Environment
Novell Data Synchronizer Mobility Pack
Situation
/var/log/datasync/syncengine/engine.log running diagnostic/verbose shows the following error:
psql: FATAL: password authentication failed for user "datasync_user"
psql: FATAL: password authentication failed for user "datasync_user"
Resolution
Verify database passwords are correct:
From a terminal window:
edit /etc/datasync/configengine/engines/default/pipelines/pipeline1/connectors/mobility/connector.xml
Find the database section and verify the password:
<dbhost>localhost</dbhost>
<dbtype>postgresql</dbtype>
<dbname>mobility</dbname>
<dbuser>datasync_user</dbuser>
<dbport>5432</dbport>
<dbpass>password</dbpass>
From a terminal window: edit /etc/datasync/configengine/configengine.xml
Find the database section, and verify the password:
<database>
<hostname>localhost</hostname>
<port>5432</port>
<type>postgresql</type>
<db>datasync</db>
<username>datasync_user</username>
<password>datasync</password>
</database>
From a terminal window:
edit /etc/datasync/configengine/engines/default/pipelines/pipeline1/connectors/mobility/connector.xml
Find the database section and verify the password:
<dbhost>localhost</dbhost>
<dbtype>postgresql</dbtype>
<dbname>mobility</dbname>
<dbuser>datasync_user</dbuser>
<dbport>5432</dbport>
<dbpass>password</dbpass>
From a terminal window: edit /etc/datasync/configengine/configengine.xml
Find the database section, and verify the password:
<database>
<hostname>localhost</hostname>
<port>5432</port>
<type>postgresql</type>
<db>datasync</db>
<username>datasync_user</username>
<password>datasync</password>
</database>
Configure postgresql:
-
From a terminal window: edit /var/lib/pgsql/data/pg_hba.conf and append the following:local all postgres ident rootaspg
local all all ident sameuser
host all all 127.0.0.1/32 md5
host all all ::1/128 md5 -
Edit /var/lib/pgsql/data/pg_ident.conf and append the following:rootaspg root postgres
rootaspg root datasync_user
rootaspg postgres postgres - From a terminal window: type rcpostgresql restart and press Enter.
- From a terminal window: type sudo -u postgres psql postgres and press Enter.
- Type ALTER User datasync_user PASSWORD '<password from above>';
- Type \q and press Enter.
- Restart DataSync services. Type rcdatasync restart and press Enter.
- Remove what was appended from steps 1 and 2.
- Type rcpostgresql restart and press Enter.