Re: [Zope] is it possible to upgrade from 2.9 to 2.13?

[Stefan Loidl]

Hi Fernando,

the option 'enable-product-installation' in zope.conf has to be set to
on to enable product registration of old products in the Products
directory.

Regards,
Stefan

Am 03.07.2011 18:44, schrieb Fernando Martins:
> On 07/03/2011 09:30 AM, Fernando Martins wrote:
>> merely dropping Products in the site-packages does not add a product.
>>
> Browsing through the list I saw this post:
>
> https://mail.zope.org/pipermail/zope/2011-June/176165.html
>
> with reference to a directive in zope.conf:
>
> products /usr/local/Products.CMFCore-2.2.4/
>
> I tried it with the package Products.ZSQLMethods here:
>
> http://pypi.python.org/pypi/Products.ZSQLMethods
>
> but no product is added and I see no error messages.
>
> The README.txt is not helpful and I found nothing useful in zope docs.
> In despair, I tried python setup.py build/install and all I got is a lot
> of zope packages being downloaded and dumped into the python install.
>
> Could someone be so kind to tell me the procedure to install Products
> from pypi?
>
> Is it possible to do it also with old products not in pypi?
>
> Also, what is the difference between zope.xxx and Products.xxx packages?
>
> Regards,
> Fernando
> ___
> Zope maillist  -  Zope@zope.org
> https://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>   https://mail.zope.org/mailman/listinfo/zope-announce
>   https://mail.zope.org/mailman/listinfo/zope-dev )

-- 
Stefan Loidl  Phone:  +49 89 35831 8882
Leibniz-Rechenzentrum Fax:+49 89 35831 8682
Boltzmannstr. 1   mailto:lo...@lrz.de
85748 Garchinghttp://www.lrz.de
___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

Re: [Zope] is it possible to upgrade from 2.9 to 2.13?

[Richard Harley]

Does anyone have any further information on this bug in 2.10 regarding 
ZSQL methods? Would an upgrade from 2.9 to 2.10+ in an app using lots of 
zsql methods cause unforseen issues?


On 04/07/11 09:46, Stefan Loidl wrote:
> Hi Fernando,
>
> the option 'enable-product-installation' in zope.conf has to be set to
> on to enable product registration of old products in the Products
> directory.
>
> Regards,
> Stefan
>
> Am 03.07.2011 18:44, schrieb Fernando Martins:
>> On 07/03/2011 09:30 AM, Fernando Martins wrote:
>>> merely dropping Products in the site-packages does not add a product.
>>>
>> Browsing through the list I saw this post:
>>
>> https://mail.zope.org/pipermail/zope/2011-June/176165.html
>>
>> with reference to a directive in zope.conf:
>>
>> products /usr/local/Products.CMFCore-2.2.4/
>>
>> I tried it with the package Products.ZSQLMethods here:
>>
>> http://pypi.python.org/pypi/Products.ZSQLMethods
>>
>> but no product is added and I see no error messages.
>>
>> The README.txt is not helpful and I found nothing useful in zope docs.
>> In despair, I tried python setup.py build/install and all I got is a lot
>> of zope packages being downloaded and dumped into the python install.
>>
>> Could someone be so kind to tell me the procedure to install Products
>> from pypi?
>>
>> Is it possible to do it also with old products not in pypi?
>>
>> Also, what is the difference between zope.xxx and Products.xxx packages?
>>
>> Regards,
>> Fernando
>> ___
>> Zope maillist  -  Zope@zope.org
>> https://mail.zope.org/mailman/listinfo/zope
>> **   No cross posts or HTML encoding!  **
>> (Related lists -
>>https://mail.zope.org/mailman/listinfo/zope-announce
>>https://mail.zope.org/mailman/listinfo/zope-dev )


-- 
Rich Harley
Director (Development)
(0044) 01754 871243 | http://www.scholarpack.com


___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

Re: [Zope] is it possible to upgrade from 2.9 to 2.13?

[Fernando]

I can not tell for sure if the problem was that one of the aliases
mentioned by Tres Seaver in results.py. However, I had a simple
application displaying merely one page and involving a few tables and
maybe 10 queries, and 2.10 could not even take hundreds of hits.

I made a simple Python program to hit the web site on the same page and
randomly changing the parameters. In my experience, if you cook up some
simple testing like this you'll quickly see the leak (I was using top in
Linux).

On Jul 4, 2011 10:24 "Richard Harley" 
 wrote:

> Does anyone have any further information on this bug in 2.10 regarding
> ZSQL methods? Would an upgrade from 2.9 to 2.10+ in an app using lots
> of
> zsql methods cause unforseen issues?
> 
> 
> On 04/07/11 09:46, Stefan Loidl wrote:
> > Hi Fernando,
> > 
> > the option 'enable-product-installation' in zope.conf has to be set
> > to
> > on to enable product registration of old products in the Products
> > directory.
> > 
> > Regards,
> > Stefan
> > 
> > Am 03.07.2011 18:44, schrieb Fernando Martins:
> > > On 07/03/2011 09:30 AM, Fernando Martins wrote:
> > > > merely dropping Products in the site-packages does not add a
> > > > product.
> > > > 
> > > Browsing through the list I saw this post:
> > > 
> > > 
> > > 
> > > with reference to a directive in zope.conf:
> > > 
> > > products /usr/local/Products.CMFCore-2.2.4/
> > > 
> > > I tried it with the package Products.ZSQLMethods here:
> > > 
> > > 
> > > 
> > > but no product is added and I see no error messages.
> > > 
> > > The README.txt is not helpful and I found nothing useful in zope
> > > docs.
> > > In despair, I tried python setup.py build/install and all I got is
> > > a lot
> > > of zope packages being downloaded and dumped into the python
> > > install.
> > > 
> > > Could someone be so kind to tell me the procedure to install
> > > Products
> > > from pypi?
> > > 
> > > Is it possible to do it also with old products not in pypi?
> > > 
> > > Also, what is the difference between zope.xxx and Products.xxx
> > > packages?
> > > 
> > > Regards,
> > > Fernando
> > > ___
> > > Zope maillist - 
> > > 
> > > ** No cross posts or HTML encoding! **
> > > (Related lists -
> > > 
> > >  )
> 
> ___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

Re: [Zope] is it possible to upgrade from 2.9 to 2.13?

[Fernando]

Stefan, thanks for your reply.

In the meanwhile I was indeed able to put products in INSTANCE/Products
(Zope 2.13.8). I did not know about that option you mention and I cannot
check it now, but the Products from pypi were being recognised, as long
as I put only the specific Product subfolder (not the whole pypi package
which contains "cruft" for eggs, whatever else, I still don't fully
understand).

However, with ZSQL Methods, the situation is different. It contains the
specific ZSQL Methods folder, but also Shared/DC/ZRDB. When loading,
Zope complains it can't find the module ZRDB/Search.py (or something
like that).

So, ZSQLMethods depends on Shared, but Share is not being recognised (or
at least not yet processed before ZSQL). How can I fix this? Somehow I
guess the pypi package should be made an egg and dropped in
lib/python2.6, and somehow configured. I couldn't yet find instructions
on doing this for Zope.

I've been trying to read about this whole new procedure[s] (setup tools,
buildout, eggs, virtualenv, ???), but I have the impression the
situation has been changing and it's quite hard to figure out what makes
sense or works right now.

Fernando

On Jul 4, 2011 09:46 "Stefan Loidl" 
 wrote:

> Hi Fernando,
> 
> the option 'enable-product-installation' in zope.conf has to be set to
> on to enable product registration of old products in the Products
> directory.
> 
> Regards,
> Stefan
> 
> Am 03.07.2011 18:44, schrieb Fernando Martins:
> > On 07/03/2011 09:30 AM, Fernando Martins wrote:
> > > merely dropping Products in the site-packages does not add a
> > > product.
> > > 
> > Browsing through the list I saw this post:
> > 
> > 
> > 
> > with reference to a directive in zope.conf:
> > 
> > products /usr/local/Products.CMFCore-2.2.4/
> > 
> > I tried it with the package Products.ZSQLMethods here:
> > 
> > 
> > 
> > but no product is added and I see no error messages.
> > 
> > The README.txt is not helpful and I found nothing useful in zope
> > docs.
> > In despair, I tried python setup.py build/install and all I got is a
> > lot
> > of zope packages being downloaded and dumped into the python
> > install.
> > 
> > Could someone be so kind to tell me the procedure to install
> > Products
> > from pypi?
> > 
> > Is it possible to do it also with old products not in pypi?
> > 
> > Also, what is the difference between zope.xxx and Products.xxx
> > packages?
> > 
> > Regards,
> > Fernando
> > ___
> > Zope maillist - 
> > 
> > ** No cross posts or HTML encoding! **
> > (Related lists -
> > 
> >  )___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

Re: [Zope] is it possible to upgrade from 2.9 to 2.13?

[Laurence Rowe]

On 4 July 2011 13:26, Fernando  wrote:
> Stefan, thanks for your reply.
>
> In the meanwhile I was indeed able to put products in INSTANCE/Products
> (Zope 2.13.8). I did not know about that option you mention and I cannot
> check it now, but the Products from pypi were being recognised, as long as I
> put only the specific Product subfolder (not the whole pypi package which
> contains "cruft" for eggs, whatever else, I still don't fully understand).
>
> However, with ZSQL Methods, the situation is different. It contains the
> specific ZSQL Methods folder, but also Shared/DC/ZRDB. When loading, Zope
> complains it can't find the module ZRDB/Search.py (or something like that).
>
> So, ZSQLMethods depends on Shared, but Share is not being recognised (or at
> least not yet processed before ZSQL). How can I fix this? Somehow I guess
> the pypi package should be made an egg and dropped in lib/python2.6, and
> somehow configured. I couldn't yet find instructions on doing this for Zope.
>
> I've been trying to read about this whole new procedure[s] (setup tools,
> buildout, eggs, virtualenv, ???),  but I have the impression the situation
> has been changing and it's quite hard to figure out what makes sense or
> works right now.

I suggest using http://pypi.python.org/pypi/plone.recipe.zope2instance
(it is not Plone specific) and referring to the Plone documentation
for installing add-ons:
http://plone.org/documentation/kb/add-ons/installing

Laurence
___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

Re: [Zope] is it possible to upgrade from 2.9 to 2.13?

[Fernando]

On Jul 4, 2011 13:30 "Laurence Rowe"  
wrote:

> 
> I suggest using
> 
> (it is not Plone specific) and referring to the Plone documentation
> for installing add-ons:
> 
> 


Thanks Lawrence,

I have already a zope 2.13.7 installation following the instructions and
using virtualenv. This seems to be an alternative to the buildout system
explained in those links.

There are several options in the add-ons page and I don't feel confident
it really applies to my case:

1) what is the ZSQLMethods package in pypi?
http://pypi.python.org/pypi/Products.ZSQLMethods/2.13.4. It's a zip with
some "egg-info" stuff in there but it is not clear that it really is an
egg (no .egg extension)

2) is Buildout compatible with virtualenv? The option to install an Egg
without Buildout is not recommended over there.

Fernando
___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

Re: [Zope] is it possible to upgrade from 2.9 to 2.13?

[Laurence Rowe]

On 4 July 2011 14:48, Fernando  wrote:
> On Jul 4, 2011 13:30 "Laurence Rowe"  wrote:
>
> I suggest using http://pypi.python.org/pypi/plone.recipe.zope2instance
> (it is not Plone specific) and referring to the Plone documentation
> for installing add-ons:
> http://plone.org/documentation/kb/add-ons/installing
>
> Thanks Lawrence,
>
> I have already a zope 2.13.7 installation following the instructions and
> using virtualenv. This seems to be an alternative to the buildout system
> explained in those links.
>
> There are several options in the add-ons page and I don't feel confident it
> really applies to my case:

