[Freeswitch-users] sqlite DB - help?!

[Geoff Mina]

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/4b61c6de/attachment.html>