Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[Freeswitch-users] sql-lite db


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users
View previous topic :: View next topic  
Author Message
freeswitch-users at li...
Guest





PostPosted: Thu Jan 05, 2023 11:12 am    Post subject: [Freeswitch-users] sql-lite db Reply with quote

------ Start of attached email. Subject: RE: [Freeswitch-users] sql-lite db ------
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@lists.freeswitch.org> On Behalf Of Kakiman Expert
Sent: 05. siječnja 2023. 15:10
To: freeswitch-users@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.

------ End of attached email ------
_________________________________________________________________________

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@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com
Back to top
gregor at infomedia.si
Guest





PostPosted: Thu Jan 05, 2023 3:00 pm    Post subject: [Freeswitch-users] sql-lite db Reply with quote

I think we are the only one in the world, but also with MS SQL server it works great. 

On Thu, 5 Jan 2023, 16:50 Zvonimir Bužanić via FreeSWITCH-users, <freeswitch-users@lists.freeswitch.org (freeswitch-users@lists.freeswitch.org)> wrote:

Quote:



---------- Forwarded message ----------
From: "Zvonimir Bužanić" <Zvonimir.Buzanic@asseco-see.hr (Zvonimir.Buzanic@asseco-see.hr)>
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org (freeswitch-users@lists.freeswitch.org)>
Cc: 
Bcc: 
Date: Thu, 5 Jan 2023 15:48:49 +0000
Subject: RE: [Freeswitch-users]  sql-lite db

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@lists.freeswitch.org (freeswitch-users-bounces@lists.freeswitch.org)> On Behalf Of Kakiman Expert
Sent: 05. siječnja 2023. 15:10
To: freeswitch-users@lists.freeswitch.org (freeswitch-users@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.



---------- Forwarded message ----------
From: "Zvonimir Bužanić via FreeSWITCH-users" <freeswitch-users@lists.freeswitch.org (freeswitch-users@lists.freeswitch.org)>
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org (freeswitch-users@lists.freeswitch.org)>
Cc: 
Bcc: 
Date: Thu, 05 Jan 2023 07:50:01 -0800 (PST)
Subject: Re: [Freeswitch-users] sql-lite db
_________________________________________________________________________

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@freeswitch.com (sales@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@lists.freeswitch.org (FreeSWITCH-users@lists.freeswitch.org)
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services