Forums

conn = mysql.connector.connect(host='userName.mysql.pythonanywhere-services.com',database='userName$database1',user='userName',password='xxxxx',port='3306')

errno=2003, values=(self.get_address(), _strioerror(err)))
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'userName.mysql.pythonanywhere-services.com:3306' (60 Operation timed out)

from sshtunnel import SSHTunnelForwarder
        with SSHTunnelForwarder(
                 ('userName.mysql.pythonanywhere-services.com', 3306),
                 ssh_password="xxxxxxxx",
                 ssh_username="userName",
                 remote_bind_address=('127.0.0.1', 3306)) as server:

            conn = mysql.connector.connect(host='127.0.0.1',
                                   port=server.local_bind_port,
                                   user='userName',
                                   passwd='xxxxxxx',
                                   db='userName$myDb')

sshtunnel.BaseSSHTunnelForwarderError: Could not connect to gateway: userName@ssh.pythonanywhere.com ((60, 'Operation timed out'))

ssh -L 3306:username.mysql.pythonanywhere-services.com:3306 username@ssh.pythonanywhere.com

from sshtunnel import SSHTunnelForwarder
with SSHTunnelForwarder(
    ('ssh.pythonanywhere.com', 3306),
    ssh_password="xxxxxxxx",
    ssh_username="userName",
    remote_bind_address=('username.mysql.pythonanywhere-services.com', 3306)
) as server:
    conn = mysql.connector.connect(
        host='127.0.0.1',
        port=server.local_bind_port,
        user='userName',
        passwd='xxxxxxx',
        db='userName$myDb'
    )

