That is in the original post. There I showed two configurations to the same database and host - one that has never failed, and the errant one.
On Tue, Nov 20, 2018 at 9:32 AM Jacob Steinberger via rsyslog < [email protected]> wrote: > That template is used for just writing to a file, not to a database. > What does your configuration file look like for inserting data into a > database? > > Jacob > Below are ommysql configurations for two connections to same host, different databases. We do not find any of these failures for ActionName Ftp, only Sftp. $ActionName Ftp $ActionQueueDequeueSlowdown 1000 # How long (in microseconds) dequeueing should be delayed $ActionQueueFileName dbFtpQueue # Set file name, also enables disk mode $ActionQueueSaveOnShutdown on # Save messages to disk on shutdown $ActionQueueType LinkedList # Use asynchronous processing $ActionResumeRetryCount -1 # Infinite retries on insert failure ftp.* :ommysql:172.99.99.125,vsftplog,hermesvsftplog,_PASSWORD_ $ActionName Sftp $ActionQueueDequeueSlowdown 1000 # How long (in microseconds) dequeueing should be delayed $ActionQueueFileName dbSftpQueue # Set file name, also enables disk mode $ActionQueueSaveOnShutdown on # Save messages to disk on shutdown $ActionQueueType LinkedList # Use asynchronous processing $ActionResumeRetryCount -1 # Infinite retries on insert failure authpriv.* :ommysql:172.99.99.125,sftplogDB,hermesvsftplog,_PASSWORD_ _______________________________________________ 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.
