I've made it work with Mysql.
But with PostgreSQL I can't login and/or register the user.
Registering with Gaim, it give me this error: "409: Conflict". Login it's impossible, even if I put the user directly in the database.
I've already compiled jungerl pgsql driver, also tried with pgsql driver from REPOS.
I don't know what to do. Using mysql and/or internal auth it's working, but I need it to work with PostgreSQL.
Thanks in advance.
Nicholas.
:)
PGSQL
Hello, you need to provide more information.
How is your configuration file, what are the version used, what do you find in the log files ?
--
Mickaël Rémond
Sorry. I'm on a Debian
Sorry.
I'm on a Debian Linux. Yes, there's a open Postgre connection (8.1 version).
Ejabberd is the latest one. On logs there is nothing about db access.
The conf file relative to the db:
{auth_method, odbc}.
{odbc_server, {pgsql, "localhost","ejabberd","ejabberd","ejabberd"}}.
PS: If i simple change pgsql to mysql (Yes, have a mysql here too) it works!.
i hv one running on debian etch
Sorry.
I'm on a Debian Linux. Yes, there's a open Postgre connection (8.1 version).
Ejabberd is the latest one. On logs there is nothing about db access.
The conf file relative to the db:
{auth_method, odbc}.
{odbc_server, {pgsql, "localhost","ejabberd","ejabberd","ejabberd"}}.
PS: If i simple change pgsql to mysql (Yes, have a mysql here too) it works!.
i have one ejabberd running on debian etch with postgresql run 3 virtual host and i didnt get any problem :D
check your pg_hba is allow to make connection ?
set your postgresql to log all statement/client connection then check on your postgresql log.
what OS ?if
what is your server ?
if linux you can check on resources whether there is open connection to postgresql service. this can be done with execute command 'ps ax'.