Re: [Freeswitch-users] Lua and database access to core_db
I have now tested the FS with core db configured using MySql (by modifying the switch.conf.xml file). Unfortunately, it does not solve my problem because some of the core tables still remain as active SQLite tables. After restarting the FS in the new configuration (with SQLite database core deleted), the following tables are created in MySql and SQLite: MySQL: aliases, complete, nat and tasks (database starting with no tables prior to FS restart). SQLite: aliases, calls, channels, interfaces, nat and tasks. As I would like to access the channels table using Lua, the change did not fix my problem. I have positive verified that the channels table is active and populated during calls. Are there other places where I should define the usage of the MySql database? Jon Brüel Consiglia Telecommunications DK-2960 Rungsted Kyst Tel: +45 45 16 1000 Mob: +45 26 15 30 60 CVR: 27047882
That means you mysql is not configured to do transactions so it failed over back to sqlite. if you scan for the warning message you will see the option you have to set and you may possibly have to update your myodbc odbc driver. To answer you other question about the sqlite, like I said the lua does not have the object coded like js does so it would be a project to implement it. You can also consider using ODBC plugin for lua to access the sqlite. On Fri, Dec 4, 2009 at 3:24 AM, Jon Bruel <jbr@consiglia.dk> wrote:
I have now tested the FS with core db configured using MySql (by modifying the switch.conf.xml file). Unfortunately, it does not solve my problem because some of the core tables still remain as active SQLite tables.
After restarting the FS in the new configuration (with SQLite database core deleted), the following tables are created in MySql and SQLite:
MySQL: aliases, complete, nat and tasks (database starting with no tables prior to FS restart).
SQLite: aliases, calls, channels, interfaces, nat and tasks.
As I would like to access the channels table using Lua, the change did not fix my problem. I have positive verified that the channels table is active and populated during calls.
Are there other places where I should define the usage of the MySql database?
*Jon Brüel* Consiglia Telecommunications
DK-2960 Rungsted Kyst Tel: +45 45 16 1000 Mob: +45 26 15 30 60
CVR: 27047882
_______________________________________________ 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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
participants (2)
-
Anthony Minessale
-
Jon Bruel