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
Read MoreLinux: create MO files from PO files (wp)
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 /dev/mapper/mpathY Make sure there are free extents on the new…
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 need to reload the systemd file in order to active…
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 load the new DB first and then drop the old…
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 store for master key credentials that have the same family…
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, which can be called by “exec sp_check_state”.The second sql satement…
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 the following message: After a small check, I noticed that…
SQL server: Slow SSMS
If you are using SSMS 17 or 18, you have maybe noticed that the SSMS startup can be very very very very slow, which is annoying for everyone. There are 2 workaround, which could resolve this issue: Open Internet Explorer: Options Then scroll to the bottom of the list and uncheck…
T-SQL: List currently running agent jobs
The T-SQL code below lists the currently running SQL Agent jobs.
Linux: GRUB slow on 4k screens
In case you have a screen with high resolutions, a 4k screen for example, it is possible that GRUB is incredibly slow. If that is the case, the workaround is to edit the /etc/default/grub file, and add/replace the following line Then run “update-grub” to update the GRUB.This will run GRUB…
T-SQL- check TEMPDB usage
You can monitoring TEMPDB usage by using the following SQL statement.
T-SQL: Select userids from linked servers
The code below can be used to query the linked servers & the user assigned to it.
Strongswan: Dynamic (BGP) IPsec VPN tunnel with strongSwan
This guide, coming from Google, explains how to use a dynamic IPsec VPN tunnel with strongSwan on Linux Step 1: Configure BIRD # Config example for bird 1.6 #debug protocols all;router id 169.254.2.2;# Watch interface up/down eventsprotocol device { scan time 10;}# Import interface routes (Connected)#…
T-SQL: Check number of messages in distribution
With this command you can check the amount of transactions in the distribution database