Memory detection in LXC containers
[ERROR] [T0] [LICENSE] License key operation failure: ERR LR.R: Memory limited license cannot be used on server with more than 8GB memory.
lxc config set web-srv security.syscalls.intercept.sysinfo=true
lxc restart web-srv
For older OS setup cron:
certbot renew –post-hook “nginx -s reload”
List the services that need restart:
vim /etc/needrestart/needrestart.conf
$nrconf{restart} = 'l';
/scripts/whoowns domain
or
grep domain /etc/userdomains
mysql> ALTER USER 'some_user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'some_password';
lsof /etc/sudoers
kill -9 process_id
SELECT CONCAT("GRANT SELECT ON ",SCHEMA_NAME,".* TO 'test_user'@'localhost';")
FROM information_schema.SCHEMATA
WHERE SCHEMA_NAME NOT LIKE 'mysql';
bash to verify root password:
sshpass -p testword ssh [email protected]
or:
pamtester system-auth root authenticate
Password:
pamtester: successfully authenticated
locale -a | grep LT
if nothing found:
locale-gen lt_LT.UTF-8
Generating locales (this might take a while)...
lt_LT.UTF-8... done
Generation complete.
filebeat output to elasticsearch indices
filebeat separate index
filebeat log different index
filebeat.inputs:
- type: log
enabled: true
paths:
- /var/log/some/path/*.log
fields:
type: "query"
- type: log
enabled: true
paths:
- /var/log/another.path/*.log
fields:
type: "error"
filebeat.config.modules:
path: ${path.config}/modules.d/*.yml
reload.enabled: false
setup.template.settings:
index.number_of_shards: 3
setup.kibana:
output.elasticsearch:
hosts: ["192.168.1.100:9200"]
index: "newindex-%{[fields.type]:other}-%{+yyyy.MM.dd}"
setup.template.name: "newindex"
setup.template.pattern: "newindex-*"
[Repl] Slave SQL for channel '': Slave failed to initialize relay log info structure from the repository, Error_code: MY-013124
mysql> start slave;
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository
mysql> reset slave;
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> CHANGE MASTER TO MASTER_HOST='172.17.0.2', MASTER_USER='repl', MASTER_PASSWORD='mypassword', MASTER_LOG_FILE='binlog.000008', MASTER_LOG_POS=157;
Query OK, 0 rows affected, 8 warnings (0.01 sec)
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
[Repl] Slave I/O thread for channel '': connected to master '[email protected]:3306',replication started in log 'binlog.000008' at position 157
To enable Percona tools:
percona-release enable tools release
* Enabling the Percona Tools repository
<*> All done
apt update
apt install percona-xtrabackup-80
vmstat -n 1 | gawk '{ print 100-int($(NF-2)); fflush(); }' | ttyplot
echo "deb [trusted=yes] https://apt.fury.io/meilisearch/ /" | sudo tee /etc/apt/sources.list.d/meilisearch.list
apt update
apt install meilisearch-http
vim /etc/systemd/system/meilisearch.service
[Unit]
Description=MeiliSearch search engine
After=network.target
[Service]
ExecStart=/usr/bin/meilisearch --http-addr 0.0.0.0:7700 --env production --master-key pwd123
Restart=always
[Install]
WantedBy=multi-user.target
some grep alias:
g(){ grep \$1 /tmp/some_data.txt | sort -k1 | awk ' {print \$1 ,\"\t\", \$3 }';}
some mkdir alias:
mkcd() { mkdir -p -- "$1" && cd -P -- "$1"; }
put to:
vim ~/.bash_alias
source ~/.bash_alias