First Install > SQLSTATE[42S02]: Base table or view not found: 1146 Table 'librenms.devices' doesn't exist

The following error was found when installing for the first time. Please help me.

librenms@Librenms:~$ ./validate.php

Component Version
LibreNMS 22.9.0-3-g06c361c2b
DB Schema No Schema (0)
PHP 7.4.3-4ubuntu2.18
Python 3.8.10
Database MariaDB 10.3.38-MariaDB-0ubuntu0.20.04.1
RRDTool 1.7.2
SNMP 5.8
====================================

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

In Connection.php line 712:

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 82:

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

librenms@Librenms:~$


librenms@Librenms:~$ cat config.php
<?php

## Have a look in misc/config_definitions.json for examples of settings you can set here. DO NOT EDIT misc/config_definitions.json!

// This is the user LibreNMS will run as
//Please ensure this user is created and has the correct permissions to your install
#$config['user'] = 'librenms';

### This should *only* be set if you want to *force* a particular hostname/port
### It will prevent the web interface being usable form any other hostname
#$config['base_url']        = "/";

### Enable this to use rrdcached. Be sure rrd_dir is within the rrdcached dir
### and that your web server has permission to talk to rrdcached.
#$config['rrdcached']    = "unix:/var/run/rrdcached.sock";

### Default community
#$config['snmp']['community'] = array('public');

### Authentication Model
#$config['auth_mechanism'] = "mysql"; # default, other options: ldap, http-auth
#$config['http_auth_guest'] = "guest"; # remember to configure this user if you use http-auth

### List of RFC1918 networks to allow scanning-based discovery
#$config['nets'][] = "10.0.0.0/8";
#$config['nets'][] = "172.16.0.0/12";
#$config['nets'][] = "192.168.0.0/16";

# Uncomment the next line to disable daily updates
#$config['update'] = 0;

# Number in days of how long to keep old rrd files. 0 disables this feature
#$config['rrd_purge'] = 0;

# Uncomment to submit callback stats via proxy
#$config['callback_proxy'] = "hostname:port";

# Set default port association mode for new devices (default: ifIndex)
#$config['default_port_association_mode'] = 'ifIndex';

# Enable the in-built billing extension
#$config['enable_billing'] = 1;

# Enable the in-built services support (Nagios plugins)
#$config['show_services'] = 1;
librenms@Librenms:~$

What does your web interface show? It seems like the DB initiation did not happen during the installer steps.

Does /install still work if you visit it? Installing LibreNMS - LibreNMS Docs check carefully you’ve followed each step in order.

You are also on an old PHP version, so will not be getting new updates - if you can move up to PHP 8.1 and try again it would be advisable.

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