[Freeswitch-users] sqlite DB - help?!

[Ítalo Rossi]

Do you want to contribute to our documentation by clarifying it? I can give
you access to the Confluence editors.
Em qua, 3 de jan de 2018 às 00:22, Geoff Mina <gmina at connectfirst.com>
escreveu:

>  I finally figured it out.  I didn't realize that I needed a specific
> odbc-dsn parameter in both the internal and external sip_profiles.  Adding
> the following to both of my profiles seems to have resolved the issues.
>
>  <param name="odbc-dsn" value="freeswitch:freeswitch:freeswitch"/>
>
> I wish the documentation on the various ODBC settings was a little more
> clear.  Anyway... all good now, we are no longer relying on corruption
> prone SQLite for our registrations.
>
> Thanks,
> Geoff
>
>
> *GEOFF MINA*Chief Executive Officer
> Connect First / Contact Center Solutions, Built Better.
>
> 3101 Iris Ave #200, Boulder, CO 80301
> 720.335.5924 <%28720%29%20335-5924>
> gmina at connectfirst.com / www.connectfirst.com <http://connectfirst.com/>
>
>  [image:
> https://docs.google.com/uc?export=download&id=0B5b6KnVfm9lJTlFrQzRVUjJ2ZVE&revid=0B5b6KnVfm9lJUXpUMTFEbGJvaktwN1p5ejM3YTFkdWVWNzBzPQ]
>
>  This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they are
> addressed. If you have received this email in error please notify the
> system manager.
>
> On Tue, Jan 2, 2018 at 5:26 PM, Geoff Mina <gmina at connectfirst.com> wrote:
>
>> Greetings,
>> I have a freeswitch installation that is configured to use MySQL (via
>> ODBC) in switch.xml.  Today we had one of our freeswitch hosts go out of
>> service with this error:
>>
>> *2018-01-03 00:14:51.340034 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR
>> [database disk image is malformed]*
>> *delete from sip_registrations where sip_user='rcampos1' and
>> sip_host='10.201.0.94'*
>>
>> Through some searching, we determined that is the result of the sqlite db
>> becoming corrupt.  There were no power events, but it simply stopped
>> working.  Now... I don't even want to use sqllite.  We have MySQL
>> configured and is working properly.  Here is our config from switch.xml
>>
>>     <param name="core-db-dsn" value="freeswitch:freeswitch:freeswitch" />
>>     <param name="auto-create-schemas" value="true"/>
>>     <param name="auto-clear-sql" value="true"/>
>>     <param name="core-dbtype" value="MYSQL"/>
>>
>> The registrations and calls ARE showing up in MySQL, so the ODBC
>> connection is working.  Why would Freeswitch continue to use SQLite even
>> though we have configured the core to use MySQL?  Even after clearing out
>> the /freeswtich/db directory, upon restart, the following files show up
>> again.  It's as if Freeswitch is writing to both SQLite and MySQL.
>>
>> -rw-r--r-- 1  14K Jan  3 00:16 call_limit.db
>> -rw-r--r-- 1 5.0K Jan  3 00:16 fifo.db
>> -rw-r--r-- 1  93K Jan  3 00:16 sofia_reg_external.db
>> -rw-r--r-- 1  99K Jan  3 00:26 sofia_reg_internal.db
>>
>> Any help would be greatly appreciated.
>>
>> Thanks,
>> Geoff
>>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180103/fceb2572/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 4537 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180103/fceb2572/attachment.png>