[求助]sylog-ng 无法向mysql数据库写数据

van_warwick

想用syslog-ng 和 php-syslog-ng做日志管理，syslog-ng已经基本配置好了，各种log文件也已经生产，mysql也安装好启动了，php也可以用，但syslog-ng就是不能向mysql数据库写数据，打开php-syslog-ng也说logs表是空的
syslog-ng.conf配置文件如下

1. 
   
2. options {
   
3. long_hostnames(off);
   
4. log_msg_size(8192);
   
5. flush_lines(1);
   
6. log_fifo_size(20480);
   
7. time_reopen(10);
   
8. use_dns(yes);
   
9. dns_cache(yes);
   
10. use_fqdn(yes);
    
11. keep_hostname(yes);
    
12. chain_hostnames(no);
    
13. perm(0644);
    
14. stats_freq(43200);
    
15. };
    
16. source s_internal { internal();};
    
17. destination d_syslognglog { file("/var/log/syslog-ng.log");};
    
18. log { source(s_internal); destination(d_syslognglog);};
    
19. 
    
20. ######
    
21. # sources
    
22. source s_local {
    
23. unix-dgram("/dev/log");
    
24. file("/proc/kmsg" program_override("kernel:"));
    
25. };
    
26. 
    
27. ######
    
28. # destinations
    
29. destination d_messages { file("/var/log/messages"); };
    
30. 
    
31. 
    
32. log {
    
33. source(s_local);
    
34. destination(d_messages);
    
35. };
    
36. 
    
37. filter f_messages { level(info..emerg);};
    
38. filter f_secure { facility(authpriv);};
    
39. filter f_mail { facility(mail);};
    
40. filter f_cron { facility(cron);};
    
41. filter f_emerg { level(emerg);};
    
42. filter f_spooler { level(crit..emerg) and facility(uucp,news);};
    
43. filter f_local7 { facility(local7);};
    
44. 
    
45. destination d_messages {file("/var/log/messages");};
    
46. destination d_secure { file("/var/log/secure");};
    
47. destination d_maillog { file("/var/log/maillog");};
    
48. destination d_cron { file("/var/log/cron");};
    
49. destination d_console { usertty("root");};
    
50. destination d_spooler { file("/var/log/spooler");};
    
51. destination d_bootlog { file("/var/log/boot.log");};
    
52. 
    
53. log { source(s_local); filter(f_emerg); destination(d_console);};
    
54. log { source(s_local); filter(f_secure); destination(d_secure); flags(final);};
    
55. log { source(s_local); filter(f_mail); destination(d_maillog); flags(final);};
    
56. log { source(s_local); filter(f_cron); destination(d_cron); flags(final);};
    
57. log { source(s_local); filter(f_spooler); destination(d_spooler);};
    
58. log { source(s_local); filter(f_local7);destination(d_bootlog);};
    
59. log { source(s_local); filter(f_messages);destination(d_messages);};
    
60. 
    
61. # Remote logging
    
62. source s_remote {
    
63. tcp(ip(0.0.0.0) port(514));
    
64. udp(ip(0.0.0.0) port(514));
    
65. };
    
66. 
    
67. destination r_console {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/console" owner("root") group("root") perm(0640) dir_perm(0750) create_dirs(yes));};
    
68. destination r_secure {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/secure" owner("root") group("root") perm(0640) dir_perm(0750) create_dirs(yes));};
    
69. destination r_cron {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/cron" owner("root") group ("root") perm(0640) dir_perm(0750) create_dirs(yes));};
    
70. destination r_spooler {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/spooler" owner("root") group("root") perm(0640) dir_perm(0750) create_dirs(yes));};
    
71. destination r_bootlog {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/bootlog" owner("root") group("root") perm(0640) dir_perm(0750) create_dirs(yes));};
    
72. destination r_messages {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/messages" owner("root") group("root") perm(0640) dir_perm(0750) create_dirs(yes));};
    
73. 
    
74. log { source(s_remote); filter(f_emerg); destination(r_console);};
    
75. log { source(s_remote); filter(f_secure); destination(r_secure); flags(final);};
    
76. log { source(s_remote); filter(f_cron); destination(r_cron); flags(final);};
    
77. log { source(s_remote); filter(f_spooler); destination(r_spooler);};
    
78. log { source(s_remote); filter(f_local7); destination(r_bootlog);};
    
79. log { source(s_remote); filter(f_messages); destination(r_messages);};
    
80. 
    
81. destination d_mysql {
    
82. program("/usr/bin/mysql -usyslogadmin -psyslogadmin syslog"
    
83. template("INSERT INTO logs (host, facility, priority, level, tag, datetime, program,msg) VALUES ('$HOST','$FACILITY','$PRIORITY','$LEVEL','$TAG','$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC','$PROGRAM','$MSG');n")
    
84. template-escape(yes));
    
85. };
    
86. log {
    
87. source(s_remote);
    
88. destination(d_mysql);
    
89. };
    

复制代码

大家帮我看看配置文件有没有问题，如果配置文件没有问题，大概会是什么问？谢谢