Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2018
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.66 KB | None | 0 0
  1. $ ./poller.php -d -h vorash-gw* -m ospf
  2. LibreNMS Poller
  3. SQL[select `version` from `dbSchema` order by `version` desc limit 1 [] 0.6ms]
  4. SQL[SELECT version() [] 0.22ms]
  5. ===================================
  6. Version info:
  7. Commit SHA: e448190a68b815e39776c68ddd4df5bcad3688db
  8. Commit Date: 1534887719
  9. DB Schema: 260
  10. PHP: 7.0.30-0ubuntu0.16.04.1
  11. MySQL: 5.7.23-0ubuntu0.16.04.1
  12. RRDTool: 1.5.5
  13. SNMP: NET-SNMP 5.7.3
  14. ==================================DEBUG!
  15. Updating os_def.cache...
  16. Warning: file_put_contents(/opt/librenms/cache/os_defs.cache): failed to open stream: Permission denied in /opt/librenms/includes/common.php on line 1651
  17. Done
  18. Using authentication for InfluxDBhttp transport being usedOverride poller modules: ospf
  19. Starting polling run:
  20.  
  21. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'vorash-gw%' ORDER BY `device_id` ASC [] 0.98ms]
  22. SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [21] 0.46ms]
  23. Hostname: vorash-gw.mgt.d6.fi
  24. Device ID: 21
  25. OS: junos
  26.  
  27. [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 vorash-gw.mgt.d6.fi
  28. Array
  29. (
  30. [xmt] => 3
  31. [rcv] => 3
  32. [loss] => 0
  33. [min] => 4.88
  34. [max] => 5.76
  35. [avg] => 5.31
  36. [exitcode] => 0
  37. )
  38. SQL[INSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW()) {"xmt":"3","rcv":"3","loss":"0","min":"4.88","max":"5.76","avg":"5.31","device_id":21} 1.39ms]
  39. SNMP Check response code: 0
  40. Modules status: Global+ OS Device
  41. #### Load poller module core ####
  42. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUt -m SNMPv2-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/junos udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0 sysDescr.0]
  43. .*.*.0 = 189685442
  44. .*.*.0 = D6 Project, Helsinki, Finland
  45. .*.*.0 = Jussi Sorjonen <mieleton@mieleton.net>
  46. .*.*.0 = vorash-gw
  47. .*.*.0 = .*.4.1.26*.2.133
  48. .*.*.0 = Juniper Networks, Inc. srx300 internet router, kernel JUNOS 15.1X49-D140.2, Build date: 2018-05-25 18:26:37 UTC Copyright (c) 1996-2018 Juniper Networks, Inc.
  49.  
  50. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/junos udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0]
  51. snmpEngineTime.0 = 1896854
  52. hrSystemUptime.0 = 189705087
  53.  
  54. Uptime seconds: 1897051
  55. RRD[update /opt/librenms/rrd/vorash-gw.mgt.d6.fi/uptime.rrd N:1897051]
  56.  
  57. InfluxDB data:
  58. uptimeArray
  59. (
  60. [hostname] => vorash-gw.mgt.d6.fi
  61. )
  62. Array
  63. (
  64. [uptime] => 1897051
  65. )
  66.  
  67. END
  68. Uptime: 21 days, 22h 57m 31s
  69. SQL[SELECT `lat`,`lng` FROM `locations` WHERE `location`=? LIMIT 1 ["D6 Project, Helsinki, Finland"] 0.62ms]
  70. Using cached lat/lng from other device
  71.  
  72. >> Runtime for poller module 'core': 0.0761 seconds with 814168 bytes
  73. >> SNMP: [2/0.06s] MySQL: [1/0.00s] RRD: [1/0.00s]
  74. #### Unload poller module core ####
  75.  
  76. RRD[update /opt/librenms/rrd/vorash-gw.mgt.d6.fi/poller-perf-core.rrd N:0.076105117797852]
  77.  
  78. InfluxDB data:
  79. poller-perfArray
  80. (
  81. [hostname] => vorash-gw.mgt.d6.fi
  82. [module] => core
  83. )
  84. Array
  85. (
  86. [poller] => 0.076105117797852
  87. )
  88.  
  89. END
  90. Modules status: Global+ OS Device+
  91. #### Load poller module ospf ####
  92. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [21] 0.53ms]
  93. Processes: SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/junos udp:HOSTNAME:161 OSPF-MIB::ospfGeneralGroup]
  94. ospfRouterId.0 = *
  95. ospfAdminStat.0 = disabled
  96. ospfVersionNumber.0 = version2
  97. ospfAreaBdrRtrStatus.0 = false
  98. ospfASBdrRtrStatus.0 = false
  99. ospfExternLsaCount.0 = 0
  100. ospfExternLsaCksumSum.0 = 0
  101. ospfTOSSupport.0 = false
  102. ospfOriginateNewLsas.0 = 0
  103. ospfRxNewLsas.0 = 0
  104. ospfExtLsdbLimit.0 = 0
  105. ospfMulticastExtensions.0 = 0
  106. ospfExitOverflowInterval.0 = 0
  107. ospfDemandExtensions.0 = false
  108.  
  109. Array
  110. (
  111. [0] => Array
  112. (
  113. [ospfRouterId] => 0.0.0.0
  114. [ospfAdminStat] => disabled
  115. [ospfVersionNumber] => version2
  116. [ospfAreaBdrRtrStatus] => false
  117. [ospfASBdrRtrStatus] => false
  118. [ospfExternLsaCount] => 0
  119. [ospfExternLsaCksumSum] => 0
  120. [ospfTOSSupport] => false
  121. [ospfOriginateNewLsas] => 0
  122. [ospfRxNewLsas] => 0
  123. [ospfExtLsdbLimit] => 0
  124. [ospfMulticastExtensions] => 0
  125. [ospfExitOverflowInterval] => 0
  126. [ospfDemandExtensions] => false
  127. )
  128.  
  129. )
  130. SQL[select * from `ospf_instances` where (`device_id` = ? and `ospf_instance_id` = ? and `context_name` is null) limit 1 [21,0] 0.78ms]
  131.  
  132. Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause' in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:470
  133. Stack trace:
  134. #0 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(470): PDO->prepare('delete from `os...')
  135. #1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('delete from `os...', Array)
  136. #2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('delete from `os...', Array, Object(Closure))
  137. #3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(477): Illuminate\Database\Connection->run('delete from `os...', Array, Object(Closure))
  138. #4 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(428): Illuminate\Database\Connection->affectingStatement('delete from `os...', Array)
  139. #5 /opt in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 647
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement