- Zope - Zope lists

\n problems with mysql5
by Ferhat Ayaz 15 Sep '06

15 Sep '06

Hi, I used mysql4 with Z MySQL without any problems. Now I want to update to mysql5. Unfortunatly the server reports a syntax error like the follows: ------------------------------------------------- Site Error An error was encountered while publishing this resource. Error Type: ProgrammingError Error Value: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on\n(\n articles.store_id = stores.id \n and \n articles.manifacture_id = manifac' at line 7") ------------------------------------------------- I think the problem is the '\n' character. Have you any idea how to solve this problem??? Thanks, Ferhat __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

2 2

POST sucks.
by Paul Winkler 15 Sep '06

15 Sep '06

Been doing web services (XML-RPC) stuff lately. What suggestions do people have for troubleshooting a zope-based XML-RPC application? Access and trace logs are totally useless, since even the method name is hidden in the POST payload, so I feel like I'm flying blind; when a client developer tells me he gets occasional hangs, I have no idea what kind of request triggers the hang. I may end up sprinkling my code with a lot more logging calls than I'm used to. Any other suggestions? -- Paul Winkler http://www.slinkp.com

5 10

ZEO with Multiple Storages
by Brian Brinegar 14 Sep '06

14 Sep '06

We currently have a ZEO environment with FileStorage (data.fs) over 100 gigs, which continues to grow. Currently we are approaching a major hardware and software upgrade. All new hardware and moving from Zope 2.6 to Zope 2.9. Our server hosts sites for several different schools and departments within our college, what I have considered doing is trying to split up the data.fs into multiple smaller storages, possibly one per school. I suspect if this is possible it could potentially have several benefits. The first being that we would not have to deal with 100 gig files which are very difficult to move around backup/restore, etc. Secondly, we often have a very large number of users updating content at a given time and will run into slowdowns where a transaction is blocked while another commits. I hope that multiple storages could allow for a transaction to commit to one storage at the same time as another, though I am not sure. Along this line can a single transaction commit to multiple storages? First off, does this make any sense? Is it worth pursuing? Secondly, I assume that where an object is stored does not limit what other objects it can access in a transaction (e.g. object A could add a property to object B if they were in different storages) because all changes would occur in a client. (this ties into the single transaction committing to multiple storages) If this does makes sense is there any documentation, recommendations, best practices for how to set something like this up? Lastly, any thoughts on how we could split up our existing data.fs file? One thought I had was to attempt to import/export data. Thank you, Brian Brinegar Web Systems Developer Engineering Computer Network Purdue University

5 10

ZPT based on files in local filesystem folder
by Alan 14 Sep '06

14 Sep '06

Hi List, I've been googling, maybe LocalFS is a solution, but I would like to listen a second (or more) opinion. I would like to have a ZPT showing images and links for files that are not within Zope filesystem, indeed they are in my local filesystem (they are created by an Unix program btw). So I am looking for something that may import my local folder and/or the files inside to Zope space where a ZPT can work with. For the moment, I would be more insterested in a external method or similar rather than LocalFS or any other product that I have to install in my zope server. Any commentary or advice would be very welcome. TIA, Alan -- Alan Wilter S. da Silva, D.Sc. - Research Associate Department of Biochemistry, University of Cambridge. 80 Tennis Court Road, Cambridge CB2 1GA, UK. >>http://www.bio.cam.ac.uk/~awd28<<

4 3

Simple high-level question - mabye about WEBDAV?
by Steve 14 Sep '06

14 Sep '06

I am looking to extend a zope portal to allow authenticated users to upload/download files... the idea being to support a shared drive containing various files available over HTTPS and available anywhere there is web-access. Ideally this notional 'web-drive' should be accessible using Windows "Web Folders" -but I'd also like for it to support ACL-style permissions with respect to file-access by other authenticated users. Are there any "products" which already address this requirement?

2 1

Jython port of Zope
by james.burton＠brighton-hove.gov.uk 14 Sep '06

14 Sep '06

Hi, does Zope run on Jython, or is anyone working on making it do so? Any pointers would be very helpful. Sorry if this is an faq, I can't search the archive of this group because I can't reach yahoo groups... Regards, ----------------------------- James Burton Notice to recipient: The information contained in this electronic mail message is intended only for the use of the individual to whom it is addressed and may contain information which is privileged and confidential, the disclosure of which is prohibited by law. If the reader of this message is not the intended recipient, please note that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error please notify the sender immediately. Thank you in anticipation of your co-operation. You can visit our website at http://www.brighton-hove.gov.uk Please consider the environment, only print out this email if absolutely necessary.

3 2

a LocalFS that works
by Alan 14 Sep '06

14 Sep '06

Hi list, I am playing with two Zope servers version: Zope 2.9.3-, python 2.4.2, darwin and Zope 2.8.5-final, python 2.3.5, sunos5 My problem is where to find a LocalFS that works? I tried version 1.0, I patched it, but it didn't work. I also saw things like LocalFS-1.3-andreas.tar.gz (even 1.7!) but from 2004/2005 or PloneLocalFS (or now PloneSingleLocalFS!), but alpha. To summarize, I am lost. A link would be very welcome. Thanks in advance. Cheers, Alan -- Alan Wilter S. da Silva, D.Sc. - Research Associate Department of Biochemistry, University of Cambridge. 80 Tennis Court Road, Cambridge CB2 1GA, UK. >>http://www.bio.cam.ac.uk/~awd28<<

2 3

Is there any setting in plone site? Which can restrict for login to newly registered users.
by Krishna Shukla 14 Sep '06

14 Sep '06

Hi All, Is there any setting in plone site? Which can restrict for login to newly registered users. I have some strange problem. I have one site, there the users which are registering newly they are not able to login. But old users are able to login Regards, Krishna Shukla

2 1

Custom authentication page...
by Steve 13 Sep '06

13 Sep '06

I'm just starting to look at Zope as a potential platform to implement a simple authenticated web site... however I do not want to face users with the standard web-browser dialogue, but rather my own log-in page. I've established how to restrict access based upon permissions etc... and I'm able to set/reset cookies based a form submission - but do not see how to integrate an HTML login page with the standard Zope security. I've read that I should use the "Cookie Crumbler" product... but after I've added this to the folder that I intend to protect, I click on cookie_authentication (the default name for the "Cookie Crumbler" object) and I get the following error message: -- An error was encountered while publishing this resource. *Error Type: AttributeError* *Error Value: aq_parent* -- Is this a bug with "Cookie Crumbler" (version 0.3 downloaded from zope.org used against Zope 2.9.4, python 2.4.3, win32)? Am I barking up the wrong tree in hoping to have a slick-looking "logon" page? Is this something commonly done using Zope? Is "Cookie Crumbler" the right product? Would I be better hand-coding this myself?

5 7

Re: [Zope] Can't stop Zope, machine hanging
by Ken Ara 13 Sep '06

13 Sep '06

I have a new problem but it's related, so I'll keep this thread alive. To recap: possibly due to some network problems at my hosting provider, my Zope would periodically stop responding and I was unable to stop, restart or kill it, or even restart the machine remotely. I am operating within a FreeBSD jail. Finally, I was given a password to the main os environment, allowing me to restart, which I have needed to do once. While waiting for my ISP to resolve his problems, I thought it would be a good idea to relieve any excess strain on Zope. Part of the strategy involved setting Squid to ignore no-cache headers. Call me an anti-social protocol violator, but it's still my website and I set the caching headers according to the page update schedule. But I digress. Anyway, with response times improved, friendly search engines went into a feeding frenzy and within 48 hours my ZODB had reached 9GB. Packing time... Now, perhaps due to the machine restart I get the following error when attempting to pack: Traceback (innermost last): Module ZPublisher.Publish, line 101, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module App.ApplicationManager, line 428, in manage_pack Module ZODB.DB, line 555, in pack Module ZODB.FileStorage, line 1570, in pack Module ZODB.fspack, line 700, in pack Module ZODB.fspack, line 455, in findReachable Module ZODB.fspack, line 475, in buildPackIndex Module ZODB.fspack, line 166, in checkTxn Module ZODB.fspack, line 161, in fail CorruptedError: /usr/local/www/Zope/zope01/var/Data.fs:3116771801:time-stamp reduction: 0x03681c50ebb292dd <= 0x03681c530eb31b99 The bulk of the database was added following the restart so truncating may not be realistic. I haven't tried - was it fsrecover? - what is the current best tool or strategy? My setup: Zope 2.7.4-0, python 2.3.4, freebsd5 Thank you, Ken __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

2 1