Related Tips & Info
Wikis - Page

Unable to connect to the database while migrating to PostgresSQL

PascalS
1 Likes
Symptoms

I want to share my experience here.

The process to migrate from MySQL DB to PostgresSQL DB is not “extravagantly” documented.

https://www.microfocus.com/documentation/filr/filr-4/filr-inst/t43dt63eor74.html#t48yofzoyrnl

While following these instructions I directly receive “Unable to connect to the database, Check the information”.

Diagnosis

Weird points:

  • The message appears directly after clicking “ok”
  • No migration.log file created in /var/opt/novell/va/logs
Solution

I had to create an SR and this is the answer from support:

<QUOTE>

Luckily I was able to duplicate the issue in my lab.

It is a bug and I am going to report it.

 

And, hopefully, these steps will help you:

  1. Stop Filr service (as per documentation)
  2. Proceed to 9443 > Configuration > Database
  3. Choose checkbox for the migration

Here are the problems:

- do not touch username (it stays as 'filr'

- enter only DB DNS name or IP and do NOT specify port

- provide password which set for user 'filr' in Postgre DB

Now you should be ready for the data migration.

<UNQUOTE>

 

Hope this helps.

Pascal

Labels:

Support Tips/Knowledge Docs
Support Tip
Comment List
Related
Recommended

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.