Re: [Zope] Re: What's the difference between 2.8.x and 2.9.x?

2006-05-31 Thread Ron Bickers
On Wed May 31 2006 14:09, Tres Seaver wrote:

   - 2.10 is the development version, not yet released except in
 beta.  It should be released by the end of June.  It will
 bundle a newer Zope3 version (3.4), and removes a number of
 forks between Zope2 and Zope3 versions of the same features.

Zope 3.4 by the end of June?  3.3 hasn't even been released (except as beta).  
Did I miss something?

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] zope and nagios

2006-03-30 Thread Ron Bickers
On Thu March 30 2006 13:21, robert rottermann wrote:

 I would like to test if zope is running using nagios.

 I would be gratefull if somebody could could point me to some info
 how to best do this.
 I am especially interested to learn what to test to detect a running but
 not responding zope.
 Just looking up a page seems not to do the trick.

As far as I'm concerned, a not responding Zope and a not running Zope are the 
same thing.  check_http with the Zope port (and other necessary parameters) 
works fine for me.

You could write a custom check that does whatever you want (including 
checking the logs or zopectl), but I think that's more trouble than it's 
worth.

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Packing data.fs programmatically

2006-02-24 Thread Ron Bickers
On Fri February 24 2006 16:19, Chris Withers wrote:

  URL whacking is evil and must be punished...
 
  How is this different than clicking on the Pack button in the ZMI?

 That's also evil, because yes, it is just URL whacking with a browser...

Ok.  So there is no difference.

  What's
  the solution without ZEO and without having to stop Zope?

 You use ZEO. Get over it, it should be how a standard Zope instance is
 set up, IMNSHO...

So, in other words, there isn't one.  I take it you're a big fan of ZEO. ;-)  
I guess I'll check it out.  I've been using Zope for 7-ish years and just 
never bothered.

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Packing data.fs programmatically

2006-02-23 Thread Ron Bickers
On Tue January 31 2006 07:47, Chris Withers wrote:

  I do it though the webinterface with a wget from the crontab:

 Oh, ouch ouch bad fragile pain failure suffering...

 URL whacking is evil and must be punished...

How is this different than clicking on the Pack button in the ZMI?  What's 
the solution without ZEO and without having to stop Zope?

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Zope 2.9 and SSL

2006-02-17 Thread Ron Bickers
On Fri February 17 2006 04:32, Martijn Pieters wrote:

 The netcraft survey for February counted 21699 instances of lighttpd;
 Zope was counted 41656 times:

   http://survey.netcraft.com/Reports/200602/

 The numbers are those seen by Netcraft during January.

Lighttpd is barely three years old.  It'll be interesting to see where these 
numbers are in another year.

I noticed that my lighttpd server that proxies to Zope responds as 
Zope/ZServer, not lighttpd.  If I recall, Apache said Apache.  There must be 
many more Zopes than netcraft shows, right?

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Zope 2.9 and SSL

2006-02-17 Thread Ron Bickers
On Fri February 17 2006 05:19, Martijn Pieters wrote:

 On 2/17/06, Ron Bickers [EMAIL PROTECTED] wrote:
  I noticed that my lighttpd server that proxies to Zope responds as
  Zope/ZServer, not lighttpd.  If I recall, Apache said Apache.  There
  must be many more Zopes than netcraft shows, right?

 No, Zope behind Apache with ProxyPass also reports as Zope:

Ok.  I thought it was reporting Apache for me before, but I don't recall for 
sure.  Does using mod_rewrite with [P] report the same?

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Zope 2.9 and SSL

2006-02-17 Thread Ron Bickers
On Fri February 17 2006 14:05, Tino Wildenhain wrote:

 Apache as frontend proxy returning apache must be a common
 urban legend. This pops up from time to time albeit
 its so easy to check and make sure ;-)

Except that I don't have Apache installed anymore. :-)  I know at one time it 
did not report Zope, but that may have been way back before I was using 
mod_proxy.

I see that the ozzope.org Plone site reports Apache.  So they must not be 
using mod_proxy, yes?

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Zope 2.9 and SSL

2006-02-15 Thread Ron Bickers
On Wed February 15 2006 02:42, Janusz Zamecki wrote:

 The easiest way is to use Apache, but I have reasons to not go that way.

If you don't want big Apache, lighttpd is small and has made a good SSL 
front-end proxy to Zope for me.

http://www.lighttpd.net/

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] DateTime strftime problem

2005-11-07 Thread Ron Bickers
On Mon November 7 2005 08:21 am, Jürgen Herrmann wrote:

 DateTime('2005/04/03 02:01 GMT').toZone('GMT-4')

 prints:
 2005/04/02 22:01:00 GMT-4
 ...which is what i expected
 -
 DateTime('2005/04/03 02:01 GMT').toZone('GMT-4')\
 .strftime('%Y/%m/%d %H:%M %Z')

 prints:
 2005/04/03 04:01

 hmm, where's the timezone information gone? to make it short, how
 can i get a text representation of a DateTime object in a given
 timezone?

strftime() timezone is broken in all versions of Zope that I know of.  You 
can work around it by using the individual functions to get the information.  
For example (not verified):

  dt = DateTime('2005/04/03 02:01 GMT').toZone('GMT-4')
  '%s/%s/%s %s:%s %s' % (dt.year(), dt.month(), dt.day(),
 dt.hour(), dt.minute, dt.timezone())

or, if you throw the seconds in there and you keep them in the same order, 
you can just use parts():

  '%s/%s/%s %s:%s:%s %s' % (dt.parts())

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] DateTime strftime problem

2005-11-07 Thread Ron Bickers
On Mon November 7 2005 12:15 pm, Ron Bickers wrote:

   dt = DateTime('2005/04/03 02:01 GMT').toZone('GMT-4')
   '%s/%s/%s %s:%s %s' % (dt.year(), dt.month(), dt.day(),
  dt.hour(), dt.minute, dt.timezone())

   '%s/%s/%s %s:%s:%s %s' % (dt.parts())

Uh... you'll probably need to change the format string to suit your needs of 
leading zeros and such, but you get the idea.

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] DateTime strftime problem

2005-11-07 Thread Ron Bickers
On Mon November 7 2005 12:15 pm, Ron Bickers wrote:

   dt = DateTime('2005/04/03 02:01 GMT').toZone('GMT-4')
   '%s/%s/%s %s:%s %s' % (dt.year(), dt.month(), dt.day(),
  dt.hour(), dt.minute, dt.timezone())

Oops. A (hopefully obvious) typo... should be dt.minute()

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] How to create an ansynchronous method

2005-09-23 Thread Ron Bickers
On Fri September 23 2005 04:31 pm, Chris Withers wrote:

 Ron Bickers wrote:
  I have no idea.  Maybe it'll do what you want, but I don't understand
  what it really does just from the description.  The work I needed to do
  was external to Zope anyway (reading data from a MySQL database,
  building PDFs with Reportlab, sending email), so it's actually better
  that I'm outside of it.

 The open source Reportlab library right?
  From what I've seen of their closed source stuff, it's way fast enough
 to do this all on the fly...

What I was doing wasn't fast enough; there were plenty of complaints from 
customers.  But to be fair, it wasn't Reportlab that was slow.

The process had to retrieve hundreds (sometimes over a thousand) of 
name/address records from a database, calculate the length of the longest 
line in each when printed with a given font, pass that information to 
Reportlab to format a page that would print each address centered on a label 
(not center-aligned, but left-aligned with the whole thing in the center of 
the label), attach the resulting PDF to an email and send it on.  I suspect 
the slowest part was going through each of the hundreds of records and 
calculating the size, but it really didn't matter; the whole thing took too 
long to do on the fly.

Reportlab is *nice*, BTW.

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Problem with Photo Folder

2005-09-13 Thread Ron Bickers
On Mon September 12 2005 12:52 pm, David wrote:

 We are using the ZODB for storage and ImageMagick as the engine.

 Module Products.Photo.Photo, line 363, in _resize
 Module popen2, line 147, in popen2
 Module popen2, line 42, in __init__
 OSError: [Errno 12] Not enough space

ImageMagick is running out of disk space when trying to generate a display.  
Check the file systems of /tmp, /var/tmp, or wherever ImageMagick is using 
for temp space.

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] How to create an ansynchronous method

2005-09-13 Thread Ron Bickers
On Tue September 13 2005 02:52 pm, David Pratt wrote:

 Hi. I have a workflow that is triggered by a file upload and the
 processing of the file can be minutes of processing depending upon the
 size of the file uploaded.  I am concerned about number of threads
 available to serve zope so I believe this is a good candidate for an
 asynchronous process.  I am looking for some type of outline to do
 this.  Currently a tool does the work that is triggered by workflow
 script.  My hope is to have this process run and send the user an email
 to advise when the process has completed instead of the user waiting
 for a response or potentially timing out waiting for one. What steps
 could I take to make this an ansynchronous process?

I had to do something like this when processing a lot of data to create PDF 
documents to send via email.  The time to do so was too long for them to sit 
and wait, so I created a separate process to do the job.  I don't know if 
this is the best way, but it wasn't very difficult and it has been working 
without problems for many months.

When a user requests the document, I add a record of needed information to a 
MySQL table (the queue), send a signal to the long-running process 
(described next) and immediately return a thank you page.  A 
separate-from-Zope long-running Python process waits for a signal, reads the 
queue table, does what it needs to do, empties the processed items from the 
queue, and goes idle.  It can handle things like getting a signal while it's 
processing a queue and catching up occassionally if it missed a signal 
(for whatever reason).

Hope this helps.

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] How to create an ansynchronous method

2005-09-13 Thread Ron Bickers
On Tue September 13 2005 08:16 pm, David Pratt wrote:

 How is it that you send a signal to the long running
 process?

The long-running process writes a pid file and waits for a SIGUSR1 signal 
(using Python's signal module).  A small External Method, called when the 
user submits the form, reads the pid file and sends the signal to the 
process.

 Is the long running process cronned to look for a record in 
 the database or is this starting another server of some type.

It waits for a SIGUSR1 signal from the website, otherwise it's idle.  That 
way it can begin processing immediately but doesn't have to do any periodic 
checking.  I do, however, have a cron job that starts it every 15 minutes in 
case it dies.  The process knows if it's already running, so it's safe to 
just start it regularly.

 What I need is something like what you are suggesting - wakes up when
 there is work in the hopper and chugs along until it is done and then
 goes to sleep (sort of the way a printing queue works). At the same
 time it would be great if it was something that had a small RAM
 footprint or ran without consuming any more than X mbs.

The part that waits for the signal is very small, but it loads the Reportlab 
modules and reads a bunch of data to do the work, so it can get large at 
times.  If it were to just call an external program that dies after doing 
its work, you could easily keep memory usage low.

 The other 
 problem I have with this is that it needs to do work in Zope itself
 since the final docs end up as objects.  I have just found Chris
 Wither's product called Stepper. I am not sure it this is for this type 
 of situation or more for cronned maintenance.

I have no idea.  Maybe it'll do what you want, but I don't understand what it 
really does just from the description.  The work I needed to do was external 
to Zope anyway (reading data from a MySQL database, building PDFs with 
Reportlab, sending email), so it's actually better that I'm outside of it.

When I have to run things in Zope from outside, I run curl with a URL of a 
Python Script that does the work.  It's a hack, but I've never had a problem 
with it.  I'm not sure how else you would work in Zope from a process 
outside of Zope.

-- 
Ron
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


[Zope-dev] Re: Photo Product Strangeness

2001-02-20 Thread Ron Bickers

I noticed this behavior a while ago.  The author said he didn't have time to
mess with it and it was a low priority.  I've been able to get the photos
back the way they should be by some combination of saving properties on the
properties screen and other such fumbling around.  I haven't bothered trying
to figure out why it's happening, though.

_
Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]

- Original Message -
From: "Michael R. Bernstein" [EMAIL PROTECTED]
To: "Ron Bickers" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, February 18, 2001 3:48 PM
Subject: Photo Product Strangeness


 I've been messing around with the Photo product, and I've
 noticed something odd about how it handles changes to the
 display sizes:

 When you create several Photo objects in the same folder
 (not in a ZPhotoAlbumPage), they affect each others display
 sizes. For example, changing one of the display sizes in one
 Photo will change the corresponding display in sibling
 Photo.

 Can anyone suggest how to fix this?

 Michael Bernstein.



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



[Zope-dev] Re: Photo Product Strangeness

2001-02-20 Thread Ron Bickers

I'll take a look at it when I get a chance.  I just moved into my new house
(perhaps you've seen the photos using the Photo product at
bickersfamily.org) and I don't have everything setup yet.  It sounds like it
might be something fairly simple to fix once you know what you're looking
for.

_
Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]

- Original Message -
From: "Michael R. Bernstein" [EMAIL PROTECTED]
To: "Ron Bickers" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 10:41 AM
Subject: Re: Photo Product Strangeness


 Ron Bickers wrote:
 
  I noticed this behavior a while ago.  The author said he didn't have
time to
  mess with it and it was a low priority.  I've been able to get the
photos
  back the way they should be by some combination of saving properties on
the
  properties screen and other such fumbling around.  I haven't bothered
trying
  to figure out why it's happening, though.

 I found an even more revealing scenario:

 When you create a Photo in a folder, alter it's display
 setings, *delete* it, and then create a new Photo in the
 same folder, the new Photo will have the altered display
 settings.

 This tells me that the displays persistent atribute (a
 tuple) is being created in the Folder's namespace, not the
 Photo's. but I don't know enough to figure out where in the
 source it's going wrong.

 Michael Bernstein.



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



RE: [Zope] DTML namespace puzzle

2001-01-30 Thread Ron Bickers

It was posted to zope-dev, which I should probably subscribe to.

http://lists.zope.org/pipermail/zope-dev/2001-January/009018.html

Thank you!  Exactly what I needed.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]

 -Original Message-
 From: Dieter Maurer [mailto:[EMAIL PROTECTED]]

 About a week ago, I posted a short description on how parameters
 are passed to DTML objects to this list.
 
 Take a look at the archive.


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Products and Zope 2.3

2001-01-29 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris
 Withers
 Sent: Monday, January 29, 2001 4:35 AM
 To: David K. Trudgett
 Cc: [EMAIL PROTECTED]
 Subject: Re: [Zope] Products and Zope 2.3


 "David K. Trudgett" wrote:
 
  This brings up the question: are there any significant products
 that don't
  yet work with Zope 2.3?

 Squishdot for one ;-)

I'm confused by this statement.  I upgraded my Squishdot 0.7.3 / Zope 2.2.5
installation to Zope 2.3.0 and my Squishdot is working without any problems.
Am I missing something that's really broken?
_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] DTML namespace puzzle

2001-01-29 Thread Ron Bickers

 -Original Message-
 From: Dieter Maurer [mailto:[EMAIL PROTECTED]]
 Sent: Monday, January 29, 2001 1:17 PM
 To: Ron Bickers
 Cc: [EMAIL PROTECTED]
 Subject: RE: [Zope] DTML namespace puzzle

 of the namespace. "dtml-with" could but it is very strange
 that it should do such things and especially that it does
 for you but not for me.

I have no explanation whatsoever, but I removed the dtml-let and it's
working now.  Sigh...

This leads me to a related question, however.  I realized the DTML method
call from the Python Script included 'container' as the first parameter (as
shown below).  I did this so that the DTML method could find another method
in the same Folder.  Without it, it fails with a NameError.  I realized that
I don't understand how Python Scripts can/should call DTML methods.  That
is, are there magical parameters?  Why does the following 'container'
parameter work?

  msg = container.orderMessage(container, num=num, SESSION=SESSION)

_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] DTML namespace puzzle

2001-01-28 Thread Ron Bickers

 -Original Message-
 From: Dieter Maurer [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, January 28, 2001 3:43 PM
 To: Ron Bickers
 Cc: [EMAIL PROTECTED]
 Subject: Re: [Zope] DTML namespace puzzle

 Does "SESSION['info']" has a key "num" or do you expect
 to access the "num" passed as parameter?
 In this case, it might have something to do with permissions,
 as Zope sometimes turns insufficient permissions into KeyError.
 However, I expect your "SESSION['info']" is a standard dictionary
 and then access should by unprotected.

SESSION['info'] does not have a key "num".  The only num is passed as a
parameter.  Did you use SQLSession to try to reproduce it, or just another
mapping?  Could SQLSession have something to do with it?
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] ZMySQLDA problems after upgrade

2001-01-26 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
 Behalf Of Andy Dustman
 Sent: Friday, January 26, 2001 12:42 AM
 To: Randall F. Kern
 Cc: [EMAIL PROTECTED]
 Subject: Re: [Zope] ZMySQLDA problems after upgrade

 be returned to it by the query method, mysql_store_result is the way to
 go. And since Zope passes max_rows as a separate parameter, it makes sense
 (to me) to make use of it.

How about excluding the automatic LIMIT clause if max_rows is set to 0?
Would that confuse people?

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] ZMySQLDA problems after upgrade

2001-01-26 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ron
 Bickers
 Sent: Friday, January 26, 2001 11:28 AM
 To: Andy Dustman; Randall F. Kern
 Cc: [EMAIL PROTECTED]
 Subject: RE: [Zope] ZMySQLDA problems after upgrade

 How about excluding the automatic LIMIT clause if max_rows is set to 0?
 Would that confuse people?

Oh!  It already does that.  So if you want to make your own LIMIT clause,
just set max_rows to 0.  Correct me, Andy, if this is a bad thing.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] ZMySQLDA problems after upgrade

2001-01-26 Thread Ron Bickers

Yeah... I just realized that's what broke my 'select LAST_INSERT_ID() as
newid' query where a LIMIT clause causes a MySQL error.  I had max_rows set
to 0 and all of a sudden I was getting Zope errors.

This worked in earlier DAs.

Thanks for the upcoming fix, Andy.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]

 -Original Message-
 From: Randall F. Kern [mailto:[EMAIL PROTECTED]]
 Sent: Friday, January 26, 2001 1:22 PM
 To: Ron Bickers; Andy Dustman
 Cc: [EMAIL PROTECTED]
 Subject: RE: [Zope] ZMySQLDA problems after upgrade


 You will get 0 rows if you use max_rows=0.

 -Randy


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] DTML namespace puzzle

2001-01-26 Thread Ron Bickers

Just when I thought I was catching on to everything, I ran into this.

I'm using Zope 2.3.0 (final).  I don't know if this worked the same with 2.2
because I didn't try this until today.  SQLSession is handling the SESSION
stuff, and I haven't had any problems with it.

I have a Python Script (sendOrder) that calls a DTML method (orderMessage)
as follows:

  container.orderMessage(num=num, SESSION=SESSION)

orderMessage contains the following:

  dtml-with "SESSION['info']" mapping
  Order Number: dtml-var num
  Blah blah other session variables that work fine.
  /dtml-with

I get a KeyError on num.  If I modify orderMessage to contain the following,
it works:

  dtml-let num=num
  dtml-with "SESSION['info']" mapping
  Order Number: dtml-var num
  Blah blah other session variables that work fine.
  /dtml-with
  /dtml-let

This seems strange to me.  What am I missing?

___________

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] What happened to random?

2001-01-26 Thread Ron Bickers

I believe Python Methods did a lot of auto importing of modules.  In Python
Scripts, you need to import what you want.

Try 'import random' or 'from random import choice'

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill
 Anderson
 Sent: Friday, January 26, 2001 7:36 PM
 To: [EMAIL PROTECTED]
 Subject: [Zope] What happened to random?

 OK, got a problem with 2.3.0 and Python Script; one that breaks
 Membership :(

 In Python Methods, I can do this

 choose=random.choice


 And it works.

 However, in a Python Script in 2.3.0, it barfs, complaining about random
 not being a variable. I've tried self.rhandom, context.rhandom,  and
 _.rhandom, and none work. Any help would be very much appreciated.


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] ANNOUNCE: Zope 2.3.0 beta 3 released

2001-01-25 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris
 Withers
 Sent: Thursday, January 25, 2001 10:19 AM
 To: Erik Enge
 Cc: Oleg Broytmann; Zope Mailing List
 Subject: Re: [Zope] ANNOUNCE: Zope 2.3.0 beta 3 released

  | Finally it works for me lake a charm! (Even with python 2.0!)
 
  Really? Python 2.0?  Without any problems?  Digicool's, are you
  supporting Zope on Python 2.0?

 That's the target for 2.4, isn't it?

That's what Brian has mentioned...that 2.4 will primarily be Python 2.x
support (including unicode) and may even require Python 2.

I'm running Python 2.0 with Zope 2.3b3, several custom and borrowed
ZClasses, Python Products, MySQL connections and it's running very well.  I
just hope I'm not a Chernobyl waiting to happen. :-)

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] VirtualHostMonster, PATH_INFO and absolute_url

2001-01-24 Thread Ron Bickers


 2. In this setup, if I got it right, absolute_url() for /MySite/spam
 should return http://10.0.1.21/spam. But it returns
 http://10.0.1.21/MySite/spam. Something's broken?

I have this same problem.  If the documentation in the VHM is correct, it's
a bug.  I found that adding a VHM to the /MySite folder (in addition to the
root) "fixes" absolute_url().  I'm using FastCGI, but I imagine it'll work
the same with ProxyPass.  Perhaps I should take the time to report it in the
Collector...unless you get to it first.

_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] VirtualHostMonster, PATH_INFO and absolute_url

2001-01-24 Thread Ron Bickers


 I should probably write a Howto for VirtualHostMonster, and ask the folks
 who've written the various fine SiteAccess-related Howtos to
 incorporate it.
 It really is a lot easier and safer to use than SiteRoots 98% of the time.

I agree.  It's very easy to use with Apache, and it doesn't mess up /manage
access through the primary domain.  Woohoo!
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Zope 2.3b2 uploading File bug (win32)? (also LocalFS?)

2001-01-23 Thread Ron Bickers

I believe this is a problem that has been fixed in CVS and for beta 3
(whenever it's released).  The bug caused this error to occur in several
different scenarios of mine.  You can either get the latest CVS or wait for
beta 3.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]

 --
 Zope Error
 Zope has encountered an error while publishing this resource.

 exceptions.AttributeError

 Sorry, a Zope error occurred.

 Traceback (innermost last):
   File C:\PROGRA~1\WebSite\lib\python\ZPublisher\Publish.py, line
 222, in publish_module
   File C:\PROGRA~1\WebSite\lib\python\ZPublisher\Publish.py, line
 179, in publish
   File C:\PROGRA~1\WebSite\lib\python\Zope\__init__.py, line 240, in abort
   File C:\PROGRA~1\WebSite\lib\python\ZODB\Transaction.py, line
 163, in abort
   File C:\PROGRA~1\WebSite\lib\python\ZODB\Connection.py, line
 433, in abort_sub
 AttributeError: _creating


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Zope 2.3.0b2 undo strangeness

2001-01-22 Thread Ron Bickers

I used an existing Dafa.fs from 2.3.0b1, 2.2.5 and down to (I think) 2.2.0.
I didn't notice these messages with  2.3.0b1.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: Chris McDonough [mailto:[EMAIL PROTECTED]]
 Sent: Monday, January 22, 2001 12:52 PM
 To: Ron Bickers; [EMAIL PROTECTED]
 Subject: Re: [Zope] Zope 2.3.0b2 undo strangeness


 Ron,

 Did you start from a fresh Data.fs for 2.3.0b2 or did you use an existing
 Data.fs from another install?


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Zope 2.3.0b2 undo strangeness

2001-01-22 Thread Ron Bickers

I was hoping that one of the fairly few changes from b1 to b2 would trigger
an "Oh yeah."
_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: Chris McDonough [mailto:[EMAIL PROTECTED]]
 Sent: Monday, January 22, 2001 2:16 PM
 To: Ron Bickers; [EMAIL PROTECTED]
 Subject: Re: [Zope] Zope 2.3.0b2 undo strangeness


 Hmmm, ok, I was just making sure it wasn't a default content issue... I
 don't know what the issue is.  :-(


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] Zope 2.3.0b2 undo strangeness

2001-01-19 Thread Ron Bickers

I am getting transaction that show in the root folder's Undo screen that
look like this:

/index_html by Anonymous User
/welcome.html by Anonymous User
/commonbond.html by Anonymous User

There are multiple entries of these and a couple others, but by accessing
these pages, I can't seem to force one to be added to the Undo list.

One of these is a Python Script, and its modification time shows as the last
time one of the above entries was made.  The transaction also shows in the
Undo tab of the Python Script itself.

The others are DTML Methods.  Their modification time has not changed since
I last modified them weeks ago, and the transaction above does *not* show in
the DTML Method's Undo tab.

What's going on here?
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Problem with LocalFS and Zope 2.3.0b1 (fix)

2001-01-18 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 Hamish Lawson
 Sent: Thursday, January 18, 2001 11:23 AM
 To: [EMAIL PROTECTED]
 Subject: [Zope] Problem with LocalFS and Zope 2.3.0b1

 After adding a LocalFS object I get the error below (but the object
 gets added OK). It seems to be related to displaying the modification
 time in the management screen. I've temporarily gotten round it by

That's exactly what it is.  The Local FS object itself doesn't have
_local_path set, so bobobase_modification_time() fails when the management
screen tries to display the time.  The attached patch will fix it.  I
notified Jonothan Farr as well and he said it would be fixed for the next
release.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]

 localfs.patch


RE: [Zope] Zope Versus Enhydra Comparison article

2001-01-17 Thread Ron Bickers


 Using Zope we knew that we would reach situations which may be
 unresolvable in the short term, and could not make significant business
 decisions with so many unknown factors and lack of any way to circumvent
 problems.

What in the world does that mean?!?  Maybe it should read "We don't know how
to use Zope or code in Python."

 The second sentence is perhaps a candidate for
 http://dna.yi.org/Zope/Quotes. Maybe a North American
 reader could confirm that "valorizes" means what I
 think it means ;-)

Perhaps a typo?  "vaporizes" fits pretty well there.  My head has done that
before while working with Zope. :-)
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Missing attribute with ZSQL methods?

2001-01-17 Thread Ron Bickers


 If I write DTML that way:

 tddtml-var telephone missing="(No phone)"/td

 and if "telephone" comes from a ZSQL method, "missing" is ignored
 even if the
 field was NULL (in SQL sense). Is it normal?

"missing" is only effective if the variable telephone cannot be found.  Even
if it has a null or None value, it's not considered missing.  Try dtml-var
telephone null="(No phone)" instead.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Zope Versus Enhydra Comparison article

2001-01-17 Thread Ron Bickers


 However, for a programmer who had to come into the Zope
 environment 'cold', the problem would likely have seemed
 intractable. They wouldn't have even known where to look,

How does Enhydra differ?  Wouldn't the same problems be true for someone
working with Enhydra that knows Zope/Python really well but has zero
Enhydra/Java experience?

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Python 2.0 ??????

2001-01-17 Thread Ron Bickers

The impression I get from the Zope dev site is that 2.3.0b1 (and possibly
before the beta) will compile and run under Python 2.0, but I haven't tried
it myself.  Anything 2.2.x needs patches, which I couldn't get working right
after a couple hours of tinkering with it.  Python 2.0 support will not be
100% "supported" in 2.3 final, but that doesn't necessarily mean it won't
run.

See http://dev.zope.org/Wikis/DevSite/Projects/Python20Migration/FrontPage
for details.
_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of OK Studio
Sent: Thursday, January 18, 2001 12:33 AM
To: [EMAIL PROTECTED]
Subject: [Zope] Python 2.0 ??


My web site had been working until this morning for months without a
problem. When investigating the cause of the crush I found out that my ISP
just upgraded to python 2.0 without my knowledge. My site is as far as I
know the only zope site there. It does not start or build. I tried to
upgrade to version 2.2.5 (I was running 2.2.2) without a success.
This is what i got when trying to upgrade to version 2.2.5 :


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] RE: Zope 2.3 and manage_page_style.css unauthorized

2001-01-13 Thread Ron Bickers

Well... that figures.  I see now that this was added to the Collector
earlier this evening (http://classic.zope.org:8080/Collector/1848/view).
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: Ron Bickers [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, January 13, 2001 3:07 AM
 To: [EMAIL PROTECTED]
 Subject: Zope 2.3 and manage_page_style.css unauthorized


 Playing with 2.3.0a2, I discovered that if I log in to the
 management screen with a Manager user that is not defined in the
 root folder, I get an unauthorized error when accessing
 /manage_page_style.css (401 from detail log).  If the Manager is
 defined in the root, everything works fine.

 A bug?  How can I fix it?
 ___

 Ron Bickers
 Logic Etc, Inc.
 [EMAIL PROTECTED]



___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] importing string module in python METHOD - a problem that shouldn't be a problem problem

2001-01-13 Thread Ron Bickers

You can using the string module in Python Methods the same way you can in
DTML.  There's no need to import anything.

Try _.string.split(...)

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lee
 Sent: Saturday, January 13, 2001 8:55 PM
 To: [EMAIL PROTECTED]
 Subject: [Zope] importing string module in python METHOD - a problem
 that shouldn't be a problem problem


 Hi,

 I have a Python method that needs to use the string module. In the
 method body I have the 'import string' statement but when I try it =

 Error Type: ImportError
 Error Value: __import__ not found

 The documentation collaborates that import statements (the string module
 specifically) can be used in Python methods. The method body is...

 import string
 text = details
 y = string.split(text,"x")
 studentMatric = y[0]
 studentRecord = y[1]
 return studentMatric + studentRecord

 .., which results in the above error. Can anyone suggest a reason for
 this? I think (hope) it'll work if I put it in my extensions directory.


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] hasRole bug or feature in 2.2.?

2001-01-12 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 Dieter Maurer
 Sent: Friday, January 12, 2001 5:00 PM
 To: Chris McDonough
 Cc: [EMAIL PROTECTED]
 Subject: Re: [Zope] hasRole bug or feature in 2.2.?



   However, if previously a protected object
   has been accessed, then your browser may (and usually
   will) send Authentication information with
   all following requests.
   A UserFolder will use this information (if present)
   to authenticate the user, even if no permissions
   are necessary for object access.
   If successful, AUTHENTICATED_USER will not
   be "Anonymous" even though the accessed object
   is unprotected.

I think I understand, but correct me if I'm wrong.  The problem is that my
browser is not even *sending* the authentication information to the other
parts of the site until I first access a protected document at the root
level.  That is, the browser only continues to send auth info on levels at
and below where I've requested a protected document.  If that potected
document is at the root level, I get the auth info everywhere in the site.
Does this also mean that even after authenticating myself on one part of the
site, accessing a protected document on another part of the site may result
in an "unauthroized" response from Zope, to which my browser kindly responds
for me without me realizing it?

If this is true, it explains clearly Zope's behavior.  It's really a browser
"feature" and not a Zope issue at all.

Given that, is it fair to say that I can never really be sure that an
authenticated user (somewhere else on the site) accessing an unprotected
document has a given role?  Or would it be safe to assume that after
accessing a root protected document, hasRole() will return the "right"
answer anywhere in the site?

If I can't safely assume any of the above, would I be better off using a
session product to track a user after log in so I can determine their roles
from an unprotected document?  Any other ways?

My goal, BTW, is to avoid showing certain content on an otherwise public
page unless the authenticated user has the Member role.  If there is a
cleaner way to do this, I'm all ears.

Thanks!
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] Zope 2.3 and manage_page_style.css unauthorized

2001-01-12 Thread Ron Bickers

Playing with 2.3.0a2, I discovered that if I log in to the management screen
with a Manager user that is not defined in the root folder, I get an
unauthorized error when accessing /manage_page_style.css (401 from detail
log).  If the Manager is defined in the root, everything works fine.

A bug?  How can I fix it?
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] MySQLDA and MySQL-python - patch needed?

2001-01-11 Thread Ron Bickers


 On my box only DA is symlinked to a different location. The rest of my
 products reside in a child directory of the main Zope installation. I am
 only running one Zope instance. This shouldn't be a problem, right?

This should not be a problem.

 From Zope management database connection Test tab, on valid
 SELECT queries
 it tells me that there was no data matching my query. On invalid SELECT
 queries (ones on nonexistent tables or columns) Zope raises the correct
 error originating from MySQL, such as "Error Value: (1146, "Table
 'somedatabase.sometable' doesn't exist")". The trial queries I am testing
 through Zope all work from the MySQL command line so I know they
 do in fact
 return data. It appears that error messages are making it back to
 Zope from
 MySQL but real query results are not.

Are you saying that the valid select queries are suppose to return data, but
in the test screen they don't?  If you can run a query and get a response,
that's a pretty strong indication that both the module and the DA are
installed correctly.

It's quite possible that the binary RPMs only work properly with certain
versions of MySQL for whatever reason.  Perhaps if you compile the module
from the src RPM
(http://dustman.net/andy/python/MySQLdb/0.2.1/MySQL-python-0.2.1-1.i386.rpm)
you can eliminate one more factor.  You'll probably need to have MySQL-devel
installed as well as python-devel.  The only reason I point to an older
version of Andy's module is because that's what I'm using and I know it
works for me.

 RPMs, but perhaps I missed something and some residue lingers. I know how
 to uninstall RPMs, but other than that how do I make sure I have a clean
 slate before trying to install anew? I think there is quite a
 number of mod
 dependencies here. Also I am confused on a basic piece of Zope
 configuration: my box has its own python and Zope has its own python, why
 two and are they sharing modules? If you want to add a module for both

You could probably have many versions of python that share modules.  I'm
using my everyday python for Zope, but I know that's not possible for some,
because Zope needs certain options that the "default" version may not have
compiled in.  If your Zope is running, the MySQLDA product isn't broken, and
you can run queries on the test page, then I can't see how it's a python or
Zope problem.  I may just be blind, though.

 I also did this as (contributed previously to the list) to fix a install
 but broken DA. Directory, site-packages, now exists in two locations. Is
 this a problem?

As long as the python you're using for Zope can find the module you expect
it to find, you should be fine.

 Seems that because of how my Zope was installed had problems... I copied
 all
 files from /usr/lib/python1.5/site-packages/ to
 /usr/local/zope/lib/python/Products/ZmySQLDA and all was sweet.

 Day 5 of the insanity continues.

I must have been very lucky with my installation since I've never had these
kinds of problems getting it running, but I see that many have.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] hasRole bug or feature in 2.2.?

2001-01-11 Thread Ron Bickers

I'm having a problem with AUTHENTICATED_USER.hasRole()

I have a user with the role 'Member' defined at the root level (and nowhere
else).  I also have the following DTML method at the root level:

  dtml-if "REQUEST['AUTHENTICATED_USER'].hasRole(PARENTS[-1], ['Member'])"
  You are a Member.
  dtml-else
  Your are NOT a Member.
  /dtml-if

When I first request the protected document /Bogus/membersonly, I'm prompted
to log in.  When I do, I get access to the /Bogus/membersonly document.
Then when I request /Bogus/isMember, it says I am a Member.  However, when I
request /isMember, it says I am NOT a Member.  Anywhere I request isMember,
other than in the /Bogus folder, I am NOT a Member, even though the user is
defined at the root level with the Member role.

If I then request a protected document /membersonly, it shows me the
document without prompt.  After I do that, when I request /isMember or
/AnyFolder/isMember, it now tells me I am a Member.

Why does it not recognize that I'm a user with the Member role anywhere on
the site until I access a protected document at the root level?  Is this by
design or a bug?  If by design, what's the reasoning?

Thanks!
_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] hasRole bug or feature in 2.2.?

2001-01-11 Thread Ron Bickers

 -Original Message-
 From: Chris McDonough [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 11, 2001 6:25 PM
 To: Ron Bickers; [EMAIL PROTECTED]
 Subject: Re: [Zope] hasRole bug or feature in 2.2.?


 You're gonna laugh.  Get ready.

 You didn't protect the isMember document.  It's viewable by
 Anonymous.  The
 Zope security machinery short-circuits authentication for resources that
 don't require it.  This means that when you view a resource that's
 unprotected, you view it "as Anonymous".  Anonymous doesn't have
 the Member
 role, so you see "You are NOT a Member" when you view /isMember.

I'm not sure this makes sense.  If I protect isMember, then anonymous won't
be able to determine if they're a member without being prompted to log in.
Isn't that true?  That's not what I want.

Also, why does it behave differently after I view a protected document in
the root?  isMember is still not protected, but it then correctly returns
that I have the Member role anywhere in the site.

___________

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] MySQLDA and MySQL-python - patch needed?

2001-01-10 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 [EMAIL PROTECTED]
 Sent: Wednesday, January 10, 2001 9:30 AM
 To: [EMAIL PROTECTED]
 Subject: [Zope] MySQLDA and MySQL-python - patch needed?


 My Zope-MySQL connection is still not quite working. It appears that the
 request from Zope is reaching MySQL and it if is an UPDATE or INSERT query
 it executes properly on the MySQL side. However, SELECT queries
 and similar
 are not getting their information back to Zope from MySQL. Is there some
 patch I am missing here? Anybody know how to fix this?

 FYI:
 I installed from these rpms

 ftp://ftp.logicetc.com/pub/Zope/RPMS/MySQL-python-0.2.1-1.i386.rpm
 ftp://ftp.logicetc.com/pub/Zope/RPMS/Zope-ZMySQLDA-1.2.0-1.i386.rpm

 This did not install into my Zope installation directory, so I used a
 symbolic link in my Zope Products directory that points to the
 directory of
 MySQLDA install. Could this be the cause? Perhaps information that should
 be returned from MySQL is getting lost on the return trip. If so,
 how would
 I fix it? Any ideas?

The RPMS install the DA where the Zope RPMS install Products.  I actually
put my products in the same place (RPMS or not) and use symbolic links for
the different instances of Zope I have running, so I know symbolic links
will work.  If DA product is showing not broken in the Control Panel, then
it was installed properly.

Are you getting any error messages?  How do you know the information is not
getting back to Zope?  When you test the queries on the connection
management screen, do you get results?

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Python Scripts in 2.2.x

2001-01-08 Thread Ron Bickers

I'm running PythonScripts with 2.2.4 and, with one exception, they seem to
be working just fine.  The exception is that DTML namespace binding does not
work under 2.2.  You can, however, pass the namespace explicitly to get the
same effect.  Here is what you need to do to get it working.  Note that
PythonScripts under 2.2 is not supported by DC, so if this blows up, you're
out of luck.

1) Install PythonScripts from CVS (Zope2/lib/python/Products/PythonScripts)
just like any other Python Product.

2) Add these lines to lib/python/AccessControl/__init__.py in your Zope
installation:

from SecurityInfo import ClassSecurityInfo, ModuleSecurityInfo
from SecurityInfo import ACCESS_PRIVATE
from SecurityInfo import ACCESS_PUBLIC
from SecurityInfo import ACCESS_NONE
from SecurityInfo import secureModule

3) Add the CVS version of AccessControl/SecurityInfo.py to the AccessControl
directory.

4) Add the CVS version of OFS/Cache.py to the OFS directory.

5) Restart Zope

Other than the exception above, I haven't found anything to not function as
expected.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 Mayers, Philip J
 Sent: Monday, January 08, 2001 10:40 AM
 To: '[EMAIL PROTECTED]'
 Subject: [Zope] Python Scripts in 2.2.x


 I need to use LoginManager, which doesn't seem to work with 2.3,
 and I need
 to use Python Scripts, which are not available (?) for 2.2.x - any ideas?



___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] ZClass Define Permissions confusion

2001-01-07 Thread Ron Bickers

After having read the Zope Book Security chapter and various other security
howtos, I understand better how permissions apply in ZClass methods and
property sheets.  However, I'm still confused about a couple things.

1) What is affected by each of the 'Define Permissions' settings in the
ZClasses main screen?  I created a new permission and assigned it to
different things in the list, but the only one that seems to do as I might
expect is the 'Create class instances'.  I can't figure out what the others
do.

2) I have a ZClass that, upon creation of a new instance, creates an Image
object in the new instance.  Everything works as I would expect, but I'm not
sure how (or if) I can define permissions to that object in the ZClass.
More specifically, I have to give Image create/change/delete access in the
container Folder where the ZClass instance is in order for the user to be
able to modify the image inside the ZClass object.  Is there a better way
using the ZClass permissions?

Does this make sense?  I understand pretty well the permission system
outside of ZClasses, it's just inside them that's giving me a headache.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Turn Off Rampant Capitalization?

2000-12-28 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kyler
 B. Laird
 Sent: Thursday, December 28, 2000 12:52 PM
 To: Chris McDonough
 Cc: [EMAIL PROTECTED]
 Subject: Re: [Zope] Turn Off Rampant Capitalization?


 Which of the following is a proper noun or acronym?
   Zope Contents View Properties Import/Export Security Undo
 Ownership Find
   Rename Cut Copy Delete Export Available Objects Add Help
   Property Name Type Value
   Digital Creations

Zope and Digital Creations are probably the only two that should be
capitalized in any context, but IMO all of the others are correctly
capitalized in the context of a tab, since the label of a tab is along the
lines of a title, which is correct to capitalize.  Also, in a sentence when
referring to a label or tab, it would be correct to capitalize.  I happen to
think it's eaiser to read that way, but I suppose reasonable people might
disagree.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] passwords TTW - security hole?

2000-12-18 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill
 Welch
 Sent: Monday, December 18, 2000 11:03 AM
 To: [EMAIL PROTECTED]
 Subject: [Zope] passwords TTW - security hole?


 AFAIK, inputs of type password are sent to the server as plain text. In
 Login Manager, for example, that would mean that passwords are exposed
 every time someone logs in. In User Folder, the passwords would be exposed
 whenever they're changed.

It's even worse than every time someone logs in.  With HTTP Basic
Authentication, the username and password are sent with every Web request.
This means that after authentication, for each and every page you visit and
every image and file you request, you're username and password is sent.

 If my interpretation is correct, then it seems to me to be a call for
 out-of-the-box ssl support in zope.

That would be nice, or at least some authentication method that is more
secure.  However, I'm not sure what, if any, secure-ish authentication
method popular browsers support.  It's not hard to use Zope through Apache
with SSL support for those that are running Apache, but I know not everyone
is doing that.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] What version of Python Methods - no - Scripts for 2.2.4?

2000-12-14 Thread Ron Bickers


 -Original Message-
 From: Itai Tavor [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, December 14, 2000 7:55 PM
 To: [EMAIL PROTECTED]
 Cc: Ron Bickers
 Subject: RE: [Zope] What version of Python Methods - no - Scripts for
 2.2.4?

 I also had to add OFS/Cache.py from the CVS for this to work.

That's interesting.  I don't have OFS/Cache.py and it seems to be working
fine.  Maybe there was a recent change that now requires it?
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] What version of Python Methods - no - Scripts for 2.2.4?

2000-12-13 Thread Ron Bickers

I got PythonScripts running on 2.2.4 after doing the following:

1) Install PythonScripts from CVS just like any other Product.

2) Add these lines to lib/python/AccessControl/__init__.py:

from SecurityInfo import ClassSecurityInfo, ModuleSecurityInfo
from SecurityInfo import ACCESS_PRIVATE
from SecurityInfo import ACCESS_PUBLIC
from SecurityInfo import ACCESS_NONE
from SecurityInfo import secureModule

3) Add the CVS version of SecurityInfo.py to lib/python/AccessControl/

It works in my limited testing, but I have no idea if something is badly
broken that just hasn't shown itself yet.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Evan
 Simpson
 Sent: Wednesday, December 13, 2000 2:52 PM
 To: Ronald L. Roeber; [EMAIL PROTECTED]
 Subject: Re: [Zope] What version of Python Methods - no - Scripts for
 2.2.4?


 From: Evan Simpson [EMAIL PROTECTED]
  After a little experimentation, I was able to get it to run with Zope
 2.0.0.
  It required small changes to __init__.py and Guarded.py, which are
 available
  through cvs.zope.org.

 P.P.S.

 That's "2.2.0", not "2.0.0", and as of three hours ago you would also need
 to backport (or stub out) OFS.Cache :-(

 Sorry,

 Evan @ digicool  4-am


 ___
 Zope maillist  -  [EMAIL PROTECTED]
 http://lists.zope.org/mailman/listinfo/zope
 **   No cross posts or HTML encoding!  **
 (Related lists -
  http://lists.zope.org/mailman/listinfo/zope-announce
  http://lists.zope.org/mailman/listinfo/zope-dev )




___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Data.fs

2000-12-06 Thread Ron Bickers

At least one option is to use the INSTANCE_HOME setup as described at
http://www.zope.org/Members/4am/instancehome

I'm using this to run several servers (and thus several different Data.fs
files) with one Zope installation.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom
 Deprez
 Sent: Wednesday, December 06, 2000 1:05 PM
 To: [EMAIL PROTECTED]
 Subject: [Zope] Data.fs


 Hi,

 My  Zope is installed in /usr/local/zope

 Is it possible to tell zope to store the data.fs file on another
 directory?

 eg. /home/zope/var

 ie. Can you run zope from the directory /usr/local/zope and let it use the
 data.fs file
   from /home/zope/var and not /usr/local/zope/var

 If so, how can I do this?


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] mod_fastcgi

2000-12-05 Thread Ron Bickers



 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 michael angelo ruberto
 Sent: Tuesday, December 05, 2000 3:36 PM
 To: [EMAIL PROTECTED]
 Subject: [Zope] mod_fastcgi


 hi,

 i was wondering what if any difference there is for zope if i
 install it to
 access mod_fastcgi through a port as opposed to a socket. which is the
 recommended/safest approach?

In theory (and maybe in practice) the socket should be faster since it does
not go through the networking process.  However, since it uses a local file,
Zope and Apache must be one the same system.  Using a TCP port would be
slower, but it allows you to run Zope and Apache on different machines.  As
to how much faster or slower, I have no idea if anyone has done any testing.

As for safest/recommended, avoiding the network is probably always safer
(although with the loopback, I'm not sure it makes any difference).  But if
you need to run them on different servers, you don't have a choice.

I've found mod_fastcgi very easy to configure in Apache and have had no
problems using it through a port.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] DC request re: Objection to Python Script Name

2000-11-24 Thread Ron Bickers

Quoting Hamish Lawson [EMAIL PROTECTED]:

 understanding. I agree with him that the new name 
needs to make it into
 the book, and Script is a reasonable choice. Is it 
intended to rename
 DTML Method, ZSQL Method, etc to be DTML Script, SQL 
Script, etc? For
 the sake of consistency I'm hoping so, and I think 
it's important that
 these revisions also make it into the book.

I agree that this consistency is important, and "before 
the book" is a good time to disrupt names.

Also, what about External Method?  External Script?  
Also, are these going to remain only available in the 
Python language?  If not, that name becomes an issue 
too.

I hope all this naming talk isn't too distracting for 
DC, but I (and clearly others) think it's important, 
esp. before the world sees it in print.

---
Ron

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] Re: Open Source Process (was:DC request re: Objection to Python Script Name)

2000-11-24 Thread Ron Bickers

Quoting Tim Cook [EMAIL PROTECTED]:

 While you may / may not have a legitimate stand on
the name
 change. This is the wrong 'string to pull'.
 This is in fact consistent with the open source
nature of the
 product. There comes a time when a decision needs to
be made. It
 gets made by the benevolent dictator, at the time
he/she/it
 decides. It's part of the process. (Yes, I used the
contraction
 properly too!). g

I know (even before I read Michel's and Tim's
messages), that I've mistakenly used the term open
source in my argument.  Perhaps I was thinking of the
fishbowl process DC has put into place to allow a more
open development process and public participation in
decisions in general.  Sorry for the misuse in this
case. I certainly prefer an excellent open source
product with bad naming conventions over a closed
source product with good ones.

I suppose I am most interested in consistent,
representative naming.  With Michel's explanation of
the Python "Method" and generic script, I'm more
comfortable with the name.  I am, however, interested
in what will be done to make ther other "Methods" less
intimidating to new users as Michel argued was one
reason for using Script.  Will we end up with DTML
Documents and DTML Scripts, SQL Scripts, etc.?

Thank you, DC and Zope community, for a great product.
I would use it even if they were called "little bits of
Python code." :-)

---
Ron

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] DC request re: Objection to Python Script Name

2000-11-23 Thread Ron Bickers

On Thu, 23 Nov 2000, Chris Withers wrote:

 To Hamish, the other Chris, and anyone else who's going to jump in on
 this.
 
 To be quite blunt, this has now been _decided_ as I understand it. So
 it's pointless to keep arguing and suggesting new and different names.
 We now _have_ a president and it's name is 'Python Script' ;-)

With all due respect to everyone, this should not be considered a closed
issue.  My understanding is that there would be a vote for a name.
Skipping that in the name of getting things moving after it was offered by
Digital Creations seems to go against the open source nature of the
product.  Not to mention that the name chosen does nothing to distinguish
it from an everyday Python "script" outside of Zope, which is what sparked
the name change to begin with.  "It's not really a Python method, so let's
change the name."  Well, it's not just a "Python Script" either.  It's
Zopified.

I agree with Hamish Lawson on the renaming of methods to use a language
name with a ZMethod suffix for consistency and for all of the other
reasons he mentioned.  The argument that all documentation would be
rendered incorrect should not be an excuse for keeping bad naming
conventions.  A document describing new names vs. old names could easily
be provided in the book and in an easily accessible location on the Zope
site.  Over time the "problem" would go away and we would end up with
something that is consistent, representative, and easy to understand. On
that same note, maybe Zope *should* provide an "alias" for
bobobase_modification_time and depricate its use?  Maybe I'm pushing it on
that one since I don't know what major internal chaos it might cause, but
I hope you understand my point.  The new getId() comes to mind as an
example in the right direction.

Please, Digital Creations, keep this issue open for consideration in the
name of a better product.  *Before* the book is published is the time to
pick a naming convention that isn't confusing.  I do care about the name.
I took great care in naming my child, and though it's not quite the same
thing, I think DC should do the same.

Thanks, and I *love* Zope.

---
Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]



___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] FTP crashing zope (was: snappier zope.org/how to make sites as snappy)

2000-11-20 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 Martin Winkler
 Sent: Monday, November 20, 2000 6:45 AM
 To: [EMAIL PROTECTED]
 Subject: Re: [Zope] snappier zope.org/how to make sites as snappy


 BTW: we do not use the FTP-Server feature of Zope, since it
 sometimes kills all Zope servers - tested on 2 different machines
 with different flavours of Linux :-(

Someone suggested to me that when they used passive mode it would not crash,
vs. using normal mode it would sometimes.  I could have those reversed, but
the bottom line was that they've been using one of the modes for some time
without any problems, whereas the other mode would crash Zope "at random".

Does that shed any light on fixing this serious problem?
_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] ZMethod (Safe)

2000-11-09 Thread Ron Bickers


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Evan
 Simpson
 Sent: Wednesday, November 08, 2000 6:14 PM
 To: [EMAIL PROTECTED]
 Cc: Jason Cunliffe; Oliver Bleutgen; Chris Withers;
 [EMAIL PROTECTED]
 Subject: Re: [Zope] ZMethod (Safe)

  Moreover, this also fails the concise/'easy to say' test that was
  used to kick out several other meritorius naming suggestions.
  Unrestricted Python ZMethod (8 syllables, 26 letters) is a
  mouthful!

 True (although some of the alternatives base names were worse).
 Considering that there aren't (yet)
 other language variants, and that I would usually use the
 restricted kind, I would normally just say
 "ZMethod".  Only if there were some potential confusion would I
 say "Unrestricted zmethod", or the
 full title.

Since you would normally *say* just ZMethod, I like the suggestion of using
"Python ZMethod" and "Python ZMethod (Unrestricted)", vs. spelling out the
(Restricted) in the first one.  After all, are we going to have a "DTML
ZMethod (Restricted)", or a "SQL ZMethod (Restricted)"?  It make sense to
keep the "normal" (restricted) methods, that will/should be used more often
than not, labeled as plainly as possible.  The unrestricted version could be
the exception and labeled as such.

For example, if we do decide to create an unrestricted DTML method, it would
seem unnecessary to rename DTML ZMethod to include the restricted label.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] use of objectValues() in DTML Methods vs. DTML Documents

2000-10-25 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike
 Bannister
 Sent: Wednesday, October 25, 2000 5:44 AM
 To: [EMAIL PROTECTED]
 Subject: [Zope] use of objectValues() in DTML Methods vs. DTML Documents

 Just for the heck of it I dropped that same code into a DTML
 Document in the
 same Folder and it didn't list the Files as I had expected. I understand
 pretty much the differences of Methods and Documents and I'm assuming the
 reason for this is related to the way the Documents exists in it's own
 namespace and the Method doesn't... so my best guess for this behavior is
 that the 'scope' of objectValues() is limited to the current namespace.

 Am I even close? If not can someone explain this to me?

That's basically it, yes.

I think of a method as being a function that works on the object it is "in",
and a document as being an object that gets worked on.  So objectValues() in
a method will return objects from its container, whereas objectValues() in a
document will always return objects from within that document.

Acquisition plays a role too, since a method can work in different contexts.

For example (given myMethod and myDocument that both use objectValues())

TestFolder1.myMethod will return objects in TestFolder1
TestFolder2.myMethod will return objects in TestFolder2

TestFolder1.myDocument will return objects in myDocument
TestFolder2.myDocument will return objects in myDocument

I hope this makes sense.

_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]



___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] RE: aq_base

2000-10-12 Thread Ron Bickers

 -Original Message-
 From: Chris Withers [mailto:[EMAIL PROTECTED]]

 Dieter Maurer wrote:
  At least in Zope 2.2.1, "aq_base" was not exposed
  to DTML.

 ...and I don't think it ever would or should be sicne it strips off all
 security context and would probably let you do 'bad things' :-S

Well... aq_base appears to work just fine in a Python method (not external).
Is that a bad thing?

I ended up creating a sameObject Python method that compares two objects'
aq_base and it does what I expect.  I'm using it to determine if I need to
display the global menu under the local menu, or if the global menu *is* the
local menu, so different context behavior isn't an issue.

I suppose an upcoming Zope will take care of this problem if it gives the
intuitive results with an == comparison.

Thanks for all of your help!!
_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] How to see if two objects are the same

2000-10-11 Thread Ron Bickers


I want to see if an object is the one aqcuired from the root, but I'm
hitting walls.

  dtml-var "myObject"
  dtml-var "PARENTS[-1].myObject"
  dtml-var "PARENTS[-1].myObject is myObject"

This returns the following when in the root folder context:

  TinyTable instance at 8684ad8
  TinyTable instance at 8684ad8
  0

It returns the following in a folder where there is another myObject:

  TinyTable instance at 8684ad8
  TinyTable instance at 86709f8
  0

What am I missing in the comparison?

Thanks!

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] How to see if two objects are the same (minor fix)

2000-10-11 Thread Ron Bickers

 From my previous post, it looked like the parent was changing.  I had
the first two lines swapped.  Fixed below.



I want to see if an object is the one aqcuired from the root, but I'm
hitting walls.

  dtml-var "PARENTS[-1].myObject"
  dtml-var "myObject"
  dtml-var "PARENTS[-1].myObject is myObject"

This returns the following when in the root folder context:

  TinyTable instance at 8684ad8
  TinyTable instance at 8684ad8
  0

It returns the following in a folder where there is another myObject:

  TinyTable instance at 8684ad8
  TinyTable instance at 86709f8
  0

What am I missing in the comparison?

Thanks!

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] How to use management tabs not for management

2000-10-02 Thread Ron Bickers


I want to create create HTML pages with my own Zopish looking tabs that have
nothing to do with Zope management.  Is there a simple way to use
manage_tabs for this, or do I need to make my own version of it?  Everything
I've tried gets me caught up in the Zope management system.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] How to use management tabs not for management

2000-10-02 Thread Ron Bickers

I didn't mean to imply that I didn't want to use any DTML.  If there's a way
to set manage_options and call manage_tabs though DTML or a Python method,
that would be ideal.  I would like to avoid having to create my own modified
manage_tabs for this purpose, but if that's what it takes, so be it.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: Peter Bengtsson [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 02, 2000 7:23 AM
 To: Ron Bickers
 Cc: [EMAIL PROTECTED]
 Subject: Re: [Zope] How to use management tabs not for management


 Viewing the HTML source of your Zope management and highlightning
 the tabs HTML? There is no DTML there.
 However, there are some images. src="/p_/ltab" and src="/p_/rtab"
 Could that be it?

 
  I want to create create HTML pages with my own Zopish looking
 tabs that have
  nothing to do with Zope management.  Is there a simple way to use
  manage_tabs for this, or do I need to make my own version of
 it?  Everything
  I've tried gets me caught up in the Zope management system.


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] A strange difference between DTMLDocument versus DTMLMethod Zope 2.2.2

2000-09-20 Thread Ron Bickers


The is a good example for illustrating the difference in a DTML Method and a
DTML Document.

With the below code, when "objectItems('Folder')" is called in a DTML
Method, the list returned is a list of Folders in the DTML Method's
*container* object (often a Folder).  In this case, you'll get a list of the
Folders that are in the Folder where the DTML Method is.

When "objectItems('Folder')" is called in a DTML Document, the DTML Document
itself is the object where Folder items are being searched for.  Since there
cannot be Folder items in a DTML Document, you get an empty list.

When you call "PARENTS[-1].objectItems('Folder')", you're asking for the
Folder items in the root object (PARENTS[-1]), so you get a list of Folders
in the root Folder.

The only time you'll get a non-empty result is when you call
objectItems('Folder') from an object that can contain other Folders.  A
Folder object, of course, is the most common object that can contain
Folders.

In short, the behavior you are experiencing is correct and by design.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 cuiod-tec Jens Gelhaar
 Sent: Wednesday, September 20, 2000 11:40 AM
 To: [EMAIL PROTECTED]
 Subject: [Zope] A strange difference between DTMLDocument versus
 DTMLMethod Zope 2.2.2


 The following few lines have a different result, when I execute
 it within an
 DTMLDocument or DTMLMethod.

 dtml-var standard_html_header
 dtml-in "objectItems('Folder')"
   dtml-var title_or_id
 /dtml-in
 dtml-var standard_html_footer

 The DTMLMethod result looks like it should be, but within a
 DTMLDocument the
 result is empty. When I modify the dtml-in tag slightly, then
 it works to

 dtml-in "PARENTS[-1].objectItems('Folder')"

 I does not seem to me consistent. Is it a new feature or bug.
 Beside, when I
 call the DTMLMethod from another Document, the result is empty to.


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Looking for Zope vs. Others at-a-glance comparison

2000-09-11 Thread Ron Bickers


 What Manila has done is to provide some reasonable default templates for
 getting useful site development work done 'out of the box' - they have
 provided a structure template, and well defined access to changing the
 obvious things people want to change.

I see.  Having higher level drop-in Web sites, IMO, is a job for add-on Zope
products that could be created by DC or the community to meet various needs
(as in Squishdot like projects).  As the Zope community grows, I have no
doubt that more add-on products for "Web sites in a can" will pop up.

  to do so.  Zope (in my experience) does nothing to limit the ability to
 make
  a site attractive, but it does do buckets for increasing manageability.

 Yes. I quite agree..But why are there no attractive Zope sites?

I can only guess that most Zope users are either not designers or are so
filled with awe over its power that they forget to put effort into beauty.
:-)  I think Zope lends itself more to the programmer and content provider
types, and leaves the designer with nothing special to desire.  I don't say
that in a bad way, but Zope isn't a design tool, so designers have no
special interest in learning to use it.  As Zope makes its way into more
businesses with design teams, pretty design will make its way into more Zope
sites.

  world examples of Zope's power.  Using any of the already available
  calendar-like products for Zope, DC could easily create a calendar to
 browse
  through stuff.  Again, it's not a limitation of Zope, the
 developers just
  didn't do it.

 Yes and I am continuously curious why they did not?

My understanding is that DC has been putting so much of their resources into
the Zope core, much needed documentation, and probably their consulting
business, that their own Web site has been left with a lower priority.  I
don't fault them for that.  I think they've done a great job at
prioritizing.

 And if you select yes you will get 'index_html' and 'acl_users' included..
 THIS is the entry point I am talking about
 The 'Add a Folder' page needs to offer more so that it can default to the
 immediate bones of a useful site, methods and links. The irony to

I think the "bones of a useful site" belong in a different object than a
Folder, though I agree that specialized products/objects for canned sites
would be a nice addition to the Zope products list, whether from DC or the
community.

___________

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Looking for Zope vs. Others at-a-glance comparison

2000-09-10 Thread Ron Bickers
 while admittedly not knowing much about the
alternatives for comparison.  I do know, however, that Zope is powerful and
has been loads of fun to work with.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] 2.1.6 and ZSQL methods

2000-07-13 Thread Ron Bickers

My understanding was that DC decided not to fix it, but instead concentrate
on the 2.2 series.  There are some patches floating around in the archives,
but none of them worked 100% for me.  I just gave up and am running 2.2b4.
The 2.2 betas has been plenty stable for me.  Even with the few problems
with the ealy betas, it has always run without blowing up.

I *think*, depending on the authentication circumstances and location of the
ZSQL methods, you might be able to rename the arguments that they use such
that there is no conflict from acquisition (e.g., rename 'id' to 'myid' or
whatever).  That is, make sure the arguments are unique names.  That turned
out to be a big pain, but it worked.  I had other problems with
authentication that I could never find a workaround.  That's why I just went
to 2.2.

Good luck. ;-)
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of The
 Sanfords
 Sent: Thursday, July 13, 2000 2:38 AM
 To: [EMAIL PROTECTED]
 Subject: [Zope] 2.1.6 and ZSQL methods


 Like an idiot I blythly ignored all the emails flying back
 and forth concerning the problems with 2.1.6 and ZSQL
 methods because I was not using 2.1.6 and didn't plan on
 upgrading my 2.1.4 until the 2.2 was stable. Hah!!!

 Was the issue ever resolved?

 I really need for my 2.1.4 ZSQL methods to work in 2.1.6.
 Does anyone know of a patch or other workarounds?


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] MySQL LIKE operator

2000-07-12 Thread Ron Bickers

You should be able to use something like this (untested):

dtml-var bar sql_quote

That way you get the SQL quoting without the surrounding quotes.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, July 12, 2000 11:03 AM
 To: [EMAIL PROTECTED]
 Subject: [Zope] MySQL LIKE operator
 
 
 Hello,
 
 I'm writing a search query to a MySQL database.  I want to keep
 people from screwing around with my database by running searches like ";
 delete from ... yada yada.  So I should use dtml-sqlvar, right?  But
 what if I want to use LIKE?
   If I say:  WHERE goo LIKE "%dtml-sqlvar name=bar type=string%"  then
 effectively I am saying: WHERE goo LIKE "%'somestring'%".  In other
 words, it will match only the string with the single quotes.  I hope
 this makes sense.  Has anyone faced a similar problem?
   Thanks for any help
 
 --Aaron
 
 
 ___
 Zope maillist  -  [EMAIL PROTECTED]
 http://lists.zope.org/mailman/listinfo/zope
 **   No cross posts or HTML encoding!  **
 (Related lists - 
  http://lists.zope.org/mailman/listinfo/zope-announce
  http://lists.zope.org/mailman/listinfo/zope-dev )
 
 

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] DTMLDocument content - html quoted or not

2000-07-11 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 Dieter Maurer
 Sent: Tuesday, July 11, 2000 6:54 PM
 To: [EMAIL PROTECTED]
 Subject: Re: [Zope] DTMLDocument content - "html quoted" or not


 Michael Gutmann writes:
   Aleksander Salwa schrieb am Fre, 07 Jul 2000:
   ...
   In mentioned method, to render document, I wrote:
   
   dtml-var this
   
   But this outputs html quoted text (so I see HTML and DTML
 tags in browser,
   instead of formatting and variables).
   Hmm, looks like a problem I had a few days ago. Maybe
  
  dtml-var "this.(_.None,_)"
 "this" is a parameter less method, thus you call is like "this()".
 Try dtml-var "this()(_.None,_)".

Wow!  Speaking of complicated DTML to do a simple thing.

I ran into this same problem while attempting to show someone how easy it
would be to create a simple 'view' method that includes 3 lines:  the
standard header, the document (using 'this'), and the standard footer.  That
way, some of our not so computer savvy content writers can just write their
documents and not have to be told they need to include some "special" tag at
the top and bottom of every page or it won't work.

At least I know how to do this now, but there *has* to be an easier way to
just include the document contents, right?  Why exactly doesn't dtml-var
this work?

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]



___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Trouble compiling ZMySQLDA

2000-07-09 Thread Ron Bickers

There seem to be several different (old?) instructions floating around on
how to install the Python MySQLdb and the Zope ZMySQLDA.  If you just want
it working, and you're using RPMs, you can grab my RPMs of Andy Dustman's
MySQLdb 0.2.1 and the ZMySQLDA 1.2.0 that now works with it.  As far as I
know, this is the latest mutually functional and thread friendly
combination.

ftp://ftp.logicetc.com/pub/Zope/RPMS/MySQL-python-0.2.1-1.i386.rpm
ftp://ftp.logicetc.com/pub/Zope/RPMS/Zope-ZMySQLDA-1.2.0-1.i386.rpm

Andy's MySQLdb - http://dustman.net/andy/python/MySQLdb/0.2.1
ZMySQLDA - http://www.zope.org/Members/mordred/ZMySQLDA

Note that Andy's latest 0.2.2 db doesn't yet work with ZMySQLDA 1.2.0.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ewald
 Wasscher
 Sent: Sunday, July 09, 2000 7:54 PM
 To: [EMAIL PROTECTED]
 Subject: [Zope] Trouble compiling ZMySQLDA


 Hello all,

 When I try to compile ZMySQLDA I get the following error messages after
 typing make:

 [root@catv6216 src]# make
 gcc -fPIC  -I/usr/local/mysql/include -I/usr/include/mysql -g -O2
 -I/usr/include/python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG_H -c
 ./MySQLmodule.c
 ./MySQLmodule.c: In function `pythonify_row':
 ./MySQLmodule.c:238: warning: assignment from incompatible pointer type
 ./MySQLmodule.c: In function `pythonify_res_fields':
 ./MySQLmodule.c:384: invalid lvalue in unary `'
 ./MySQLmodule.c: In function `STH_fetchdict':
 ./MySQLmodule.c:1125: invalid lvalue in unary `'
 ./MySQLmodule.c:1147: invalid lvalue in unary `'
 make: *** [MySQLmodule.o] Error 1
 [root@catv6216 src]#

 I can't even read a single line of c so I have no idea what's wrong
 exactly.

 FYI:

 OS: Immunix 6.2 (= RedHat 6.2 + stackguard)
 Zope: 2.1.6 (compiled from Jeff Rush's source rpm, 2.2b3 doesn't work
 either)
 MySQL: 3.22.32 and 3.23.21
 Python MySQLdb: 2.0 2.1

 Ewald Wasscher

 ___
 Zope maillist  -  [EMAIL PROTECTED]
 http://lists.zope.org/mailman/listinfo/zope
 **   No cross posts or HTML encoding!  **
 (Related lists -
  http://lists.zope.org/mailman/listinfo/zope-announce
  http://lists.zope.org/mailman/listinfo/zope-dev )




___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Trouble compiling ZMySQLDA

2000-07-09 Thread Ron Bickers

The RPMs install in /usr/share/zope/lib/python/Products, where the Zope RPMs
provided by Jeff Rush install the Products folder.  If you're not using the
Zope RPMs and have zope installed somewhere else, you can still use these
RPMs and just make a symlink to your real Products folder.  For example (if
Zope is installed in /usr/local/zope):

# cd /usr/local/zope/lib/python/Products
# ln -s /usr/share/zope/lib/python/Products/ZMySQLDA ZMySQLDA

Restart Zope and that should do it.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: Peter Marriott [mailto:[EMAIL PROTECTED]]
 Sent: Monday, July 10, 2000 12:58 AM
 To: Ron Bickers; [EMAIL PROTECTED]
 Subject: RE: [Zope] Trouble compiling ZMySQLDA


 I couldn't seem to get the RPMS to install, what kind of setup are they
 expecting?  Does it matter where I have installed zope?  (I am a linux
 learner so please forgive if I am not making sense)

 Thanks
 Peter.


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Number of zope processes on Linux and OpenBSD

2000-07-07 Thread Ron Bickers

I went the other way around and wondered why my single MySQL process on
FreeBSD was now a dozen or so on Linux.

As already mentioned, Linux assigns a process ID to every thread, so all
threads show in the process list.  On the BSDs (and probably most, if not
all other UNIX OSs), threads are not assigned PIDs, so they don't show.

Either way, Zope is running with multiple threads on both machines.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 Ragnar Beer
 Sent: Friday, July 07, 2000 2:55 AM
 To: [EMAIL PROTECTED]
 Subject: [Zope] Number of zope processes on Linux and OpenBSD


 Howdy! I have a question concerning the number of running zope
 processes: I used to run Zope under Linux and there was always more
 than a handful of zope processes running. Now I switched to OpenBSD
 and there is only one. How comes? I guess the more zope processes I
 have running the more requests I can satisfy?


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Unquoting a string.

2000-07-07 Thread Ron Bickers

dtml-sqlvar does quoting of strings to aid in placing them in SQL queries.

Use just dtml-var resp instead of dtml-sqlvar ...

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gregory Haley
 Sent: Friday, July 07, 2000 11:36 AM
 To: Zope
 Subject: [Zope] Unquoting a string.
 
 
 Hi,
 
 I am trying to pass a column id through a ZMySQL method
 call.  The thing looks like this:
 
 UPDATE venapoll 
   SET dtml-sqlvar resp type=string = last_insert_id(+1)
 WHERE poll_num = 3;
 
 where resp is a value passed in by a dtml method and can
 have the value of resp0, resp1, resp3, etc.  These are the
 names of columns.  Zope is blowing chuncks, because the
 parsed call is actually:
 
   SET 'resp1' = last_insert_id(+1)
 
 and ZMySQL needs to have the value passed in as 
 
   SET resp1 = . . .
 
 (i.e., without the quotes).
 
 Has anyone had a problem with this?


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] How do I merge form URL vars into sql easily

2000-07-05 Thread Ron Bickers

Unless I'm overlooking something here, you can just use the form variables
(e.g., dtml-var formVarName), whether POST or GET, in the ZSQL Method
itself.  You'll need to include the variable names in the arguments list of
the ZSQL Method, but that's it.

ZSQL Methods are explained (fairly well in my opinion) in the Z SQL Methods
User's Guide at http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.html

Note that if you're using Zope 2.1.6 (vs. 2.1.4 or 2.2b3) you may have
problems with this, since versions after 2.1.4 broke ZSQLMethods with regard
to names and in which order they are looked up.  This made me jump from
2.1.4 straight to the 2.2 beta series, where this is fixed.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 [EMAIL PROTECTED]
 Sent: Wednesday, July 05, 2000 5:32 PM
 To: [EMAIL PROTECTED]
 Subject: [Zope] How do I merge form  URL vars into sql easily


 I am a new user to Zope and I'm trying to pass data that has been
 entered into a form (either through GET or POST) into another
 object.  This object calls a z sql method to insert the form data into
 the database.  So far, the only way I've found to pass data to the
 sql is to define arguments for it and then, in the dtml-document (or
 method) use:
 dtml-call "REQUEST.set['argument','value']"
 (and it took me long enough to figure THAT out, let me tell you)
 The problem is that sucks when there are 30 form varibles that
 need to be inserted into the database.
   I would think that there is some way to let the sql method see
 these varibles that are defined within my document.  Or loop
 through all URL or form varibles defined and sets all the vars in
 request. Something to keep from having to write the above dtml 30
 times.  Thanks.

 Jake Feasel

 ___
 Zope maillist  -  [EMAIL PROTECTED]
 http://lists.zope.org/mailman/listinfo/zope
 **   No cross posts or HTML encoding!  **
 (Related lists -
  http://lists.zope.org/mailman/listinfo/zope-announce
  http://lists.zope.org/mailman/listinfo/zope-dev )




___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] 2.2b3 and absolute_url wrong?

2000-07-03 Thread Ron Bickers

I have a folder "RSSChannels" with a few RSSChannel instances in it, one of
which is called 'zopenews'.  There is also a DTML Method called 'view_all"
that displays the channel contents.

In Zope 2.1.4, both of the following code snippets resulted in
http://localhost/RSSChannels/zopenews/view_all, but Zope 2.2b3 returns
http://localhost/RSSChannels/view_all.

Is 2.2b3 broken, or was 2.1.4?

dtml-var "RSSChannels.zopenews.view_all" url

or

dtml-with RSSChannels
 dtml-with zopenews
   dtml-var view_all url
 /dtml-with
/dtml-with

_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] 2.2b3 and INSTANCE_HOME problem

2000-07-01 Thread Ron Bickers

 -Original Message-
 From: Evan Simpson [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, July 01, 2000 2:02 AM
 To: Ron Bickers; [EMAIL PROTECTED]
 Subject: Re: [Zope] 2.2b3 and INSTANCE_HOME problem


 - Original Message -
 From: "Ron Bickers" [EMAIL PROTECTED]
  It's not looking in the right place for the image file in
 XMLDocument. You
  can see that if found the XMLDocument product in INSTANCE_HOME/Products
 (of
  course, or it wouldn't have tried to install it in the first place).

  Is this a bug, or do I need to set some other variable, or what?

 It's a bug.  I've been tracking down and squishing a few in corners where
 INSTANCE_HOME wasn't properly taken into account, but I hadn't gotten to
 XMLDocument yet.  This should be fixed in CVS shortly (and the
 next release
 of Zope).

Great!  Thanks!

For now, I just made links in the zope installation to the products so that
when it needs to find stuff, it can.
_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] MySQL Select Statements

2000-06-30 Thread Ron Bickers

 -Original Message-
 From: Andy Dustman [mailto:[EMAIL PROTECTED]]
 Sent: Friday, June 30, 2000 11:42 AM
 To: Michael Blewett
 Cc: Ron Bickers; [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: RE: [Zope] MySQL Select Statements


 It's a matter of perspective. I prefer to think of it as 0.2.2 breaks
 ZMySQLDA. This is because ZMySQLDA uses _mysql, and _mysql prior to 0.2.2
 implemented fetch_row(), fetch_rows(), fetch_all_rows(), and the
 ..._as_dict() variants.

Thanks for clarifying that.  I hope the 1.2.0 DA continues to follow your
(Andy's) changes to the MySQLdb so that we can have a nice, working, stable
db/DA combination.

 what the solution is for this. It may be necessary to have the ZMySQLDA
 package include another DA: ZMySQLTDA for transactions. The standard DA

Please not two DAs just for the difference in transaction support.

 Obviously the application designer will have to use the right DA for the
 right table type...

It should be as simple as the application designer actually knowing what
they're doing by knowing whether or not they're working with a table that
supports transactions or not, and just not using BEGIN/COMMIT/ROLLBACK when
they're not.  Or is it too much to ask that designers know what they're
doing? :-)

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-06-30 Thread Ron Bickers

 -Original Message-
 From: Andy Dustman [mailto:[EMAIL PROTECTED]]
 Sent: Friday, June 30, 2000 1:25 PM
 To: Ron Bickers
 Cc: Michael Blewett; [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: RE: [Zope] MySQL Select Statements

 That's the problem: They don't get control over when BEGIN/COMMIT/ROLLBACK
 are used. Zope does that if you are using the Transaction Manager. And the
 only way to control use of the Transaction Manager is by
 selection of DA.

 That's why I think it may be necessary to have two ZMySQLDAs: One which is
 transactional and one which is not. However, they can both be part of the
 same distribution, and the transactional one can simply subclass the
 non-transactional one (mixing in the TM base and adding the required
 methods), so there is not a lot of code duplication.

I see.  So how would this affect use of transaction and non-transaction
supporting tables?  Would two separate database connections be required
where the SQLMethod must use the correct connection depending on transaction
support?

Making assumptions is bad, but suppose MySQL 3.23 does something elegant
with BEGIN/COMMIT/ROLLBACK attempts on non-transaction supporting tables
(like return a "table does not support transactions" or simply ignores that
statement).  Could we then just have one DA for 3.22 and another for 3.23,
where the 3.23 DA handles transactions, but silently ignores them when
dealing with non-transaction tables?

_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] 2.2b3 and INSTANCE_HOME problem

2000-06-30 Thread Ron Bickers

Using the instructions at http://www.zope.org/Members/4am/instancehome on
how to run multiple zopes with the same install, I semi-successfully have
two instances of 2.2b3 running.  However, when I run them, I get the
following traceback for XMLDocument (INSTANCE_HOME is /home/zopdev/zope in
this case):

2000-07-01T04:37:22 ERROR(200) Zope Couldn't install XMLDocument
Traceback (innermost last):
  File /usr/local/zope-2.2b3/lib/python/OFS/Application.py, line 467, in
install_products
(Object: ApplicationDefaultPermissions)
(Info: XMLDocument)
  File /home/zopedev/zope/Products/XMLDocument/__init__.py, line 102, in
initialize
  File /usr/local/zope-2.2b3/lib/python/App/ImageFile.py, line 110, in
__init__
IOError: [Errno 2] No such file or directory:
'/usr/local/zope-2.2b3/lib/python/Products/XMLDocument/xml_element.gif'

It's not looking in the right place for the image file in XMLDocument. You
can see that if found the XMLDocument product in INSTANCE_HOME/Products (of
course, or it wouldn't have tried to install it in the first place).

I get other IOErrors when I try to add or manipulate objects where Zope is
looking in the wrong place for dtml files or whatever.  Everything works as
far as I can tell when browsing the site itself.

Is this a bug, or do I need to set some other variable, or what?

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] MySQL Select Statements

2000-06-29 Thread Ron Bickers


 If I don't specify my Selects using "AS", I then get the following error
 message:

 Error Type: KeyError
 Error Value: SubjectName

Traceback (innermost last):
   File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/Publish.py,
line 214, in publish_module
   File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/Publish.py,
line 179, in publish

...

I overlooked that you are running 2.1.6.  I don't know about the error
message you're getting so this may be unrelated, but I and many many others
have had a lot of problems with 2.1.6 and ZSQLMethods.  So many that I stuck
with 2.1.4 and I'll skip directly to 2.2.

 It's funny that you say 0.2.2 is broken. Apart from this one glitch, it
 works fine for me (although from memory I think we had to do a little bit
 of fiddling at install time to get it to work).

I don't know a whole lot about the problem, but fetch_all_rows() is missing,
and for whatever reason that breaks my methods.  If it's working for you,
then great.  I don't guess that helps you with your problem though.  Did you
have this problem with 2.1.4?

_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] standard_html_header/footer for Help system in 2.2

2000-06-27 Thread Ron Bickers

The help system in 2.2 is looking great, with a minor annoying "feature".
The left-side navigational window uses my standard_html_header and footer,
which is not at all appropriate for a navigational window (it includes
navigational bars of its own and causes a big horizontal scrolling
situation).

The right-side topic window has its own very basic header and footer. Is
there a way (short of me modifying the help system) to get it to use a more
plain header/footer?  Maybe it should not use mine at all, but use its own
as does the Zope management interface itself.

_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Zope 2.2 beta 2 - (MySQLDA)

2000-06-23 Thread Ron Bickers

I've been running 2.0.0 from Andy without any problems.  I tried 1.2.0 and
it worked equally well.  2.0.0, BTW, can be found at
http://dustman.net/andy/python/ZMySQLDA/2.0.0a1.

It seemed to me that Andy wrote 2.0.0 primarily because it uses his own
MySQLdb python module without having to apply a patch to the DA.  Since
1.2.0 now does that as well, I suppose there's little need to use it over
the one published on zope.org.  None of this came from the mouth of Andy,
however, so this is all speculation.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of T.J.
 Mannos
 Sent: Friday, June 23, 2000 11:18 AM
 To: [EMAIL PROTECTED]
 Cc: IPM Return requested Receipt notification requested
 Subject: Re: [Zope] Zope 2.2 beta 2 released


 Monty,

 I can't find 1.2.0.  I run a search for MySQL and all that comes up is
 MikeP's version 1.1.3.  Come to think of it, I have no idea where I found
 2.0.0, either.  I think it was on a Zope news announcement for a
 while then
 disappeared.  Anyway, could you send me the URL to 1.2.0?

 Thanks,
 T.J.

 - Original Message -
 From: Monty Taylor [EMAIL PROTECTED]
 To: T.J. Mannos [EMAIL PROTECTED]
 Cc: IPM Return requested Receipt notification requested [EMAIL PROTECTED]
 Sent: Friday, June 23, 2000 1:53 AM
 Subject: Re: [Zope] Zope 2.2 beta 2 released


  Well, I'm not sure why you would need to change versions as I haven't
  done any testing of ZMySQLDA on the 2.2 Beta release, but I would
  suggest downloading and installing ZMySQLDA 1.2.0. Andy's version,
  2.0.0, isn't published because he doesn't really want to provide support
  right now. He does have some things in there that I want to migrate into
  the current line, and I've already included his changes to use the new
  backend module. So I can help you out a bit more if you use 1.2.0. But
  that's your call. I'll see what I can find out in any case, just as soon
  as I install a 2.2 server somewhere.


 ___
 Zope maillist  -  [EMAIL PROTECTED]
 http://lists.zope.org/mailman/listinfo/zope
 **   No cross posts or HTML encoding!  **
 (Related lists -
  http://lists.zope.org/mailman/listinfo/zope-announce
  http://lists.zope.org/mailman/listinfo/zope-dev )




___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Please test this Zope 2.2 beta 1 ZSQLMethods fix...

2000-06-21 Thread Ron Bickers

While I wasn't having the exact problem described below, this does appear to
have fixed the problem I was having with SQL Methods not being able to
access ZClass properties because of authentication problems.

My ZClass was working fine in 2.1.4/5/6, but not in 2.2beta1 because of
this.  Now it works fine in both.
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brian
 Lloyd
 Sent: Wednesday, June 21, 2000 11:26 AM
 To: '[EMAIL PROTECTED]'; Brian Lloyd; '[EMAIL PROTECTED]';
 '[EMAIL PROTECTED]'
 Subject: [Zope] Please test this Zope 2.2 beta 1 ZSQLMethods fix...


 Hi all,

 Several folks have reported problems in beta 1 with SQLMethods
 having authentication problems when trying to call other SQL
 Methods. I'd like a few intrepid volunteers to try something
 for me to see if it fixes the problem. I'd like to make a 2.2
 beta 2 release tomorrow but I want to make sure this issue is
 resolved first.

 Make a backup of the file:

 lib/python/Shared/DC/ZRDB/DA.py

 in your current (beta 1) installation and replace it with the
 DA.py attached to this email, restart and let me know if the
 problem goes away.



___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Problem with adding items to ZClass instance (semi-solved)

2000-06-20 Thread Ron Bickers

Thanks a lot for your help on this weird one!

Now that I know what to look into, I'll do that.

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rik
 Hoekstra
 Sent: Tuesday, June 20, 2000 4:53 AM
 To: Ron Bickers
 Cc: [EMAIL PROTECTED]
 Subject: Re: [Zope] Problem with adding items to ZClass instance

 OK, I downloaded it and I think I found your problem (not wure how to
 remediate this, though). If you look in the source of the management
 screen
 http://localhost/somefolder/IssueTrackerInstance/manage_main, the
 dropdown list for adding Product looks like this:
 
   FORM ACTION="http://localhost/somefolder/IssueTrackerInstance/"
 METHOD="GET"
   SELECT NAME=":method"
 ONCHANGE="location.href='http://localhost/testhier/blup/'+this.opt
 ions[this.selectedIndex].value"
 OPTION value="manage_workspace" DISABLEDAvailable Objects
   OPTION value="manage_addProduct/OFSP/documentAdd"DTML Document
   OPTION value="manage_addProduct/OFSP/methodAdd"DTML Method
   OPTION value="manage_addProduct/MailHost/addMailHost_form"Mail
 Host
   OPTION value="manage_addTinyTableForm"TinyTable
   OPTION value="manage_addProduct/OFSP/manage_addUserFolder"User
 Folder
   OPTION value="manage_addZMySQLConnectionForm"Z MySQL Database
 Connection
 /SELECT
   INPUT TYPE="SUBMIT" VALUE=" Add "
   /FORM
 
 As you see, most of the items have a manage_addProducts/ as a start.
 Not so with TinyTables and MySQLConnection. They call the
 add_TinyTableForm and manage_addZMySQLConnection form. They do not
 switch the namespace to manage_addProduct (not in the form). Why this is
 a problem, I can't tell, but this _is_ the problem.
 
 I'm not quite sure about the solution. Probably it's best to make a
 custom manage_main form that does the right incantations for adding
 products and then map this to your Contents View in the ZCLass
 definition.
 
 As a side I'd like to remark that all products should comply with the
 same manage_addProduct interface, because the current situation leads to
 nasty problems.
 
 Rik


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Problem with adding items to ZClass instance

2000-06-19 Thread Ron Bickers

 -Original Message-
 From: Rik Hoekstra [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 19, 2000 6:23 AM
 To: Ron Bickers
 Cc: [EMAIL PROTECTED]
 Subject: Re: [Zope] Problem with adding items to ZClass instance

 Hm, this is getting hard to answer. Adding normal instances of ZCLasses
 to other ZClasses should work. Are you adding everything straight from
 the management interface or programmatically from DTML?
 If from the management interface, are you sure you always add TinyTable
 etc from within the instance?
 If programmatically, could you send the code?

 Perhaps you could try and adding one of the problem products in another
 way (from a dtml method instead of the management interface or the other
 way around).

The items I'm adding aren't other ZClasses, but rather from python products.
I haven't come up with an exhaustive list of which items cause the problem
and which don't, but I know at least the TinyTable and ZMySQL DB Connection
do, and the DTML Methods/Documents, MailHost and UserFolders don't.

Everything is being added via the interface.  I haven't tried adding them
via DTML.  I've never done that because I haven't had a use for it, so I'm
not sure I know how.

I setup a series of screen shots to demonstrate exactly what's happening.
Take a look at http://www.logicetc.com/Test/zclass_problem if you're
interested.

Thanks!
___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] Problem with adding items to ZClass instance

2000-06-19 Thread Ron Bickers

 -Original Message-
 From: Rik Hoekstra [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 19, 2000 4:13 PM
 To: Ron Bickers
 Cc: [EMAIL PROTECTED]
 Subject: Re: [Zope] Problem with adding items to ZClass instance

 I looked at it, and found it fishy. The strange thing is, I tried to
 reproduce it, but I can't. To be sure I added a tiny table plus to an
 instance not a straight tiny table and a ZODBC adapter, but I
 doubt whether
 this would make a difference. Anyway, they both work straight
 away. This is
 getting very strange indeed. It seems strange things are happening to your
 namespace.

 I can think of some things that may cause problems, but this is all
 speculation.

 This may be a bug, but then it's a special one. Anything special
 about your
 ZClass - what does it derive from (just objectmanager? anything else that
 might cause strange behaviour?).
 Is there a subobjects tab in it's definition? Are the products in there?

I don't think there's anything "special" about my ZClass.  It's derived from
Catalog Aware and ObjectManager.  I believe I reproduced it without the
Catalog Aware and got the same results.

I'm using Andy Dustman's version of the MySQLDA and TinyTable v0.8.2.  They
both work just fine once I get the objects in the right place.  Maybe the
problem just happens to be with these two products, but I have no clue.

You're welcome to fetch the product at
ftp://ftp.logicetc.com/pub/Zope/IssueTracker.zexp if you want to give it a
look.  It's a one day throw-together port of the issue tracking system used
by the PHP project with modifications for my own needs.

Thanks!
_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] Problem with adding items to ZClass instance

2000-06-18 Thread Ron Bickers

On Sun, 18 Jun 2000, Rik Hoekstra wrote:

 This is not so easy to answer. ZClasses do strange things to adding items.
 If your ZCLass definition (in the Product) is nested in another ZClass, then
 it is your ZClass. If the ZClass  definition is defined in the top level of
 your product. There may be other things going on, including all of the above
 ;-)
 You'll need to provide more details to  be able to say more about this.

I'm not sure what kind of information would help.  Let me know what and
I'll be happy to provide it.  I'll provide the Product .zexp which
includes a single top-level ZClass, a couple dozen methods and a single
property sheet, if that would help.  There's nothing especially complex
about it.  It uses ZSQLMethods (w/ MySQLDA) and TinyTables, and once I can
get the stuff in the right place in the instance, everything works just
fine.

Thanks!

---
Ron


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope-dev] (no subject)

