SAWarning under TG 2.0.3

13 views
Skip to first unread message

Juan Antonio Ibáñez

unread,
Feb 23, 2012, 2:44:25 PM2/23/12
to TurboGears
Hello,

I am doing one deployment under TG 2.0.3 and when I try to log in
the app I get:

[Thu Feb 23 20:19:56 2012] [error] /usr/src/tg2env/lib/python2.4/site-
packages/SQLAlchemy-0.5.1-py2.4.egg/sqlalchemy/engine/default.py:229:
SAWarning: Unicode type received non-unicode bind param value 'user'

I can see TG defines auth member classes as Unicode but I cannot see
where the problem is.
Any idea?

Regards

Christoph Zwerschke

unread,
Feb 23, 2012, 3:41:25 PM2/23/12
to turbo...@googlegroups.com
Am 23.02.2012 20:44, schrieb Juan Antonio Ib��ez:
> [Thu Feb 23 20:19:56 2012] [error] /usr/src/tg2env/lib/python2.4/site-
> packages/SQLAlchemy-0.5.1-py2.4.egg/sqlalchemy/engine/default.py:229:
> SAWarning: Unicode type received non-unicode bind param value 'user'

You can ignore that. It is produced by the repoze auth modules, so you
can't change that anyway. With more recent versions of TG/SA/repoze it
should not appear any more.

-- Christoph

Juan Antonio Ibáñez

unread,
Feb 23, 2012, 4:44:52 PM2/23/12
to TurboGears
The system uses python 2.4 and seems not to be compatible with newer
versions as 2.1.1. Trying to use 2.1.1 I get:

[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] File "/usr/
src/tg2env/lib/python2.4/site-packages/transaction-1.2.0-py2.4.egg/
transaction/__init__.py", line 19, in ?
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] from
transaction._transaction import Transaction
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] File "/usr/
src/tg2env/lib/python2.4/site-packages/transaction-1.2.0-py2.4.egg/
transaction/_transaction.py", line 108, in ?
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] from
transaction.compat import reraise
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] File "/usr/
src/tg2env/lib/python2.4/site-packages/transaction-1.2.0-py2.4.egg/
transaction/compat.py", line 45, in ?
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] from io
import BytesIO as StringIO
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] ImportError:
No module named io

and abobe repoze error does not allow to log in the app...

Juan Antonio Ibáñez

unread,
Feb 23, 2012, 4:48:53 PM2/23/12
to TurboGears
The system uses python 2.4 and seems not to be compatible with newer
versions as 2.1.1. Trying to use 2.1.1 I get:

[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] File "/usr/
src/tg2env/lib/python2.4/site-packages/transaction-1.2.0-py2.4.egg/
transaction/__init__.py", line 19, in ?
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] from
transaction._transaction import Transaction
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] File "/usr/
src/tg2env/lib/python2.4/site-packages/transaction-1.2.0-py2.4.egg/
transaction/_transaction.py", line 108, in ?
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] from
transaction.compat import reraise
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] File "/usr/
src/tg2env/lib/python2.4/site-packages/transaction-1.2.0-py2.4.egg/
transaction/compat.py", line 45, in ?
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] from io
import BytesIO as StringIO
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] ImportError:
No module named io

and abobe repoze error does not allow to log in the app...



On 23 feb, 21:41, Christoph Zwerschke <c...@online.de> wrote:

Juan Antonio Ibáñez

unread,
Feb 23, 2012, 4:52:29 PM2/23/12
to TurboGears
The system uses python 2.4 and seems not to be compatible with newer
versions as 2.1.1. Trying to use 2.1.1 I get:

[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] File "/usr/
src/tg2env/lib/python2.4/site-packages/transaction-1.2.0-py2.4.egg/
transaction/__init__.py", line 19, in ?
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] from
transaction._transaction import Transaction
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] File "/usr/
src/tg2env/lib/python2.4/site-packages/transaction-1.2.0-py2.4.egg/
transaction/_transaction.py", line 108, in ?
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] from
transaction.compat import reraise
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] File "/usr/
src/tg2env/lib/python2.4/site-packages/transaction-1.2.0-py2.4.egg/
transaction/compat.py", line 45, in ?
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] from io
import BytesIO as StringIO
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] ImportError:
No module named io

