Cannot Add or Edit Dashboard (add widgets or anything)

[Jeff_Lariscy]

I just completed a fresh install on Ubuntu 20.04 LTS on a Proxmox VM. Everything appears to be working but I cannot add widgets to the default dashboard or create a new dashboard. When I try to do either (clicking [Update] or trying to add a widget), I get a red box with no text but a red circle with an ‘X’ in it on the right side of the browser. If I click update multiple times, the box appears multiple times in a column on the right. I have uploaded an image for reference. If anyone can point me in the right direction, I would be greatly appreciative!

[TheGracens]

Hi,
could you do a : ./validate.php
Does it show something like →

[FAIL] Your database is out of date!
[FIX]:
./lnms migrate

[TheGracens]

You are right, I also get this error.
Could be related to the latest "Dashboard code cleanup #13996 " merge

[el_es]

Not sure if this is relevant but my dashboard looks like this right now

( the server and polling and alerts seem to be functioning normally) (though web link to validate returns Failed to load data from backend, check webserver. )
(looks like I have some fixes to do as suggested by validate.php, be back in a jiffy)

[mesut]

@TheGracens

./lnms migrate

./lnms migrate will sort out this problem.

[el_es]

SO i sorted most of what validate.php was talking about but

librenms@debian:~$ ./validate.php
====================================
Component | Version
--------- | -------
LibreNMS  | 22.5.0-14-g32f1ce494
DB Schema | 2022_02_21_073500_add_iface_field_to_bgp_peers (237)
PHP       | 7.3.31-1~deb10u1
Python    | 3.7.3
MySQL     | 10.3.34-MariaDB-0+deb10u1
RRDTool   | 1.7.1
SNMP      | 5.7.3
====================================

[OK]    Composer Version: 2.3.5
[OK]    Dependencies up-to-date.
[OK]    Database connection successful
[FAIL]  Your database is out of date!
        [FIX]:
        ./lnms migrate
[INFO]  Detected Python Wrapper
[OK]    Connection to memcached is ok
[FAIL]  Python3 module issue found: 'Required packages: ['PyMySQL!=1.0.0', 'python-dotenv', 'redis>=3.0', 'setuptools', 'psutil>=5.6.0', 'command_runner>=1.3.0']
Package not found: The 'command_runner>=1.3.0' distribution was not found and is required by the application
'
        [FIX]:
        pip3 install -r /home/librenms/requirements.txt

I run on Debian 10.12 - is that safe to do on production?

EDIT: this is what ./lnms migrate --pretend wants to do -

librenms@debian:~$ ./lnms migrate --pretend
**************************************
*     Application In Production!     *
**************************************

 Do you really wish to run this command? (yes/no) [no]:
 > yes

AddWidgetsColumnToUsersWidgetsTable: alter table `users_widgets` add `widget` varchar(32) not null default '' after `user_id`
MigrateWidgetIds: failed to dump queries. This may be due to changing database columns using Doctrine, which is not supported while pretending to run migrations.
RemoveUserWidgetsId: alter table `users_widgets` drop `widget_id`
DropWidgetsTable: drop table if exists `widgets`

[el_es]

Back here!
I installed python3-pip package in debian then the requirements, then ran the lnms migrate and now my dashboard is back in action

[Jeff_Lariscy]

Yess! The validate initially was “good” and then when I ran it again, it advised the above! Now working like a charm!