Labels

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

Saturday, 7 February 2026

crontab -e not opening correct editor

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

echo 'export EDITOR=vim' >> ~/.bashrc

Then logout and back in or source .bashrc


If this doesn't work, try adding it to .bash_profile or do;

echo 'export EDITOR=vim' >> ~/.bash_profile

and then again, logout and back in or do source .bash_profile


NOTE: We can test using echo $EDITOR

I think on is fine for when at the console and the other for remote sessions, maybe...

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.

Wednesday, 1 October 2025

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.

Friday, 4 July 2025

Sunday, 25 May 2025

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/

Saturday, 8 March 2025

Netbeans build.xml file

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

Tuesday, 18 February 2025

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

Friday, 14 February 2025