Advertisement
Guest User

Untitled

a guest
Apr 20th, 2018
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.23 KB | None | 0 0
  1. SQL Debug
  2. SET NAMES 'utf8'
  3. SET CHARACTER SET 'utf8'
  4. SET COLLATION_CONNECTION = 'utf8_unicode_ci'
  5. SELECT `config_name`,`config_value` FROM `config`
  6. SELECT * FROM graph_types
  7. SELECT DISTINCT(`os`) FROM `devices`
  8. DELETE FROM `session` WHERE `session_expiry` < '1524264319'
  9. SELECT * FROM devices_perms WHERE user_id = '1'
  10. SELECT * FROM ports_perms WHERE user_id = '1'
  11. SELECT * FROM bill_perms WHERE user_id = '1'
  12. SELECT * FROM `plugins` WHERE `plugin_active` = '1'
  13. SELECT service_status, count(service_status) as count FROM services GROUP BY service_status
  14. SELECT COUNT(port_id) FROM `ports` WHERE `ifOperStatus` = 'down' AND `ifAdminStatus` = 'up' AND `ignore` = '0'
  15. SELECT COUNT(*) FROM `links`
  16. SELECT COUNT(bgpPeer_id) FROM bgpPeers AS B where (bgpPeerAdminStatus = 'start' OR bgpPeerAdminStatus = 'running') AND bgpPeerState != 'established'
  17. SELECT * FROM device_groups ORDER BY name
  18. SELECT COUNT(*) from `plugins` WHERE plugin_active = '1'
  19. SELECT 1 from `packages` LIMIT 1
  20. SELECT `type`,COUNT(`type`) AS total_type FROM `devices` AS D WHERE 1 GROUP BY `type` ORDER BY `type`
  21. SELECT location FROM devices AS D GROUP BY location ORDER BY location
  22. SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.`deleted` = '0' AND D.`device_id` = I.`device_id` AND I.`ignore` = '0' AND D.`ignore` = '0' AND (I.`ifInErrors_delta` > '0' OR I.`ifOutErrors_delta` > '0')
  23. SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.`deleted` = '0' AND D.`device_id` = I.`device_id` AND (I.`ignore` = '1' OR D.`ignore` = '1')
  24. SELECT * FROM `ports` AS P, `devices` as D WHERE P.`deleted` = '1' AND D.device_id = P.device_id
  25. SELECT sensor_class,COUNT(sensor_id) AS c FROM sensors GROUP BY sensor_class ORDER BY sensor_class
  26. SELECT `sensor_class` FROM `wireless_sensors` GROUP BY `sensor_class`
  27. SELECT DISTINCT(`app_type`) AS `app_type` FROM `applications` ORDER BY `app_type`
  28. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'apache' ORDER BY `app_instance`
  29. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'bind' ORDER BY `app_instance`
  30. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'ceph' ORDER BY `app_instance`
  31. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'dhcp-stats' ORDER BY `app_instance`
  32. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'mailscanner' ORDER BY `app_instance`
  33. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'memcached' ORDER BY `app_instance`
  34. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'mysql' ORDER BY `app_instance`
  35. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'nginx' ORDER BY `app_instance`
  36. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'ntp' ORDER BY `app_instance`
  37. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'ntp-client' ORDER BY `app_instance`
  38. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'ntp-server' ORDER BY `app_instance`
  39. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'os-updates' ORDER BY `app_instance`
  40. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'postfix' ORDER BY `app_instance`
  41. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'rrdcached' ORDER BY `app_instance`
  42. SELECT DISTINCT(`app_instance`) FROM `applications` WHERE `app_type` = 'tinydns' ORDER BY `app_instance`
  43. SELECT COUNT(bgpPeer_id) from `bgpPeers` LEFT JOIN devices AS D ON bgpPeers.device_id=D.device_id WHERE D.device_id IS NOT NULL
  44. SELECT COUNT(ospf_instance_id) FROM `ospf_instances` WHERE `ospfAdminStat` = 'enabled'
  45. SELECT COUNT(cef_switching_id) from `cef_switching`
  46. SELECT COUNT(vrf_id) from `vrfs`
  47. SELECT `C`.`id`,`C`.`device_id`,`C`.`type`,`C`.`label`,`C`.`status`,`C`.`disabled`,`C`.`ignore`,`C`.`error`,`CP`.`attribute`,`CP`.`value` FROM `component` as `C` LEFT JOIN `component_prefs` as `CP` on `C`.`id`=`CP`.`component` WHERE ( `type` = 'Cisco-OTV' )
  48. SELECT COUNT(`alerts`.`id`) FROM `alerts` LEFT JOIN `devices` ON `alerts`.`device_id`=`devices`.`device_id` RIGHT JOIN `alert_rules` ON `alerts`.`rule_id`=`alert_rules`.`id` WHERE 1 AND `alerts`.`state` NOT IN (0,1)
  49. select count(notifications.notifications_id) from notifications where not exists( select 1 from notifications_attribs where notifications.notifications_id = notifications_attribs.notifications_id and notifications_attribs.user_id = '1')
  50. select count(notifications.notifications_id) from notifications inner join notifications_attribs on notifications.notifications_id = notifications_attribs.notifications_id where notifications_attribs.key = "sticky" && notifications_attribs.value = 1
  51. SELECT `value` FROM `users_prefs` WHERE `user_id`='1' AND `pref`='dashboard'
  52. SELECT * FROM `dashboards` WHERE dashboards.access > 0 || dashboards.user_id = '1'
  53. SELECT user_widget_id,users_widgets.widget_id,title,widget,col,row,size_x,size_y,refresh FROM `users_widgets` LEFT JOIN `widgets` ON `widgets`.`widget_id`=`users_widgets`.`widget_id` WHERE `dashboard_id`='1'
  54. SELECT * FROM `widgets` ORDER BY `widget_title`
  55. SELECT COUNT(*) FROM `devices` WHERE `last_polled` <= DATE_ADD(NOW(), INTERVAL - 15 minute) AND `ignore` = 0 AND `disabled` = 0 AND status = 1
  56. SELECT `notifications`.* FROM `notifications` WHERE NOT exists( SELECT 1 FROM `notifications_attribs` WHERE `notifications`.`notifications_id` = `notifications_attribs`.`notifications_id` AND `notifications_attribs`.`user_id` = '1') AND `severity` > 1
  57. 55 total SQL queries run.
  58.  
  59. PHP Debug
  60. Array ( [errno] => 8 [errstr] => Undefined index: HTTPS [errfile] => /opt/librenms/includes/defaults.inc.php [errline] => 950 )
  61. Array ( [errno] => 8 [errstr] => Undefined index: custom_css [errfile] => /opt/librenms/html/index.php [errline] => 138 )
  62. Array ( [errno] => 8192 [errstr] => call_user_func() expects parameter 1 to be a valid callback, non-static method LibreNMS\Plugins\Test::menu() should not be called statically [errfile] => /opt/librenms/LibreNMS/Plugins.php [errline] => 85 )
  63. Array ( [errno] => 8 [errstr] => Undefined offset: 1 [errfile] => /opt/librenms/html/pages/front/tiles.php [errline] => 33 )
  64. Array ( [errno] => 8 [errstr] => Undefined index: dashboard [errfile] => /opt/librenms/html/pages/front/tiles.php [errline] => 58 )
  65. 5 total PHP issues / errors.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement