PHP Script to verify private key matches SSL certificate?
OpenSSL command can be used to verify if an SSL certificate matches a private key file. You need to find the checksum…
Blog
How to display /proc/*/environ file in separate lines?
environ is a file located in /proc/PID/environ, it shows environment variables for a process. If you run “cat environ”, you will get…
How to enable SSL/TLS for Express.js application
For node.js applications, you can enable SSL on the application side or using Nginx or Apache running as a reverse proxy. To…
Watermark video using ffmpeg
To watermark video using FFmpeg, run ffmpeg -i SOURCE.mp4 -vf “drawtext=text=’WATERMARK_TEXT’:x=10:y=H-th-10:fontsize=32:fontcolor=white:shadowcolor=black:shadowx=2:shadowy=2” OUT.mp4 In the above command replace SOURCE.mp4 = file name of…
Lego – LetsEncrypt client
Lego is a Let’s Encrypt client and ACME library written in Go. https://go-acme.github.io/lego Install Lego To install go to the release page,…
Install MySQL 8 on FreeBSD
To install MySQL 8 on FreeBSD 13, run pkg install mysql80-server-8.0.25_2 Enable start on boot echo ‘mysql_enable=”YES”‘ >> /etc/rc.conf Start MySQL server…
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails
When deleting a table in a MySQL database, I get the following error message MariaDB [thrkhztbpt]> drop table users; ERROR 1451 (23000):…
Debian 11.0 Bullseye released
Debian 11.0 Bullseye released on August 14th, 2021 is the next major Debian GNU/Linux distribution release. Debian 10 buster is designated as…
MySQL show processlist
To see currently running MySQL processes, login to MySQL server, run in MySQL command prompt, run the command show processlist; To see…
MySQL Backup
MySQL Backup Backup Services MySQL Backup Tricks MySQL Restore Errors MySQL Backup Errors Back to MySQL