sshtunnel.BaseSSHTunnelForwarderError: Could not connect to gateway: ssh.pythonanywhere.com ((60, 'Operation timed out'))

    remote_bind_address=(db1.mysql.pythonanywhere-services.com', 3306)
File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sshtunnel.py", line 1422, in __enter__
    self.start()
File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sshtunnel.py", line 1147, in start
    self._raise(reason=e)
File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sshtunnel.py", line 995, in _raise
    raise exception(reason)
sshtunnel.BaseSSHTunnelForwarderError: Could not connect to gateway: ssh.pythonanywhere.com ((60, 'Operation timed out')) raise exception(reason)
    sshtunnel.BaseSSHTunnelForwarderError: Could not connect to gateway: ssh.pythonanywhere.com ((60, 'Operation timed out'))

with SSHTunnelForwarder(
         ('ssh.pythonanywhere.com'),
         ssh_password="xxxxx",
         ssh_username="userName",
         remote_bind_address=('db1.mysql.pythonanywhere-services.com', 3306)

  File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/mysql/connector/connection.py", line 1383, in cursor
    raise errors.OperationalError("MySQL Connection not available.")
mysql.connector.errors.OperationalError: MySQL Connection not available.

import time

with SSHTunnelForwarder(
         ('ssh.pythonanywhere.com'),
         ssh_password="xxxxx",
         ssh_username="userName",
         remote_bind_address=('db1.mysql.pythonanywhere-services.com', 3306)
) as server:
    print("Local port: {}".format(server.local_bind_port)
    time.sleep(1000)

mysql -u userName -h localhost --port PORT_NUMBER -p 'userName$myDb'

mysql -u userName -h localhost --port 51114 -p 'userName$db1'

ERROR 1045 (28000): Access denied for user 'userName'@'localhost' (using password: YES)

mysql -u pulpiwapi -h pulpiwapi.mysql.pythonanywhere-services.com -p

12:43 ~ $ mysql -u pulpiwapi -h pulpiwapi.mysql.pythonanywhere-services.com -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.

ERROR 2003 (HY000): Can't connect to MySQL server on 'pulpiwapi.mysql.pythonanywhere-services.com' (60)

with SSHTunnelForwarder(
        ('ssh.pythonanywhere.com'),
        ssh_username="XXXX",
        ssh_password="XXXX",
        remote_bind_address=('canonsburg.mysql.pythonanywhere-services.com', 3306)
        ) as server:

        cnx = mysql.connector.connect(user='XXXX', password='XXXX',
                            port=server.local_bind_port,
                            host='127.0.0.1',database='canonsburg$default')


2016-07-21 15:22:55,592 :Connected (version 2.0, client OpenSSH_6.6.1p1)
2016-07-21 15:22:56,068 :Auth banner: b'<<<<<<:>~ PythonAnywhere SSH. Help @https://www.pythonanywhere.com/wiki/SSHAccess\n'
2016-07-21 15:22:56,068 :Authentication (password) successful!
2016-07-21 15:23:00,897 :Exception on /non_profit_connect/search [POST]
Traceback (most recent call last):
File "/home/canonsburg/.virtualenvs/my-virtualenv/lib/python3.4/site-packages/flask/app.py", line 1817, in wsgi_app
response = self.full_dispatch_request()
File "/home/canonsburg/.virtualenvs/my-virtualenv/lib/python3.4/site-packages/flask/app.py", line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/canonsburg/.virtualenvs/my-virtualenv/lib/python3.4/site-packages/flask/app.py", line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/home/canonsburg/.virtualenvs/my-virtualenv/lib/python3.4/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/home/canonsburg/.virtualenvs/my-virtualenv/lib/python3.4/site-packages/flask/app.py", line 1475, in      full_dispatch_request
rv = self.dispatch_request()
File "/home/canonsburg/.virtualenvs/my-virtualenv/lib/python3.4/site-packages/flask/app.py", line 1461, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/home/canonsburg/non-profit-connect/app.py", line 382, in non_profit_connect_search
search = User_info()
File "/home/canonsburg/non-profit-connect/info_db.py", line 22, in __init__
Cursor = cnx.cursor()
File "/home/canonsburg/.virtualenvs/my-virtualenv/lib/python3.4/site-packages/mysql/connect /connection.py", line 807, in cursor
raise errors.OperationalError("MySQL Connection not available.")
mysql.connector.errors.OperationalError: MySQL Connection not available.

import pymysql

databse=pymysql.connect(host='testdatabase.mysql.pythonanywhere-services.com',user='testdatbase',passwd='admin.sree',db='testdatabase$tutorial')
c=database.cursor()
c.execute("SELECT * FROM data")
rows=c.fetchall()
for row in rows:
    print(row)

Traceback (most recent call last):
  File "C:/Users/Sree Lakshmi/AppData/Local/Programs/Python/Python36-32/newconnection.py", line 3, in <module>
    databse=pymysql.connect(host="testdatabase.mysql.pythonanywhere-services.com",user="testdatbase",passwd="admin.sree",db="testdatabase$tutorial")
  File "C:\Users\Sree Lakshmi\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pymysql\__init__.py", line 90, in Connect
    return Connection(*args, **kwargs)
  File "C:\Users\Sree Lakshmi\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pymysql\connections.py", line 706, in __init__
    self.connect()
  File "C:\Users\Sree Lakshmi\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pymysql\connections.py", line 963, in connect
    raise exc
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'testdatabase.mysql.pythonanywhere-services.com' (timed out)")

def data_cleaner():
host = 'xxx.mysql.pythonanywhere-services.com'
user = 'xxx'
password = 'xxx'
db = 'xxx$zipcode_census'
#normally local code cannot interact with pythonanywhere database servers
#must use sshtunnel to set up an external connection
with sshtunnel.SSHTunnelForwarder(
    ('ssh.pythonanywhere.com'),
    ssh_username='xxx',
    ssh_password='xxx',
    remote_bind_address=(host, 3306)
) as server:
    connection = mysql.connector.connect(
        host='127.0.0.1',
        port=server.local_bind_port,
        user=user,
        passwd=password,
        db=db,
    )
#MySQL interface
print("connection established")
cursor = connection.cursor()

2018-06-01 17:26:00,573| ERROR   | Could not connect to gateway ssh.pythonanywhere.com:22 : 61
Traceback (most recent call last):
File "US_zipcode_cleaner.py", line 43, in <module>
data_cleaner()
File "US_zipcode_cleaner.py", line 22, in data_cleaner
remote_bind_address=(host, 3306)
File "/usr/local/lib/python3.6/site-packages/sshtunnel.py", line 1486, in __enter__
self.start()
File "/usr/local/lib/python3.6/site-packages/sshtunnel.py", line 1228, in start
reason='Could not establish session to SSH gateway')
File "/usr/local/lib/python3.6/site-packages/sshtunnel.py", line 1038, in _raise
raise exception(reason)
sshtunnel.BaseSSHTunnelForwarderError: Could not establish session to SSH gateway

raise errors.OperationalError("MySQL Connection not available.")
mysql.connector.errors.OperationalError: MySQL Connection not available.

if connection.is_connected():
    print('Connection Successful!!!')
else:
    print('connection not successful')

Connection closed by 23.21.200.247 port 22

3306:xxx.mysql.pythonanywhere-services.com: option requires an argument -- L
usage: ssh [*********] [-b bind_address] [-c cipher_spec]
       [-D [bind_address:]port] [-E log_file] [-e escape_char]
       [-F configfile] [-I pkcs11] [-i identity_file]
       [-J [user@]host[:port]] [-L address] [-l login_name] [-m mac_spec]
       [-O ctl_cmd] [-o option] [-p port] [-Q query_option] [-R address]
       [-S ctl_path] [-W host:port] [-w local_tun[:remote_tun]]
       [user@]hostname [command]