Linux Postgres Authentication Error

[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 <bdrunrev at gmail.com> wrote:

> 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).
> 
> Is "glen" set up as a user with a password within the Postgres database?
> 
> http://www.postgresql.org/docs/8.2/static/auth-methods.html#AUTH-PASSWORD
> 
> Hope that is of some help.
> 
> Bernard
> 
> On Sun, May 27, 2012 at 3:06 PM, Glen Bojsza <gbojsza at gmail.com> wrote:
>> 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  DATABASE        USER            ADDRESS                 METHOD
>> host             all                  glen           0.0.0.0/0
>>      md5
>> 
>> I know that I am talking to postgres (if I change md5 to trust I can
>> login... but this allows anyone to as well)
>> 
>> The error I get is FATAL:  password authentication failed for user "glen"
>> 
>> In the standalone settings I have:
>> 
>> Script libraries
>> 
>>   - database
>>   - internet
>>   - ssl / encryption
>> 
>> 
>> Checked : Database support
>> 
>>   - postgreSQL
>> 
>> 
>> Any ideas why it is failing?
>> 
>> thanks,
>> 
>> Glen
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode