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

[mayamatakeshi]

On Fri, Oct 1, 2010 at 3:05 PM, ovvenkat <ovvenkatesan at gmail.com> wrote:

>
>
> 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)
>

Clearly you don't have the latest git version. The above is from svn mirror,
which is not being synced with git repo anymore.
If you were using git, you would see something like this:

FreeSWITCH Version 1.0.head (git-b6a81ba 2010-09-27 21-36-02 -0500)


> 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.
>
>
> _______________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20101001/3e825038/attachment-0001.html