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