[Zope] RE: [Zope-CMF] mysqlUserFolder and CMF

Norman Khine khine@btinternet.com
Tue, 24 Apr 2001 16:28:16 +0100


You are too good I was just looking at these tools.

Can I confirm then that if I go down the route of mySQLUserFolder all I will
be concern with in ensuring it is complient with the CMF to be the
portal_registration part of the application lloking at the Portal Object
schema http://www.zope.org/Products/PTK/UML/PTKBase/Portal_Objects_Diag.html

and I suppose I'll need to look at the portal_membership
www.zope.org/Products/PTK/UML/PTKBase/portal_membership_Info.html objects
and merge it with the mysqlUserFolder

Well thatnks for your help, I have taken enough of your time. If this work I
will sit down and write a How-to ;^)

Regards

Norman

-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Shane
Hathaway
Sent: Tuesday, April 24, 2001 3:58 PM
To: Norman Khine
Cc: Zope Mailing List
Subject: [Zope] RE: [Zope-CMF] mysqlUserFolder and CMF


On Tue, 24 Apr 2001, Norman Khine wrote:

> Can you tell me though is there a particular reason as to the pro's &
con's
> of using either existing acl_users or any other flavours of Login
Managers.
>
> The reason why I am using the mysqlUserFolder is to integrated with the
> existing application and also because I did not want to clutter the ZODB
> with demographic user data. What I am getting at will I loose any
> performence if using one method or the other? I know you said you don't
have
> any experience of using mysqlUserFolder, but maybe from a perspective of
OO
> to RDBMS authentication.

Assuming mysqlUserFolder caches the authentication tokens (and it very
likely does), there should be only a minor performance drop when using an
RDBMS.  The ZODB has built-in caching that reduces the time it takes to
access authentication tokens to something on the order of nanoseconds :-)
while SQL authentication without caching can easily take up to 100 ms per
request, which would be noticeable.

> Also are there any methods which I can use to analyse the Log files from
the
> CMF if they are any? If so where can I find them. Or is there a way in
which
> I can query the Members folder, so that I can for example get total number
> of Members, their e-mails etc etc?

You could analyze the HTTP log, Z2.log.  To query the members folder use a
Python script like:

return len(container.Members.objectIds())

For email properties look at what the "roster" method does.

Shane


_______________________________________________
Zope maillist  -  Zope@zope.org
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 )