<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Ensure you have at least 80GB of free space on disk, then open a
<a moz-do-not-send="true"
href="https://linuxize.com/post/how-to-use-linux-screen/"><font
face="monospace">screen</font></a> session and run this
command:</p>
<p><font face="monospace">ngcp-cleanup-cdr-files</font></p>
<p>This command will take a very long time to execute if there is no
previous CDR maintenance.<br>
</p>
<p>Don't do it on production time.<br>
</p>
<p>Regards!<br>
</p>
<div class="moz-cite-prefix">On 10/04/23 1:49 p. m., Dhaniels Nieto
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAMvYiGGM+ntyqh7sbXY9jK6wnowrvw9_Pc7FbroQYoUJLfuagA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hello, I hope you are doing well.<br>
today i logged into my system to verify that everything is
working as expected, and then try to update to a more recent
version.<br>
after entered the command: ngcp-status i see a warning wich
says:<br>
"accounting.cdr is too big on localhost:3306 for an upgrade:
6945390 rows"<br>
and the HDD is almost full.<br>
This server has been running with no issues for more than 3
years.<br>
<br>
How can I fix this problem?<br>
<br>
here is the full output:<br>
<br>
root@grml:~# ngcp-status<br>
+---------------------------+----------------------------------------------
2023-04-10 20:39:09 -+<br>
| 149.XX.XX.XX | NGCP: CE mr9.1.1 nodes
setup [ ] |<br>
| grml | NGCP: subscribers:189
locations:121 calls:49 |<br>
| grml. | OS: buster (10.7)
4.19.0-13-amd64 SMP (ext4) |<br>
| (PRODUCTION - ACTIVE) | CPU: 8 = 2 x Common KVM processor
(HT) |<br>
| | HW: Standard PC (i440FX + PIIX,
1996) by QEMU |<br>
| | BIOS: rel-1.16.1-0-g3208b0...
(04/01/2014) by SeaBIOS |<br>
| | RAM: 15Gi (used 13%/cache 79%)
kamailio[7.9%] influxd[3.1%] |<br>
| | LA: system load OK: 0.39 0.79
0.81 |<br>
| | DISK: /dev/sda [HDD] /dev/sr0
[CDROM] |<br>
| ! DISK: space used /[91%]
|<br>
| | DISK: inodes in use /[4%]
|<br>
| | CFG: [5aaf0b2] net (6 weeks ago)
|<br>
| ? NGCP: allowed root remote SSH by
password, use 'prohibit-password' |<br>
| ? DB: accounting.cdr is too big on
localhost:3306 for an upgrade: 6945390 rows |<br>
| | MODs: License OFF, Fax ON,
|<br>
+-------------------5 sec---+-----
---------------------------------------9.1.1.1+0~mr9.1.1.1---+<br>
<br clear="all">
<div><br>
</div>
<span class="gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr"><i>Dhaniels Nieto</i><i><br>
+1 787 7108591</i></div>
<div dir="ltr"><i>+57 320 5153851<br>
</i></div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
</blockquote>
<div class="moz-signature">-- <br>
<table style="width: 800px; font-size: 10pt; font-family: Arial,
sans-serif; line-height:normal; table-layout:auto"
cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="width:400px" colspan="2" width="400"> <span
style="font-size:12pt; font-family: Arial, sans-serif;
font-weight: bold; color: #000000;">Oscar Bello</span> </td>
</tr>
<tr>
<td style="width:400px; padding-top:5px" colspan="2"
width="400"> <span style="font-size:10pt; font-family:
Arial, sans-serif; color: #888888; padding-bottom:5px;">Departamento
de Telefonía</span> </td>
</tr>
<tr>
<td style="width:400px; padding-top:10px" colspan="2"
width="400"> <span><a
href="https://www.facebook.com/Dialapplet"
target="_blank"><img alt="Facebook icon"
src="cid:part2.2A2F89F7.24302CD8@dialapplet.com"
style="border:0; height:20px; width:20px" width="19"
height="19" border="0"></a> </span><span><a
href="https://www.linkedin.com/company/dialapplet"
target="_blank"><img alt="LinkedIn icon"
src="cid:part4.D337855C.2A6E8157@dialapplet.com"
style="border:0; height:20px; width:20px" width="19"
height="19" border="0"></a> </span><span><a
href="https://twitter.com/Dialapplet" target="_blank"><img
alt="Twitter icon"
src="cid:part6.56C17A09.A0276043@dialapplet.com"
style="border:0; height:20px; width:20px" width="19"
height="19" border="0"></a> </span><span><a
href="https://www.dialapplet.com" target="_blank"><img
alt="Youtube icon"
src="cid:part8.8F2BDAD3.221180A5@dialapplet.com"
style="border:0; height:20px; width:20px" width="19"
height="19" border="0"></a> </span><span><a
target="_blank" href="mailto:info@dialapplet.com"><img
alt="Instagram icon"
src="cid:part10.4F1C1415.20B478DC@dialapplet.com"
style="border:0; height:20px; width:20px" width="19"
height="19" border="0"></a></span> <span></span> </td>
</tr>
<tr>
<td style="/*! padding-right:0px; */ border-right:1px solid
#385cc7;height: 30px;" width="270" valign="top"> <span> <a
href="https://www.dialapplet.com/" target="_blank"><img
alt="Logo"
src="cid:part12.B5A7AD5D.74D21480@dialapplet.com"
style="border:0;max-width:400px;border-top-width:
0px;border-top-style: solid;padding-top: 17px;"
width="250" border="0"></a> </span> </td>
<td style="padding-left:15px;padding-right:15px;
vertical-align: top;padding-top: 5px; border-right:1px
solid #385cc7;white-space:nowrap;" width="190"
valign="top"> <span style="font-family: Arial,
sans-serif; color:#000000;"><span
style="font-weight:bold;">T: </span>(+57) 601 914
4999<br>
</span> <span style="font-family: Arial, sans-serif;
color:#000000;"><span style="font-weight:bold;">E:</span>
<a class="moz-txt-link-abbreviated" href="mailto:oscar.bello@dialapplet.com">oscar.bello@dialapplet.com</a><br>
</span> <span><span style="font-weight:bold;">W: </span>
<a target="_blank" href="https://www.dialapplet.com"> <span
style="font-family: Arial, sans-serif;
color:#0645AD">www.dialapplet.com</span></a></span>
</td>
<td style="padding-left:15px; vertical-align:
top;padding-top: 5px; width:auto" valign="top"> <span
style="font-family: Arial, sans-serif; color:#000000;">
<span style="font-weight:bold;">Colombia</span><br>
</span> <span style="font-family: Arial, sans-serif;
color:#000000;">110221 Bogotá, D.C.<br>
</span> <span style="font-family: Arial, sans-serif;
color:#000000;">Calle 99 No. 10 - 19 Piso 4<br>
</span> </td>
</tr>
</tbody>
</table>
<p style="width: 800px; font-size: 7pt; font-family: Arial,
sans-serif; line-height:normal;color:#868686;"> AVISO DE
CONFIDENCIALIDAD<br>
Le informamos, como destinatario de este mensaje, que el correo
electrónico vía Internet no permite asegurar la confidencialidad
de los mensajes transmitidos ni su integridad o correcta
recepción. Si no consintiera la utilización del correo
electrónico vía Internet, rogamos nos lo comunique de forma
inmediata. Este mensaje va dirigido de manera exclusiva a su
destinatario y puede contener información confidencial cuya
divulgación está prohibida por la ley. Si ha recibido este
mensaje por error, le rogamos nos lo comunique de forma
inmediata por esta misma vía y proceda a su eliminación, así
como a la de cualquier documento adjunto al mismo. Asímismo, si
no es el destinatario del mensaje, se le informa de que su
lectura, copia, distribución y utilización, así como la de
cualquier documento adjunto, sea cual sea su finalidad, están
prohibidas.<br>
CONFIDENTIALITY WARNING<br>
We hereby inform you, as addressee of this message, that
Internet e-mail neither guarantees the confidentiality nor the
completeness or proper receipt of the messages sent. If you do
not consent to the use of Internet e-mail, please notify us
immediately. This message is intended exclusively for its
addressee and may contain confidential information protected
from disclosure by law. If you have received this message in
error, please immediately notify us via e-mail and delete it and
any attachment. If you are not the addressee indicated in this
message, please be informed that any reading, copy, distribution
or use of it or its attachments, for any purpose, is forbidden.
</p>
</div>
</body>
</html>