Making luaSQL or Dbh working on Freeswitch installed on a Debian Linux distribution
Hye, I have a server that works on a debian squeeze 6.0.2 Linux distribution. On that server, since march 2011, is installed Freeswitch 1.0.6 I've just installed Debian packages for "mysql" and created a database that works fine. I've also installed Debian packages for "unixodbc" to be able to work on that database via ODBC in order to access that database from "Freeswitch.Dbh" The command : "isql dsn_name" does connect to my database. I have tried to install luaSQL but I don't know how to edit the "config" file in the source directory "/usr/src/luasql-2.1.1/" in order to compile without errors. I've found that LUA_LIBDIR is not in /usr/local/lib/lua/5.1 but in /usr/lib/lua/5.1 Same thing for LUA_DIR which is in /usr/share/lua/5.1 (can you confirm ?) I don't know how to edit the lines about the MySQL Drivers : DRIVER_LIBS= -L/usr/local/mysql/lib -lmysqlclient -lz DRIVER_INCS= -I/usr/local/mysql/include Odbc finds his own drivers in the directory : /usr/lib/odbc I've heard that it could be better to use Freeswitch.Dbh instead of luaSQL so this is not crutial but could help me to understand how all those things work together. My crutial questions are : How can I test the connection from Freeswitch.Dbh to the database ? Now that unixodbc is installed after freeswitch, do I have to re-install freeswitch from scratch (configure, ..., make, make install, ...) in order to have it working together? Is this re-installation operation safe as I have created some new things in the dialplan and the users directory of freeswitch ? Thanks a lot. Obbyone -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Making-luaSQL-or-Dbh-working-o... Sent from the freeswitch-users mailing list archive at Nabble.com.
i wouldn't bother with LuaSQL, freeswitch.Dbh is a much better way to go. you'll need to upgrade your FreeSWITCH installation though, 1.0.6 didn't have it. you can find usage examples for freeswitch.Dbh on the wiki. chad On Sep 9, 2011, at 10:08 AM, obbyone wrote:
Hye,
I have a server that works on a debian squeeze 6.0.2 Linux distribution. On that server, since march 2011, is installed Freeswitch 1.0.6
I've just installed Debian packages for "mysql" and created a database that works fine. I've also installed Debian packages for "unixodbc" to be able to work on that database via ODBC in order to access that database from "Freeswitch.Dbh"
The command : "isql dsn_name" does connect to my database.
I have tried to install luaSQL but I don't know how to edit the "config" file in the source directory "/usr/src/luasql-2.1.1/" in order to compile without errors. I've found that LUA_LIBDIR is not in /usr/local/lib/lua/5.1 but in /usr/lib/lua/5.1 Same thing for LUA_DIR which is in /usr/share/lua/5.1 (can you confirm ?)
I don't know how to edit the lines about the MySQL Drivers :
DRIVER_LIBS= -L/usr/local/mysql/lib -lmysqlclient -lz DRIVER_INCS= -I/usr/local/mysql/include
Odbc finds his own drivers in the directory : /usr/lib/odbc
I've heard that it could be better to use Freeswitch.Dbh instead of luaSQL so this is not crutial but could help me to understand how all those things work together.
My crutial questions are :
How can I test the connection from Freeswitch.Dbh to the database ? Now that unixodbc is installed after freeswitch, do I have to re-install freeswitch from scratch (configure, ..., make, make install, ...) in order to have it working together? Is this re-installation operation safe as I have created some new things in the dialplan and the users directory of freeswitch ?
Thanks a lot.
Obbyone
-- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Making-luaSQL-or-Dbh-working-o... Sent from the freeswitch-users mailing list archive at Nabble.com.
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
Thanks. I've made an upgrade of freeswitch with GIT version of 2011-09-09 and it works fine. Can I now use Freeswitch.Dbh on the mysql database through ODBC without changing anything or do I have to edit and compile something else? How can I test in a simple way this connection between Freeswitch and MySQL database ? Thanks in advance. -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Making-luaSQL-or-Dbh-working-o... Sent from the freeswitch-users mailing list archive at Nabble.com.
RTFM: http://wiki.freeswitch.org/wiki/Mod_lua#freeswitch.Dbh http://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh chad On Sep 10, 2011, at 4:18 AM, obbyone wrote:
Thanks. I've made an upgrade of freeswitch with GIT version of 2011-09-09 and it works fine.
Can I now use Freeswitch.Dbh on the mysql database through ODBC without changing anything or do I have to edit and compile something else?
How can I test in a simple way this connection between Freeswitch and MySQL database ?
Thanks in advance.
-- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Making-luaSQL-or-Dbh-working-o... Sent from the freeswitch-users mailing list archive at Nabble.com.
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
participants (2)
-
Chad Phillips -- Apartment Lines
-
obbyone