Bug 991647

a workaround is not to write the column to the mysql-database

since i do not need ReceivedAt, Facility, Priority, InfoUnitID in
my web-based backends for which the database exists i will stay at it

$template tpl,"insert into systemevents (Message, FromHost, DeviceReportedTime, SysLogTag) values ('%msg%', '%HOSTNAME%', '%timereported:::date-mysql%', '%syslogtag%')",SQL 
________________________________________________________

what i do not understand is that the error goes away but rsyslog insists to write the non listed fields with default values and so the great option reduce the database size is not really useable :-(

Aug  3 12:18:19 testserver rsyslogd: db error (1054): Unknown column 'Facility' in 'field list'

ERRATA:

that the error stopped was only luck
the way below only the wanted fields are proceeded
_________________________________________________________________

template(name="stdSQLformat" type="string" option.sql="on"
 string="insert into SystemEvents (Message, FromHost, DeviceReportedTime, SysLogTag) values ('%msg%', '%HOSTNAME%', '%timereported:::date-mysql%', '%syslogtag%')"
)

*.info;mail.none;authpriv.none;cron.none            action(type="ommysql" server="192.168.196.1" serverport="3306" db="rsyslog" uid="syslog_insert" pwd="*****" template="stdSQLformat")

mail.*                                              action(type="ommysql" server="127.0.0.1" serverport="3307" db="rsyslog" uid="syslog_insert" pwd="*****" template="stdSQLformat")

Harald, I can reproduce the issue partially by using this template:

$template tpl,"insert into SystemEvents (Message, Facility, FromHost, Priority, DeviceReportedTime, ReceivedAt, InfoUnitID, SysLogTag) values ('%msg%', foo, '%HOSTNAME%', %syslogpriority%, '%timereported:::date-mysql%', '%timegenerated:::date-mysql%', %iut%, '%syslogtag%')",SQL

I see the error message

"Oct 20 17:23:05 hn rsyslogd: db error (1054): Unknown column 'foo' in 'field list'

but I don't get a busy-loop. Could you confirm that this configuration should produce the symptoms?

i have fixed that on all machine with my template above

i quoted the other things because i feel rsyslog introudces way too much changes the last 2 years with a ton of regressions - frankly using rsyslog-mysql still blocks a reboot forever until i tell systemd kill it after 1 second at stop and so on

This message is a notice that Fedora 19 is now at end of life. Fedora 
has stopped maintaining and issuing updates for Fedora 19. It is 
Fedora's policy to close all bug reports from releases that are no 
longer maintained. Approximately 4 (four) weeks from now this bug will
be closed as EOL if it remains open with a Fedora 'version' of '19'.

Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, simply change the 'version' 
to a later Fedora version.

Thank you for reporting this issue and we are sorry that we were not 
able to fix it before Fedora 19 is end of life. If you would still like 
to see this bug fixed and are able to reproduce it against a later version 
of Fedora, you are encouraged  change the 'version' to a later Fedora 
version prior this bug is closed as described in the policy above.

Although we aim to fix as many bugs as possible during every release's 
lifetime, sometimes those efforts are overtaken by events. Often a 
more recent Fedora release includes newer upstream software that fixes 
bugs or makes them obsolete.

Fedora 19 changed to end-of-life (EOL) status on 2015-01-06. Fedora 19 is
no longer maintained, which means that it will not receive any further
security or bug fix updates. As a result we are closing this bug.

If you can reproduce this bug against a currently maintained version of
Fedora please feel free to reopen this bug against that version. If you
are unable to reopen this bug, please file a new report against the
current release. If you experience problems, please add a comment to this
bug.

Thank you for reporting this bug and we are sorry it could not be fixed.