[Freeswitch-users] mod_nibblebill

[Sergey Okhapkin]

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
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20101020/06c84d52/attachment-0001.html