Pfsense OpenVPN

From tleadley, 5 Years ago, written in Plain Text.
URL https://p.libren.ms/view/3b4b036f
Embed
Download Paste or View Raw
  1. LibreNMS Discovery
  2. SQL[[1;33mselect `version` from `dbSchema` order by `version` desc limit 1 [0;33m[][0m 0.38ms]
  3. SQL[[1;33mSELECT version() [0;33m[][0m 0.26ms]
  4. ===================================
  5. Version info:
  6. Commit SHA: 29f8a8d4a31897832027358a36ad335a0df3fc19
  7. Commit Date: 1547319112
  8. DB Schema: 281
  9. PHP: 7.0.32-0ubuntu0.16.04.1
  10. MySQL: 10.0.36-MariaDB-0ubuntu0.16.04.1
  11. RRDTool: 1.5.5
  12. SNMP: NET-SNMP 5.7.3
  13. ==================================DEBUG!
  14. Updating os_def.cache... Done
  15. Override discovery modules: ports
  16. SQL[[1;33mSELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE '10.100.50.1' ORDER BY device_id DESC [0;33m[][0m 0.9ms]
  17. SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[7][0m 0.27ms]
  18. 10.100.50.1 7 pfsense [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 10.100.50.1
  19. Array
  20. (
  21.     [xmt] => 3
  22.     [rcv] => 3
  23.     [loss] => 0
  24.     [min] => 1.59
  25.     [max] => 2.29
  26.     [avg] => 1.89
  27.     [exitcode] => 0
  28. )
  29. SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`)  VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) [0;33m{"xmt":"3","rcv":"3","loss":"0","min":"1.59","max":"2.29","avg":"1.89","device_id":7,"debug":"[]"}[0m 24.89ms]
  30. SNMP Check response code: 0
  31. SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ?  [0;33m[7,"poll_mib"][0m 0.38ms]
  32. Attempting to initialize OS: pfsense
  33. Attempting to initialize OS: unix
  34. OS initilized as Generic
  35.  
  36. Modules status: Global+ OS  Device  
  37. #### Load disco module core ####
  38. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY '-OUQn' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/pfsense' 'udp:HOSTNAME:161' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m]
  39. .*.*.0 = router.wickidmachines.com
  40. .*.*.0 = .*.4.1.123*.1.1
  41. .*.*.0 = pfSense  2.4.4-RELEASE pfSense FreeBSD 11.2-RELEASE-p3 amd64
  42.  
  43.  
  44. >> Runtime for discovery module 'core': 0.0070 seconds with 1072 bytes
  45. >> SNMP: [2/0.02s] MySQL: [4/0.03s] RRD: [0/0.00s]
  46. #### Unload disco module core ####
  47.  
  48. Modules status: Global+ OS+ Device  
  49. #### Load disco module ports ####
  50. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/pfsense' 'udp:HOSTNAME:161' 'ifDescr'[0m]
  51. ifDescr.1 = igb0
  52. ifDescr.2 = igb1
  53. ifDescr.3 = igb2
  54. ifDescr.4 = igb3
  55. ifDescr.5 = igb4
  56. ifDescr.6 = igb5
  57. ifDescr.7 = igb6
  58. ifDescr.8 = igb7
  59. ifDescr.9 = enc0
  60. ifDescr.10 = lo0
  61. ifDescr.11 = pflog0
  62. ifDescr.12 = pfsync0
  63. ifDescr.13 = ovpns2
  64. ifDescr.14 = ovpns3
  65. ifDescr.15 = ovpns5
  66. ifDescr.16 = ovpnc1
  67.  
  68. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/pfsense' 'udp:HOSTNAME:161' 'ifName'[0m]
  69. ifName.1 = igb0
  70. ifName.2 = igb1
  71. ifName.3 = igb2
  72. ifName.4 = igb3
  73. ifName.5 = igb4
  74. ifName.6 = igb5
  75. ifName.7 = igb6
  76. ifName.8 = igb7
  77. ifName.9 = enc0
  78. ifName.10 = lo0
  79. ifName.11 = pflog0
  80. ifName.12 = pfsync0
  81. ifName.13 = ovpns2
  82. ifName.14 = ovpns3
  83. ifName.15 = ovpns5
  84. ifName.16 = ovpnc1
  85.  
  86. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/pfsense' 'udp:HOSTNAME:161' 'ifAlias'[0m]
  87. ifAlias.1 =
  88. ifAlias.2 =
  89. ifAlias.3 =
  90. ifAlias.4 =
  91. ifAlias.5 =
  92. ifAlias.6 =
  93. ifAlias.7 =
  94. ifAlias.8 =
  95. ifAlias.9 =
  96. ifAlias.10 =
  97. ifAlias.11 =
  98. ifAlias.12 =
  99. ifAlias.13 =
  100. ifAlias.14 =
  101. ifAlias.15 =
  102. ifAlias.16 =
  103.  
  104. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/pfsense' 'udp:HOSTNAME:161' 'ifType'[0m]
  105. ifType.1 = ethernetCsmacd
  106. ifType.2 = ethernetCsmacd
  107. ifType.3 = ethernetCsmacd
  108. ifType.4 = ethernetCsmacd
  109. ifType.5 = ethernetCsmacd
  110. ifType.6 = ethernetCsmacd
  111. ifType.7 = ethernetCsmacd
  112. ifType.8 = ethernetCsmacd
  113. ifType.9 = wwanPP2
  114. ifType.10 = softwareLoopback
  115. ifType.11 = ifPwType
  116. ifType.12 = ilan
  117. ifType.13 = ppp
  118. ifType.14 = ppp
  119. ifType.15 = ppp
  120. ifType.16 = ppp
  121.  
  122. Array
  123. (
  124.     [1] => Array
  125.         (
  126.             [ifDescr] => igb0
  127.             [ifName] => igb0
  128.             [ifAlias] =>
  129.             [ifType] => ethernetCsmacd
  130.         )
  131.  
  132.     [2] => Array
  133.         (
  134.             [ifDescr] => igb1
  135.             [ifName] => igb1
  136.             [ifAlias] =>
  137.             [ifType] => ethernetCsmacd
  138.         )
  139.  
  140.     [3] => Array
  141.         (
  142.             [ifDescr] => igb2
  143.             [ifName] => igb2
  144.             [ifAlias] =>
  145.             [ifType] => ethernetCsmacd
  146.         )
  147.  
  148.     [4] => Array
  149.         (
  150.             [ifDescr] => igb3
  151.             [ifName] => igb3
  152.             [ifAlias] =>
  153.             [ifType] => ethernetCsmacd
  154.         )
  155.  
  156.     [5] => Array
  157.         (
  158.             [ifDescr] => igb4
  159.             [ifName] => igb4
  160.             [ifAlias] =>
  161.             [ifType] => ethernetCsmacd
  162.         )
  163.  
  164.     [6] => Array
  165.         (
  166.             [ifDescr] => igb5
  167.             [ifName] => igb5
  168.             [ifAlias] =>
  169.             [ifType] => ethernetCsmacd
  170.         )
  171.  
  172.     [7] => Array
  173.         (
  174.             [ifDescr] => igb6
  175.             [ifName] => igb6
  176.             [ifAlias] =>
  177.             [ifType] => ethernetCsmacd
  178.         )
  179.  
  180.     [8] => Array
  181.         (
  182.             [ifDescr] => igb7
  183.             [ifName] => igb7
  184.             [ifAlias] =>
  185.             [ifType] => ethernetCsmacd
  186.         )
  187.  
  188.     [9] => Array
  189.         (
  190.             [ifDescr] => enc0
  191.             [ifName] => enc0
  192.             [ifAlias] =>
  193.             [ifType] => wwanPP2
  194.         )
  195.  
  196.     [10] => Array
  197.         (
  198.             [ifDescr] => lo0
  199.             [ifName] => lo0
  200.             [ifAlias] =>
  201.             [ifType] => softwareLoopback
  202.         )
  203.  
  204.     [11] => Array
  205.         (
  206.             [ifDescr] => pflog0
  207.             [ifName] => pflog0
  208.             [ifAlias] =>
  209.             [ifType] => ifPwType
  210.         )
  211.  
  212.     [12] => Array
  213.         (
  214.             [ifDescr] => pfsync0
  215.             [ifName] => pfsync0
  216.             [ifAlias] =>
  217.             [ifType] => ilan
  218.         )
  219.  
  220.     [13] => Array
  221.         (
  222.             [ifDescr] => ovpns2
  223.             [ifName] => ovpns2
  224.             [ifAlias] =>
  225.             [ifType] => ppp
  226.         )
  227.  
  228.     [14] => Array
  229.         (
  230.             [ifDescr] => ovpns3
  231.             [ifName] => ovpns3
  232.             [ifAlias] =>
  233.             [ifType] => ppp
  234.         )
  235.  
  236.     [15] => Array
  237.         (
  238.             [ifDescr] => ovpns5
  239.             [ifName] => ovpns5
  240.             [ifAlias] =>
  241.             [ifType] => ppp
  242.         )
  243.  
  244.     [16] => Array
  245.         (
  246.             [ifDescr] => ovpnc1
  247.             [ifName] => ovpnc1
  248.             [ifAlias] =>
  249.             [ifType] => ppp
  250.         )
  251.  
  252. )
  253. SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? ORDER BY port_id [0;33m[7][0m 1.18ms]
  254. SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb0","igb0","igb0",39][0m 26.48ms]
  255. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb1","igb1","igb1",40][0m 33.14ms]
  256. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb2","igb2","igb2",41][0m 33.19ms]
  257. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb3","igb3","igb3",42][0m 33.22ms]
  258. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb4","igb4","igb4",43][0m 33.2ms]
  259. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb5","igb5","igb5",44][0m 33.18ms]
  260. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb6","igb6","igb6",45][0m 33.22ms]
  261. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb7","igb7","igb7",46][0m 33.06ms]
  262. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["wwanPP2","enc0","enc0","enc0",47][0m 33.23ms]
  263. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["softwareLoopback","lo0","lo0","lo0",48][0m 33.18ms]
  264. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ifPwType","pflog0","pflog0","pflog0",49][0m 33.22ms]
  265. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ilan","pfsync0","pfsync0","pfsync0",50][0m 277.79ms]
  266. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ppp","ovpns2","ovpns2","ovpns2",51][0m 80.05ms]
  267. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ppp","ovpns3","ovpns3","ovpns3",52][0m 24.9ms]
  268. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ppp","ovpns5","ovpns5","ovpns5",53][0m 24.83ms]
  269. .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ppp","ovpnc1","ovpnc1","ovpnc1",54][0m 24.85ms]
  270. .
  271.  
  272. >> Runtime for discovery module 'ports': 0.8430 seconds with 4312 bytes
  273. >> SNMP: [4/0.04s] MySQL: [17/0.80s] RRD: [0/0.00s]
  274. #### Unload disco module ports ####
  275.  
  276. SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ?  [0;33m[7,"poll_mib"][0m 0.37ms]
  277. SQL[[1;33mUPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [0;33m[1.904,7][0m 24.38ms]
  278. Discovered in 1.904 seconds
  279.  
  280. SQL[[1;33mINSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) [0;33m{"type":"discover","doing":"10.100.50.1","start":1547414290.8983,"duration":"2.133","devices":1,"poller":"tlnms"}[0m 24.88ms]
  281. ./discovery.php 10.100.50.1 2019-01-13 13:18:13 - 1 devices discovered in 2.133 secs
  282. SNMP [6/0.06s]: Get[2/0.02s] Getnext[0/0.00s] Walk[4/0.04s]
  283. MySQL [24/0.87s]: Cell[1/0.00s] Row[1/0.00s] Rows[3/0.00s] Column[0/0.00s] Update[17/0.82s] Insert[2/0.05s] Delete[0/0.00s]
  284. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
  285.  


Reply to "Pfsense OpenVPN"