2000-06-16 Thread Ron Bickers

Howdy all,

I discovered something bizarre that happens in my 2.1.4 and 2.2b1
installations.

I have a ZClass based on ObjectManager.  In an instance of the ZClass, I can
"Add" most of the available objects (DTML Documents, DTML Methods, User
Folder, MailHost to name a few).  However, for at least two items (TinyTable
and ZMySQL DB Connection), when I add them, they show up in the container
folder, not in the ZClass instance.  Then, if I check it to delete it, it
gives a "does not exist" error.  Upon refreshing the container folder, the
item still shows, but then I *can* delete it.  Equally interesting is that I
can Copy the item from the container folder and successfully Paste it into
the ZClass instance.  However, since ZMySQL DB Connections don't support
Copy/Paste, that won't work.

What's going on?  Is it a problem with my ZClass, the Product manage_add, or
Zope?  Or me?

___________

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )




[Zope-dev] Problem with adding items to ZClass instance

2000-06-16 Thread Ron Bickers

[Doh... I don't read messages without subjects. Here 'tis again. Sorry.]

Howdy all,

I discovered something bizarre that happens in my 2.1.4 and 2.2b1
installations.

I have a ZClass based on ObjectManager.  In an instance of the ZClass, I can
"Add" most of the available objects (DTML Documents, DTML Methods, User
Folder, MailHost to name a few).  However, for at least two items (TinyTable
and ZMySQL DB Connection), when I add them, they show up in the container
folder, not in the ZClass instance.  Then, if I check it to delete it, it
gives a "does not exist" error.  Upon refreshing the container folder, the
item still shows, but then I *can* delete it.  Equally interesting is that I
can Copy the item from the container folder and successfully Paste it into
the ZClass instance.  However, since ZMySQL DB Connections don't support
Copy/Paste, that won't work.

What's going on?  Is it a problem with my ZClass, the Product manage_add, or
Zope?  Or me?

___________

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )




[Zope] (no subject)

2000-06-16 Thread Ron Bickers

Howdy all,

I discovered something bizarre that happens in my 2.1.4 and 2.2b1
installations.

I have a ZClass based on ObjectManager.  In an instance of the ZClass, I can
"Add" most of the available objects (DTML Documents, DTML Methods, User
Folder, MailHost to name a few).  However, for at least two items (TinyTable
and ZMySQL DB Connection), when I add them, they show up in the container
folder, not in the ZClass instance.  Then, if I check it to delete it, it
gives a "does not exist" error.  Upon refreshing the container folder, the
item still shows, but then I *can* delete it.  Equally interesting is that I
can Copy the item from the container folder and successfully Paste it into
the ZClass instance.  However, since ZMySQL DB Connections don't support
Copy/Paste, that won't work.

What's going on?  Is it a problem with my ZClass, the Product manage_add, or
Zope?  Or me?

___________

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] Problem with adding items to ZClass instance

2000-06-16 Thread Ron Bickers

[Doh... I don't read messages without subjects. Here 'tis again. Sorry.]

Howdy all,

I discovered something bizarre that happens in my 2.1.4 and 2.2b1
installations.

I have a ZClass based on ObjectManager.  In an instance of the ZClass, I can
"Add" most of the available objects (DTML Documents, DTML Methods, User
Folder, MailHost to name a few).  However, for at least two items (TinyTable
and ZMySQL DB Connection), when I add them, they show up in the container
folder, not in the ZClass instance.  Then, if I check it to delete it, it
gives a "does not exist" error.  Upon refreshing the container folder, the
item still shows, but then I *can* delete it.  Equally interesting is that I
can Copy the item from the container folder and successfully Paste it into
the ZClass instance.  However, since ZMySQL DB Connections don't support
Copy/Paste, that won't work.

What's going on?  Is it a problem with my ZClass, the Product manage_add, or
Zope?  Or me?

___________

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] Zope 2.1.5/6/7 ZSQLMethods problem

2000-06-15 Thread Ron Bickers


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brian
 Lloyd
 Sent: Thursday, June 15, 2000 5:26 PM
 To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
 Subject: [Zope] Zope security alert and 2.1.7 update [*important*]


 A Zope 2.1.7 release has been made that resolves this issue for
 Zope 2.1.x users. This release is available from Zope.org:

   http://www.zope.org/Products/Zope/2.1.7/


I assume based on the change log that this is the only fix in 2.1.7,
correct?

I fought for a full day to get my ZSQLMethods working in 2.1.6, but
apparently the argument aquisition or something like that is still so broken
that I had to jump back to 2.1.4.  I applied the various unofficial "fixes"
from the list archives (not all at the same time, of course) and none of
them did the trick.  I know others beat themselves up over this too.

The problem I'm talking about is the one where the arguments to the sql
method seem to be ignored.  That is, if I have an argument 'order', and I
have a DTML method (or any other "item") named 'order' in the same folder,
dtml-var order in the sql method refers to the DTML method, not the
argument.  This breaks dozens of sql methods I have.

With all of these security issues popping up, I don't like not being able to
upgrade.  Does anyone have a real fix for the ZSQLMethod problems in 2.1.6
that could be officially applied to the 2.1 series, or should I start using
the 2.2 betas?

Thanks!
___________

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] RSSChannel

2000-06-13 Thread Ron Bickers



 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Oleg
 Broytmann
 Sent: Tuesday, June 13, 2000 6:32 AM
 To: Zope Mailing List
 Subject: [Zope] RSSChannel


 Hello!

It is amazing how awful :) it is to find unlisted Product on
 Zope.org :(
Where can I find RSSChannel? Thanks...

Amos wrote an article on XML.com
(http://www.xml.com/pub/2000/02/23/zope/index.html) that goes through
creating an RSS Channel Manager.  There is a link to a very simple
RSSChannel product that he uses in the examples
(http://www.zope.org/Members/Amos/RSSChannel.tgz).  There's pretty much zero
documentation other than the article, but it's been working just fine for
me.

As the Site Summary docs state "Import is only limited to RSS 0.91 files,
not the older, "broken", version."  The RSSChannel product works with the
old broken version, which I just happen to need.

___________

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] ZSQL method broken on 2.1.6

2000-06-11 Thread Ron Bickers

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andreas
 Sent: Saturday, June 10, 2000 1:59 AM
 To: Umesh Soni
 Cc: Phill Hugo; [EMAIL PROTECTED]
 Subject: Re: [Zope] ZSQL method broken on 2.1.6

   
(using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1)
   

 As I know so far there is no way to disable this property or to set a
 value like 'maximum'

This version of ZMySQLDA (and possibly others) doesn't put the LIMIT
statement in at all if you set the maximum number of rows to 0 (zero).

Like someone else said, it's a "safety net" for queries that may accidently
return way too many records.
_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] ZSQL-Methods: last inserted id

2000-05-18 Thread Ron Bickers

You can get a ZSQLMethod that's used for inserting to return the last
inserted ID by doing the following:

  INSERT ...whatever...

  dtml-var sql_delimiter

  SELECT LAST_INSERT_ID() AS newid

You get the results as you would with any ZSQLMethod:

  dtml-in my_zsql_method
  Inserted ID: dtml-var newid
  /dtml-in

___

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andy
 Sent: Wednesday, May 17, 2000 7:45 PM
 To: [EMAIL PROTECTED]
 Subject: [Zope] ZSQL-Methods: last inserted id



 I wonder how I can find out about the last inserted id of a row in my
 mysql-database, which I inserted through a ZSQL-Method...

 I tried mysql's built-in function LAST_INSERT_ID(), but that did not solve
 my problem...


 ___
 Zope maillist  -  [EMAIL PROTECTED]
 http://lists.zope.org/mailman/listinfo/zope
 **   No cross posts or HTML encoding!  **
 (Related lists -
  http://lists.zope.org/mailman/listinfo/zope-announce
  http://lists.zope.org/mailman/listinfo/zope-dev )




___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )