.Skip to main content
Pwnagotchi version 1.2.1
Type of hardware rpi0w, inkyphat
Just my 2 cents just upgraded to 1.2.1, and found the issue as described.
Yes I noticed. I have created a delta PostgreSQL file to create the full database, but still it fails due to other issues for some reason in MySQL you can add true + true + true to make 3.
`CASE WHEN ("Role"."perm_add" + "Role"."perm_modify" + "Role"."perm_publish" = 3) THEN '3'
PostgreSQL could be:
`CASE WHEN ("Role"."perm_add"::int + "Role"."perm_modify"::int + "Role"."perm_publish"::int = 3) THEN '3'`
`CASE WHEN ("Role"."perm_add" AND "Role"."perm_modify" AND "Role"."perm_publish") THEN '3'`
This is at line 47 of Role.php
Delta PostgreSQL is here:
I'm running into the same issue, but as a manual fix you could add the missing 3 columns with this query :
psql -U misp -d misp
alter table servers
add column skip_proxy SMALLINT NOT NULL DEFAULT 0,
add column caching_enabled SMALLINT NOT NULL DEFAULT 0,
add column priority BIGINT NOT NULL DEFAULT 0;
Stagering numbers, from January to August 2019, around the world, there were more than 518,223 cases of stalkerware precense detected. - https://
The theme of the new cards is kinda different.
I'm trying to load the firmware from the dist directory to my micro:bit but this keeps failing.
Off course I'm in maintenance mode and i have switched back and forth between the original firmware versions 0250 en 0253.
This is the .hex file I'm loading:
Size: 470092 bytes (459 KiB)
after dropping it on the storage the micro:bit resets and restarts in maintenance mode.
At this point I see the FAIL.TXT on the storage with the following content:
The hex file you dropped isn't compatible with this mode or device. Are you in MAINTENANCE mode? See HELP FAQ.HTM
My micro:bit has version v1.3 B on the print.
Any advice would be appreciated.
@virtualabs I'm trying to load your bltejack firmware on my micro:bit but it keeps giving me a FAIL.TXT telling me the .hex isn't compatible. Have any suggestions?
@pseudohvr Hey Harrison, I like the new #shadowtalk logo. I really think I need to have that sticker on my laptop. could you send me, a loyal podcast listener, one so I can show it off?
My @UbisoftUplay password was "2e0eTG180rCdigFh" but because you cannot paste it I changed it to "Ubisoft8" #AwesomeSecurity /cc @ubisoftsupport
1 min read
On the Raspberry pi install the dnss package
apt install dnss
Edit the settings to make it listsn on port 5053, normally it listens on 53
# Sockets for dnss.
# This lets dnss run unprivileged.
# We typically want one UDP and one TCP socket.
And restart the service, because the pi-hole is running starting probably failed right after installation, port 53 is in use
systemctl restart dnss.socket
In the Pi-hole admin web interface under settings find the tab DNS and adjust the upstream DNS Server to the dnss installation
And we're good to go. dnss uses by default dns.google.com.