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 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-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 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-16 Thread Ron Bickers
On Thu February 16 2006 03:31, you wrote:

> > http://www.lighttpd.net/
>
> How many millions of people use this a day?

I have no idea.  Far less than use Apache, of course, but the number appears 
to be growing steadily.

http://trac.lighttpd.net/trac/wiki/PoweredByLighttpd has a short list of 
those that bothered to add their names, but that doesn't mean a whole lot 
and it doesn't say anything at all about the SSL implementation.

> SSL is not something you want to use unless the server has been really
> well battle tested...

Both lighty and Apache use OpenSSL.  I'm using it and haven't seen any 
battlefield casualties so far. ;-)  Apache has its share of (even recent) 
security issues, including some related to mod_ssl. Lighty seems to be 
fitting well for those that need a smaller, simpler server, which is why I 
mentioned it.  I'll leave it as an exercise for the interested to determine 
if they want to use it.

-- 
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 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] 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 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] 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] 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 )


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] 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] 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 )




[Zope] Zope memory usage / cache

2001-01-30 Thread Ron Bickers

I have a site that has dozens of 300k+ Photo objects
(http://www.zope.org/Members/Drew/Photo).  When I start Zope, it uses about
10MB.  It will run at around 10-12MB for days as long as I don't access any
of the photos.  Once I access several of the photos, it jumps up to around
50MB.  The debug info says there are over 200 Photo object references.

If I then do a Cache minimize, there are no longer any Photo object
references, but the memory usage remains 50MB.  It will stay that high
indefinitely (at least as long as I have tested -- a few days), even if the
site isn't accessed.  If I restart, it goes back down to 10MB, and it will
stay there as long as my photos aren't accessed.

Is this normal behavior?  It seems crazy to have Zope sucking up that much
memory when those photos are hardly ever accessed.
___________

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] LocalFS on 2.3.0

2001-01-29 Thread Ron Bickers

I submitted the following patch to the LocalFS maintainer not too long ago.
LocalDirectory objects don't have _local_path set, so
bobobase_modification_time() barfs when the new management interface tries
to display the mod time.

--- LocalFS.py-dist Wed Jan 17 14:27:45 2001
+++ LocalFS.py  Wed Jan 17 14:33:21 2001
@@ -976,6 +976,8 @@
 except 'Forbidden': pass

 def bobobase_modification_time(self):
+if not hasattr(self, '_local_path'):
+self._local_path = self.basepath
 t = os.stat(self._local_path)[stat.ST_MTIME]
 return DateTime(t)

@@ -1179,7 +1181,7 @@
 """Change the properties of the file system object."""

 self.title = title
-self.basepath = os.path.normpath(basepath)
+self.basepath = self._local_path = os.path.normpath(basepath)
 self.default_document = default_document or self.default_document
 self.tree_view = self.isPrincipiaFolderish = tree_view
 self.catalog = catalog


___
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] 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-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] MYSQL Problem

2001-01-27 Thread Ron Bickers

The trailing L identifies a long int in Python.  As of ZMySQLDA 2.0.4, MySQL
integers use Python longs because an unsigned MySQL integer could overflow a
Python int.  So, it's a bug fix.

A couple solutions (found at http://dustman.net/andy/python/ZMySQLDA/2.0.4)
are to use  or something similar to strip the L, or
use Python 2.x, which would not display the L in this case.  You could also
modify MySQLDA to use a Python int if you know you're not going to have
integers that will overflow.

Note that Python 2 is not officially supported by Digital Creations, though
it does happen to work with Zope 2.3.0.
_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jens
Grewen
Sent: Saturday, January 27, 2001 11:36 PM
To: Zope Maillist
Subject: [Zope] MYSQL Problem

>From the following SQL statment I get the result  233L and not 233 as
expected

select count(PID)
from product

When I run this SQL Statment from another program I get the expected value
233.


In my installation there are a lot of Z SQL Methods that should return an
int value and when I use field description int in the database I always get
this 'L' behind the expected result. A lot of things don´t work because of
this.

When I change to mediumint (database field description) I get the expected
233.

How can I fix 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] 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 )




[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:

  
  Order Number: 
  Blah blah other session variables that work fine.
  

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

  
  
  Order Number: 
  Blah blah other session variables that work fine.
  
  

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] 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 )




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

> -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] 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


> 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] 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] 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 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 )




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 )




[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] 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 )




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] "Missing" attribute with ZSQL methods?

2001-01-17 Thread Ron Bickers


> If I write DTML that way:
>
> 
>
> 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  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


