Skip to content

Instantly share code, notes, and snippets.

View kyob's full-sized avatar

kyob

20 followers · 76 following
View GitHub Profile
@kyob
kyob / importUsersFromLMStoMikrotikHotspot.php
Created January 26, 2017 10:49
<?php
$mysqli_remote = new mysqli("rhost", "rlogin", "rpass", "rdb");
mysqli_local = new mysqli("lhost", "lroot", "lpass", "ldb");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$sqlt = "TRUNCATE TABLE radcheck";
@kyob
kyob / discovery_se600.txt
Created February 16, 2017 10:03
for librenms
LibreNMS Discovery
Version info:
Commit SHA: d06aaaa222fefc083dd1c60dce1ad1cbbaf8100b
DB Schema: 164
PHP: 7.0.15
MySQL: 5.5.52-MariaDB
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2
DEBUG!
SQL[SELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1]
@kyob
kyob / poller_se600.txt
Created February 16, 2017 10:05
for librenms
LibreNMS Poller
Version info:
Commit SHA: d06aaaa222fefc083dd1c60dce1ad1cbbaf8100b
Commit Date: 1487233120
DB Schema: 164
PHP: 7.0.15
MySQL: 5.5.52-MariaDB
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2
DEBUG!
@kyob
kyob / se600-sensors.txt
Created February 21, 2017 12:06
./discovery.php -h 10.10.10.10 -d -m sensors
LibreNMS Discovery
Version info:
Commit SHA: ca2662fead1a54ba4f3879863bdb7ced7168016b
DB Schema: 165
PHP: 7.0.15
MySQL: 5.5.52-MariaDB
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2
@kyob
kyob / gist:0a05a1ae169ce4659f4259b996cc8471
Created February 21, 2017 12:11
LibreNMS Discovery
Version info:
Commit SHA: ca2662fead1a54ba4f3879863bdb7ced7168016b
DB Schema: 165
PHP: 7.0.15
MySQL: 5.5.52-MariaDB
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2
DEBUG!
SQL[SELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1]
@kyob
kyob / gist:bbf6c78ffb80097266dcd3eca25947a7
Created February 21, 2017 12:16
LibreNMS Poller
Version info:
Commit SHA: ca2662fead1a54ba4f3879863bdb7ced7168016b
Commit Date: 1487677077
DB Schema: 165
PHP: 7.0.15
MySQL: 5.5.52-MariaDB
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2
DEBUG!
@kyob
kyob / gist:7704ec639b65a90e7a4b4d06019e5b19
Created February 21, 2017 12:18
LibreNMS Discovery
Version info:
Commit SHA: ca2662fead1a54ba4f3879863bdb7ced7168016b
DB Schema: 165
PHP: 7.0.15
MySQL: 5.5.52-MariaDB
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2
DEBUG!
SQL[SELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1]
@kyob
kyob / discovery-planet-SGS-6340-16XR.txt
Created March 2, 2017 10:44
LibreNMS Discovery
Version info:
Commit SHA: 46198b2caa30e4e7a2848da6aa94256e9bff77e6
DB Schema: 172
PHP: 7.0.16
MySQL: 5.5.52-MariaDB
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2
DEBUG!
SQL[SELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1]
@kyob
kyob / poller-planet-SGS-6340-16XR.txt
Created March 2, 2017 10:46
LibreNMS Poller
Version info:
Commit SHA: 46198b2caa30e4e7a2848da6aa94256e9bff77e6
Commit Date: 1488441869
DB Schema: 172
PHP: 7.0.16
MySQL: 5.5.52-MariaDB
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2
DEBUG!
@kyob
kyob / dgs-1510-discovery.txt
Created March 8, 2017 09:54
LibreNMS Discovery
Version info:
Commit SHA: 1c48fe399f78b7acd93384646ef159c0d00d0ac1
DB Schema: 173
PHP: 7.0.16
MySQL: 5.5.52-MariaDB
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2
DEBUG!
SQL[SELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1]