/etc/sagan-rules/mysql.rules is in sagan-rules 10212010-r1-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | # Sagan mysql.rules
# Copyright (c) 2009-2010, Softwink, Inc.
# All rights reserved.
#
# Please submit any custom rules or ideas to sagan-submit@softwink.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
alert tcp $EXTERNAL_NET any -> $HOME_NET 3306 (msg:"[MYSQL] Access denied for user"; content: "Access denied for user"; classtype: unsuccessful-user; program: mysqld; reference: url,wiki.softwink.com/bin/view/Main/5000149; sid: 5000149; rev:1;)
alert tcp $EXTERNAL_NET any -> $HOME_NET 3306 (msg:"[MYSQL] Access denied for user"; pcre: "/\d+ \S+ \d+ Connect/i"; classtype: unsuccessful-user; program: mysqld; reference: url,wiki.softwink.com/bin/view/Main/5000150; sid: 5000150; rev:1;)
alert tcp $EXTERNAL_NET any -> $HOME_NET 3306 (msg:"[MYSQL] User disconnected from database"; pcre: "/\d+ \S+ \d+ Quit/i"; classtype: not-suspicious; program: mysqld; reference: url,wiki.softwink.com/bin/view/Main/5000151; sid: 5000151; rev:1;)
alert tcp $EXTERNAL_NET any -> $HOME_NET 3306 (msg:"[MYSQL] Database startup or restart"; pcre: "/mysqld started|mysqld restarted/i"; classtype: system-event; program: mysqld; reference:softwink,5000152; sid:5000152; rev:1;)
alert tcp $EXTERNAL_NET any -> $HOME_NET 3306 (msg:"[MYSQL] Database error"; pcre: "/\d+ \S+ \d+ [ERROR]/"; classtype: program-error; program: mysqld; reference: url,wiki.softwink.com/bin/view/Main/5000153; sid: 5000153; rev:1;)
alert tcp $EXTERNAL_NET any -> $HOME_NET 3306 (msg:"[MYSQL] Database fatal error"; content: "Fatal error"; classtype: program-error; program: mysqld; reference: url,wiki.softwink.com/bin/view/Main/5000154; sid: 5000154; rev:1;)
|