syslog-ng-test.conf

@version: 3.3
@include "scl.conf"

options { check_hostname(yes);
	keep_hostname(yes);
	chain_hostnames(no); 
	# enable or disable directory creation for destination files
	create_dirs(yes);

	# default owner, group, and permissions for log files (defaults are 0, 0, 0600)
	owner(root);
	group(root);
	perm(0777);

	# default owner, group, and permissions for created directories (defaults are 0, 0, 0700)
	dir_owner(root);
	dir_group(root);
	dir_perm(0777);

	#use_dns(yes); use_fqdn(yes);
};

source inputs {
	udp(port(514));
};

destination logpile {
	file("/var/log/CollectionRequests-$YEAR$MONTH$DAY/rest.log" 
	owner("root")
	group("root")
	perm(0777)
	template("$HOUR:$MIN:$SEC [$LEVEL] [$FACILITY] [$PROGRAM] $MSG\n")
	template_escape(no));
};

destination d_mysql {
	sql(
		username("root")
		type(mysql)
		password("S0UR(Eopia")
		database("collection")
		host("localhost")
		table("syslog-ng_logs")
		columns("host", "facility", "priority", "level", "tag", "datetime", "program", "msg")
		values("$HOST", "$FACILITY", "$PRIORITY", "$LEVEL", "$TAG","$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC","$PROGRAM", "$MSG")
		indexes("datetime", "host", "program", "pid", "message")
	);
};

log { source(inputs); destination(logpile); };
log { source(inputs); destination(d_mysql); };