# Listing 1: Filter/Destination für PIX-Firewall

filter f_pix {
        host(pix);
};
# Zielort der Log-Dateien
destination loghost {
        file ("/var/log/hosts/$YEAR-$MONTH/$HOST/$FACILITY-$YEAR-$MONTH-$DAY"
                owner(root) group(root) perm(0600) dir_perm(0700) create_dirs(yes)
        );
destination d_mysql {
        program("/usr/bin/mysql -f --reconnect --user=root --password=<I>PASSWORT<I> syslog"§§
  template("INSERT INTO logs (host, facility, priority, level, tag, date, time, program, msg) VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG', '$YEAR-$MONTH-$DAY','$HOUR:$MIN:$SEC','$PROGRAM', '$MSG' );\n")
          template-escape(yes)); };
};

log {
        source(s_all);
        destination(loghost);
        destination(d_mysql);
};
# Pix
log {
        source(s_all);
        filter(f_pix);
        destination(loghost);
        flags(final);
};