[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):
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
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
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.