When installing PhpMyAdmin on Debian 9, it will be accessible from any domain on the server. To serve it from a single domain remove from apache.conf in /etc/phpmyadmin. Then add the Alias line above to the domain you want to serve it from in /etc/apache2/sites-available. Restart Apache.
Failed to connect to mysql server using user “root” and password “***”: Access denied for user ‘root’@’localhost’
When trying to login or give SQL\ database access to an application, the following error can be resolved by The reason for this is when MariaDB\ MySQL is being setup, if the password is not set for root, the above error occurs. by typing the below you can see that on MariaDB the result would…Continue reading Failed to connect to mysql server using user “root” and password “***”: Access denied for user ‘root’@’localhost’
SSH keygen with ed25519
-a: Is the KDF (Key Derivation Function) rounds. Higher result in slower passphrase verification, increasing the resistance to brute-force cracking. -t: Specifies the type of key, in this case Ed25519. -f: The filename of the generated key file. -C: Comment.
Adding a motor and MQTT remote control to a sit stand desk
As a first project into micro controllers, I looked at converting a manual sit stand desk into one powered by a motor, controlled over WiFi MQTT commands. The what The parts The how To Do Github code The original desk had no electronics and could only manually be “wound” up and down with a handle.…Continue reading Adding a motor and MQTT remote control to a sit stand desk
Nextcloud\Owncloud and Redis with OpenVZ
After unsuccessfully trying to get Nextcloud and Owncloud working on an openvz VPS, I kept running into errors around installing redis. Turns out the issue is that a lot of the cheaper VPS resellers use an old kertnel version which has issues with redis. The only solution I could find was to switch to apcu…Continue reading Nextcloud\Owncloud and Redis with OpenVZ
Spamassasin “ADMINISTRATOR NOTICE: The query to URIBL was blocked.”
ADMINISTRATOR NOTICE: The query to URIBL was blocked If you are seeing the error “ADMINISTRATOR NOTICE: The query to URIBL was blocked.” in logs. In debian 9 and similar , go to /etc/resolv.conf and remove other dns that may be there and add your own dns that can resolve. That should fix the issue
Apache http to https rewrite\redirect
To redirect http to https in Apache On Debian 9 and similar edit sites_available file in /etc/apache2/ In the <***:80> section add the following RewriteEngine OnRewriteCond %{HTTPS} !=onRewriteRule ^/?(.*) https://%{SERVER_NAME}/$1 [R,L]