|
1 2 3 |
sudo docker compose exec postgres pg_dumpall -U postgres > backup17.sql // Edit docker compose / change data dir to empty sudo docker compose exec -T postgres sh -c "psql -U postgres" < backup17.sql |
Important: Postgres 18 changed data dir mount point:
|
1 2 |
- /mnt/docker-data/postgres17-data:/var/lib/postgresql/data - /mnt/docker-data/postgres18-data:/var/lib/postgresql |
This is my configuration to run Thread/Matter configuration to work together with Home Assistant. Assumptions: enp2s0 – ethernet card id 192.168.0.128:7638 – ip and port of socket listening on SLZB-MR3 This works on Debian 13 (trixie) and OpenWRT 24.10.2 SLZB-MR3 OpenWRT
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
# Add IPv6 to existing LAN interface uci set network.globals.ula_prefix='fd12:3456:789a::/48' uci set network.lan.ipv6='1' uci set network.lan.ip6assign='64' uci set network.lan.ip6hint='0' # Enable Multicast snooping uci set network.lan.multicast_snooping='1' uci commit network /etc/init.d/network restart # Enable DHCPv6 server (IPv4 DHCP will continue working) uci set dhcp.lan.dhcpv6='server' uci set dhcp.lan.ra='server' uci set dhcp.lan.ra_management='1' uci set dhcp.lan.ra_default='1' uci set dhcp.lan.ra_lifetime='1800' uci set dhcp.lan.ra_addresses='1' uci commit dhcp /etc/init.d/odhcpd restart |
|
1 2 |
opkg update opkg install umdns |
Debian I installed avahi-daemon… Continue reading
Adding:
|
1 |
Add-DnsClientNrptRule -Namespace "internal.company.com" -NameServers "10.0.0.1,10.0.2.1" |
Listing:
|
1 |
Get-DnsClientNrptRule |
Removing:
|
1 |
Get-DnsClientNrptRule | Where-Object {$_.Namespace -contains "internal.company.com"} | Remove-DnsClientNrptRule |
Sometimes we only know the PID (e.g. from nvidia-smi). We do not know what container the PID is running in.
|
1 2 3 4 5 6 7 8 9 |
TARGET_PID=331711 for container in $(docker ps -q); do if docker top $container | awk '{print $2}' | grep -q $TARGET_PID; then container_name=$(docker inspect --format '{{.Name}}' $container | sed 's/^\/\(.*\)/\1/') echo "PID $TARGET_PID is running in container: $container (Name: $container_name)" exit 0 fi done echo "PID $TARGET_PID is not running in any active container." |
Option 1
|
1 2 3 4 5 6 |
cd C:\Users\user\AppData\Local\Docker\wsl\data net stop com.docker.service taskkill /IM "docker.exe" /F taskkill /IM "Docker Desktop.exe" /F wsl --shutdown Optimize-VHD -Path ext4.vhdx -Mode Full |
Option 2 https://github.com/okibcn/wslcompact
Remember_windows
PPTP uses the GRE (Generic Routing Encapsulation) protocol to create a point-to-point tunnel. As a pure IP protocol, GRE uses only IP addresses, but without the port numbers given by a router with NAT, and without the delay in establishing a connection. In its basic configuration, OpenWrt Backfire is capable… Continue reading
about:config
|
1 2 |
browser.urlbar.openViewOnFocus = false browser.urlbar.update1 = false |
Dockerfile
|
1 2 3 4 5 6 7 8 9 |
FROM node:12-slim EXPOSE 9000 RUN mkdir /app WORKDIR /app RUN curl {URL_WITH_THE_APP} | tar -x && chown -R node:node /app USER node RUN npm i CMD ["npm", "start"] |
Build
|
1 |
sudo docker build -t {IMAGE} --pull --no-cache . |
Save image
|
1 |
sudo docker save {IMAGE:TAG} | gzip > {FILE.tar.gz} |
Load image
|
1 2 |
curl {IMAGE_URL} z -o {FILE.tar.gz} sudo docker load -i {FILE.tar.gz} |
Get datetime of last successful login of each user – from logs collection
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
// Requires official MongoShell 3.6+ db.getCollection("log").aggregate( [ { $match: { "message": { "$eq": "USER_SUCCESS_LOGIN" } } }, { $sort: { timestamp: -1 } }, { $lookup: { "from": "users", "localField": "meta.user", "foreignField": "_id", "as": "user" } }, { $match: { "user": { $ne: [] } } }, { $unwind: { path: "$user" } }, { $project: { "timestamp": { $dateToString: { format: "%Y-%m-%d %H:%M:%S:%L", date: "$timestamp" }} , "message": 1, "userid": "$user._id", "firstName": "$user.firstName", "lastName": "$user.lastName", } }, { $group: { "_id": "$userid", "firstName": { $first: "$firstName" }, "lastName": { $first: "$lastName" }, "lastLogin": { $first: "$timestamp" } } } ], { "allowDiskUse": true } ); |
