[Solved] PostgreSQL connection and passwords
lazarus / 16-Databases

----------------------------------------------------------------------
dokhebi · 2012-12-12 22:12

I gave up trying to get MySQL to work so I'm using PostgreSQL
instead.  I can actually connect using the postgres user because the
password is all lower case.  When I log in with a user that has upper
case letters and special characters I get an error message with "...
password authentication failed for user ..."  I can log into the SQL
interpreter (psql) using the password without a problem.  Are the
libraries mangling the password before sending it over to the server? 
Also, I've using MD5 encryption for the passwords.  My pg_hba.conf
looks like this

Code: [Select]host     all    all   127.0.0.1/32   md5
with lines for other hosts as well.  I can log in to PgAdmin III on
the client with this user/password, but not phpPgAdmin.  I *can't* log
in with pgpPgAdmin and user postgres.

My versions: Laz 1.0.4 / FPC 2.6.0 / WinXP (client) / CentOS 6.3
(server) / PG 8.4.13

----------------------------------------------------------------------
dokhebi · 2012-12-14 19:23

It really helps to edit your code...     I found my mistake and it
wasn't an issue with a mixed case password.  I was passing the user
name to the password so of course it failed.  

In the words of Great Detective Conan, "Case Closed!"