- Zope - Zope lists

RE: [Zope] ZPygreSQL woes
by Michel Pelletier 26 Jul '99

26 Jul '99

> -----Original Message----- > From: nathan frund [mailto:ndf@rocketmail.com] > Sent: Monday, July 26, 1999 1:04 PM > To: Hannu Krosing > Cc: zope(a)zope.org > Subject: Re: [Zope] ZPygreSQL woes > > > I'm running Red Hat Linux 5.2 with kernel 2.2.9 I've run into problem where I've had to recompile packages with new kernel versions, especially new major versions when the rest of the OS was compiled against the older. Did you set your system up to be able to boot back to the stock 2.0.36 kernel that comes with RH52? I would try that first (at worst you can save your new kernel, install the RH52 kernel RPMs, rerun lilo and reboot, but *READ* the docs first before doing this! I'm sure if you've re compiled your own kernel your pretty aware, but you never know). It's pretty trivial to have your machine set up to boot any number of kernels (you can add a lilo entry for each one and just set up a default). Boot back to 2.0.36, and see if the problem persists. If not, you probably need to compile a new glibc against the new kernel, and then recomple Python, Postgress, Zope, and the DA. Or switch back to 2.0.36. -Michel > Python 1.5.2 from Oliver Andrich's site. > Postgres is version 6.4.2-5. > ZPyGreSQLDA version is 0.3. > Zope 2.0.0b1 and Zope 1.10.3 > > I also have python-PyGreSQL-2.3.2.rpm installed. I > got it from rufus.w3.org. I removed it thinking that > it conflicted or caused the problem. But removing it > didn't seem to help so I reinstalled the package. > > > I haven't tried yet but I'm going to write an > external method and see if that works. > > > I've put up a lot of info, thanks for your help. > _________________________________________________________ > DO YOU YAHOO!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

upgrade procedure
by Jens Vagelpohl 26 Jul '99

26 Jul '99

hi everyone, since all is so quiet in zope-land... let me throw out a question here :) what is the best way to upgrade (in my case from 2.0.0a3 to b1) an existing site without endangering the existing objects? i'm running it on RH6. Jens Vagelpohl

1 0

Solid DA install help
by Andrew 26 Jul '99

26 Jul '99

Does anyone have the Solid DA adapter configured to work with Zope 2.00b1 and Solid 2.3? I can make the sql.so with the following output. # make gcc -fpic -DSOLIDSQLAPI -I/usr/local/solid/include -g -O2 -I/usr/local/include/python1.5 -I/usr/local/include/python1.5 -DHAVE_CONFIG_H -c ./sql.c ./sql.c: In function `SQLBindInputParameter': ./sql.c:1360: warning: assignment from incompatible pointer type gcc -shared sql.o -L/usr/local/solid/lib -lsolcli -o sql.so When I try to test the sql.so, I get the following. #python1.5.2 Python 1.5.2 (#5, Jun 23 1999, 15:59:20) [GCC egcs-2.91.66 19990314/Linux (egcs- on linux2 Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam >>> import sql Traceback (innermost last): File "<stdin>", line 1, in ? ImportError: libsolcli.so: cannot open shared object file: No such file or directory I have "swig"ed the sql.c sql.i files with no further luck. Any help would be greatly appreciated.

1 0

RE: [Zope] Solid DA install help
by Michel Pelletier 26 Jul '99

26 Jul '99

> -----Original Message----- > From: Andrew [mailto:andrew@eventera.com] > Sent: Monday, July 26, 1999 1:14 PM > To: zope(a)zope.org > Subject: [Zope] Solid DA install help > > > Does anyone have the Solid DA adapter configured to work with Zope > 2.00b1 and Solid 2.3? > > I can make the sql.so with the following output. > > # make > gcc -fpic -DSOLIDSQLAPI -I/usr/local/solid/include -g -O2 > -I/usr/local/include/python1.5 -I/usr/local/include/python1.5 > -DHAVE_CONFIG_H -c ./sql.c > ./sql.c: In function `SQLBindInputParameter': > ./sql.c:1360: warning: assignment from incompatible pointer type > gcc -shared sql.o -L/usr/local/solid/lib -lsolcli -o sql.so > > When I try to test the sql.so, I get the following. > > #python1.5.2 > Python 1.5.2 (#5, Jun 23 1999, 15:59:20) [GCC egcs-2.91.66 > 19990314/Linux (egcs- on linux2 > Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam > >>> import sql > Traceback (innermost last): > File "<stdin>", line 1, in ? > ImportError: libsolcli.so: cannot open shared object file: No > such file > or directory > Is the path to your libsolcli.so file in your /etc/ld.so.conf file? did you run the 'ldconfig' program after editing that file? Linux can't dynamicly link programs to their required libraries unless you tell it where to look. Alternatively, and this works on Solaris too, you can add the path to the library to the LD_LIBRARY_PATH environment variable. -Michel

1 0

RE: [Zope] Newbie Question about variables in DTML
by Michel Pelletier 26 Jul '99

26 Jul '99

> -----Original Message----- > From: Donald Holten [mailto:donner@biophysics.lanl.gov] > Sent: Monday, July 26, 1999 12:56 PM > To: zope(a)zope.org > Subject: [Zope] Newbie Question about variables in DTML > > > Hi! I want to get a value from the database, increment > it by one, and > store it back into the database. Is there a way to do this > purely in DTML, or > do I have to use External Methods? Thanks! > Donner > What kind of database? The Zope one? Strange as this sounds, it would probably be a better idea to store a hit counterish thingy in a realtional database, because the Zope database is transactional, and keep *all* previous versions of objects in the database (this is so you can 'undo') therefor, if you incriment an object on every hit, your database will grow a little on every hit. You can also use an external method to store hit counts in a file. -Michel > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

Re: [Zope] ZPygreSQL woes
by nathan frund 26 Jul '99

26 Jul '99

---Hannu Krosing <hannu(a)trust.ee> wrote: > > ndf(a)rocketmail.com wrote: > > > > I've run into a problem with Zope with PostgreSQL. The query runs and > > runs and runs till all the memory on the server is used up and Zope > > falls over. > > I'm using it all the time with no major problems. > > Do the same queries run fine from psql ? Yea, even from from 'regular old Python' and with PGaccess. Here is the SQL that I used to create the table. ------------------------------- items.sql ------------------------------- CREATE TABLE items ( prodname char(20), retailPrice money, description char(80), prodVis char(80), IMpartNumber char(20), size float4, speed float4, color char(8), weight int8, height int8, width int8, onhand int8, reorder int8, discontinued boolean, supplier char(20), supplierPartNumber char(20), manufacturer char(16), cost money ); copy items from stdin using delimiters ','; "15"" 5VX 28mm",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004520,0,200 "17"" 7SP .28mm 1280x1024(1yrs warr)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004190,0,250 "17"" 70+ .28mm 1280x1024",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004120,0,300 ----------------------------------------------------- psql database < items.sql Python code that works. ------------------------------------------ from pg import * cnx=connect('database','localhost',5432) query=cnx.query('select * from items') print "\n" fields=query.listfields() print fields ------------------------------------------ > Schemas, row counts, queries executed ? The query with Zope is the same exact query with the python... "Select * from items" It stops even with only three rows in the database. The SQL above for me stops Zope and Postgres in their tracks. > Also OS, postgres and ZPygreSQLDA versions. I'm running Red Hat Linux 5.2 with kernel 2.2.9 Python 1.5.2 from Oliver Andrich's site. Postgres is version 6.4.2-5. ZPyGreSQLDA version is 0.3. Zope 2.0.0b1 and Zope 1.10.3 I also have python-PyGreSQL-2.3.2.rpm installed. I got it from rufus.w3.org. I removed it thinking that it conflicted or caused the problem. But removing it didn't seem to help so I reinstalled the package. I haven't tried yet but I'm going to write an external method and see if that works. I've put up a lot of info, thanks for your help. _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com

1 0

Newbie Question about variables in DTML
by Donald Holten 26 Jul '99

26 Jul '99

Hi! I want to get a value from the database, increment it by one, and store it back into the database. Is there a way to do this purely in DTML, or do I have to use External Methods? Thanks! Donner

1 0

Structuring Zope objects (Actors?) for global access
by Tony McDonald 26 Jul '99

26 Jul '99

I was wondering what the best practice is for allowing access to Zope objects from anywhere in the hierarchy? I intend to be able to put methods such as 'upload', 'mcq' and 'edit' at the end of URLs and have them do the appropriate things to that object at that URL (if it's permissable). eg /guides/s1ot/e47/e56/edit will edit the XML representation of a part of a study guide and /guides/s1ot/theme3/mcq will show all multiple choice questions associated with a specific section of the course. Normally I would put the objects at the top level of the tree, but having seen mentions made of UML and Actors on the list, I decided to look into that a bit more. It seems that you should do something like /guides/s1ot/e46/e56/Actors/edit and /guides/s1ot/theme3/Actors/mcq, having first put your methods etc into a folder called Actors at the top level of the hierarchy. Is this the 'Zopish' way of doing things? I mean, is this the proper way to manage these objects? (I'd like to get these fundamentals sorted out before embarking on the big stuff!). TIA tone. ------ Dr Tony McDonald, FMCC, Networked Learning Environments Project http://nle.ncl.ac.uk/ The Medical School, Newcastle University Tel: +44 191 222 5888 Fingerprint: 3450 876D FA41 B926 D3DD F8C3 F2D0 C3B9 8B38 18A2

1 0

RE: [Zope] Object RESPONSE
by Michel Pelletier 26 Jul '99

26 Jul '99

Oh wait, there does apear to be some: http://www.zope.org/Documentation/Guides/DTML/DTML-HTML/DTML.4.5.html -Michel

1 0

RE: [Zope] Object RESPONSE
by Michel Pelletier 26 Jul '99

26 Jul '99

> -----Original Message----- > From: Thierry MICHEL [mailto:thierry@geltrude.mixad.it] > Sent: Monday, July 26, 1999 6:31 AM > To: zope(a)zope.org > Subject: [Zope] Object RESPONSE > > > Hi ! > > where can I find class description of the object RESPONSE ? It doesn't apear to be very well documented i'm afraid. Do you have a specific question? -Michel > > thanks for your informations ! > > Thierry > > thierry(a)glisco.it > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0