Glam

☑ Linux barebones quickstart

History

2025/09/18 Full drive due to logging

Mariadb was not happy and generated 10's of GB of logging...

root@glam:/var/log# tail syslog.1
2025-09-14T00:00:02.262984+00:00 glam mariadbd[1076]: 2025-09-14  0:00:02 1908080 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
2025-09-14T00:00:02.263026+00:00 glam mariadbd[1076]: 2025-09-14  0:00:02 1908080 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).

Brave AI prompt:

Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type

says to fix it with this:

ALTER TABLE mysql.column_stats MODIFY COLUMN hist_type ENUM('SINGLE_PREC_HB', 'DOUBLE_PREC_HB', 'JSON_HB');

Wordpress is using mariadb. Db is only accessible via localhost, need to shell to glam.

ssh glam
mysql -u root -p
use mysql
ALTER TABLE mysql.column_stats MODIFY COLUMN hist_type ENUM('SINGLE_PREC_HB', 'DOUBLE_PREC_HB', 'JSON_HB');
# Query OK

HOLY SHIT i just happened to notice that I needed this, too, it fixed a TON of stuff!

root@glam:/var/log# mariadb-upgrade -p

Upgrade to Ubuntu 22.04

• PHP on Apache2: 22.04 uses PHP 8.1. Everything seemed to upgrade just fine, but wordpress, mediawiki, etc. stopped working. I browsed to https://bitpost.com/wiki to confirm that php was being displayed as code, not run. After a shitton of wasted time, I found that the PHP Apache mod simply needed to be enabled. WHY???

sudo a2enmod php8.1

• mariadb upgrade failed because it did not know my root password. Just upgrade manually:

sudo mariadb-upgrade

• wordpress news site took some heavy damage with all the updating, needs some widget love