[Freeswitch-users] mod_nibblebill ODBC issue

Rafqat . rafonline at hotmail.com
Mon Dec 13 00:04:00 MSK 2010



Which variables do I need to set?

I am suprised to see the following line in my error output:

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)!

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.

All seems very odd.

Please help.

Cheers

Raf

From: infos at madovsky.org
To: freeswitch-users at lists.freeswitch.org
Date: Sun, 12 Dec 2010 15:50:20 -0500
Subject: Re: [Freeswitch-users] mod_nibblebill ODBC issue










Mabe your system env variables are not set.
it looks like odbc can't find the path...

  ----- Original Message ----- 
  From: 
  Rafqat 
  . 
  To: freeswitch-users at lists.freeswitch.org 
  
  Sent: Sunday, December 12, 2010 3:36 
  PM
  Subject: Re: [Freeswitch-users] 
  mod_nibblebill ODBC issue
  
I only updated the nibblebill config file with the following: 
  
<!-- Information for connecting to your database -->
<param name="db_username" value="rafqat"/>
<param name="db_password" value="?????"/>
<param name="db_dsn" value="FreeSWITCH"/>

I did not change any of the dsn related stuff in any of the other FreeSWITCH config files.

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?

or am i missing the point?

Cheers

Raf



  
  From: infos at madovsky.org
To: freeswitch-users at lists.freeswitch.org
Date: 
  Sun, 12 Dec 2010 15:27:39 -0500
Subject: Re: [Freeswitch-users] 
  mod_nibblebill ODBC issue


  
  

  what did you write on every
  db_dsn in Freeswitch config ?
  
    ----- Original Message ----- 
    From: Rafqat . 
    
    To: freeswitch-users at lists.freeswitch.org 
    
    Sent: Sunday, December 12, 2010 3:19 
    PM
    Subject: Re: [Freeswitch-users] 
    mod_nibblebill ODBC issue
    

More than what I have already specified?

My 
    /etc/odbc.ini file:

[FreeSWITCH]
Driver   = 
    MySQL
SERVER   = localhost
PORT     = 
    3306
DATABASE = FreeSWITCH
OPTION  = 
    67108864
Socket   = /var/lib/mysql/mysql.sock

My 
    /etc/odbcinst.ini file:

# Example driver definitinions
#
#
# 
    Included in the unixODBC 
    package
#[PostgreSQL]
#Description    = ODBC for 
    PostgreSQL
#Driver         = 
    /usr/lib/libodbcpsql.so
#Setup          
    = /usr/lib/libodbcpsqlS.so
#FileUsage      = 
    1

# Driver from the MyODBC package
# Setup from the unixODBC 
    package
[MySQL]
Description     = ODBC for 
    MySQL
Driver            
    = 
    /usr/lib64/libmyodbc3.so
Setup            
    = /usr/lib64/libodbcmyS.so
FileUsage      = 
    1


    
    From: infos at madovsky.org
To: 
    freeswitch-users at lists.freeswitch.org
Date: Sun, 12 Dec 2010 15:11:32 
    -0500
Subject: Re: [Freeswitch-users] mod_nibblebill ODBC issue


    

    you have to specify a unix odbc drivers,
    usually in /etc/odbc.ini 
/etc/odbcinst.ini
    
      ----- Original Message ----- 
      From: 
      Rafqat 
      . 
      To: freeswitch-users at lists.freeswitch.org 
      
      Sent: Sunday, December 12, 2010 3:02 
      PM
      Subject: [Freeswitch-users] 
      mod_nibblebill ODBC issue
      

Hi,

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:

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

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)!

Do I need to update more than just the nibblebill 
      conf file? 

Any help is much 
      appreciated

CHeers

Raf


My /etc/odbc.ini 
      file:

[FreeSWITCH]
Driver   = 
      MySQL
SERVER   = localhost
PORT     = 
      3306
DATABASE = FreeSWITCH
OPTION  = 
      67108864
Socket   = /var/lib/mysql/mysql.sock

My 
      /etc/odbcinst.ini file:

# Example driver 
      definitinions
#
#
# Included in the unixODBC 
      package
#[PostgreSQL]
#Description    = ODBC for 
      PostgreSQL
#Driver         = 
      /usr/lib/libodbcpsql.so
#Setup          
      = /usr/lib/libodbcpsqlS.so
#FileUsage      = 
      1

# Driver from the MyODBC package
# Setup from the unixODBC 
      package
[MySQL]
Description     = ODBC for 
      MySQL
Driver            
      = 
      /usr/lib64/libmyodbc3.so
Setup            
      = /usr/lib64/libodbcmyS.so
FileUsage      = 
      1

Snippet of my nibblebill.conf.xml file:

<!-- 
      Information for connecting to your database -->
<param 
      name="db_username" value="rafqat"/>
<param name="db_password" 
      value="?????"/>
<param name="db_dsn" 
      value="FreeSWITCH"/>


I have even setup the following 
      links:
mkdir /usr/local/freeswitch/etc
ln -s /etc/odbcinst.ini /usr/local/freeswitch/etc/odbcinst.ini
ln -s /etc/odbc.ini /usr/local/freeswitch/etc/odbc.ini

I can connect successfully using isql:

isql FreeSWITCH rafqat ??????









      
      
_______________________________________________
FreeSWITCH-users 
      mailing 
      list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

_______________________________________________ 
    FreeSWITCH-users mailing list FreeSWITCH-users at lists.freeswitch.org 
    http://lists.freeswitch.org/mailman/listinfo/freeswitch-users 
    UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users 
    http://www.freeswitch.org 

    
    
_______________________________________________
FreeSWITCH-users 
    mailing 
    list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

_______________________________________________ 
  FreeSWITCH-users mailing list FreeSWITCH-users at lists.freeswitch.org 
  http://lists.freeswitch.org/mailman/listinfo/freeswitch-users 
  UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users 
  http://www.freeswitch.org 
  
  

  _______________________________________________
FreeSWITCH-users 
  mailing 
  list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org


_______________________________________________
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20101212/ee77c882/attachment.html 


More information about the FreeSWITCH-users mailing list