[Freeswitch-users] mod_nibblebill ODBC issue

[Rafqat .]

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 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20101212/c9c78507/attachment-0001.html