Advertisement
Guest User

Untitled

a guest
Feb 3rd, 2019
310
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.75 KB | None | 0 0
  1. [root@librenms librenms]# ./validate.php
  2. ====================================
  3. Component | Version
  4. --------- | -------
  5. LibreNMS | 1.48.1-4-g57aec11
  6. DB Schema | 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
  7. PHP | 7.1.26
  8. MySQL | 5.7.25
  9. RRDTool | 1.3.8
  10. SNMP | NET-SNMP 5.5
  11. ====================================
  12.  
  13. [OK] Composer Version: 1.8.3
  14. [OK] Dependencies up-to-date.
  15. [OK] Database connection successful
  16. [FAIL] Database: missing constraint (device_group_device/device_group_device_device_group_id_foreign)
  17. [FAIL] Database: missing constraint (device_group_device/device_group_device_device_id_foreign)
  18. [FAIL] Database: missing constraint (wireless_sensors/wireless_sensors_device_id_foreign)
  19. [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):
  20. [FIX]:
  21. Run the following SQL statements to fix.
  22. SQL Statements:
  23. 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;
  24. ALTER TABLE `device_group_device` ADD CONSTRAINT `device_group_device_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `devices` (`device_id`) ON DELETE CASCADE;
  25. ALTER TABLE `wireless_sensors` ADD CONSTRAINT `wireless_sensors_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `devices` (`device_id`) ON DELETE CASCADE;
  26. [WARN] Your install is over 24 hours out of date, last update: Fri, 01 Feb 2019 13:22:53 +0000
  27. [FIX]:
  28. Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.
  29. [root@librenms librenms]#
  30.  
  31. [root@librenms librenms]# ./poller.php -h swick-asr9k6-gw10 -d -m bgp-peers
  32. LibreNMS Poller
  33. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.63ms]
  34.  
  35. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.38ms]
  36.  
  37. SQL[SELECT version() [] 0.29ms]
  38.  
  39. ===================================
  40. Version info:
  41. Commit SHA: 57aec11aad43720d7bccc3aec9b439c937b540ff
  42. Commit Date: 1549027373
  43. DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
  44. PHP: 7.1.26
  45. MySQL: 5.7.25
  46. RRDTool: 1.3.8
  47. SNMP: NET-SNMP 5.5
  48. ==================================DEBUG!
  49. Updating os_def.cache...
  50. Done
  51. Override poller modules: bgp-peers
  52. Starting polling run:
  53.  
  54. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'swick-asr9k6-gw10' ORDER BY `device_id` ASC [] 1ms]
  55.  
  56. ./poller.php swick-asr9k6-gw10 2019-02-03 22:31:19 - 0 devices polled in 0.400 secs
  57. 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]
  58. [root@librenms librenms]# ./poller.php -h 172.22.200.10 -d -m bgp-peers
  59. LibreNMS Poller
  60. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.51ms]
  61.  
  62. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.37ms]
  63.  
  64. SQL[SELECT version() [] 0.3ms]
  65.  
  66. ===================================
  67. Version info:
  68. Commit SHA: 57aec11aad43720d7bccc3aec9b439c937b540ff
  69. Commit Date: 1549027373
  70. DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
  71. PHP: 7.1.26
  72. MySQL: 5.7.25
  73. RRDTool: 1.3.8
  74. SNMP: NET-SNMP 5.5
  75. ==================================DEBUG!
  76. Updating os_def.cache...
  77. Done
  78. Override poller modules: bgp-peers
  79. Starting polling run:
  80.  
  81. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '172.22.200.10' ORDER BY `device_id` ASC [] 1.22ms]
  82.  
  83. ./poller.php 172.22.200.10 2019-02-03 22:32:04 - 0 devices polled in 0.679 secs
  84. 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]
  85. [root@librenms librenms]#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement