Linux: create MO files from PO files (wp)
Using WP-CLI you can create MO files from PO files using the following command:
SCHELSTRAETE.ORG
I.T. minded
January 2022
Read More
Linux: migrate storage with pvmove
1. Begin by pvcreate’ing the new disk. This is the disk from the new storage array to which we want to migrate to. # pvcreate /dev/mapper/mpathY 2. Now, add this disk into the data_vg Volume Group : # vgextend data_vg…
Systemd: automatically restart after failure
With systemd you can configure the service so that it automaticaly restarts the service in case the service crashes.It’s enough to add the “restart” option to the [service] stanza within the service systemd configuraiton file.See example below. Of course, you…
Clamav: limit memory usage
Once in a while the clamd process can get killed because of memory usage. It turns out it would always get killed when reloading the database after an update. This is due to the fact that during a database reload clamd will…
Oracle: Map ASM disks to physical disks
Mapping Oracle ASM disks to physical disks can be done using the command: This will result something like this:
T-SQL: Group timestamp by Year/Month
You can group datetime fields by year/month by using a simple ‘format’. Of course, there are other possibilities for doing this. See example below:
T-SQL: Add/drop pass to open a database master key
When SQL Server needs a database master key to decrypt or encrypt a key, SQL Server tries to decrypt the database master key with the service master key of the instance. If the decryption fails, SQL Server searches the credential…
Linux: check if website is http2 enabled
With curl you can test if your website supports http2. Just execute the following curl command:
T-SQL: Jobs in suspended state
It is possible that sql jobs are “hanging” in a suspended state. The SQL statements below will give you an indication on what the job is waiting.The first SQL statement will create a small stored procedure in the master database,…
Linux: quotaon: Quota format not supported in kernel
I was building a new system for hosting, and that system is a virtualised system with Ubuntu. The OS was built by the provider. After installing everything, I wanted to activate the quota on the filesystem. The quota check failed with…