ERROR "psql: FATAL: password authentication failed for user "datasync_user"" while running update.sh for Mobility Pack 1.2

  • 7009062
  • 27-Jul-2011
  • 10-Dec-2013

Environment

Product:
Novell Data Synchronizer Mobility Pack 1.2

Configuration:
datasync_user password contains special character like $ or &

Situation

update.sh fails with ERROR: "psql: FATAL:  password authentication failed for user "datasync_user""
update.sh gives error while updating the database

Resolution

This happens only and only if the password for datasync_user contains special characters like & or $
Please follow the steps listed below to manually update the database
  1. Open a terminal window for the Datasync Server.
  2. Type "psql -U datasync_user mobility ".
  3. Enter password for the database. If the database password is not known, please check /etc/datasync/configengine/configengine.xml file as the password is stored in plaintext in the following format
    <db>datasync</db>
    <username>datasync_user</username>
    <password>novell$a</password>
  4. Type "ALTER TABLE DeviceImages ALTER COLUMN extReferenceMap TYPE varchar(300); " without quotes and press Enter. Make sure to put a semi-colon (;) at the end and press Enter.
  5. Type "ALTER TABLE DeviceEvents ALTER COLUMN extReferenceMap TYPE varchar(300);" without quotes and press Enter. Make sure to put a semi-colon (;) at the end and press Enter.
  6. Type "ALTER TABLE GAL ALTER COLUMN mobilePhone TYPE VARCHAR(256);" without quotes and press Enter. Make sure to put a semi-colon (;) at the end and press Enter.
  7. Type "ALTER TABLE GAL ALTER COLUMN homePhone TYPE VARCHAR(256); " without quotes and press Enter. Make sure to put a semi-colon (;) at the end and press Enter.
  8. Type "ALTER TABLE GAL ALTER COLUMN phone TYPE VARCHAR(256); " without quotes and press Enter. Make sure to put a semi-colon (;) at the end and press Enter.
  9. Type "\q " without quotes and press Enter to quit.
  10. Type rcdatasync stop and press Enter.
  11. Type rcpostgresql restart and press Enter.
  12. Type rcdatasync start and press Enter.

Status

Reported to Engineering

Additional Information

Notes:
Message

 /opt/novell/datasync/update.sh
Welcome to the Novell Data Synchronizer Update!

Are you sure you want to update Novell Data Synchronizer Mobility Pack? (yes/no):yes

psql: FATAL:  password authentication failed for user "datasync_user"
psql: FATAL:  password authentication failed for user "datasync_user"
psql: FATAL:  password authentication failed for user "datasync_user"
Updating database schema.....
Schema change: "ALTER TABLE DeviceImages ALTER COLUMN extReferenceMap TYPE varchar(300);"
Schema change: "ALTER TABLE DeviceEvents ALTER COLUMN extReferenceMap TYPE varchar(300);"
Schema change: "ALTER TABLE GAL ALTER COLUMN mobilePhone TYPE VARCHAR(256);"
Schema change: "ALTER TABLE GAL ALTER COLUMN homePhone TYPE VARCHAR(256);"
Schema change: "ALTER TABLE GAL ALTER COLUMN phone TYPE VARCHAR(256);"
Database schema is updated.
System is updated. Please see the log file /var/log/datasync/update.log for detail changes
Please restart mobility services:
1) rcdatasync stop
2) rcpostgresql restart
3) rcdatasync start