[Freeswitch-users] freeswitch mysql handling

[Steven Ayre]

unixodbc is the unixodbc libraries
unixodbc-dev are the development headers for compiling freeswitch to be able
to speak to the unixodbc library

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.

Spidermonkey is just the module that runs javascript scripts, it isn't
needed at all for odbc.

"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.

-Steve



On 28 January 2011 22:56, deniro <ayhkor at gmail.com> wrote:

> ok I got dsn...
>
> I am using  ubuntu linux & mqsql, so  is it "unixodbc" to be installed?
> what is this "unixodbc-dev " then ?
> where spidermonkey come in picture? do I need spidermonkey too if I
> installed   unixodbc?
> what is "core" and how different from ODBC?
>
> thx
> deniro--
>
>
> On Fri, Jan 28, 2011 at 5:15 PM, deniro <ayhkor at gmail.com> wrote:
>
>>
>> thanks I looked these links and  I did some googling...
>>  I am using ubuntu 10.04  with mysql
>> couple of points to clear (sorry I am relativelly new  to freeswitch
>> world and  concepts)
>>
>> what is dsn?
>> I am using  ubuntu linux  so  it must be "unixodbc" to be installed?
>> what is this "unixodbc-dev " then ?
>> where spidermonkey come in picture? do I need spidermonkey too if I
>> installed   unixodbc?
>> what is "core" and how different from ODBC?
>>
>> thx
>> deniro--
>>
>>
>>
>>
>>
>>
>>
>> On Fri, Jan 28, 2011 at 4:29 PM, Steven Ayre <steveayre at gmail.com> wrote:
>>
>>> Configure MySQL so you can connect via ODBC. That means installing
>>> MyODBC, and unixodbc if you're on Linux, then setting up a DSN.
>>>
>>> http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core
>>>
>>> -Steve
>>>
>>>
>>> On 28 January 2011 21:09, Phone <phone.bytes at gmail.com> wrote:
>>>
>>>> Take a look here
>>>>
>>>> http://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh
>>>>
>>>> and here
>>>>
>>>> http://wiki.freeswitch.org/wiki/Mod_lua#freeswitch.Dbh
>>>>
>>>> lots of good info to get you started.
>>>>
>>>>
>>>>
>>>> On 01/28/2011 1:41 PM, deniro wrote:
>>>>
>>>>   Hi
>>>>
>>>> I think lua is the recomended/preferred for database connections and
>>>> programming with freeswitch
>>>>
>>>> 1-- how can I connect to an existing mysql database (externally created
>>>> and managed by php program -- contructed tables -rows- fields etc...)
>>>>
>>>> 2-- how can I create  new mysql database  with freeswitch?
>>>>
>>>> 3-- how to check if required  lua components are  really
>>>> installed/working  for mysql db in freeswitch?
>>>>
>>>> 4-- if lua isn't a choice, which is the next best to handle  mysql
>>>> databases (javascript, perl etc..)
>>>>
>>>> 5-- any comprehensive  freeswitch  mysql db handling doc, links etc...?
>>>> thx
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>>
>>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>
> _______________________________________________
> 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/20110129/c494c16b/attachment.html