Glam - Revision history

M: /* 2025/09/18 Full drive due to logging */

2025-09-18T14:18:15Z

2025/09/18 Full drive due to logging

← Older revision		Revision as of 14:18, 18 September 2025
Line 20:		Line 20:
	ALTER TABLE mysql.column_stats MODIFY COLUMN hist_type ENUM('SINGLE_PREC_HB', 'DOUBLE_PREC_HB', 'JSON_HB');		ALTER TABLE mysql.column_stats MODIFY COLUMN hist_type ENUM('SINGLE_PREC_HB', 'DOUBLE_PREC_HB', 'JSON_HB');
	# Query OK		# 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 ===		=== Upgrade to Ubuntu 22.04 ===

M: /* History */

2025-09-18T14:12:36Z

History

← Older revision		Revision as of 14:12, 18 September 2025
Line 3:		Line 3:
	== History ==		== History ==

	=== Full drive due to logging ===		=== 2025/09/18 Full drive due to logging ===
	Mariadb was not happy and generated 10's of GB of logging...		Mariadb was not happy and generated 10's of GB of logging...
	root@glam:/var/log# tail syslog.1		root@glam:/var/log# tail syslog.1

M: /* Full drive due to logging */

2025-09-18T14:10:07Z

Full drive due to logging

← Older revision		Revision as of 14:10, 18 September 2025
Line 14:		Line 14:
	ALTER TABLE mysql.column_stats MODIFY COLUMN hist_type ENUM('SINGLE_PREC_HB', 'DOUBLE_PREC_HB', 'JSON_HB');		ALTER TABLE mysql.column_stats MODIFY COLUMN hist_type ENUM('SINGLE_PREC_HB', 'DOUBLE_PREC_HB', 'JSON_HB');

	~~I guess~~ Wordpress is using mariadb ~~eh?~~		Wordpress is using mariadb. Db is only accessible via localhost, need to shell to glam.
			ssh glam
	~~Let's try to get to the db with dbeaver-ce~~.~~.. user root db wordpress (see private)... it's~~ only accessible via localhost, ~~cool~~. ~~Let's~~ use ~~shell on 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

	=== Upgrade to Ubuntu 22.04 ===		=== Upgrade to Ubuntu 22.04 ===

M: /* Full drive due to logging */

2025-09-18T14:05:38Z

Full drive due to logging

← Older revision		Revision as of 14:05, 18 September 2025
Line 14:		Line 14:
	ALTER TABLE mysql.column_stats MODIFY COLUMN hist_type ENUM('SINGLE_PREC_HB', 'DOUBLE_PREC_HB', 'JSON_HB');		ALTER TABLE mysql.column_stats MODIFY COLUMN hist_type ENUM('SINGLE_PREC_HB', 'DOUBLE_PREC_HB', 'JSON_HB');

	~~What the hell~~ is using mariadb ~~anyway~~?		I guess Wordpress is using mariadb eh?

			Let's try to get to the db with dbeaver-ce... user root db wordpress (see private)... it's only accessible via localhost, cool. Let's use shell on glam...

	=== Upgrade to Ubuntu 22.04 ===		=== Upgrade to Ubuntu 22.04 ===

M: /* Full drive due to logging */

2025-09-18T13:56:33Z

Full drive due to logging

← Older revision		Revision as of 13:56, 18 September 2025
Line 8:		Line 8:
	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.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).		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');

			What the hell is using mariadb anyway?

	=== Upgrade to Ubuntu 22.04 ===		=== Upgrade to Ubuntu 22.04 ===

M: /* Full drive due to logging */

2025-09-18T13:53:11Z

Full drive due to logging

← Older revision		Revision as of 13:53, 18 September 2025
Line 5:		Line 5:
	=== Full drive due to logging ===		=== Full drive due to logging ===
	Mariadb was not happy and generated 10's of GB of 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.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).		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).

M: /* History */

2025-09-18T13:52:43Z

History

← Older revision		Revision as of 13:52, 18 September 2025
Line 2:		Line 2:

	== History ==		== History ==

			=== Full drive due to logging ===
			Mariadb was not happy and generated 10's of GB of logging...
			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).

	=== Upgrade to Ubuntu 22.04 ===		=== 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???		* 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???

M: /* Upgrade to Ubuntu 22.04 */

2023-07-24T21:17:33Z

Upgrade to Ubuntu 22.04

← Older revision		Revision as of 21:17, 24 July 2023
Line 7:		Line 7:
	* mariadb upgrade failed because it did not know my root password. Just upgrade manually:		* mariadb upgrade failed because it did not know my root password. Just upgrade manually:
	sudo mariadb-upgrade		sudo mariadb-upgrade
			* wordpress news site took some heavy damage with all the updating, needs some widget love

M at 20:45, 24 July 2023

2023-07-24T20:45:02Z

← Older revision		Revision as of 20:45, 24 July 2023
Line 1:		Line 1:
	☑ [[Linux barebones quickstart]]		☑ [[Linux barebones quickstart]]

			== History ==
			=== 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

M: Created page with "☑ Linux barebones quickstart"

2021-02-14T16:46:09Z

Created page with "☑ Linux barebones quickstart"

New page

☑ [[Linux barebones quickstart]]