I'm pretty new using sqlalchemy and I will probably ask some smart and
a lot of silly questions.
At the moment I'm having problems with connecting to remote MySQL
databases. If I run the updates on a local database everything works
fine.
When I try to connect to a remote database I keep getting the
following errors:
File "/usr/lib/pymodules/python2.6/sqlalchemy/pool.py", line 142, in
connect
return _ConnectionFairy(self).checkout()
File "/usr/lib/pymodules/python2.6/sqlalchemy/pool.py", line 304, in
__init__
rec = self._connection_record = pool.get()
File "/usr/lib/pymodules/python2.6/sqlalchemy/pool.py", line 161, in
get
return self.do_get()
File "/usr/lib/pymodules/python2.6/sqlalchemy/pool.py", line 639, in
do_get
con = self.create_connection()
File "/usr/lib/pymodules/python2.6/sqlalchemy/pool.py", line 122, in
create_connection
return _ConnectionRecord(self)
File "/usr/lib/pymodules/python2.6/sqlalchemy/pool.py", line 198, in
__init__
self.connection = self.__connect()
File "/usr/lib/pymodules/python2.6/sqlalchemy/pool.py", line 261, in
__connect
connection = self.__pool._creator()
File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/strategies.py",
line 80, in connect
raise exc.DBAPIError.instance(None, None, e)
OperationalError: (OperationalError) (2003, "Can't connect to MySQL
server on 'xxx.xxx.xxx.xxx' (111)") None None
I checked the userrights. Tried with root and installed sqlalchemy and
python-bindings for mysql on the server. I also tried on several
servers with different OS-versions, but I can't see anything wrong.
Manual logins with mysql-client to the servers work.
Can anybody give any pointers how to solve this?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
