[Freeswitch-users] mod_nibblebill

[budi wibowo]

hi
for nibblebill.conf.xml i have this
<configuration name="nibblebill.conf" description="Nibble Billing">
  <settings>
    <!-- See http://wiki.freeswitch.org/wiki/Mod_nibblebill for help with
these options -->

    <!-- Information for connecting to your database -->
    <param name="db_username" value="root"/>
    <param name="db_password" value="rootpass"/>
    <param name="db_dsn" value="fs_conect"/>

also fs_connect is recognized when i issue command isql

please help



On Wed, Oct 20, 2010 at 3:15 PM, Nyamul Hassan <mnhassan at usa.net> wrote:

> Check the debug log you posted earlier. The first line says all about it.
>
> For nibble bill, you put it in the conf.xml file for nibble bill.
>
> Regards
> HASSAN
>
>
> On 2010-10-20, budi wibowo <bwibowo at gmail.com> wrote:
> > hi hassan
> > dns name is fs_connect, where i hould put that parameter?
> >
> >
> > regards
> >
> > budi
> >
> > On Wed, Oct 20, 2010 at 2:25 PM, Nyamul Hassan <mnhassan at usa.net> wrote:
> >
> >> As per the debug logs, the name of the dsn is missing a "n" inside
> >> FreeSWITCH.
> >>
> >> Regards
> >> HASSAN
> >>
> >>
> >> On 2010-10-20, budi wibowo <bwibowo at gmail.com> wrote:
> >> > dear all
> >> >
> >> > i install mod_nibblebil on centos 5.5 according to steps in
> >> > http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core
> >> >
> >> > odbc.ini config:
> >> > [fs_connect]
> >> > Driver   = mySQL
> >> > SERVER   = localhost
> >> > PORT     = 3306
> >> > DATABASE = fs
> >> > OPTION  = 67108864
> >> > Socket   = /var/lib/mysql/mysql.sock
> >> >
> >> > switch.conf.xml i add this
> >> >
> >> >  <param name="odbc-dsn" value="fs_connect:root:rootpass" />
> >> >
> >> > if i execute isql fs_connect root rootpass it's the result
> >> > +---------------------------------------+
> >> > | Connected!                            |
> >> > |                                       |
> >> > | sql-statement                         |
> >> > | help [tablename]                      |
> >> > | quit                                  |
> >> > |                                       |
> >> > +---------------------------------------+
> >> > SQL>
> >> >
> >> >
> >> > but i found this error, where's my mistake ?
> >> >
> >> > i 2010-10-20 07:20:39.411254 [CRIT] switch_odbc.c:210 The sql server
> is
> >> not
> >> > responding for DSN fs_conect [STATE: 08003 CODE 0 ERROR:
> >> [unixODBC][Driver
> >> > Manager]Connnection does not exist
> >> > ][169]
> >> > 2010-10-20 07:20:39.411254 [CRIT] switch_odbc.c:218 The connection
> could
> >> not
> >> > be re-established
> >> > 2010-10-20 07:20:40.412241 [ERR] switch_odbc.c:318 STATE: IM002 CODE 0
> >> > ERROR: [unixODBC][Driver Manager]Data source name not found, and no
> >> default
> >> > driver specified
> >> >
> >> > 2010-10-20 07:20:40.412241 [CRIT] switch_odbc.c:210 The sql server is
> >> > not
> >> > responding for DSN fs_conect [STATE: 08003 CODE 0 ERROR:
> >> [unixODBC][Driver
> >> > Manager]Connnection does not exist
> >> > ][169]
> >> > 2010-10-20 07:20:40.412241 [CRIT] switch_odbc.c:218 The connection
> could
> >> not
> >> > be re-established
> >> > 2010-10-20 07:20:41.412257 [ERR] switch_odbc.c:318 STATE: IM002 CODE 0
> >> > ERROR: [unixODBC][Driver Manager]Data source name not found, and no
> >> default
> >> > driver specified
> >> >
> >> > 2010-10-20 07:20:41.412257 [CRIT] switch_odbc.c:210 The sql server is
> >> > not
> >> > responding for DSN fs_conect [STATE: 08003 CODE 0 ERROR:
> >> [unixODBC][Driver
> >> > Manager]Connnection does not exist
> >> >
> >> >
> >> >
> >> > regards
> >> >
> >> > budi
> >> >
> >>
> >> --
> >> Sent from my mobile device
> >>
> >> _______________________________________________
> >> 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
> >>
> >
>
> --
> Sent from my mobile device
>
> _______________________________________________
> 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/20101021/caacd302/attachment-0001.html