Why do I get "Invalid username or password" after upgrading Postgresql?

ben-Nabiy_Derus

I am currently running Nuxeo 5.5 on a Debian 7.2 install (tomcat). I just upgraded Debian from 6.0 to 7.2, and tested the server afterwards to make sure nuxeo still worked. It did.

Then I manually installed postgresql-9.1 and postgresql-client-9.1 and did a drop of the default 9.1 main cluster, and then ran pg_upgradecluster 8.4 main and it successfully upgraded the main cluster.

When I check webmin and look at the database, everything is there. When I try to log into nuxeo, I cannot. What happened?

ben-Nabiy_Derus

It appears that the issue was with the pg_hba.conf file not being repopulated with the values from the old install. Errors were logging about pg_hba.conf not containing an entry for 127.0.0.1 for nuxeo...

Solution is to make sure that you have an entry like:

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5

and not just the default local (which applies to Unix domain socket connections only)

local all postgres ident