Labels

Android (1) Apache (1) bash (2) boost (2) C (34) C++ (2) cheatsheet (2) CLion (6) css (3) Debian (33) DL (17) Docker (2) Dreamweaver (2) Eclipse (3) fail2ban (5) git (5) GitHub (4) Hacking (3) html (8) http (1) iOS (1) iPad (1) IRC (1) Java (33) javascript (3) Linux (174) Mac (20) Machine Learning (1) mySQL (51) Netbeans (5) Networking (1) Nexus (1) OpenVMS (6) Oracle (2) Pandas (3) php (17) Postgresql (8) Python (9) raid (1) RedHat (14) Samba (2) Slackware (50) SQL (14) svn (1) tar (1) ThinkPad (1) Virtualbox (3) Visual Basic (1) Visual Studio (1) Windows (2)

Sunday, 8 February 2026

Slackware minimum PXE boot example

For this example, we will be using dnsmasq on Slackware 14.2 with the Slackware 15 mirror.

Saturday, 7 February 2026

crontab -e not opening correct editor

Open your .bashrc file and add the line export EDITOR=vim

Then logout and back in or source .bashrc

Monday, 19 January 2026

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.

Thursday, 8 January 2026

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.