Hope this saves someone else some time in combing the answers on the interwebs.
when running ./validate you may receive the error
[FAIL] Database: incorrect column (notifications/datetime)
[FAIL] Database: incorrect column (users/created_at)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE notifications
CHANGE datetime
datetime
timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’ ;
ALTER TABLE users
CHANGE created_at
created_at
timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’ ;
TO solve this you need to log into the mysql database with -u root -p
root needs to be replaced with the database username you selected in the mysql setup and then you’ll be prompted for the mysql password selected in the setup
Once logged into mysql cli you need to connect to the database with the command below
connect librennms
"librenms" and “root” is the default login name and database name in the setup defaults if you copy and pasted from the how to
Once connected to the database you can run the commands from ./validate
ALTER TABLE notifications
CHANGE datetime
datetime
timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’ ;
ALTER TABLE users
CHANGE created_at
created_at
timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’ ;