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

[Hohl Matthias]

Henk Plessius got the idea and solved it like this:

 

 

I found the following bug:

In acc-cleanup.conf username and password are defined, but Cleanup.pm uses user and pass for the database connection.

Of course if the root DB user has no password defined there seems to be no error.

 

A quick workaround is using acc-cleanup.conf.customtt replacing username and password lines:

 

user = [% credentials.mysql.cleanuptools.u %]
pass = [% credentials.mysql.cleanuptools.p %]

 

 

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

 

Nobody an idea for me?

 

 

Von: Spce-user <spce-user-bounces at lists.sipwise.com <mailto: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 <mailto: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/ab2204a4/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/ab2204a4/attachment-0002.p7s>