S
S
Steely2014-08-06 12:17:39
PostgreSQL
Steely, 2014-08-06 12:17:39

Postgresql - why can't I log in as new users?

I use phppgadmin - the connection to the database through the old user works, I create a new user with a password and I can not log in with it.
I look at the pgbounce.log file:

(nodb)/(nouser)@unix:5432 closing because: No such user: newuser (age=0)
(nodb)/(nouser)@unix:5432 Pooler Error: No such user: newuser
(nodb)/(nouser)@unix:5432 login failed: db=template1 user=newuser

But there is such a user in the database, I see him if I log in through olduser.
I make a request "select * from pg_shadow;" and see my newuser with the same settings as olduser. Created several users - all the same. I also created a user through the "createuser ..." console - the same thing.
The rules in pg_hba.conf are:
local   all             postgres                                ident
local   all         all                               trust
host    all         all         127.0.0.1/32          trust
host    all         all         ::1/128               md5

In theory, I even have to log in with any password - what could it be?
postgresql version 8.4

Answer the question

In order to leave comments, you need to log in

1 answer(s)
@
@estatic, 2014-08-07
_

I may be wrong, but try changing the postge config from trust to md5 (there is also a password, it seems).
And if you connect yourself, does it connect?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question