[Freeswitch-users] mod_nibblebill ODBC issue

[Madovsky]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20101212/2a3cadc9/attachment-0001.html