- Zope - Zope lists

Re: [Zope] Automatic Restarts?
by prosam＠comcast.net 15 Sep '03

15 Sep '03

Thanks Guys, I will forward this to our programmer since I know diddily squat about what you guys just said. :) Thanks a bunch, Sammy > > >>> prosam(a)comcast.net wrote > > Hi All, > > Zope keeps restarting on its own. Why is it doing this? We are running Zope > > 2.61. It is really becoming a headache since we are running and eCommerce > site. > > Everytime it restarts you get a Proxy error on the site until it is done. You > > can imagine how annoying this would be especially to our customers. > > What platform? Which version of Python? If it's Unix, try running strace or > truss to see why it's exiting. Also, as a stopgap, consider running ZEO, as > the client restarts are a lot faster than a full zope restart (or run > multiple ZEO clients behind pythondirector or pound or suchlike to give > you some failover). > > Zope _shouldn't_ be restarting like this... > > Consider also trying Zope 2.6.2 - there's a whole pile of bugfixes in > it, although nothing off the top of my head that is directly relevant, > unfortunately. :-/ > > > > -- > Anthony Baxter <anthony(a)interlink.com.au> > It's never too late to have a happy childhood. >

3 2

RE: [Zope] ZMySQLDA
by Passin, Tom 15 Sep '03

15 Sep '03

[Joseph F. Dries III] > > Then the mysqp-python binary is probably built for Python > 2.3 and would > > not likely work with Python 2.2. > > No, it is not. I have the mysql-python 0.9.2 binary for > Python 2.1, 2.2 > and 2.3. Too bad, that would have been an easy solution! I originally had the mysql-python binary installed for Python > 2.1, since that is the python that ships with 2.6.2 and Plone 1.0.5. > mysql-python and ZMySQLDA worked fine with the Plone 1.0.5 > and Zope 2.6.2 > installations. I removed both of those completely, installed > Zope 2.7.0 > b2, added the correct registry entries for Python 2.2.3 under > Zope 2.7.0 > b2 so the installer could find the paths, and installed > mysql-python 0.9.2 > for Python 2.2. > > > Which interpreter? Zope's Py2.2 or your Py2.3? > > Zope's Py2.2. I obviously wouldn't test my Py2.3 interpreter > for a working > mysql-python (it is installed, and is working there also)... Sorry, but quite a few people mix the two interpreters up when they test something from the command line. I would try connecting using odbc. You should be able to get an odbc connector for MySQL. I tried it with MySQL several years ago and it worked fine, as I recall. Once things are working, you can follow up trying to get the ZMySQLDA working as well, if you even feel that you need to at that point. Cheers, Tom P

1 0

ZMySQLDA
by Joseph F. Dries III 15 Sep '03

15 Sep '03

> [Joseph F. Dries III] > > I have recently installed Zope 2.7.0 b2, and installed the > > mysql-python 0.9.2 along with ZMySQLDA 2.09b2. I had to > > manually copy the registry entries for my Python.org > > Python 2.3 installation to the 2.2 Python that > > is part of the Zope 2.7.0 b2 binary install. > > Then the mysqp-python binary is probably built for Python 2.3 and would > not likely work with Python 2.2. No, it is not. I have the mysql-python 0.9.2 binary for Python 2.1, 2.2 and 2.3. I originally had the mysql-python binary installed for Python 2.1, since that is the python that ships with 2.6.2 and Plone 1.0.5. mysql-python and ZMySQLDA worked fine with the Plone 1.0.5 and Zope 2.6.2 installations. I removed both of those completely, installed Zope 2.7.0 b2, added the correct registry entries for Python 2.2.3 under Zope 2.7.0 b2 so the installer could find the paths, and installed mysql-python 0.9.2 for Python 2.2. The mysql-python 0.9.2 is also installed in my stand-alone Python 2.3. I have the mysql-python 0.9.3b1 source tarfile, but like I said I have no means to compile it on the Windows 2000 box. There is a line in the readme in 0.9.3b1 that states that it is the suggested version to use for python 2.2 and above. I obviously cannot be the only person running Zope 2.7.0 on Windows connecting to MySQL ... What are the others out there doing? If I need to, I suppose I can download the appropriate development tools to make Zope 2.7.0 and MySQL behave. But this certainly a high barrier to entry. Right now I need a quick solution so I can continue my site development and deployment. > > It looks like that lives in the _mysql.pyd file, which is installed > > correctly. I can fire up the python interpreter and do an > > "import _mysql" > > and it gives me no errors. I can do an "import MySQLdb", create a > > db.connect, and manually execute some SQL. > > Which interpreter? Zope's Py2.2 or your Py2.3? Zope's Py2.2. I obviously wouldn't test my Py2.3 interpreter for a working mysql-python (it is installed, and is working there also)... but the above test also works in Zope's Py2.2 installation. Which is why I'm confused. I saw a message posted on Yahoo's groups to find the self.db.server_capabilities line and remove that and replace it with 0, but I don't like working around something, I like getting it working. Especially when it deals with data integrity. > Cheers, > > Tom P Thanks for the quick response. -- Joseph F. Dries III

1 0

populate CMFCollector with a python script remotely
by anton 15 Sep '03

15 Sep '03

Hi, I have zope 1.6.1+plone 1.04+ CMFCollector running on a linux box. Now I would like to write have a python script on my other Win2K PC, which parses a issue database (could be csv,ascii excel..) and add automatically new items to the collector. The reason: I have an old excel file with bugs, and I would like to transfer them to the collector. Did somebody already a similar thing? .. otherwise any idea?? Thanks,

2 2

RE: [Zope] Re: Re: [Security] How to encrypt a Zope oid ?
by Passin, Tom 15 Sep '03

15 Sep '03

[Edward Muller] > > On Mon, 2003-09-15 at 11:48, Passin, Tom wrote: > [snip] > > > If you > > want the pages to appear only within their intended frame, > a user with > > the right browser can easily defeat that intention unless > you enforce it > > using javascript in the page. > > Which isn't secure at all, since someone who is really dedicated would > just fire up curl, wget, lynx, etc (insert tool of choice here) to > attempt to grab whatever they want anyway, bypassing any javascript on > the page. > Right, if we are going to consider people who can ignore or change the document contents (as opposed to people who just grab the GET parameters or use the browser's context menu). Which just goies to emphasize that the OP has not explained his problem adequately to get a sensible answer. Cheers, Tom P

1 0

RE: [Zope] Re: Re: [Security] How to encrypt a Zope oid ?
by Passin, Tom 15 Sep '03

15 Sep '03

[Sinclair] > Example : a document has url : > $ZOPE/.../document_manager/document_37. > > I wish the displayed url looks like : > $ZOPE/.../document_manager?document=k2316fge54dsgb51v3vsdv4 > > That is the document_manager who translates an unreadable parameter to > document real url. > > What I want to avoid is somebody trying to access manually to > document_38, > document_39, etc., just to add more security... > If I wanted to look at the document, I would just copy and paste that document number. Do you really mean that you do not want people to be able to __guess__ other neraby URLs? Why would you not want that? If you think that an unauthorized person should not be able to view a given page, you need to apply some authorization machinary. An obfuscated URL is not really enough. If that is not what you mean, then presumably you are willing to allow any user to access those pages. Why, then, would you want to make it harder for them to do so? If you want the pages to appear only within their intended frame, a user with the right browser can easily defeat that intention unless you enforce it using javascript in the page. Please explain further why you wish to restrict access to those pages, then maybe you will get more useful suggestions. Cheers, Tom P

3 2

RE: [Zope] ZMySQLDA
by Passin, Tom 15 Sep '03

15 Sep '03

[Joseph F. Dries III] > I have recently installed Zope 2.7.0 b2, and installed the > mysql-python > 0.9.2 along with ZMySQLDA 2.09b2. I had to manually copy the registry > entries for my Python.org Python 2.3 installation to the 2.2 > Python that > is part of the Zope 2.7.0 b2 binary install. Then the mysqp-python binary is probably built for Python 2.3 and would not likely work with Python 2.2. > It looks like that lives in the _mysql.pyd file, which is installed > correctly. I can fire up the python interpreter and do an > "import _mysql" > and it gives me no errors. I can do an "import MySQLdb", create a > db.connect, and manually execute some SQL. Which interpreter? Zope's Py2.2 or your Py2.3? Cheers, Tom P

1 0

RE: [Zope] Zope hangs on string compared to '##'
by Passin, Tom 15 Sep '03

15 Sep '03

[Christoph Landwehr] > print '# ENDE' of bindings' > return printed > > The script seems to get caught in an endless loop and returns no > results. Sometimes after calling the script Zope does not responde > anymore and needs to be restarted. > > Everything runs finde if I compare i eg. with '#' > > What am I missing? You have a typo here - an extra apostrophe. If that is in your original, remove it (although I do not know why your example with the typo would run at all). Cheers, Tom P

1 0

evaluating a "sequence-item" within a dtml-if statement
by Roger Mallett 15 Sep '03

15 Sep '03

I am attempting to evaluate a "sequence-item" in a dtml-if statement. I have made several variations, all of which failed. The code below fails with: "invalid syntax (line 1). <dtml-in expr="[1,2,3,4,5,6]"> <dtml-if expr="&dtml-sequence-item;==3"> &dtml-sequence-item; <dtml-else> failed </dtml-if> </dtml-in> Thank you for any assistance you can provide RogerM _________________________________________________________________ Need more e-mail storage? Get 10MB with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es

3 2

Re: Aw: Re: [Zope] Cookie Crumbler - read Password from login_form
by Chris Withers 15 Sep '03

15 Sep '03

nicogrubert(a)arcor.de wrote: >>>these fieldnames (e.g. __ac_name, __ac_password) are not found in the >> >>REQUEST when submitting the form "login_form" since they are stored in a >>cookie called "__ac". >> >>They'll still be in the REQUEST, just not accessible due to their names... > > so I could use REQUEST.get('__ac_password', None) in my external method to get the password in cleartext ? Maybe, I don't know... Chris

1 0