<div dir="ltr">Hi Mikko,<div><br></div><div>ACC can be cleaned using the "ngcp-cleanup-tools".</div><div>The best is setup the "cleanuptools" section in the config.yml file.</div><div><br></div><div>Cheers</div><div>Marco</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 2, 2024 at 11:01 AM mikko puurunen <<a href="mailto:mikko.puurunen@outlook.com">mikko.puurunen@outlook.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-1484427994837328036">
<div dir="ltr">
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Hi,</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
It's new install about month ago. No upgrades.</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
All settings pretty much default.</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
If manually start kamailio-proxy service after reboot, it works.</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
But tried just now to replicate this problem same as yesterday and now it works ok.</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
(restored backup before that)</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
But this has happened with few times before exactly same.</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
what is proper way to clean acc, because database is now about 150mb and after 6 months it's over 1gb.</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div id="m_-1484427994837328036appendonsend"></div>
<hr style="display:inline-block;width:98%">
<div id="m_-1484427994837328036divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>Lähettäjä:</b> Marco Capetta via Spce-user <<a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a>><br>
<b>Lähetetty:</b> torstai 2. toukokuuta 2024 10.04<br>
<b>Vastaanottaja:</b> <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a> <<a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a>><br>
<b>Aihe:</b> Re: [Spce-user] [EXTERNAL] kamailio-proxy fails to start after ngcp-cleanup-acc</font>
<div> </div>
</div>
<div>
<div dir="ltr">Hi,
<div><br>
</div>
<div>is it a new deployed system or is it an upgraded one?</div>
<div>In the second case, have you already migrated to KeyDB or are you still running on Redis?</div>
<div><br>
</div>
<div>Can you also check if the KeyDB/Redis is running on your system or not?</div>
<div><br>
</div>
<div>Thank you</div>
<div>Marco</div>
<div><br>
</div>
<div><br>
</div>
</div>
<br>
<div>
<div dir="ltr">On Wed, May 1, 2024 at 7:53 PM mikko puurunen <<a href="mailto:mikko.puurunen@outlook.com" target="_blank">mikko.puurunen@outlook.com</a>> wrote:<br>
</div>
<blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div dir="ltr">
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Hi</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Using Sipwise 11.5.1</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
When running ngcp-cleanup-acc and rebooting. Kamailio-proxy not starting at boot.</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Error entries in kamalio-proxy.log:</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
May 1 19:31:44.101588 spce proxy[1424]: ERROR: db_redis [redis_connection.c:247]: db_redis_connect(): failed to load LUA script to server redis://localhost:6379/23: LOADING KeyDB is loading the dataset in memory</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
May 1 19:31:44.101605 spce proxy[1424]: ERROR: db_redis [redis_connection.c:325]: db_redis_new_connection(): Failed to connect to redis db</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
May 1 19:31:44.101613 spce proxy[1424]: ERROR: <core> [db.c:324]: db_do_init2(): could not add connection to the pool</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
May 1 19:31:44.101624 spce proxy[1424]: ERROR: dialog [dlg_db_handler.c:149]: init_dlg_db(): Unable to connect to the database</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
May 1 19:31:44.101630 spce proxy[1424]: ERROR: dialog [dialog.c:775]: mod_init(): failed to initialize the DB support</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
May 1 19:31:44.101637 spce proxy[1424]: ERROR: <core> [core/sr_module.c:1030]: init_mod(): Error while initializing module dialog (/usr/lib/x86_64-linux-gnu/kamailio/modules/dialog.so)</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Any help would be nice.</div>
</div>
-- <br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com" rel="noreferrer" target="_blank">http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com</a><br>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
<span>-- </span><br>
<div dir="ltr">
<div dir="ltr">
<div><span style="font-size:9px"><br>
</span></div>
<span style="font-size:9px">Sipwise GmbH | an Alcatel-Lucent Company<br>
Leonard-Bernstein-Straße 10 | 1220 Wien<br>
<a rel="noopener" href="mailto:gfuchs@sipwise.com" target="_blank">Email: invoice@sipwise.com</a><br>
Website: <a href="https://www.sipwise.com" target="_blank">https://www.sipwise.com</a><br>
<br>
Particulars according Austrian Companies Code paragraph 14<br>
Geschäftsführer: DI Dr. Gernot Fuchs Sitz: Wien FG: Landesgericht Wien FN: 305595f<br>
Die übermittelten Informationen sind ausschließlich dem Empfänger vorbehalten und können vertrauliches oder privilegiertes Material enthalten. Ein Gebrauch, Weiterleitung oder Verbreitung in jeglicher Form seitens Dritter ist nicht gestattet. Sollten Sie diese
Nachricht irrtümlich erhalten haben, bitten wir Sie, sich mit dem Absender in Verbindung zu setzen und die Nachricht einschließlich der Anlagen zu löschen. Jegliche nicht autorisierte Nutzung dieser E-Mail ist illegal.<br>
Hinweis zum Datenschutz: Sipwise GmbH ist der Schutz Ihrer Daten wichtig. Auch durch die Kommunikation per E-Mail werden personenbezogene Daten ausgetauscht. Erfahren Sie mehr unter: <a rel="noopener" href="http://www.sipwise.com/" target="_blank">www.sipwise.com</a><br>
<br>
Managing Director: DI Dr. Gernot Fuchs HQ: Vienna FG: Vienna Regional Court FN: 305595f<br>
Confidentially notice. This e-mail transmission may contain legally privileged and/or confidential information. Please do not read it if you are not the intended recipient(s). Any use, reproduction or disclosure by any other person is prohibited. If you have
received this e-mail in error, please notify the sender and destroy the original transmission and its attachments without reading or saving it in any manner. Any unauthorized use of this e-mail is illegal.<br>
Note on data protection: Sipwise GmbH attaches great importance to the protection of your data. Personal data is also exchanged through communication by e-mail. Learn more at: <a rel="noopener" href="http://www.sipwise.com/" target="_blank">www.sipwise.com</a></span><br>
</div>
</div>
</div>
</div>
</div></blockquote></div><br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><span style="font-size:9px"><br></span></div><span style="font-size:9px">Sipwise GmbH | an Alcatel-Lucent Company<br>Leonard-Bernstein-Straße 10 | 1220 Wien<br><a rel="noopener" href="mailto:gfuchs@sipwise.com" target="_blank">Email: invoice@sipwise.com</a><br>Website: <a href="https://www.sipwise.com" target="_blank">https://www.sipwise.com</a><br><br>Particulars according Austrian Companies Code paragraph 14<br>Geschäftsführer: DI Dr. Gernot Fuchs Sitz: Wien FG: Landesgericht Wien FN: 305595f<br>Die
übermittelten Informationen sind ausschließlich dem Empfänger
vorbehalten und können vertrauliches oder privilegiertes Material
enthalten. Ein Gebrauch, Weiterleitung oder Verbreitung in jeglicher
Form seitens Dritter ist nicht gestattet. Sollten Sie diese Nachricht
irrtümlich erhalten haben, bitten wir Sie, sich mit dem Absender in
Verbindung zu setzen und die Nachricht einschließlich der Anlagen zu
löschen. Jegliche nicht autorisierte Nutzung dieser E-Mail ist illegal.<br>Hinweis
zum Datenschutz: Sipwise GmbH ist der Schutz Ihrer Daten wichtig. Auch
durch die Kommunikation per E-Mail werden personenbezogene Daten
ausgetauscht. Erfahren Sie mehr unter: <a rel="noopener" href="http://www.sipwise.com/" target="_blank">www.sipwise.com</a><br><br>Managing Director: DI Dr. Gernot Fuchs HQ: Vienna FG: Vienna Regional Court FN: 305595f<br>Confidentially
notice. This e-mail transmission may contain legally privileged and/or
confidential information. Please do not read it if you are not the
intended recipient(s). Any use, reproduction or disclosure by any other
person is prohibited. If you have received this e-mail in error, please
notify the sender and destroy the original transmission and its
attachments without reading or saving it in any manner. Any unauthorized
use of this e-mail is illegal.<br>Note on data protection: Sipwise GmbH
attaches great importance to the protection of your data. Personal data
is also exchanged through communication by e-mail. Learn more at: <a rel="noopener" href="http://www.sipwise.com/" target="_blank">www.sipwise.com</a></span><br></div></div>