Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [root@librenms librenms]# ./validate.php
- ====================================
- Component | Version
- --------- | -------
- LibreNMS | 1.48.1-4-g57aec11
- DB Schema | 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
- PHP | 7.1.26
- MySQL | 5.7.25
- RRDTool | 1.3.8
- SNMP | NET-SNMP 5.5
- ====================================
- [OK] Composer Version: 1.8.3
- [OK] Dependencies up-to-date.
- [OK] Database connection successful
- [FAIL] Database: missing constraint (device_group_device/device_group_device_device_group_id_foreign)
- [FAIL] Database: missing constraint (device_group_device/device_group_device_device_id_foreign)
- [FAIL] Database: missing constraint (wireless_sensors/wireless_sensors_device_id_foreign)
- [FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
- [FIX]:
- Run the following SQL statements to fix.
- SQL Statements:
- ALTER TABLE `device_group_device` ADD CONSTRAINT `device_group_device_device_group_id_foreign` FOREIGN KEY (`device_group_id`) REFERENCES `device_groups` (`id`) ON DELETE CASCADE;
- ALTER TABLE `device_group_device` ADD CONSTRAINT `device_group_device_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `devices` (`device_id`) ON DELETE CASCADE;
- ALTER TABLE `wireless_sensors` ADD CONSTRAINT `wireless_sensors_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `devices` (`device_id`) ON DELETE CASCADE;
- [WARN] Your install is over 24 hours out of date, last update: Fri, 01 Feb 2019 13:22:53 +0000
- [FIX]:
- Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.
- [root@librenms librenms]#
- [root@librenms librenms]# ./poller.php -h swick-asr9k6-gw10 -d -m bgp-peers
- LibreNMS Poller
- SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.63ms]
- SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.38ms]
- SQL[SELECT version() [] 0.29ms]
- ===================================
- Version info:
- Commit SHA: 57aec11aad43720d7bccc3aec9b439c937b540ff
- Commit Date: 1549027373
- DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
- PHP: 7.1.26
- MySQL: 5.7.25
- RRDTool: 1.3.8
- SNMP: NET-SNMP 5.5
- ==================================DEBUG!
- Updating os_def.cache...
- Done
- Override poller modules: bgp-peers
- Starting polling run:
- SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'swick-asr9k6-gw10' ORDER BY `device_id` ASC [] 1ms]
- ./poller.php swick-asr9k6-gw10 2019-02-03 22:31:19 - 0 devices polled in 0.400 secs
- MySQL [1/0.00s]: Cell[1/0.00s] Row[-1/-0.00s] Rows[1/0.00s] Column[0/0.00s] Update[0/0.00s] Insert[0/0.00s] Delete[0/0.00s]
- [root@librenms librenms]# ./poller.php -h 172.22.200.10 -d -m bgp-peers
- LibreNMS Poller
- SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.51ms]
- SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.37ms]
- SQL[SELECT version() [] 0.3ms]
- ===================================
- Version info:
- Commit SHA: 57aec11aad43720d7bccc3aec9b439c937b540ff
- Commit Date: 1549027373
- DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
- PHP: 7.1.26
- MySQL: 5.7.25
- RRDTool: 1.3.8
- SNMP: NET-SNMP 5.5
- ==================================DEBUG!
- Updating os_def.cache...
- Done
- Override poller modules: bgp-peers
- Starting polling run:
- SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '172.22.200.10' ORDER BY `device_id` ASC [] 1.22ms]
- ./poller.php 172.22.200.10 2019-02-03 22:32:04 - 0 devices polled in 0.679 secs
- MySQL [1/0.00s]: Cell[1/0.00s] Row[-1/-0.00s] Rows[1/0.00s] Column[0/0.00s] Update[0/0.00s] Insert[0/0.00s] Delete[0/0.00s]
- [root@librenms librenms]#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement