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.
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 TelecommunicationsDK-2960 Rungsted Kyst
Tel: +45 45 16 1000
Mob: +45 26 15 30 60CVR: 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