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@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@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@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@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org