[Zope] [voipiri: Re: [Zope] Opensource DBMS for WIN?]

2001-01-23 Thread Riku Voipio

too fast typing - ment this to the list...
-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764




On Tue, Jan 23, 2001 at 10:35:11AM +0100, Paul Zwarts wrote:
 Greetings,
 
 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...

Uh, why bother?

postgres / mysql are desgned to be run under unixen, running them on
Win will always be a hack. 

It will probably be easier to install the Linux OS and Posgres on 
the win2k machine than to install posgres/mysql on win2k. 

all respectable distributions carry postgres _as part_ of 
the distrubuition.


-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764





Re: [Zope] Why Not Zope? 'Cos I like to bitch! ;-)

2000-12-01 Thread Riku Voipio

On Thu, Nov 30, 2000 at 02:18:57PM -0800, Andy McKay wrote:
 
 For most small applications DTML can suffice, but when it gets large you
 should separate your code the way its intended, DTML is for simple logic and
 presentation ONLY. Whilst PythonMethods are cool, I would naturally stray
 away from them for the above reasons for anything longer than about 5 lines.

But once you have done 5 lines of dtml, and yoo need to add sixth, 
what is more probable: 

1. Rewrite as a pyhtonmethod
2. Just add the sixth line

I have the creeping feeling, that dtml is the worst thing since csh. 

Fortunatly, even DC seems to have realized it.

  Zope's built in FTP server is one of it's huge stengths, IMO. He hasn't
  realised this and so bitches about it. You can always turn it off you
  know! Likewise the HTTP server, run Zope as a CGI if you must! :P
 
 "Apache already exists and is highly flexible and configurable" of course it
 is, use it if you want, grrr. TMTOWTODI.

But cgi is slow. and using mod_proxy is not beatiful and adds latency. 
Besides, the zserver on 2.1.6 seems to have bugs that sometimes let 
the page only 90% through. I've really wondered, why all the trouble 
of using a own HTTP server, Apache is a great HTTP server and most 
users run it anyway. which leads to the natural question:

Why isn't there a mod_zope module?




-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764


___
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] debugging zope?

2000-10-19 Thread Riku Voipio

Hi,

I'm running zope 2.1.6 on Linux with DCoracle on "production", 
and about once in week zope runs out of control, like it would 
be in a infinite loop. Stops responding to zserver requests.

Any hints on how to find out what's going on? 

-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764


___
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 in Windows is faster than Linux ???

2000-10-11 Thread Riku Voipio

On Mon, Oct 09, 2000 at 01:39:41PM +0100, Toby Dickenson wrote:
 We have been stress testing our Zope application on NT and Linux. Our
 conclusion is that OS is not a factor in Zope performance.

 Its all application-specific, and theres nothing I can release at the
 moment. Essentially the timings were all within a 15% band after a
 little tweaking.

 Personally I don't think this result is at all suprising: In a loaded
 Zope system the processor spends all its time executing the python VM,
 not OS code.

...which takes us to the obvious question - howto make python faster?
Has anyone tried diffrent compiler flags for python etc. to make it 
faster?

-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764


___
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] [voipiri: Re: [Zope] DCOracle Connection with Oracle 8.0.5]

2000-09-14 Thread Riku Voipio

On Wed, Sep 13, 2000 at 10:20:15AM -0300, Celio C. Guimaraes wrote:
 1) In order to connect successfully  I had to drop the @sid parameter:
 dbc=DCOracle.Connect('scott/tiger@ora8')
 returns with error:  ORA-12154 : TNS: could not resolve service name

I think this is default oracle behaviour. for local databases you 
set the $ORACLE_SID connect with username/passwd. For remeote databases
you set $TWO_TASK or connect with username/passwd@SID . 

You also need a correctly setup /etc/tnsnames.ora

-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764

___
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] External Methods, reloading and Versions

2000-09-14 Thread Riku Voipio

On Thu, Sep 14, 2000 at 11:52:59AM +0100, Chris Withers wrote:
 Riku Voipio wrote:
  How do you reolad an external method that has changed?

  (versions are rather cool, now I can develop on the production
  server safely).

 Versions and external methods interact very badly :-(
 Don't try editing and external method in a version.

Blah. External mehtods seem to be astonishingly external.

-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764


___
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] Important Security Concerns

2000-09-12 Thread Riku Voipio

On Tue, Sep 12, 2000 at 08:31:52AM -0400, Coleman, Bryan wrote:
 That would cause another whole set of problems, unless apache is inherity
 more secure than Medusa. I was really wondering what the risks are
 associated with those two options.

I think Zope behind apache is more secure than zope behind medusa, 
bacause of:

1. Finer grained control on access. 

One can add lines like the following:

RewriteCond %{REMOTE_ADDR} !^10\.0\.0\.(.*)
RewriteRule ^/Zope.*manage - [F]

Which would mean that only users from 10.0.0.* can 
access managment interfaces.

2. Wider usage of apache (a lot more security auditing) 

this is heavily IMHO.

   Option A: Poke a hole through our firewall on the primary http port or
  on
   port 8080 to allow Zope pages through and then require authentication on
  the
   first page.

   Option B: Set up a DMZ off the firewall to allow the same as the above.

I assume that you would firewall the DMZ as well. With a setup which 
allows maintainance to the ftp/ssh/whatever ports from your lan and 
only http traffic from elsewhere, this would be slightly more secure
than having the server on your lan. 

Is it worth depends on how much you trust on the potential users, and 
how much time you hcope with the extra maintainance load of the DMZ. 
Assuming you don't already have a DMZ...

If you have limited set of extranet users, you can tighten up by restricting 
access at firewall only from IP address ranges of your clients.

-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764






___
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 CVS on Windoze

2000-08-25 Thread Riku Voipio

On Thu, Aug 24, 2000 at 03:26:29PM +0200, Wolfgang Strobl wrote:
 Speaking about Linux - I just noticed that the upcoming Suse 
 distribution (V7) will contain Zope in the "professional edition", see

http://www.debian.org/Packages/stable/web/zope.html

The current Debian has it too. As well as the msqlda on some ohter 
comment products.

 It's a bit old, though: 2.1.6

That's what the current Debian release has too. Unstable already
has 2.2.0

-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764


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

2000-07-27 Thread Riku Voipio

On Wed, Jul 26, 2000 at 06:28:55PM -0400, Satheesh Babu wrote:
 Hi,
 
 If you are running Zope on
 1. Linux:
 You need to install Oracle client libraries to compile
  ZOracleDA. As far as I know, Oracle does not give
  any easy way to install only the clients. So, if you've
  enough disk space, install Oracle with the minimum
  DB options, and compile ZOracleDA. You DON'T
  NEED to run Oracle DB on your Zope machine, to
  have zope connect to your actual DB machine.

I think that 8.1.5i had an option to install client. stuff 
(beacuse that is what i did at first). However, you need to 
compile the ZOracleDA on a machine where the entire oracle is
installed, because some crucial haeder files only come with the 
full install.

Then, just remember to set up the tns listener on server and 
the tnsnames.ora on the client, but that stuff is out of this 
list's scope.

-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764


___
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] ZUBB/Ztree permission problem

2000-07-21 Thread Riku Voipio

Unless the ZDiscussion object has Anonymous/access information 
permission, nobody, including manager and owner, can't access the 
The Zdiscussion which has any content. 

running ZDiscussions-0.3.2 on Zope 2.1.6-5 Debian/Frozen. 

traceback follows:

Traceback (innermost last):
  File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module
  File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 179, in publish
  File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 165, in publish
  File /usr/lib/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply
(Object: index_html)
  File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 102, in call_object
(Object: index_html)
  File /usr/lib/zope/lib/python/OFS/DTMLMethod.py, line 150, in __call__
(Object: index_html)
  File /usr/lib/zope/lib/python/DocumentTemplate/DT_String.py, line 504, in __call__
(Object: index_html)
  File /usr/lib/zope/lib/python/TreeDisplay/TreeTag.py, line 154, in render
(Object: a tree tag)
  File /usr/lib/zope/lib/python/TreeDisplay/TreeTag.py, line 245, in tpRender
(Object: ElementWithAttributes)
  File /usr/lib/zope/lib/python/TreeDisplay/TreeTag.py, line 321, in tpRenderTABLE
(Object: ElementWithAttributes)
Unauthorized: [0, 1, 2, 3]


-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764


___
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] LONG insert 2000 chars fail

2000-07-06 Thread Riku Voipio

On Thu, Jul 06, 2000 at 08:48:43AM -0400, Satheesh Babu wrote:
 Hi,
 
 We use Oracle v 8.1.5 and 8.1.6 and there we can go upto
 5000 characters for string literals. Anyway, LONG is a
 deprecated datatype and we decided to use detail tables
 for text more than 4000 chars. Any given string will be
 split at 4000 chars and inserted as one or more records
 into detail table, as varchar2 fields. Varchar2 fields
 are easy to process also.

Yes, you are right, we are using 8.1.5 On Linux, and it swallows 
up to 4k. But having to split a string to get it in the database 
feels pretty stupid. 

 I think it is more of an Oracle OCI problem than OracleDA.

Yep, I tried to look at oci.c/oci.i sources and got shocked... 
Maybe overnight I'll gather some courage to see if it would 
be feasible to use 'bind variables' to push data in to the long 
columns. Or will it be easier to split text with a python 
external method.

-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764


___
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] mod_rewrite rule to close managment screens from outsiders

2000-06-27 Thread Riku Voipio

I'm trying to deny external access to zope maintainance from elsewhere
(just for  sure), with Zope behind apache. However, It 
just doesn't seem work... Sure It's more apache's problem, but I guess 
someone around there has a working solution?

#/IfModule
dule mod_rewrite.c
RewriteEngine on
RewriteCond %{HTTP:Authorization}  ^(.*)
RewriteRule ^/Zope(.*) /usr/lib/cgi-bin/Zope/$1 
[e=HTTP_CGI_AUTHORIZATION:%1,t=application/x-httpd-cgi,l]

RewriteCond %{REMOTE_ADDR} !^193\.143\.156\.(.*)
RewriteRule ^/Zope.*manage - [F]
#/IfModule

-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764


___
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] long columns on oracle

2000-06-14 Thread Riku Voipio

On Mon, Jun 12, 2000 at 05:22:04PM +0300, Riku Voipio wrote:
 Hi, 
 
 I'm running Oracle 8.1.5i / DCoracle 1.3/Zoracle 2.1.0/zope 2.1.6,
 On Debian/potato (2.2.16)  and whenever I try select a LONG column, I 
 get the following;
 
 Error, exceptions.IndexError: 1 

Sorry, I was running really an older version of DCoracle in the Zope
subdirectory while I had the newer in the python directory...

-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764


___
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] long columns on oracle

2000-06-12 Thread Riku Voipio

Hi, 

I'm running Oracle 8.1.5i / DCoracle 1.3/Zoracle 2.1.0/zope 2.1.6,
On Debian/potato (2.2.16)  and whenever I try select a LONG column, I 
get the following;

Error, exceptions.IndexError: 1 

SQL used:

select
 MSG_ID,
 USER_ID,
 HANDLER_ID,
 STATE,
 APP,
 TMODULE,
 VER,
 HEADER,
 VER_DONE,
 PATCH,
 TEXT,
 DATE_CREATED,
 DATE_CHANGED
from tmessage

Inserts work fine, and the select while be file, if I remove 
the 'TEXT' column, which is the LONG column.

-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764


___
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] escaping with dtml?

2000-06-07 Thread Riku Voipio

Hello, 
I'm trying to get some doubleqoutes to the final document,
but I've been unsuccesful so far:

dtml-let hack="\"app\" 
ONCHANGE=\'location.href=cookie?app=+this.options[this.selectedIndex].value\'"
/dtml-let

-- 
Riku Voipio
[EMAIL PROTECTED]
09-862 60764


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