ok thx a lot .. solved now On Thu, Oct 21, 2010 at 5:16 AM, Sergey Okhapkin <sos@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@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
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
--
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
_______________________________________________ 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