I’m start a new Librenms on CentOS7 ngnix, I’m stuck with web install Build DB.
Here is the output of build DB:
Starting Update…
INFO Preparing database.
Creating migration table
…
1,059ms
DONE
INFO Loading stored database schemas.
database/schema/mysql-schema.dump
…
857ms
FAIL
The command “mysql --user=”${:LARAVEL_LOAD_USER}" --password=“${:LARAVEL_LOAD_PASSWORD}” --host=“${:LARAVEL_LOAD_HOST}” --port=“${:LARAVEL_LOAD_PORT}” --database=“${:LARAVEL_LOAD_DATABASE}” < “${:LARAVEL_LOAD_PATH}”" failed.
Exit Code: 1(General error)
Working directory: /opt/librenms/html
Output:
Error Output:
mysql: Deprecated program name. It will be removed in a future release, use ‘/usr/bin/mariadb’ instead
ERROR 2002 (HY000): Can’t connect to server on ‘localhost’ (13)
Error!
Here is the log in MariaDB status:
Aug 16 14:44:01 localhost.localdomain mariadbd[6890]: 2023-08-16 14:44:01 935 [Warning] Access denied for user ‘librenms@localho’@‘localhost’ (using password: YES)
Aug 16 14:44:01 localhost.localdomain mariadbd[6890]: 2023-08-16 14:44:01 936 [Warning] Access denied for user ‘librenms@localho’@‘localhost’ (using password: YES)
===================================================================
Here is my validate:
bash-4.2$ ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 23.7.0-74-g6e4d124 (2023-08-13T23:43:52+07:00) |
| DB Schema | No Schema (0) |
| PHP | 8.1.22 |
| Python | 3.6.8 |
| Database | MariaDB 11.0.3-MariaDB |
| RRDTool | 1.4.8 |
| SNMP | 5.7.2 |
| =========================================== |
[OK] Composer Version: 2.5.8
[OK] Dependencies up-to-date.
In Connection.php line 795:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.devices’ doesn’t exist (Connection: mysql, SQL: select exists(select * from devices) as exists)
In Connection.php line 416:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.devices’ doesn’t exist
bash-4.2$
Thank a lot for your help