Re: [sqlalchemy] Re: (Workaround found and SA bug with localhost?) error connecting to remote mysql database

2010-03-25 Thread Conor
Richard de Koning wrote: > I've done some troubleshooting and these are my preliminary > conclusions. > > A ssh-tunnel is used to reach the remote MySQL database server that > only runs on 127.0.0.1 (localhost). > Commands sent to 127.0.0.1 port 3307 are forwarded to remote server on > port 3306. >

Re: [sqlalchemy] Re: (Workaround found and SA bug with localhost?) error connecting to remote mysql database

2010-03-25 Thread Michael Bayer
Richard de Koning wrote: > I've done some troubleshooting and these are my preliminary > conclusions. > > A ssh-tunnel is used to reach the remote MySQL database server that > only runs on 127.0.0.1 (localhost). > Commands sent to 127.0.0.1 port 3307 are forwarded to remote server on > port 3306. >

[sqlalchemy] Re: (Workaround found and SA bug with localhost?) error connecting to remote mysql database

2010-03-25 Thread Richard de Koning
That's strange. I have the same connection-string, but for me it isn't working after that. In the original script I initially connect to another database, transform the data and then create a new session to insert it in another database. I close the 1th session before creating another. > > I'm de

Re: [sqlalchemy] Re: (Workaround found and SA bug with localhost?) error connecting to remote mysql database

2010-03-25 Thread Mariano Mara
Excerpts from Richard de Koning's message of Thu Mar 25 15:50:45 -0300 2010: > I've done some troubleshooting and these are my preliminary > conclusions. > > A ssh-tunnel is used to reach the remote MySQL database server that > only runs on 127.0.0.1 (localhost). > Commands sent to 127.0.0.1 port

[sqlalchemy] Re: (Workaround found and SA bug with localhost?) error connecting to remote mysql database

2010-03-25 Thread Richard de Koning
I've done some troubleshooting and these are my preliminary conclusions. A ssh-tunnel is used to reach the remote MySQL database server that only runs on 127.0.0.1 (localhost). Commands sent to 127.0.0.1 port 3307 are forwarded to remote server on port 3306. When I connect with MySQLdb.connect a