and abobe repoze error does not allow to log in the app...



On 23 feb, 21:41, Christoph Zwerschke <c...@online.de> wrote:

Juan Antonio Ibáñez

unread,
Feb 23, 2012, 5:17:10 PM2/23/12
to TurboGears
The system uses python 2.4 and seems not to be compatible with newer
versions as 2.1.1. Trying to use 2.1.1 I get:

[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] File "/usr/
src/tg2env/lib/python2.4/site-packages/transaction-1.2.0-py2.4.egg/
transaction/__init__.py", line 19, in ?
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] from
transaction._transaction import Transaction
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] File "/usr/
src/tg2env/lib/python2.4/site-packages/transaction-1.2.0-py2.4.egg/
transaction/_transaction.py", line 108, in ?
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] from
transaction.compat import reraise
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] File "/usr/
src/tg2env/lib/python2.4/site-packages/transaction-1.2.0-py2.4.egg/
transaction/compat.py", line 45, in ?
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] from io
import BytesIO as StringIO
[Thu Feb 23 22:25:18 2012] [error] [client 2.138.60.245] ImportError:
No module named io

and abobe repoze error does not allow to log in the app...



On 23 feb, 21:41, Christoph Zwerschke <c...@online.de> wrote:

Christoph Zwerschke

unread,
Feb 23, 2012, 5:45:42 PM2/23/12
to turbo...@googlegroups.com
Am 23.02.2012 22:44, schrieb Juan Antonio Ib��ez:
> The system uses python 2.4 and seems not to be compatible with newer
> versions as 2.1.1.

No, TG 2.1.x itself works fine on Python 2.4. But it seems you have
installed newer versions of external packages that are not compatible
(e.g. transaction 1.2.0 instead of 1.1.1). You should install TG 2.1.1
with the "certified" versions on our package index:

easy_install -i http://tg.gy/2.1.1/ tg.devtools

Better, use the current version 2.1.4:

easy_install -i http://tg.gy/current/ tg.devtools

-- Christoph

Juan Antonio Ibáñez

unread,
Feb 24, 2012, 11:59:29 AM2/24/12
to TurboGears
If I run

easy_install -ihttp://tg.gy/2.1.1/tg.devtools

2.1.4 gets installed

Reading http://www.turbogears.org/2.1/downloads/current/
Processing dependencies for tg.devtools
Searching for TurboGears2>=2.1.1
Reading http://tg.gy/2.1.1/TurboGears2/
Best match: TurboGears2 2.1.4
Downloading http://www.turbogears.org/2.1/downloads/current/TurboGears2-2.1.4.tar.gz
Processing TurboGears2-2.1.4.tar.gz
Running TurboGears2-2.1.4/setup.py -q bdist_egg --dist-dir /tmp/
easy_install-MUp93l/TurboGears2-2.1.4/egg-dist-tmp-7VHXAN
Adding TurboGears2 2.1.4 to easy-install.pth file

No transaction package gets installed until 'python setup.py develop'
is executed. Once done transaction 1.2.0 gets installed instead 1.1.1:

Searching for transaction
Reading http://pypi.python.org/simple/transaction/
Reading http://www.zope.org/Products/ZODB
Best match: transaction 1.2.0
Downloading http://pypi.python.org/packages/source/t/transaction/transaction-1.2.0.tar.gz#md5=48bb47e69df085d01ebec185705b3a7f
Processing transaction-1.2.0.tar.gz

I don't understand why...

Christoph Zwerschke

unread,
Feb 24, 2012, 3:55:22 PM2/24/12
to turbo...@googlegroups.com
Am 24.02.2012 17:59, schrieb Juan Antonio Ib��ez:
> If I run
>
> easy_install -ihttp://tg.gy/2.1.1/tg.devtools
>
> 2.1.4 gets installed

Hm, at first I thought this is because spaces are missing, it should be

easy_install -i http://tg.gy/2.1.1/ tg.devtools

