To check if MariaDB/MySQL databases are empty in your DB Server, run the following query: 1MariaDB [(none)]> SELECT table_schema, # "DB Name", 2-> Round(Sum(data_length + index_length) / 1024 / 1024, 1) # "DB Size in MB" 3-> FROM information_schema.tables 4-> GROUP BY table_schema; …
Read MoreUse the following command: 17z a -p -mem=AES256 -tzip file.zip source-file1.txt source-file2.txt It will ask for a password but will obviously not be echoed. To decrypt: 17za e file.zip You need to install as well associated tools. Shown are for Redhat-like Linux: 1sudo yum install p7zip p7zip-plugins Some details …
Read MoreGiven the following cert: 1root@php73:~# certbot certificates 2Saving debug log to /var/log/letsencrypt/letsencrypt.log 34- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 5Found the following certs: 6Certificate Name: php72.example.com 7Domains: php72.example.com php72.example.net 8Expiry …
Read MoreI turned-off my built-in wireless network interface using the command: 1iwconfig wlan0 txpower off Howerver, I can no longer turn-it back on. Logic says just change "off" to "on" but instead, I get this error. 1root@raspberrypi:/home/pi# iwconfig wlan0 txpower on 2Error for wireless request "Set …
Read MoreI did buy a wifi donggle in Lazada but I didn't know if it can be detected in my Raspberry pi using Rasbian. Command to use: lsusb. Example: 1root@raspberrypi:/home/pi# lsusb 2Bus 002 Device 001: ID 1d6b:0003 Linux Foundation 3.0 root hub 3Bus 001 Device 003: ID 148f:7601 Ralink Technology, Corp. MT7601U Wireless …
Read MoreSyntax: 1kubectl exec --stdin --tty <pod_name> -- /bin/bash Example, with the following pods 1me@example:~$ kubectl get pod 2NAME READY STATUS RESTARTS AGE 3cert-manager-cainjector-68c88cc858-c2rhx 1/1 Running 0 109m 4cert-manager-d76d644df-pgqn9 1/1 Running 0 109m 5cert-manager-webhook-6dd68c6fbc-rzcln 1/1 …
Read MoreWhen a pi gets under voltage below 4.63V (+/-5%), a thunderbolt icon is shown in the monitor like in https://www.raspberrypi.org/documentation/configuration/warning-icons.md It will then get throttled to get back to desired voltage. From command line, here's what you can use to check: 1vcgencmd get_throttled with some …
Read MoreInstall needed package: 1sudo apt install cec-utils Check connected devices 1pi@raspberrypi:~ $ echo 'scan' | cec-client -s -d 1 2opening a connection to the CEC adapter... 3requesting CEC bus information ... 4CEC bus information 5=================== 6device #0: TV 7address: 0.0.0.0 8active source: no 9vendor: …
Read MoreTested on a RaspberryPI 4 B 2GB. Setup Raspbian OS on the disk In a Mac for example, create a wpa_supplicant.conf in /Volumes/boot. Just replace with your country, ssid and psk 1country=US 2ctrl_interface=DIR=/var/run/wpa_supplicant GROUP=netdev 3update_config=1 45network={ 6ssid="NETWORK-NAME" …
Read MoreCheck first the names of your container: 1docker ps Technically though, it's just running a shell, so run as follows: 1docker exec -it <container-name> /bin/bash In case you see this error: 1OCI runtime exec failed: exec failed: container_linux.go:349: starting container process caused "exec: …
Read More