VoIP Mailing List Archives

[jp.manchu at gmail.com]

Hi All,
I am newbie to Freeswitch.
I installed freeswitch-1.0.3 in Debian machine. I am able to make
call, check presence, retrieve CDRs.
I followed the installation steps given in mod_nibblebill for rating.
While, installing mysql-connector-odbc, it has thrown errors related
to mysql-config file, that it does not exist. Coming to mysql,
mysql-client-5 and mysql-server-5 are installed.

So I installed libmyodbc which is used for the same functionality.
Rest of the steps are done, as given in mod-nibblebill installation.
When the freeradius server is restarted, it has given the following error.

2009-03-14 14:55:47 [ERR] switch_odbc.c:164
switch_odbc_handle_connect() STATE: IM002 CODE 0 ERROR:
[unixODBC][Driver Manager]Data source name not found, and no default
driver specified

2009-03-14 14:55:47 [CRIT] mod_nibblebill.c:233 load_config() Cannot
connect to ODBC driver/database freeswitch (user: root / pass dev)!

Will you please have a look in solving this issue ? , how the issue
can be solved?


Thanks & Regards,
JP.

_______________________________________________
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

[rupa at rupa.com]

Have you configured unixodbc? 

http://wiki.freeswitch.org/wiki/Mod_spidermonkey_odbc

covers configuring odbc in detail.

On Sat, Mar 14, 2009 at 6:49 AM, JayaPrakash <jp.manchu@gmail.com (jp.manchu@gmail.com)> wrote:

[d at d-man.org]

Is this issue still open? I just noticed this.

The error you are receiving indicates UnixODBC is installed, but not
configured properly (most likely anyway). The UnixODBC drivers are kind of a
pain to setup on some systems, especially CentOS, but this article may help
you get it working -
http://webaj.com/how-setup-mysql-dsn-datasbase-source-centos-myodbc-and-unix
odbc-command-line.htm. I strongly recommend making sure the test commands
they list work before trying to get UnixODBC working within FreeSWITCH.

Also, it looks like you may have failed to copy the sample mod_nibblebill
XML config file to /usr/local/freeswitch/conf/autoload_configs/ . You may
want to give that a try. Within that file is the name of the ODBC driver
being referenced - make sure that driver exists (see link above).


- Darren


-----Original Message-----
From: JayaPrakash [mailto:jp.manchu@gmail.com]
Sent: Saturday, March 14, 2009 4:49 AM
To: freeswitch-users@lists.freeswitch.org
Subject: [Freeswitch-users] Issue relating mod_nibblebill

Hi All,
I am newbie to Freeswitch.
I installed freeswitch-1.0.3 in Debian machine. I am able to make call,
check presence, retrieve CDRs.
I followed the installation steps given in mod_nibblebill for rating.
While, installing mysql-connector-odbc, it has thrown errors related to
mysql-config file, that it does not exist. Coming to mysql,
mysql-client-5 and mysql-server-5 are installed.

So I installed libmyodbc which is used for the same functionality.
Rest of the steps are done, as given in mod-nibblebill installation.
When the freeradius server is restarted, it has given the following error.

2009-03-14 14:55:47 [ERR] switch_odbc.c:164
switch_odbc_handle_connect() STATE: IM002 CODE 0 ERROR:
[unixODBC][Driver Manager]Data source name not found, and no default driver
specified

2009-03-14 14:55:47 [CRIT] mod_nibblebill.c:233 load_config() Cannot connect
to ODBC driver/database freeswitch (user: root / pass dev)!

Will you please have a look in solving this issue ? , how the issue can be
solved?


Thanks & Regards,
JP.

_______________________________________________
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