cacti syslog module using syslog-ng

syslog-ng.conf

source remote {
	udp(ip(0.0.0.0) port(514));
};

log {
  source(remote);
  destination(d_sql);
};

destination d_sql {
	sql(
		type(mysql)
		host("127.0.0.1") username("cacti") password("cacti")
		database("cacti")
		table("syslog_incoming")
		columns("facility_id", "priority_id", "program", "date", "time", "host", "message")
		values("${FACILITY_NUM}", "${LEVEL_NUM}", "${PROGRAM}", "${YEAR}-${MONTH}-${DAY}", "${ISODATE}", "${FULLHOST_FROM}", "${MESSAGE}")
		indexes()
	);
};