[Zope] zope 2.11.4 + zmysqlda

[Oliver]

Hi,
I'm trying configure zope 2.11.4 + zmysqlda under Windows, for connecting it
to a mysql database.
I've done the next:

1) With zope stopped, I've downloaded zmysqlda, the last version 2.0.8, and
I copy it to ""C:\Zope\2.11.4\Zope\lib\
python\Products". It's a dir named "ZMySQLDA".
2) It needs for woking mysql-python, so I've downloaded the last version
1.2.2, as windows binary, of "
http://sourceforge.net/projects/mysql-python/files/mysql-python/1.2.2/";, the
file named MySQL-python-1.2.2.win32-py2.4.exe. It needs a python registered
in the windows registry, and the python of zope is not registered in the
installation, so I've added a manual entry in the registry:

HKLM\Software\python\pythoncore\2.4\InstallPath, here I put a entry as
reg_sz type with the value: "C:\Zope\2.11.4\Python\"

It works well ... For testing it, I go the zope python shell and I put:
import _mysql, it doesn't show error ...

3) I start zope service, but when I go to the dropdown "Add" in zope root
folder, I don't have Z Mysql ... What I do bad? I have another products
working well, as Ldapuserfolder, for example.
Thanks beforehand.

Cheers...

___
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] 2.13 upgrade problems

[Peter Bengtsson]

I'm getting the error below when trying to boot up a zope 2.13.7 using
a Data.fs I took from a zope 2.8.12 instance.
Having Products.ZSQLMethods-2.13.3 installed or not installed doesn't
appear to be relevant.
The fortunate thing, in this instance, is that the SQLMethods in that
instance are not important to me so I'd be happy to delete them if I
could.
However, I tried with ./bin/zopectl debug
>>> del app.www['id_of_a_zsql_method']
but that raises the same TypeError.

Any ideas?


2011-06-03 11:36:27 ERROR ZODB.Connection Couldn't load state for 0x5528
Traceback (most recent call last):
  File 
"/Users/peterbe/dev/ZOPE/Zope2-2.13.7/eggs/ZODB3-3.10.2-py2.6-macosx-10.4-x86_64.egg/ZODB/Connection.py",
line 856, in setstate
self._setstate(obj)
  File 
"/Users/peterbe/dev/ZOPE/Zope2-2.13.7/eggs/ZODB3-3.10.2-py2.6-macosx-10.4-x86_64.egg/ZODB/Connection.py",
line 910, in _setstate
self._reader.setGhostState(obj, p)
  File 
"/Users/peterbe/dev/ZOPE/Zope2-2.13.7/eggs/ZODB3-3.10.2-py2.6-macosx-10.4-x86_64.egg/ZODB/serialize.py",
line 612, in setGhostState
state = self.getState(pickle)
  File 
"/Users/peterbe/dev/ZOPE/Zope2-2.13.7/eggs/ZODB3-3.10.2-py2.6-macosx-10.4-x86_64.egg/ZODB/serialize.py",
line 605, in getState
return unpickler.load()
TypeError: ('argument list must be a tuple', , None)

-- 
Peter Bengtsson,
home www.peterbe.com
fun donecal.com
work www.mozilla.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] zope 2.11.4 + zmysqlda

[Michele Marcionelli]

Hi Oliver

to check if you installed Zope-Products correctly, you can have a look in the 
control panel:

http://localhost/Control_Panel/Products/manage_main

If you see *broken* icons, then you have installed something incorrectly. Try 
also checking the logfile event.log.

Regards,
Michele


On Jun 3, 2011, at 10:34 , Oliver wrote:

> Hi,
> I'm trying configure zope 2.11.4 + zmysqlda under Windows, for connecting it 
> to a mysql database.
> I've done the next:
> 
> 1) With zope stopped, I've downloaded zmysqlda, the last version 2.0.8, and I 
> copy it to ""C:\Zope\2.11.4\Zope\lib\
> python\Products". It's a dir named "ZMySQLDA".
> 2) It needs for woking mysql-python, so I've downloaded the last version 
> 1.2.2, as windows binary, of 
> "http://sourceforge.net/projects/mysql-python/files/mysql-python/1.2.2/";, the 
> file named MySQL-python-1.2.2.win32-py2.4.exe. It needs a python registered 
> in the windows registry, and the python of zope is not registered in the 
> installation, so I've added a manual entry in the registry:
> 
> HKLM\Software\python\pythoncore\2.4\InstallPath, here I put a entry as reg_sz 
> type with the value: "C:\Zope\2.11.4\Python\"
> 
> It works well ... For testing it, I go the zope python shell and I put: 
> import _mysql, it doesn't show error ...
> 
> 3) I start zope service, but when I go to the dropdown "Add" in zope root 
> folder, I don't have Z Mysql ... What I do bad? I have another products 
> working well, as Ldapuserfolder, for example.
> Thanks beforehand.
> 
> Cheers...
> ___
> 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 )

--
Michele Marcionelli · m...@ethz.ch · +41 44 632 6193
* Please consider the environment before printing

___
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] zope 2.11.4 + zmysqlda

[Oliver]

Thanks for your reply.
It is fixed now. The product in the "product management" list would appear
well (not broken), the object in an application was broken ... (I had a
backup loaded of another zope version, because I'm migrating the server).
I've fixed it using google, I've read that I may delete some files of the
mysqldb for doing it work in python 2.4... and fix some lines in DA.py and
Dabase.py ... change Imagefile for App.Imagefile.


2011/6/3 Michele Marcionelli 

> Hi Oliver
>
> to check if you installed Zope-Products correctly, you can have a look in
> the control panel:
>
> http://localhost/Control_Panel/Products/manage_main
>
> If you see *broken* icons, then you have installed something incorrectly.
> Try also checking the logfile event.log.
>
> Regards,
> Michele
>
>
> On Jun 3, 2011, at 10:34 , Oliver wrote:
>
> Hi,
> I'm trying configure zope 2.11.4 + zmysqlda under Windows, for connecting
> it to a mysql database.
> I've done the next:
>
> 1) With zope stopped, I've downloaded zmysqlda, the last version 2.0.8, and
> I copy it to ""C:\Zope\2.11.4\Zope\lib\
> python\Products". It's a dir named "ZMySQLDA".
> 2) It needs for woking mysql-python, so I've downloaded the last version
> 1.2.2, as windows binary, of "
> http://sourceforge.net/projects/mysql-python/files/mysql-python/1.2.2/";,
> the file named MySQL-python-1.2.2.win32-py2.4.exe. It needs a python
> registered in the windows registry, and the python of zope is not registered
> in the installation, so I've added a manual entry in the registry:
>
> HKLM\Software\python\pythoncore\2.4\InstallPath, here I put a entry as
> reg_sz type with the value: "C:\Zope\2.11.4\Python\"
>
> It works well ... For testing it, I go the zope python shell and I put:
> import _mysql, it doesn't show error ...
>
> 3) I start zope service, but when I go to the dropdown "Add" in zope root
> folder, I don't have Z Mysql ... What I do bad? I have another products
> working well, as Ldapuserfolder, for example.
> Thanks beforehand.
>
> Cheers...
>
> 
> ___
> 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 )
>
>
> --
> Michele Marcionelli · m...@ethz.ch · +41 44 632 6193
> * Please consider the environment before printing
>
>
___
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] 2.13 upgrade problems

[Martijn Pieters]

On Fri, Jun 3, 2011 at 12:42, Peter Bengtsson  wrote:
> I'm getting the error below when trying to boot up a zope 2.13.7 using
> a Data.fs I took from a zope 2.8.12 instance.

You may want to try to boot up the instance on intermediary Zope
versions first, it may well update the pickles for you along the way.

-- 
Martijn Pieters
___
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] 2.13 upgrade problems

[Chris Withers]

On 03/06/2011 15:25, Martijn Pieters wrote:
> On Fri, Jun 3, 2011 at 12:42, Peter Bengtsson  wrote:
>> I'm getting the error below when trying to boot up a zope 2.13.7 using
>> a Data.fs I took from a zope 2.8.12 instance.
>
> You may want to try to boot up the instance on intermediary Zope
> versions first, it may well update the pickles for you along the way.

Not quite.

I hit this problem going from Zope 2.9 to 2.12.

The answer was to load up on 2.9, save all the affected objects 
(_p_changed = 1 or some such) and then try moving to 2.12 again...

cheers,

Chris

-- 
Simplistix - Content Management, Batch Processing & Python Consulting
- http://www.simplistix.co.uk
___
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 )