export VISUAL=vim
linux set editor vim
Leave a reply
Category Archives: linux
mysql uptime days
SELECT
VARIABLE_VALUE AS Uptime_seconds,
NOW() AS "Now",
NOW() - INTERVAL VARIABLE_VALUE SECOND AS "Up since",
DATEDIFF(NOW(), NOW() - INTERVAL VARIABLE_VALUE SECOND) AS "Uptime_days"
FROM performance_schema.session_status
WHERE VARIABLE_NAME = 'Uptime';
brave fedora
sudo dnf install dnf-plugins-core
sudo dnf config-manager –add-repo https://brave-browser-rpm-release.s3.brave.com/x86_64/
sudo rpm –import https://brave-browser-rpm-release.s3.brave.com/brave-core.asc
sudo dnf install brave-browser
telnet timeout
echo 'QUIT' | nc -w SECONDS YOUR_HOST PORT; echo $?
No match for argument: vlc Error: Unable to find a match: vlc
sudo dnf install https://mirrors.rpmfusion.org/free/fedora/rpmfusion-free-release-34.noarch.rpm
sudo dnf install vlc
Status not available – monit http interface is not enabled, please add the ‘set httpd’ statement
monit status
Status not available – monit http interface is not enabled, please add the ‘set httpd’ statement
vim /etc/monit/monitrc
set httpd port 2812 and
use address 0.0.0.0
allow 0.0.0.0/0.0.0.0
monit -t
service monit reload
mysql change root auth_socket
UPDATE mysql.user SET plugin = 'mysql_native_password', authentication_string = PASSWORD('changeme') WHERE User = 'root';
FLUSH PRIVILEGES
show database collocation mysql
SELECT SCHEMA_NAME 'database', default_character_set_name 'charset', DEFAULT_COLLATION_NAME 'collation' FROM information_schema.SCHEMATA;
docker remove dangling images
docker images --quiet --filter=dangling=true | xargs --no-run-if-empty docker rmi
systemd for nginx
vim /lib/systemd/system/nginx.service
[Unit]
Description=The NGINX HTTP and reverse proxy server
After=syslog.target network.target remote-fs.target nss-lookup.target
[Service]
Type=forking
PIDFile=/run/nginx.pid
ExecStartPre=/usr/sbin/nginx -t
ExecStart=/usr/sbin/nginx
ExecReload=/bin/kill -s HUP $MAINPID
ExecStop=/bin/kill -s QUIT $MAINPID
PrivateTmp=true
[Install]
WantedBy=multi-user.target
Magento install Could not validate a connection to Elasticsearch. No alive nodes found in your cluster
php bin/magento module:disable {Magento_Elasticsearch,Magento_Elasticsearch6,Magento_Elasticsearch7}
bash: killall: command not found
apt install psmisc
diff show only differences side by side
sdiff -bBWs file1 file2
-b Ignore changes in the amount of white space
-W Ignore all white space
-B Ignore changes whose lines are all blank
-s Do not output common lines
scan all scsi_host scan for new drives
for host in `ls /sys/class/scsi_host/`;do
echo “- – -” >/sys/class/scsi_host/${host}/scan;
done
mysql show loaded config file
which mysqld
/usr/sbin/mysqld
/usr/sbin/mysqld --verbose --help | grep -A 1 "Default options"
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf