[Freeswitch-users] mod_nibblebill ODBC issue
Madovsky
infos at madovsky.org
Sun Dec 12 23:50:20 MSK 2010
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?CheersRaf
------------------------------------------------------------------------------
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/etcln -s /etc/odbcinst.ini /usr/local/freeswitch/etc/odbcinst.iniln -s /etc/odbc.ini /usr/local/freeswitch/etc/odbc.iniI 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20101212/a55ebefe/attachment.html
More information about the FreeSWITCH-users
mailing list