host | DBA Knowledge Base

Create shortcuts for frequently accessed servers

January 19, 2021 Leave a comment

Life is too short, that’s why it’s mandatory to use shortcuts… Instead of typing frequently used ssh client options such as port, user, hostname, identity-file and so on, you can save that information in sshd config file and then access it with defined alias.

System wide config file location is /etc/ssh/ssh_config
User specific config file location is ~/.ssh/config same as $HOME/.ssh/config

Instead of connecting to the server everytime using the following command:

# ssh root@95.80.12.10 -i ~/.ssh/my_id_rsa

Save the following entries in ~/.ssh/config file:

# vim ~/.ssh/config

Host my_db
     HostName 95.80.12.10
     IdentityFile ~/.ssh/my_id_rsa
     User root

And connect to the server using this simple way:

# ssh my_db

For other options check https://linuxize.com/post/using-the-ssh-config-file/

Filed under Linux, Oracle Enterprise Linux, OS Tagged with config, host, shortcut, ssh

Virtualbox connect from host to guest via ssh and enable internet on guest

September 8, 2016 Leave a comment

Open Oracle VM Virtualbox Manager
Place the cursor on the machine that you want to configure and press the button Settings.
-> Network -> Adapter 1-> check Enable Network Adapter -> in Attached to choose NAT.
-> in Advanced section -> press Port Forwarding -> in Port Forwarding Rules, press addition button ->
Fill the rule , by the following way:
Host IP: (leave blank)
Host Port: 22 (or any port that your host has free)
Guest IP: (leave blank)
Guest Port: 22
Start up the VM and connect to the guest using ssh.
Hostname: localhost (or your machine name)
Port: 22 (it is the same that we have indicated during rule configuration field Host Port)
If you are not using proxy, than you can think that the post finished for you. You can connect to the guest from os and also you have an internet on your guest.
But if proxy is used then you should configure parameter http_proxy.
You can enter this variable information in every user’s ~/.bash_profile or you can do it globally in /etc/profile file.

#add the following entry in profile file

[root@oracle01 ~]# vi /etc/profile
export http_proxy=http://proxyservername.domain.ge:8080

Logout and login for changes to take effect.