<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
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="stopSpelling">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>
<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">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 </body>
</html>