I'm trying to use ODBC for my ejabberd database. I have configured a user/password combination of ejabberd/ejabberd. When using the test tool isql, I can connect
[zach@centora logs]$ isql -v OracleODBC-11g ejabberd ejabberd
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
I have ejabberd configured like:
%% {auth_method, internal}.
{auth_method, odbc}.
{odbc_server, "DSN=OracleODBC-11g;DATABASE=system;UID=ejabberd;PWD=ejabberd"}.
However, when I try to connect to ejabberd, I get
=INFO REPORT==== 13-Jan-2012::16:22:27 ===
I(<0.42.0>:ejabberd_app:72) : ejabberd 2.1.7 is started in the node ejabberd@localhost
=INFO REPORT==== 13-Jan-2012::16:22:27 ===
I(<0.291.0>:ejabberd_odbc:216) : odbc connection failed:
** Reason: "No SQL-driver information available. Connection to database failed."
** Retry after: 30 seconds
I see that there is an odbc.ini file under the ejabberd
ejabberd-2.1.8/conf/odbc.ini and I added my configuration as
[OracleODBC-11g]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
BindAsFLOAT = F
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = Oracle 11g ODBC driver
DSN = OracleODBC-11g
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MaxLargeData = 0
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
ServerName = SYSTEM
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
DisableRULEHint = T
UserID =
StatementCache=F
CacheBufferSize=20
UseOCIDescribeAny=FThese values are the default values in my /etc/odbc.ini file. I also configured the odbcinst.ini file under the conf directory with the default values:
[OracleODBC-11g]
Description = Oracle ODBC driver for Oracle 11g
Driver = /usr/lib/oracle/11.2/client/lib/libsqora.so.11.1
Setup =
FileUsage =
CPTimeout =
CPReuse =I have followed the steps at to the best of my knowledge, but I just cant get it to work. Anyone have any recommendations?
Hello everyone, i know that
Hello everyone, i know that this post is really old, but after many researches and nothing really complet about this problem, i am facing the same, i can access my database using isql, but from Ejabberd, i only get the message that DNS and Driver dont exist