Store the system logs in MariaDB


I’ve used Elasticsearch on OpenBSD to store my system logs for quite long now. And if it does the job, there are a few things I don’t like so much with it. I only used a single instance so I was warned about availability. But a sudden power outage had severe impact on my daily data. Way much more than what I expected from a Production-ready software. Rebuilding and re-indexing the data was a real pain in the ass. From time to time, I also get errors about indexing that seem to go away without doing nothing. The latter is probably due to my low memory server. But I want to store logs for only a couple of boxes. And I don’t want to reserve 4GB of RAM just for this. This “gimme more RAM” manner really annoys me. And as I also need RAM for Logstash (to parse the data and send them to Elasticsearch), this leads to way too much resources consumption. That said, I decided to test another way for storing the logs : using a RDBMS, namely MariaDB. I already have one running smooth. And I read Grafana was able to read data from it using SQL commands.

Continue reading...

Compress the MariaDB tables


This is just a quick note on how to enable MySQL / MariaDB compressed tables. As I plan to store lots of text, I’ll check later on if that’s usefull or not. But I guess it should.

Continue reading...

Remove all WordPress Featured Images


I used to use “Featured Images” in my posts to illustrate the main tag. Now that I changed my theme (namely Twenty Fourteen), those icon-sized images don’t show up well. I decided to simply drop them all so that nothing is displayed by the theme. This is done easily using MySQL:

Continue reading...

OAMP – Apache using FastCGI Process Manager on OpenBSD


Once upon a time, there was a way to run PHP with Apache on OpenBSD using the php-*-ap2 package. At that time, OpenBSD shipped with home-patched Apache 1.3 and provided Apache 2.x as a package. Since then, Apache 1.x was dropped from base, replaced with httpd(8) and ports gave the opportunity to run either Apache 1.x or Apache 2.x. This is when PHP packages and Apache 2.x became quite a pain in the ass to use. Thanks to the ports, one could deal with it. But binary PHP packages are not built this way. One way to get PHP and Apache is to use FastCGI. Here’s how to run the OAMP 6.0.

Continue reading...

Manual mysql_secure_installation on QNAP


I have installed the SQL server on my QNAP TS-453mini but couldn’t find the mysql_secure_installation script. As far as I understood it, it simply changes the root password, disable remote sensible access and deletes the test database. So I decided to run the commands manually inside phpMyAdmin.

Continue reading...

1 / 4