As part of the Fortinet 60E hardening project, I decided to write a MariaDB database for the Fortinet 60E Firewall syslogs. The code associated with this page is used to parse the syslog log file data so it can be copied and inserted into the database on a daily basis. I created cron.daily scripts to
1. Parse the data on the Syslog server. 2. copy the data to the database server using SCP. 3. LOAD Data Local Infile script to upload the data. I have a SQL User with Select and Insert for this.