[Zope] Re: [Fwd: [Zope] PoPy Installation. Where's the BEEF?]
> The PoPy module is not installed > > So, it looks like I need to install PoPy. I went to www.mixadlive.com (PoPy > PeOpLe :) and couldn't find > it there (I don't speak Italian, so it may be right under my nose). I've > searched the > Zope archives and didn't see any leads there. > > Can anyone give me a pointer? popy and zpopyda moved to sourceforge some weeks ago, try http://popy.sourceforge.net hope this helps, federico -- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology [EMAIL PROTECTED] Debian GNU/Linux Developer & Italian Press Contact[EMAIL PROTECTED] Put a GNOME on your desktop! [http://www.gnome.org] -- brought to you by One Line Spam ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] PoPy Installation. Where's the BEEF?
Did you move this Zope from it's original location in /usr/local/zope? I'm guessing you did.. and those paths are in the .pyc files. try: find /usr/local/EcoZope -name "*.pyc" -delete then (optionally) rerun w(o?)_pgci.py which will (among other things) rebuild the .pyc files. If you don't, Zope will just be slower for a while is it rebuilds the pyc files as it imports them (mostly at startup I would guess). -steve > "Eric" == Eric Walstad <[EMAIL PROTECTED]> writes: Eric> AAKK! I just noticed something... -8<-- Start Snip Eric> --8<- ZPoPyDA Import Traceback Traceback (innermost Eric> last): File "/usr/local/Zope/lib/python/OFS/Application.py", Eric> line 397, in import_products product=__import__(pname, Eric> global_dict, global_dict, silly) File Eric> "/usr/local/zope/lib/python/Products/ZPoPyDA/__init__.py", Eric> line 32, in ? File Eric> "/usr/local/zope/lib/python/Products/ZPoPyDA/DA.py", line Eric> 35, in ? File Eric> "/usr/local/zope/lib/python/Products/ZPoPyDA/PoPy_db.py", Eric> line 35, in ? The PoPy module is not installed -8<-- Eric> End Snip --8<- Notice the paths in the traceback. Eric> I have one copy of Zope (no PostgreSQl support) in: Eric> /usr/local/Zope Eric> And another copy that will need to connect to PostgreSQL is Eric> in: /usr/local/EcoZope Eric> and ZPoPyDA is in: Eric> /usr/local/EcoZope/lib/python/Products/ZPoPyDA/ Eric> The traceback is displaying wrong paths. I searched the Eric> ZPoPyDA python source for hard coded paths but didn't find Eric> any. Is there an environment variable that sets this? Eric> Thanks for any help... Eric. Eric> Eric Walstad [EMAIL PROTECTED] Eric> ___ Zope Eric> maillist - [EMAIL PROTECTED] Eric> http://lists.zope.org/mailman/listinfo/zope ** No cross Eric> posts or HTML encoding! ** (Related lists - Eric> http://lists.zope.org/mailman/listinfo/zope-announce Eric> http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] PoPy Installation. Where's the BEEF?
AAKK! I just noticed something... -8<-- Start Snip --8<- ZPoPyDA Import Traceback Traceback (innermost last): File "/usr/local/Zope/lib/python/OFS/Application.py", line 397, in import_products product=__import__(pname, global_dict, global_dict, silly) File "/usr/local/zope/lib/python/Products/ZPoPyDA/__init__.py", line 32, in ? File "/usr/local/zope/lib/python/Products/ZPoPyDA/DA.py", line 35, in ? File "/usr/local/zope/lib/python/Products/ZPoPyDA/PoPy_db.py", line 35, in ? The PoPy module is not installed -8<-- End Snip --8<- Notice the paths in the traceback. I have one copy of Zope (no PostgreSQl support) in: /usr/local/Zope And another copy that will need to connect to PostgreSQL is in: /usr/local/EcoZope and ZPoPyDA is in: /usr/local/EcoZope/lib/python/Products/ZPoPyDA/ The traceback is displaying wrong paths. I searched the ZPoPyDA python source for hard coded paths but didn't find any. Is there an environment variable that sets this? Thanks for any help... Eric. Eric Walstad [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] PoPy Installation. Where's the BEEF?
> The PoPy module is not installed > > So, it looks like I need to install PoPy. I went to >Can anyone give me a pointer? http://freshmeat.net/search/?q=popy ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] PoPy Installation. Where's the BEEF?
Hello all, After installing the ZPoPyDA product, restarting Zope and browsing to the Products interface, I see: ZPoPyDA Import Traceback Traceback (innermost last): File "/usr/local/Zope/lib/python/OFS/Application.py", line 397, in import_products product=__import__(pname, global_dict, global_dict, silly) File "/usr/local/zope/lib/python/Products/ZPoPyDA/__init__.py", line 32, in ? File "/usr/local/zope/lib/python/Products/ZPoPyDA/DA.py", line 35, in ? File "/usr/local/zope/lib/python/Products/ZPoPyDA/PoPy_db.py", line 35, in ? The PoPy module is not installed So, it looks like I need to install PoPy. I went to www.mixadlive.com (PoPy PeOpLe :) and couldn't find it there (I don't speak Italian, so it may be right under my nose). I've searched the Zope archives and didn't see any leads there. Can anyone give me a pointer? Thanks, Eric. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] PoPy Problems
Linux 6.2, Zope 2.2.4, PostgreSQL 7.0.3, PoPy 1.4.1, ZPoPyDA 0.7.0 I installed the PoPy module and at the Python command line can "import PoPy' with no problems. I then untarred the ZPoPyDA and restarted Zope at which point I get (in the Zope management screen). ZPoPyDA Import Traceback Traceback (innermost last): File "/usr/local/zope/lib/python/OFS/Application.py", line 397, in import_products product=__import__(pname, global_dict, global_dict, silly) File "/usr/local/zope/lib/python/Products/ZPoPyDA/__init__.py", line 32, in ? import sys, os, Globals, DA File "/usr/local/zope/lib/python/Products/ZPoPyDA/DA.py", line 35, in ? from PoPy_db import DB File "/usr/local/zope/lib/python/Products/ZPoPyDA/PoPy_db.py", line 35, in ? raise "The PoPy module is not installed" The PoPy module is not installed There is really no more instructions on the site, in the INSTALL or README. If have installed and worked with ZPygreSQL before but was under the impression that it did not work with the newer versions of Zope and Postgresql. Thanks, J ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] PoPy module finally compiled but there is another prob
Paolo Quaglia wrote: > > Hi to all > Finally I compiled the Popy module (the 1.4) and I obtained the > PoPymodule.so file > I copied the module in the [ZopDir]/lib/python directory > I installed the ZPoPyDA.0.7 > > but When I start Zop this error occour: > > Traceback (innermost last): > The PoPy module is old: Update your version of PoPy Have a look at PoPy_db.py Search for __compatibility__ I don't know if it was a bad thing but I changed it ot ('1.4.1',) and the PoPyDA works. -- Andreas Heckel [EMAIL PROTECTED] LINUX is like a wigwam ...no gates ...no windows and an apache inside ;-) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] PoPy module finally compiled but there is another prob
Hi to all Finally I compiled the Popy module (the 1.4) and I obtained the PoPymodule.so file I copied the module in the [ZopDir]/lib/python directory I installed the ZPoPyDA.0.7 but When I start Zop this error occour: Traceback (innermost last): File "/usr/local/Zope-2.2.4-linux2-x86/lib/python/OFS/Application.py", line 397, in import_products product=__import__(pname, global_dict, global_dict, silly) File "/usr/local/Zope-2.2.4-linux2-x86/lib/python/Products/ZPoPyDA/__init__.py", line 32, in ? import sys, os, Globals, DA File "/usr/local/Zope-2.2.4-linux2-x86/lib/python/Products/ZPoPyDA/DA.py", line 35, in ? from PoPy_db import DB File "/usr/local/Zope-2.2.4-linux2-x86/lib/python/Products/ZPoPyDA/PoPy_db.py", line 37, in ? raise "The PoPy module is old: Update your version of PoPy" The PoPy module is old: Update your version of PoPy Has someone had the same probs? How do you think the problem is? Thanks Paolo Quaglia ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] PoPy and Delete results
Thanks for the response, Dieter. For consistency within Zope, an integer result could still be repackaged as a sequence result. For now I can do what I wanted to by: select count(food) from penguins where food='Henri Bergson' (thus getting the number of records about to be affected by a delete as a sequence result) before running: delete from penguins where food='Henri Bergson' Cheers, Chris On Tue, 28 Nov 2000, Dieter Maurer wrote: > Chris Gray writes: > > In psql a delete command returns a count of the number of rows > > deleted. Is this returned result available to a ZSQL method using PoPy or > > PyGreSQL? > I think, Zope should pass integer results from SQL commands. > But I fear, it does not. > > When I looked at the code (quite some time ago), I had the impression, > that Zope does only pass sequence results. Integer results > are translated into 'None'. > > > Dieter > > ___ > Zope maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] PoPy and Delete results
Chris Gray writes: > In psql a delete command returns a count of the number of rows > deleted. Is this returned result available to a ZSQL method using PoPy or > PyGreSQL? I think, Zope should pass integer results from SQL commands. But I fear, it does not. When I looked at the code (quite some time ago), I had the impression, that Zope does only pass sequence results. Integer results are translated into 'None'. Dieter ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] PoPy and Delete results
In psql a delete command returns a count of the number of rows deleted. Is this returned result available to a ZSQL method using PoPy or PyGreSQL? Cheers, Chris ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] PoPy and system tables
> can anybody out there tell me why this query fails > although PoPyDA is connected as postgres superuser ? > > select * from pg_class at now popy tries to dereference every oid thinking it is a large object. obviously that is not tru for oids of system tables... *grin* hope this helps, federico -- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology [EMAIL PROTECTED] Debian GNU/Linux Developer & Italian Press Contact[EMAIL PROTECTED] Best friends are often failed lovers. -- Me ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] PoPy and system tables
Chris Gray wrote: > > I can pinpoint the problem a bit more. > > select > relname, relowner, relpages, reltuples, relhasindex, relisshared, relkind, > relnatts, relchecks, reltriggers, relukeys, relfkeys, relrefs, relhaspkey, > relhasrules, relacl > from pg_class > > works fine but > > select reltype from pg_class > select relam from pg_class > select rellongrelid from pg_class > > all cause problems and sometimes crash my instance of Zope! These three > fields all have the type oid. Apparently PoPy can't handle returned > values of this type. PoPyDA has serious problems with oid fields. But I found a temporary solution. select int4(relam) from pg_class -- Andreas Heckel [EMAIL PROTECTED] UNIX is like a wigwam ...no gates ...no windows and an apache inside ;-) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] PoPy and system tables
I can pinpoint the problem a bit more. select relname, relowner, relpages, reltuples, relhasindex, relisshared, relkind, relnatts, relchecks, reltriggers, relukeys, relfkeys, relrefs, relhaspkey, relhasrules, relacl from pg_class works fine but select reltype from pg_class select relam from pg_class select rellongrelid from pg_class all cause problems and sometimes crash my instance of Zope! These three fields all have the type oid. Apparently PoPy can't handle returned values of this type. Chris On Sun, 26 Nov 2000, Andreas wrote: > Hi, > can anybody out there tell me why this query fails > although PoPyDA is connected as postgres superuser ? > > select * from pg_class > > BTW: when I try this query I get no traceback :-( > > Postgres 7.02 > PoPy 1.4.1 > ZPoPyDA 0.7 > Zope2.1.6 > Linux 2.2.13 > > > -- > _ > Andreas Heckel[EMAIL PROTECTED] > > ___ > Zope maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] PoPy and system tables
Andreas wrote: > > Hi, > can anybody out there tell me why this query fails > although PoPyDA is connected as postgres superuser ? > > select * from pg_class by now I found there is a problem with pg_class.oid. "select relname from pg_class" works fine "select oid from pg_class" fails -- Andreas Heckel [EMAIL PROTECTED] Linux is like a wigwam ...no gates ...no windows and an apache inside ;-) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] PoPy and system tables
Hi, can anybody out there tell me why this query fails although PoPyDA is connected as postgres superuser ? select * from pg_class BTW: when I try this query I get no traceback :-( Postgres 7.02 PoPy 1.4.1 ZPoPyDA 0.7 Zope2.1.6 Linux 2.2.13 -- _ Andreas Heckel[EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] PoPy
On Mon, 30 Oct 2000 10:43:16 +1030 (CST) you wrote: >ImportError: ./PoPymodule.so: Undefined symbol "sem_wait" Take a look at the man page for sem_wait(). Take the library/libraries listed there and put them on the configure line for PoPy. In my case (Solaris 2.6), I added "--with-libs=-lposix4". It'd be nice if PoPy would do this on its own. --kyler ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: [Soft] [Fwd: [Zope] PoPy]
first of all, always install the latest versions of popy and zpopyda. you can get them on our website, www.mixadlive.com. you don't need to compile the .py files of the database adapter, zope takes care of loading them through python that will compile them on the fly. please, when a compilation fails, send use some more information, at least the compiler error message and, if you can, installed packages/programs, etc... hope this helps, federico p.s. if you use the Debian distribution you can install popy and zpopyda by simply invoking "apt-get install python-popy zope-popyda" > I am new with Zope and I don't know Python. > I want to use Zope with PostgreSQL. > I have installed PoPy-1.2.1 and compiled the module PoPymodule.so. > I have also installed ZPoPyDA.0.7 in /lib/python/Products/ZPoPyDA/. > My problem is I don't know if I have to compile the Phyton files in > ZPoPyDA ? > I have tried, and some errors appeared : > > when compiling __init__.py : > ImportError: No module named Globals > when compiling PoPy_db.py : > The PoPy module is old: Update your version of PoPy > > So, I tried to install PoPy-1.3.6, but I failed! > > Is there someone who could help me ??? :-( -- Federico Di Gregorio MIXAD LIVE System Programmer [EMAIL PROTECTED] Debian GNU/Linux Developer & Italian Press Contact[EMAIL PROTECTED] Those who do not study Lisp are doomed to reimplement it. Poorly. -- from Karl M. Hegbloom .signature ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] PoPy
hello everybody, I am new with Zope and I don't know Python. I want to use Zope with PostgreSQL. I have installed PoPy-1.2.1 and compiled the module PoPymodule.so. I have also installed ZPoPyDA.0.7 in /lib/python/Products/ZPoPyDA/. My problem is I don't know if I have to compile the Phyton files in ZPoPyDA ? I have tried, and some errors appeared : when compiling __init__.py : ImportError: No module named Globals when compiling PoPy_db.py : The PoPy module is old: Update your version of PoPy So, I tried to install PoPy-1.3.6, but I failed! Is there someone who could help me ??? :-(
[Zope] PoPy
Hi all Im trying to compile PoPy on a bsd 3.1 box it compiles fine but when i try to import it i get an error ImportError: ./PoPymodule.so: Undefined symbol "sem_wait" Has anybody had this before, know what libs i need to link against to get this to work or even if this is a kernel thing? Thanks Mark ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] PoPy-1.2.tar.gz file is missing...
The PoPy-1.2.tar.gz file doesn't seem to be available from the ftp.mixadlive.com site. Would anyone out there mind emailing me the file? Thanks, Eric. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] PoPy Licence
Dear PoPy and zpopyda users, there has been a lot of discussion lately concerning the GPL issue of PoPy on zope mailing list, python mailing list and even in the Mixadlive itself. We have been thinking a lot since there. On one hand, we are very concerned about using and developing free software available for the community, on the other hand, we want to provide the best product for our user and give them the availability to enjoy popy as much as we do without having licence issue, that's free software... We have developed PoPy to work faster and cleaner and since we are using it, our work get easier than ever. That's why we have chosen to modify licences of PoPy and zpopyda and put them under the LGPL licence. We hope you'll enjoy that for comments and questions please use our mailing list : [EMAIL PROTECTED] Regards the PoPy team ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Re: Fwd: Re: [Zope] PoPy module
"Bak @ kedai" wrote: > > On Mon, 05 Jun 2000, Thierry MICHEL wrote: > > > > > 2. Whether Auto-commit mode is on or off on ZPoPyDA the new postgres > > > 7.0 syntax > > > "select * from foo limit 20 offset 10" returns all records of foo and > > > not only 20 ! > > > With PyGreSQLDA it works :-) > > > > That's running every where, it's strange that's not running on your system. > > Do you have packed the database of Zope ? Do you have create a new object ? > > > i will vouch for this, although i'm using postgres 6.5 (from rpm). i packed > the database, stop and start zope. create a zpopyda connection, and test the > connection with SQL query. and limit doesn't work. It can't worke with postgres 6.5 because it's a NEW FEATURE of postgres 7.0 :-) -- _ Andreas Heckel[EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Re: Fwd: Re: [Zope] PoPy module
On Mon, 05 Jun 2000, Thierry MICHEL wrote: > > > 2. Whether Auto-commit mode is on or off on ZPoPyDA the new postgres > > 7.0 syntax > > "select * from foo limit 20 offset 10" returns all records of foo and > > not only 20 ! > > With PyGreSQLDA it works :-) > > That's running every where, it's strange that's not running on your system. > Do you have packed the database of Zope ? Do you have create a new object ? > i will vouch for this, although i'm using postgres 6.5 (from rpm). i packed the database, stop and start zope. create a zpopyda connection, and test the connection with SQL query. and limit doesn't work. > PygresqlDA runs ok because it doesn't deal with cursors ... :-) > > Thierry > [EMAIL PROTECTED] > ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: Fwd: Re: [Zope] PoPy module
Thierry MICHEL wrote: ... > > 1. When I try to connect to postgres 6.4 using PoPy the connect fails > >postgres.log: ERROR: parser: parse error at or near "transaction" > > Postgres 6.4 seems not being SQL 92 compliant for the transactions ! > PoPy is ! pygresql no certtainly ! OK ... take it as a note for users still working with postgres 6.4 ;-) > > 2. Whether Auto-commit mode is on or off on ZPoPyDA the new postgres > > 7.0 syntax > > "select * from foo limit 20 offset 10" returns all records of foo and > > not only 20 ! > > With PyGreSQLDA it works :-) > > That's running every where, it's strange that's not running on your system. > Do you have packed the database of Zope ? Do you have create a new object ? > > PygresqlDA runs ok because it doesn't deal with cursors ... :-) I of course I packed the Zope database several times. But after I installed PoPy I did not pack it. I only created a Z PoPy Database connection and a Z SQL Method to test the DA. Please reply if I can help you with some logs or version info of my system. -- _ Andreas Heckel[EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN ;-) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: Fwd: Re: [Zope] PoPy module
On Mon, Jun 05, 2000 at 10:25:20AM +0200, [EMAIL PROTECTED] wrote: > > > -- Forwarded message -- > Da: jani <[EMAIL PROTECTED]> > Soggetto: Re: [Zope] PoPy module > Data: Sun, 04 Jun 2000 20:14:03 -0700 >A: Alexander N Gould <[EMAIL PROTECTED]> >Copia: [EMAIL PROTECTED] > > Alexander N Gould wrote: > > > > I'm trying to install the PoPy Python module on my Yellowdog Linux system > > (a redhat clone for PowerPC hardware). I'm sure it's a simple task, but I > > don't know how to do it. Any suggestions or tips? Thanks in advance. > > > > Building highways to reduce traffic is like loosening your belt to reduce > > obesity > > First make sure that pyton-devel is installed on your system. > It's available at www.python.org I think. > > Untar PoPy-1.1.tar.gz and ZPoPyDA-0.3.tar.gz . > First you have to build PoPy. > On my system I had to modify the lib and include path in Setup and > in PoPymodule.c > > Setup: > *shared* > PoPy PoPymodule.c -I/usr/local/pgsql/include -L/usr/local/pgsql/lib -lpr > > PoPymodule.c: > ... > #include > #include > ... > > Go on with: > make -f Makefile.pre.in boot > make > > You should now have the shared library PoPymodule.so . > Copy this file to python1.5/site-packages on your system. With make install, it compiles and installs directly in the python1.5/site-packages. > Now you have to install zope-popyda-0.3 > "make install" will place the Zope product to > /usr/lib/zope/lib/python/Products/ZPoPyDA > > Just move it to the Product folder of your Zope installation. > Restart Zope and it should work ;-) > > Take a look at the README. It describes the format of the connection > string. > It's different from that of PyGreSQLDA! > Also make sure that you hav set proper permissions on > &PGDATA/pg_hba.conf > > BTW after i recognized some problems using PoPy I switched back to > PyGreSQLDA. > 1. When I try to connect to postgres 6.4 using PoPy the connect fails >postgres.log: ERROR: parser: parse error at or near "transaction" Postgres 6.4 seems not being SQL 92 compliant for the transactions ! PoPy is ! pygresql no certtainly ! > 2. Whether Auto-commit mode is on or off on ZPoPyDA the new postgres > 7.0 syntax > "select * from foo limit 20 offset 10" returns all records of foo and > not only 20 ! > With PyGreSQLDA it works :-) That's running every where, it's strange that's not running on your system. Do you have packed the database of Zope ? Do you have create a new object ? PygresqlDA runs ok because it doesn't deal with cursors ... :-) Thierry [EMAIL PROTECTED] > -- > _ > Andreas Heckel[EMAIL PROTECTED] > > ___ > Zope maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > > > ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] PoPy module
Alexander N Gould wrote: > > I'm trying to install the PoPy Python module on my Yellowdog Linux system > (a redhat clone for PowerPC hardware). I'm sure it's a simple task, but I > don't know how to do it. Any suggestions or tips? Thanks in advance. > > Building highways to reduce traffic is like loosening your belt to reduce > obesity First make sure that pyton-devel is installed on your system. It's available at www.python.org I think. Untar PoPy-1.1.tar.gz and ZPoPyDA-0.3.tar.gz . First you have to build PoPy. On my system I had to modify the lib and include path in Setup and in PoPymodule.c Setup: *shared* PoPy PoPymodule.c -I/usr/local/pgsql/include -L/usr/local/pgsql/lib -lpr PoPymodule.c: ... #include #include ... Go on with: make -f Makefile.pre.in boot make You should now have the shared library PoPymodule.so . Copy this file to python1.5/site-packages on your system. Now you have to install zope-popyda-0.3 "make install" will place the Zope product to /usr/lib/zope/lib/python/Products/ZPoPyDA Just move it to the Product folder of your Zope installation. Restart Zope and it should work ;-) Take a look at the README. It describes the format of the connection string. It's different from that of PyGreSQLDA! Also make sure that you hav set proper permissions on &PGDATA/pg_hba.conf BTW after i recognized some problems using PoPy I switched back to PyGreSQLDA. 1. When I try to connect to postgres 6.4 using PoPy the connect fails postgres.log: ERROR: parser: parse error at or near "transaction" 2. Whether Auto-commit mode is on or off on ZPoPyDA the new postgres 7.0 syntax "select * from foo limit 20 offset 10" returns all records of foo and not only 20 ! With PyGreSQLDA it works :-) -- _ Andreas Heckel[EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] PoPy module
I'm trying to install the PoPy Python module on my Yellowdog Linux system (a redhat clone for PowerPC hardware). I'm sure it's a simple task, but I don't know how to do it. Any suggestions or tips? Thanks in advance. Building highways to reduce traffic is like loosening your belt to reduce obesity ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )