Unifi AP useful commands

using SSH:

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

Generic

Command	Example	Function

PattaFeuFeu / HA_Migrate-sqlite-to-mysql.md

Last active September 24, 2025 21:07

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 / snat_dnat_advantech.md

Last active September 3, 2025 10:44

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.

Ayden Ranni adog1314