unixodbc is the unixodbc libraries<br>unixodbc-dev are the development headers for compiling freeswitch to be able to speak to the unixodbc library<br><br>You need both unixodbc-dev and unixodbc on the box you're compiling freeswitch on, but if you then distributed the binary files to another server you'd only need unixodbc to run it.<br>
<br>Spidermonkey is just the module that runs javascript scripts, it isn't needed at all for odbc.<br><br>"Core" is the database that freeswitch stores some internal data in... normally that's in a sqlite file, but you can move it into ODBC too.<br>
<br>-Steve<br><br><br><br><div class="gmail_quote">On 28 January 2011 22:56, deniro <span dir="ltr"><<a href="mailto:ayhkor@gmail.com">ayhkor@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>ok I got dsn...</div>
<div> </div>
<div>I am using ubuntu linux & mqsql, so is it "unixodbc" to be installed?</div><div class="im">
<div>what is this "unixodbc-dev " then ?</div>
<div>where spidermonkey come in picture? do I need spidermonkey too if I installed unixodbc? </div>
<div>what is "core" and how different from ODBC?</div>
<div> </div>
<div>thx </div>
<div>deniro--</div>
<div><br><br></div>
</div><div><div></div><div class="h5"><div class="gmail_quote">On Fri, Jan 28, 2011 at 5:15 PM, deniro <span dir="ltr"><<a href="mailto:ayhkor@gmail.com" target="_blank">ayhkor@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;" class="gmail_quote">
<div> </div>
<div>thanks I looked these links and I did some googling...</div>
<div>
<div>I am using ubuntu 10.04 with mysql</div>couple of points to clear (sorry I am relativelly new to freeswitch world and concepts)</div>
<div> </div>
<div>what is dsn?</div>
<div>I am using ubuntu linux so it must be "unixodbc" to be installed?</div>
<div>what is this "unixodbc-dev " then ?</div>
<div>where spidermonkey come in picture? do I need spidermonkey too if I installed unixodbc? </div>
<div>what is "core" and how different from ODBC?</div>
<div> </div>
<div>thx</div>
<div>deniro--</div>
<div>
<div></div>
<div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">On Fri, Jan 28, 2011 at 4:29 PM, Steven Ayre <span dir="ltr"><<a href="mailto:steveayre@gmail.com" target="_blank">steveayre@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;" class="gmail_quote">Configure MySQL so you can connect via ODBC. That means installing MyODBC, and unixodbc if you're on Linux, then setting up a DSN.<br>
<br><a href="http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core" target="_blank">http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core</a><br><br>-Steve
<div>
<div></div>
<div><br><br>
<div class="gmail_quote">On 28 January 2011 21:09, Phone <span dir="ltr"><<a href="mailto:phone.bytes@gmail.com" target="_blank">phone.bytes@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
<div text="#000000" bgcolor="#ffffff">Take a look here<br><br><a href="http://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh" target="_blank">http://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh</a><br><br>and here<br><br><a href="http://wiki.freeswitch.org/wiki/Mod_lua#freeswitch.Dbh" target="_blank">http://wiki.freeswitch.org/wiki/Mod_lua#freeswitch.Dbh</a><br>
<br>lots of good info to get you started.
<div>
<div></div>
<div><br><br><br>On 01/28/2011 1:41 PM, deniro wrote: </div></div>
<blockquote type="cite">
<div>
<div></div>
<div>
<div>Hi</div>
<div> </div>
<div>I think lua is the recomended/preferred for database connections and programming with freeswitch</div>
<div> </div>
<div>1-- how can I connect to an existing mysql database (externally created and managed by php program -- contructed tables -rows- fields etc...) </div>
<div> </div>
<div>2-- how can I create new mysql database with freeswitch?</div>
<div> </div>
<div>3-- how to check if required lua components are really installed/working for mysql db in freeswitch?</div>
<div> </div>
<div>4-- if lua isn't a choice, which is the next best to handle mysql databases (javascript, perl etc..)</div>
<div> </div>
<div>5-- any comprehensive freeswitch mysql db handling doc, links etc...?</div>
<div>thx</div>
<div> </div></div></div><pre><fieldset></fieldset>
_______________________________________________
FreeSWITCH-users mailing list
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a>
</pre></blockquote><br></div><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><br></blockquote></div><br></div></div><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><br></blockquote></div><br></div></div></blockquote></div><br>
</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>