MariaDB Logging and old password support

For old password compatibility, do

SET GLOBAL old_passwords = 1;
SET PASSWORD FOR 'repl'@'%' = PASSWORD('the_password');
SET GLOBAL old_passwords = 0;

We can also try SET GLOBAL secure_auth=OFF; however I found this made no difference when running MariaDB 10.5 and attempting to connect with an old (presumable 4.1) client.

MariaDB GTID position reset

On Master, do SELECT @@gtid_current_pos;
then on Slave, do SET GLOBAL gtid_slave_pos = 'GTID_FROM_SERVER_1';

if need be do;

CHANGE MASTER TO
  MASTER_HOST='server1',
  MASTER_USER='replica_user',
  MASTER_PASSWORD='password',
  MASTER_USE_GTID=slave_pos;

then;

Start Slave;

SHOW SLAVE STATUS/G;

A note on the above, do it quickly, in case the position changes.

SELECT @@gtid_slave_pos, @@gtid_current_pos; should show the same.

Oracle timeouts

I had a problem with Oracle timeouts when connecting to a remote Oracle database server from within a php page. This resulted in the need to restart Apache to resolve as other web pages were also not available in said situations.

PCI Passthrough

WIP

Reboot and do: dmesg | grep -e DMAR -e IOMMU

[source]

[source]

fail2ban-client

An example of the fail2ban-client command would be:

fail2ban-client status filter-name 

where filter name is the name of a file in /etc/fail2ban/filter.d/

Netbeans build.xml file

 Below is a couple of additions I've made in the past to the build.xml files:

Creating a jar file, adding to, extracting and viewing the contents of...

To view the contents of a jar file:

jar tf jar-file.jar

To run a jar file:

java -jar jar-file.jar

Remote Monitor

Remote Monitor v:1.16h1

Proton-5 v:1.2

Force zerotier one to stop and preventing reload on Mac

To unload the service and stop: 

launchctl unload -w /Library/LaunchDaemons/com.mysql.mysql.plist

To load the service and start:

launchctl load -w /Library/LaunchDaemons/com.mysql.mysql.plist

[source]

Reset mySQL (mariadb) master/slave with GTID replication

To reset and start fresh, do;