Linux Postgres Authentication Error

[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 Sahores <sc at sahores-conseil.com>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
>>> 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
>> 
>> --
>> Pierre Sahores
>> mobile : 06 03 95 77 70
>> www.sahores-conseil.com
>> 
>> 
>> _______________________________________________
>> 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

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.com