After upgrade and have a new version of Rsyslog. I'm checking a version
that result on below
ouychai@Logs:~$ sudo rsyslogd -v
[sudo] password for ouychai:
rsyslogd 8.3.5, compiled with:
FEATURE_REGEXP: Yes
GSSAPI Kerberos 5 support: No
FEATURE_DEBUG (debug build, slow code): No
32bit Atomic operations supported: Yes
64bit Atomic operations supported: Yes
memory allocator: system default
Runtime Instrumentation (slow code): No
uuid support: Yes
Number of Bits in RainerScript integers: 32 (due to too-old json-c
lib)
See http://www.rsyslog.com for more information.
ouychai@Logs:~
I'm using the same configuration but an Rsyslog but can't change to other
database.
How to check them?
On Wed, Oct 15, 2014 at 5:11 PM, Rainer Gerhards <[email protected]>
wrote:
> 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.
--
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.