HP DL380 G5 Server - Cannot Install Latest Ubuntu / Linux - Solution

Update all firmware on HP DL380 G5 server
The firmware for that server is located on HP's website:

• Here's your BIOS download.
• Here's your ILO download.
• Here's your RAID controller download.

Solved the problem cannot find the disk to install latest version ubuntu :)

Ref: https://serverfault.com/questions/793011/update-all-firmware-on-hp-dl380-g5-server

Trying to upgrade mysql 56 to 80

1. Manage to upgrade mysql 56 to 57
a. Stop MySQL: service mysql-server stop
b. Add to /etc/rc.conf:
Code:
mysql_args="--explicit_defaults_for_timestamp=true --skip-grant-tables --skip-slave-start --thread_stack=256K"
These are needed, it prevents the slave process from starting, skips grant tables (so you always have access), the thread stack seems to be required, I ran out of it a couple of times

c. Install MySQL 5.7: pkg install mysql57-server
d. Start it: service mysql-server start
e. Note, this starts MySQL with the arguments we added above.
f. Run the upgrade script: mysql_upgrade (But For number (f) - > mysql_upgrade -u root –p )
g. Stop MySQL server: service mysql-server stop
h. Remove the mysql_args line from /etc/rc.conf
i. Start MySQL server service mysql-server start
j. Done


2. Failed upgrade mysql57 to mysql 80

a) Pre-requisite using this blog -> https://dinfratechsource.com/2019/06/12/upgrade-from-mysql-5-7-to-mysql-8-0/

b) but mine mysql version is 8.0.19, have problem with uppercase characters.

c) https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html

i)SET GLOBAL innodb_fast_shutdown = 1; -- fast shutdown

ii)Shut down the old MySQL server. For example: mysqladmin -u root -p shutdown

iii) Upgrade the MySQL binaries or packages. If upgrading a binary installation, unpack the new MySQL binary distribution package. See Obtain and Unpack the Distribution. For package-based installations, install the new packages. (pkg install mysql80-server)

iv)Start the MySQL 8.0 server, using the existing data directory. For example: mysqld_safe --user=mysql --datadir=/path/to/existing-datadir &


Failed: with error uppercase characters.

i) lower_case_table_names=1, change in /usr/local/etc/mysql/my.cnf

• error uppercase

ii) lower_case_table_names=1,change in /usr/local/etc/mysql/my.cnf

• 2020-02-17T06:04:32.646839Z 2 [ERROR] [MY-013140] [Server] BLOB/TEXT column 'FileSystem' used in key specification without a key length
•   2020-02-17T06:04:50.345066Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.
• 2020-02-17T06:04:50.346251Z 0 [ERROR] [MY-010119] [Server] Aborting
• 2020-02-17T06:04:53.342583Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.19) Source distribution.