Problem in Ejabberd integration with Oracle database

Hello All,

I need to integrate ejabberd with Oracle database(don't want to use Mnesia default database). I searched all the ejabberd forums but couldn't find any help.

Can some body help me in integration of ejabberd server with Oracle database.

I enabled the below parameters in "ejabberd.yml" file:

auth_method: odbc
odbc_type: odbc
odbc_server: "DSN=dbname@//dbipaddr:port/SID;UID=dbuser;PWD=dbuserpassword"

I'm getting an error like below:

ejabberd_odbc:handle_info:323 unexpected info in connecting
ejabberd_odbc: connecting: 242 odbc connection failed.
Reason: connection_closed
Retry after: 30 seconds

i am successfully able to connect ejabberd with Mysql & Postgres databases, but not able to connect with Oracle.

Whether DSN is wrong?
Whether i need to install any ODBC driver into ejabberd explicitly? I'm using ejabberd version 15.

Syndicate content