<div dir="ltr"><br><br><div class="gmail_quote">On Thu, Sep 30, 2010 at 1:29 PM, Leon de Rooij <span dir="ltr"><<a href="mailto:leon@scarlet-internet.nl">leon@scarlet-internet.nl</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 style="">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></blockquote><div><br>Hi Leon, I have updated to latest git version. My new version is <br><br><span style="background-color: rgb(204, 204, 255);">FreeSWITCH Version 1.0.head (svn-18355M)</span><br>
<br>Still, I am not able to use freeswitch.Dbh. I am getting error like <br><br><span style="background-color: rgb(255, 204, 204);">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)</span><br style="background-color: rgb(255, 204, 204);">
<span style="background-color: rgb(255, 204, 204);">stack traceback:</span><br style="background-color: rgb(255, 204, 204);"><span style="background-color: rgb(255, 204, 204);"> /usr/local/freeswitch/scripts/test.lua:23: in main chunk</span><br>
<br><br>I can able to connect to mysql using java script, the script i have used <br><br><span style="background-color: rgb(153, 255, 153);">use("ODBC");</span><br style="background-color: rgb(153, 255, 153);"><span style="background-color: rgb(153, 255, 153);">var db = new ODBC("dsn_name", "venkat", "venkat123");</span><br>
<br>Thanks in advance, <br>Venkat. <br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div style=""><div></div><div>Kind regards,</div>
<div><br></div><font color="#888888"><div>Leon</div></font><div><div></div><div class="h5"><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><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" target="_blank">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><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" 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><br></div></div></div></div><br>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">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>
<br></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>