[Freeswitch-users] convert sqlite to mysql
David Villasmil
david.villasmil.work at gmail.com
Sat Feb 15 01:00:55 UTC 2020
Even better. Upgrade to 1.10 if you can and use MySQL in the core
(mod_mariadb), you MUST also enable mod_pgsql even if you won’t use it. The
simply configure the DSN in switch.conf. No odbc needed.
On Fri, 14 Feb 2020 at 18:59, Nathan Neulinger <nneul at mst.edu> wrote:
> 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> 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> 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>
>>> 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>
>>>> 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
>>>>> 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
>>>>
>>>>
>>>>
>>>> --
>>>> 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
>>>> 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
>>>
>>> _________________________________________________________________________
>>>
>>> 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
>>
>> --
>> Regards,
>>
>> David Villasmil
>> email: 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
>> 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
>
>
> _________________________________________________________________________
>
> 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 Servicessales at freeswitch.comhttps://freeswitch.com
>
> Official FreeSWITCH Siteshttps://freeswitch.com/osshttps://freeswitch.org/confluencehttps://cluecon.com
>
> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttps://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
>
> _________________________________________________________________________
>
> 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
--
Regards,
David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20200214/6d123888/attachment-0001.html>
More information about the FreeSWITCH-users
mailing list