Dear all
    I’m need a helpfull with rsyslog and mysql. I’m using ubuntu 12.04
server. I’m using mysql for collect a log. I’m setup by this command.

sudo apt-get install rsyslog-mysql

After setup I’m config with

local0.*            :ommysql:localhost,Syslog,rsyslog,123456

A local0 have a log from squid3. I’m setup a new database. Database name is
“Log_Managements”. The username is “userlog”. A password is “123456”

I’m need to change the mysql log from Rsyslog database to Logs_Managements
database.
I’m try to follow this this article on below.
http://www.rsyslog.com/doc/ommysql.html
by
local0.*     action(type="ommysql" server="127.0.0.1" serverport="3306"
db="Logs_Managements" uid="userlog" pwd="123456")

After restart a service by this command.
sudo /etc/init.d/rsyslog restart

The log is still the same and not change. I’m attach a config file with
this e-mail.

How to change database?

               reguards
             Ouychai Chaita

President of Lanna Opensource Software Club
      www.lanna-oss.org
(66) 08-7185-0920
skype : ouychai_chaita

Attachment: rsyslog.conf
Description: Binary data

_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
What's up with rsyslog? Follow https://twitter.com/rgerhards
NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad of 
sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you DON'T LIKE 
THAT.

Reply via email to