[Freeswitch-users] mod_nibblebill ODBC issue

[Rafqat .]

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