______ Configuration of Logrotate ______
To configure logrotate use the following snippet on the
logrotate configuration part of your wished logfile

---- Snipp ----

postrotate
	for PROCESS in $(ls /var/run/mailtrace.*.pid) ; do
		kill $(cat ${PROCESS})
	done
	
	sleep 3
	
	/opt/heinlein-elements/mailtrace/daemon/mailtrace.pl
endscript

---- Snapp ----

Alternatively you can use the supplied cron script mailtraced.logrotate and put only
one line in the logrotate configuration file.

______ Initial database setup ______

---- MySQL ----
mysql -e "CREATE DATABASE \`mailtrace\`;" -u root -p
mysql -e "CREATE USER 'mailtrace'@'%' IDENTIFIED BY 'xxxxx';" -u root -p
mysql -e "GRANT USAGE ON *.* TO 'mailtrace'@'%' IDENTIFIED BY 'xxxxx' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;" -u root -p
mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON \`mailtrace%\`.* TO 'mailtrace'@'%' WITH GRANT OPTION;" -u root -p

---- PostgreSQL ----
su - postgres
echo "create user mailtrace with password 'xxxxx';"  | psql
createdb --owner=mailtrace mailtrace

______ Package dependencies ______
SuSe:
	perl-Readonly
	perl-Cache-Memcached
	perl-Config-IniFiles
	perl-DBD-Pg
	perl-DateTime
	
Debian:
	libreadonly-perl
	
	