Hello, Just out of curiosity, has anyone managed to connect to MySQL via Handlersocket ? If yes, would appreciate tips. Cheers, Abdul Hakeem From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of David Villasmil Govea Sent: Wednesday, January 14, 2015 2:06 PM To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] Database query from dialplan hello, 1- Can freeswitch.dbh be used directly as core dsn (without ODBC Like the DSN used at freeswitch startup). If yes would it support connection pooling? I believe you must use odbc. As someone said before, yes, it will use connection pooling. 2- Can freeswitch.dbh be used to connect to some different database (Then core database) in lua scripts? Yes, you can connect to any db. In the case of MySQL it's like so: /etc/odbc.ini [freeswitch] Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so SERVER = [SERVER-IP] PORT = 3306 DATABASE = [DATABASE] OPTION = 67108864 USER = [USER] PASSWORD = [PASSWORD] [my_other_db] Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so SERVER = [SERVER-IP] PORT = 3306 DATABASE = [DATABASE] OPTION = 67108864 USER = [USER] PASSWORD = [PASSWORD] /etc/odbcinst.ini [MySQL] Description = MySQL driver Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so UsageCount = 1 FileUsage = 1 Threading = 0 function dbConnect() conn = freeswitch.Dbh("odbc://my_other_db:user:passw"); assert(conn:connected()) end On Wed, Jan 14, 2015 at 8:24 AM, John Nash <john.nash778@gmail.com> wrote: Thank you. I have compiled freeswitch with postgresql core as per https://freeswitch.org/confluence/display/FREESWITCH/PostgreSQL+in+the+core I read many documentation pages but am still confused on few points... 1- Can freeswitch.dbh be used directly as core dsn (without ODBC Like the DSN used at freeswitch startup). If yes would it support connection pooling? 2- Can freeswitch.dbh be used to connect to some different database (Then core database) in lua scripts? On Wed, Jan 14, 2015 at 2:06 AM, Bote Man <bote_radio@botecomm.com> wrote: Surely you mean the Confluence pages at https://freeswitch.org/confluence/display/FREESWITCH/Lua+freeswitch+dbh https://freeswitch.org/confluence/display/FREESWITCH/Databases (formerly DSN) That nasty old wiki is deprecated, I don't know why people are still linking to it. Bote From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Steven Ayre Sent: Tuesday, 13 January, 2015 09:19 To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] Database query from dialplan Use freeswitch.Dbh (https://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh) It's stable and uses FreeSWITCH's connection pools. It supports any FreeSWITCH DSNs - so sqlite, ODBC or postgresql native driver. https://wiki.freeswitch.org/wiki/DSN _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com 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 _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com 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 -- DVG -- Imagination is more important than knowledge Albert Einstein