📅 January 2022
(10 posts)
📅 2022-01-24
✍️ Bart Schelstraete
Using WP-CLI you can create MO files from PO files using the following command: sudo -u MYUSER /usr/local/bin/wp i18n make-mo /var/www/website.be/web/wp-content/plugins/myplugin/languages
Read more →
📅 2022-01-21
✍️ Bart Schelstraete
1. Begin by pvcreate'ing the new disk. This is the disk from the new storage array to which we want to migrate. # pvcreate /dev/mapper/mpathY 2. Now, add this disk into the data_vg Volume Group: #…
Read more →
📅 2022-01-18
✍️ Bart Schelstraete
With systemd you can configure the service so that it automatically restarts in case it crashes. It's enough to add the "restart" option to the [Service] stanza within the systemd service…
Read more →
📅 2022-01-18
✍️ Bart Schelstraete
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…
Read more →
📅 2022-01-06
✍️ Bart Schelstraete
Mapping Oracle ASM disks to physical disks can be done using the /etc/init.d/oracleasm command: # /etc/init.d/oracleasm querydisk -p ASMDISK1 This will result in something like this: Disk "ASMDISK1"…
Read more →
📅 2022-01-06
✍️ Bart Schelstraete
You can group datetime fields by year/month by using a simple 'format'. Of course, there are other possibilities for doing this. See the example below: declare @format varchar(100) = 'yyyy/MM' SELECT…
Read more →
📅 2022-01-06
✍️ Bart Schelstraete
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…
Read more →
📅 2022-01-02
✍️ Bart Schelstraete
With curl you can test if your website supports HTTP/2. Just execute the following curl command: curl --http2 https://www.schelstraete.org
Read more →
📅 2022-01-02
✍️ Bart Schelstraete
It is possible that SQL jobs are "hanging" in a suspended state. The SQL statements below will give you an indication of what the job is waiting on. The first SQL statement will create a small stored…
Read more →
📅 2022-01-01
✍️ Bart Schelstraete
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…
Read more →