[ppa-help] [phppgadmin - Help] RE: login failed

[SourceForge.net <no...@so...>]

Read and respond to this message at: 
https://sourceforge.net/forum/message.php?msg_id=4149526
By: xzilla

> of course I mean phpPgAdmin

:-)

> and yes i log from a different server with a different user to the
> postgresql server manually
> to be precise :
> # su - nobody
> nobody@xxx:~$ psql -h yyy -U zzz -d xxx
> Password:
> Welcome to psql, the PostgreSQL interactive terminal.

Interesting. Does it work if you set the defaultdb param in phppgadmin to xxx
?

> but phpPgAdmin fails with message no other message than 'login failed'
> and apparently it doesnt even try to connect to the postgresql server
> (nothing logged and tcpdump just told me) so I guess it's not postgres
> fault.

Your sure it's a login failed and not the super user security failure? (doesnt
sound like it, but worth verifying).  Try removing the @
in libraries/adodb/drivers/adodb-postgres64.inc.php round line 655 and see if
you can get a better error message from php.

> I know 7.2 is way too old, but that's a requirement here, and it's
> advertised to work, no ?
> if not, i will reconsider.

It's advertised to work only because I don't know of any reason why it wouldn't
work, but I don't have a 7.2 to test against (couldn't get it to run on recent
slackware). Given 7.2 is not support by the postgresql developers...

> It works with phpPgAdmin 4.0 so I guess a problem was introduced in 4.1
> I can't find where though

Hmm... the two suspicious items that jump out are the change to send encrypted
passwords and support for ssl. You might be able to dig around there and find
something, but getting a better error message from php would probably be more
helpful.


______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit: 
https://sourceforge.net/forum/unmonitor.php?forum_id=115884