Mailscanner mysql

[Kebold]

Hi everybody,
I'm a new user.

I d'ont know if this is the right section for my answer, if so, I beg your pardon.

So,
I have my relay server with SLES 10, Mailscanner (version 4.60.8 ) and Mailwatch.
I need to clear the mailscanner mysql db with a cronjob because the growing db will soon fill up my disk.
I find this documentation
but I don't understand where I can find the mailwatch_mysql_maintenance.sql file. There isn't in /path/to/mailwatch...
Any help?

Thanks.

[Thrillhouse]

Hi Kebold. Welcome to the forums.

Have you tried locate?

$locate mailwatch_mysql_maintenance.sql

[Kebold]

yes, but without success...
I think I have to create this file, but I'm not sure about that and in the Mailscanner documentation I can't find any help.

Maybe the filename is not the same for the suse disto?

[Thrillhouse]

How about using wildcard characters to broaden the search?

locate "*.sql"

Also, it's possible that your locate db hasn't been updated since these files were created so you may have to run updatedb as root to update it manually. That command may take a minute or two to finish.

[Kebold]

Ok, I Find the solution!

I dont' have the mailwatch_mysql_maintenance.sql file, but in another directory:
/usr/local/src/mailwatch/tools, I have a php script: db_clean.php.
This script work like the .sql file.

Thanks for the answers.