March 1999 - Zope - Zope lists

RE: [Zope] Plenty of problems. Please Help
by Michel Pelletier 05 Mar '99

05 Mar '99

> -----Original Message----- > From: Pavlos Christoforou [mailto:pavlos@gaaros.msrc.sunysb.edu] > Sent: Friday, March 05, 1999 5:47 AM > To: zope(a)zope.org > Subject: [Zope] Plenty of problems. Please Help > > > Zopistas > > I have encountered problems mainly associated with ZServer and ZAP: > > I am using Zope-1.9.0 and the preconfigured Apache server to > run my Zope > site. Last night (a couple of hours ago!) I installed > ZServer. It wouldn't > run and I had to add the following to start.py to fix it: > I would suggest, first off, to use 1.10.2. ZServer is being developed against 1.10.2, and the latest Zap was tested and confirmed to work with it. > import sys,os > sys.path.insert(0,os.path.join('..','lib','python')) > Yes, there were discussions on this in the list about this problem. Someone needs to go back, rassle up the discussion and submit it to the ZDP. Looks like you found the fix. > Later on upon entering the management screens I noticed that > the id of the > top level folder dissappeared which caused the paths to my objects to > change. With ZAP (the preconfigured apache) I would visit: > http://www.gaaros.com:8080/Gaaros/ to get to the top level > directory but > with ZServer is: http://www.gaaros.com:8080/ which spoils all kind of > links that people have on my site. Hm. Is your Zap .pcgi file named Garros or does your RewriteRule look for Garros and then call PCGI? If so that is why you need to use Garros to reach the server. ZServer can server right out of Zope and doesn't have this problem. Your description makes this sould like it is a production site, I would not suggest running ZServer on a production machine as it is alpha and still buggy. > > Switching back to ZAP I got the following error: > > <FONT SIZE="+2">Temporarily Unavailable</FONT> > <P> > The resource you requested is temporarily unavailable - > please try again > later. > </TD> > </TR> > </TABLE> > (102) failure during connect >  > </BODY></HTML> > > Seems like ZServer changed my root id from "Gaaros" to nothing. This error comes from PCGI. It can't find your .cgi file so Zope isn't even being launched. Did your zap.conf file change (specificly the RewriteRule)? > I called PickleDictionary on Data.bbb directly from python > but I could not > even see the subobjects. BTW can the Zope Data.bbb be > accessed directly > from PickleDictionary?? > You can open a Data.bbb file into a PickleDictionary, but you won't see anything useful unless you really know what your doing. The Database itself is not a Pickle, it is a database of Pickles. I have attached a small 5K script that will be released with 1.10.3 which paruses the database and generates reports. In the future we are intending it to translate the entire database into XML for transport. (Note, we do not intend to use XML as the db format) > Also trying to shut ZServer from the control-panel results in > a core dump. > I suspect this is because you are using 1.9.0 > Ok enough for now, its very late and I cannot think anymore. > > If anybody has any clues about the root object id problem > please let me > know. > > Thanks > > Pavlos > > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope >

1 0

RE: [Zope] zope ZGadfly DA buggy
by Paul Everitt 05 Mar '99

05 Mar '99

Aaron wrote: > I'm sure these will be fixed soon, in fact I'd offer a patch > if I could > figure out how the thing works, but until then, Right, understood. We had to spend a lot of time figuring out Gadfly in order to host it inside Zope. Thus we labeled it "Demo". I imagine that it is best for everybody if we take Gadfly out of the base Zope and make it an external, no-warranty package like the MySQL support. --Paul

2 1

RE: [Zope] Some tough questions about zope... (long)
by Paul Everitt 05 Mar '99

05 Mar '99

Tony wrote: > This is quite a long email where I ask a lot of questions about Zope, > but I hope you'll be lenient with me as I think I have a few hard > decisions to make! I appreciate your patience and taking the time to submit well-thought questions. > Some background: > I'm one of the web developers here, with a remit to implement a > curriculum database that can; > (a) support the Medical Faculty here > (b) get rolled out to three other Medical-related sites, each with > their own 'look and feel' > (c) possibly implement a University-wide curriculum database. Sounds fantastic! > The curriculum database is essentially delivering online study guides > (over 100 for each Faculty) whose source is originally from very well > marked up Word Documents. In addition, we include multiple choice This is really weird, it just reminded me of a (rather pathetic) dream I had last night. I dreamt that someone created a Python module that would read Word files. My DreamTV must be picking up the wrong channel. > questions, file upload of lecture notes etc. and some 'active' web > pages showing dynamical processes in medicine etc. The curriculum > database needs to be searchable across its entire breadth (although > initially restricted to the one site), so that students and faculty > can find occurences of, say, 'lung cancer' in lecture resources - > this is to plan for curriculum management, so that we can find out if > we're pushing subjects too much (or indeed, whether we're pushing a > subject at all!). We have other applications (nearly all of which are > written in Perl/PHP3) and want to seemlessly integrate them into the > curriculum database. > > Currently we do all our development work on Unix, using Apache > virtual web servers, MySQL as our database engine and Perl running as > a CGI for most of our applications. My input has been to introduce > PHP-3 (an Apache module with a bulit-in XML parser) and some XML > knowledge to the group. I've been looking at a scenario where our > study guides are converted in XML using Omnimark and held as static > XML documents in a database. They are then rendered into HTML/RTF and > put into static web directories. The student can run a program that > extracts elements from selected XML documents and creates a > customised set of HTML pages or RTF document that is built for them > 'on the fly'. My manager was a bit worried about all these static > pages lying about and to be honest so am I, but extracting the > relevant XML from a database to render into individual HTML pages > seems a massive drain on the system. I've been awfully interested in XML in the last few days. Can you describe what user-visible benefits PHP delivers due to its integrated XML parser? Additionally, we are working on Zope searching for a consulting project right now. Actually it is Zope Cataloging. It's still a consulting-only option, but plans are that eventually it will go "below the line". > I found out about Zope Monday morning, dl'ed it, installed it, got > one or two things working... and have been worried sick ever since. Ahhh, you too, eh? Did you have the dream about the chimp and the External Method where...oh, nevermind. :^) > My problem? is that I can see how Zope can do so much for us, but it > seems to need a hell of a gut-wrench to do so. I *think* I have some good news to report on this, but before I squawk, could you detail this gut-wrench a bit more? > There also doesn't seem to be an easy 'half-way' house to > move to Zope. > I've read a lot of the documentation, and am doing so constantly, but > the wisdom of the list would be very helpful indeed. > > The questions: > a) Is there a way for us to 'dump' the non-dynamic parts of a Zope > database into static HTML pages. This would act as a way to say to > the team "look, we have a parachute!". There have been a lot of suggestions on this one. Here's another one: a command-line program that takes everything out, such as the wget program. > b) Can I integrate with the Perl/PHP3 programs that we have (the Perl > programs are mainly .cgi, but the PHP3 programs are server-side > scripted, and as such are embedded into the HTML itself). This is so > that I can > c) Is there any way of using the XML documents that I'm creating into > the database and parsing them to produce either HTML or RTF output? I'd like to have this as well. I've been doing a lot of thinking about this lately. It is a bit more complicated than expected, though... > d) I know that this a terrible question to ask... but is Zope likely > to 'remain' open-source (we're worried about getting stuck with a > proprietary system)?. This is the main reason I replied. Having Zope as a free and Open Source(tm) platform is the heart of our business plan. A closed Zope would basically mean we start over completely as a different company. Thus, closing Zope is roughly equivalent to closing our company. With _that_ said, we still need to provide some assurances that we won't legislate the connection between Zope and DC. First, we are trying to keep some arm's length distance between zope.org and Digital Creations. We hope to formalize the way the community participates in the platform. We expect to make it lucrative for other businesses to participate. At the same time, we intend to pursue commercial opportunities atop the platform for vertical applications. Ultimately this is the same question put to Netscape regarding Mozilla during the AOL talks. The answer is simple: "The genie is out of the bottle." Since it is open sourced, Digital Creations must *earn* its stewardship of Zope. If we don't we'll become less relevant. Earning the community's enthusiasm is pretty simple, I think. Unfortunately we aren't doing a good job right now, though we are trying damn hard. But we'll keep trying... In the meantime, I'm absolutely ecstatic to see folks in the community step forward over the last month and lead the way. > e) Can I 'point' an Apache virtual server to run a Zope cgi (ie > dropping the :port requirment). Yep, the zope.org machine has five virtual hosts. > f) I'd like to have the option to have user authentication > information coming from a database - is this possible? Previously answered. > g) We have something like 200 main level directories holding the > study guides, each with up to 200 files in them - is that pushing the > Zope database too far? Ditto. > h) We also need resources such as QuickTime movies, images PowerPoint > slides etc. to be uploaded - would they sit in the database or can > they be held somewhere else (and what happens about file name > conflicts)? We put them in the database. The 3 Mb Zope binaries are served out of the database, the PDF files are served out of the database. This works so well I don't even think about it any more. --Paul

1 0

RE: [ZDP] Re: [Zope] need help with IIS/ODBC
by Paul Everitt 05 Mar '99

05 Mar '99

Martijn wrote: > What is the procedure for retracting bug reports? mail > support(a)digicool.com? That's a good solution for now. --Paul

1 0

Re: [Zope] An interim solution for the FAQ
by Martijn Pieters 05 Mar '99

05 Mar '99

>To contribute to the FAQ you just have to send e-mail to me or to the >Zope list and include the word FAQ somewhere in the subject. >In the body of your e-mail message you should include (somewhere) an >XMLish faq entry as below: Hmmm.. could we change this the ZDP list? After all, that's what it is there for.. -- M.J. Pieters, Web Developer | Antraciet http://www.antraciet.nl | Tel: +31-35-6254545 Fax: +31-35-6254555 | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ------------------------------------------

2 1

Plenty of problems. Please Help
by Pavlos Christoforou 05 Mar '99

05 Mar '99

Zopistas I have encountered problems mainly associated with ZServer and ZAP: I am using Zope-1.9.0 and the preconfigured Apache server to run my Zope site. Last night (a couple of hours ago!) I installed ZServer. It wouldn't run and I had to add the following to start.py to fix it: import sys,os sys.path.insert(0,os.path.join('..','lib','python')) Later on upon entering the management screens I noticed that the id of the top level folder dissappeared which caused the paths to my objects to change. With ZAP (the preconfigured apache) I would visit: http://www.gaaros.com:8080/Gaaros/ to get to the top level directory but with ZServer is: http://www.gaaros.com:8080/ which spoils all kind of links that people have on my site. Switching back to ZAP I got the following error: <FONT SIZE="+2">Temporarily Unavailable</FONT> <P> The resource you requested is temporarily unavailable - please try again later. </TD> </TR> </TABLE> (102) failure during connect  </BODY></HTML> Seems like ZServer changed my root id from "Gaaros" to nothing. I called PickleDictionary on Data.bbb directly from python but I could not even see the subobjects. BTW can the Zope Data.bbb be accessed directly from PickleDictionary?? Also trying to shut ZServer from the control-panel results in a core dump. Ok enough for now, its very late and I cannot think anymore. If anybody has any clues about the root object id problem please let me know. Thanks Pavlos

1 0

need help with IIS/ODBC
by Jay Ashton 05 Mar '99

05 Mar '99

