I just finished getting out of using mysql with ODBC driver on FS. If you have the option, strongly recommend moving to the mariadb support in 1.8. I had an .odbcinst.ini in freeswitch user homedir or possibly /etc/odbcinst.init file containing: [freeswitch] Driver = /local/fslibs/install/lib/libmyodbc5a.so (path to your libmyodbc lib file) SERVER = serverfqdn (this is optional) PORT = 3306 DATABASE = databasename (optional) OPTION = 67108864 Then the dsn I previously used was: odbc://INSTANCE:USER:PASSWORD where INSTANCE = the "freeswitch" in the odbcinst.init, USER = the userid on database, PASSWORD = password on db mariadb support is much simpler, no extra setup, just use dsn like: mariadb://Server=serverfqdn;Database=databasname;Uid=userid;Pwd=password;: and yes, you want that ;: at the end) -- Nathan On 2/14/20 5:31 PM, Joli Martinez wrote:
I have tried the following code in the switch.conf.xml file and did not work. I went ahead and have followed the instructions in the link below, but I can't seem to access the "Compile FreeSWITCH with ODBC Support <https://freeswitch.org/confluence/pages/editpage.action?pageId=6586653#UsingODBCinthecore-CompileFreeSWITCHwithODBCsupport>" section. We are running freeswitch 1.6.19 and it was originally installed from the Debian repos. (yes I know it is an old build and we will upgrade, but it shouldn't affect what I am trying to do at the moment)
<param name="core-db-dsn" value="odbc://DRIVER=mysql;SERVER=<ip>;UID=devsca01;PWD=<password>;DATABASE=devsca01">
https://freeswitch.org/confluence/display/FREESWITCH/Using+ODBC+in+the+core
I have created a remote DB and gave it the proper permissions. When I tested it, it appears to connect, but not sure where to go from here.
root@dev-sca01a:/etc/freeswitch# isql -v devsca01 +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL>
On Fri, Feb 14, 2020 at 12:36 PM David Villasmil <david.villasmil.work@gmail.com <mailto:david.villasmil.work@gmail.com>> wrote:
That’s right. You don’t need to do anything else. Just make sure the user you setup in freeswitch has rights to create db, tables, etc.
On Fri, 14 Feb 2020 at 11:59, Joli Martinez <mrjoli021@gmail.com <mailto:mrjoli021@gmail.com>> wrote:
Hello,
So if I understand correctly. I will create a new mysql DB, update the switch.conf.xml and restart FS.
Is that correct?
On Fri, Feb 14, 2020 at 10:30 AM Giovanni Maruzzelli <gmaruzz@gmail.com <mailto:gmaruzz@gmail.com>> wrote:
Hello,
you don't need to import anything, all tables are created runtime, and they are for internal FreeSWITCH usage, so FS will populate them, you do not need to do anything. Obviously, you will lose all registrations, until phones re-register.
Do a lab, and experiment a little to get the Knack of it
-giovanni
On Fri, Feb 14, 2020 at 4:03 PM Joli Martinez <mrjoli021@gmail.com <mailto:mrjoli021@gmail.com>> wrote:
Hello,
We have several freeswitch boxes that are running sqlite. We have outgrown this and need to move the DB to mySQL. Not sure how to import it, or if there is a procedure already in place for this. What would be the best option for this?
let me know _________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com <mailto:sales@freeswitch.com> https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
-- Sincerely,
Giovanni Maruzzelli OpenTelecom.IT cell: +39 347 266 56 18
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com <mailto:sales@freeswitch.com> https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com <mailto:sales@freeswitch.com> https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
-- Regards,
David Villasmil email: david.villasmil.work@gmail.com <mailto:david.villasmil.work@gmail.com> phone: +34669448337 _________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com <mailto:sales@freeswitch.com> https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://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 https://freeswitch.com
-- ------------------------------------------------------------ Nathan Neulinger nneul@mst.edu Missouri S&T Information Technology (573) 341-6679 System Administrator - Architect (573) 612-1412 System and Desktop Infrastructure Team Manager