For some reason I always forget which parameters needs to be used in each one of those cases, so, I’m going to put this information in this post until it burns in my brain.
Extract a tar.bz2 file or a tar.bz
tar -xvjf your_file.tar.bz2
Extract a tar.gz
tar -xvzf your_file.tar.gz
There are several commands that you can use in order to know details of the network traffic of your server.
In order to use the fingerprint reader to login and to avoid password on sudo you just need to install the fprint library
sudo apt install libpam-fprintd
Then you just need to register your fingerprints with the command
For SQLite there is a table named SQLITE_SEQUENCE with all the auto incremental values of the tables, so you need to update the value.
UPDATE SQLITE_SEQUENCE SET seq = [starting_number] WHERE name = '[table_name]';
Just change [starting_number] for the desired initial auto increment and [table_name] for the name of the table to update
There are several programs that make this happen, but after I tried some of them I found very useful one of them KAZAM
It’s very simple to install
sudo apt-get install kazam
And just run it
You can view this post for other options for it
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)