On Fri, 2006-09-01 at 21:33 +0400, Lev Serebryakov wrote:
It is too generic solution, isn't it? In every specific case (apache, dovecot, postfix, etc.) table can be more specific than simple generic(host, datetime, facility, level, messagestring) tuple.
You could write some script which SELECTs data from the syslog generic table format and INSERTs it into a custom application specific table. You could also parse logfiles in the first place and then insert data into a database. But all this requires manual parsing of log files, which was explicitly excluded.
All depends on what the post author exactely needs to do. Generic question, generic answer.
Or are you trying to say that authentication logging to SQL should be a Dovecot feature?
Regards,
Luca