|
Versions
unixODBC 2.2.11 installed by source code asterisk 1.2.2 recompiled with the CFLAGS options enabled just as mentioned in the wiki:
http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage
I’m pooling all the configuration from realtime/MySQL and everything works perfectly, I’ve checked the connectivity by ODBC with isql utility ant the connection is up and running!
But when I issue the “odbc show” command the asterisk crashes and restarts automatically
lab*CLI> odbc show Name: asterisk DSN: asterisk Connected: no
Feb 16 14:07:35 WARNING[22165]: res_odbc.c:238 odbc_sanity_check: Connection is down attempting to reconnect... Feb 16 14:07:35 WARNING[22165]: res_odbc.c:497 odbc_obj_disconnect: res_odbc: asterisk [asterisk] already disconnected Feb 16 14:07:35 NOTICE[22165]: res_odbc.c:552 odbc_obj_connect: Connecting asterisk Feb 16 14:07:35 WARNING[22165]: res_odbc.c:563 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not found, and no default driver specified
And the configuration is not even shown
Here you can see my configuration files
res_odbc.conf
[asterisk] dsn => asterisk ;username => myuser ;password => mypass ;pre-connect => yes
[mysqlvm] dsn => MySQL-asterisk username => username password => password ;pre-connect => yes
/usr/local/etc/odbc.ini
[MySQL-asterisk] Description = MySQL ODBC Driver Testing Driver = MySQL Socket = /var/lib/mysql/mysql.sock Server = pbx.1234.com User = username Password = password Database = database Option = 3 Port = 3306
/usr/local/etc/odbcinst.ini
# Example driver definitinions # #
# Included in the unixODBC package #[PostgreSQL] #Description = ODBC for PostgreSQL #Driver = /usr/lib/libodbcpsql.so #Setup = /usr/lib/libodbcpsqlS.so #FileUsage = 1
# Driver from the MyODBC package # Setup from the unixODBC package [MySQL] Description = ODBC for MySQL Driver = /usr/lib/libmyodbc.so Setup = /usr/local/lib/libodbcmyS.so FileUsage = 1
Any clue what I’m missing ????? As I said, testing the connectivity by ODBC works just fine…. It seems only a problem with asterisk, not being able to make identify that thers a ODBC connection active!!
Thanks in advance!!! |
_______________________________________________ --Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
