New Install, validation success but no prompt for GUI new user add

Help
1

Hello,

I am new to librenms, I tried installing the application on Ubuntu 20.04 and 22.04, after some troubleshooting I am able to successfully validate as shown below, but when I access GUI, I see Pre Install checks all green, configure database all green, but when I click on user, i get error. I looked at the logs and find below. Any thoughts? Thank you.

Successful DB:

image
image742×963 34 KB

New User Creation Page Error:

image
image978×390 13.8 KB

LOG FILE ERROR:
[2025-03-27T06:06:07][ERROR] SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘is’ in ‘where clause’ (Connection: setup, SQL: select * from users where is = admin limit 1) {“exception”:“[object] (Illuminate\Database\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘is’ in ‘where clause’ (Connection: setup, SQL: select * from users where is = admin limit 1) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘is’ in ‘where clause’ at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:423)”}

VALIDATION:

root@SERVER:/opt/librenms#
root@SERVER:/opt/librenms# sudo -u librenms ./validate.php

Component Version
LibreNMS 25.3.0-57-gda6ed13a3 (2025-03-26T21:53:24+00:00)
DB Schema 2022_05_25_084506_add_widgets_column_to_users_widgets_table (327)
PHP 8.3.19
Python 3.8.10
Database MariaDB 10.3.39-MariaDB-0ubuntu0.20.04.2
RRDTool 1.7.2
SNMP 5.8
===========================================

[OK] Composer Version: 2.8.6
[OK] Dependencies up-to-date.
[OK] Database connection successful
[WARN] You have no devices.
[FIX]:
Consider adding a device such as localhost: http://x.y.r.z/addhost
[OK] Database connection successful
[OK] Database Schema is current
[OK] SQL Server meets minimum requirements
[OK] lower_case_table_names is enabled
[OK] MySQL engine is optimal
[OK] Database and column collations are correct
[OK] Database schema correct
[OK] MySQL and PHP time match
[OK] Locks are functional
[OK] Python poller wrapper is polling
[OK] Redis is unavailable
[OK] rrd_dir is writable
[OK] rrdtool version ok
root@SERVER:/opt/librenms#

2

I am getting the exact same error on Rocky Linux.

3

I’m stuck in the same boat. Running Ubuntu 24.04.2 LTS.

--------- | -------
LibreNMS | 25.3.0-61-g3a33db2d5 (2025-03-27T14:40:29-06:00)
DB Schema | 2025_03_22_134124_fix_ipv6_addresses_id_type (327)
PHP | 8.3.6
Python | 3.12.3
Database | MariaDB 10.11.8-MariaDB-0ubuntu0.24.04.1
RRDTool | 1.7.2
SNMP | 5.9.4.pre2

4

I have the same issue. I believe the installer is busted somewhere. Hopefully a fix is coming.

5

Running Ubuntu 24.04.2 LTS.

  1. At first, there was an error at the end of “Build Database”. I re-installed and tried to edit the .env file first, and the “Build Database” completed successfully.
  2. But when I go to “Create Admin User”, I get the same error as you.
6

These should be fixed upstream. Easiest way to fix it is to start fresh. If you want to try to recover your install, just git pull

1 Like
7

tested and it is success. Thank you Murrant

8

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