I would recommend using buildout, most people do, if you have problems
it helps to be in the main stream.

> 1) what is the ZSQLMethods package in pypi?
> http://pypi.python.org/pypi/Products.ZSQLMethods/2.13.4. It's a zip with
> some "egg-info" stuff in there but it is not clear that it really is an egg
> (no .egg extension)

This is a source distribution that a binary egg will be automatically
built from. As you are using virtualenv you should be able to
easy_install Products.ZSQLMethods in the same way you installed Zope2.
(I hope you have some way of ensuring a consistent known good set of
packages equivalent to the buildout versions.cfg, without it you are
unlikely to get a working system.)

> 2) is Buildout compatible with virtualenv? The option to install an Egg
> without Buildout is not recommended over there.

On my development machine I have a virtualenv python (using
--no-site-packages) which I use to run buildout's bootstrap.

Laurence
___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

Re: [Zope] about the leakage in Shared.DC.ZRDB.Results.Results

[Tres Seaver]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 07/03/2011 12:54 PM, Fernando Martins wrote:
> Regarding the leakage in Shared.DC.ZRDB.Results.Results mentioned
> in:
> 
> https://mail.zope.org/pipermail/zope/2011-January/176106.html
> 
> which might very well be the leakage introduced in 2.10 that made
> ZSQL methods useless, what are the chances of being solved?
> 
> I see that Tres Seaver made a new package, SQL Adaptor (not useful to
>  me) because of this bug. Is it an indication the bug is too hard to
> fix?

The leakage occurs due to a feature ("caseless" column aliases) which
would break backward compatibiltiy if removed.  If you can live without
that feature (your app already uses the column names spelled the same
way as the RDBMS returns them, or you can change it to do so), you
should be able to apply the attached patch to remove the leaking feature.



Tres.
- -- 
===
Tres Seaver  +1 540-429-0999  tsea...@palladion.com
Palladion Software   "Excellence by Design"http://palladion.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk4R3DEACgkQ+gerLs4ltQ4gjQCglmXM907m+ysUeVyUnOHo0+sO
jUgAoJ7VWMc8XCmTQgzZ9nL8OxbZJkAO
=QTY8
-END PGP SIGNATURE-
=== modified file 'lib/python/Shared/DC/ZRDB/Results.py'
--- lib/python/Shared/DC/ZRDB/Results.py	2005-11-18 14:39:19 +
+++ lib/python/Shared/DC/ZRDB/Results.py	2011-01-27 16:09:13 +
@@ -38,7 +38,6 @@
 self._names=names=[]
 self._schema=schema={}
 self._data_dictionary=dd={}
-aliases=[]
 if zbrains is None: zbrains=NoBrains
 i=0
 for item in items:
@@ -49,10 +48,6 @@
 if schema.has_key(name):
 raise ValueError, 'Duplicate column name, %s' % name
 schema[name]=i
-n=name.lower()
-if n != name: aliases.append((n, SQLAlias(name)))
-n=name.upper()
-if n != name: aliases.append((n, SQLAlias(name)))
 dd[name]=item
 names.append(name)
 i=i+1
@@ -70,11 +65,6 @@
 if k[:2]=='__':
 setattr(r,k,getattr(Record,k))
 
-# Add SQL Aliases
-for k, v in aliases:
-if not hasattr(r, k):
-setattr(r, k, v)
-
 if hasattr(brains, '__init__'):
 binit=brains.__init__
 if hasattr(binit,'im_func'): binit=binit.im_func

___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

[Zope] www.zope.org relaunch on Thursday

[Andreas Jung]

Hi there,

www.zope.org will be relaunched this Thursday.

The current www.zope.org will be moved old.zope.org
and replaced with the new site.

During the DNS transition and while working on the sites
you may encounter outages.

The transition will start on Thursday (Germany) morning.

Andreas
<>___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )