Search Postgresql Archives

Re: authentication failure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <dineshkumar02@xxxxxxxxx> wrote:

On Fri, Jan 3, 2014 at 5:13 PM, Jayadevan M <maymala.jayadevan@xxxxxxxxx> 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



On Fri, Jan 3, 2014 at 5:09 PM, Chris Curvey <chris@xxxxxxxxxxxxxxx> wrote:



On Fri, Jan 3, 2014 at 4:16 AM, Jayadevan M <maymala.jayadevan@xxxxxxxxx> 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.




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux