I have a problem importing MID

Help
1

====================================

Component Version
LibreNMS 1.30.01-100-g30c1b79
DB Schema 204
PHP 7.0.22-0ubuntu0.16.04.1
MySQL 10.0.31-MariaDB-0ubuntu0.16.04.2
RRDTool 1.5.5
SNMP NET-SNMP 5.7.3

====================================

[OK] Database connection successful
[FAIL] Database: incorrect column (users/created_at)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (https://t.libren.ms/5gscd):
ALTER TABLE users CHANGE created_at created_at timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’;

Trying to get LibreNMS to pick up this device as a hp router ProCurve Secure Router 7102dl
I imported MIB Files from HP. However it still recognizes this device as a generic device and not a hp network device.
Any help will be greatly appreciated. Thank you very much

2

You will need to run this query in the database, try that and then run a discovery on that device.Should work after that.

Keep in mind that librenms is not mib based polling so you can’t just add a MIB and have it work, needs to coded into yaml file/php for that OS. What exactly are you trying to monitor? We have pretty good support for HP Procurves.

3

MIB files by themselves do nothing.

You can submit new support yourself, following these docs: https://docs.librenms.org/Developing/Support-New-OS/

Or you can request new device support by opening a new issue on github and supply the requested information. https://github.com/librenms/librenms/issues/new

1 Like
4

So sorry to ask a dumb question Kevin how will I do that. Please and Thank you for all your help

5

Thats not a dumb question from the command line, login into your database.

mysql -ulibrenms -p

6

Kevin it is monitoring everything correctly with the original files but recognizes the Procurve Router 7102dl as a generic device

Untitled
Untitled1152×648 16 KB

The first reply was about the running query in the database .
Once again thank you for all your help

7

Ok then follow what Murrant said to do with

8

ok so i enter the mysql -ulibrenms -p you requested for me to do now what

Capture
Capture815×479 16.4 KB
and I will be glad to submit the issue on github

9

use librenms;

ALTER TABLE users CHANGE created_at created_at timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’;

10

MariaDB [librenms]> ALTER TABLE users CHANGE created_at created_at timestamp NOT NULL 19 70-01-02 00:00:librenms;01DEFAULT
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 ‘1970-01-02 00:00:librenms’ at line 1

11

GOT IT WORKING. Thanks Kevin and Murrant submitting New Issue now.

1 Like