I have a problem importing MID

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

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

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.

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

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

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

mysql -ulibrenms -p

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

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

Ok then follow what Murrant said to do with

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

and I will be glad to submit the issue on github

use librenms;

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

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

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

1 Like