Hi all,
I have a postgres 9 installation and ejabberd 2.1.9 configured to connect via odbc to postgres. I can create users and check that they exist, but cannot log in with "failed authentication". I did see a ticket regarding this issue suggesting to use revision 412 of pgsql module because of some breaking change. I tried it all. Every compiled and source module for pg I could find. Fail. And guess what? As soon as I switch to mysql, everything starts to work. I did look in Postgres log and didn't find anything special except for "duplicate key" when I tried to create the same user twice (which is ok, since I double checked that connection works).
Please, I need some advice. Maybe pgsql binaries for 9.0 that 100% work?