Linux Postgres Authentication Error

[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).

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