Subject: Zope digest, Vol 1 #1453 - 25 msgs
From: [email-masked]
To: [email-masked]
Date: Sun, 10 Jun 2001 12:01:25 -0400
List-Id: Users of the Z Object Publishing Environment <zope.zope.org>

Send Zope mailing list submissions to
	[email-masked]

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.zope.org/mailman/listinfo/zope
or, via email, send a message with subject or body 'help' to
	[email-masked]

You can reach the person managing the list at
	[email-masked]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Zope digest..."

Today's Topics:

   1. RE: MySQLdb-0.9.0 and ZMySQLDA-2.0.7 nogo with 2.4a1? (Norman Khine)
   2. Washington State Zope users? (jimbo)
   3. Re: Zope docs (was Re: [Zope] I was wondfe) (Chris McDonough)
   4. Re: MySQLdb-0.9.0 and ZMySQLDA-2.0.7 nogo with 2.4a1? (Tony McDonald)
   5. anonymouse ftp access only ([email-masked])
   6. Re: MySQLdb-0.9.0 and ZMySQLDA-2.0.7 nogo with 2.4a1? (Frank Tegtmeyer)
   7. Re: Zope docs (was Re: [Zope] I was wondfe) (Edward Muller)
   8. Re: DTML abc? (Arjan de Knegt)
   9. tar.gz for ZStylesheet available (Frank Tegtmeyer)
  10. ZCatalog and VirtualHostMonster (tav)
  11. gadfly question (Robert Rottermann)
  12. Re: tar.gz for ZStylesheet available (Frank Tegtmeyer)
  13. RE: gadfly question (Norman Khine)
  14. Unique IDs (Daniel Fairs)
  15. Re: Unique IDs (Frank Tegtmeyer)
  16. Re: Unique IDs (Frank Tegtmeyer)
  17. Re: Zope docs (was Re: [Zope] I was wondfe) (Philippe Jadin)
  18. Bug tracking product (Gitte Wange)
  19. Re: [Zope-dev] Advanced REQUEST inside Python Class Problem (Oliver Bleutgen)
  20. Re: Unique IDs (Oliver Bleutgen)
  21. RE: Unique IDs (Daniel Fairs)
  22. RE: How to remove zope.pcgi from URL (in IIS)? (Max M)
  23. Re: Zope docs (was Re: [Zope] I was wondfe) (Oliver Bleutgen)
  24. Re: Sharing Database connections and/or methods between Zo pes? (Doug Hellmann)
  25. Re: transaction control from Zope to Postgresql? (SOLVED) (Reinoud van Leeuwen)

--__--__--

Message: 1
From: "Norman Khine" <[email-masked]>
To: "Tony McDonald" <[email-masked]>
Cc: "Zope" <[email-masked]>
Subject: RE: [Zope] MySQLdb-0.9.0 and ZMySQLDA-2.0.7 nogo with 2.4a1?
Date: Sat, 9 Jun 2001 17:21:29 +0100

Hello Tony,
I too have the same problem with 2.4.0a1, can you check if ZGadfly is
available in the Products Pull-down menu, and had raised the issue before,
but was told that it has not been a problem.

Regards

Norman

-----Original Message-----
From: [email-masked] [mailto:[email-masked]]On Behalf Of Tony
McDonald
Sent: 08 June 2001 16:31
To: Zope mailing list
Subject: Re: [Zope] MySQLdb-0.9.0 and ZMySQLDA-2.0.7 nogo with 2.4a1?

On 4/6/01 7:21 pm, "Andy Dustman" <[email-masked]> wrote:

> Go get 'em at http://sourceforge.net/projects/mysql-python

I've got a python2.1 installation with 2.4.0a1 Zope. I've installed
MySQLdb-0.9.0 and tested it alongside python2.1. This is under Solaris.

On startup the ZMySQLDA product shows up ok in the Products folder (ie no
broken icon), but there's no entry for ZMySQLDA connections in the popup
list.

