<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<STYLE>.hmmessage P {
PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 0px
}
BODY.hmmessage {
FONT-FAMILY: Tahoma; FONT-SIZE: 10pt
}
</STYLE>
<META name=GENERATOR content="MSHTML 8.00.6001.18939"></HEAD>
<BODY class=hmmessage bgColor=#ffffff>
<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: #000000 2px solid; 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: #e4e4e4; font-color: black"><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=stopSpelling>
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>
<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>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: rgb(0,0,0) 2px solid; 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: 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
<P>
<HR>
<P></P>_______________________________________________<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></BODY></HTML>