Thread: md5 authentication fails

md5 authentication fails

From
"Randolph Jones"
Date:
I have pg 7.3.2 running on rh8 2.4.19.
I have pg_hba.conf with line
host testt user xxx.xxx.xxx.xxx xxx.xxx.xxx.xxx md5

I can log on as user thru psql -h xxx.xxx.xxx.xxx testt
pgsql asks for password, allows logon to testt

I have a java program using user password that gets
authentication failed for user user error

username and passwd are the same as used in psql
 on another machine the java program works ok
something is not set up right on the box that is failing

I set up the good box by trial and error, hacking/stumbling around until
something worked, then stagger on to the next debacle
no clue to what the difference might be

Any suggestions greatly appreciated

TIA
rfjones



Re: md5 authentication fails

From
Bruce Momjian
Date:
Do you perhaps have an old version of jdbc on that machine?

---------------------------------------------------------------------------

Randolph Jones wrote:
> I have pg 7.3.2 running on rh8 2.4.19.
> I have pg_hba.conf with line
> host testt user xxx.xxx.xxx.xxx xxx.xxx.xxx.xxx md5
>
> I can log on as user thru psql -h xxx.xxx.xxx.xxx testt
> pgsql asks for password, allows logon to testt
>
> I have a java program using user password that gets
> authentication failed for user user error
>
> username and passwd are the same as used in psql
>  on another machine the java program works ok
> something is not set up right on the box that is failing
>
> I set up the good box by trial and error, hacking/stumbling around until
> something worked, then stagger on to the next debacle
> no clue to what the difference might be
>
> Any suggestions greatly appreciated
>
> TIA
> rfjones
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073