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@madovsky.org
To: freeswitch-users@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@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:

<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@madovsky.org
To: freeswitch-users@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@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@madovsky.org
To: freeswitch-users@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@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:


<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@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@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@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@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org