Blog Home / SIDU

Localhost SIDU ssh connect remote site localhost

2019-01-01 00:00
13016   7
 

The following line is a handy tip to allow SIDU from localhost to ssh connect remote site's localhost, when remote database is not allowed connection from a remote IP:

Open a terminal and input the following line:

# ssh -fCTMNS /tmp/sidu_tunnel -p 22 user@remote.ip -L 3307:localhost:3306

user@remote.ip == ssh user of a remote ip, and you need enter password at prompt

save temp tunnel file at the /tmp

Then open web browser eg:
http://localhost/sidu

host = 127.0.0.1
user = db-user
pass = db-pass
port = 3307

And now you can connect a localhost SIDU to a remote site's localhost !

When you finish work, you can stop the tunnel by:

# ssh -S/tmp/sidu_tunnel -O exit remote.ip

Back « Wiki: Topnew DB helper

Leave a comment

Comments

Comment is closed

Category

New Replies

» Optional sidu_fk table
» SIDU SQL in charts: howto
» Godaddy Magic Quotes Problem
» SIDU import/export data clean
» How to install databases
» SIDU feature request and bug