As a novice (who's loving Zope!) I'm having a terrible time trying to get Zope1.10.2 on NT with IIS to connect to MS SQL with a Z ODBC connection. Previously I had no problem getting Zope 1.9/ZopeHTTPServer to connect to MS SQL via Z ODBC. Recently I upgraded to 1.10.2 without a hitch, and was able to run it with IIS 4.0 after putting the (PCGI executable?) MYZOPE.exe in /InetPub/scripts/ and turning off in IIS both Basic Authentication and NT Challenge/Response as I read here in the list. My problem now is that when I try to open my db connection (exactly the same connection that was working with 1.9 & ZopeHTTPServer) I get the following error from IIS: >HTTP Error 400 >400 Bad Request >Due to malformed syntax, the request could not be understood by >the server. The client should not repeat the request without modifications. In trying to figure out what's going on I've noticed a couple things. First, and I think most illustrative, if I try to add a new Z ODBC connection, none of my ODBC sources are showing up in the available list (except the default 'LocalServer, SQL Server') - whereas if I run my 1.9 Zope with ZopeHTTPServer all my ODBC connections show up just fine. Also, running my new 1.10.2 Zope/IIS with the faulty db connection side by side with the functioning 1.9/ZopeHTTPServer, I printed our the environment variables of both and noticed some differences - USERPROFILE's are Default User vs. Administrator, and the 1.9/ZopeHTTPServer contains variables not contained in the 1.10.2/IIS environ: HOMEPATH, TEMP, USERNAME, HOMEDRIVE, USERDOMAIN, PROMPT, LOGONSERVER, TMP. I attempted to set at least USERDOMAIN in the 1.10.2/IIS environ, with no luck. I've read all the posts from the list that I could find dealing with IIS and ODBC, but couldn't find anything with info on this type of trouble. Have I made a boneheaded mistake and started to look in the wrong places for the fix? Any help/info/pointers would be hugely appreciated as I continue to bang my head on my keyboard hoping that I'll soon clear this hurdle and get back to having fun with Zope! Thanks! Jay

3 4

Re: [Zope] ZMySQLDA
by Phil Harris 05 Mar '99

05 Mar '99

Where exactly is the file? find out by doing a locate 'libmysqlclient'. Let's assume that it is in /usr/local/mysql/lib. The easiest way to accomplish what you want is this. 1. cd /etc 2. vi ld.so.conf 3. Goto the end of the file and add a line that says '/usr/local/mysql/lib' replace this with the exact location of you libmysqlient.so.6 4. save the file 5. run 'ldconfig' 6. run 'sync' twice, this just makes sure all changes are written to the disk. This adds the mysql lib directory to the lib search path. HTH Phil ----- Original Message ----- From: Timothy Grant <tjg(a)avalongroup.net> To: Zope Folk <zope(a)zope.org> Sent: Friday, March 05, 1999 4:05 AM Subject: Re: [Zope] ZMySQLDA >John Eikenberry wrote: > >> 1. Get everything cleaned up (ie. back in the condition after first >> untarring ZMySQL). >> 2. Edit Setup.in, add -L<the path to libmysqlclient> to the end of the >> last line. >> 3. Proceed as usual (make -f Makefile.pre.in boot; make) > >Thanks to both John and Ronald for their kind assitance. I have made it >past >my original error and got everything compiled correctly. However, my >general >Newbieness is still coming back and biting me on the you-know-what. > >The instructions state that I should start python, and then Import the >MySQL >module to make sure it works. When I do, I get yet another error. > >Traceback (innermost last): > File "<stdin>", line 1, in ? >ImportError: libmysqlclient.so.6: cannot open shared object file: No >such >file or directory > >The file does exist, so I am once again stumped. > >Thank you for your continued assitance. > > >-- >Stand Fast, > tjg. >=================================================== >Timothy Grant >VP Technology/CTO >Avalon Technology Group >tjg(a)avalongroup.net >www.avalongroup.net >(503) 246-3630 voice >(503) 246-3124 fax > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://www.zope.org/mailman/listinfo/zope > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://www.zope.org/mailman/listinfo/zope

1 0

An interim solution for the FAQ
by Pavlos Christoforou 05 Mar '99

05 Mar '99

Zopistas Until the SGML experts develop the FAQ format here is an interim solution: I have set up a Zope FAQ site at: http://www.gaaros.com:9673/FAQ <FAQ> <SECTION>FAQ Related</SECTION> <QUESTION>How can one contribute to the FAQ?</QUESTION> <ANSWER><![CDATA[ To contribute to the FAQ you just have to send e-mail to me or to the Zope list and include the word FAQ somewhere in the subject. In the body of your e-mail message you should include (somewhere) an XMLish faq entry as below: <FAQ> <SECTION>FAQ Related</SECTION> <QUESTION>How can one contribute to the FAQ?</QUESTION> <ANSWER>Answer One</ANSWER> <Answer>Answer Two</Answer> </FAQ> Tag case is not important.<QUESTION> <Question> and <question> are all equivalent as long as starting and ending tags match. If you want to include DTML or HTML in your answers or questions you need to include the ugly CDATA directive. If there is an error in the formating of your entry the parsing will fail and your entry will not be uploaded, but the entry will be logged. Structured Text is not supported because of the problems that Martijn Faassen discussed on the Zope List. If the section or question already exist in the FAQ then the entries will be appended to the already existing ones, otherwise the new categories will be created.]]></ANSWER> <question>How can I download the whole FAQ?</question> <answer>The whole FAQ can be exported by clicking on the "Export FAQ" in the navigation margin.</answer> <section>DTML Scripting</section> <question>How do I pass a non-form variable to the next requested URL?</question> <answer><![CDATA[ Use Hidden fields within the form: <input type="hidden" name="varname" value="">]]></answer> </FAQ> If everything works ok this e-mail will make the first entry to the FAQ! Pavlos

1 0

ZMySQLDA
by Timothy Grant 05 Mar '99

05 Mar '99

Hi, I'm playing with Zope, and have been trying to get Zope to talk to MySQL using the MySQLDA. I'm running RedHat 5.2 Since there were caveats about having MySQL development enabled, and such, I downloaded the source distribution for MySQL and made it. It appears to be working very nicely. When I follow the procedures outlined in the README, the following happens: I run make -f Makefile.pre.in boot and everything works correctly. I then run make and get the following error. gcc -fPIC -g -O2 -I/usr/include/python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG _H -I/usr/local/mysql/include -I/usr/include/mysql -c ./MySQLmodule.c ./MySQLmodule.c: In function `pythonify_row': ./MySQLmodule.c:238: warning: assignment from incompatible pointer type gcc -shared MySQLmodule.o -L/usr/local/mysql/lib -L/usr/lib/mysql -lmysqlclien t -lm -o MySQLmodule.so ld: cannot open -lmysqlclient: No such file or directory make: *** [MySQLmodule.so] Error 1 I did a locate on mysqlclient, and coudln't find the file. though I did find some called libmysqlclient. So I changed the both Setup and Setup.in to reflect that other name. however, I still get the above error. Any help would be greatly appreciated. -- Stand Fast, tjg. =================================================== Timothy Grant VP Technology/CTO Avalon Technology Group tjg(a)avalongroup.net www.avalongroup.net (503) 246-3630 voice (503) 246-3124 fax

3 4