Pythonanywhere giving MySQL connection error even without time delay

Question

I am trying to connect to my pythonanywhere DB from a local python file, using the following code.

import MySQLdb, sshtunnel
sshtunnel.SSH_TIMEOUT = 5.0
sshtunnel.TUNNEL_TIMEOUT = 5.0

queryAdd = ("INSERT INTO `****$geo***`.O***"
               "(name, address) "
               "VALUES (%s, %s)")

with sshtunnel.SSHTunnelForwarder(
    ('ssh.pythonanywhere.com'),
    ssh_username='*******', ssh_password='*******',
    remote_bind_address=('*****.mysql.pythonanywhere-services.com', 3306)
) as tunnel:
    connection = MySQLdb.connect(
        user='******',
        passwd='********',
        host='127.0.0.1', port=tunnel.local_bind_port,
        db='****$geo******',
        )

cursor = connection.cursor()    

for row in dl:
    tup=(row['name'],row['address'])
    cursor.execute(queryAdd, tup)
    connection.commit()

However, as soon as the code is run, I get the following error:

MySQLdb._exceptions.OperationalError: (2013, 'Lost connection to MySQL server during query')

There is no delay between creating the connection and running the query. What am I doing wrong?

Filip · Accepted Answer · 2021-10-21 08:54:38Z

0

You need to do everything inside your with block as the tunnel is gone when you go outside of the context.

answered Oct 21, 2021 at 8:54

Filip

6767 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

chhibbz Over a year ago

Thanks @Filip! It worked.

Collectives™ on Stack Overflow

Pythonanywhere giving MySQL connection error even without time delay

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related