> 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] How to display only x records with

2001-01-15 Thread Ron Bickers

Exactly how is it not working?

Without knowing that, I'll guess that you might be seeing the effects of the
default orphan setting of 3, which prevents there from being a "left over"
batch of less than 3.  So if you only have 4 objects, setting size=2 will
still cause all 4 to be returned.  To force it to return your size, set
orphan=0.


...

___________

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> Timothy Wilson
> Sent: Monday, January 15, 2001 11:56 PM
> To: Zope listserv
> Subject: [Zope] How to display only x records with 
>
>
> Hey everyone,
>
> I've got a method to display some text which uses
> 
> to iterate through a bunch of "Spam and Eggs" ZClass instances. I thought
> that I could use size="2" in the  to display only the first two
> instances, but it's not working. I want to display only the first two and
> use a link at the bottom to direct people to see the rest on a separate
> page. 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 )




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 )




[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 )




[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] 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 )




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 )




[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:

  
  You are a Member.
  
  Your are NOT a Member.
  

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] 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 )




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 )




[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!). 

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 )




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] 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 )




RE: [Zope] Acquisiton Wrappers bite ;-)

2000-10-11 Thread Ron Bickers

> -Original Message-
> From: Chris Withers [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 11, 2000 3:16 PM
> To: Ron Bickers
> Cc: [EMAIL PROTECTED]
> Subject: Re: [Zope] Acquisiton Wrappers bite ;-)
>

> > 
>
> ...this one will return true in the next version of Zope, in the above
> example...
>
> To do comparisons like this, though, you really need to be in an
> external method or other unrestricted python so you can get access to
> .aq_base, which is the real object you're dealing with...

Thanks for the info.

So, is there another way in DTML I can see if an object was acquired from
PARENTS[-1] or not?  Is there a way to check an objects container out of
context?

___

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.

  
  
  

This returns the following when in the root folder context:

  
  
  0

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

  
  
  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

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.

  
  
  

This returns the following when in the root folder context:

  
  
  0

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

  
  
  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 )




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 )




[Zope] How to use management tabs not for management

2000-10-01 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] 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.
>
> 
> 
>   
> 
> 
>
> The DTMLMethod result looks like it should be, but within a
> DTMLDocument the
> result is empty. When I modify the  tag slightly, then
> it works to
>
> 
>
> 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
ds, ZSQL Methods and all the other
methods are there for a reason.  To each its own purpose.

> So may question is was not:
> - "What comparisons should I have made 12-18 months ago?",
> but rather:
> - "What is presently the state of play in Zope vs. Other Alternatives ?"

I rant about the powers of Zope 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):



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 , right?  But
> what if I want to use LIKE?
>   If I say:  WHERE goo LIKE "%%"  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:
>  > >
>  > >
>  > >
>  > >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
>  >
>  >
> "this" is a parameter less method, thus you call is like "this()".
> Try .

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  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

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] Trouble compiling ZMySQLDA

2000-07-09 Thread Ron Bickers

Actually, I just realized that what you're trying to compile is the MySQLdb
that comes with the DA.  The DA itself is written in Python, and doesn't
need to be compiled.

If you already have a db installed, and the DA is compatible with it, you
should be able to just put ZMySQLDA in the Products directory and restart
Zope.  If the DA isn't compatible (because it's written for a different db),
then your best and quickest solution is to install the mutually compatible
RPMs I posted.
___________

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

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] 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  instead of 

___

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  = 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] 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] 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., ), 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:
> 
> (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?



or


 
   
 


___

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] Cannot "uncheck" boolean properties in 2.2b3

2000-07-02 Thread Ron Bickers

In 2.2b3, after setting a boolean property to "checked", it will not save
when trying to "uncheck" it.  I reported this to the Collector already
(751).

As a workaround, you can just delete it and readd it since it defaults to
unchecked.

___________

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-06-30 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 )




[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 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 4:08 PM
> To: Ron Bickers
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [Zope] MySQL transaction support (was: MySQL Select
> Statements)

> with BDB tables. But it may be possible to break things down as having a
> DA for 3.22 and one for 3.23. Which is, in practice, may not be any
> different than having one that is not transactional (3.22 never is) and
> one that is transactional (3.23 sometimes is).

What I want to avoid is having to create two different "MySQL database
connections" where I have to choose the "correct" one based on whether or
not my SQL method is using transactions or not.  I'll most likely only be
using one version of MySQL at a time, but if I'm using transactions at all,
there's a good chance not all of my tables will support them.

I guess we'll just have to do some testing.
___

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 )




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 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 )




RE: [Zope] MySQL Select Statements

2000-06-29 Thread Ron Bickers

Why do you say you "must" use the AS statement?  Do you get an error
otherwise?

MySQLdb 0.2.2 is broken when used with ZMySQLDA.  But 0.2.1 works okay for
me.  Andy Dustman (author of the MySQLdb) said he will fix it and hinted
that one should use the ZMySQLDA that is on Zope.org (v1.2.0 now I believe).
Since that one now uses his MySQLdb, he will likely kill off his own DA.

_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> Michael Blewett
> Sent: Thursday, June 29, 2000 10:53 PM
> To: [EMAIL PROTECTED]
> Subject: [Zope] MySQL Select Statements
>
>
> Hi Everyone,
> Just need someone to put me straight here. When I use Select
> statements in
> an SQL Method I cannot simply :
>
> Select Column1, Column2 etc
> from TableA.
>
> Instead I must use the AS statement ie
>
> Select Column1 AS Column1, Column2 AS Column2
> from TableA.
>
> Is this just an oddity with the MySQLDA/Db adapters or am I overlooking
> something blatantly obvious here? All the examples on zope.org don't have
> the extra "AS Column1" additions on them and I was wondering if this is a
> Zope/mySQL-unique thing.
>
> I'm using Zope (2.1.6) with MySQL (3.22.32) with Zope MySQL Database
> Adapter (ZMySQLDA) 2.0.0a1 and
> MySQLdb module release: 0.2.2 .
>
> Could someone please let me know as I don't want to have to type
> the extra
> bits on all my SQL statements from here on in if I don't need to
> (I am the
> world's worst and laziest typist). If it is the case that it's a
> necessary
> evil, then I want to put a HowTo or Tip up on zope.org because it
> took me a
> while to figure out what I was doing wrong, and if I can save
> someone else
> that same wasted time then I would like to. However I wanted to get my
> facts straight (via all you experts) first.
>
> Thanks for any help...
>
>   - Michael
> ~~~
> Michael Blewett
> Computer Support Mgr - Biological Sciences
> Monash University (Clayton Campus)
> Victoria Australia 3168
>
> " Can I trade this job for what's behind door #2? "
>
>
> ___
> 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] 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///manage_main, the
> dropdown list for adding Product looks like this:
> 
>   http://localhost///"
> METHOD="GET">
>ONCHANGE="location.href='http://localhost/testhier/blup/'+this.opt
> ions[this.selectedIndex].value">
> Available Objects
>   DTML Document
>   DTML Method
>   Mail
> Host
>   TinyTable
>   User
> Folder
>   Z MySQL Database
> Connection
> 
>   
>   
> 
> 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 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-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-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] 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] (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 )




RE: [Zope] Re: Zope 2.1.5/6/7 upgrading issues

2000-06-16 Thread Ron Bickers

Sounds good to me.

I started working with 2.2b1 because of these issues and everything I'm
using works okay except that the ZSQLMethods I have in one of my ZClasses
could not access properties from the properties sheet.  It keeps asking for
authentication and without it comes back with unauthorized...not allowed to
access 'db_name' (one of the string properties).  Is that addressed/fixed in
2.2.b2 or is there some permissions change in the 2.2 series that is causing
it?

I'm excited about the changes in 2.2, but until I better understand how the
new permissions work, I don't want to upgrade any production servers.

_______

Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brian
> Lloyd
> Sent: Friday, June 16, 2000 10:51 AM
> To: 'Stephen Cimarelli'; 'Gregor Hoffleit'; 'Graham Chiu'; 'Ron
> Bickers'; 'Adam Karpierz'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
> Subject: [Zope] Re: Zope 2.1.5/6/7 upgrading issues
>
>
> Hi guys,
>
> First of all, I'd like to apologize for the pain factor here -
> there has been some CM process changes around here and the
> 2.1.x branch is suffering as a result :(
>
> I have a proposal, however, that I hope will make this much
> easier. How about if we:
>
>   o release a "Product" today that, if you install it and
> restart your Zope (no matter what version), patches the
> hole at runtime (in memory change only).
>
>   o retract the 2.1.7 release in favor of getting 2.2 beta 2
> out on Monday, which doesn't have the cruft problem of
> the 2.1.x branch and contains all fixes to date (and
> which will fix SQLMethod problems and support the SiteAccess
> release that Evan is making today).
>
>
> I can have the new "hotfix" product ready by 12:00pm EST today.


___
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 )




  1   2   >