[Freeswitch-users] Lua and database access to core_db

[Anthony Minessale]

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 at 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 at 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 at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
iax:guest at conference.freeswitch.org/888
googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
pstn:213-799-1400
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091204/88f41a3b/attachment-0002.html