Airport Extreme: Using the Guest Wifi With Bridge Mode

This article did the trick: https://www.thegeekpub.com/5191/use-airport-extreme-guest-network-bridge-mode/. If happen to have an unmanaged “smart” switch (such as the NETGEAR GS108) between your Airport Extreme and your firewall, you should only need to config the VLAN on the firewall and your unmanaged “smart” switch should pass those frames with no problem.

How to Change the Icon of an Apple Script Application

If you have an Apple Script that you’ve saved as an application, here’s a way to change the icon for it. The process is straightforward and mainly involves copy/paste. Create an icon in any format. For best results, make sure it’s a square image. Go to https://iconverticons.com/online/ and download the .icns file …

How to Configure AnyTerm Web-based SSH on Ubuntu

Anyterm provides a web-based SSH interface that would allow you to, for example, access your internal system using SSH via a web page. Configuration is straightforward, but will require compiling the Anyterm source. In order to download the source, you’ll need Subversion. Download Anyterm (http://anyterm.org/download.html) into a directory called anyterm …

Raspberry Pi: Connecting the PS3 Keypad Over Bluetooth

If you’re interested in connecting the PS3 Keypad to your Raspberry Pi, I’ve found a way to do so using the QtSixA project. Note that the process is a little bit easier if you’re using RetroPie 2.3. In the case you are using RetroPie 2.3, simply install the PS3 controller …

How to Run SQL Against Every Database on a Microsoft SQL Server

Use the sp_msforeachdb stored procedure. In the following example, I needed to find out if there were any objects that were referencing a specific linked server: DECLARE @command varchar(1000) SELECT @command = ‘USE ? SELECT OBJECT_NAME(object_id) [?] FROM sys.sql_modules WHERE definition LIKE ”%LINKEDSERVERNAME%”’ EXEC sp_msforeachdb @command In my case above, …

Settings Not Saving on a Bitnami Stack on Reboot?

This was happening to my Gitlab instance. What happens is that the Bitnami stack reconfigures your settings (in my case, an LDAP setting) to be the same IP address as the server. If you’re finding that your settings aren’t being saved, in particular, anything related to hostnames or IP addresses, …