Re: Linux Postgres Authentication Error

2012-05-27 Thread Bernard Devlin
If you check the pg_authid table, do you find the same password (hashed or unhashed) as you are sending? Bernard On Sun, May 27, 2012 at 3:50 PM, Glen Bojsza wrote: > Hi Bernard, > > Yes, I tried with and without using md5digest on the password. And glen is > setup as a user with a password. >

Re: Linux Postgres Authentication Error

2012-05-27 Thread Pierre Sahores
Best to connect your client app to a cgi and the cgi to postgresql, so you don't have to open a pg access to the outside world... Le 27 mai 2012 à 16:47, Glen Bojsza a écrit : > Currently it is a local network... later it will be remote networks. > > On Sun, May 27, 2012 at 10:34 AM, Pierre Sah

Re: Linux Postgres Authentication Error

2012-05-27 Thread Glen Bojsza
Currently it is a local network... later it will be remote networks. On Sun, May 27, 2012 at 10:34 AM, Pierre Sahores wrote: > Local network ? > > Le 27 mai 2012 à 16:06, Glen Bojsza a écrit : > > > Hello, > > > > I have a stack that needs to connect over a network to a postgres > database > > r

Re: Linux Postgres Authentication Error

2012-05-27 Thread Glen Bojsza
Hi Bernard, Yes, I tried with and without using md5digest on the password. And glen is setup as a user with a password. Glen On May 27, 2012, at 10:30 AM, Bernard Devlin wrote: > I never hook up Postgres so that the service talks to the outside > world, so this is just a guess. > > Did you f

Re: Linux Postgres Authentication Error

2012-05-27 Thread Pierre Sahores
Local network ? Le 27 mai 2012 à 16:06, Glen Bojsza a écrit : > Hello, > > I have a stack that needs to connect over a network to a postgres database > running on Linux where the pg_hba.conf file is configured as follows > > # TYPE DATABASEUSERADDRESS METHOD

Re: Linux Postgres Authentication Error

2012-05-27 Thread Bernard Devlin
I never hook up Postgres so that the service talks to the outside world, so this is just a guess. Did you format your submitted password using md5digest() when you changed from "trust" to "md5"? (You at least know you are talking to Postgres (the FATAL: response looks like a Postgres response).

Linux Postgres Authentication Error

2012-05-27 Thread Glen Bojsza
Hello, I have a stack that needs to connect over a network to a postgres database running on Linux where the pg_hba.conf file is configured as follows # TYPE DATABASEUSERADDRESS METHOD host all glen 0.0.0.0/0 md5 I