Anyone know what I'm doing wrong here?

TIA
Tone.
--
Dr Tony McDonald,  Assistant Director, FMCC, http://www.fmcc.org.uk/
The Medical School, Newcastle University Tel: +44 191 243 6140
A Zope list for UK HE/FE  http://www.fmcc.org.uk/mailman/listinfo/zope

_______________________________________________
Zope maillist  -  [email-masked]
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 )

--__--__--

Message: 2
Date: Sat,  9 Jun 2001 12:27:37 -0700
From: "jimbo" <[email-masked]>
Reply-To: <[email-masked]>
To: <[email-masked]>
Subject: [Zope] Washington State Zope users?

Just wondering if there are any zope users in the area?

--__--__--

Message: 3
From: "Chris McDonough" <[email-masked]>
Subject: Re: Zope docs (was Re: [Zope] I was wondfe)
To: Milos Prudek <[email-masked]>,[email-masked]
Date: Sat, 09 Jun 2001 16:11:20 -0400

Hi Milos,

On Sat, 09 Jun 2001 15:10:11 +0200
 Milos Prudek <[email-masked]> wrote:
> > I think folks need to start becoming more specific when
> they say "Zope
> > isn't well documented".
> 
> Chris,
> 
> The following is a rant :-) 

I appreciate the warning, but IMHO we need fewer rants and
more energy spent doing creative things.  ;-)
 
Your message called for better CMF docs.  That's specific
enough for me.

- C

--__--__--

Message: 4
Date: Sat, 09 Jun 2001 22:30:43 +0100
Subject: Re: [Zope] MySQLdb-0.9.0 and ZMySQLDA-2.0.7 nogo with 2.4a1?
From: Tony McDonald <[email-masked]>
To: Norman Khine <[email-masked]>
CC: Zope <[email-masked]>

On 9/6/01 5:21 pm, "Norman Khine" <[email-masked]> wrote:

> Hello Tony,
> I too have the same problem with 2.4.0a1, can you check if ZGadfly is
> available in the Products Pull-down menu, and had raised the issue before,
> but was told that it has not been a problem.
> 
> Regards
> 
> Norman

Aha!, cheers for that Norman - it's another data point. Nope ZGadfly is
*not* in the pull down menu but *is* in the Products folder and is not a
broken icon.

The mechanics of what is displayed in the pulldown menu seems to be in
OFS/ObjectManager.py, seemingly in the function 'all_meta_types'. Thing is,
I'm lost from there on in.

Does that help anyone a bit more knowledgeable than I to track this down?

Tone.
-- 
Dr Tony McDonald,  Assistant Director, FMCC, http://www.fmcc.org.uk/
The Medical School, Newcastle University Tel: +44 191 243 6140
A Zope list for UK HE/FE  http://www.fmcc.org.uk/mailman/listinfo/zope

--__--__--

Message: 5
Date: Sat, 9 Jun 2001 16:20:29 -0600 (MDT)
From: <[email-masked]>
To: <[email-masked]>
Subject: [Zope] anonymouse ftp access only

I would like to setup the ftp server for zope so that it allows anonymous
access only. IE no user can login with ftp. I have been working with
M2Crypto and will be redirecting all http logins through https so ftp is
the only other security hole. I do want people to be able to batch
download some files from the site and they seem to prefer ftp.

Thanks

Designing the webpages of tomorrow http://webme-eng.com
Designing the MMORPGS of tomorrow http://worldforge.org

--__--__--

Message: 6
To: [email-masked]
Subject: Re: [Zope] MySQLdb-0.9.0 and ZMySQLDA-2.0.7 nogo with 2.4a1?
From: Frank Tegtmeyer <[email-masked]>
Date: 10 Jun 2001 00:20:57 +0200

Tony McDonald <[email-masked]> writes:

> On 4/6/01 7:21 pm, "Andy Dustman" <[email-masked]> wrote:
> I've got a python2.1 installation with 2.4.0a1 Zope. I've installed
> MySQLdb-0.9.0 and tested it alongside python2.1. This is under Solaris.

The same here on a Linux system.

> Anyone know what I'm doing wrong here?

Nothing possibly. Because the same was reported for Gadfly I assume a
problem in this Zope alpha version.

Regards, Frank

--__--__--

Message: 7
From: Edward Muller <[email-masked]>
Reply-To: [email-masked]
To: "Chris McDonough" <[email-masked]>,
 [email-masked]
Subject: Re: Zope docs (was Re: [Zope] I was wondfe)
Date: Sat, 9 Jun 2001 18:22:07 -0500

Since I started this thread, I'd just like to pipe up and give my 2 cents.

-Zope does now have some docs. Great!

-Zope needs more docs. I'm thinking something along the lines of Java's 
Documentation. I've written a few (never published) zope products and the 
only thing I can say is that I'm still not sure why somethings work, but 
because I saw the code in an example and it did what I wanted I used it. I 
think the core Zope classes and their methods needs to be put in some sort of 
document, indexed and possibly with examples.

On Saturday 09 June 2001 03:11, Chris McDonough wrote:
> Hi Milos,
>
> On Sat, 09 Jun 2001 15:10:11 +0200
>
>  Milos Prudek <[email-masked]> wrote:
> > > I think folks need to start becoming more specific when
> >
> > they say "Zope
> >
> > > isn't well documented".
> >
> > Chris,
> >
> > The following is a rant :-)
>
> I appreciate the warning, but IMHO we need fewer rants and
> more energy spent doing creative things.  ;-)
>
> Your message called for better CMF docs.  That's specific
> enough for me.
>
> - C
>
> _______________________________________________
> Zope maillist  -  [email-masked]
> 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 )

-- 
Edward Muller - [email-masked] - [email-masked]
There are two kinds of people, those who do the work and those who take the 
credit. Try to be in the first group; there is less competiton there.

--__--__--

Message: 8
Date: Sun, 10 Jun 2001 00:52:00 +0200
From: Arjan de Knegt <[email-masked]>
To: Oleg Broytmann <[email-masked]>
Cc: [email-masked]
Subject: Re: [Zope] DTML abc?

Oleg,

Thanks, that does the trick. Maybe I need a daily hour of DTML exercise to
keep my DTML skills from getting rusty :-)

Arjan.

------
Oleg Broytmann wrote:

> On Sat, 9 Jun 2001, Arjan de Knegt wrote:
> > I just have a tiny little DTML question that I can't seem to solve:
> > Some of my object ID's contain dot's, e.g. "NicePicture.jpg". Yes, I do
> > know  Zope doesn't need (or want?) the use of extension like "jpg" in
> > object ID's , but I have my reasons to do so.  Now I simply would like
> > to render this object with dtml-var. Al DTML syntaxes I can think of
> > result in Zope errors, propably because Zope thinks the ".jpg" part is
> > an object method instead of part of the object ID?
>
>    <dtml-var "_['index.html']">
>    <dtml-var "_.getitem('index.html', 0)">
>    <dtml-var "_.getitem('index.html', 1)">
>
> Oleg.
> ----
>      Oleg Broytmann     http://www.zope.org/Members/phd/     [email-masked]
>            Programmers don't die, they just GOSUB without RETURN.

--__--__--

Message: 9
To: [email-masked]
From: Frank Tegtmeyer <[email-masked]>
Date: 10 Jun 2001 01:31:12 +0200
Subject: [Zope] tar.gz for ZStylesheet available

Hi all,

although I appreciate the work by haqa that resulted in ZSTyleSheets,
I always find it annoying to always spen half an hour to convert all
the filenames of this package to be usable on a Unix system.

haqa mentions a tar.gz file in the documentation but there is none to
find on zope.org. It would be preferrable to provide only a tar.gz -
Windows users would have no problem and Unix users too.

I changed all the lowercase filenames to the "right" ones
yesterday. Everyone who wants to save the time to do it again may get
the result at
http://fte.tegtmeyer.net/ZStyleSheet-4.1.0.tar.gz

I didn't test it yet, so there may still be wrong filenames.

Regards, Frank

--__--__--

Message: 10
Reply-To: "tav" <[email-masked]>
From: "tav" <[email-masked]>
To: <[email-masked]>
Date: Sun, 10 Jun 2001 09:06:22 +0100
Organization: esp worldwide ltd
Subject: [Zope] ZCatalog and VirtualHostMonster

i have been trying to use ZCatalog with VirtualHostMonster

according to
http://dev.zope.org/Wikis/DevSite/Projects/ZCatalogVirtualHostFix/UpgradeFAQ
everything should work right out of the box, but unfortunately, when objects
are indexed, getPhysicalPath() doesn't seem to getting used

e.g. i have site.foo.com and subsite.foo.com being served out of /site and
/site/sub using VirtualHostMonster

but, /site/sub/test_object is indexed as /sub/test_object, if i view it from
site.foo.com, and /test_object if i view it from subsite.foo.com

i am using Zope 2.3.2 and was under the impression that
ZCatalogVirtualHostFix had solved this particular problem

also, i tried to run manage_normalize_paths on my ZCatalogs, however, i get:

    0 paths normalized, 21 paths removed, and 0 unchanged

where 21 is the number of objects in the ZCatalog

--
best regards, tav
[email-masked]

--__--__--

Message: 11
From: "Robert Rottermann" <[email-masked]>
To: <[email-masked]>
Date: Sun, 10 Jun 2001 10:29:55 +0200
Organization: redCOR
Subject: [Zope] gadfly question

Hello there this fine sunday morning,
here in Switzerland its pissing rain you would not dare to go outside
without scuba gear.
So I fiddle with gadfly.

Which brings me to my question:

Is there a way to access gadfly without the user interface. I would like to
create and fill tables from an external script.

Thanks
Robert

--__--__--

Message: 12
To: [email-masked]
Subject: Re: [Zope] tar.gz for ZStylesheet available
From: Frank Tegtmeyer <[email-masked]>
Date: 10 Jun 2001 12:42:40 +0200

> yesterday. Everyone who wants to save the time to do it again may get
> the result at
> http://fte.tegtmeyer.net/ZStyleSheet-4.1.0.tar.gz
> 
> I didn't test it yet, so there may still be wrong filenames.

Now there are also the fileformats changed from DOS to Unix and the
permissions set. I missed that this night - sorry to the one who did
already download the file today.

Regards, Frank

--__--__--

Message: 13
From: "Norman Khine" <[email-masked]>
To: "Zope" <[email-masked]>,
	"Robert Rottermann" <[email-masked]>
Subject: RE: [Zope] gadfly question
Date: Sun, 10 Jun 2001 12:13:28 +0100

Don't worry in the UK is also pissing down.

Try searching at yahoo for gadfly database and try this link
http://www.chordate.com/kwParsing/gadfly.html

Regards

Norman

-----Original Message-----
From: [email-masked] [mailto:[email-masked]]On Behalf Of
Robert Rottermann
Sent: 10 June 2001 09:30
To: [email-masked]
Subject: [Zope] gadfly question

Hello there this fine sunday morning,
here in Switzerland its pissing rain you would not dare to go outside
without scuba gear.
So I fiddle with gadfly.

Which brings me to my question:

Is there a way to access gadfly without the user interface. I would like to
create and fill tables from an external script.

Thanks
Robert

_______________________________________________
Zope maillist  -  [email-masked]
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 )

--__--__--

Message: 14
From: "Daniel Fairs" <[email-masked]>
To: <[email-masked]>
Date: Sun, 10 Jun 2001 12:18:13 +0100
Subject: [Zope] Unique IDs

Hi,

What's the best way to generate a secure unique ID in Zope? I've tried
generating a random integer then md5'ing it, but trying to do an md5.new()
causes Zope to prompt for authentication. I'm running this as a user who's
an out-of-the-box Manager - what other permission is needed?

Or is there a better way of doing it?

Cheers,
Dan

_________________________________________________________________
Daniel Fairs | [email-masked] | www.spiderplant.net

--__--__--

Message: 15
To: [email-masked]
Subject: Re: [Zope] Unique IDs
From: Frank Tegtmeyer <[email-masked]>
Date: 10 Jun 2001 13:57:07 +0200

"Daniel Fairs" <[email-masked]> writes:

> What's the best way to generate a secure unique ID in Zope? I've tried
> generating a random integer then md5'ing it, but trying to do an md5.new()

I am using an external Python method for that:

# Token.py
# generate a token for user accounts
# the token is built from a secret key and the users
# first and last name and his email address
# 2001-04-14  Frank Tegtmeyer

import sha, binascii

def GetToken(initstring):
        s=sha.new()
        s.update("put your secret string here")
        s.update(initstring)
        return binascii.b2a_base64(s.digest())[:16]

if __name__=='__main__':
        print GetToken('abcdefg')

Regards, Frank

--__--__--

Message: 16
To: [email-masked]
Subject: Re: [Zope] Unique IDs
From: Frank Tegtmeyer <[email-masked]>
Date: 10 Jun 2001 13:59:39 +0200

> Or is there a better way of doing it?

One additional: using a hash algorithm does produce unique values in
many cases but doesn't guarantee them. If uniqueness is an absolute
requirement you have to check if a key already exists and generate
another one in this case (using a different secret f.e.).

Regards, Frank

--__--__--

Message: 17
From: "Philippe Jadin" <[email-masked]>
To: <[email-masked]>
Subject: Re: Zope docs (was Re: [Zope] I was wondfe)
Date: Sun, 10 Jun 2001 14:17:45 +0200

> > > I think folks need to start becoming more specific when
> > they say "Zope
> > > isn't well documented".

Let me add my own piece...

imho zope is quite well documented. I mean, if you need to find a function
name and it's use, you'll allways find it in a few minutes. If you need a
dtml reference, you'll find it. If you need to learn python, well, buy a
book / see the online site.
Even the zope api is not poorly documented. (just tried docfinder of
Dieter - it's a great tool)

The feeling of people when they say zope is not well documented is probably
not because there is lack of "traditional" documentation.

What is really needed is implementations examples of canonical problems.

imho the most usefull parts of the zope book is the simple guestbook, the
file librairy, etc...

The same will go for the next chapters of dieter's book (current
implementation of a complex website)

All we (newbies) need is opensourced implementations of sites (an automated
faq, an e-commerce site, a news page, a thumbnail gallery, a guestbook, a
forum, etc...) I know those exists as products, but when you are able to
write products, you don't need this intermediate level of knowledge. and if
the product doesn't suit your needs, it's hard to customize it.

The "see source" feature of some zope sites is a great start. It could be
even better if they allowed you to donwload their sources... (maybe some
allow this?)

In one word : no real work needed from DC (beside some finer classification
of things), most intermediate docs could come from sources of existing
implementations. Experienced zope webmasters, I (an probably some other
newbie) need your knowledge!

And I know this is the role of how to's. They are a great source of help by
the way. 

All is fine then ? Almost ;-)

My 0.02

Philippe

--__--__--

Message: 18
From: Gitte Wange <[email-masked]>
To: [email-masked]
Date: Sun, 10 Jun 2001 14:30:34 +0200
Organization: MMManager.org
Subject: [Zope] Bug tracking product

Hello,

I am looking for a bug tracking product for Zope that also can contain 
feature requests. Everybody should be able to enter bugs and/or feature 
requests.

Does suck a product exists ?

Regards,
-- 
************************
Gitte Wange Jensen

