nikitasius

#======
0.0.0.0 statsfe2.update.microsoft.com.akadns.net
0.0.0.0 fe2.update.microsoft.com.akadns.net
0.0.0.0 s0.2mdn.net
0.0.0.0 survey.watson.microsoft.com
0.0.0.0 view.atdmt.com
0.0.0.0 watson.microsoft.com
0.0.0.0 watson.ppe.telemetry.microsoft.com
0.0.0.0 vortex.data.microsoft.com
0.0.0.0 vortex-win.data.microsoft.com

nikitasius

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

nikitasius

Warning: file_get_contents(): SSL operation failed with code 1. OpenSSL Error messages: error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed

go to https://curl.haxx.se/docs/caextract.html

https://curl.haxx.se/ca/cacert.pem in /etc/ in chroot

add this into php-fpm profiles

php_admin_value[curl.cainfo] = /etc/cacert.pem
php_admin_value[openssl.cafile] = /etc/cacert.pem

nikitasius

8:43 PM	Push failed: your_reponame_is_here: failed with error: Could not read from remote repository.

==> idea.log <==
2018-02-22 20:46:48,111 [ 306076]   INFO - ellij.ide.PrivacyPolicyUpdater - Error updating privacy policy: Connection refused (Connection refused) 
2018-02-22 20:47:02,328 [ 320293]   INFO -  #git4idea.commands.GitHandler - [your_reponame_is_here] git -c core.quotepath=false -c log.showSignature=false push --progress --porcelain origin refs/heads/master:master 
2018-02-22 20:47:04,700 [ 322665]   INFO -  #git4idea.commands.GitHandler - java.io.IOException: There was a problem while connecting to github.com:22 
2018-02-22 20:47:04,701 [ 322666]   INFO -  #git4idea.commands.GitHandler - at com.trilead.ssh2.Connection.connect(Connection.java:817) 
2018-02-22 20:47:04,701 [ 322666]   INFO -  #git4idea.commands.GitHandler - at com.trilead.ssh2.Connection.connect(Connection.java:686) 
2018-02-22 20:47:04,701 [ 322666]   INFO -  #git4idea.commands.GitHandler - at com.trilead.ssh2.Connection.connect

nikitasius

• install dnsmasq (2.78+, cause 2.72 is bugged with certain DNS, including cloudflare)
• /etc/dnsmasq.conf:

port=53
listen-address=127.0.0.1
interface=lo
bind-interfaces
dnssec
dnssec-check-unsigned
trust-anchor=.,19036,8,2,49AAC11D7B6F6446702E54A1607371607A1A41855200FD2CE1CDDE32F24E8FB5

nikitasius

The problem

When you attach a file, roundcube tells you: File upload failed

I understand you

When you fixed all what you think and even fullfilled some php vars like base_dir and pack of upload* variables and you still see empty files and you wanna remove this #$%^!, just relax and..

Solution

In a config file keep/add in active plugins filesystem_attachments and remove database_attachments (if you had it).

They can't work together and attachements needs at least a filesystem_attachments.

nikitasius

Keybase proof

I hereby claim:

• I am nikitasius on github.
• I am nikitasius (https://keybase.io/nikitasius) on keybase.
• I have a public key whose fingerprint is EFED B03E 3DE4 3772 FE73 4473 E151 C0BE 20CE 81BE

To claim this, I am signing this object:

nikitasius

• dnsmasq
• wireguard
• shadowsocks

resolv.conf

echo "supersede domain-name-servers 127.0.0.1;" >> /etc/dhcp/dhclient.conf

rc.local

nikitasius

Here is tx: https://ropsten.etherscan.io/tx/0x8b831bb67c9da08c23fc1a7b34f637c233c096d8de661e831c17ff39bf632a4c

Here is block from the geth what used to send this ropsten eth: https://gist.github.com/nikitasius/6acc4c4171d5b7b3986dbeb436bb819a

Why i can't find this address 0x85e4c630348ad9ece016e47911dd1ffd1df163ad inside this block?

nikitasius

• Install Wireguard aptitude install wireguard
• create keys for your node
  • cd /etc/wireguard/
  • umask 077; wg genkey | tee wg0.key | wg pubkey > wg0.pub

Next make your config touch /etc/wireguard/wg0.conf, inside you can put this:

#VPN

[Interface]