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

[Leon de Rooij]

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.

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100930/a85e4cdd/attachment.html