Roundup Tracker - Issues

Issue 1772174

classification
Passwordless authentification with PostgreSQL impossible
Type: Severity: normal
Components: Database Versions:
process
Status: closed works for me
:
: jpend : jpend, leonidasxiv
Priority: normal :

Created on 2007-08-11 10:40 by leonidasxiv, last changed 2007-08-30 00:39 by jpend.

Messages
msg2466 Author: [hidden] (leonidasxiv) Date: 2007-08-11 10:40
In the PostgreSQL world it is common not to use passwords for authentification as MySQL does but to 

I tried running ``roundup-admin initialise`` as user ``django`` and leaving the password of my tracker empty (``password = ``). Then I get this exception:

roundup.hyperdb.DatabaseError: FATAL:  password authentication failed for user "django"

Next thing I tried was another syntax in the INI file: ``password = ''``. The exception I get is the following:

raise hyperdb.DatabaseError, message
roundup.hyperdb.DatabaseError: fe_sendauth: no password supplied

So it looks like it got it that I want to use *no* password, but it doesn't let me.
msg2467 Author: [hidden] (jpend) Date: 2007-08-28 04:25
I'm far from a postgres expert but I think this handled on postgres' end of things.

When my pg_hba.conf just had the line:
host    all         all         127.0.0.1/32          md5

Then I got the same exception you mention. If you add:
host    all         roundup     127.0.0.1/32          trust

(where roundup is whatever username you're using for the roundup user) then it should work.

I just tested it on my postgres 8.2/psycopg 2.0.5.1 and it worked.
msg2468 Author: [hidden] (jpend) Date: 2007-08-30 00:39
Closing as "Works for Me" based on my previous comment.

If we get a report with some more details about the postgres side that contradict my admittedly limited knowledge of postgres I'd be happy to look at it in more detail.
History
Date User Action Args
2007-08-11 10:40:27leonidasxivcreate