Yes. All the basic checks I have done. I upgraded from CENTOs 6.4 to 6.5. Another interesting thing - if I su - postgres and then try, it works. So it has something to do with the chrt user (root) settings.
On Fri, Jan 3, 2014 at 5:36 PM, dinesh kumar <dineshkuma...@gmail.com>wrote: > > On Fri, Jan 3, 2014 at 5:13 PM, Jayadevan M > <maymala.jayade...@gmail.com>wrote: > >> I am able to login from the non-chroot environment. So it is not an issue >> with pg_hba.conf and not an issue of password expiration. Is there a debug >> psql option? >> >> OK. > > Have you checked the PGPASSWORD environment variable, from where you are > trying to login. > > Regards, > Dinesh > manojadinesh.blogspot.com > > >> >> >> On Fri, Jan 3, 2014 at 5:09 PM, Chris Curvey <ch...@chriscurvey.com>wrote: >> >>> >>> >>> >>> On Fri, Jan 3, 2014 at 4:16 AM, Jayadevan M <maymala.jayade...@gmail.com >>> > wrote: >>> >>>> Hi, >>>> I am trying to login from psql and consistently getting a >>>> "psql: FATAL: password authentication failed for user "xyz"" for all >>>> users. I am not being prompted for a password at all. I faced a similar >>>> issue sometime ago because there was a .pgpass file and it had wrong >>>> entries. This time there is no .pgpass file. >>>> Any clues? How do I trouble-shoot? >>>> Other possibly relevant info - this is a chrooted environment. I >>>> upgraded the OS recently in this env and faced some issues with /dev/null >>>> /proc etc not being present and so on. Some issues there? >>>> The database itself is running in the same server in the non-chroot >>>> environment. I am also running a python application which uses psycopg2 and >>>> that is working fine. >>>> Regards, >>>> Jayadevan >>>> >>> >>> Could it be a problem with your pg_hba.conf? Perhaps password >>> authentication is not enabled there? >>> >>> >>> >>> -- >>> I asked the Internet how to train my cat, and the Internet told me to >>> get a dog. >>> >> >> >
