[root@localhost ~] #  vi /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1           localhost localhost.localdomain localhost6 localhost6.localdomain6

xxx.xxx.xxx.xxx    host  host.domain

[root@localhost ~] #  cp /etc/rsyslog.conf /etc/rsyslog.conf.backup

[root@localhost ~] #  vi /etc/rsyslog.conf

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

# if you experience problems, check
# http://www.rsyslog.com/troubleshoot for assistance

#### MODULES ####

$ModLoad imuxsock.so    # provides support for local system logging (e.g. via logger command)
$ModLoad imklog.so        # provides kernel logging support (previously done by rklogd)
$ModLoad immark.so       # provides --MARK-- message capability

$ModLoad ommysql

$template dbtest, “insert into syslog(messages) values (‘%msg%’)”,SQL
*.*    :ommysql:127.0.0.1,test,root,password;dbtest

# Provides UDP syslog reception
$ModLoad imudp.so
$UDPServerRun 514

# Provides TCP syslog reception
$ModLoad imtcp.so
$InputTCPServerRun 514

[root@localhost ~] #  vi /etc/sysconfig/rsyslog

# Options to syslogd
# syslogd options are deprecated in rsyslog v3
# if you want to use them, switch to compatibility mode 2 by "-c 2"
#SYSLOGD_OPTIONS="-c 4"

SYSLOGD_OPTIONS="-r -m 0"

[root@localhost ~] #  service rsyslog restart