Hello Dusan,
first of all many thanks again for allowing me to answer this via the
mailing list. I guess it can be helpful for other users, too.
The issue is actually a small typo. You wrote:
> *.* => 127.0.0.1,Syslog,root,;dbFormat
the correct one would be
> *.* => >127.0.0.1,Syslog,root,;dbFormat
please note the greater-than-sign in front of "127.0.0.1". This is what
tells rsyslog to write to the database. As a side note, you can also
skipt the ";dbFormat" part if you use the default schema, so it would
come down to
> *.* => >127.0.0.1,Syslog,root,
But please be aware that 0.9.1 has a bug, so that a semicolon at the end
is needed in all cases.
Regarding the make, you need to enable MySQL support by editing the
makefile. If you have not done this, MySQL functionality is *not* there.
And finally, I recommend to move on to version 0.9.6, which has fixed a
number of glitches and also has much better documentation. You can
obtain it from www.rsyslog.com.
Please note that we now have good HOWTOs on both the install process as
well as writing to the data base. They can be viewed online at
http://www.rsyslog.com/Documentation-/install.html.phtml
http://www.rsyslog.com/Documentation-/rsyslog_mysql.html.phtml
If any of these links become broken by the mailer, simply go to
http://www.rsyslog.com/doc
and follow the links on that page.
I hope that gets you going. If there are still problems, please let me
know. I know that I sometimes do not provided the greatest instructions,
so assume any misunderstanding is caused by me ;)
Rainer
> -----Original Message-----
> From: Dusan Keprta [mailto:dusan.keprta@etel.sk]
> Sent: Friday, August 12, 2005 9:43 AM
> To: Rainer Gerhards
> Subject: Please ....
>
> Hello Gerhard.
>
> I apologize but after few days I would like ask your for your help.
>
> Many times I tried and read documentation and compilation
> rsylog 0.9.1 for testing syslog messages and sending to MySQL
> but without any effect.
>
> Please id You have a time I will be happy with your support.
>
> [1] I compiled rsyslog 0.9.1 and installed on Trustix Linux 3.0.
> [2] Of course I create db,tables in MySQL.
> [3] And finally I configured rsyslog.conf.
> [4] I used example dbFormat , and it is running when rsyslog
> writing to some file :
>
> *.* => /var/log/test.log;dbFormat
> But :
> *.* => 127.0.0.1,Syslog,root,;dbFormat
> does not work. I did not see any log messages via mysql
> and I really don't known where is a problem.
>
> Please can you favor and send me short idea ?
>
> I compiled this version without any extra arguments only
> standard make .....
>
> Dusan Keprta
> Slovakia
>
first of all many thanks again for allowing me to answer this via the
mailing list. I guess it can be helpful for other users, too.
The issue is actually a small typo. You wrote:
> *.* => 127.0.0.1,Syslog,root,;dbFormat
the correct one would be
> *.* => >127.0.0.1,Syslog,root,;dbFormat
please note the greater-than-sign in front of "127.0.0.1". This is what
tells rsyslog to write to the database. As a side note, you can also
skipt the ";dbFormat" part if you use the default schema, so it would
come down to
> *.* => >127.0.0.1,Syslog,root,
But please be aware that 0.9.1 has a bug, so that a semicolon at the end
is needed in all cases.
Regarding the make, you need to enable MySQL support by editing the
makefile. If you have not done this, MySQL functionality is *not* there.
And finally, I recommend to move on to version 0.9.6, which has fixed a
number of glitches and also has much better documentation. You can
obtain it from www.rsyslog.com.
Please note that we now have good HOWTOs on both the install process as
well as writing to the data base. They can be viewed online at
http://www.rsyslog.com/Documentation-/install.html.phtml
http://www.rsyslog.com/Documentation-/rsyslog_mysql.html.phtml
If any of these links become broken by the mailer, simply go to
http://www.rsyslog.com/doc
and follow the links on that page.
I hope that gets you going. If there are still problems, please let me
know. I know that I sometimes do not provided the greatest instructions,
so assume any misunderstanding is caused by me ;)
Rainer
> -----Original Message-----
> From: Dusan Keprta [mailto:dusan.keprta@etel.sk]
> Sent: Friday, August 12, 2005 9:43 AM
> To: Rainer Gerhards
> Subject: Please ....
>
> Hello Gerhard.
>
> I apologize but after few days I would like ask your for your help.
>
> Many times I tried and read documentation and compilation
> rsylog 0.9.1 for testing syslog messages and sending to MySQL
> but without any effect.
>
> Please id You have a time I will be happy with your support.
>
> [1] I compiled rsyslog 0.9.1 and installed on Trustix Linux 3.0.
> [2] Of course I create db,tables in MySQL.
> [3] And finally I configured rsyslog.conf.
> [4] I used example dbFormat , and it is running when rsyslog
> writing to some file :
>
> *.* => /var/log/test.log;dbFormat
> But :
> *.* => 127.0.0.1,Syslog,root,;dbFormat
> does not work. I did not see any log messages via mysql
> and I really don't known where is a problem.
>
> Please can you favor and send me short idea ?
>
> I compiled this version without any extra arguments only
> standard make .....
>
> Dusan Keprta
> Slovakia
>