There is no need to say that this is a security risk and a performance killer, but sometimes in debug I need to checkout every single query made to the server, so in order to do this, at least on MySQL 5.7.17 it can be enabled on runtime.
I usually only put in this blog working solutions proved by me, but in this case I did so many things that I can’t recall how I make that VPN working, but from my browser history I can reference to some of the posts that helped me do it. And the last thing that I did to make it work. I promise to update this post when I need to make this process again with the solution but until that I can’t erase it to make the process again (I don’t have the time for it)
I was just copying the public key and then accesing the server to make the authorized_keys file and so on, but this command does that automatically.
ssh-copy-id -i ~/.ssh/the-key user@host
I was just having trouble because you can’t use the same RSA key in order to connect to multiple accounts on bitbucket, this can be solved creating a new one, but you need to know how to handle them, and there is two ways to do it.
If you just need to connect with ssh to a host well you can just put it as a parameter, but this doesn’t work as a complete solution.
ssh -i PATH_TO_SSH_KEY email@example.com
I forgot a lot about the configurations needed to associate my own email account on the different applications, so here they are
Sometimes you need to run commands as another user in order to avoid permission errors, you can run a crontab as another user with the following command
sudo crontab -u USER_RUNNER -e
Just change USER_RUNNER for an existent user on your system and it will run as that user.
And by the way, if you need some assistance on how to create the different values for your cron times, and how they are defined, this is a great tool.
With SSH create a SOCKS proxy it’s really easy, just log into your account on the remote server, and leave it open
ssh -D [PORT:9000] firstname.lastname@example.org