Still “Whoops, looks like something went wrong. Check your librenms.log”
When running ./validate.php:
====================================
Component Version LibreNMS 21.6.0 DB Schema 2021_02_09_122930_migrate_to_utf8mb4 (204) PHP 7.4.20 Python 3.8.10 MySQL 10.5.10-MariaDB-1:10.5.10+maria~focal RRDTool 1.7.2 SNMP NET-SNMP 5.8 ==================================== [OK] Composer Version: 2.1.3
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
Ubuntu Version:
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 20.04.2 LTS
Release: 20.04
Codename: focal
When running ./lnms migrate:
Application In Production! *
Do you really wish to run this command? (yes/no) [no]:
y
Migrating: 2021_03_11_003540_rename_toner_table
In Connection.php line 678:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.toner’ doesn’t exist (SQL: rename table
toner
toprinter_supplies
)In Exception.php line 18:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.toner’ doesn’t exist
In PDOStatement.php line 112:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.toner’ doesn’t exist
When checking status of MariaDB:
● mariadb.service - MariaDB 10.5.10 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Wed 2021-06-23 16:05:20 CEST; 19h ago
Docs: man:mariadbd(8)
systemd - MariaDB Knowledge Base
Process: 410 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 420 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 431 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=cd /usr/bin/..; /usr/bin/galera_recovery
; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR |>
Process: 525 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 527 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 457 (mariadbd)
Status: “Taking your SQL requests now…”
Tasks: 20 (limit: 2200)
Memory: 574.5M
CGroup: /system.slice/mariadb.service
└─457 /usr/sbin/mariadbdJun 23 16:05:20 librenms systemd[1]: Started MariaDB 10.5.10 database server.
Jun 23 16:05:20 librenms /etc/mysql/debian-start[530]: Upgrading MySQL tables if necessary.
Jun 23 16:05:20 librenms /etc/mysql/debian-start[533]: /usr/bin/mysql_upgrade: the ‘–basedir’ option is always ignored
Jun 23 16:05:20 librenms /etc/mysql/debian-start[533]: Looking for ‘mysql’ as: /usr/bin/mysql
Jun 23 16:05:20 librenms /etc/mysql/debian-start[533]: Looking for ‘mysqlcheck’ as: /usr/bin/mysqlcheck
Jun 23 16:05:20 librenms /etc/mysql/debian-start[533]: This installation of MariaDB is already upgraded to 10.5.10-MariaDB, use --force if you still need to run mysql_upgrade
Jun 23 16:05:20 librenms /etc/mysql/debian-start[544]: Checking for insecure root accounts.
Jun 23 16:05:20 librenms /etc/mysql/debian-start[548]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Jun 23 16:05:21 librenms mariadbd[457]: 2021-06-23 16:05:21 0 [Note] InnoDB: Buffer pool(s) load completed at 210623 16:05:21
Jun 23 16:10:53 librenms mariadbd[457]: 2021-06-23 16:10:53 36 [Warning] Aborted connection 36 to db: ‘librenms’ user: ‘librenms’ host: ‘localhost’ (Got an error reading communication packets)
Any suggestions?