Saturday, November 21, 2020

(Drupal) How to change max_allowed_packet size


#

#  GL  2020-11-21    Increase max_allowed_packets to to prevent comms

#                    error from occurring when sending large queries

#                    to MySQL / MariaDB server

#

# Symptom:

# Communication link failure: 1153 Got a packet bigger than 'max_allowed_packets' bytes

#

# Discussion:

# https://mariadb.com/kb/en/server-system-variables/#max_allowed_packet

#

# Parameter:

# MariaDB [(none)]> show variables like 'max_allowed_packet';

#

# Resolution:

#

# https://stackoverflow.com/questions/8062496/how-to-change-max-allowed-packet-size

#

# Actions::

# A) Set parameter in /etc/my.cnf.d/server.cnf as follows

# [myssqld]

# max_allowed_packet=500M

#

# B) Restart MariaDB server

# # service mariadb restart

#


Tuesday, July 21, 2020

Subaru Headlight Yellowing Fix

I recently bought the Blue Fox (a 2005 Subaru Forester 2.5x @ 200K km) to help me work on a house I am rehabbing in Canada.  The car, being 15 years old, has a multitude of little (and some not so little) problems that are common for a vehicle of this age.

One of the more common problems with a vehicle that is more than a decade old is yellowed headlights.  Not only are they unsightly, yellow headlights are not as good at throwing light down the road as they should be posing somewhat of a safety risk.

Fortunately, fixing yellowed headlights is pretty simple.  Just buy some BRASSO and polish the yellow off!  In this case I bought a polishing/buffing kit for my drill, but you can just use elbow grease if you don't feel like spending any more than the minimum.

After an hour (in my case) the headlight looked great, and then I applied some Castor Oil to the plastic headlights - and the plastic bumper too!

It all turned out great - and you can do this too!\