[Freeswitch-users] Not able to connect mysql using Dbh

[ovvenkat]

Hi to all,

If I wanted to use "freeswitch.Dbh" to connect mysql,  Can you anyone please
guide me, what are the packages I need to install ?

As of now, I have installed mysql and unixodbc

On Thu, Sep 30, 2010 at 11:03 AM, ovvenkat <ovvenkatesan at gmail.com> wrote:

> Hi Sassan,
>
> Which version of FreeSWITCH?
>>
>>
>     FreeSWITCH Version 1.0.6
>
>     Installed on CENT OS 5.3
>
>
>
> Regards,
> Venkat.
>
>
> Regards
>> HASSAN
>>
>>
>> On 2010-09-30, ovvenkat <ovvenkatesan at gmail.com> wrote:
>> > Hi to all,
>> > I could not able to connect to mySql using Dbh. Here is the coding I
>> have
>> > used to connect to my db.
>> > *
>> > local dbh = assert(freeswitch.Dbh("dsn_name","venkat","venkat123"))*
>> >
>> > I am getting following error while executing the lua test.lua in fs_cli
>> >
>> > 2010-09-29 17:57:29.924498 [ERR] mod_lua.cpp:182
>> > /usr/local/freeswitch/scripts/test.lua:23: attempt to call field 'Dbh'
>> (a
>> > nil value)
>> > stack traceback: /usr/local/freeswitch/scripts/test.lua:23: in main
>> chunk
>> >
>> > */etc/odbc.ini* file contains
>> >
>> > [dsn_name]
>> > Driver=MySQL
>> > SERVER=localhost
>> > PORT=3306
>> > USER=venkat
>> > PASSWORD=venkat123
>> > DATABASE=venkat
>> > Socket = /var/lib/mysql/mysql.sock
>> >
>> > *I can able to connect to my db using following command *
>> >
>> > isql dsn_name venkat venkat123
>> >
>> > I trying to figure it out for past two days and gone though wiki  not
>> able
>> > to crack it. Any one please help me to resolve my issue.
>> >
>> >
>> > --
>> >
>> > Regards
>> > Venkatesan OV.
>> >
>>
>> --
>> 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
>>
>
>
>
> --
>
> If you have come to help me, you are wasting your time.
> If you have come to because your liberation is bound up in mine, we can
> work together.
>
>
> Regards
> Venkatesan OV.
>
>


-- 

If you have come to help me, you are wasting your time.
If you have come to because your liberation is bound up in mine, we can work
together.


Regards
Venkatesan OV.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100930/823610e2/attachment-0001.html