But then I tested it and you're right, TG2 2.1.4 gets installed instead
of TG2 2.1.1. I looked into it and I think what happens is this:
easy_install first properly installs tg.devtools 2.1.1 from our package
index. But when it continues to install the dependencies (and TG2 is the
first dependency of tg.devools), it uses the current (2.1.4) index
instead of the 2.1.1 index. This is because the dependency_links setting
in setup.py (of both tg.devtools and TG2) points to the current index
instead of the 2.1.1 index, and it seems that dependency_links overrules
the package index given with the -i option.

So it seems our old indexes have been rendered useless by the
dependency_links setting (which was introduced in 2.1.1 first).

You will probably need to manually download tg.devtools and TurboGears2
from http://tg.gy/2.1.1/, adapt the dependency_links setting from
current to 2.1.1 and then install these manually with setup.py install,
if you really want to have TG 2.1.1 with the certified dependencies.

Maybe somebody else has a better idea? How should this be fixed?

-- Christoph

Michael Pedersen

unread,
Feb 28, 2012, 11:43:04 PM2/28/12
to turbo...@googlegroups.com
I should have realized this would happen. I apologize. When doing 2.1.5, I'll re-release 2.1.1-2.1.4 to fix this problem.

On Fri, Feb 24, 2012 at 3:55 PM, Christoph Zwerschke <ci...@online.de> wrote:


-- Christoph

--
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbo...@googlegroups.com.
To unsubscribe from this group, send email to turbogears+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en.




--
Michael J. Pedersen
My Online Resume: http://www.icelus.org/ -- Google+ http://plus.ly/pedersen
Google Talk: m.ped...@icelus.org -- Twitter: pedersentg

Juan Antonio Ibáñez

unread,
Mar 6, 2012, 3:55:11 AM3/6/12
to TurboGears
Thank you Michael!

On 29 feb, 05:43, Michael Pedersen <m.peder...@icelus.org> wrote:
> I should have realized this would happen. I apologize. When doing 2.1.5,
> I'll re-release 2.1.1-2.1.4 to fix this problem.
>
>
>
>
>
>
>
>
>
> On Fri, Feb 24, 2012 at 3:55 PM, Christoph Zwerschke <c...@online.de> wrote:
> > Am 24.02.2012 17:59, schrieb Juan Antonio IbАЯez:
>
> >  If I run
>
> >>  easy_install -ihttp://tg.gy/2.1.1/tg.**devtools<http://tg.gy/2.1.1/tg.devtools>
>
> >> 2.1.4 gets installed
>
> > Hm, at first I thought this is because spaces are missing, it should be
>
> >    easy_install -ihttp://tg.gy/2.1.1/tg.devtools
>
> > But then I tested it and you're right, TG2 2.1.4 gets installed instead of
> > TG2 2.1.1. I looked into it and I think what happens is this: easy_install
> > first properly installs tg.devtools 2.1.1 from our package index. But when
> > it continues to install the dependencies (and TG2 is the first dependency
> > of tg.devools), it uses the current (2.1.4) index instead of the 2.1.1
> > index. This is because the dependency_links setting in setup.py (of both
> > tg.devtools and TG2) points to the current index instead of the 2.1.1
> > index, and it seems that dependency_links overrules the package index given
> > with the -i option.
>
> > So it seems our old indexes have been rendered useless by the
> > dependency_links setting (which was introduced in 2.1.1 first).
>
> > You will probably need to manually download tg.devtools and TurboGears2
> > fromhttp://tg.gy/2.1.1/, adapt the dependency_links setting from current
> > to 2.1.1 and then install these manually with setup.py install, if you
> > really want to have TG 2.1.1 with the certified dependencies.
>
> > Maybe somebody else has a better idea? How should this be fixed?
>
> > -- Christoph
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "TurboGears" group.
> > To post to this group, send email to turbo...@googlegroups.com.
> > To unsubscribe from this group, send email to turbogears+unsubscribe@**
> > googlegroups.com <turbogears%2Bunsu...@googlegroups.com>.
> > For more options, visit this group athttp://groups.google.com/**
> > group/turbogears?hl=en <http://groups.google.com/group/turbogears?hl=en>.
>
> --
> Michael J. Pedersen
> My Online Resume:http://www.icelus.org/-- Google+http://plus.ly/pedersen
> Google Talk: m.peder...@icelus.org -- Twitter: pedersentg
Reply all
Reply to author
Forward
0 new messages