Your database schema is reflected in the regular expression from the LoggerFS schemas.xml configuration file. This is probably the most difficult part, as it requires understanding of regular expressions, which most novices are unfamiliar with.
Since LoggerFS will automatically create the table and columns, we only need to instruct MySQL to create a database and user with permissions on that database. We'll name our database myApacheLogs and create a user to insert data into it named apachelogger and use s3cr3tp4zzw0rd as the password. The SQL statements below will do this for us:
Now start MySQL by running # /etc/init.d/mysqld start- it has to be running before you can use LoggerFS!
Post new comment