I used to upgrade LibreNMS as root user. Now it ask to login as LibreNMS user. But I have forgotten password.
Can I find it somehow, or change it ?
That’s a bit vague but I assume you mean from the VM we provide?
Passwords are listed here: http://docs.librenms.org/Installation/Ubuntu-image/
If you have root access, you don’t need the librenms user password.
Just run su - librenms or passwd librenms
Thanks! That did the trick ![]()
When I run ./validate.php I get the following:
root@nms01:/opt/librenms# ./validate.php
Component Version LibreNMS 2dd44fdfdfd96cdf791b83e70b2f729113755459 DB Schema 190 PHP 7.0.19-1~dotdeb+8.1 MySQL 10.0.30-MariaDB-0+deb8u2 RRDTool 1.4.8 SNMP NET-SNMP 5.7.2.1 ==========================================================
[OK] Database connection successful
[FAIL] Database: incorrect column (dbSchema/version)
[FAIL] Database: missing index (dbSchema/PRIMARY)
[FAIL] Database: missing column (users/remember_token)
[FAIL] Database: incorrect column (users/updated_at)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (Report database schema issues here - LibreNMS Community):
ALTER TABLEdbSchemaCHANGEversionversionint(11) NOT NULL DEFAULT ‘0’;
ALTER TABLEdbSchemaADD PRIMARY KEY (version);
ALTER TABLEusersADDremember_tokenvarchar(100) NULL AFTERrealname;
ALTER TABLEusersCHANGEupdated_atupdated_attimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP;
What to do ?
Run those queries in mysql
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''dbSchema' CHANGE 'version' 'version' int(11) NOT NULL DEFAULT '0'' at line 1
We can’t see what you’ve pasted there. Show us the full input / output.
2 posts were split to a new topic: Password for SSH on LibreNMS images
2 posts were merged into an existing topic: Password for SSH on LibreNMS images