Advanced Search
Search Results
121 total results found
Permissions / Grants
Grants GRANT ALL ON *.* TO 'user'@'localhost' IDENTIFIED BY 'somepassword'; GRANT ALL ON database.* TO 'user'@'localhost' IDENTIFIED BY 'somepassword'; GRANT ALL ON database.table TO 'user'@'localhost' IDENTIFIED BY 'somepassword'; GRANT insert ON *.* TO...
MAC Addresses
MAC OUI Reserved OUIs Addresses Usage Reference 00-00-00 to 00-00-FF Reserved [RFC7042] 00-01-00 to 00-01-FF VRRP (Virtual Router Redundancy Protocol) [RFC5798] 00-02-00 to 00-02-FF VRRP IPv6 (Virtual Router Redundancy Protocol...
Ruckus / Brocade
Links https://robrobstation.com/2017/07/17/ruckus-icx7150-c12p-initial-configuration/
VBAN for Linux
https://github.com/quiniouben/vban I've used Voicemeeter Banana and Potato for a long time to do advanced audio management on my various computers, including streaming audio from various computers in the house to my laptop and vice versa. VBAN for Linux allo...
radsecproxy
radsecproxy Github Project Page radsecproxy.conf man page Configuration Example Configuration Options # Note that some block option values may reference a block by name, in which case the block name must be previously defined. Hence the order of the blocks...
Network Policy Server / NPS
Enable NTLMv2 support for MSCHAPv2 RADIUS requests Enables proxied radius requests when using things like radsecproxy, duoauthproxy, etc. Avoids the MS-CHAP-Error responses. $registryPath = "HKLM:\System\CurrentControlSet\Services\RemoteAccess\Policy" $p...
OpenVPN
Integrating OpenVPN with RADIUS Below is the culmination of at least a month working with OpenVPN. I recently discovered a bug in the Mikrotik OpenVPN server implementation that prevents users from being informed that they entered invalid credentials. (This ...
Bandwidth monitoring
Useful console programs bwm-ng - Bandwidth Monitor NG (Next Generation), a live bandwidth monitor for network and disk io iftop - display bandwidth usage on an interface by host nethogs - Net top tool grouping bandwidth per process nload - displays the c...
Batteries
Lithium Ion Voltage vs. Charge Status Original Source 4.2V – 100% 4.1V – 87% 4.0V – 75% 3.9V – 55% 3.8V – 30% 3.5V – 0% Somewhere in the 3.9V or slightly below area would be ideal for storage. Just don't overdo it. I believe AW batteries generally ship...
Useful system commands
Hardware related Memory # Show maximum capacity and number of RAM slots sudo dmidecode -t 16 # Show information on RAM in slots sudo dmidecode -t 17 # Shows all memory related information in the system. Slow as it polls all hardware first. sudo lshw -...
Flask
Reference code bases: https://github.com/miguelgrinberg/flasky
Creating a CHR instance in AWS EC2
RouterOS CHR instances in AWS EC2 I have experience with T2, T3, and T3a, primarily nano and micro, CHR instances. I prefer to use T3 instances as they provide two CPU cores for practically the same low price. TL;DR If you want to use T3 or T3a instance, y...
Using cursors in stored procedures
The MySQL code below is from a stackoverflow answer. It provides a design pattern with detailed explanation of the behavior of a cursor inside the stored procedure. DELIMITER $$ DROP PROCEDURE IF EXISTS `my_proc` $$ CREATE PROCEDURE `my_proc`(arg1 INT) --...
Password recovery
Reset lost root password /etc/init.d/mysqld stop mysqld_safe --skip-grant-tables --skip-networking & sleep 5 mysql -u root use mysql; update user set password=PASSWORD("toor") where User='root'; flush privileges; quit /etc/init.d/mysqld restart
Polycom
Polycom SIP TLS with custom CA The config files below show how to add a custom CA certificate (customCaCert1) to a Polycom phone for use with SIP TLS registration. file: ca.cfg <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <!-- PlcmConversionCrea...
Axis camera packet capture
Download network trace Source According to documentation this can be done via the URL below, as well as via the web interface in newer AXIS OS versions. pcapdump URL Source Open any browser and paste the following URL:http://CA.ME.RA.IP/axis-cgi/debug/d...
Failover for type=FWD entries in the RouterOS DNS proxy
The Mikrotik DNS resolver supports static entries with type=FWD (forward). Combining this with the regex (and now the match-subdomain option since v7.6) allows you to forward queries for specific domains to a server. Unfortunately, the type=FWD resolver does n...
Ubiquiti UniFi
List users in the UniFi Controller database # show list of users in the unifi mongodb database mongo --port 27117 ace --eval "db.admin.find().forEach(printjson);" Change password for a UniFi Controller user # change <UserName> to an actual user on the un...
WiFi Regulatory Notes
More notes to come. For now, these are random useful illustrations from around the web. -end
Learning Resources
rustup toolchain installer book: the rust programming language rust by example rustlings