On Thu, Sep 30, 2010 at 1:29 PM, Leon de Rooij <leon@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@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@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@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@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@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org