[Spce-user] /usr/sbin/acc-cleanup.pl doesn't work - access denied

[Hohl Matthias]

Nobody an idea for me?

 

 

Von: Spce-user <spce-user-bounces at lists.sipwise.com> Im Auftrag von Hohl Matthias
Gesendet: Donnerstag, 22. August 2019 09:43
An: 'Spce-user' <Spce-user at lists.sipwise.com>
Betreff: Re: [Spce-user] /usr/sbin/acc-cleanup.pl doesn't work - access denied

 

Hello…

 

Any hint how to solve this?

Thank you 

 

 

# ngcp-status –all

|   DB: DB localhost:3306 contains 3 users without password: root at spce root at 127.0.0.1 <mailto:root at 127.0.0.1>  root@::1 |

 

 

# /usr/sbin/acc-cleanup.pl

ERROR error: Failed to connect to DB accounting (localhost):Access denied for user 'root'@'localhost' (using password: NO) at /usr/share/perl5/NGCP/Cleanup.pm line 112.

 

 

 

Von: Spce-user <spce-user-bounces at lists.sipwise.com <mailto:spce-user-bounces at lists.sipwise.com> > Im Auftrag von Hohl Matthias
Gesendet: Dienstag, 20. August 2019 23:43
An: 'Spce-user' <Spce-user at lists.sipwise.com <mailto:Spce-user at lists.sipwise.com> >
Betreff: [Spce-user] /usr/sbin/acc-cleanup.pl doesn't work - access denied

 

Hello,

 

we tried to upgrade today from 6.5.3 to 6.5.5 but got this error at # ngcp-status –all

 

|                           |   DB: accounting.cdr is too big on localhost:3306 for an upgrade: 6429995 rows |

|                           |   DB: DB localhost:3306 contains 3 users without password: root at spce root at 127.0.0.1 <mailto:root at 127.0.0.1>  root@::1 |

 

 

I tired to start the acc-cleanup tool manually but got this error:

 

# /usr/sbin/acc-cleanup.pl

ERROR error: Failed to connect to DB accounting (localhost):Access denied for user 'root'@'localhost' (using password: NO) at /usr/share/perl5/NGCP/Cleanup.pm line 112.

 

 

I really don’t know what happened here, cause we didn’t change any DB passwords or whatever.

On our test spce installation I can run acc-cleanup.pl without a problem.

 

How can I fix this?

Thanks for your help.

 

Mit freundlichen Grüßen,
Matthias Hohl

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20190826/b1b080d7/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5585 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20190826/b1b080d7/attachment-0002.p7s>