Change auto increment starting number on SQLite

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

Connecting to a Cisco AnyConnect on Ubuntu 16.04

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)

Continue reading

Using multiple RSA keys to connect through SSH

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 username@host.com

Continue reading