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