[Freeswitch-users] mod_nibblebill ODBC issue

[Rafqat .]

Hi,

I have a problem trying to get mod_nibblebill to work.  I have thought I had done everything to get it to work but obviously not:

2010-12-12 18:01:24.112241 [ERR] switch_odbc.c:313 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

2010-12-12 18:01:24.112413 [CRIT] mod_nibblebill.c:223 Cannot connect to ODBC driver/database bandwidth.com (user: bandwidth.com / pass password)!

Do I need to update more than just the nibblebill conf file? 

Any help is much appreciated

CHeers

Raf


My /etc/odbc.ini file:

[FreeSWITCH]
Driver   = MySQL
SERVER   = localhost
PORT     = 3306
DATABASE = FreeSWITCH
OPTION  = 67108864
Socket   = /var/lib/mysql/mysql.sock

My /etc/odbcinst.ini file:

# 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/lib64/libmyodbc3.so
Setup            = /usr/lib64/libodbcmyS.so
FileUsage      = 1

Snippet of my nibblebill.conf.xml file:

<!-- Information for connecting to your database -->
<param name="db_username" value="rafqat"/>
<param name="db_password" value="?????"/>
<param name="db_dsn" value="FreeSWITCH"/>


I have even setup the following links:
mkdir /usr/local/freeswitch/etc
ln -s /etc/odbcinst.ini /usr/local/freeswitch/etc/odbcinst.ini
ln -s /etc/odbc.ini /usr/local/freeswitch/etc/odbc.ini

I can connect successfully using isql:

isql FreeSWITCH rafqat ??????







 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20101212/b766c8e6/attachment.html