System Squid Developer
MMManager Aps
+45 29 72 79 72

[email-masked]
************************

--__--__--

Message: 19
Date: Sun, 10 Jun 2001 16:02:53 +0200
From: Oliver Bleutgen <[email-masked]>
Reply-To: Oliver Bleutgen <[email-masked]>
To: [email-masked]
Subject: [Zope] Re: [Zope-dev] Advanced REQUEST inside Python Class Problem

> Hello everyone,

> I try to access the REQUEST variable in a Python class, but in certain
> cases this gives me a real headache.

> If I call my object with <dtml-var ObjectInstance>, then I can refer to
> the
> request variable in my Python code with self.REQUEST
> But, if I try: <dtml-var "ObjectInstance">, then I cannot use
> self.REQUEST,
> since the namespace is somehow not passed. BTW, the same seems to be true
> with properties inside a parent object. For some reason, if I call
> __getattr__, the entire "global namespace" (REQUEST and Aquisition) does
> not work correctly anymore.

> Has anyone a clue for me?

Hi Stephan,

<dtml-var ObjectInstance> does some zope-specific
argument passing. This magic isn't available
if you do
<dtml-var "ObjectInstance()"> (notice the brackets,
the way you did it would just cause to render
something like <ObjectInstance at #2424234> 
and wouldn't call the object).
If you do the above you have to explicitly pass
the arguments, i.e. REQUEST and _.
Take a look at dieter maurers excellent writings at
http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html
for instance for a concise explanation what kind
of magic happens with dtml-var.

cheers,
olivver

--__--__--

Message: 20
Date: Sun, 10 Jun 2001 16:12:52 +0200
From: Oliver Bleutgen <[email-masked]>
Reply-To: Oliver Bleutgen <[email-masked]>
To: [email-masked]
Subject: Re: [Zope] Unique IDs

>> Or is there a better way of doing it?

> One additional: using a hash algorithm does produce unique values in
> many cases but doesn't guarantee them. If uniqueness is an absolute
> requirement you have to check if a key already exists and generate
> another one in this case (using a different secret f.e.).

Hm,
out of interest, is there a way to be sure to get
atomicity for the above algorithm?
Otherwise there is always a small timespan in
which an object with the same name could have
been created - after the above check, but before
you create it.

Wouldn't it be simpler (in typical zope cases)
to just try to create the objects in the same 
folder and just wrap the id generation 
and object creation in a try/except clause?

And additionally  - instead of using hashes - 
just to use a timestamp?

cheers,
oliver

--__--__--

Message: 21
From: "Daniel Fairs" <[email-masked]>
To: "Oliver Bleutgen" <[email-masked]>,
	<[email-masked]>
Subject: RE: [Zope] Unique IDs
Date: Sun, 10 Jun 2001 15:08:00 +0100

>
> And additionally  - instead of using hashes -
> just to use a timestamp?

The key thing I need is unpredictability - hence my originally wanting to
use md5 as the last step in the generation. The 'usual' way to do this is to
seed the random number generator with the current time, pull a number out of
that and then do an md5 on it. I've got a number of options now, I'll look
at them

However, this doesn't answer the first part of my original question - why is
Zope asking me for further credentials when I try to use the md5 module? I'm
guessing md5 is in the security sin bin along with re and other stuff... but
why md5?

Curious...

Cheers,
Dan

_________________________________________________________________
Daniel Fairs | [email-masked] | www.spiderplant.net

--__--__--

Message: 22
From: "Max M" <[email-masked]>
To: <[email-masked]>,
	<[email-masked]>
Subject: RE: [Zope] How to remove zope.pcgi from URL (in IIS)?
Date: Sun, 10 Jun 2001 16:43:56 +0200

> From: [email-masked] [mailto:[email-masked]]On Behalf Of
> Satheesh Babu

> We've a big static site served by IIS and some ASP. For the moment, I must
> use the same server machine for Zope too. And most corporate
> firewalls block
> ports other than 80. That is why I'm trying to front end Zope with IIS.

I have had the exact same problem with Zope/IIS, and fond no solution. I got
the customer to use Apache instead of IIS so that was an easy way out.

Aparantly IIS is not made for easy collaboration with other servers :-).

