Andrew Gold agold
Mon Aug 8 18:45:40 PDT 2005
Hi everyone,

I'm having connection problems when I try to run slon on my master
database. The master was configured with the following connection lines:

        node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST
port=$MASTERPORT user=$MASTERDBA password=mypass';
        node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST
port=$SLAVEPORT user=$SLAVEDBA password=mypass';

I invoke slon with the following confg value:
    conn_info='dbname=$MASTERDBNAME user=$MASTERDBA password=mypass
host=$MASTERHOST port=$MASTERPORT'

I read in my slon logs:

2005-08-05 14:19:27 EDT WARN   remoteListenThread_2: DB connection
failed - sleep 10 seconds
2005-08-05 14:19:29 EDT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 42
2005-08-05 14:19:29 EDT DEBUG2 localListenThread: Received event 1,42 SYNC
2005-08-05 14:19:37 EDT ERROR  slon_connectdb:
PQconnectdb("dbname=$SLAVEDBNAME host=$SLAVEHOST port=$SLAVEPORT
user=$SLAVEDBA ") failed - fe_sendauth: no password supplied

It appears that I'm failing to submit a password, but that seems totally
contrary to my configuration values.
I'm sure that I'm missing something simple here; any suggestions are
greatly welcome.

Thanks,

Andrew Gold







More information about the Slony1-general mailing list