DB Schema | No Schema (0)

Fresh install on centos8 with apache.

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

Component Version
LibreNMS 1.70.1-37-g709d1b6f5
DB Schema No Schema (0)
PHP 7.3.20
Python 3.6.8
MySQL 10.3.27-MariaDB
RRDTool 1.7.0
SNMP NET-SNMP 5.8

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

[OK] Composer Version: 2.0.8
[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(s
elect * 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 78:

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

  • Steps to reproduce an issue.
  • The output of ./validate.php

If it’s an issue with the WebUI then please consider including a screenshot and the browser version you are using.

If you are having troubles with discovery/polling include the pastebin output of:

./discovery.php -h HOSTNAME -d | ./pbin.sh
./poller.php -h HOSTNAME -r -f -d | ./pbin.sh

If you need to post any text longer than a few lines, please use a pastebin service such as https://p.libren.ms using non-expiring pastes.

initially I had just no schema so i added the password and database name to .env. and now i have the sqlstate[ errors]

Any help would be appreciated.

You haven’t run the migrations yet.
It happens during the web installer step;
https://docs.librenms.org/Installation/Install-LibreNMS/#web-installer

1 Like

you are right.
I couldn’t access the web installer. I think i might have forgotten to update the host file. Thank you.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.