Re: [Zope] Question about Upgrading Zope and OS X Server

2010-12-07 Thread Dan Gaibel
Good advice here, thanks! Is it a big mistake to stay at Zope 2.8.6? The server 
has been very stable for years, apparently. What are the downfalls of not 
upgrading all the way past 2.10?

On Dec 7, 2010, at 2:40 PM, Andrew Milton wrote:

> +---[ Tres Seaver ]--
> | -BEGIN PGP SIGNED MESSAGE-
> | Hash: SHA1
> | 
> | On 12/07/2010 01:18 PM, Dan Gaibel wrote:
> | 
> | > I have recently inherited the responsibility of supporting a fairly
> | > complex web server running Zope 2.8.6 on Python 2.3.5. This
> | > configuration is currently on a Linux (Fedora Core) server and I
> | > would like very much to migrate to OS X Server Snow Leopard. It also
> | > seems to me that I should consider upgrading Zope to a more current
> | > release while I'm at it. We heavily use MySQL and associated
> | > products, LocalFS, and the Python Imagining Library. We have a
> | > variety of ZClass homegrown products as well.
> | > 
> | > I know that I'm in for a headache no matter what, but I wonder if any
> | > of you folks could point me in the right direction or offer advice on
> | > the situation. Is it crazy to jump from 2.8.6 to 2.12? Does anyone
> | > use OS X Server for Zope? Is this migration a mistake? Any pitfalls I
> | > should be looking out for?
> | 
> | I would do this in small steps, e.g. first migrate to the new machine / OS:
> | 
> | - - Get Python 2.3.x installed on the OS/X server.
> | 
> | - - Build the latest Zope 2.8.* on that server.
> | 
> | - - Install and test products there in the same versions  you now use.
> | 
> | - - Copy your old database over and test.
> | 
> | then upgrade the software stack:
> | 
> | - - Move carefully through the Zope releases (I would to 2.9, 2.10, and'
> |   2.12), upgrading Python as needed  to stay on a supported version.
> | 
> | - - Check for upgrades to the products, and their compatibility with
> |   Zope versions.  Test them, and your site. after each upgrade.
> 
> The move from 2.9 to 2.10 is likely to be the most painful part in
> terms of legacy Zope apps. A lot of products will break on 2.10
> 
> -- 
> Andrew Milton
> a...@theinternet.com.au
> ___
> 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 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] Question about Upgrading Zope and OS X Server

2010-12-07 Thread Andrew Milton
+---[ Tres Seaver ]--
| -BEGIN PGP SIGNED MESSAGE-
| Hash: SHA1
| 
| On 12/07/2010 01:18 PM, Dan Gaibel wrote:
| 
| > I have recently inherited the responsibility of supporting a fairly
| > complex web server running Zope 2.8.6 on Python 2.3.5. This
| > configuration is currently on a Linux (Fedora Core) server and I
| > would like very much to migrate to OS X Server Snow Leopard. It also
| > seems to me that I should consider upgrading Zope to a more current
| > release while I'm at it. We heavily use MySQL and associated
| > products, LocalFS, and the Python Imagining Library. We have a
| > variety of ZClass homegrown products as well.
| > 
| > I know that I'm in for a headache no matter what, but I wonder if any
| > of you folks could point me in the right direction or offer advice on
| > the situation. Is it crazy to jump from 2.8.6 to 2.12? Does anyone
| > use OS X Server for Zope? Is this migration a mistake? Any pitfalls I
| > should be looking out for?
| 
| I would do this in small steps, e.g. first migrate to the new machine / OS:
| 
| - - Get Python 2.3.x installed on the OS/X server.
| 
| - - Build the latest Zope 2.8.* on that server.
| 
| - - Install and test products there in the same versions  you now use.
| 
| - - Copy your old database over and test.
| 
| then upgrade the software stack:
| 
| - - Move carefully through the Zope releases (I would to 2.9, 2.10, and'
|   2.12), upgrading Python as needed  to stay on a supported version.
| 
| - - Check for upgrades to the products, and their compatibility with
|   Zope versions.  Test them, and your site. after each upgrade.

The move from 2.9 to 2.10 is likely to be the most painful part in
terms of legacy Zope apps. A lot of products will break on 2.10

-- 
Andrew Milton
a...@theinternet.com.au
___
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] Question about Upgrading Zope and OS X Server

2010-12-07 Thread Tres Seaver
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 12/07/2010 01:18 PM, Dan Gaibel wrote:

> I have recently inherited the responsibility of supporting a fairly
> complex web server running Zope 2.8.6 on Python 2.3.5. This
> configuration is currently on a Linux (Fedora Core) server and I
> would like very much to migrate to OS X Server Snow Leopard. It also
> seems to me that I should consider upgrading Zope to a more current
> release while I'm at it. We heavily use MySQL and associated
> products, LocalFS, and the Python Imagining Library. We have a
> variety of ZClass homegrown products as well.
> 
> I know that I'm in for a headache no matter what, but I wonder if any
> of you folks could point me in the right direction or offer advice on
> the situation. Is it crazy to jump from 2.8.6 to 2.12? Does anyone
> use OS X Server for Zope? Is this migration a mistake? Any pitfalls I
> should be looking out for?

I would do this in small steps, e.g. first migrate to the new machine / OS:

- - Get Python 2.3.x installed on the OS/X server.

- - Build the latest Zope 2.8.* on that server.

- - Install and test products there in the same versions  you now use.

- - Copy your old database over and test.

then upgrade the software stack:

- - Move carefully through the Zope releases (I would to 2.9, 2.10, and'
  2.12), upgrading Python as needed  to stay on a supported version.

- - Check for upgrades to the products, and their compatibility with
  Zope versions.  Test them, and your site. after each upgrade.



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/

iEYEARECAAYFAkz+jJwACgkQ+gerLs4ltQ5/0wCgujisDb7vxO966ywlxvORAAsZ
vXAAnjpGkfah2Bf0ME29x5dEhhMakNdK
=rSSg
-END PGP SIGNATURE-

___
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] problem installing Openflow product of zope on LINUX

2010-12-07 Thread Philip Kilner
Hi Smita,

On 07/12/2010 15:26, Smita Kamdar wrote:
> I have already installed the following products on my dev RedHat LINUX m/c –
>
> 1) Zope-2.11.4
>
> 2) Python-2.4.4
>
> 3) Egenix-2.0.6
>
> 4) Postgresql-7.4.13
>
> 5) Psycopg-1.1.6
>
> 6) OpenFlow-1.1.0
>
> & on the live m/c also all these products are installed with a mismatch
> in versions of the products. Only in case of Database Adapter instead of
> ZPsycopgDA, ZPygresqlDA is installed on live.
>

Is there a reason that you are using ZPsycopgDA instead of ZPygresqlDA?

You should set the two environments up identically.

> But still when I import my project’s source code (i.e. .zexp file) from
> live to dev m/c all the code is imported successfully except it gives
> errors in Pygresql_Database_Connection & OpenFlow.
>
> For Pygresql_Database_Connection & Openflow it gives error as ‘This
> object from PygresqlDA product is broken’ & ‘This object from OpenFlow
> product is broken’ respectively.
>

If you are importing a zexp that contains a ZPygresqlDA connection and 
the ZPygresqlDA product is not properly installed, you will indeed have 
broken objects - that would apply to ZPsycopgDA too, of course. If you 
want to use the imported objects, you must have the same products 
installed (at the same versions).

I don't know anything about ZPygresqlDA (or OpenFlow, for that matter), 
but I've had similar problems with ZPsycopgDA, so the following may be 
of some help: -

First, is your DA correctly installed?

Take a look at the Control Panel in the ZMI, and scroll down to the DA 
itself - does it have a "broken product" icon? If so, this may be 
because the associated python-level product (which would be Psycopg 
itself in the case of ZPsycopgDA) is not correctly installed.

N.B. You may have to install libpq-dev to compile it.

Second, is the DA actually usable?

Even if it appears installed properly in the Control Panel, it's worth 
testing by setting up a new connection to your database.

If you have a good setup, and the error is still thrown, you would still 
need to zap the old product's connection and replace it with the new 
product's equivalent, of course

Formally, you are on your own importing a zexp file into a target 
environment that differs from the source environment. If the above does 
not help, then I'd go back and make the necessary changes to make them 
match before spending a lot of time on this.

HTH


-- 

Regards,

PhilK


'work as if you lived in the early days of a better nation'
- alasdair gray
___
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] Question about Upgrading Zope and OS X Server

2010-12-07 Thread Dan Gaibel
Greetings,

I have recently inherited the responsibility of supporting a fairly complex web 
server running Zope 2.8.6 on Python 2.3.5. This configuration is currently on a 
Linux (Fedora Core) server and I would like very much to migrate to OS X Server 
Snow Leopard. It also seems to me that I should consider upgrading Zope to a 
more current release while I'm at it. We heavily use MySQL and associated 
products, LocalFS, and the Python Imagining Library. We have a variety of 
ZClass homegrown products as well.

I know that I'm in for a headache no matter what, but I wonder if any of you 
folks could point me in the right direction or offer advice on the situation. 
Is it crazy to jump from 2.8.6 to 2.12? Does anyone use OS X Server for Zope? 
Is this migration a mistake? Any pitfalls I should be looking out for?

Many thanks,

Dan
___
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] problem installing Openflow product of zope on LINUX

2010-12-07 Thread Smita Kamdar
Hi Marco,

 

I have already installed the following products on my dev RedHat LINUX
m/c -

 

1) Zope-2.11.4

2) Python-2.4.4

3) Egenix-2.0.6

4) Postgresql-7.4.13

5) Psycopg-1.1.6

6) OpenFlow-1.1.0

 

& on the live m/c also all these products are installed with a mismatch
in versions of the products. Only in case of Database Adapter instead of
ZPsycopgDA, ZPygresqlDA is installed on live.

 

But still when I import my project's source code (i.e. .zexp file) from
live to dev m/c all the code is imported successfully except it gives
errors in Pygresql_Database_Connection & OpenFlow.

 

For Pygresql_Database_Connection & Openflow it gives error as 'This
object from PygresqlDA product is broken' & 'This object from OpenFlow
product is broken' respectively.

 

Is the issue because of mismatch of PygresqlDA & PsycopgDA at live & dev
respectively??

Thanks a Lot In Advance!

 

 

Thanks & Regards,

Smita Kamdar 

 

 

 


Disclaimer:
  This message and the information contained herein is proprietary and 
confidential and subject to the Tech Mahindra policy statement, you may review 
the policy at http://www.techmahindra.com/Disclaimer.html";>http://www.techmahindra.com/Disclaimer.html
 externally and http://tim.techmahindra.com/Disclaimer.html";>http://tim.techmahindra.com/Disclaimer.html
 internally within Tech 
Mahindra.
___
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] Iteration over columns in ZSQLMethod result not working in Zope 2.12.13

2010-12-07 Thread Tres Seaver
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 12/07/2010 09:19 AM, Tres Seaver wrote:
> On 12/07/2010 05:02 AM, Andreas Elvers wrote:
>> To answer part of my own question:
> 
>> ZSQLMethod  column iteration went away with 2.12. Up until Zope 2.11.7 
>> still had this feature available with no deprecation messages logged 
>> when using this feature.
> 
>> Should I file a bug for missing deprecation messages in 2.11 or for 
>> missing functionality in 2.12 ?
> 
> Hmmm, I would file it as missing functionality in 2.12.  The bug may be
> due to changes in the supported version of Python (2.4 for Zope < 2.12,
> 2.6 for 2.12).

The attached script should help isolate the bug without needing an
actual SQL connection.  Under 2.11, run as::

 $ PYTHONPATH=lib/python /path/to/python2.4 iter_results_record.py

Under 2.12, run as::

 $ bin/allpy iter_results_record.py

Note that the script runs without errors under both versions for me:
likely the security machinery isn't actually being wired up.  I'm out of
time, however, to think harder about it.



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/

iEYEARECAAYFAkz+UdoACgkQ+gerLs4ltQ7rPwCguzHh/nFv1hexflrJkNDl/YEI
OL0AoMsiIAv/p647aaACgvieRDhiUPRx
=6YB9
-END PGP SIGNATURE-


iter_results_record.py
Description: application/httpd-cgi
___
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] Iteration over columns in ZSQLMethod result not working in Zope 2.12.13

2010-12-07 Thread Tres Seaver
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 12/07/2010 05:02 AM, Andreas Elvers wrote:
> To answer part of my own question:
> 
> ZSQLMethod  column iteration went away with 2.12. Up until Zope 2.11.7 
> still had this feature available with no deprecation messages logged 
> when using this feature.
> 
> Should I file a bug for missing deprecation messages in 2.11 or for 
> missing functionality in 2.12 ?

Hmmm, I would file it as missing functionality in 2.12.  The bug may be
due to changes in the supported version of Python (2.4 for Zope < 2.12,
2.6 for 2.12).



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/

iEYEARECAAYFAkz+QoAACgkQ+gerLs4ltQ7wMwCg1p4q1uBIk3BVWpDPU3fyx2dU
cVYAnAjA+JzC9W+q5VPlDyXUMOIEHA6l
=CNid
-END PGP SIGNATURE-

___
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] Iteration over columns in ZSQLMethod result not working in Zope 2.12.13

2010-12-07 Thread Tres Seaver
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 12/01/2010 08:27 AM, Andreas Elvers wrote:
> Hi,
> 
> I stumbled over the following error using Zope 2.12.13. Bug ?
> 
> Given some ZSQLMethod,  and either ZMySQLDA (3.1.1) or ZPsycopgDA 
> (2.0.14 or 2.2.2)
> and the following python script:
> 
> result = context.someZSQLMethod()
> for row in result:
> for col in row: #this will fail
>pass

Does the "safe list" builtin work for you in 2.12?

  for row in result:
  for col in list(row):
  pass



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/

iEYEARECAAYFAkz+QnwACgkQ+gerLs4ltQ5kmQCfdzh17HxciJxRhr2oQwkxqrcL
ewkAoNc4bvQ/mI5fEq1xkrmn9bPiVWzA
=ZEge
-END PGP SIGNATURE-

___
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] Iteration over columns in ZSQLMethod result not working in Zope 2.12.13

2010-12-07 Thread Andreas Elvers
Hi Tres,

[...]
>> Given some ZSQLMethod,  and either ZMySQLDA (3.1.1) or ZPsycopgDA
>> (2.0.14 or 2.2.2)
>> and the following python script:
>>
>> result = context.someZSQLMethod()
>> for row in result:
>>  for col in row: #this will fail
>> pass
>>
>> I get an AttributeError: __iter__

[...]

> I don't think the Record class fills the 'tp_iter' slot.  [...]

I don't know about this tp_iter slot, but adding the following
DocTest to the Record tests.py will pass:

def test_RecordIteration():
 """

 Creating a record

 >>> r = P(('zx', 81 , 1.23))

 We can iterate over a record:

 >>> [i for i in r]
 ['zx', 81, 1.23]

 """

- 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 )


Re: [Zope] Iteration over columns in ZSQLMethod result not working in Zope 2.12.13

2010-12-07 Thread Andreas Elvers
To answer part of my own question:

ZSQLMethod  column iteration went away with 2.12. Up until Zope 2.11.7 
still had this feature available with no deprecation messages logged 
when using this feature.

Should I file a bug for missing deprecation messages in 2.11 or for 
missing functionality in 2.12 ?

- 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 )