Re: [Freeswitch-users] Lua and database access to core_db

2009-12-08 Thread Jon Bruel
I got the combination Lua with direct access to the core Sqlite database to work. Hurray, maybe I'm not as stupid as A.M II hints... The problem was that Lua did not like: require luasql.sqlite env = luasql.sqlite() con = assert(env:connect(/usr/local/freeswitch/db/core.db)) After

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-08 Thread Brian West
And you didn't open a Jira about this? These are the kinds of issues that you should report so we can fix them... sitting on them and NOT reporting them only delays the 1.0.5 release. /b On Dec 8, 2009, at 5:46 AM, Jon Bruel wrote: Changing the core db into a MySQL via ODBC caused some

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-08 Thread Anthony Minessale
One last bit of free consulting advice for you: You are again being rude because you want us to work for you for free. The code is free sir, the support here is voluntary and based on our willingness to help and comments like that are all it takes to get us to ignore you completely. On Tue, Dec

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-08 Thread Michael Jerris
I changed the name of key to ikey in trunk. Mike Changing the core db into a MySQL via ODBC caused some problems even after it seemed to work. For instance, console help caused an error with an error description indicating that a SQL SELECT query including the reserved word key has been

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-08 Thread Michael Collins
On Tue, Dec 8, 2009 at 3:46 AM, Jon Bruel j...@consiglia.dk wrote: I got the combination Lua with direct access to the core Sqlite database to work. Hurray, maybe I’m not as stupid as A.M II hints… Tsk tsk! He didn't actually hint that you were stupid - all he said was that doing ODBC and

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-08 Thread Jon Bruel
-boun...@lists.freeswitch.org] On Behalf Of Anthony Minessale Sent: 8. december 2009 17:28 To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Lua and database access to core_db One last bit of free consulting advice for you: You are again being rude because you want us

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-08 Thread Kendall Stauffer
-users-boun...@lists.freeswitch.org] On Behalf Of Brian West Sent: Tuesday, December 08, 2009 9:34 AM To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Lua and database access to core_db And you didn't open a Jira about this? These are the kinds of issues that you should

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-08 Thread Tim Uckun
On Wed, Dec 9, 2009 at 7:56 AM, Kendall Stauffer k...@ksac.com wrote: Hey you guys, I know this isn’t the right place for this, but I have been working with asterisk for 5 years now, and just got freeswitch working (on windows, not os x yet). All I can say is AWESOME --- thanks so much

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-06 Thread Jon Bruel
Dear all Some feedback regarding using Lua to access core database: First of all, I did not succeed to get SQLite drivers in Lua or ODBC-drivers in Lua to work. The SQLite driver did compile OK, but there was an error when loading into Lua. The ODBC driver did also compile OK, did load into

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-06 Thread Lon Baker
Jon, What version of MySQL are you using? ___ 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

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-06 Thread Anthony Minessale
Most of this is unfortunatly because you do not have the proper skill to set it up because, with the proper skills, all of the ways you tried would have ended sucessfully. I say that beacause I have had many users use each of the different methods in your list of failures only they were

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-06 Thread Jon Bruel
: [Freeswitch-users] Lua and database access to core_db Most of this is unfortunatly because you do not have the proper skill to set it up because, with the proper skills, all of the ways you tried would have ended sucessfully. I say that beacause I have had many users use each of the different

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-06 Thread Anthony Minessale
-users@lists.freeswitch.org *Subject:* Re: [Freeswitch-users] Lua and database access to core_db Most of this is unfortunatly because you do not have the proper skill to set it up because, wit... ___ FreeSWITCH-users mailing list FreeSWITCH-users

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-04 Thread Jon Bruel
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

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-04 Thread 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

[Freeswitch-users] Lua and database access to core_db

2009-12-03 Thread Jon Bruel
I am trying to rewrite all my javascript scripts into Lua scripts. I have run into the problem of core_db access. This can be achieved with Spidermonkey, but apparently not with Lua. I have tried to get the binary for Lua (using apt-get) but I get an error when I require the sqlite.so:

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-03 Thread Anthony Minessale
In latest trunk you can run the core db in your same mysql db. other than that we would need to create an object from our lua module similar to how it was done in js. On Thu, Dec 3, 2009 at 2:05 PM, Jon Bruel j...@consiglia.dk wrote: I am trying to rewrite all my javascript scripts into Lua

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-03 Thread Jon Bruel
Anthony, you advised me to use MySQL as the core database in order to access it from Lua. I'm testing that as a work-around. Still, I guess that your choice of SQLite as the default core database have been taken from efficiency or stability considerations. Using MySQL through an ODBC-connector

Re: [Freeswitch-users] Lua and database access to core_db

2009-12-03 Thread Mathieu Rene
ODBC isnt as bad as its used to be. We use it with postgresql every day and are very happy with it. Mathieu Rene Avant-Garde Solutions Inc Office: + 1 (514) 664-1044 x100 Cell: +1 (514) 664-1044 x200 mr...@avgs.ca On 4-Dec-09, at 1:40 AM, Jon Bruel wrote: Anthony, you advised me to use