Ubuntu 18.04 LTS on VMware ESXI.
I’ve followed the installation guide to the best of my ability (kind of new to Linux, so might’ve missed something which would be obvious to more seasoned users). Anyway, the problem I’m currently stuck at is the webinstaller (had a few hiccups along the way, but solved those I believe), at step 4/6 the user I create wont get added to the database.
This is the error in the /opt/librenms/logs/librenms.log file:
2018-07-30 15:41:44 MySQL Error: Table ‘librenms.users’ doesn’t exist (SELECT COUNT() FROM users WHERE username = ‘USER’)
2018-07-30 15:41:44 MySQL Error: Table ‘librenms.users’ doesn’t exist (SELECT COUNT() FROM users WHERE username = ‘USER’)
2018-07-30 15:41:44 MySQL Error: Table ‘librenms.users’ doesn’t exist (INSERT INTO users (username,password,level,email,realname,can_modify_passwd,descr) VALUES (‘USER’,‘HASH’,‘10’,‘MAIL’,’’,‘1’,’’))
Heres verifying the user in mysql which Im specifying in step 1 of the web installer (the input I’m using for this step is shown further down):
MariaDB [(none)]> show grants for ‘librenms’@‘localhost’
-> ;
±----------------------------------------------------------------------------------------------------------------+
| Grants for librenms@localhost |
±----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON . TO ‘librenms’@‘localhost’ IDENTIFIED BY PASSWORD ‘PASSWORD’ |
| GRANT ALL PRIVILEGES ON librenms.* TO ‘librenms’@‘localhost’ |
±----------------------------------------------------------------------------------------------------------------+
MariaDB [mysql]> show databases
-> ;
±-------------------+
| Database |
±-------------------+
| information_schema |
| librenms |
| mysql |
| performance_schema |
±-------------------+
4 rows in set (0.00 sec)
MariaDB [mysql]> use librenms
Database changed
MariaDB [librenms]> show tables;
Empty set (0.01 sec)
WEBINSTALLER STEP 1 INPUT:
DB Host: localhost
DB Port: 3306
DB Unix-Socket: Leave empty if using Host
DB User: librenms
DB Pass: PASSWORD
DB Name: librenms
Now I’m not sure (since I’m new to mysql aswell…) but should the database table be empty? I’ve also tried to create a new DB, but that one also have empty tables.
Here is a abbreviated output from validate.php:
====================================
| Component | Version |
|---|---|
| LibreNMS | 1.41-68-gcde15ce75 |
| DB Schema | ? |
| PHP | 7.0.30-1+ubuntu18.04.1+deb.sury.org+1 |
| MySQL | ? |
| RRDTool | 1.7.0 |
| SNMP | NET-SNMP 5.7.3 |
====================================
[FAIL] config.php does not exist, please copy config.php.default to config.php
I believe that the config.php will be fixed in a later step of the web installer?
There are many snmp errors aswell in the output which I’ve excluded for brevity which I’m unsure why they are there, I don’t think they cause the web installer to fail however.
Any and all help is appreciated.