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

[ovvenkat]

On Thu, Sep 30, 2010 at 1:29 PM, Leon de Rooij <leon at scarlet-internet.nl>wrote:

> Hi Venkat,
>
> Please try to get latest revision from git. The Dbh function was introduced
> in mod_lua since 7 sept. You don't need to install any extra packages in
> your os if you have odbc already working in FreeSWITCH itself.
>
>
Hi Leon, I have updated to latest git version.  My new version is

FreeSWITCH Version 1.0.head (svn-18355M)

Still, I am not able to  use freeswitch.Dbh. I am getting error like

2010-10-01 11:22:38.226735 [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


I can able to connect to mysql using java script, the script i have used

use("ODBC");
var db = new ODBC("dsn_name", "venkat", "venkat123");

Thanks in advance,
Venkat.

Kind regards,
>
> Leon
>
>
>
>
> On Sep 30, 2010, at 9:47 AM, ovvenkat wrote:
>
> 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.
>
>  _______________________________________________
> 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
>
>
>
> _______________________________________________
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20101001/bc9bf23d/attachment.html