# Sagan mysql.rules
# Copyright (c) 2009-2020. Quadrant Information Security <www.quadrantsec.com>
# All rights reserved.
#
# Please submit any custom rules or ideas to sagan-submit@quadrantsec.com or the sagan-sigs mailing list
#
#*************************************************************
#  Redistribution and use in source and binary forms, with or without modification, are permitted provided that the
#  following conditions are met:
#
#  * Redistributions of source code must retain the above copyright notice, this list of conditions and the following
#    disclaimer.
#  * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the
#    following disclaimer in the documentation and/or other materials provided with the distribution.
#  * Neither the name of the nor the names of its contributors may be used to endorse or promote products derived
#    from this software without specific prior written permission.
#
#  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS AS IS AND ANY EXPRESS OR IMPLIED WARRANTIES,
#  INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
#  DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
#  SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
#  SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
#  WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE
#  USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
#
#*************************************************************
#
# see: http://dev.mysql.com/doc/refman/5.1/en/error-log.html
# 
# program: mysqld|MySQL handles *nix and Windows MySQL systems

alert any $EXTERNAL_NET any -> $HOME_NET any (msg:"[MYSQL] Access denied for user"; content: "Access denied for user"; default_proto: tcp; default_dst_port: $MYSQL_PORT; classtype: unsuccessful-user; program: mysqld|MySQL; reference: url,wiki.quadrantsec.com/bin/view/Main/5000149; sid: 5000149; rev:4;)
alert any $EXTERNAL_NET any -> $HOME_NET any (msg:"[MYSQL] Access denied for user"; pcre: "/\d+ \S+ \d+ Connect/i"; default_proto: tcp; default_dst_port: $MYSQL_PORT; classtype: unsuccessful-user; program: mysqld|MySQL; reference: url,wiki.quadrantsec.com/bin/view/Main/5000150; sid: 5000150; rev:4;)
#alert any $EXTERNAL_NET any -> $HOME_NET any (msg:"[MYSQL] User disconnected from database"; pcre: "/\d+ \S+ \d+ Quit/i"; default_proto: tcp; default_dst_port: $MYSQL_PORT; classtype: not-suspicious; program: mysqld|MySQL; reference: url,wiki.quadrantsec.com/bin/view/Main/5000151; sid: 5000151; rev:4;)
#alert any $EXTERNAL_NET any -> $HOME_NET any (msg:"[MYSQL] Database startup or restart"; pcre: "/mysqld started|mysqld restarted/i"; default_proto: tcp; default_dst_port: $MYSQL_PORT; classtype: system-event; program: mysqld|MySQL; reference:quadrantsec,5000152; sid:5000152; rev:4;)
#alert any $EXTERNAL_NET any -> $HOME_NET any (msg:"[MYSQL] Database error"; pcre: "/\d+ \S+ \d+ [ERROR]/"; default_proto: tcp; default_dst_port: $MYSQL_PORT; classtype: program-error; program: mysqld|MySQL; reference: url,wiki.quadrantsec.com/bin/view/Main/5000153; sid: 5000153; rev:4;)
#alert any $EXTERNAL_NET any -> $HOME_NET any (msg:"[MYSQL] Database fatal error"; content: "Fatal error"; default_proto: tcp; default_dst_port: $MYSQL_PORT; classtype: program-error; program: mysqld|MySQL; reference: url,wiki.quadrantsec.com/bin/view/Main/5000154; sid: 5000154; rev:4;)