[Freeswitch-users] convert sqlite to mysql
Nathan Neulinger
nneul at mst.edu
Fri Feb 14 23:44:05 UTC 2020
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 at 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 at gmail.com
> <mailto:david.villasmil.work at 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 at gmail.com <mailto:mrjoli021 at 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 at gmail.com <mailto:gmaruzz at 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 at gmail.com <mailto:mrjoli021 at 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 at freeswitch.com <mailto:sales at 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 at lists.freeswitch.org <mailto:FreeSWITCH-users at 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 at freeswitch.com <mailto:sales at 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 at lists.freeswitch.org <mailto:FreeSWITCH-users at 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 at freeswitch.com <mailto:sales at 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 at lists.freeswitch.org <mailto:FreeSWITCH-users at 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 at gmail.com <mailto:david.villasmil.work at 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 at freeswitch.com <mailto:sales at 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 at lists.freeswitch.org <mailto:FreeSWITCH-users at 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 at 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 at 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 at mst.edu
Missouri S&T Information Technology (573) 341-6679
System Administrator - Architect (573) 612-1412
System and Desktop Infrastructure Team Manager
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20200214/02633694/attachment-0001.html>
More information about the FreeSWITCH-users
mailing list