2014-10-15 12:07 GMT+02:00 Ouychai Chaita <[email protected]>: > 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. > > I assume your version is too old for this syntax. Check the legacy config section of the doc you quoted.
to find out the version and how to upgrade to a decent one, check the video at the bottom of this page: http://www.rsyslog.com/debian-repository/ HTH Rainer How to change database? > > reguards > Ouychai Chaita > > President of Lanna Opensource Software Club > www.lanna-oss.org > (66) 08-7185-0920 > skype : ouychai_chaita > > _______________________________________________ > 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. > _______________________________________________ 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.
