Advanced Search
Search Results
48 total results found
SQL
PSQL get version psql -h <IP/DNS> -U <user> -d <database> -c 'SELECT VERSION()' PSQL test connection Install packages postgresql-client-common and postgresql-client-10 psql -h <host> -p <port> -U <username> -d <database> -c '\c' Database size SELECT pg_s...
ssh, bash, vim configs
SSH # disable host key check Host * StrictHostKeyChecking no ServerAliveInterval 30 Host test123 User usr Hostname qrl.ee Port 2222 IdentityFile ~/.ssh/my-priv-key.pem LocalForward 4000 localhost:4000 BASH alias ll='ls -lart...
Tips & Tricks
Rsync rsync -avh -log-file=$HOME/.rsyncd.log --delete /mnt/nas/ /mnt/mybook/nas-backup/ --dry-run -a = archive (preserve permissions, symbolic links, etc.) -v = verbose -h = human-readable --delete = delete files in destination that no longer exist in ...
Vagrant
Basic commands vagrant up vagrant provision vagrant destroy vagrant ssh vagrant status Example Vagrantfile # -*- mode: ruby -*- # vi: set ft=ruby : VAGRANTFILE_API_VERSION = "2" Vagrant.configure(VAGRANTFILE_API_VERSION) do |config| config.v...
Windows
Test IP and port connection Test-NetConnection <IP> -port <port>
Geopeitus
18650 vs 3x AAA 18650 (VTC5) Eneloop AAA x3 Eneloop AAA Nominal voltage 3.6 V 3.6 V (1.2 x3) 1.2 V Nominal capacity 2500 mAh 2250 750mAh Weight ~45 g ~35 g ~12 g Energy capacity 9 Wh 8.1 Wh 0.9 Wh Energy per gra...
Maple tapping
tüvi vähemalt 25cm diameeter lõuna poole 1m kõrgusele 0.8-1cm auk 4-5cm sügavale kerge nurga all Kask panna jooksma siis, kui vahtrast enam ei jookse.kerge nurga all spile plastikust
OpenStreetMaps
https://garmin.bbbike.org/?sw_lng=21.633&sw_lat=57.462&ne_lng=28.333&ne_lat=59.783&format=garmin-leisure.zip&coords=22.542%2C57.817%7C23.225%2C57.728%7C25.248%2C57.82%7C26.414%2C57.477%7C27.272%2C57.462%7C27.552%2C57.516%7C28.053%2C57.828%7C27.656%2C58.225%7C2...
Process memory usage
https://stackoverflow.com/questions/22261452/finding-memory-usage-of-a-process-in-linux https://stackoverflow.com/questions/131303/how-can-i-measure-the-actual-memory-usage-of-an-application-or-process # sudo ./ps_mem.py -S -p 130609 Private + Shared = ...
Squid
# Games order # How many wons did Seong Ji-hun win in gambling? 4560000 # What day is player no. 456th birthday? April 26 # What year did the first Squid Game take place? 1988 # What did Seong Ji-hun give his daughter for her birthday? lighte...
101
ee-test/GOV/70007446/hksos/ambulanceResourcesV2/v1 keskkond/asutuse-tüüp/reg-kood/alamsüsteem/teenuse-nimi/teenuse-ver
Attachment(s) / Manused
soapi manust pole kunagi salvestatud,ainult soap body, või rest body soap manus ei ela mitte kusagil seda ei salvestata, ja pole kunagi salvestatud. See on by design nii ,et soapi manusest jääb vaid hash signatuuri sees 🙂 kui turvik saadab sõnumi, siis võib ...
Errors
Server.ClientProxy.SslAuthenticationFailedService provider did not send correct authentication certificate Klient annab teada et teenuse turvikuga ei õnnestu handshake teha sest ei tule teenusepakkuja poolt auth serti Server.ServerProxy.ServiceFailed.HttpErr...
Force restore conf backup
X-Road 7 force restore conf backup Meant to be used on uninitialized ss and not in cluster From old ss - take conf backup - get UID from(UID is for ex. ee-dev/GOV/70009770/tehik_dev) cat /etc/xroad/gpghome/openpgp-revocs.d/<-SOME-NUMBERS->.rev | gre...
Increasing open files limit
Increasing xroad-proxy open file limits w/o host restart (temporary solution) prlimit --pid <xroad-proxy-PID> --nofile=10000:30000 Increasing xroad-proxy open file limits su - xroad prlimit --pid <xroad-proxy-PID> /etc/security/limits.conf xroad so...
Links
X-tee kataloog - https://x-tee.ee/catalogue Info - https://abi.ria.ee NIIS Github - https://github.com/nordic-institute/X-Road RIA Github X-Road scripts - https://github.com/ria-ee/X-Road-scripts Päringuid testimiseks - https://abi.ria.ee/xtee/et/turvaserv...
Messagelog Database info
https://moodle.ria.ee/mod/page/view.php?id=694 psql -h 127.0.0.1 -U messagelog <password from /etc/xroad/db.properties> Kui palju kirjeid on tabelis select count( *) from logrecord; Milline on kõige vanem sõnumilogi kirje baasis select to_timestamp(min( t...
MISP2
If base package is upgraded, port 8080 conf will be defaulted Uncomment port 8080 in /var/lib/tomcat8/conf/server.xml Remote database upgrade psql -h <database-ip> -p <database-port> -U postgres -d misp2db -f insert_xslt.sql When was MISP2 upgraded to newe...
Op-mon to use one IP and daemon within a cluster
1) make sure, slave nodes -> master node can connect over port 2080 2) on master node, add to /etc/xroad/conf.d/local.ini [op-monitor] host = <master-internal-IP> 3) on master node service xroad-proxy restart 4) on slave nodes service xroad-proxy re...
REST examples
listMethods curl -X GET -H "accept: application/json" -H "X-Road-Client: ee-dev/GOV/70008799/pohak" "http://10.0.13.90/r1/ee-dev/GOV/70008799/pohak/listMethods" | json_pp HTTPS with cert and key curl --cert nextcloud.bgp.12.berylia.org_cert.crt --key nextc...