Allow mysql remote access


Enable bind address at

/etc/mysql/mysql.conf.d/mysqld.cnf

change bind address to your ip remote or 0.0.0.0 to allow from all

add mysql port to firewall via ufw allow mysql

CREATE USER 'user'@'ip_address' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'ip_address';

If you see %, well then, there’s another problem altogether as that is “any remote source”. If however you do want any/all systems to connect via root, use the % wildcard to grant access:

CREATE USER 'user'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%';

Finally, reload the permissions, and you should be able to have remote access:

FLUSH PRIVILEGES;

Howto use B-L072Z-LRWAN1 with lmic


My notes howto make B-L072Z-LRWAN1 can use lmic in arduino, i’m using standard lmic and this library can’t work until you add manually pin spi at your setup.

SPI.setMOSI(PA7);
SPI.setMISO(PA6);
SPI.setSCLK(PB3);

And you can use this pinout

// Pin mapping
const lmic_pinmap lmic_pins = {
.nss = PA15,
.rxtx = LMIC_UNUSED_PIN,
.rst = PC0,
.dio = {PB4, PB1, PB0},
};

For complete code you can see at my github here

Add dependency when install Pillow at alpine image docker


Pillow needs dependency jpeg-dev, zlib-dev and libjpeg so add this to your Dockerfile before requirement instalation

.....
RUN apk add jpeg-dev zlib-dev libjpeg
COPY ./requirements.txt .
...
And rebuilt the image, hope this helps

Happy Codding 
Salam Ngoprek

Rangkuman Cloud AWS


  • Lima pilar dari AWS Well-Architected Framework, di antaranya:
    • Operational excellence (Keunggulan Operasional)
    • Security (Keamanan)
    • Reliability (Keandalan)
    • Performance efficiency (Efisiensi Kinerja)
    • Cost optimization (Pengoptimalan Biaya)
  • Enam manfaat dari komputasi cloud, antara lain:
    • Ubah pengeluaran di muka menjadi pengeluaran variabel.
    • Manfaatkan masifnya skala ekonomi.
    • Berhenti menebak kapasitas.
    • Tingkatkan kecepatan dan ketangkasan.
    • Hentikan biaya pengelolaan dan pemeliharaan data center.
    • Mendunia dalam hitungan menit.

Remote Desktop Linux Mint


Install vino

sudo apt install vino

type on your terminal

gsettings set org.gnome.Vino require-encryption false

gsettings set org.gnome.Vino prompt-enabled false

sudo vim /etc/lightdm/lightdm.conf

autologin-user=yourusername
autologin-user-timeout=0

add startup

/usr/lib/vino/vino-server

node-red flow menampilkan data dari gps


[{"id":"81f9ffeb.66d4d","type":"gpsd","z":"e108dd82.a3cce","name":"","hostname":"localhost","port":"2947","tpv":true,"sky":false,"info":false,"device":false,"gst":false,"att":false,"x":400,"y":160,"wires":[["33ea6491.a441ac","9f80de4c.be389"]]},{"id":"33ea6491.a441ac","type":"debug","z":"e108dd82.a3cce","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":710,"y":160,"wires":[]},{"id":"9f80de4c.be389","type":"function","z":"e108dd82.a3cce","name":"","func":"msg.payload = {\n    name:\"cyberdeck\",\n    icon:\"fa-car\",\n    lat : msg.payload.lat,\n    lon : msg.payload.lon,\n}\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":570,"y":260,"wires":[["f568e1f8.f22dd","a3414ec7.91967"]]},{"id":"f568e1f8.f22dd","type":"debug","z":"e108dd82.a3cce","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":820,"y":260,"wires":[]},{"id":"a3414ec7.91967","type":"worldmap","z":"e108dd82.a3cce","name":"","lat":"","lon":"","zoom":"12","layer":"OSM","cluster":"","maxage":"","usermenu":"show","layers":"show","panit":"false","panlock":"false","zoomlock":"false","hiderightclick":"false","coords":"none","showgrid":"false","allowFileDrop":"false","path":"/map","x":800,"y":360,"wires":[]}]