[Freeswitch-users] sql-lite db

[Zvonimir Bužanić]

Hi, we had serious issues with sqlite. Database would crash and we had to make scripts to delete databasem then restart FS.
But in the end the solution is to use Postgres database. It works flawless. No crashes anymore.

BR, Zvonimir

From: FreeSWITCH-users <freeswitch-users-bounces at lists.freeswitch.org> On Behalf Of Kakiman Expert
Sent: 05. siječnja 2023. 15:10
To: freeswitch-users at lists.freeswitch.org
Subject: [Freeswitch-users] sql-lite db

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Hello,

Since a few weeks, i am using maria-db with FS 1.10.6   (1.10.6-release-18-1ff9d0a60e~64bit)

Two questions :

1/ I see that I don't have the same list of db in my both FS servers, do you know what are they used for and if they are mandatory

/var/lib/freeswitch/db/call_limit.db
/var/lib/freeswitch/db/core.db
/var/lib/freeswitch/db/fifo.db
/var/lib/freeswitch/db/json.db
/var/lib/freeswitch/db/sofia_reg_external.db
/var/lib/freeswitch/db/sofia_reg_internal.db

2/ sometimes, some database get corrupted and FS is down until we delete the corrupted DB
do you know why it happens and if there is a solution of a better DB to use with FS ?

thanks
franck

This communication is for informational purposes only. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Present message and any attached files may be or contain privileged information and is the property exclusive of ASSECO SEE CAPITAL GROUP. This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable law. The information contained in this message is solely intended for the physical or legal person to whom it is addressed and to the authorized persons for receiving it. In the case you are not the intended recipient or the authorized person to receive this message, we inform that disclosure, duplicate, distribution or taking up any actions on information contained in this message are strictly forbidden and are under civil and legal responsibility. In case you received it by error, you are requested to notify the sender and to destroy the original e-mail message from your system. Opinions, conclusions or any other information contained into this message, which are not related to ASSECO SEE CAPITAL GROUP activity must not be understood to be expressed or should be endorsed by ASSECO SEE CAPITAL GROUP. The interpretation expressed in the present message did not reflect ASSECO SEE CAPITAL GROUP opinion.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20230105/254ba539/attachment-0001.html>