Thank you!
Precisely 10 years ago, this site was born! Special thanks to all visitors and supporters. Stay safe and healthy. K.
Linux : Drop MySQL database return error db.opt Errcode: 13 – Permission denied
Trying to drop (delete) a MySQL database using CLI and the following error is returned? ERROR 6 (HY000): Error on delete of ‘./database//db.opt’ (Errcode: 13 – Permission denied) This is most likely due to permission issue on the database folder or a file within that folder. Have a look at the MySQL database folder using… Read More »
Web : ImagickException: attempt to perform an operation not allowed by the security policy `PDF’
After updating ImageMagick to version 6.9.10.23+ from an earlier version, the following behavior occur : Thumbnails generation from PDF, XPS, PS, and EPS does not work anymore The following output can be found in the Web server error log : PHP Fatal error: Uncaught ImagickException: attempt to perform an operation not allowed by the security… Read More »
Linux : How to show Apache memory usage and average process size
Here is an easy way to output in a single command the Apache memory usage and average process size : ps -ylC apache2 | awk ‘{x += $8;y += 1} END {print “Apache Memory Usage (MB): “x/1024; print “Average Proccess Size (MB): “x/((y-1)*1024)}’ This is particularly useful when you need to calculate proper process, max… Read More »
Windows : MakeMKV can’t find any usable optical drive when connected using RDP
If you are accessing a computer using Remote Desktop (RDP) and try ripping an optical media (DVD, BD) using MakeMKV (or any other similar software for that matter), it will fail to access the disk. With MakeMKV, the error message will be as followed : The program can’t find any usable optical drive. This error… Read More »
Linux : sar command return “Cannot open /var/log/sysstat/sa27: No such file or directory”
Attempting to use the SAR (sadc) command to lookup the historical system resources consumption metrics and got the following message? Cannot open /var/log/sysstat/sa27: No such file or directory Please check if data collecting is enabled Most likely data collecting is disabled (it is the default on several systems). You need to enable data collecting and… Read More »
Linux : Issue with mail aliases “database /etc/aliases.db is older than source file /etc/aliases”
If you are experiencing issues with your local mail aliases, make sure there is no syntax error in /etc/aliases file and have a look at the mail log file : /var/log/mail.log You most likely will encounter a message like this one : postfix/local[15083]: warning: database /etc/aliases.db is older than source file /etc/aliases In that case,… Read More »
Linux : phpMyAdmin – Error Incorrect format parameter
Having the following error while importing a MySQL dump? phpMyAdmin – Error Incorrect format parameter Have a look at the “upload_max_filesize” value in your “php.ini” parameters. Most of the time, the dump file you are trying to import exceed that limit. Increase the value as needed.
Windows : Unable to merge cells within a table in Microsoft Excel
If you attempted to merge cells together within a table in Microsoft Excel, you may have faced the grayed out “Merge and Center” button issue. To work around this problem, do the following : 1. Select the cells that you want to merge 2. Right click on the selection 3. In the context menu, click… Read More »
Linux : Mail issues after renaming server hostname
If you changed the hostname/FQDN of a Linux server, you may end up with some issues, especially with mailing if some areas were forgotten with that change. Here is a quick procedure involving all the steps you should be looking for. (The following example is based on a Debian Linux system running Postfix MTA.) 1.… Read More »