[Freeswitch-users] convert sqlite to mysql

Joli Martinez mrjoli021 at gmail.com
Fri Feb 14 23:31:43 UTC 2020


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20200214/747a702c/attachment-0001.html>


More information about the FreeSWITCH-users mailing list