<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><font face="monospace">ngcp-cleanup-acc</font><br>
</p>
<div class="moz-cite-prefix">On 10/04/23 3:28 p. m., Dhaniels Nieto
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAMvYiGFyzniT_1tE4FhqB4eKuF7tcpp5TuLgQL4GVJB3yYrMmg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">
<blockquote type="cite">
<div dir="ltr">Thanks Oscar, but the issue still persists,
and looks like the table "cdr" of the "accounting"
database is the main reason for the error.<br>
</div>
</blockquote>
<blockquote type="cite">
<div dir="ltr">any other solution?<br>
<br>
Regards!</div>
<div dir="ltr"><br class="gmail-Apple-interchange-newline">
--<br>
<div dir="ltr">
<div dir="ltr"><i>Dhaniels Nieto</i><i><br>
+1 787 7108591</i></div>
<div dir="ltr"><i>+57 320 5153851</i></div>
</div>
</div>
</blockquote>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">El lun, 10 abr 2023 a las
15:18, Oscar Javier Bello Pérez (<<a
href="mailto:oscar.bello@dialapplet.com"
moz-do-not-send="true">oscar.bello@dialapplet.com</a>>)
escribió:<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>
<p>Ensure you have at least 80GB of free space on disk,
then open a <a
href="https://linuxize.com/post/how-to-use-linux-screen/"
target="_blank" moz-do-not-send="true"><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>On 10/04/23 1:49 p. m., Dhaniels Nieto wrote:<br>
</div>
<blockquote type="cite">
<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>-- </span><br>
<div dir="ltr">
<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></fieldset>
</blockquote>
<div>-- <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:rgb(0,0,0)">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:rgb(136,136,136);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" moz-do-not-send="true"><img
alt="Facebook icon"
src="cid:part3.75B41697.2CE9E535@dialapplet.com"
style="border: 0px; height: 20px; width:
20px;" class="" width="19" height="19"
border="0"></a> </span><span><a
href="https://www.linkedin.com/company/dialapplet"
target="_blank" moz-do-not-send="true"><img
alt="LinkedIn icon"
src="cid:part5.911D3321.C16DD3A4@dialapplet.com"
style="border: 0px; height: 20px; width:
20px;" class="" width="19" height="19"
border="0"></a> </span><span><a
href="https://twitter.com/Dialapplet"
target="_blank" moz-do-not-send="true"><img
alt="Twitter icon"
src="cid:part7.17B0B05E.A8CAB7AA@dialapplet.com"
style="border: 0px; height: 20px; width:
20px;" class="" width="19" height="19"
border="0"></a> </span><span><a
href="https://www.dialapplet.com"
target="_blank" moz-do-not-send="true"><img
alt="Youtube icon"
src="cid:part9.BA846248.0D1ADC47@dialapplet.com"
style="border: 0px; height: 20px; width:
20px;" class="" width="19" height="19"
border="0"></a> </span><span><a
href="mailto:info@dialapplet.com"
target="_blank" moz-do-not-send="true"><img
alt="Instagram icon"
src="cid:part11.54E2BCF3.414282CC@dialapplet.com"
style="border: 0px; height: 20px; width:
20px;" class="" width="19" height="19"
border="0"></a></span> <span></span> </td>
</tr>
<tr>
<td style="border-right:1px solid
rgb(56,92,199);height:30px" width="270"
valign="top"> <span> <a
href="https://www.dialapplet.com/"
target="_blank" moz-do-not-send="true"><img
alt="Logo"
src="cid:part13.635D2FE8.26847120@dialapplet.com"
style="border-width: 0px;
border-right-style: initial;
border-bottom-style: initial;
border-left-style: initial; border-color:
initial; border-image: initial; max-width:
400px; border-top-style: solid;
padding-top: 17px;" class="" 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 rgb(56,92,199);white-space:nowrap"
width="190" valign="top"> <span
style="font-family:Arial,sans-serif;color:rgb(0,0,0)"><span
style="font-weight:bold">T: </span>(+57)
601 914 4999<br>
</span> <span
style="font-family:Arial,sans-serif;color:rgb(0,0,0)"><span
style="font-weight:bold">E:</span> <a
href="mailto:oscar.bello@dialapplet.com"
target="_blank" moz-do-not-send="true">oscar.bello@dialapplet.com</a><br>
</span> <span><span style="font-weight:bold">W:
</span> <a href="https://www.dialapplet.com"
target="_blank" moz-do-not-send="true"> <span
style="font-family:Arial,sans-serif;color:rgb(6,69,173)">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:rgb(0,0,0)">
<span style="font-weight:bold">Colombia</span><br>
</span> <span
style="font-family:Arial,sans-serif;color:rgb(0,0,0)">110221
Bogotá, D.C.<br>
</span> <span
style="font-family:Arial,sans-serif;color:rgb(0,0,0)">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:rgb(134,134,134)">
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>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
<span class="gmail_signature_prefix">--</span></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:part17.FB57F5BB.6B3559A3@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:part19.74A0E1E0.813AE46F@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:part21.0A8CE265.56D6654C@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:part23.58D53817.DA1573A8@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:part25.383CAB7A.B4EAA39B@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:part27.80716ED8.10F5AF07@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>