Re: [Condor-users] Quill configuration issues

["Ian Chesal" <ICHESAL@xxxxxxxxxx>]

> I'm having issues configuring quill.
> Postgres is running on the machine and I can connect as "quillwriter"
> using psql,
> but quill process keeps saying that cannot connect to the db.
> These are quill logs.
> 
> ------------------------------
> 7/30 12:33:29 ++++++++ Sending schedd ad to collector ++++++++
> 7/30 12:33:29 ++++++++ Sent schedd ad to collector ++++++++
> 7/30 12:33:39 ******** Start of Probing Job Queue Log File ********
> 7/30 12:33:39 Connection to database 'control1' failed.
> 7/30 12:33:39 FATAL:  password authentication failed for user
> "quillwriter"
> 7/30 12:33:39 Deallocating connection resources to database 'control1'
> 7/30 12:33:39 Connection to database 'control1' failed.
> 7/30 12:33:39 FATAL:  password authentication failed for user
> "quillwriter"
> 7/30 12:33:39 Deallocating connection resources to database 'control1'
> 7/30 12:33:39 Error: Unable to connect to db "control1"
> 7/30 12:33:39 Connection to database 'template1' failed.
> 7/30 12:33:39 FATAL:  password authentication failed for user
> "quillwriter"
> 7/30 12:33:39 Deallocating connection resources to database
'template1'
> 7/30 12:33:39 Error: Failed while trying to create database control1.
> 7/30 12:33:39 >>>>>>>> Fail: Probing Job Queue Log File <<<<<<<<
> 7/30 12:33:39 ++++++++ Sending schedd ad to collector ++++++++
> 7/30 12:33:39 ++++++++ Sent schedd ad to collector ++++++++
> ----------------------------------
> 
> I created successfully the control1 db manually using quillwriter as
user.

Check your pg_hba.conf file and make sure the accounts have access to
the database from the appropriate IP addresses in your subnet. You need
lines like this:

host    all       quillreader       157.0.0.0       255.0.0.0
password
host    all       quillwriter       157.0.0.0       255.0.0.0
password

Where the fourth and fifth entries limit access by your subnet IP. For
more information on pg_hba.conf see:

http://www.postgresql.org/docs/7.3/static/client-authentication.html#AUT
H-PG-HBA-CONF

By default postgres lets you access the machine using any account from
127.0.0.1/32 (the localhost IP address) which is probably why you can
connect manually as quillwriter but the Quill daemon can't connect (even
if it's running on the same machine it's probably not trying to access
postgres over localhost but instead using the hostname).

Let me know if that doesn't help you out.

- Ian