sexta-feira, 20 de setembro de 2013

SSH Tunneling

Let's try to get back to this useless life of blogger, taking out the spider webs and dust of the room corners. I'll return my posts registering here something to I never forget again, once it took all of one entire of my days trying to configure: A SSH tunneling through Putty! The scene which lead me to this need was that once I had a SSH access through 777 port, on a Oracle Database Server into a remote host, I had to access this database through some local application at my computer. First thing to do is configure the connection to the remote host. For example, you need to access a database that is at the 201.200.175.203 ip server, but your remote access is opened at 777 port. The configuration on Putty would be similar to this:
Next step is to configure the tunneling. This stuff called tunneling is almost like the Worm Holes used by Capitain Kirk and the Enterprise. You just have to inform to Putty that when you try to access the XXXXX port on your local machine, system will foward you to the host and port specified on your configuration: Translating what was done on the figure above. I'm informing that I'll use my local port 1521 (Source Port) to gain access to the DB server “server-oracle” - we could also inform an IP address there – at 1521 port. Click “Add” to create this configuration:
And now comes the phylosofal stone secret! The magic that will make your local application access the remote database through your TNSNAMES. You must have to inform at the HOST of your session the 127.0.0.1 IP for this database:
O SERVICE_NAME (or SID) must have to contain the database name which you would like to access. Thus, with this configuration, will be possible to make that any of your local apllications (TOAD, SQL Developer, BDE, etc.) to access the remote database trhough your Oracle Client.

Nenhum comentário:

Postar um comentário

Locations of visitors to this page
Côcos pelo Mundo