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
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org
pstn:213-799-1400