its a URL, so URL encode the + sign.
>>> from sqlalchemy.engine.url import make_url
>>> url = make_url('mysql://scott:ti%2b...@localhost')
>>> url.password
'ti+ger'
On Dec 15, 2008, at 4:24 AM, akean wrote:
>
> A password I was given to access an institutional database contains
> the character '+',
> With that password, I'm unable to use sqlalchemy to create a
> connection to either postgres or mysql.
>
> I can connect to either db engine via the command line and using
> python, django, php, no problem.
> But sqlalchemy trips up.
> After trying everything else, I changed the password to eliminate the
> '+' and the problem disappeared.
>
> Here's a minimal script which demonstrates the problem:
>
> #!/usr/bin/env python
> import sys
> from sqlalchemy import create_engine, engine
> from sqlalchemy.orm import *
> import psycopg2
>
> db_user='akea013'
> db_pass="1234+ab"
> db_host='127.0.0.1'
> db_name='akea013'
> db_engine='postgres'
> db_uri = "%s://%s:%...@%s/%s" %
> (db_engine,db_user,db_pass,db_host,db_name)
>
> engine=create_engine(db_uri, echo=True, module=psycopg2)
> connection=engine.connect()
> result=engine.execute( "select version()")
> print result
> connection.close()
>
>
> This produces
>
> Traceback (most recent call last):
> File "bootstrap.py", line 15, in <module>
> connection=engine.connect()
> File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc5dev_r5477-
> py2.5.egg/sqlalchemy/engine/base.py", line 1213, in connect
> return self.Connection(self, **kwargs)
> File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc5dev_r5477-
> py2.5.egg/sqlalchemy/engine/base.py", line 528, in __init__
> self.__connection = connection or engine.raw_connection()
> File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc5dev_r5477-
> py2.5.egg/sqlalchemy/engine/base.py", line 1268, in raw_connection
> return self.pool.unique_connection()
> File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc5dev_r5477-
> py2.5.egg/sqlalchemy/pool.py", line 119, in unique_connection
> return _ConnectionFairy(self).checkout()
> File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc5dev_r5477-
> py2.5.egg/sqlalchemy/pool.py", line 304, in __init__
> rec = self._connection_record = pool.get()
> File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc5dev_r5477-
> py2.5.egg/sqlalchemy/pool.py", line 161, in get
> return self.do_get()
> File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc5dev_r5477-
> py2.5.egg/sqlalchemy/pool.py", line 639, in do_get
> con = self.create_connection()
> File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc5dev_r5477-
> py2.5.egg/sqlalchemy/pool.py", line 122, in create_connection
> return _ConnectionRecord(self)
> File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc5dev_r5477-
> py2.5.egg/sqlalchemy/pool.py", line 198, in __init__
> self.connection = self.__connect()
> File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc5dev_r5477-
> py2.5.egg/sqlalchemy/pool.py", line 261, in __connect
> connection = self.__pool._creator()
> File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc5dev_r5477-
> py2.5.egg/sqlalchemy/engine/strategies.py", line 80, in connect
> raise exc.DBAPIError.instance(None, None, e)
> sqlalchemy.exc.OperationalError: (OperationalError) missing "=" after
> "ab" in connection info string
> None None
>
> and changing the password to 1234abab I get output
>
> 2008-12-15 22:15:30,893 INFO sqlalchemy.engine.base.Engine.0x...2aec
> select version()
> 2008-12-15 22:15:30,894 INFO sqlalchemy.engine.base.Engine.0x...2aec
> {}
> <sqlalchemy.engine.base.ResultProxy object at 0x9e4488c>
>
> Anita
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
