#!/bin/bash

DIR=`dirname "$0"`;
MYSQL_LOG_DIR="/var/log/mysql";

# "Access denied for user % (using password %)"
#	SELECT * FROM `mysql`.`general_log` WHERE `argument` LIKE 'Access denied for user % (using password %)'
#	-> Dies gibt es in den Varianten "Connect" und "Init DB".
# "%Host % is not allowed to connect to this MySQL server%"
#	Wird nicht geloggt.

TAB=`echo -ne \\t`;

# Lock both:
"$DIR/addtimestamp-daemon.sh" "$MYSQL_LOG_DIR/mysql.log" "$MYSQL_LOG_DIR/auth.log" "Access denied for user"

# Lock only Connect attempts
#"$DIR/addtimestamp-daemon.sh" "$MYSQL_LOG_DIR/mysql.log" "$MYSQL_LOG_DIR/auth.log" "Connect${TAB}Access denied for user"

# Lock database attempts
#"$DIR/addtimestamp-daemon.sh" "$MYSQL_LOG_DIR/mysql.log" "$MYSQL_LOG_DIR/auth.log" "Init DB${TAB}Access denied for user"