[Freeswitch-users] sqlite DB - help?!

[Geoff Mina]

 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180102/bd72e37a/attachment-0001.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/20180102/bd72e37a/attachment-0001.png>