jimbouse.com
Jim Bouse Dot Com | All posts by jimbouse
http://www.jimbouse.com/author/jimbouse.aspx
Jim Bouse Dot Com. Technical Tips and Code Snippets. Query data in AirControl2 database. 17 April 2016 12:37. In Beta 19 release of AirControl2, Ubiquiti migraded to posgres database for storage. Much of it is stored in JSON format inside a table row but it is queryable. To begin you'll need to get to the postgres prompt:. Opt/Ubiquiti/AirControl2/pgsql/bin/psql -U ubnt -d ac2. Then, you can query things out of the nodes table with this:. 9f251619-1bfb-4f1f-8b09-3f098f7da86e 0 .0. 10 September 2014 16:53.
jimbouse.com
Jim Bouse Dot Com | Archive
http://www.jimbouse.com/archive.aspx
Jim Bouse Dot Com. Technical Tips and Code Snippets. AC1 to AC2 GPS Coordinate Pusher. FreshBooks and Mikrotik Automatic Non-Payment Script. Import MSSQL Spatial Data into Manifold via .vbs script. Google Map Mashup with WMS. Google Maps Mashup with SQL 2008. Mikrotik Workplace VPN Logging. FreshBooks and Mikrotik Automatic Non-Payment Script. Set Simple Queue Burst Rates. Low Cost Outdoor UPS. Mikrotik Simple Queue Script. Mikrotik Workplace VPN Logging. PowerShell - Export Group Members to CSV. Revert ...
jimbouse.com
Jim Bouse Dot Com | Python
http://www.jimbouse.com/category/Python.aspx
Jim Bouse Dot Com. Technical Tips and Code Snippets. AC1 to AC2 GPS Coordinate Pusher. 13 August 2013 16:37. Ok Since it looks like UBNT isn't excited about pulling data from AC1 into AC2, I whipped up a python script that copies the GPS coordinates from AC1 to the device so that it can be used in AC2. THIS MAY BREAK YOUR NETWORK. Don't say I didn't warn you. That said, I have run it against my network and it just caused breif outages while devices rebooted. 2cb4b808-7601-41f0-91ed-9982e52b166a 0 .0.
jimbouse.com
Jim Bouse Dot Com | AC1 to AC2 GPS Coordinate Pusher
http://www.jimbouse.com/post/2013/08/13/AC1-to-AC2-GPS-Coordinate-Pusher.aspx
Jim Bouse Dot Com. Technical Tips and Code Snippets. Formatting MSSQL (TSQL) Date Columns. Make UBNT device use a single polarity. AC1 to AC2 GPS Coordinate Pusher. 13 August 2013 16:37. Ok Since it looks like UBNT isn't excited about pulling data from AC1 into AC2, I whipped up a python script that copies the GPS coordinates from AC1 to the device so that it can be used in AC2. THIS MAY BREAK YOUR NETWORK. Don't say I didn't warn you. AC1-to-AC2-Coordinate-Pusher.py.txt (3.64 kb).
jimbouse.com
Jim Bouse Dot Com | Formatting MSSQL (TSQL) Date Columns
http://www.jimbouse.com/post/2012/12/28/Formatting-MSSQL-(TSQL)-Date-Columns.aspx
Jim Bouse Dot Com. Technical Tips and Code Snippets. AirOS 5.5.2 for UniFi. AC1 to AC2 GPS Coordinate Pusher. Formatting MSSQL (TSQL) Date Columns. 28 December 2012 08:18. I often need to format a date column from SQL into something nicer. The code below does that. CAST(DATEPART(m, DateCol) AS varchar(2). CAST(DATEPART(d, DateCol) AS varchar(2). CAST(DATEPART(year, DateCol) AS varchar(4). CASE WHEN DATEPART(HH, DateCol) 13 THEN RIGHT(REPLICATE(' , 2). CAST(DATEPART(n, DateCol) AS VARCHAR(2) , 2). After w...
jimbouse.com
Jim Bouse Dot Com | PHP
http://www.jimbouse.com/category/PHP.aspx
Jim Bouse Dot Com. Technical Tips and Code Snippets. Mikrotik Workplace VPN Logging. 8 September 2014 10:41. I recently had a customer of my WISP ask if we could give her a way to log when her employees are working remotely. She doesn't have a huge infrastructure with sophisticated logging abilities. She felt that her employees were claiming to work when they really weren't even logged in. Part 1(a) "create a script called 'vpn-log' on the Mikrotik":. Local urlRoot "http:/ 192.168.99.22:82/? Php date def...
jimbouse.com
Jim Bouse Dot Com | AirOS 5.5.2 for UniFi
http://www.jimbouse.com/post/2012/12/03/AirOS-552-for-UniFi.aspx
Jim Bouse Dot Com. Technical Tips and Code Snippets. Formatting MSSQL (TSQL) Date Columns. AirOS 5.5.2 for UniFi. 3 December 2012 13:41. From time to time, I install UniFi access points for customers. These customers normally do not need a controller and just want a nice looking AP. NVX from the UBNT forums put together the firmware needed to convert the UniFi to a standard UBNT radio. Here is the original post: http:/ forum.ubnt.com/showpost.php? 659c16d2-5b0e-4e0f-a947-e7db19f46b69 1 5.0.
jimbouse.com
Jim Bouse Dot Com | Make UBNT device use a single polarity.
http://www.jimbouse.com/post/2013/12/16/Make-UBNT-device-use-a-single-polarity.aspx
Jim Bouse Dot Com. Technical Tips and Code Snippets. AC1 to AC2 GPS Coordinate Pusher. Mikrotik Workplace VPN Logging. Make UBNT device use a single polarity. 16 December 2013 11:36. FYI in /tmp/system.cfg (configuration file):. Where bit mask means which chain/chains to enable:. So you can make combinations like 1 and 4 = 5, means chain0 and chain2 enabled. And so on. NOTE: Chains are HW specif, not all have all chains or the same chains. 2858afca-9a60-4aec-b8a4-42ce3695e6b5 1 5.0. After working for Tex...
jimbouse.com
Jim Bouse Dot Com | WISP
http://www.jimbouse.com/category/WISP.aspx
Jim Bouse Dot Com. Technical Tips and Code Snippets. Mikrotik Workplace VPN Logging. 8 September 2014 10:41. I recently had a customer of my WISP ask if we could give her a way to log when her employees are working remotely. She doesn't have a huge infrastructure with sophisticated logging abilities. She felt that her employees were claiming to work when they really weren't even logged in. Part 1(a) "create a script called 'vpn-log' on the Mikrotik":. Local urlRoot "http:/ 192.168.99.22:82/? Php date def...
jimbouse.com
Jim Bouse Dot Com | SQL
http://www.jimbouse.com/category/SQL.aspx
Jim Bouse Dot Com. Technical Tips and Code Snippets. Formatting MSSQL (TSQL) Date Columns. 28 December 2012 08:18. I often need to format a date column from SQL into something nicer. The code below does that. CAST(DATEPART(m, DateCol) AS varchar(2). CAST(DATEPART(d, DateCol) AS varchar(2). CAST(DATEPART(year, DateCol) AS varchar(4). CASE WHEN DATEPART(HH, DateCol) 13 THEN RIGHT(REPLICATE(' , 2). CAST(datepart(HH, DateCol) AS VARCHAR(2) , 2) ELSE RIGHT(REPLICATE(' , 2). Powered by BlogEngine.NET.