[Spce-user] acc-cleanup not working anymore

[Henk]

Hi all,

I received no reaction at all on the acc-cleanup problem, so I 
investigated this a little more.
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 %]

Everything is working now, so please change this in the next release! It 
saves a lot of disk space and also memory!

Henk

On 19-5-2019 12:19, Henk wrote:
>
> Hi,
>
> My database is taking more memory every day. I found that acc-cleanup 
> is not working. Maybe this is also related to the disk full errors.
>
> Manually starting acc-cleanup I get this message:
>
> root at spce:/usr# 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.
>
> In the config file a user and password is present (username = 
> dbcleaner). Maybe this script depends on having no root password?
>
> Regards,
>
> Henk
>
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20190626/8e9e860c/attachment.html>