Re: [Freeswitch-users] Lua and database access to core_db
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 changing it to require luasql.sqlite3 env = luasql.sqlite3() con = assert(env:connect(/usr/local/freeswitch/db/core.db)) And seeing that there was a symlink in one of the right directories called with the name: sqlite3.so, it worked. 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 fired. It this problem likely to be solved if I used another version of the MySQL? 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
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 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 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 fired. It this problem likely to be solved if I used another version of the MySQL? ___ 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
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 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 8, 2009 at 5: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… 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 changing it to require luasql.sqlite3 env = luasql.sqlite3() con = assert(env:connect(/usr/local/freeswitch/db/core.db)) And seeing that there was a symlink in one of the right directories called with the name: sqlite3.so, it worked. 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 fired. It this problem likely to be solved if I used another version of the MySQL? *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_miness...@hotmail.com msn%3aanthony_miness...@hotmail.com GTALK/JABBER/PAYPAL:anthony.miness...@gmail.compaypal%3aanthony.miness...@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:8...@conference.freeswitch.org sip%3a...@conference.freeswitch.org iax:gu...@conference.freeswitch.org/888 googletalk:conf+...@conference.freeswitch.orggoogletalk%3aconf%2b...@conference.freeswitch.org pstn:213-799-1400 ___ 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
Re: [Freeswitch-users] Lua and database access to core_db
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 fired. It this problem likely to be solved if I used another version of the MySQL? Jon Brüel ___ 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
Re: [Freeswitch-users] Lua and database access to core_db
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 configuring databases isn't something as simple as flipping on a switch. It takes a bit of knowledge, much of which is hard-earned through experience. Trying to get it all up and running by emailing the list every time something goes wrong is like trying to learning how to change the oil in your car and emailing the Audi-users list every time something doesn't go as expected: yeah, you can probably learn something, possibly you can get it working, but it's grossly inefficient. You'd be much better off paying someone a few euros to come out and give you a lesson because in the long run it would save you both time and money. Just my $0.02. (Don't know what that is in euros...) -MC ___ 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
Re: [Freeswitch-users] Lua and database access to core_db
Point taken Anthony. Naturally you are not going to work for me for free. But I'm a bit confused about the statement that I'm rude. That's not my purpose to be. And I certainly do hope that this is not just a question of a cultural clash between an elderly man with a Phd in black holes from a European background and a young American FS genius. But frankly, I did believe that focus regarding changes and new developments was somewhat guided by the input you get from the users list, including changes which makes the FS easier to access for newbies, but maybe I'm wrong. That's my last comment, hope we can continue the exchange of views in a good spirit. Jon Brüel Consiglia Telecommunications DK-2960 Rungsted Kyst Tel: +45 45 16 1000 Mob: +45 26 15 30 60 CVR: 27047882 From: freeswitch-users-boun...@lists.freeswitch.org [mailto:freeswitch-users-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 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 8, 2009 at 5:46 AM, Jon Bruel j...@consiglia.dkmailto: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... 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 changing it to require luasql.sqlite3 env = luasql.sqlite3() con = assert(env:connect(/usr/local/freeswitch/db/core.db)) And seeing that there was a symlink in one of the right directories called with the name: sqlite3.so, it worked. 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 fired. It this problem likely to be solved if I used another version of the MySQL? 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.orgmailto: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_miness...@hotmail.commailto:msn%3aanthony_miness...@hotmail.com GTALK/JABBER/PAYPAL:anthony.miness...@gmail.commailto:paypal%3aanthony.miness...@gmail.com IRC: irc.freenode.nethttp://irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:8...@conference.freeswitch.orgmailto:sip%3a...@conference.freeswitch.org iax:gu...@conference.freeswitch.org/888http://iax:gu...@conference.freeswitch.org/888 googletalk:conf+...@conference.freeswitch.orgmailto:googletalk%3aconf%2b...@conference.freeswitch.org pstn:213-799-1400 ___ 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
Re: [Freeswitch-users] Lua and database access to core_db
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 From: freeswitch-users-boun...@lists.freeswitch.org [mailto:freeswitch-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 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 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 fired. It this problem likely to be solved if I used another version of the MySQL? ___ 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
Re: [Freeswitch-users] Lua and database access to core_db
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 Out of curiosity. Did you choose freeswitch because it runs on windows and asterisk doesn't? I find some people choose freeswitch because they don't know or want to use linux (obviously this doesn't apply to you) and some people choose it because they want a windows solution and asterisk doesn't run on windows. ___ 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
Re: [Freeswitch-users] Lua and database access to core_db
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 Lua, but could not connect. Accessing the SQLite from the Linux console using isql -v name of DSN worked OK. The problems may be related to the present Linux distribution, which is Ubuntu 9.1 server. Unfortunately the public searchable information about Lua ODBC driver problems is sparse. So I continued to try to get the FS to use MySQL as the core db. A number of problem occurred, which I did not find solution for in the FS documents. The problems and solutions are described below: 1) The core database is not automatically created by FS, therefore I created it manually. 2) During startup, the FS test for transaction support, and this test failed. To achieved transaction support with MySQL and MyODBC, three things had to be changed: a. A line was added in my.cnf to force innoDB as the default table: under the [mysqld] header, the following line was added: set-variable = default-table-type=InnoDB. b. The a line under the DNS was added to allow for multiple line statement support: option = 67108864. (ODBC version is 3.51). 3) After these changes the transaction worked, but all the tables in the core db were not created, therefore I copied the structure from the SQLite tables into tables with the same names in the MySQL database. This exercise also showed what the problem was: MySQL could not create tables with many VARCHAR type files with a size of 4096 (sound very big?). The size was reduced to 255, and most of the tables were created OK. One table still gave problems: the interface table. One of the fields is called key, which is a reserved word in MySQL, and by backticking the word key in the create statement, it worked. 4) Finally the FS started up using the MySQL, but errors splashed over the screen just after startup. There was a problem creating new records in the interface table, the problem was the key field. Changing the insert statement in switch.core.sqldb.c file by backticking the key field name and recompiling the FS solved that problem. I guess this will be fixed in later releases and I hope this will assist the brave programmers! I would like to argue for the development of SQLite connectivity in Lua. The ODBC core solution is not as clean as a direct database connection, and as long as this is limited to SQLite, a direct connection from recommended script language would be the cleanest solution. Further, it would be nice if everything works after having compiled the FS package. 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
Re: [Freeswitch-users] Lua and database access to core_db
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 http://www.freeswitch.org
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, 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 sucessful. What you are asking for is possible but would require many hours of coding just to help solve your problem. You would have to wait a really long time until someone had the time to do it for free or post a bounty for it. Probably about 1k in consulting time. It may be cheaper for you to pay a consultant to set up one of the ways known to work. These are your options as I see it. On Dec 6, 2009 12:20 PM, Lon Baker l...@kickasspixels.com wrote: 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 http://www.freeswitch.org ___ 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
Re: [Freeswitch-users] Lua and database access to core_db
The MySQL version is 5.1.37. Well I'm not an expert on every field, and I have no skills in the C, include libraries, and the art of compiling. For this I have to follow the guidelines. But it wouldn't harm the FS project if it generally became more accessible to the race of non-specialists, which I hereby represent. Jon Brüel From: freeswitch-users-boun...@lists.freeswitch.org [mailto:freeswitch-users-boun...@lists.freeswitch.org] On Behalf Of Anthony Minessale Sent: 6. december 2009 20:42 To: freeswitch-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, 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 sucessful. What you are asking for is possible but would require many hours of coding just to help solve your problem. You would have to wait a really long time until someone had the time to do it for free or post a bounty for it. Probably about 1k in consulting time. It may be cheaper for you to pay a consultant to set up one of the ways known to work. These are your options as I see it. On Dec 6, 2009 12:20 PM, Lon Baker l...@kickasspixels.commailto:l...@kickasspixels.com wrote: Jon, What version of MySQL are you using? ___ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.orgmailto: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 ___ 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
Re: [Freeswitch-users] Lua and database access to core_db
Yes, exactly my point. Like I said you have several choices be paitent till we have time to code it for free, post a bounty to increase the chance somone will do it from the community, hire someone to set it up for you or keep trying yourself. Did I miss something? On Dec 6, 2009 3:38 PM, Jon Bruel j...@consiglia.dk wrote: The MySQL version is 5.1.37. Well I’m not an expert on every field, and I have no skills in the C, include libraries, and the art of compiling. For this I have to follow the guidelines. But it wouldn’t harm the FS project if it generally became more accessible to the race of non-specialists, which I hereby represent. *Jon Brüel* -- *From:* freeswitch-users-boun...@lists.freeswitch.org [mailto: freeswitch-users-boun...@lists.freeswitch.org] *On Behalf Of *Anthony Minessale *Sent:* 6. december 2009 20:42 *To:* freeswitch-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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org ___ 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
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 ___ 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
Re: [Freeswitch-users] Lua and database access to core_db
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 j...@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_miness...@hotmail.com msn%3aanthony_miness...@hotmail.com GTALK/JABBER/PAYPAL:anthony.miness...@gmail.compaypal%3aanthony.miness...@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:8...@conference.freeswitch.org sip%3a...@conference.freeswitch.org iax:gu...@conference.freeswitch.org/888 googletalk:conf+...@conference.freeswitch.orggoogletalk%3aconf%2b...@conference.freeswitch.org pstn:213-799-1400 ___ 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
Re: [Freeswitch-users] Lua and database access to core_db
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 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: undefined symbol: luaopen_luasql_sqlite, so I’m stuck. So what is a feasible way to manipulate the core database from Lua? I may mention that access to MySQL works perfectly from Lua. Regards Jon ___ 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_miness...@hotmail.com msn%3aanthony_miness...@hotmail.com GTALK/JABBER/PAYPAL:anthony.miness...@gmail.compaypal%3aanthony.miness...@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:8...@conference.freeswitch.org sip%3a...@conference.freeswitch.org iax:gu...@conference.freeswitch.org/888 googletalk:conf+...@conference.freeswitch.orggoogletalk%3aconf%2b...@conference.freeswitch.org pstn:213-799-1400 ___ 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
Re: [Freeswitch-users] Lua and database access to core_db
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 does not sound as a clean solution. Have you any experience about how bad it is to use the ODBC MySQL combination in terms of stability, memory leaks and efficiency? Regards 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
Re: [Freeswitch-users] Lua and database access to core_db
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 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 does not sound as a clean solution. Have you any experience about “how bad” it is to use the ODBC MySQL combination in terms of stability, memory leaks and efficiency? Regards 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 ___ 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