I cant login into postgresql from php scripts. I have no problem using postgres tieh the webmin module. I can even open a ssh session with user alcnoticias, password alcnoticias, and then I can login with psql -d alc_database, but I cant be validated when accesing psql with the same postgres database, user and password, if i have initiated the ssh session with other user than alcnoticias.
I cant also connect to the database from phpPgAdmin (“Authentication failed”), or from my own phpscripts using ADOdb (“Database connection failed”).
Any help would be very welcomed. The main trace here is why I can login to psql with database alc_database after initiating the ssh session from user alcnoticias, password alcnoticias, but cant do the same with other linux user but with the same postgresql user and password