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.