Try this it will work guaranteed 😀
created_on = db.Column(db.DateTime, server_default=db.func.now())
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=yourusernameautologin-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":[]}]
kak eko 