THMMY.gr

######
# options

options {
        chain_hostnames(0);
        time_reopen(10);
        time_reap(360);
        sync(0);
        log_fifo_size(2048);
        create_dirs(yes);
        #owner(root);
        group(adm);
        perm(0660);
        dir_owner(root);
        dir_group(adm);
        dir_perm(0775);
        use_dns(no);
        log_msg_size(2048);
	stats_freq(0);
	bad_hostname("^gconfd$");
};

######
# sources

source s_all {
        internal();
        unix-stream("/dev/log");
        file("/proc/kmsg" log_prefix("kernel: "));
        udp();
	tcp();
};

######
# destinations

#mysql destination
destination d_mysql{
    sql(
        type("mysql")
        host("AtomServer") username("syslog-ng") password("Password")
        database("logging")
        table("messages_${HOST}")
        columns("datetime", "host", "program", "facility", "pid", "message")
        values("$R_DATE", "$HOST", "$PROGRAM", "$FACILITY", "$PID", "$MSGONLY")
        indexes("datetime", "host", "program", "facility")
    );
};

######
# filters
#no need of filters, just one destination

######
# logs

#all messages from all sources, go to the only destination
log {
        source(s_all);
        destination(d_mysql);
};

sql()