Skip to main content
Question

Some characters in the password for FME Server Database seems to make installation unusable.

  • May 5, 2023
  • 1 reply
  • 32 views

Forum|alt.badge.img

When installing FME Server 2022.2.5 b22795, i used the character '¤' in the PostgreSQL database password. The password was accepted and the installation finished without warnings or errors.

Then, none of the FME Services would start. When looking for the configuration files, I noticed that server.xml was missing. I copied it from another installation wich made the FME Server Application Server start. The FME Server database service would not start still.

 

After some troubleshooting, I decided to reinstall. When asked again for the password, for some reason, I used another password without the '¤' sign. After the installation, all services started up and the server.xml file was where it's supposed to be.

 

I have repeated the procedure on a different machine with the same result.

 

My guess is that the '¤' sign is approved by the FME installation program but not accepted by the database. I don't understand why the server.xml file was missing though.

For english/american users, this might be an odd symbol but on a swedish QWERTY keyboard layout it replaces the $ sign on Shift + 4, so it's easy to access and accepted in passwords in other systems.

If this is the case I think the installation program should not silently accept characters that PostgreeSQL will not.

1 reply

david_r
Celebrity
  • May 5, 2023

It might be an encoding issue between the installer, configuration files and the way the different components connect to the database.

For this reason I sometimes end up using only regular ASCII characters (decimal 33-126) for passwords, but compensate with password length.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings