Posts by ServerOk

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 enable SSL for a node.js express application, use the following code.

See node.js […]

Read More…

Watermark video using ffmpeg

To watermark video using FFmpeg, run

In the above command replace

See ffmpeg […]

Read More…

Lego – LetsEncrypt client

Lego is a Let’s Encrypt client and ACME library written in Go. https://github.com/go-acme/lego Install Lego To install go to the release page, download the latest version.

Create SSL certificate To create an SSL certificate, run

Renew SSL certificate To renew the SSL certificate, stop the webserver

Now run

Start webserver after […]

Read More…

Install MySQL 8 on FreeBSD

MySQL MariaDB

To install MySQL 8 on FreeBSD 13, run

Enable start on boot

Start MySQL server

By default MySQL root user have no password set. You can login with the command

See FreeBSD […]

Read More…

ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails

MySQL MariaDB

When deleting a table in a MySQL database, I get the following error message

To fix the error, run

Now the drop table SQL command will work. After you dropped the table, re-enable foreign key check with

Example

[…]

Read More…

How to Install Xfce and VNC on Ubuntu 20.04

VNC allows you to connect to a remote server. We will install Xfce desktop on an Ubuntu server and configure VNC to access the desktop remotely. Install xfce with command

During the installation, you will be asked to select Install vnc server

For security reasons, running a desktop as the user root is […]

Read More…

Debian 11.0 Bullseye released

Debian 11.0 Bullseye

Debian 11.0 Bullseye released on August 14th, 2021 is the next major Debian GNU/Linux distribution release. Debian 10 buster is designated as oldstable. https://www.debian.org/releases/bullseye/ Debian 12 “Bookworm” is the new testing distribution with is expected to be released in 2023. You can download the latest version of Debian 11.0 ISO from https://www.debian.org/download What is new […]

Read More…

MySQL show processlist

MySQL

To see currently running MySQL processes, login to MySQL server, run in MySQL command prompt, run the command

To see the full SQL command, use

You can also use the following command from the bash command prompt

To see the number of SQL processes, use

See MySQL […]

Read More…

WordPress Plugins

WordPress Backup and Migration Plugins Best WordPress Image Compression Plugins https://wordpress.org/plugins/wps-hide-login/ – Hide WordPress login page from hackers. https://wordpress.org/plugins/wp-security-audit-log/ – Logs every action. https://wordpress.org/plugins/wp-cdn-rewrite/ https://wordpress.org/plugins/wp-mail-smtp/ https://wordpress.org/plugins/wp-mail-logging/ https://wordpress.org/plugins/query-monitor/ https://wordpress.org/plugins/p3-profiler/ WordPress use CDN with out plugin Amazon AWS CDN Ad Inserter – Ad Manager & AdSense Ads Easy Table of Contents Internal Link Juicer: SEO Auto Linker […]

Read More…