<!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>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: #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: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=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 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: 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: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: 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 <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>