Hi @learning_curve
First of all: thanks for your extensive reply
Secondly: I don't get everythign you are saying (not because you didn't explain it clearly, but because of me lacking knowledge)
Configuring this MariaDB/MySQL thing is all quite new to me, but I'm trying to understand. Please forgive me if I ask silly questions. I'm trying to learn.
What does that mean ... does it mean that everywhere it says "mysql" it is actually a reference to mariadb? So where I used to see mariadb before I now (should) see mysql? Or is it the exact opposite: where I first saw mysql I should now see mariadb?
I have the feeling I am missing some basic knowledge of what MariaDB logrotate is.
For example ... I have a Fail2Ban log ... it logs Fail2Ban activities and the log rotates after a while. I understand what is happening and why it is happening. Another log is the secure log which also rotates. It logs security related issues. I fully get it. Then we have the messages log and the mail log. I see what is logged here and I do understand why it is logged.
But now there is (or was) MariaDB. What kind of information is stored in the mariadb log? Why is there a log? What is it logging? It is just a database server I assume. Why should it log anything?
And then the other important question ... in my first install there was a directory 'mariadb' in /var/log. Now I installed a newer version of mariadb and all of a sudden there is no longer a 'mariadb' directory in /var/log, so there is no mariadb log either. Also there is no 'mysql' directory or mysql log.
I hope you can explain to me the purpose of the mariadb/mysql log (in a simple way as if you would explain it to a child ... English is not my native language) and secondly I hope you can tell me if I should enable logrotate again and what are the steps to do that.
I truly hope you can help me. This is the last 'big' thing and then my server is quite ready to go Thanks for your reply in advance!
First of all: thanks for your extensive reply
Secondly: I don't get everythign you are saying (not because you didn't explain it clearly, but because of me lacking knowledge)
Configuring this MariaDB/MySQL thing is all quite new to me, but I'm trying to understand. Please forgive me if I ask silly questions. I'm trying to learn.
- “mysql” is now “mariadb”
What does that mean ... does it mean that everywhere it says "mysql" it is actually a reference to mariadb? So where I used to see mariadb before I now (should) see mysql? Or is it the exact opposite: where I first saw mysql I should now see mariadb?
I have the feeling I am missing some basic knowledge of what MariaDB logrotate is.
For example ... I have a Fail2Ban log ... it logs Fail2Ban activities and the log rotates after a while. I understand what is happening and why it is happening. Another log is the secure log which also rotates. It logs security related issues. I fully get it. Then we have the messages log and the mail log. I see what is logged here and I do understand why it is logged.
But now there is (or was) MariaDB. What kind of information is stored in the mariadb log? Why is there a log? What is it logging? It is just a database server I assume. Why should it log anything?
And then the other important question ... in my first install there was a directory 'mariadb' in /var/log. Now I installed a newer version of mariadb and all of a sudden there is no longer a 'mariadb' directory in /var/log, so there is no mariadb log either. Also there is no 'mysql' directory or mysql log.
I hope you can explain to me the purpose of the mariadb/mysql log (in a simple way as if you would explain it to a child ... English is not my native language) and secondly I hope you can tell me if I should enable logrotate again and what are the steps to do that.
I truly hope you can help me. This is the last 'big' thing and then my server is quite ready to go Thanks for your reply in advance!