<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
<br>Hi,<br><br>I have a problem trying to get mod_nibblebill to work.&nbsp; I have thought I had done everything to get it to work but obviously not:<br><br>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<br><br>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)!<br><br>Do I need to update more than just the nibblebill conf file? <br><br>Any help is much appreciated<br><br>CHeers<br><br>Raf<br><br><br>My /etc/odbc.ini file:<br><br>[FreeSWITCH]<br>Driver&nbsp;&nbsp; = MySQL<br>SERVER&nbsp;&nbsp; = localhost<br>PORT&nbsp;&nbsp;&nbsp;&nbsp; = 3306<br>DATABASE = FreeSWITCH<br>OPTION&nbsp; = 67108864<br>Socket&nbsp;&nbsp; = /var/lib/mysql/mysql.sock<br><br>My /etc/odbcinst.ini file:<br><br># Example driver definitinions<br>#<br>#<br># Included in the unixODBC package<br>#[PostgreSQL]<br>#Description&nbsp;&nbsp;&nbsp; = ODBC for PostgreSQL<br>#Driver&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = /usr/lib/libodbcpsql.so<br>#Setup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = /usr/lib/libodbcpsqlS.so<br>#FileUsage&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 1<br><br># Driver from the MyODBC package<br># Setup from the unixODBC package<br>[MySQL]<br>Description&nbsp;&nbsp;&nbsp;&nbsp; = ODBC for MySQL<br>Driver&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = /usr/lib64/libmyodbc3.so<br>Setup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = /usr/lib64/libodbcmyS.so<br>FileUsage&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 1<br><br>Snippet of my nibblebill.conf.xml file:<br><br>&lt;!-- Information for connecting to your database --&gt;<br>&lt;param name="db_username" value="rafqat"/&gt;<br>&lt;param name="db_password" value="?????"/&gt;<br>&lt;param name="db_dsn" value="FreeSWITCH"/&gt;<br><br><br>I have even setup the following links:<br><pre>mkdir /usr/local/freeswitch/etc<br>ln -s /etc/odbcinst.ini /usr/local/freeswitch/etc/odbcinst.ini<br>ln -s /etc/odbc.ini /usr/local/freeswitch/etc/odbc.ini<br><br>I can connect successfully using isql:<br><br>isql FreeSWITCH rafqat ??????<br><br></pre><br><br><br><br><br><br>                                               </body>
</html>