Hello, Inregards to this howto - http://www.howtoforge.com/logging_with_rsyslog_phplogcon_debian_etch I was wondering how do I set it up to accept syslog messages from other hosts? I've tried this in /etc/rsyslog.conf with no luck *.* @192.168.0.200:514
I think you must modify /etc/rsyslog.conf, e.g. like this: Code: *.* >192.168.0.200,rsyslog,rsyslog_user,rsyslog_user_password
Tried those settings, however I get this message db error (2003): Can't connect to MySQL server on '192.168.0.200' (4) Does this mean that I need to create table for this host ?
Update: (I thought that I had found the problem) I tried to enable logging from remote hosts first, by adding in the -r option in /etc/init.d/rsyslog RSYSLOGD_OPTIONS="-m 0 -r" then Restarted rsyslog Still no messages from other hosts. So I removed the following *.* >192.168.0.200,rsyslog,rsyslog_user,rsyslog_user_password still no luck.
May have solved this one !? I skipped this step vi /etc/default/rsyslog Also had to enter in the -r option here.
Make sure that the client system is allowed to log in to the MySQL server on 192.168.0.200. Also, the MySQL server must use TCP and listen on all interfaces and on port 3306. What's the output of Code: netstat -tap|grep mysql on 192.168.0.200?