[Freeswitch-users] mod_nibblebill

[budi wibowo]

ok thx a lot .. solved now

On Thu, Oct 21, 2010 at 5:16 AM, Sergey Okhapkin
<sos at sokhapkin.dyndns.org>wrote:

>  People told you many times already:
>
> <param name="db_dsn" value="fs_conect"/>
>
> On Wednesday 20 October 2010, budi wibowo wrote:
>
> > 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
>
> >
>
>
> _______________________________________________
> 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/a86d7732/attachment-0001.html