Database Stuck at following prompt

[MK13]

During the fresh install.php is stuck at “DB build please wait”

Can someone please help identify an issue here? How long does it take for the install.php to go to the next step?

Since CentOs 8 is EoS/EoL, need to setup this up on cento7.6

bash-4.2$ ./validate.php

Component	Version
LibreNMS	21.4.0-62-ge40e106
DB Schema	Not Connected (0)
PHP	7.3.28
Python	3.6.8
MySQL	?
RRDTool	1.4.8
SNMP	NET-SNMP 5.7.2
====================================

[OK] Composer Version: 2.0.13
[OK] Dependencies up-to-date.
Could not connect to database, check logs/librenms.log.

Thanks,
MK.

[robvas]

Is your database running, started, installed?

[MK13]

Yes i think so?

bash-4.2$ systemctl status mariadb
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2021-05-05 04:01:23 UTC; 2 days ago
Main PID: 20695 (mysqld_safe)
CGroup: /system.slice/mariadb.service
├─20695 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─20886 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.s…
bash-4.2$

[Jellyfrog]

Too old mysql version I’m guessing

[MK13]

After going through multiple articles and docs , following is the latest error i am getting;

bash-4.2$ ./validate.php

Component	Version
LibreNMS	21.4.0-68-g99db4bf
DB Schema	2018_07_03_091314_create_alert_log_table (4)
PHP	7.3.28
Python	3.6.8
MySQL	5.5.68-MariaDB
RRDTool	1.4.8
SNMP	NET-SNMP 5.7.2

====================================

[OK] Composer Version: 2.0.13
[OK] Dependencies up-to-date.

In Connection.php line 678:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.devices’ doesn’t exist (SQL: select exists(select * from devices) as exists)

In Exception.php line 18:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.devices’ doesn’t exist

In PDOConnection.php line 79:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.devices’ doesn’t exist

[MK13]

Secondly, per all the doc majority of the things i did were over the cli/command prompt.

But isnt install.php suppose to enable it through the GUI. wondering why am i still seeing this error on the browser:

Not Found

The requested URL /install.php was not found on this server.

[PipoCanaja]

Hi @MK13
Your MariaDB installed version is too old for LibreNMS to succeed. You need to upgrade to something newer than 10.2 to get it right. You have plenty posts in this forum with people having this issue.
Bye

[Wolfraider]

Instructions to upgrade are here

https://mariadb.com/docs/deploy/upgrade-community-server-cs105-centos7/

[MK13]

YES!!
Thanks a bunch folks.

Its Up and Operational.

Next Step enable/discover other features.