Why do I get "Invalid username or password" after upgrading Postgresql?
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?
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