<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Venkat,<div><br></div><div>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.</div><div><br></div><div>Kind regards,</div><div><br></div><div>Leon</div><div><br></div><div><br></div><div><br></div><div><br><div><div>On Sep 30, 2010, at 9:47 AM, ovvenkat wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr"><span>Hi to all, <br><br>If I wanted to use "freeswitch.Dbh" to connect mysql, Can you anyone please guide me, what are the packages I need to install ?</span><br><br>As of now, I have installed mysql and unixodbc <br> <br><div class="gmail_quote">On Thu, Sep 30, 2010 at 11:03 AM, ovvenkat <span dir="ltr"><<a href="mailto:ovvenkatesan@gmail.com">ovvenkatesan@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div dir="ltr">Hi Sassan, <br><div class="gmail_quote"><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Which version of FreeSWITCH?<br> <br></blockquote><div><br> FreeSWITCH Version 1.0.6<br> <br> Installed on CENT OS 5.3 <br> <br> <br><br>Regards,<br>Venkat. <br><br><br></div><div><div></div><div class="h5"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Regards<br> HASSAN<br> <div><div></div><div><br> <br> On 2010-09-30, ovvenkat <<a href="mailto:ovvenkatesan@gmail.com" target="_blank">ovvenkatesan@gmail.com</a>> wrote:<br> > Hi to all,<br> > I could not able to connect to mySql using Dbh. Here is the coding I have<br> > used to connect to my db.<br> > *<br> > local dbh = assert(freeswitch.Dbh("dsn_name","venkat","venkat123"))*<br> ><br> > I am getting following error while executing the lua test.lua in fs_cli<br> ><br> > 2010-09-29 17:57:29.924498 [ERR] mod_lua.cpp:182<br> > /usr/local/freeswitch/scripts/test.lua:23: attempt to call field 'Dbh' (a<br> > nil value)<br> > stack traceback: /usr/local/freeswitch/scripts/test.lua:23: in main chunk<br> ><br> > */etc/odbc.ini* file contains<br> ><br> > [dsn_name]<br> > Driver=MySQL<br> > SERVER=localhost<br> > PORT=3306<br> > USER=venkat<br> > PASSWORD=venkat123<br> > DATABASE=venkat<br> > Socket = /var/lib/mysql/mysql.sock<br> ><br> > *I can able to connect to my db using following command *<br> ><br> > isql dsn_name venkat venkat123<br> ><br> > I trying to figure it out for past two days and gone though wiki not able<br> > to crack it. Any one please help me to resolve my issue.<br> ><br> ><br> > --<br> ><br> > Regards<br> > Venkatesan OV.<br> ><br> <br> </div></div>--<br> Sent from my mobile device<br> <br> _______________________________________________<br> FreeSWITCH-users mailing list<br> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br> </blockquote></div></div></div><br><br clear="all"><br>-- <br><div dir="ltr"><br>If you have come to help me, you are wasting your time. <br>If you have come to because your liberation is bound up in mine, we can work together.<br> <br> <br>Regards<br>Venkatesan OV.</div><br> </div> </blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr"><br>If you have come to help me, you are wasting your time. <br>If you have come to because your liberation is bound up in mine, we can work together.<br><br> <br>Regards<br>Venkatesan OV.</div><br> </div> _______________________________________________<br>FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>http://www.freeswitch.org<br></blockquote></div><br></div></body></html>