regards Max M

Max M. W. Rasmussen,    Denmark.   New Media Director
private: [email-masked] work: [email-masked]
-----------------------------------------------------
Shipping software is an unnatural act

--__--__--

Message: 23
Date: Sun, 10 Jun 2001 17:06:14 +0200
From: Oliver Bleutgen <[email-masked]>
Reply-To: Oliver Bleutgen <[email-masked]>
To: [email-masked]
Subject: Re: Zope docs (was Re: [Zope] I was wondfe)

>> > > I think folks need to start becoming more specific when
>> > they say "Zope
>> > > isn't well documented".

> Let me add my own piece...

> imho zope is quite well documented. I mean, if you need to find a function
> name and it's use, you'll allways find it in a few minutes. If you need a
> dtml reference, you'll find it. If you need to learn python, well, buy a
> book / see the online site.
> Even the zope api is not poorly documented. (just tried docfinder of
> Dieter - it's a great tool)

> The feeling of people when they say zope is not well documented is
> probably
> not because there is lack of "traditional" documentation.

> What is really needed is implementations examples of canonical problems.

I think there are many examples already there, it's just sometimes hard
to find them (and to be sure these examples are "done right").

Perhaps we need something like the open directory project (dmoz.org)
for some elements of zope documentation. OTOH, perhaps we already
have an effort like this with the ZDP. Only - my impression is
it doesn't seem to work very well, perhaps it's too ambitious.

One thing which I have missed often lately was a more fine grained
categorization of the howtos on zope.org similar to 
that for the products. I just joined zope.org so I'm not clear about whats
technically possible with such an account, but if there's
need I would look into starting some smallish project that
makes it possible for the community to do that on ourselves.

But I admit, I think such functionality would better
fit as a core component of zope.org, but that would mean
work for DC. Also the possibility to comment/rate on
products and howtows would be nice, as would be 
a fulltext search on all howtos.

cheers,
oliver

--__--__--

Message: 24
From: Doug Hellmann <[email-masked]>
To: "Schmidt, Allen J." <[email-masked]>,
 [email-masked]
Subject: Re: [Zope] Sharing Database connections and/or methods between Zo pes?
Date: Sun, 10 Jun 2001 11:48:59 -0400

Allen,

If you're still trying to share that database among multiple Zope servers, 
you should check out the XMLRPCProxy product (available on Zope.org at 
http://www.zope.org/Members/dshaw/XMLRPCProxy).  It hooks two Zope servers 
together in a way that lets you call methods of an object that lives on a 
remote server as though the object was local.

You could set up one server to host the database, and share it by passing 
your calls through the proxy.

Doug

On Tuesday 05 June 2001 13:14, Schmidt, Allen J. wrote:
> Well, with my limited Python, that is easier said than done. Something to
> shoot for though.
>
> Thanks Andy!!!
>
> Allen
>
> -----Original Message-----
> From: Andy McKay [mailto:[email-masked]]
> Sent: Tuesday, June 05, 2001 1:19 PM
> To: Schmidt, Allen J.; [email-masked]
> Subject: Re: [Zope] Sharing Database connections and/or methods between
> Zopes?
>
>
> Here's how I would do it: Write a python script that calls your SQL and
> transfer the results into a list of dicts and returns that. You can then
> call the python script through xml-rpc and can hence parse the results.
>
> Cheers.
> --
>   Andy McKay.
>
>
> ----- Original Message -----
> From: "Schmidt, Allen J." <[email-masked]>
> To: "'Andy McKay'" <[email-masked]>; "Schmidt, Allen J."
> <[email-masked]>; <[email-masked]>
> Sent: Tuesday, June 05, 2001 10:05 AM
> Subject: RE: [Zope] Sharing Database connections and/or methods between
> Zopes?
>
> > Don't even care about slow at this point! Just the functionality....
> >
> > So I can assume then that remote access of ZSQL methods is not possible??
> >
> >
> > Seems like ZEO is the answer for everything! <8^)
> >
> > If anyone can think of a reason why this would not work, please drop a
>
> note.
>
> > If this is considered OT then jsut email me directly.
> >
> > -----Original Message-----
> > From: Andy McKay [mailto:[email-masked]]
> > Sent: Tuesday, June 05, 2001 1:09 PM
> > To: Schmidt, Allen J.; [email-masked]
> > Subject: Re: [Zope] Sharing Database connections and/or methods between
> > Zopes?
> >
> >
> > Ah well thats the point of a database of course, is you can share it. You
> > could concont some other solution with other stuff but you might find it
> > slow.
> >
> > This sound like a perfect job for ZEO.
> >
> > Cheers.
> > --
> >   Andy McKay.
>
> _______________________________________________
> Zope maillist  -  [email-masked]
> 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-masked]
> 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 )

