[Freeswitch-users] mod_nibblebill ODBC issue

[Madovsky]

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