I'm trying to get asterisk cdr_odbc configured, but it can't connect through my odbc driver. switchboard*CLI> module load cdr_odbc [May 4 20:06:04] ERROR[17758]: cdr_odbc.c:358 odbc_load_module: cdr_odbc: Unable to connect to datasource: asterisk /etc/odbcinst.ini: [MySQL] Description = MySQL driver Driver = /usr/lib/odbc/libmyodbc.so Setup = /usr/lib/odbc/libodbcmyS.so /etc/odbc.ini: [asterisk] Description = asterisk ODBC Driver = MySQL Socket = /var/run/mysqld/mysqld.sock Server = localhost User = asterisk Password = mysql_password Database = asterisk Option = 3 #Port Trace = On TraceFile = /var/log/odbc-asterisk /etc/asterisk/res_odbc.conf: [asterisk] enabled => yes dsn => asterisk username => asterisk password => exodus_2009 pre-connect => yes /etc/asterisk/cdr_odbc.conf: ; cdr_odbc.conf ; [global] dsn=asterisk username=asterisk password=exodus_2009 loguniqueid=yes dispositionstring=yes table=cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT ---------------------------------------------------------------------------------------------------------- Any ideas?
On Monday 04 May 2009 20:12:19 Atlanticnynex wrote:> I'm trying to get asterisk cdr_odbc configured, but it can't connect > through my odbc driver. > > switchboard*CLI> module load cdr_odbc > [May 4 20:06:04] ERROR[17758]: cdr_odbc.c:358 odbc_load_module: > cdr_odbc: Unable to connect to datasource: asterisk > > /etc/odbcinst.ini: > > [MySQL] > Description = MySQL driver > Driver = /usr/lib/odbc/libmyodbc.so > Setup = /usr/lib/odbc/libodbcmyS.so > > > /etc/odbc.ini: > > [asterisk] > Description = asterisk ODBC > Driver = MySQL > Socket = /var/run/mysqld/mysqld.sock > Server = localhost > User = asterisk > Password = mysql_password > Database = asterisk > Option = 3 > #Port > Trace = On > TraceFile = /var/log/odbc-asterisk > > > > /etc/asterisk/res_odbc.conf: > > [asterisk] > enabled => yes > dsn => asterisk > username => asterisk > password => exodus_2009 > pre-connect => yes > > > /etc/asterisk/cdr_odbc.conf: > ; cdr_odbc.conf > ; > [global] > dsn=asterisk > username=asterisk > password=exodus_2009 > loguniqueid=yes > dispositionstring=yes > table=cdr ;"cdr" is default table name > usegmtime=no ; set to "yes" to log in GMT > > > --------------------------------------------------------------------------- >------------------------------- > > Any ideas?The password you have in odbc.ini does not match the password in res_odbc.conf. -- Tilghman