Skip to content

Instantly share code, notes, and snippets.

View adog1314's full-sized avatar

Ayden Ranni adog1314

1 follower · 6 following
  • Canada
View GitHub Profile
@CorwinDev
CorwinDev / unlock_unifi_talk_without_touch_device.md
Last active March 8, 2026 18:09

Setting up Unifi Talk without Touch device

I recently came across the issue that I wanted to setup Unifi Talk but I didn't want to buy a talk device just to set it up (this was the recommended way from Unifi)

For Unifi Talk 4.2.4 its a little more difficult but still possible:

  1. Go to your Unifi Talk setup page and press right mouse button -> Inspect
  2. Go to Network tab in Dev Tools
  3. Search for index-
@rosco-pc
rosco-pc / unifi.md
Last active February 18, 2026 08:53
Unifi commands.md

Unifi AP useful commands

using SSH:

  • log in to AP: $ ssh ubnt@<IP>
  • default username & password: ubnt & ubnt

Generic

Command Example Function
@PattaFeuFeu
PattaFeuFeu / HA_Migrate-sqlite-to-mysql.md
Last active February 7, 2026 17:22
Steps necessary to migrate from HomeAssistant’s standard sqlite database to an external MariaDB(10) SQL database

Migrate Home Assistant’s sqlite database to MySQL, specifically MariaDB (10)

After having added a decent amount of entities to my Home Assistant setup, the user interface—especially the history tab, but also the history for each entity—became very sluggish. Having to wait for up to 30 seconds to see the history graph for a single entity became the norm with an sqlite file weighing in at 6GB and millions of entries in the “events” and “states” tables.

I wanted to keep my acquired data, so I had to migrate it from the current sqlite file to a MySQL database instead of starting anew. I’ve done this using Home Assistant version 0.81 and MariaDB 10. Some parts might change in the future.

Dump Home Assistant sqlite database

@tomasinouk
tomasinouk / snat_dnat_advantech.md
Last active January 26, 2026 10:01
examples of SNAT, DNAT with iptables for Advantech, Conel routers, with comments (probably will work on other routers where iptables can be manipulated, care needs to be taken on applying these commands after reboot).

Some examples of SNAT, DNAT with iptables with comments

mainly used in start-up script

How to test 'safely'

When we play with iptables aka firewall we might end up in situation, where we execute rule, which has unforseen impact - lock yourself out. Recovering from this situation is necessity.

How to:

  • Enable reboot via SMS.
  • Test all commands in shell first before putting them into Start-up script. This way the command will be wiped out, when unit is rebooted.

masquarade all outgoing packets to be WLAN0 IP