Re: [Zope] Opensource DBMS for WIN?

2001-01-23 Thread Petru Paler

On Tue, Jan 23, 2001 at 10:35:11AM +0100, Paul Zwarts wrote:
 Was wondering if there was an open source dbms to use with Zope on a
 Win2k machine...? I found references of using cygwin to run PGSQL (which
 we have on our unixbox) but would prefer something that doesnt run over
 an extender-shell...

I don't think I get what you mean by "extender shell". As far as I know
(never used it though), PostgreSQL works on win32. I'd ask on the postgres
lists first, though.

--
Petru Paler, mailto:[EMAIL PROTECTED]
http://www.ppetru.net - ICQ: 41817235

___
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.2.4 (final) released...

2000-11-27 Thread Petru Paler

On Mon, Nov 27, 2000 at 02:47:38PM -0500, Brian Lloyd wrote:
   Zope 2.2.4 has been released - you can download it from
   Zope.org:

Anything changed since the alpha release ?

--
Petru Paler, mailto:[EMAIL PROTECTED]
http://www.ppetru.net - ICQ: 41817235

___
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 for medium/large sites

2000-11-05 Thread Petru Paler

On Sun, Nov 05, 2000 at 02:13:55AM +, Tiago Antão wrote:
 bill.a If you have the hardware:
 bill.a  o a dedicated SQL server to hold member authentication data
 
   We've Oracle as the backend.

[...]

 bill.a That should be able to handle pretty much what you describe with ease.
 
  BTW, Do you know of any site with more than 10 registered users and
 lots of hits using zope?

mydomain.com (I work for them, did the programming). There are 139216 members
as I write this, and a couple hundred registrations each days. The system 
manages 315421 domains right now, but about 2000 new ones enter the database
each day. The site gets about 50 hits/day.

Everything works wery well (everything is on one computer, Oracle 8.1.6 and
Zope 2.2.2 behind a proxy rewrite rule for apache), EXCEPT for the Zope being
unstable. I think the culprit is the Oracle DA and I've sent a message to 
this mailing list, but noone seems to know what happens...

--
Petru Paler, mailto:[EMAIL PROTECTED]
http://www.ppetru.net - ICQ: 41817235

___
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] ZOracleDA causing instability

2000-11-02 Thread Petru Paler

Hi,

Just wondering if anyone else sees this: I run a moderately high-traffic (a
couple hundred thousand hits/day) with Zope and Oracle (most of the site is
forms interacting with the Oracle database, the rest being help/support files
for those forms and a couple images). Products used:

  - FSSession-0-4-2
  - GenericUserFolder 1-2-4
  - PythonMethod-0-1-7
  - SiteAccess-2-0-0b3
  - the latest ZOracleDA (the __version__ string in __init__.py says:
"$Revision: 1.4 $")

Zope 2.2.2 (source release) run with RewriteRule proxying behind apache 1.3.14.
Oracle 8.1.6 (aka 8i release 2) installed on the same machine.

The problem is that the whole thing is very unstable, and I suspect ZOracleDA
to be the culprit. Sometimes the whole Zope just hangs (actually so often, that
we are restarting it from cron each 15 minutes, but it's a bad solution since
all the GUF cookies are lost and customers are logged out), other times it
goes mad and eats lots of memory (I've seen it consuming 800 megs of memory,
and the whole unpacked Data.fs is 9 megs!), other times it gives a very strange
error: ZSQL methods raise exceptions whose contents is queries ran in other
threads!.

Does anyone have any ideea of what is happening, and how to fix it ?

--
Petru Paler, mailto:[EMAIL PROTECTED]
http://www.ppetru.net - ICQ: 41817235

___
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] status of SOAP for Zope?

2000-10-05 Thread Petru Paler

On Thu, Oct 05, 2000 at 01:25:44PM -0700, Michel Pelletier wrote:
   What is the status of SOAP on Zope, I need to know if I can use ROPE..
  
  Hi Brad -
  
  SOAP is still something we want to do, but it is on hold right
  now (we just don't have the resources at the moment). I've been
  hoping that someone might take the lead and start a project on
  dev.zope.org, but so far that hasn't happened :(
 
 Take a look at:
 
 http://classic.zope.org:8080/Collector/1360/view
 
 I remember glancing at it for a bit, it might be a good start to at
 least get it to the same level of support as xml-rpc.

Glad to see that people finally show some interest in that :)
That patch was the result of a long night, but I'm sure it can be gotten to
work properly (right now I think it has problems with exception handling).

--
Petru Paler, mailto:[EMAIL PROTECTED]
http://www.ppetru.net - ICQ: 41817235

___
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] 1000-record limit?

2000-09-26 Thread Petru Paler

On Tue, 26 Sep 2000, Christopher J. Kucera wrote:

 We're running a somewhat older release of Zope with ZOracleDA, and
 we've run up against a 1000-record limit when returning data for
 reports, etc.  I know that this is intended behavior (careful_range
 in DT_Util.py), but I'm wondering what the reasoning is, and if I
 should be even considering playing around with this (I'm assuming
 it was put in there for *some* reason . . . :)

Take a look at the "Advanced" tab of your SQL methods...

Petru



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




[Zope-dev] RFC: page contracts

2000-08-30 Thread Petru Paler

Hi eveyone.

While playing around with the development version of ACS (ArsDigita Community
System), I noticed a very nice feature they introduced, namely page contracts.

In ACS, this means that every tcl page starts with a call to ad_page_contract.
In the parameters passed, you specify:
   - general page documentation (what it does)
   - author(s)
   - creation date (not needed for Zope since we have bobobase_modification_time)
   - CVS ID (not quite applicable for Zope (yet?))
   - the expected input variables (from forms) along with their default values
   (where applicable) and types (having a couple of types like "integer" and "string"
   predefined and an easy-to-use plugin system to add custom types)
   - an optional validation block in which you can check the input data ranges
   and validity (you can also make validation rules depend on each other so if
   one fails, the rules which depend on it aren't tried)
   - an optional custom error messages section (to use when one of the required
   input variables is not there or does not match the format, or when a validation
   block fails). If you don't provide this some reasonable defaults are provided.

IMHO, such a feature would be very useful for Zope too. I find myself quite 
often doing input validation and error handling in DTML, which is (to say the
least) painful.

I would be interested to give a try at implementing this, but before starting
I wanted to hear community's opinion on:
   - whether this would be useful
   - how this should be aproached (the two possibilities I have in mind until
   now are either a separate manage tab for the page contract, and there a
   HTML-based interface for building it, either a dtml-contract tag which
   surrounds the page contract (written in python probably) and placed at the
   top of DTML documents/methods).

--
Petru Paler, mailto:[EMAIL PROTECTED]
http://www.ppetru.net - ICQ: 41817235

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




[Zope] SOAP (Re: [Zope] Oracle ZODB (Paul's talk in Paris))

2000-08-28 Thread Petru Paler

 ps. I've got to ask, Is there any prelim work being done on SOAP?

I did write once a patch that worked (i.e. you could call methods inside
Zope using SOAP and get the results back; the problems were with some type
marshalling and error handling). You can get it from
http://www.ppetru.net , though I haven't done anything on it in the last
month (lack of time and lack of people's interest...)

Petru



___
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] I cannot compile Zope...

2000-08-20 Thread Petru Paler

On Sun, Aug 20, 2000 at 05:58:58PM -0400, Paul Hewitt wrote:
 ...on RedHat 6.2 (Zoot).  I did not have problems
 compiling  Zope 2.0 thru 2.2 on earlier versions
 of RH (eg, 5.2, 6.1).  The problem seems to be
 with finding the include files, among them
 asm/socket.h.  I have played around with
 LD_LIBRARY_PATH etc but so far have not gotten
 anything to compile -- not Zope, not ZDiscussions,
 etc.  I have installed the binary version of Zope
 and this works fine, but that does not come with
 pcgi-wrapper compiled, for example.  Any
 suggestions?

Install the kernel-source RPM and run "make menuconfig" once in the /usr/src/linux
directory (just enter and exit it, no need to configure anything).

Or you can just install kernel-headers.

--
Petru Paler, mailto:[EMAIL PROTECTED]
http://www.ppetru.net - ICQ: 41817235

___
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] Virtual hosting on Linux: what's needed in BIND?

2000-06-25 Thread Petru Paler

On Sun, Jun 25, 2000 at 12:16:18AM -0700, Hung Jung Lu wrote:
 For Zope/SiteAccess to work with virtual hosting, something needs to be done 
 at the Linux BIND level. But I would like to know what exactly. Is it as 
 simple as adding a whole bunch of cname lines into the database file?

Yes.

 Also, is it possible to use wildcards in the database file for BIND? I mean, 
 if you have many virtual sites, would it be possible (and wise?) to make it 
 so all requests like *.mysite.com point to the Zope server? 

Yes, something like
*   IN  CNAME (or A, if you wish)   your IP

-Petru

___
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-dev] No feedback for SOAP patch ?

2000-06-23 Thread Petru Paler

On Fri, Jun 23, 2000 at 10:34:50PM -0400, Evan Simpson wrote:
 I've barely had a free second with functioning brain capacity this past
 week, but I'm interested.  More so now that Secret Labs has announced their
 SOAP client library at http://www.pythonware.com/products/soap  If you

   That made me to do it :^) (and it is partly guilty for why it isnt working
as good as it should...).

 haven't already popped your patch into the Collector, please do!

   I just did now

-Petru

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




Re: [Zope] Parse Text File (newbie q.)

2000-06-14 Thread Petru Paler

  I'm trying to display the contents of a text file in a DTML document.  It's 
  easy enough to display but all the line breaks are removed.  Is there an 
  easy way to bring in formatted text?
  
 
 Maybe you want something like:
 
 dtml-var " _.string.replace(text,'\n','BR')"

Even better, 
dtml-var text newline_to_br

-Petru


___
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-dev] Request for comments: Directory storage

2000-06-13 Thread Petru Paler

  It would be great if you could do it, but beware that you will be
  benchmarking a lot of overhead if you only plan to measure storage
  performance. Why not use ZODB directly ?
 
 If I talk HTTP, it measures things fully - Python's interpreter lock
 will mean a storage system written in python will benchmark better
 without having to compete with ZServer, and vice versa for storage
 systems with non-pythonic bits.

Yes, you are right.

  What filesystem does that use ?
 
 No idea :-) Something log based that is very fast and handles huge
 directories happily. It also appears that another member of this
 list has an EMC Symmetrix box to test on, which I believe is the next (and 
 highest) level up from a Netapp.

Mmmm... I heard that Network Appliance hired a couple of the SGI engineers
that designed XFS ?

 I've attached a prerelease alpha of zouch.py for giggles. Not even a
 command line yet, so you will need to edit some code at the bottom.
 The current settings generate about 360 directories and about 36000 files,
 and proceeds to make about 18 reads. This bloated by test ZODB
 to just over 200MB and took about 2.6 hours attacking my development Zope
 server from another host on my LAN.

Cool :)
Thanks for writing this, it will be very useful for benchmarking.

-Petru


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




Re: [Zope] Zope Beta Can't create folders as superuser!

2000-06-13 Thread Petru Paler

 I get the following error when I try to create a new folder as superuser.

   Due to the new security policy you can't create anything as superuser.
Add an user account first and use that.

-Petru


___
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] [offtopic] Job request

2000-06-11 Thread Petru Paler

  Hello all and excuse me for the off-topic,

   I'm looking for a Zope/Python related job. Since I'm so offtopic I'm
not pasting my resume here but refer you to
http://www.brainbench.com/transcript.jsp?pid=45513 and mention that I have
1.5 years experience with Zope. I'm learning very fast, as long as the
things I learn don't mean that my job is shifting to PHP, Perl or such
other nasties :)
   For more details, please contact me in private.

Thanks,

-Petru

PS: a Zope job board would be really useful (hint, hint :)


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




[Zope-dev] Request for comments: Directory storage

2000-06-07 Thread Petru Paler

  Hello all,

   You probably saw my yesterday post with the first alpha of
ReiserStorage. One of the questions that people tend to ask about it is
wheter they can use it without reiserfs.
   There are two problems with not using reiserfs:

1. ReiserStorage (now renamed to DirectoryStorage) stores each object in a
separate file and *all* the files in a single directory. This was done in
order to let the filesystem what it was meant to do: store and retrieve
files quickly. While reiserfs is *extremely* good at this (it uses a btree
to store directory entries), most other filesystems do linear searches
when finding a file so performance is very bad when you have many files in
a single directory.
   This problem can be solved by splitting files into multiple directories
when not using reiserfs. This would add a little overhead but it is
tolerable.

2. Waste of space. Typical block-allocation filesystems like ext2 and FAT
will waste alot of space in the usage pattern of DirectoryStorage.
ReiserFS packs small files together in the btree, so it solves the
problem, but I have no ideea how this could be fixed easyly on the other
fs's.

Comments ? Suggestions ?

PS: a new DirectoryStorage release will be done today, with bugfixes and
new features.

-Petru



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




[Zope-dev] ReiserStorage 0.01 alpha

2000-06-06 Thread Petru Paler

  Hello all,

   Attached you can find the code for a preliminary ZODB storage manager
which is designed to take adventage of the reiserfs filesystem
(http://devlinux.com/namesys). While it is usable on other filesystems
too, the performance will decrease as the number of objects in your
database increases.
   Comments:

1. This is as alpha as it can be. While it is usable to do some testing on
a spare Zope, you must be insane to even try to use this on a production
system.
2. A generic DirectoryStorage is comming soon, with the diference being
splitting files by directory (and, of course, being slower than the
reiserfs version).
3. As you can see in the source, I/O errors in critical points can corrupt
the storage.
4. It currently does not support versioning and undo. I'm working first on
getting it stable and fast, and then add these features.

Feedback is not only welcome, but wanted :)

-Petru


##
# 
# Zope Public License (ZPL) Version 1.0
# -
# 
# Copyright (c) Digital Creations.  All rights reserved.
# Copyright (c) 2000 Petru Paler ([EMAIL PROTECTED]) All rights reserved.
# 
# This license has been certified as Open Source(tm).
# 
# Redistribution and use in source and binary forms, with or without
# modification, are permitted provided that the following conditions are
# met:
# 
# 1. Redistributions in source code must retain the above copyright
#notice, this list of conditions, and the following disclaimer.
# 
# 2. Redistributions in binary form must reproduce the above copyright
#notice, this list of conditions, and the following disclaimer in
#the documentation and/or other materials provided with the
#distribution.
# 
# 3. Digital Creations requests that attribution be given to Zope
#in any manner possible. Zope includes a "Powered by Zope"
#button that is installed by default. While it is not a license
#violation to remove this button, it is requested that the
#attribution remain. A significant investment has been put
#into Zope, and this effort will continue if the Zope community
#continues to grow. This is one way to assure that growth.
# 
# 4. All advertising materials and documentation mentioning
#features derived from or use of this software must display
#the following acknowledgement:
# 
#  "This product includes software developed by Digital Creations
#  for use in the Z Object Publishing Environment
#  (http://www.zope.org/)."
# 
#In the event that the product being advertised includes an
#intact Zope distribution (with copyright and license included)
#then this clause is waived.
# 
# 5. Names associated with Zope or Digital Creations must not be used to
#endorse or promote products derived from this software without
#prior written permission from Digital Creations.
# 
# 6. Modified redistributions of any form whatsoever must retain
#the following acknowledgment:
# 
#  "This product includes software developed by Digital Creations
#  for use in the Z Object Publishing Environment
#  (http://www.zope.org/)."
# 
#Intact (re-)distributions of any official Zope release do not
#require an external acknowledgement.
# 
# 7. Modifications are encouraged but must be packaged separately as
#patches to official Zope releases.  Distributions that do not
#clearly separate the patches from the original work must be clearly
#labeled as unofficial distributions.  Modifications which do not
#carry the name Zope may be packaged in any form, as long as they
#conform to all of the clauses above.
# 
# 
# Disclaimer
# 
#   THIS SOFTWARE IS PROVIDED BY DIGITAL CREATIONS ``AS IS'' AND ANY
#   EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
#   IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
#   PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL DIGITAL CREATIONS OR ITS
#   CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
#   SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
#   LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
#   USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
#   ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
#   OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
#   OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
#   SUCH DAMAGE.
# 
# 
# This software consists of contributions made by Digital Creations and
# many individuals on behalf of Digital Creations.  Specific
# attributions are listed in the accompanying credits file.
# 
##


# To-do list:
# Critical:
#- Most I/O operations are not atom

Re: [Zope] Medusa vs. Apache

2000-05-24 Thread Petru Paler

 Hi All,
 I wonder if it is more convenient to stay with Apache or to move to
 Medusa for a best use of Zope?

   If you don't need any of the Apache features go with ZServer/Medusa.

-Petru


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