- Zope - Zope lists

ZOracleDA - python - dumps core [Q]
by Bruno Mattarollo 19 Nov '99

19 Nov '99

Hello... Yes, I know, too many posts by me made in so little time ... :-) I compiled DCOracle that came in the ZOracleDA 2.1.0 to use it in our dev workstation (UltraSparc running Solaris 7, zope 2.0.1 and Oracle8i). I needed to do some tweaking into the Setup file to get it to work. But finally it compiled and worked nicely... I am using Apache 1.3.9 and PCGI <---> Zope 2.0.1 ... But I am noticing a strange behavior. From time to time (several times a day -aprox 10 to 15), randomly -or at least I couldn't see a pattern- I get a "Resource Unavailable" and clicking anywhere else works. And I get a core file in the Zope root directory. Doing a file core I get the following. core: ELF 32-bit MSB core file SPARC Version 1, from 'python' I don't know how to check what happened, but it happens anywhere in the site. Sometimes just browsing it, sometimes saving a method, sometimes when saving a ZSQL method, well, no pattern at all. Does anyone is using Zope on a similar environment? Noticied something similar? BTW I sended to Christopher Petrilli (of Digicool) a copy of the Setup file I used to compile the DCOracle. Thanks in advance. /B Bruno Mattarollo <brunomadv(a)ciudad.com.ar> --- Python Powered <http://www.python.org/psa/>

1 0

fastcgi and ISP's -- alternatives?
by Jason Jones 19 Nov '99

19 Nov '99

According to the Zope fastcgi package, it sounds like Zope will only run under a mod_fastcgi snapshot later than 2.2.2. Is this correct? I want to run Zope through fastcgi under apache on my ISP, but I doubt I can convince them to install an unstable snapshot. I've tried pcgi but it's very slow. Is there any work being done on a mod_zope or some other connection method that ISP's would willing run? I don't have the luxury of running my own server but would like to use Zope and unfortunately none of the Zope hosts listed at zope.org seems right for me. Does anyone know of ISP's providing apache/zope with fastcgi? Thanks, Jason

7 10

Re: [Zope] ZSQL retreive auto_increment id inserted [Q]
by Anthony Baxter 19 Nov '99

19 Nov '99

>>> Sam Gendler wrote > I didn't take a long look, but it looks as though this solution requires > you to call a separate ZSQL query in order to retrieve the ID. Needless to > say, there is a wide open race condition if someone else inserts another > entry before you get the results from the second query. I was looking for > something that returns the last_insert_id as the result set to an INSERT > query, much the way the apis (for mysql anyway) do in other environments. > Please correct me if I am wrong. Thanks for the effort, anyway What I do with Oracle and Sequences is have multiple ZSQL methods: the first looks up the next value: select sequence_name.nextval from dual I take this number back, and use it in subsequence DTML and SQL code.

5 5

Using Zope with PCGI
by Nemeth Miklos 19 Nov '99

19 Nov '99

I did setup my first Zope server accessed via Apache and PCGI some minutes ago, and I think now I understand how pcgi works. As far as I understood PCGI supports only an architecture where the ZServer runs on the same host as Apache. PCGI currently does not support INET sockets. Is this true? Did anyone manage to set up a Zope system with a remote Apache server? Miklos Nemeth

4 5

At a loss
by Clayton Miller 19 Nov '99

19 Nov '99

Hi all, I am new to Zope and I am attempting to use both Zope and Python for the first time. So, please excuse my ignorance. I hope to get an E-Commerce (or should I say Z-Commerce) site up soon. I was very interested in using the SQLSession object from the contribution download area. After downloading and untaring into the Zope directory (I am using RedHat so that is /usr/share/zope), all seem to go well. However, I did not find any instructions for getting the Zope Product to appear in my Zope Control Panel list. I therefore assumed that I needed to compile the code using the python compiler I had previously installed (version 1.5.2?; Zope 2.0.1 works so I assume it was 1.5.2). I looked through all of the Zope documentation I could find but I could not find how to compile Zope Products. I had previously installed the Postgresql product (which I compiled using python) and it worked flawlessly. To compile SQLSession, I used the commandline: python SQLSession.py I got a compiler error stating that it could not import Persistent from Persistence. I looked in the file /usr/share/zope/lib/python/Persistence.py and I did not find any methods. I had setup my python environment variables as: PYTHONPATH=".:/usr/share/zope/lib/python:/usr/lib/python1.5" PYTHONHOME="/usr/lib/python1.5" As I also did not find any documentation on setting up python to compile Zope objects. I just winged the above variables ;^). I have been accused of being blind in the past so I am sure that all of the documentation that I said I could not find exist somewhere. Anyway, I am now under the assumption that there is more to the compilation process than I have hacked together. Your help would be greatly appreciated. By the way, I do plan to display the Zope icon at the bottom of my pages. I think Zope is a great find. I researched several commerical and non-commerical products before deciding on Zope. I just wish a tutorial exist that walked a newbie (like myself) through all the steps to setup a simple site. I am still puzzled by by how to allow users other than "superuser" to log in. I learn more by example than by reading (as you can probably tell by my inability to locate the documentation I need). I liked the example (I can not remember the author or title, sorry) that went beyond Zen's tutorial and created a Hello World! product. However, I think it would be even better if a section was added on the compilation process for us poor souls just starting out. Thanks again! Clayton.

2 1

ANNOUNCE: ZRTChat v0.1 'Realtime' Chat example Product
by Jim Washington 19 Nov '99

19 Nov '99

ZRTChat is a pseudo-real-time (HTML) chat product for Zope. It is created with ZClasses, so it requires Zope 2.0+. It is provided as a .zexp file, so everyone can see how it is done. It probably could use some work, since it is my first ZClass Product, and it was (actually pretty easily) ported to ZClasses from its previous incarnation as folders/DTMLMethods on Zope1.03. It is fairly processor intensive, so probably not for big public pages. It has worked fine for college graduate classes of 15 or so students on-line at once. Mainly, it is (hopefully) a good example product for ZClasses, since it employs several techniques I have found useful toward my future acquisition of Zope zen... If anyone sees major code blunders, let me know ASAP so I can fix. Upgrade/feature ideas will be graciously considered. The URL is http://www.zope.org/Members/jwashin/ZRTChat. -- Jim Washington God does not play dice, but he seems to excel at billiards...

1 0

Re: [Zope] Zope-2.1.0b2 fails on access to management screen
by Martijn Pieters 19 Nov '99

19 Nov '99

At 15:52 19/11/99 , Jim Cain wrote: >On Fri, 19 Nov 1999, Martijn Pieters wrote: > > > > > >Yes, I have python 1.5.2 installed. I have used the same python > > >installation with Zope 2.0.1 and several versions before that. > > > > Hmm... and make test still does alright? You get an error with standard > > python library methods, very strange. > >Here is the make test output for python: Your tests run fine then. It's just that the call to time.gmtime(time.time()) seemd to fail. You could try and do: python >> import time >> time.gmtime(time.time()) but I think that'll be alright. The problem then list with the PCGServer. The code around this statement has changed between 2.0.1 and 2.1.0 beta 1. I have a feeling that self.reply_code (line 231) is not an integer for you. You could change this to int(self.reply_code), or change corresponding %d on line 225 (2nd one in the string) to %s. If this fixes things, file a Collector bug report. It might be something deeper, or other places may need to be fixed. -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | Tel: +31-35-7502100 Fax: +31-35-7502111 | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ------------------------------------------

1 0

RE: [Zope] ZODB or ZODBC?
by Chris Petrilli 19 Nov '99

19 Nov '99

> what is less difficult to work (ZODB or ZODBC)? Well, you can't run Zope without the Object Database (ZODB), so, it's the easiest to work with! :-) ZODBCDA requires install, and of course another database somewhere that you work with. It works great for certain types of rectangular data sets. > i am trying to make a bank site like (called internet bank), where the > bank's client need to login with a valid username/password. > to consult your > accounts. So depending on where the account information is stored, this decision will be made de-facto. > my site need to read an ASCII file, that is > exported from other > program that i make, has u ideia on how to make this? or if is this > possible? Sure, use an External Method to read it, parse it, and return it back to you as objects. Chris -- | Christopher Petrilli Digital Creations | petrilli(a)digicool.com http://www.digicool.com

2 1

Re: [Zope] fastcgi and ISP's -- alternatives?
by Jason Jones 19 Nov '99

19 Nov '99

on 11/19/99 6:07 AM, Jeff Rush at jrush(a)timecastle.net wrote: > Hi Jason, > > On Fri, 19 Nov 1999 05:13:59 +0800, Jason Jones wrote: > >> I don't have the luxury of running my >> own server but would like to use Zope and unfortunately none of the Zope >> hosts listed at zope.org seems right for me. > > Pardon me but I'm curious what the hosts listed at zope.org are lacking > that you need. You see, I'm in the process of setting myself up as a > Zope hosting ISP and would want to add anything you think is lacking. > > It's mainly a case of space and money. Of the six or so servers listed, most are expensive and are fairly limited in resources (one only lists 35megs of space and not much transfer bandwith per month) and some of them restrict what you can install as far as products go. Most standard hosts are starting to offer more generous packages (350,750+ megs, etc. and large transfer limits). Of course those are pretty basic accounts and the tech support can't boast the Zope expertise which a dedicated zope host could - so there is definitely a trade off. I may end up going with one of the Zope hosts listed though... especially since mod_fastcgi isn't really supported yet according to Scott Robertson's post (only unstable post 2.2.2 versions pass the authentication and rewrite rules won't work), but I think I will probably go with something like iserver.com or one of their resellers. They are more expensive and you do have to pay for extra space over 200megs, but they offer what is probably THE most important thing for me -- the ability to admin your own server. It's really nice to be able to set up all of your config files, set up the dynamic modules loaded into your apache instance (within reason), etc... most places only let you touch .htaccess, which is fine for lots of people, but doesn't work for me. Jason

1 0

Re: [Zope] Linking two tables
by Thomas B. Passin 19 Nov '99

19 Nov '99

-----Original Message----- From: Anders Gaarsdal Holst <anders(a)colorweb.dk> > >This question might be slightly off topic. But anywhere here it is: > >I have two tables in my MS Access database: >1. Containg a record for each employee > >2. DVD database containing a record for each DVD > >What I would like to do with Zope, is to somehow link these two >together, so that I can write on my intranet that Mr. X has DVD this >and that. > >My problem is that I can offcause make a field in the first table >(employee table), where I list the IDnumbers of the DVDs (seperated by >commas), which the employee owns, but then a query returns these id's >comma seperated and I don't how to handle this (in a <dtml-in> -loop). > > You should do this in the query to the database, not in Zope. You should make a third table that relates employees to dvds. Then, using SQL, you would use a query something like this: select employee_name, dvd_name from employee_dvd, employee.dvd where employee.employee_id=employee_dvd.employee_id and dvd.dvd_id=employee_dvd.dvd_id order by employee_name If the database supports joins you can use joins in the from statement and omit the where statement. Then you would use Zope to display the results. Tom Passin

1 0