[Freeswitch-users] mod_nibblebill ODBC issue

Mon Dec 13 00:10:10 MSK 2010

I am a total idiot! I was changing the wrong nibblebill conf file!

Thanks very much guys.

Sorry for wasting your time.

Cheers

Raf

From: rafonline at hotmail.com
To: freeswitch-users at lists.freeswitch.org
Date: Sun, 12 Dec 2010 21:04:00 +0000
Subject: Re: [Freeswitch-users] mod_nibblebill ODBC issue

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 		 	   		  

_______________________________________________
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/1ae8a723/attachment.html 