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@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@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@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...

_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org

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@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@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@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@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@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...

_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org