--__--__--

Message: 25
From: [email-masked] (Reinoud van Leeuwen)
To: <[email-masked]>
Subject: Re: [Zope] transaction control from Zope to Postgresql? (SOLVED)
Date: Sun, 10 Jun 2001 15:58:53 GMT
Organization: Not organized in any way
Reply-To: [email-masked]

On Fri, 8 Jun 2001 13:40:02 +0200 (CEST), I wrote:

>Hello world,
>
>I am in need for a way to explicitely contral transaction behaviour for =
a=20
>group of inserts in a postgresql database. The DTML script I use first=20
>inserts a header record and after that some detail records. The =
postgresql=20
>function that does the inserts might return an errorstring. So I tried =
the=20
>following code (simplified for readability)

Well, I found an amswer with the help of some people on irc channel
#zope (thanx Vladdrac!). Although I did not manage to get the
transaction control the way I originally planned it, I have figured
out why it did not work.
Zope rolls back the transaction automatically only when it thinks the
request went wrong. Because I had implemented a <dtml-except> clause,
Zope did not think something went really wrong.=20
I have changed the <dtml-raise> to=20

<dtml-raise type=3DRedirect><dtml-var
"error_html.absolute_url()"></dtml-raise>

(error_html is a DTML document that reports the error to the user).
Because of the redirection, Zope thinks enough went worng and rolls
back all the executed SQL for me automagically. So my problem is
solved.

><dtml-try>
>  <dtml-call "sql_to_insert_head_record (some_parameters)">
>
>  <dtml-in "a_loop_over_detail_lines">
>    <dtml-if "check_detail_line">
>      <dtml-raise required_attribute_missing> errormessage </dtml-raise>
>    </dtml-if>
>
>    <dtml-call "sql_to_insert_detail_line">
>    <dtml-if "check_returncode">
>      <dtml-raise inserterror> error inserting! </dtml-raise>
>    </dtml-if>
>  </dtml-in>
>
><dtml-except>
> insert failed (error: <dtml-var error_value>)
><dtml-else>
>  object added to database
></dtml-try>
>
>What I would like to do is that all the SQL executed between dtml-try =
and=20
>dtml-except is rolled back when the exception is raised. I tried=20
>sending "begin" and "rollback" to the database, but that does not work=20
>because Zope sends some transaction control by itself.
>I tried getting get_transaction().begin() and get_transaction().abort() =
to=20
>work, but I cannot reach that function from dtml not python script.=20
>Anyone has some clues to spare?
>
>Have a nice weekend,
>Reinoud

--=20
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen       [email-masked]
http://www.xs4all.nl/~reinoud
__________________________________________________

--__--__--

_______________________________________________
Zope maillist  -  [email-masked]

End of Zope Digest