Python

Python RSS

how do I connect to MySQL server which is firewall protected?

•

Join Date: Jan 2006

Posts: 237

Reputation: katharnakh is an unknown quantity at this point

Solved Threads: 32

katharnakh katharnakh is offline

Offline

Posting Whiz in Training

how do I connect to MySQL server which is firewall protected?

Aug 3rd, 2006

I am facing problem connecting problem connecting remote MySQL server which is firewall protected. I used the valid user name and password, but it throws me the error

OperationalError: (2003, "Can't connect to MySQL server on 'www.myreomtemysqlserver.com' (10061)")

I want to connect from python.

I searched in Google is there anyway so that I can connect MySQL server through SSH. MySQL server is running on UNIX box.

Is there any thing I do on server or is there any package to connect to MySQL which is firewall protected?

Please help me out.

Thanks.

kath.

•

Join Date: Oct 2005

Posts: 521

Reputation: pty is on a distinguished road

Solved Threads: 37

pty

Offline

Posting Pro

Re: how do I connect to MySQL server which is firewall protected?

Aug 3rd, 2006

•

Originally Posted by katharnakh

I am facing problem connecting problem connecting remote MySQL server which is firewall protected. I used the valid user name and password, but it throws me the error

OperationalError: (2003, "Can't connect to MySQL server on 'www.myreomtemysqlserver.com' (10061)")

I want to connect from python.

I searched in Google is there anyway so that I can connect MySQL server through SSH. MySQL server is running on UNIX box.

Is there any thing I do on server or is there any package to connect to MySQL which is firewall protected?

Please help me out.

Thanks.

kath.

If the SSH port is open on the server's firewall (22 by default) you should be able to use a SSH tunnel to connect to mysql.

ssh -L [local port]:[mysql host]:[connect-to-port]

Then aim your connection at localhost:[local port]

For mysql the default listen port is 3306

•

Join Date: Jan 2006

Posts: 237

Reputation: katharnakh is an unknown quantity at this point

Solved Threads: 32

katharnakh katharnakh is offline

Offline

Posting Whiz in Training

Re: how do I connect to MySQL server which is firewall protected?

Aug 4th, 2006

•

Originally Posted by pty

If the SSH port is open on the server's firewall (22 by default) you should be able to use a SSH tunnel to connect to mysql.

ssh -L [local port]:[mysql host]:[connect-to-port]

Then aim your connection at localhost:[local port]

For mysql the default listen port is 3306

I knew this concept, but thanks for your reply. But how do I implement the same in Python?
I use the following code, to connect to MySQL server, sitting remote.

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
import MySQLdb
 
db=MySQLdb.connect(host="myremote_MySQL_server.com", user="USERNAME", passwd="PASSWORD", port=3306)
import MySQLdb

db=MySQLdb.connect(host="myremote_MySQL_server.com", user="USERNAME", passwd="PASSWORD", port=3306)

Can you please tell me how do I tell MySQLdb.connect() to use the SSH tunnel, by running the above command

ssh -L [local port]:[mysql host]:[connect-to-port]

Thank you.
kath.

•

Join Date: May 2006

Posts: 38

Reputation: msvinaykumar is an unknown quantity at this point

Solved Threads: 2

msvinaykumar msvinaykumar is offline

Offline

Light Poster

Re: how do I connect to MySQL server which is firewall protected?

Aug 15th, 2006

Hi Kather,
Create an account in mysql which does not require SSL
that's all Boss

•

Join Date: Oct 2005

Posts: 521

Reputation: pty is on a distinguished road

Solved Threads: 37

pty

Offline

Posting Pro

Re: how do I connect to MySQL server which is firewall protected?

Aug 16th, 2006

i presume you don't have access to change the firewall settings.

i'm no python expert so i got this from here:

mytunnel.py

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
#!/usr/bin/python
 
import socket
 
def run(host,port):
 
sd = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
 
try:
 
# connect to the given host:port
 
sd.connect((host, port))
 
except socket.error:
 
return 0
 
else:
 
return 1
 
sd.close()
#!/usr/bin/python

import socket

def run(host,port):

sd = socket.socket(socket.AF_INET, socket.SOCK_STREAM)

try:

# connect to the given host:port

sd.connect((host, port))

except socket.error:

return 0

else:

return 1

sd.close()

open.tunnel.py

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
#!/usr/bin/python
 
import os,mytunnel
 
command = '/usr/bin/ssh zarski@ssh.server.com -i /root/identity-test/id_rsa -N -L 4000:localhost:3306'
 
val = mytunnel.run('localhost',4000)
 
if not val:
 
pipe=os.popen(command,'r')
 
pipe.close()
#!/usr/bin/python

import os,mytunnel

command = '/usr/bin/ssh zarski@ssh.server.com -i /root/identity-test/id_rsa -N -L 4000:localhost:3306'

val = mytunnel.run('localhost',4000)

if not val:

pipe=os.popen(command,'r')

pipe.close()