<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
<br>I am a total idiot! I was changing the wrong nibblebill conf file!<br><br>Thanks very much guys.<br><br>Sorry for wasting your time.<br><br>Cheers<br><br>Raf<br><br><hr id="stopSpelling">From: rafonline@hotmail.com<br>To: freeswitch-users@lists.freeswitch.org<br>Date: Sun, 12 Dec 2010 21:04:00 +0000<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:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}

</style>


<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.&nbsp; 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="ecxstopSpelling">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>




<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="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;"><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>&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>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="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;"><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&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>
    <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="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;"><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.&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><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                                               
<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>