<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
<br>Which variables do I need to set?<br><br>I am suprised to see the following line in my error output:<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>I looked at the mod_nibblebill.c source code to see when the values for the variables used in this error message get set. They should be getting set from the values in the nibblebill config file, so I have no idea how 'bandwidth.com' gets to be in the variable globals.db_dsn.<br><br>All seems very odd.<br><br>Please help.<br><br>Cheers<br><br>Raf<br><br><hr id="stopSpelling">From: infos@madovsky.org<br>To: freeswitch-users@lists.freeswitch.org<br>Date: Sun, 12 Dec 2010 15:50:20 -0500<br>Subject: Re: [Freeswitch-users] mod_nibblebill ODBC issue<br><br>
<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<meta name="Generator" content="Microsoft SafeHTML">
<style>
.ExternalClass .ecxhmmessage P
{padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;}
.ExternalClass BODY.ecxhmmessage
{font-family:Tahoma;font-size:10pt;}
</style>
<div><font face="Arial">Mabe your system env variables are not set.</font></div>
<div><font face="Arial">it looks like odbc can't find the path...</font></div>
<blockquote style="border-left: 2px solid rgb(0, 0, 0); padding-left: 5px; padding-right: 0px; margin-left: 5px; margin-right: 0px;">
<div style="font: 10pt arial;">----- Original Message ----- </div>
<div style="font: 10pt arial; background: none repeat scroll 0% 0% rgb(228, 228, 228);"><b>From:</b>
<a title="rafonline@hotmail.com" href="mailto:rafonline@hotmail.com">Rafqat
.</a> </div>
<div style="font: 10pt arial;"><b>To:</b> <a title="freeswitch-users@lists.freeswitch.org" href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</a>
</div>
<div style="font: 10pt arial;"><b>Sent:</b> Sunday, December 12, 2010 3:36
PM</div>
<div style="font: 10pt arial;"><b>Subject:</b> Re: [Freeswitch-users]
mod_nibblebill ODBC issue</div>
<div><br></div>I only updated the nibblebill config file with the following:
<br><pre><!-- Information for connecting to your database --><br><param name="db_username" value="rafqat"/><br><param name="db_password" value="?????"/><br><param name="db_dsn" value="FreeSWITCH"/><br><br>I did not change any of the dsn related stuff in any of the other FreeSWITCH config files.<br><br>I dont see why I should be changing other freeswitch config files, can't one use a different database for the billing side of things? It seems odd to allow dsn config to be added to the nibblebill conf file but not actually get used?<br><br>or am i missing the point?<br><br>Cheers<br><br>Raf<br></pre><br><br>
<hr id="ecxstopSpelling">
From: infos@madovsky.org<br>To: freeswitch-users@lists.freeswitch.org<br>Date:
Sun, 12 Dec 2010 15:27:39 -0500<br>Subject: Re: [Freeswitch-users]
mod_nibblebill ODBC issue<br><br>
<style>
.ExternalClass .ecxhmmessage P
{padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;}
.ExternalClass BODY.ecxhmmessage
{font-family:Tahoma;font-size:10pt;}
</style>
<div><font face="Arial">what did you write on every</font></div>
<div><font face="Arial">db_dsn in Freeswitch config ?</font></div>
<blockquote style="border-left: 2px solid rgb(0, 0, 0); padding-left: 5px; padding-right: 0px; margin-left: 5px; margin-right: 0px;">
<div style="font: 10pt arial;">----- Original Message ----- </div>
<div style="font: 10pt arial; background: none repeat scroll 0% 0% rgb(228, 228, 228);"><b>From:</b> <a title="rafonline@hotmail.com" href="mailto:rafonline@hotmail.com">Rafqat .</a>
</div>
<div style="font: 10pt arial;"><b>To:</b> <a title="freeswitch-users@lists.freeswitch.org" href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</a>
</div>
<div style="font: 10pt arial;"><b>Sent:</b> Sunday, December 12, 2010 3:19
PM</div>
<div style="font: 10pt arial;"><b>Subject:</b> Re: [Freeswitch-users]
mod_nibblebill ODBC issue</div>
<div><br></div><br>More than what I have already specified?<br><br>My
/etc/odbc.ini file:<br><br>[FreeSWITCH]<br>Driver =
MySQL<br>SERVER = localhost<br>PORT =
3306<br>DATABASE = FreeSWITCH<br>OPTION =
67108864<br>Socket = /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 = ODBC for
PostgreSQL<br>#Driver =
/usr/lib/libodbcpsql.so<br>#Setup
= /usr/lib/libodbcpsqlS.so<br>#FileUsage =
1<br><br># Driver from the MyODBC package<br># Setup from the unixODBC
package<br>[MySQL]<br>Description = ODBC for
MySQL<br>Driver
=
/usr/lib64/libmyodbc3.so<br>Setup
= /usr/lib64/libodbcmyS.so<br>FileUsage =
1<br><br>
<hr id="ecxstopSpelling">
From: infos@madovsky.org<br>To:
freeswitch-users@lists.freeswitch.org<br>Date: Sun, 12 Dec 2010 15:11:32
-0500<br>Subject: Re: [Freeswitch-users] mod_nibblebill ODBC issue<br><br>
<style>
.ExternalClass .ecxhmmessage P
{padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;}
.ExternalClass BODY.ecxhmmessage
{font-family:Tahoma;font-size:10pt;}
</style>
<div><font face="Arial">you have to specify a unix odbc drivers,</font></div>
<div><font face="Arial">usually in /etc/odbc.ini
/etc/odbcinst.ini</font></div>
<blockquote style="border-left: 2px solid rgb(0, 0, 0); padding-left: 5px; padding-right: 0px; margin-left: 5px; margin-right: 0px;">
<div style="font: 10pt arial;">----- Original Message ----- </div>
<div style="font: 10pt arial; background: none repeat scroll 0% 0% rgb(228, 228, 228);"><b>From:</b>
<a title="rafonline@hotmail.com" href="mailto:rafonline@hotmail.com">Rafqat
.</a> </div>
<div style="font: 10pt arial;"><b>To:</b> <a title="freeswitch-users@lists.freeswitch.org" href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</a>
</div>
<div style="font: 10pt arial;"><b>Sent:</b> Sunday, December 12, 2010 3:02
PM</div>
<div style="font: 10pt arial;"><b>Subject:</b> [Freeswitch-users]
mod_nibblebill ODBC issue</div>
<div><br></div><br>Hi,<br><br>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:<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 =
MySQL<br>SERVER = localhost<br>PORT =
3306<br>DATABASE = FreeSWITCH<br>OPTION =
67108864<br>Socket = /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 = ODBC for
PostgreSQL<br>#Driver =
/usr/lib/libodbcpsql.so<br>#Setup
= /usr/lib/libodbcpsqlS.so<br>#FileUsage =
1<br><br># Driver from the MyODBC package<br># Setup from the unixODBC
package<br>[MySQL]<br>Description = ODBC for
MySQL<br>Driver
=
/usr/lib64/libmyodbc3.so<br>Setup
= /usr/lib64/libodbcmyS.so<br>FileUsage =
1<br><br>Snippet of my nibblebill.conf.xml file:<br><br><!--
Information for connecting to your database --><br><param
name="db_username" value="rafqat"/><br><param name="db_password"
value="?????"/><br><param name="db_dsn"
value="FreeSWITCH"/><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><br>
<hr>
<br>_______________________________________________<br>FreeSWITCH-users
mailing
list<br>FreeSWITCH-users@lists.freeswitch.org<br>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>http://www.freeswitch.org<br></blockquote><br>_______________________________________________
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org <br>
<hr>
<br>_______________________________________________<br>FreeSWITCH-users
mailing
list<br>FreeSWITCH-users@lists.freeswitch.org<br>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>http://www.freeswitch.org<br></blockquote><br>_______________________________________________
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
<BR><hr>
<BR>_______________________________________________<br>FreeSWITCH-users
mailing
list<br>FreeSWITCH-users@lists.freeswitch.org<br>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>http://www.freeswitch.org<br></blockquote>
<br>_______________________________________________
FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org </body>
</html>