Re: [Zope] Openflow_ZPygresqlDA_products_broken_on_ZMI

2010-12-08 Thread Philip Kilner
Hi Smita,

On 08/12/2010 14:32, Smita Kamdar wrote:
 Can I install ZPygresqlDA without uninstalling ZPsycopgDA on the same
 m/c? Will it work properly? If it works properly I will install
 ZPygresqlDA-0.0.3 on dev Linux box  again import my source code  check
 whether it still appears broken?


I'm not aware of a reason that ZPygresqlDA and ZPsycopgDA should not 
co-exist, but I really don't know anything about ZPygresqlDA.

Having an extra product in your target environment should not cause 
problems when importing, but having products missing or at mismatched 
versions is very likely to cause problems importing.

 Please help me so that I can progress accordingly. If this doesn’t work
 I will install all the products on dev with the same version as the
 products on live as suggested by you.


This is the most sensible thing to do.

It would help us to help you if you could explain why you are reluctant 
to do this in the first place.


-- 

Regards,

PhilK


'work as if you lived in the early days of a better nation'
- alasdair gray
___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] problem installing Openflow product of zope on LINUX

2010-12-07 Thread Philip Kilner
Hi Smita,

On 07/12/2010 15:26, Smita Kamdar wrote:
 I have already installed the following products on my dev RedHat LINUX m/c –

 1) Zope-2.11.4

 2) Python-2.4.4

 3) Egenix-2.0.6

 4) Postgresql-7.4.13

 5) Psycopg-1.1.6

 6) OpenFlow-1.1.0

  on the live m/c also all these products are installed with a mismatch
 in versions of the products. Only in case of Database Adapter instead of
 ZPsycopgDA, ZPygresqlDA is installed on live.


Is there a reason that you are using ZPsycopgDA instead of ZPygresqlDA?

You should set the two environments up identically.

 But still when I import my project’s source code (i.e. .zexp file) from
 live to dev m/c all the code is imported successfully except it gives
 errors in Pygresql_Database_Connection  OpenFlow.

 For Pygresql_Database_Connection  Openflow it gives error as ‘This
 object from PygresqlDA product is broken’  ‘This object from OpenFlow
 product is broken’ respectively.


If you are importing a zexp that contains a ZPygresqlDA connection and 
the ZPygresqlDA product is not properly installed, you will indeed have 
broken objects - that would apply to ZPsycopgDA too, of course. If you 
want to use the imported objects, you must have the same products 
installed (at the same versions).

I don't know anything about ZPygresqlDA (or OpenFlow, for that matter), 
but I've had similar problems with ZPsycopgDA, so the following may be 
of some help: -

First, is your DA correctly installed?

Take a look at the Control Panel in the ZMI, and scroll down to the DA 
itself - does it have a broken product icon? If so, this may be 
because the associated python-level product (which would be Psycopg 
itself in the case of ZPsycopgDA) is not correctly installed.

N.B. You may have to install libpq-dev to compile it.

Second, is the DA actually usable?

Even if it appears installed properly in the Control Panel, it's worth 
testing by setting up a new connection to your database.

If you have a good setup, and the error is still thrown, you would still 
need to zap the old product's connection and replace it with the new 
product's equivalent, of course

Formally, you are on your own importing a zexp file into a target 
environment that differs from the source environment. If the above does 
not help, then I'd go back and make the necessary changes to make them 
match before spending a lot of time on this.

HTH


-- 

Regards,

PhilK


'work as if you lived in the early days of a better nation'
- alasdair gray
___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] anyone heard of Zamasing?

2008-04-18 Thread Philip Kilner

Hi Tim,

Tim Nash wrote:

 @Phil,
   I think you will find the product learning curve isn't that steep
at all. The famous z-shaped curve has more to do with the lack of
up-to-date documentation than anything else. Products are the way to
go. It is very much like wriitng 'Scripts Python'. I am going to put a
simple 'boring' product on the zope.org site (if they let me) which
will show how to use zope and extjs for anyone who is interested.
Looking forward to your proof of concept



Know it is the way to go - seems hard because I'm an RDBMS developer not 
a Python coder, has been a long time coming as the stuff I do in the ZMI 
really is mostly glue - not so complex that the classic management 
issues of ZMI have bitten me particularly hard.


Motivation for going Products route is need to share (and thus improve!) 
ideas, and need to package code up for use by others as we grow our 
business. Starting point is currently the Beta Boring product by 
Betabug (Thanks Sascha!)


Am taking a week's break from my consulting gig next week, so will be on 
with writing this up after today.



--

Regards,

PhilK


'work as if you lived in the early days of a better nation'
- alasdair gray
___
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] anyone heard of Zamasing?

2008-04-17 Thread Philip Kilner

Hi Tim,

Tim Nash wrote:

  It is great to see more posts about how well zope works for Web
2.0 projects. I have used extjs with zope and really like the
combination. I'd like to learn more about your jquery /plone setup and
how you make it work. Would it be a time consuming for you to create a
generic product that demonstrates your setup? It would be helpful to
have a common set of artifacts to discuss.



Am happy to share - it's all very simple stuff, the elements just work 
very elegantly together. I'm stringing other people's pearls here - the 
tools are great, putting them together is trivial.


However, having got the elements together, I'm now moving from a TTW 
approach (yes, I know - I'm a dinosaur!) to a Product approach, which is 
going to be a pretty steep learning curve for me. I need to document my 
starting point (which is effectively a common folder of scripts and 
templates, which the working pages access by acquisition), so I'll post 
a link to the list asking for feedback when I'm at that point.


N.B. This is going to take me at least a couple of weeks - I've got some 
paying work to finish off before I can move on to that.


I've got a proof of concept set of templates without Formulator or any 
RDBMS interaction that I did somewhere. It's only about three templates 
and a scrip. I'll post them when I find them, so that you can see how 
Taconite works with ZPTs, which is the most joyful part of it for me.



--

Regards,

PhilK


'work as if you lived in the early days of a better nation'
- alasdair gray
___
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] anyone heard of Zamasing?

2008-04-16 Thread Philip Kilner

Hi Tom,

Tom Von Lahndorff wrote:
Thats pretty awesome. It's zamazing to me that Zope 2 is not a de 
facto platform for Web 2.0 projects. I think it has some major 
benefits over Rails and maybe even Django but there seems to be no 
interest in it from that community. This is a great start.




I agree that it's a great platform for Web 2.0 projects - I'm a happy 
RDBMS developer, using Zope as an application server against Postgres dbs.


I find that Formulator, ZPTs and simple scripts on the server side and 
JQuery on the client side (specifically, the JQuery Taconite 
implementation [1] with XML ZPTs) work wonderfully together.


My interest is pretty narrow, in the sense that I'm all about RDBMSs, 
tabular data, and form-driven data entry - the less guff between me the 
and the RDBMS, the happier I am. However, if I don't have much to say, 
it's only because TTW Zope development using these tools is so easy. If 
there is any interest in discussing this stuff, I am up for that.


Having said all that, I'm happy enough with the ZMI as it is, so 
Zamasing is only of academic interest to me.


FWIW, all these techniques can also be made to work seamlessly inside 
Plone without doing any actual Plone development, which can be handy 
(you really only need to work with Plone's CSS to make it look 
consistent) - a server side mash-up which avoids all the cross-site 
scripting stuff, if you like.


[1] http://www.malsup.com/jquery/taconite/


--

Regards,

PhilK


'work as if you lived in the early days of a better nation'
- alasdair gray
___
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] extract page title

2007-04-24 Thread Philip Kilner
Hi Dean,

Dean Hale wrote:
 I'm trying to implement some web tracking code within a page template,
 however a little stuck.
 
 In the code below i'd like to append the page template - page title
 between the title tags dynamically rather than having to manually add
 to each page
 
 script language='JavaScript1.1' type='text/javascript' 
 noscript 
 img src=http://domain/xxx/xxx/s?websitename.PAGETITLE;  
 width=1 height=1 alt= 
 /noscript 
 /script
 
 do you have any advise please on how this could be done?
 

I've re-read this thread about four times now, and am having a lightbulb
moment.

Do you mean that you wish to dynamically form the tag: -

img
  src=http://domain/xxx/xxx/s?websitename.PAGETITLE;
  width=1
  height=1
  alt=

...such that PAGETITLE is the title of the current page?

If so, you need to bone up on tal:attributes, because you need to do
something like: -

img
  tal:attributes=src string:http://url?sitename.${here/title_or_id};
  src=http://domain/xxx/xxx/s?websitename.PAGETITLE;
  width=1
  height=1
  alt=

(Untested - but you get the idea)

HTH

-- 

Regards,

PhilK
___
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.6.4 + Win32 server

2007-02-21 Thread Philip Kilner

Hi David,

David VanKirk wrote:

I'm trying to migrate from a Linux server with Oracle to a win32
server with MS SQL Server.  I need to run it behind a webserver so
that I can connect through SSL.

I've tried IIS, Apache + PCGI, and Apache + FastCGI.

Has anyone been able to successfully run a Zope + win32 Web Server
successfully, that can help.



I run Zope behind Apache on Windows for several projects, some with MS 
SQL server. I'm very happy using Zope behind Apache on Windows, and have 
always been happy with the standard setup - never had to use PCGI or 
FastCGI. I also use Zope  Plone (in the form of Enfold Server) behind 
IIS in one case, but frankly the IIS aspect is not one I am 100% happy with.


What problems are you having?

Do you actually need PCGI/FastCGI?


--

Regards,

PhilK

'let's hear it for the vague blur'
___
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.6.4 + Win32 server

2007-02-21 Thread Philip Kilner

Hi David,

Please stay on the list - have added back in as CC.

David VanKirk wrote:

I was under the impression that you needed PCGI or FastCGI to get Zope
and Apache to communicate.

If you have another method, I'm open to try it.



No, not at all - in fact FastCGI at least is deprecated in current versions.


Just be informed that I'm using an older version of Zope (2.6.4) so if
there have been advancements that have been made since then with
communicating with Apache, I'm not able to use those.



Well, if you need Apache or IIS for SSL support, and you do not need to 
have SSL for the link between Apache and Zope, then there is nothing 
exotic at all involved. There are 3rd party solutions to use IIS (which 
cannot proxy on its own), but Apache is all you need.


The Zope book has the gist here: -

http://www.plope.com/Books/2_7Edition/VirtualHosting.stx

That's the latest version, but the version on the Zope site is for 2.6, 
and as you can see little has changed: -



http://www.zope.org/Documentation/Books/ZopeBook/2_6Edition/VirtualHosting.stx

The gist is: -

- Zope serves over HTTP.
- Apache can /proxy/ HTTP.
- The Zope Virtual Host Monster can rewrite the URLs generated by Zope 
to those required to pass the traffic through Apache.


You don't need to do anything on the Zope side other than ensure that 
the VHM is present - all the work is done by a rewrite rule in the 
Apache virtual hosts setup. The rewrite rules can be fiddly, and a great 
resource is the Rewrite Rule Witch: -


http://betabug.ch/zope/witch

I've mainly done this with Apache 2.0.x, but I have used the same basic 
setup under 1.3.x - I can't recall if there were any great differences, 
but I still have one running server with 1.3.x on it, so I should be 
able to help either way.


Can I suggest that you read up and have a play, and come back with any 
specific questions?


I found the rewrite rules very fiddly at first, but soon got used to 
them - you might need some patience to get to grips with that part, but 
that's the only bit that caused me any pain.


You don't say how you will be connecting Zope to MS SQL Server, but I 
can recommend the eGenix ODBC DA - it's not free, but it's not expensive 
either, and if you value your time at all it's cheaper and safer than 
doing it any other way...


HTH!


--

Regards,

PhilK

'let's hear it for the vague blur'
___
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.6.4 + Win32 server

2007-02-21 Thread Philip Kilner

Hi David,

Once again, please stay on the list - you need to hit reply to all.

David VanKirk wrote:

I appreciate your help and links, but I'm still not getting anything.



I did say it was fiddly!

I've go to get some urgent stuff out of the way, but I'll have some 
time	 later and will do a fully worked example.


In the meantime...


I enabled the proxy_module to use with the P option on the rewrite rule.

I've also added the following line to my VirtualHost section:

RewriteRule ^($|/.*)
http://127.0.0.1:8080/VirtualHostBase/https/%{SERVER_NAME}:443/VirtualHostRoot$1 


[L,P]

but when I go to http://127.0.0.1/manage I get a Forbidden error.



You can turn on some logging in Apache for rewrites.


I did setup the Virtual Host Monster in Zope, so if I were to
construct the URL like the ReWrite rule does manually, it starts to
load the page, but the frames all have 404 errors because it's
querying Apache on port 443 for the resources after Zope returns the
VHMed URL.



Is this an application that loads in a frame-set?


Maybe you could send me a copy of you httpd.conf/ssl.conf files so I
can see if there's something I'm missing?



I'll send an annotated version.


--

Regards,

PhilK

'let's hear it for the vague blur'
___
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] cpu load 99 percent a lot in plone evinironment

2007-02-15 Thread Philip Kilner
Hi Jamie,

Robert (Jamie) Munro wrote:
 Very useful. I've based my system on the first link because I didn't
 need to use POSTs, I just add ?foo=bar to the end of the URL and get it
 as normal. I added the ability to load a list of urls and element ids
 one after the other, then only activate the submit button at the bottom
 of the page when the whole form was loaded.  This means the top of the
 page loads quickly, and the rest loads section by section before people
 scroll down to it.
 
 I was thinking I would have to do something like this, and your links
 made it really easy.
 

I'm really pleased to hear it.

I came across AHAH as I was investigating AJAX. I'd been dreading using
AJAX, partly because it would mean a good deal of reworking of existing
applications, partly because of the learning curve. For my applications,
AHAH has turned out to be a better solution, and it's a bonus that it is
so easy to implement.


-- 

Regards,

PhilK

'let's hear it for the vague blur'
___
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] cpu load 99 percent a lot in plone evinironment

2007-02-13 Thread Philip Kilner
Hi Robert (Jamie?),

Robert (Jamie) Munro wrote:
 I've been having similar speed problems with a page that loops through a
 lot of SQL records. From what I can tell from the profiler, it is the
 security machinery that is at fault.
 

I'm doing the same sort of stuff, and routinely have the same sorts of
problems.

Two other things that I've done that help are: -

- Use the database to handle pagination, such that a single page of data
is returned - Plone/Zope batching can be very slow with huge data sets
(which to be fair it was never designed for). This is easy with
PostgreSQL and there is a work around for SQL Server.

- Instead of simply embedding my dataset (sometimes multiple datasets)
in the page, use AHAH to pull in a panel of data into the existing page
as a pure Zope transaction. This makes the UI a lot more fluid by
avoiding multiple redundant Plone page loads (e.g. during pagination, or
when doing drill-down type navigation).

AHAH does not seem to be much discussed here - it's worth reading: -

http://microformats.org/wiki/rest/ahah

http://www.gizax.it/ahahsection/

(I have based my work on the script in the second link)

Short version: uses AJAX-like technique of rewriting the HTML using
JavaScript, but returns pure HTML as opposed to XML or JSON, so trivial
to implement, and can degrade gracefully.

HTH


-- 

Regards,

PhilK

'let's hear it for the vague blur'
___
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 Alternative

2006-11-14 Thread Philip Kilner
Michael,

michael nt milne wrote:
 Is there a reason that the Plone list gets 3 times the level of postings
 that the Zope list gets? Yes. because it is a more mature and
 constructive support environment which actually helps promote the product.
 

Bollocks.

:-)


-- 

Regards,

PhilK

Say what you mean. Bear witness. Iterate. -John M. Ford
___
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 Log File Analysis

2006-10-19 Thread Philip Kilner
Hi,

Doyon, Jean-Francois wrote:
 Ah yes, indeed, I could do custom logging ... But then I'd have to worry 
 about the performance impact, the fact that because these logs would be 
 custom, I'd need custom analysis tools as well (unless I can make it 
 compatible somehow?) ... And so on ...
 
 We'd much rather stick with more standard solutions!
 

Have you seen: -

http://www.zope.org/Members/sbrauer/Webalizer-CT/README


-- 

Regards,

PhilK

Say what you mean. Bear witness. Iterate. —John M. Ford
___
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] Upgrading Zope

2006-10-18 Thread Philip Kilner
Hi,

Nightflyer wrote:
 I'd like to know if you think that such migration is feasible or if I'll
 encounter some problems.
 
 Do you think it is better to migrate to the latest version of the 2.x or 3.x
 branch?
 

From 2.1.x to the latest 2.x should be feasible.

Zope 3.x is a rewrite with no upgrade path, so that's not an option.

The best route is probably to try it on a development server and report
back with any issues.

Which RDBMS are you using your ZSQL Methods against?


-- 

Regards,

PhilK

Say what you mean. Bear witness. Iterate. —John M. Ford
___
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: R: [Zope] Upgrading Zope

2006-10-18 Thread Philip Kilner
Hi Andrew,

Nightflyer wrote:
 Which RDBMS are you using your ZSQL Methods against?
 
 MySQL 4.1.
 

From what you tell us, the database adapter is the only 3rd-party
dependency, and (although I don't use it myself) I understand mySQL is
well-supported, so you really need to try the upgrade on a development
machine to find out.

The Very Old Zope section in the link to ZopeWiki that Paul sent
should get you going...


-- 

Regards,

PhilK

Say what you mean. Bear witness. Iterate. —John M. Ford
___
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-DB] Zope and PostgreeSQL

2006-10-18 Thread Philip Kilner
Hi Javi,

javi lopez wrote:
 Hello i´m a spanish boy and i have a problem with zope-postgreeSQL. My
 zope version ( Windows 2000) is 2.9.4, postgreSQL 8.1.5, python 2.4 y
 i want to conect my database about psycopg 2.0.5.1 but it don´t work.
 Can you help me please?? I don´t know what the problem if versions or
 installation, so i don´t know to do. Can you give me a manual or
 versions to work correctly please?? I´m sorry my english and Thanks.
 

Please tell us a bit more than just that it does not work: -

- Do you see the Database Adapter as a Zope product?

- Can you create a Database Connection using the adapter?

- Can you access the database through the connection?

I'm using roughly the same setup as you, so I'm sure I can help - I just
need to know where to start!


-- 

Regards,

PhilK

Say what you mean. Bear witness. Iterate. —John M. Ford
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope] Zope 2 for Windows

2006-10-12 Thread Philip Kilner
Michael,

michael nt milne wrote:
 ignorant thinking. Most businesses use Windows and Zope will suffer
 unless it is embraced.
 

Volunteer to look after Windows if you want to fix this, but do not
insult those who have volunteered to look after other platforms.

Re-read what Andreas said (there is no current maintainer, we do not
have a volunteer, in essence) and what you said (ignorant thinking),
and see if you can spot your mistake - you are attacking Andreas for not
taking ownership of a platform he does /not/ use, in the context of his
work to look after a platform he /does/ use.

You really do need to stop shooting from the hip.


-- 

Regards,

PhilK

Say what you mean. Bear witness. Iterate. —John M. Ford
___
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 gets killed on startup

2006-10-05 Thread Philip Kilner
Hi Martijn,

Martijn Pieters wrote:
 Note that Plone 2.5 uses PlonePAS, which for some reason feels the
 need to replace the root-level acl_users folder when you create a
 Plone site.
 

I've just been bitten by this, and aren't at all happy.

Is there any reason I can't zap this and revert to a standard acl_users
folder?

I presume I'll need to do emergency user stuff to do this, but I'm
really not comfortable about having something unnecessarily complex in
my root - I might not feel this way if I could find more docs on
PlonePAS, but I can't, so I do!


-- 

Regards,

PhilK

Say what you mean. Bear witness. Iterate. —John M. Ford
___
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-DB] windows 2003 and sql server 2000

2006-09-30 Thread Philip Kilner
Hi,

shahrzad khorrami wrote:
  Is there any body to know that what is the problem with windows 2003 and 
 sql server 2000 ?I can't setup sql server2000 in windows 2003 !
 

Your question is off-topic for this list (they are both M$ products,
after all), but FYI SQL Server needs to have service pack(s) applied
(don't recall to which level) to work under Windows Server 2003.

You should be able to install it, but you should not start it until you
have service-packed it.


-- 

Regards,

PhilK

Say what you mean. Bear witness. Iterate. —John M. Ford
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope] zope hosting

2006-09-22 Thread Philip Kilner
Hi David,

David H wrote:
 My understanding is that Zettai is closing down.  Bummer cause I have
 been using them.
 
 Just looking for Zope Host recommendations
 

I've moved to HSR from Zettai, and am very happy.

I did the migration myself, as I wanted to do it step by step, but: -

http://highspeedrails.com/Weblog/archive/2006/09/06/free-migrations-for-zettai-customers

HTH

-- 

Regards,

PhilK

someone who experiments with the limitations of systems for
intellectual curiosity
___
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] Re: Zope behind iis

2006-08-24 Thread Philip Kilner
Hi Max,

Max M wrote:
 (Having seen a server wiped out via an IIS security hole, I just don't
 trust it on a public IP - long time ago, but once bitten, twice shy!)
 
 Hmmm ... then try making a mistake in your apache httpd.conf and turn on
 proxy by mistake.
 

Sure - but I'm much more worried about mistakes that others have made
that I could not possibly know about. Within limits, I can do something
to manage my own risk, and in any event it is my responsibility - but I
don't want to buy an unquantifiable risk off someone else.


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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] MailBoxer Question

2006-08-24 Thread Philip Kilner
Hi Beno,

beno wrote:
 Well, all I know is that Pound has a strong following of Zopistas that
 use it in combination with Zope (and without Apache) for high volume
 production work and seem to be happy.

Odd, then, that you have not had much input on the list about that. I
can't provide numbers, but the people I speak to/work with all use
Apache or Enfold.

 My domain is xfr.co.uk, and I have a mail host called smtp (because
 that is what it serves). So, the token yourMailHost refers to the mail
 host name and the yourDomain refers to the domain name, so to send me
 mail, you make an SMTP connection to smtp.xfr.co.uk.
   
 Ah! So *that's* what it meant! Thank you!
 

I'm glad I was able to help.

Since I have, can I ask you to consider the flak you have had on the
list and learn from it, please?

Specifically: -

- The shouting (all caps, multiple exclamation marks) is likely to
discourage people from helping you.

- Stephan's comments about different cultures is something you need to
take on board. I appreciate that your frustration combined with a
certain Germanic bluntness was a fatal combination, but these guys were
trying to help you and you roundly abused them.

I've hard a hard time learning to fly Zope - I've been using it for over
five years, but I learn more every day, and initially the learning curve
was very steep and I spent a lot of time as frustrated as you have been.
This list and it's relatives (DB, ZPT) got me through that, and I like
to try to help where I can in return - so I like to see the list
dynamics /work/.


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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 behind iis

2006-08-23 Thread Philip Kilner
Hi Chris,

Chris Withers wrote:
 Personally, I'd just put Apache in front of both Zope and IIS...
 

Me too - simpler, better documented, safer.

(Having seen a server wiped out via an IIS security hole, I just don't
trust it on a public IP - long time ago, but once bitten, twice shy!)


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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] MailBoxer Question

2006-08-23 Thread Philip Kilner
Hi,

beno wrote:
 Apache duplicates 95% of what Zope's server does, so if you're only
 using Zope, then it's un-elegant to use Apache.

Not so - Apache is a mature production web server, Zope is an
application server that serves over HTTP, but it's HTTP server is *not*
designed for production use.

 the rewrite rules you have to throw at Apache are awkward

You may think so, but they are the supported, documented solution: -

http://www.plope.com/Books/2_7Edition/VirtualHosting.stx

 Zope can't handle cgi
 scirpts

That is because Zope is an application server, not a web server.

 I find the tokens yourMailHost
 and yourDomain terribly unclear.
 

I simply don't understand that. It's off topic, but here goes: -

My domain is xfr.co.uk, and I have a mail host called smtp (because
that is what it serves). So, the token yourMailHost refers to the mail
host name and the yourDomain refers to the domain name, so to send me
mail, you make an SMTP connection to smtp.xfr.co.uk.

What's the problem?


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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] MailBoxer Question

2006-08-23 Thread Philip Kilner
Hi Chris,

Chris Withers wrote:
 numpty.
 

That is /such/ a great word!


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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] MailBoxer Question

2006-08-23 Thread Philip Kilner
Hi Chris,

Chris Withers wrote:
 numpty.

 That is /such/ a great word!
 
 My thanks to Tim Penhey for re-introducing me to it :-)
 

First said to me by a distressed Scots techie - Is that guy a numpty,
or what?, and I hear it in my head in a Scots accent to this day.

UrbanDictionary.com has great examples, and tells us that it is indeed
Scots...


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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] Logging client IPs to Z2.log

2006-08-17 Thread Philip Kilner
Hi Oliver,

Oliver Hookins wrote:
 I'd missed that you were using the reverse proxy technique - I'd
 strongly recommend rewrite rules.
 
 Without meaning to be greedy, can you suggest an example?
 

As Jonathan says, the Zope book has examples. The most recent version
I'm aware of is at: -

http://www.plope.com/Books/2_7Edition/VirtualHosting.stx

The Rewrite Rules Witch is a handy resource, too: -

http://www.betabug.ch/zope/witch/

HTH!


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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] Logging client IPs to Z2.log

2006-08-16 Thread Philip Kilner
Hi Oliver,

Oliver Hookins wrote:
 So... is it at all possible to log the real client IPs in Z2.log using
 mod_proxy? If not what is going to happen when (and if) PCGI/FCGI support
 is
 removed?

FCGI is already unsupported,

 It may be that you need to reconfigure apache, have a look at the apache 
 docs:

 http://httpd.apache.org/docs/2.0/mod/mod_proxy.html
 
 What do you mean by reconfigure? If the directives I have used weren't 
 supported
 then httpd would have complained on restart. This is clearly not the problem.
 

Not necessarily - Jonathan may have been suggesting that Apache can do
things /differently/, as opposed to that it is /wrongly/ configured.

 Surely I'm not the only one who has run into this issue, or is everyone else
 steadfastly sticking to ZServer or PCGI/FCGI?
 

I have exactly that issue, and I recommend that you consider Apache to
be the web server and Zope the application server, and that logging
client IPs is the web server's job.

Very few people use PCGI/FCGI (less all the time), most run Zope behind
Apache.


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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] Logging client IPs to Z2.log

2006-08-16 Thread Philip Kilner
Hi Oliver,

Oliver Hookins wrote:
 Exactly.  Instead of using apache as a reverse proxy, set up rewrite rules 
 and then you can pass along the ip address (if you really need it).

...[snip]...
 
 Hmmm sounds like what I suspected is actually true... well at least I won't
 spend time bashing my head against a wall. Thanks for all your (very speedy)
 help everyone!
 

I'd missed that you were using the reverse proxy technique - I'd
strongly recommend rewrite rules.

HTH

-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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] ZJetDA product and Microsoft Access

2006-07-27 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 Thanks a lot. Yes I know it's crazy but some organisations built up a
 database over the years and want to stay with that technology. The best
 way would be to migrate but I can understand why it doesn't happen.
 

I understand - but the migration from Access to Access-over-SQL-Server
is pretty simple, and now that a usable version of SQL Server is free
(as  in beer) in most cases (certainly those where Access was ever a
reasonably choice), I will never use the JET database engine again!


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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] ZJetDA product and Microsoft Access

2006-07-26 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 I know it's totally
 crazy to want to hook Access up with Zope using sql queries but I'd just
 like to know if it's been done or is possible.
 

Crazy on so many levels.../but/, although I can't tell you anything
about the DA you are asking about, I can very strongly recommend the
eGenix mxODBC DA - using that product, it is possible, and does work.


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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] installing zope with appropriate python version

2006-07-16 Thread Philip Kilner
Hi Noah,

Noah wrote:
 The zope installed is telling me it is going to use the older version of
 python of 2.3.5 .  Is this proper and welcome behavior?
 

Yes...

 The optimum Python version (2.3.5) was found at /usr/local/bin/python2.3.
 
   - Zope top-level binary directory will be /opt/Zope-2.8.
 

...as 2.3.x was the version for Zope 2.8.x - from memory, Zope was only
certified with Python 2.4.x for the 2.9.x series.


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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] Inavlid Refernce Counts in Temporary Storage

2006-07-14 Thread Philip Kilner
Hi Dieter,

Dieter Maurer wrote:
 You may see a bug in the pack implementation for TemporaryStorage.
 

Aha - well, my Zope version is 2.8.6 - I'll dig to see if this version
is affected.

 Few people will probably try to pack a TemporaryStorage...
 Are you shure to need it?
 

No, not as such - I'm having problems with Conflict Errors, when I try
to store variables in the session.

The system has not changed in any way  that I can see is relevant, and
is not under heavy load (10 users accessing the pages in question), so
I was trying to examine the behaviour of the temporary storage and
satisfy myself that is was healthy.

From what you say, it may be that this error is entirely down to the
pack bug, so I'm back to trying to figure out how to troubleshoot the
conflict error.


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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 )


[Zope] Inavlid Refernce Counts in Temporary Storage

2006-07-13 Thread Philip Kilner
Hi All,

I have an RDBMS application, which resides in a Plone site, but uses
only Zope techniques.

Aside from Plone, the only use of the ZODB is to hold session variables
for users (search parameters etc.), and the load on that part of the
system is very light (10 users, accessing the script in question once
every couple of minutes at the most). The session variables are written
by simple TTW Python scripts, and read back by TALES expressions - all
very simple.

For the last three days, we have been plagued by slowdowns and temporary
lock-ups, which have on a couple of score occasions culminated in a
Conflict Error, indicting transactional problems in the temporary
storage. On four or five occasions, Zope has apparently locked up, and
a restart has been required.

Today, I am seeing errors when I try to pack this storage: -

--
2006-07-13T15:09:11 ERROR Zope.SiteErrorLog
http://10.0.0.7:8080/Control_Panel/Database/temporary/manage_pack
Traceback (most recent call last):
 File D:\PROGRA~1\ENFOLD~1\Zope\lib\python\ZPublisher\Publish.py,
line 114, in publish
   request, bind=1)
 File D:\PROGRA~1\ENFOLD~1\Zope\lib\python\ZPublisher\mapply.py,
line 88, in mapply
   if debug is not None: return debug(object,args,context)
 File D:\PROGRA~1\ENFOLD~1\Zope\lib\python\ZPublisher\Publish.py,
line 40, in call_object
   result=apply(object,args) # Type scr to step into published object.
 File D:\Program Files\Enfold
Server\Zope\lib\python\App\ApplicationManager.py, line 426, in
manage_pack
   t=db.pack(t)
 File D:\PROGRA~1\ENFOLD~1\Zope\lib\python\ZODB\DB.py, line 634, in pack
   self._storage.pack(t, referencesf)
 File
D:\PROGRA~1\ENFOLD~1\Zope\lib\python\tempstorage\TemporaryStorage.py,
line 350, in pack
   self._takeOutGarbage(oid)
 File
D:\PROGRA~1\ENFOLD~1\Zope\lib\python\tempstorage\TemporaryStorage.py,
line 321, in _takeOutGarbage
   raise ReferenceCountError, (
ReferenceCountError:  An error occured while decrementing a reference
to an object in
   the commit phase. The object's reference count was below zero.
(Oid '\x00\x00\x00\x00\x00\x00\x00;' had refcount -1)
--

This seems to indicate that the temporary storage is corrupt in some way
- am I right?

If so, what do I do about it?

Could this indicate a RAM or disk problem, since the application has not
changed significantly, at least at the level of my TTW code?

Any input welcome - aside from this simple use of the session, I never
have to manipulate the ZODB, so this is pretty new to me!


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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] manage_changeProperties has strange side effect on response Content-Type.

2006-06-16 Thread Philip Kilner
Hi Andreas,

Andreas Jung wrote:
 'Hustype' is  pure ASCII...this will *always* have the same encoding in
 almost all encodings (except in Klingon).
 

[klingon] ghaH ghItlhta' Daq [ASCII]

;-)

-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
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-DB] A web based rewards management system for [EMAIL PROTECTED]

2006-06-10 Thread Philip Kilner
Hi Bob,

Since this is somewhat off topic for this list, I have replied to Philip
directly, cc'ing yourself.

Bottom line: Implementing something like this with Plone and some RDBMS
integration should be relatively simple. For my own part, I think that
the RDBMS route has advantages over a pure Plone route (hey, that's
why I'm on this list!), but it's important to acknowledge that others
would disagree.


-- 

Regards,

PhilK

Human language continually changes, innit.
- Stephen Juan
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope] apache rewrite rules redux

2006-05-24 Thread Philip Kilner
Hi David,

I'm suffering from a coffee underflow error, so am not 100% (yet!), but...

David Bear wrote:
 RewriteRule ^/z2$ http://127.0.0.1:9080/VirtualHostBase/\
 https/%SERVER_NAME}:80/VirtualHostRoot/_vh_z2/ [L,P]
 
 RewriteRule ^/z2/(.*) http://127.0.0.1:9080/VirtualHostBase/\
 https/%{SERVER_NAME}:80/VirtualHostRoot/_vh_z2/$1 [L,P]
 
 RewriteRule ^/z2$ http://127.0.0.1:9080/VirtualHostBase/\
 http/%SERVER_NAME}:80/VirtualHostRoot/_vh_z2/ [L,P]
 
 RewriteRule ^/z2/(.*) http://127.0.0.1:9080/VirtualHostBase/\
 http/%{SERVER_NAME}:80/VirtualHostRoot/_vh_z2/$1 [L,P]
 
 The rules listed above only work to serve content from
 http://servername/z2 .. They refuse to work for https://servername/z2
 (that generates a  not found error)
 
 Any other advice on make both urls work?
 

Yes! Your rewrite rules are all rewriting to port 80, but for SSL you
need port 443, so you should have something like: -

RewriteRule ^/z2$ http://127.0.0.1:9080/VirtualHostBase/\
https/%SERVER_NAME}:443/VirtualHostRoot/_vh_z2/ [L,P]
^^^

...for the SSL versions.

HTH!


-- 

Regards,

PhilK

'I must create my own system or be enslaved by another man's.'
- William Blake
___
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] Atomic ZSQL on Zope 2.7.5

2006-04-25 Thread Philip Kilner
Hi Andreas,

Andreas Jung wrote:
 For some reason I thought ZSQL method calls were atomic, but they appear
 otherwise.
 
 What do you mean by atomic? ZSQL are handled by the database adaper
 which is usually tied to the transaction manager of the ZODB.
 

I'm too tired to find the words, so cut and pasted from answers.com: -

Indivisible. An atomic operation, or atomicity, implies an operation
that must be performed entirely or not at all. For example, if machine
failure prevents a transaction to be processed to completion, the system
will be rolled back to the start of the transaction.

Like Michael, I had understood that ZSQL database transactions were tied
into Zope transactions, and would fail or succeed as a whole. Like him,
I have found that - at least with this combination of DA  RDBMS - this
is not so. I work around it, as I always do when a Microsoft product is
involved. If I hit the same thing with PostgreSQL, I'll look into it
deeper...


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

“The creative impulse animates whatever
instrument is placed at its disposal.”
— Robert Fripp
___
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] Atomic ZSQL on Zope 2.7.5

2006-04-25 Thread Philip Kilner
Hi Floyd,

Floyd May wrote:
 Like Michael, I had understood that ZSQL database transactions were tied
 into Zope transactions, and would fail or succeed as a whole. Like him,
 I have found that - at least with this combination of DA  RDBMS - this
 is not so. I work around it, as I always do when a Microsoft product is
 involved. If I hit the same thing with PostgreSQL, I'll look into it
 deeper...
 
 I was under the impression that ZSQL methods were very much intended to
 be atomic:
 http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx#2-77
 

Yes, the docs seem pretty unambiguous.

 I know that it's been atomic to the point of frustration when working
 with Zope and MySQL.  Perhaps the database adapter is at fault here?
 

Surely there /is/ only one point to which it can be atomic?

;-)

There are several layers to this - the eGenix DA, the eGenix ODBC stuff
below that, MS's ODBC driver for SQL Server and SQL server itself. If I
hit the issue with the eGenix DA and another (non-MS) database, or with
another DA and another (non-MS) database entirely, I would spend time
trying to diagnose it. Having wasted a big chunk of my life on
troubleshooting this stuff I now have a rigid policy - if an MS product
is involved I want to know how it /does/ work and develop against that,
otherwise I want to know how it /should/ work and make sure it does. I'm
not trying to denigrate MS (I earn a living on Windows, can live with
the OS, can live without the applications), I'm just making an
observation on not throwing precious time away on things that are
unfathomable.


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

“The creative impulse animates whatever
instrument is placed at its disposal.”
— Robert Fripp
___
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] Atomic ZSQL on Zope 2.7.5

2006-04-25 Thread Philip Kilner
Hi Michael,

Maslak, Michael wrote:
 How can I detect failure and maintain atomicity?
 

You may get more responses to this on the Zope-DB list - as well as
other RDBMS + Zope users, the eGenix guys are active over there (or as
active as you can be on such a quiet list).


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

“The creative impulse animates whatever
instrument is placed at its disposal.”
— Robert Fripp
___
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] Nabble, again?

2006-03-22 Thread Philip Kilner
Hi Chris,

Chris Withers wrote:
 Dunno what Nabble is
 

You could always google for it...

;-)

(Sorry - couldn't help myself!)


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Using folder name in macro

2006-03-13 Thread Philip Kilner
Hi John,

John Poltorak wrote:
 How do I use a folder name in a macro?
 
 ie I want to change this 
 
 metal:macro metal:use-macro=context/abc.pt/macros/page
 

This is a path expression with a file (abc.pt) and path (context/,
signifying the context of the call)...

 which is in the folder 'abc'
 

...so you must have /abc/abc.pt

 to
 
 metal:macro metal:use-macro=context/[folder_name].pt/macros/page
 
 

In your example, you seem to have confused the file and folder - I
suspect you want something more like: -

metal:macro metal:use-macro=context/[folder_name]/abc.pt/macros/page

...meaning the macro page in the file abc.pt in the folder
folder_name, with all the usual caveats about acquisition.

 I don't know where to look this sort of thing up.
 

I generally start with the examples in the latest (?) Zope book (2.7) on
Plope.org. The reference is appendix C: -

http://www.plope.com/Books/2_7Edition/AppendixC.stx

HTH!


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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 )


[Zope-DB] Accessing ZSQL Method properties

2006-02-20 Thread Philip Kilner
Hi All,

I'd like to throw a warning in my application when a record-set is
truncated (e.g. if the ZSQL Method has a Maximum Rows to Retrieve
value lower than the size of the record-set).

In a Script(Python), what is the syntax to access this value?

FWIW, I've been trying to work this out from the 2.7 Zope Book, but the
section in the docs tails off with the plaintive comment XXX where is
that??...


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope] Re: major problems placing authentication on an extranet site-security flaw?

2006-02-11 Thread Philip Kilner
Hi,

J Cameron Cooper wrote:
 Also, as I recall, there was a private plone site howto on plone.org;
 dunno what happened to it.
 

It's still there, still works - and is very likely what Michael wants.


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Re: major problems placing authentication on an extranet site-security flaw?

2006-02-11 Thread Philip Kilner
Hi Again,

Re. Private Plone Site Howto

Philip Kilner wrote:
 It's still there, still works - and is very likely what Michael wants.
 

I'm an idiot - should have checked, knowing that there was a
documentation sprint last weekend. It was at: -

http://plone.org/documentation/how-to/creating-private-plone-site/howto_view

...but I get a login prompt at that URL now.

Has this how to been pulled because flawed, or is it just missing?

I've used it in numerous places, so I'd be interested to know either way!


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Re: major problems placing authentication on an extranet site-security flaw?

2006-02-11 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 Yes I found that as well but picked it up from the Google cache.
 Strange that it is available there as it's password protected.
 Possibly it was public before?
 

Yes, it was public before.

Have you tried this, and does it solve your problems?

JCC is spot on when he points to workflow as being the basis of security
in Plone - it's also worth saying that the Zope system and the Plone
system are pretty much at odds with one another. You are more likely to
make mistakes at the Zope level than to do what you intend.

(If you try the howto, don't overlook that last step - hitting the
update security settings button. Managed to overlook this myself
recently (despite it being the umpteenth time I've followed this howto),
and spent hours thinking that something more exotic was going on!)

Let us know how you get on...


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Re: major problems placing authentication on an extranet site-security flaw?

2006-02-11 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 I've implemented what's outlined in the make private site
 documentation and it works fine on Plone 2.1.1. No content is available
 apart from the site-map page (doesn't list content) and the contact form
 but I can figure that out separately.
  

Since neither of those counts as content as such, I think that that is
 legitimate and as you say, you can work around those if it matters to
you (In cases where I've wanted to work around such things, I've simply
called a script that redirects with an error message if the the
appropriate conditions aren't met.

 Yes I think I like the HTML login page way to authenticate. It feels
 more usable. And I don't think I'll use an Apache login box at all. Most
 users will find it hard remembering one password and with cookie
 authentication over SSL you can go straight into the site. Brilliant.
  

Agreed. Apache does a great job of managing the SSL, securing the data
over public wires, but that's a 100% generic task whereas the
authentication is tightly bound to your application.

It's worth bearing in mind that those credentials are passed over the
wire with every page, so you need your sessions to /stay/ in SSL mode
once authenticated.

 I'm revisting some of the points made in this thread though about
 security. It does seem that Zope and Plone as you say, are at odds on this.
  

Because Zope is an application server, it has to expose it's mechanism -
Plone has an easier job because it has a specific task to do (e.g.
manage content), and so can take an approach which is much simpler to
fly. In Plone, always do things the Plone way - working at the Zope
level may potentially subvert Plone's mechanisms for achieving things.


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Re: major problems placing authentication on an extranet site-security flaw?

2006-02-10 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 Also I feel that Plone has
 usabillity which sits above it's prettyness. It is a well designed
 interface graphically but also has very strong non graphical usability
 elements.
 

You are correct - but you are not comparing like with like, as Plone is
an /application/ and Zope is an /application server/.

An analogous comparison might be between a car's dashboard and it's
engine compartment - you would expect the dashboard to be designed for a
human user above all, but the engine compartment - however logically
laid out - is primarily functional and is always going to appear alien
to the person who is more comfortable driving than using a spanner.

Ultimately, Zope's ZMI user interface is designed for techies who want a
minimal user interface which allows them to see the moving parts, not
the kind of end-user oriented GUI that Plone sports.

You've been given a bit of a hard time in this thread, and I think that
some good points have been made, but I've seen your energetic but
somewhat misdirected posting as more a symptom of youth and
over-confidence than any great sin - you seem to be coping with the
feedback, so you'll learn. However, I'd like to make the point that the
counter-productive and gratuitous insults for which Chris is rightly
famous are another thing entirely. He's a clever bloke and helpful, but
he seems to enjoy being rude - which is a shame.

FWIW, I think the best advice you've been given, albeit in the midst of
quite a strong mail were Floyd's - the security framework in Zope and
Plone was built in the way that it is FOR A REASON - both in terms of
etiquette and in terms of what should be reasonable to assume, it is
usually best to assume that the core of Zope and Plone /work/, and that
if some part of them appears not to then it is more likely the nut
behind the steering wheel that is responsible, as it were.

;-)

Have a good weekend...


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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-DB] Suggestions If Any Please ! ! ! ! !

2005-11-18 Thread Philip Kilner
Hi Rajesh,

Rajesh wrote:
 I'm Having problem in Zsql Method ,which return recordset
 dictionary,containing key--.value pairs,
 this recordset returns only 1000 records ,Even if my Sql query satisfies
 more than 1000 records ,
 Looking forward for suggestions/alternatives
  

Look at the Advanced tab of your ZSQL method - there is a property
there called Maximum rows to retrieve which is limiting your result
set size. The default is 1,000 - you need to identify an appropriate value.

Please don't send HTML mail with graphics to the list - plain text only,
please.


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope] ODBC DA on zope2.6.x

2005-11-03 Thread Philip Kilner
Hi Giuseppe,

Giuseppe Bonelli wrote:
 What people use as an ODBC database adaptor on Zope 2.7 and above?
 Is the eGenix.com mxODBC Zope DA commercial product the only serious
 alternative?
 

I use the eGenix product (against MS SQL Server, primarily), and am very
happy with it.

It is not expensive, and if you value your time at all you may conclude
- as I did - that it is less expensive to purchase the eGenix product
than it would be to thoroughly test a free or open source alternative...


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] NTUserFolder still useful?

2005-10-17 Thread Philip Kilner
Hi Sean,

Sean Dunn wrote:
 I’m running Zope on WindowsXP with plans to run it on server 2003.
 Instead of creating user accounts I’d like to leverage NT
 authentication.. And NTUserFolder looks like it might be what I want,
 except that it looks like a dead product. Besides a note that it works
 on Win2k under certain constraints, I’m not sure if I should try using
 it. Have people had success installing this on WinXP/S2003?
 

Can't speak for XP/S2K3, but we use it in production under S2K in an
S2K3 environment, and I can vouch for it's usefulness.

When we set our system up, there were some issues with AD LDAP support
that I couldn't overcome - NTUserFolder provides authentication to the
Intranet using Windows credentials, which was all we needed.

There was some issue with crypto on the 2K3 Server, but this was just a
case of some silly default settings (same sort of stuff that would cause
Same /et al/ issues).

Let me know if you need more details...


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Vservers and ZOPE

2005-09-27 Thread Philip Kilner
Hi Benmania,

Benmania Guin wrote:
 I have some experience with Zope on my desktop pc with an WIN XP operating 
 system. Now I want to order my own virtual server but I am unsure about the 
 features I will need and I do not know how to install ZOPE on such a system 
 at all. 
 Can you give me any advice what features I will certainly need, e.g. SSH(?), 
 Root access(?)? 
 Can you tell me where I can find more infos about this issue (installing ZOPE 
 on different VServers with different OSs)? 
 

I've just ordered the Zope Virtual Server from Zettai, which seemed to
mysteriously morph from a Zope instance to a virtual server part way
through the sign up process - which I am very happy about.

I wouldn't have chosen a virtual server initially, because all my
experience is Win32 and I don't have time to learn for this project.
However, it feels like the best of both worlds - I didn't have to set
Zope up at all, it was all in place for me (Zope 2.8.1, Plone 2.1 + the
classic products I'd have expected to install), and I get SSH and Root
access more or less as a bonus. The only thing I have had to get my head
around is the file system - but that hasn't been hard at all.

You might consider a Zettai account, or you might want to see how they
do it, 'cos they seem to have got it right from my PoV. Put it this way
- I bought a second identical account less than a week later for a
personal project.

 I hope my inquiries were not too trivial to be answered. 
 

Not at all - this is important!


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison

___
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] Re: ZDatabaseTool - does this still exist?

2005-08-11 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 I've already made it clear in this thread exactly what I want to do!
 It doesn't to be a relational db to be able to easily add fields.The
 database browser tools in the ZMI are ok but basic.
 

I'm as puzzled as other readers, but now you have said add fields, I'm
even more puzzled!

What do you want to add fields to?

Do you mean to add properties to an object?

What sort of object?

If so, arguably the whole ZMI is your database tool, and the database
tools elements are just some maintenance utilities...

N.B. Am not trying to needle you - am trying to get some traction on
your problem!

:-)


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Re: ZDatabaseTool - does this still exist?

2005-08-11 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 Whether you call them objects or fields it's still clear what I want
 to do and there's no easy way to do it. Surprised someone hasn't
 developed a product tn do this. I'm looking at CMFMember and perhaps
 it will fit the bill.
 

There are a bunch of things to say here - first of all, it may be clear
to /you/, but it's not clear to /us/! You do need to respect the fact
that others may use different terms (or consider different things
implicit), to communicate usefully. I've become frustrated myself whilst
getting to grips (to the extent that I have!) with these tools, but it
doesn't help...what helps is chipping away at it with a positive
attitude until you arrive at some common ground.

Now you mention CMFMember, it seems that you want to add fields
(attributes?) to the Member record (object?). If you think of the ZODB
as a database, and Zope as an application server, you are now getting
into the specifics of an /application/ (CMF/Plone), and in that context
your needs are perhaps more complex than you think: You need to store
your data, yes, but you also need to integrate the capture and updating
of that data into an existing application. So you are not really asking
for a database management tool but a product which does that and more
besides - which goes to show that the terminology /is/ important!


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Re: localhost:8080 not found on windows

2005-08-10 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 Thanks for the help here. I'm calling in a support engineer to try and
 get it up and running. Firewall, router issues involved. Strange
 though that localhost doesn't work. Because that wouldn't go through
 the firewall/router.
 

I despise ISA Server with a passion - have just spent a couple of hours
hunting down a silly mistake in one of my rules in the 2K3 version which
would have stuck out like a sore thumb in an Apache .conf file.

I wouldn't make any assumptions about what it might block, up to and
including localhost - it bites me time after time, and all I ever have
to do is add web publishing rules, which that /should/ be simple enough.
Problem is, it's all hidden in tabbed dialogues where you can't see the
whole rule at once...spit

 I've also noticed that something shuts down pythonservice.exe program
 which is strange.
 

Now that /is/ a new one on me - but would certainly explain your problem...

Good luck!

-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Re: localhost:8080 not found on windows

2005-08-10 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 I've even tried using the machine's local IP but that doesn't work in
 the same way that localhost doesn't. I've installed Apache now as well
 so as to route requests through that to Zope.
 
 I'm going to be using the same IP address that the webmail exchange
 service uses. It uses mail.sbcscot.com http://mail.sbcscot.com so I
 guess if I have http://plone.sbcscot.com then I could tell Apache to
 route that to Zope? How would I tell IIS or ISA not to listen to that
 domain? Meanwhile I noticed on installing Apache that it failed to bind
 to port 80!
 

Well, you /can't/ tell IIS not to listen on that domain - it listens
at a port on an IP. The host header translation for virtual hosting can
only happen if it can field the request in the first place (e.g. if
there are no clashes at that port/IP). If you have a single interface,
you are stuck using non-standard ports to avoid clashes. Apache will not
bind to port 80 either because you have http://mail.sbcscot.com bound to
the same port  IP, or because of the socket pooling nonsense if you
have a separate IP.

I would not touch ISA with a barge-pole if I had a choice - but assuming
you are on SBS and are/could be behind a separate firewall, I would: -

- Leave Zope/Plone on 8080

- Change the port for webmail (and any other IIS stuff) to a different
high port (e.g. 9080?), so it is no longer clashing with Apache.

- Disable socket pooling. spit!

- Run Apache on port 80

- Use virtual hosts with rewrite rules in the Apache .conf to pass
requests to your Zope and Webmail sites.

You could probably do something similar with ISA server (I do, but not
on the same box as IIS and Zope/Plone), but I'd rather not even think
about that...


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] localhost:8080 not found on windows

2005-08-09 Thread Philip Kilner
Hi Michael,

Apols for delay in replying - been on the hoof.

michael nt milne wrote:
 Thanks for the advice. Yes I've looked at everything mentioned here.
 Localhost is in the hosts file. Zope has started as a service. I've
 changed the hosts file to include localhost:8080/manage etc.
 
 Yes this is a set-up on Windows Small Business Server and it also has
 an Exchange webmail service running as well.
 
 The web server is IIS 6.0.
 
 Enterting http://domain or IP/exchange
 
 gives the login for the exchange service, however localhost:8080 or
 127.0.0.1 etc gives page not found.
 
 Do I need to set-up a website under IIS or a virtual directory?
 

Absolutely not - if IIS and Zope are on different ports, they are two
entirely separate beasts.

Does your SBS install include ISA server?

- If so, you will probably need to tweak it.

- If not, I would try looking at logfiles and/or changing Zope's port.

Honestly, this is usually v. easy - either the service is having
problems or there is something else on that port (it's often used by web
application servers, e.g. Tomcat, as a default).

HTH - Let us know where you're at.


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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 )


[Zope] Re: localhost:8080 not found on windows

2005-08-09 Thread Philip Kilner
Hi Michael,

Michael nt milne wrote:
 I read though that you have to do a re-write in IIS or install an
 ISAPI re-write extension so that IIS speaks to zope. There's also the
 404 asp script in Andy Mckay's book.
 

This only applies if you are using the /same/ ports on IIS as Zope.
Using 8080 should keep it separate.

 Apparently IIS hogs all the ports and has to be forced not to.
 

Not quite - it hogs it's ports (e.g. 21, 80, 443) on all IPs (socket
pooling) unless sense is kicked into it.

See: -

http://support.microsoft.com/kb/q238131/

 Not sure about ISA server.
 

Since it is a firewall and would know about IIS but not Zope, you do
need to know if it's in play...

Can I suggest you try this on a plain Windows workstation, so you can
see how it normally works?


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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 )


[Zope] Re: localhost:8080 not found on windows

2005-08-09 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 Ok thanks. Will check on the ISA side. I've it up and running on a laptop 
 fine.
 Will let you know progress. Would you say it should be fine just
 running the app from the zope server on 8080 once it is running,rather
 than configuring to go through IIS?What's your experience?
 

Glad you've had it running on a laptop - I was concerned you might lose
faith!

;-)

If the app is Internet facing, or has non-trivial traffic, I'd put Zope
behind Apache. I have multiple sites on single Zope instances on several
Windows servers, and it works really well.

In my case, Apache serves pages on port 80 but on a separate IP address
from IIS. One old server is NT4 (!) which worked fine, another is Win2k
Server, and I needed to knock socket pooling on the head for that one.

If I were doing it again, I'd run /both/ Zope and IIS on non-standard
ports, and put both behind Apache. I may be a bit jaundiced, but I don't
consider IIS is well enough house-trained to be let loose on port 80...


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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 )


[Zope] Re: localhost:8080 not found on windows

2005-08-09 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 Ok, thanks. Yes, Apache would be much better to route traffic through.
 And also it looks like a complete pain to try and route traffic
 through IIS. Is Apache for windows good? I only have experience of it
 on UNIX
 

Works fine - once it's up and running and you are looking at the .conf
file, you will probably barely notice the difference.

 Since I am not expecting very high traffic for my site at first I am
 going to use the Zope server at first. My head is hurting too much
 just now!
 

Understood!

 By the way do you have any experience of altering the zope database or
 adding fields to the registration process on Plone etc? Seems a wee
 bit tricky and a client wants extra fields etc.
 

That's one for the Plone list - but there is now a release candidate out
for Plone 2.1, and I understand such things are simpler in that version.
There may be an existing CMF/Plone product that does what you want for
that matter.


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Anyone using isapirewrite or freshlogic re-write for IIS and Zope?

2005-08-09 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 Has anyone used either of the ISAPI re-write tools for IIS and Zope
 from HeliconTech at http://www.isapirewrite.com or at Freshlogic
 http://freshlogic.net ?
 
 I'm attempting to set up a largescale instance on a windows small
 business server.
 
 The latter is written more for Plone and Zope in mind. Both cost around 
 £30-35.
 

No experience of either - but you may also want to consider: -

http://www.enfoldsystems.com/Products/EEP

...of which I also have no experience g, but which is closer to Plone,
as it were...


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] RE: Blobs in Interbase

2005-08-02 Thread Philip Kilner
Hi Ashley,

Ashley Lloyd wrote:
 The LDAP error, as it turns out, was from zkinterbasdb or something like
 that - something I probably picked up thinking it was kinterbase.
 

Aha - thought it was unlikely to be from the DA!

 Forgive my ignorance, but what was your procedure for installing kinterbase?
 I've tried just installing kinterbasDA, which required kinterbasdb. So I've
 tried installing kinterbasdb (from an executable, rather than the more
 familiar simple compressed file), but I keep getting an ImportError: DLL
 load failed when looking at the product in Control_Panel/Products.
 
 The error refers to a line import _kinterbasdb as _k. I've assumed that
 its referring to import _kinterbasdb.pyd, rather than a dll, as thats all
 that I can find. I've tried copying it into several places, but I'm assuming
 that its compiled by the exe at install time, and is specific to the folder
 its placed in. Or I could be completely wrong!
 

You want a .pyd, not a .dll - that bit's fine.

I may have started from a different point from you - I have a Plone
install with multiple Zope and Plone sites in it, and Plone does a
couple of things differently. In a Plone install on Windows, the Plone's
Python is set as the system's Python. This means that when you run the
binary installer for kinterbasdb it installs in the right copy of
Python. I wonder if you have Python installed elsewhere, and the binary
installer is finding the wrong one?

The other thing is the mxExtensions - do you have these installed?

 Any hints as to your procedure would be appreciated, as this is getting
 frustrating (probably meaning I'm missing stupid things).
 

I didn't do anything beyond what the docs for the three packages (mx
Extensions, Python db i/f, Zope DA) stated - but there is always the joy
of working out what those instructions /really/ mean, as in now I've
done it, I understand it! I do remember some frustration, but I think it
was just the system Python thing.

If the above doesn't help, the traceback from your error should be our
starting point - stick with it, because since installing it I haven't
even needed to think about this DA except when I've upgraded it, it just
works (for me - YMMV and all that)!


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] localhost:8080 not found on windows

2005-08-02 Thread Philip Kilner
Hi Michael,

michael nt milne wrote:
 I have installed Zope and Plone on a windows business server. On
 trying to view http://localhost:8080/manage I am getting a 404 not
 found etc.
 

Is that under IE? It's error messages can be misleading...

 The server is already running a webmail service, however nothing comes
 up for locahost or http://127.0.0.1.
 

Do you have localhost in your hosts file??

Have you tried http://127.0.0.1:8080/manage ?

Have you checked that the service is running?

 I've also tried using the IP address of the machine to access the
 interface with the same result. The IP address is available in web
 DNS.
 
 Does anyone have any ideas on how to get the zope/plone browser
 interface running at all?
 

It generally doesn't take any work at all - I'd suspect either that the
service is not running or that something else is trying to hog that port
before getting into more exotic issues. Check the service status (try
restarting it if it seems to be running), and event log...

You say windows business server - could this mean SBS? If so, has ISA
server got it's sticky mitts in the situation?


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Re: Zope Foundation Update

2005-07-20 Thread Philip Kilner
Hi Godefroid,

Godefroid Chapelle wrote:
 It's definitely better to speak about it in the open air, where we all
 will be able to think about it together.
 

Amen.

I wasn't aware of this until ten minutes ago, and now it seems a whole
bunch of stuff has gone on, up to and including people getting shirty
with each other, which I would have liked to have known about earlier.

I'm an independent developer and I'm pretty quiet in the community, but
I've pretty much bet my livelihood on Zope - this stuff /matters/ to me!

What makes me unhappy about this is people making sweeping and
inaccurate statements which also imply bad faith. The idea that an
organisation that only registered a trademark in one territory describes
the registration of the same mark in a /different/ territory as a
violation is very irksome because it ignores the nature of trademark
law (in which context ZC not registering it in Europe is negligence,
plain and simple, if they want to pursue it), but infinitely more
irksome is the implication that this was somehow done in bad faith, when
what little I know about it indicates the exact opposite.

This has the potential to make the Zope community look like muppets, and
not in a good Swedish chef kind of way...


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Re: Zope Foundation Update

2005-07-20 Thread Philip Kilner
Hi Chris,

Chris Withers wrote:
 This has the potential to make the Zope community look like muppets, and
 not in a good Swedish chef kind of way...
 
 I'm not sure muppetism applies to the Zope community, it appears to be
 Zope Corporation who are coming out of this looking less than clever.
 

Agreed/understood - but ZC are part of the community, too - the BDFL
part, I guess. I was trying to be as inclusive as possible, since it
takes two to get into these messes...


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Newbie Questions - many-many relationships? Zope 2 or 3?

2005-06-22 Thread Philip Kilner
Hi Jim,

Jim Vine wrote:
 I’d greatly appreciate any guidance that can be
 provided on these subjects.
 

I know a lot has been said since your original query, but re-reading it
I was surprised that no one had asked a fundamental question: -

If the data is structured in nature and fits the relational model well
(e.g. is well defined), why not use an RDBMS for the data, and
Zope/Plone for the UI?

I do full-time development of web-based RDBMS applications in Zope and
Plone (MS SQL and Firebird), and I have the following observations: -

- By putting database-related complexity in the database, where it
belongs IMHO, you may find (as I have) that the complexity of what you
need to accomplish in Zope is reduced to the point where the ZMI
approach is entirely appropriate.

- You will find yourself working very hard to implement a relational
database in the ZODB, compared to interfacing to an RDBMS. If you need
one, I'd use one - instead of writing one! ;-)

YMMV and all that - I /am/ an RDBMS zealot (see Fabian Pascal's writing
for the mindset!), and I am /not/ a Python wizard (although my Python-Fu
grows stronger by the day due to immersion in Zope...), so my choice of
approach was strongly influenced by my starting point.


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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] Transferring Zope Settings

2005-06-14 Thread Philip Kilner
Hi Joel,

jlegris wrote:
 Clearly, transferring the Data.fs from
 the test server to the production server is insufficient given the user data
 mismatch. Therefore, it would seem that my only option, given the
 circumstances would be to manually replicate the configuration in the
 production server. However, my better judgment leads me to think that this
 isn't sensible. Is there no alternative? 
 

If you have settings and user data (not sure exactly what that means
 in terms of which objects are which) in the ZODB, and you need to
update  some and keep some, the way I would go about it is as follows: -

- Identify in your production data.fs what user data needs preserving
- Export these to disk as .zexp files.
- Drop in the new data.fs
- Test
- Import the user data from the .zexp files on disk

Clearly, in your case treating the data.fs as a single monolithic entity
 will not work for you - you need a way of splitting up the two types of
data that need to be treated in two different ways. I do the above
fairly frequently - I have a Plone site that seems to be nomadic, and
has passed through a number of data.fs instances in it's life. The only
gotcha I've encountered is where the products were out of sync between
instances.

(Note that this is pretty much what Tino has already said - I'm just
expanding on it a bit to try and get some traction.)

Is there any reason why the above would not work for you?

I have a nagging feeling I'm missing something here...which I think
flows form your use of the term settings - would you care to expand on
what objects you are thinking of?


-- 

Regards,

PhilK

Email: [EMAIL PROTECTED]
PGP Public key: http://www.xfr.co.uk
Voicemail  Facsimile: 07092 070518

You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start.
- Tony Harrison
___
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-DB] ZODBCDA

2005-05-20 Thread Philip Kilner
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Carlos,

Carlos A. Micucci wrote:
 I have a problem with ZODBCDA. When query a DB which instances have a
 null values, this values return as cero values (0) not  nulls values,
 and  this  is a problem  for me,  because  I need  differentiate  them.
 In my opinion, it's a serious error. There is somebody who know the
 solution?
 

ZODBCDA is obsolete and unmaintained - unless you are using a /really/
old version of Zope, you are likely to encounter much more serious
problems than this.

There is another free ODBC adapter (for Windows only) at: -

http://www.zope.org/Members/timmorgan/products/ZODBCDA/document_view

There is also an ADO adapter: -

http://sourceforge.net/projects/zadoda/

YMMV - I have not tried these, and both are early versions.

Finally there is the commercial eGenix product at: -

http://www.zope.org/Members/lemburg/mxODBC_Zope_DA

I /have/ worked with this one - on fact I earn my living with it, in
effect. Recommended.

HTH!


- --

Regards,

PhilK

Email: [EMAIL PROTECTED] / Voicemail  Facsimile: 07092 070518

Never increase, beyond what is necessary, the number of entities
required to explain anything --- William of Ockham (1285-1349)

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFCjhgWuk+q3Pfz3LYRAmtRAJ996Zg8WQfAteyqOkvLXBlVnc79DQCePQc1
AOawgCkXSCz9Y58jf/4F/M8=
=lNzr
-END PGP SIGNATURE-
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope] Re: Does anyone care whether we deprecate ZClasses?

2005-04-07 Thread Philip Kilner
Hi Chris,
Chris Withers wrote:
(There are no plans to deprecate DTML.  It is even supported in Zope 3.)
That is the best news I have heard all day (although, it is early).
I will be selling black flags for the mourning of a missed opportunity...
With or without a circled A?
;-)
--
Regards,
PhilK
Email: [EMAIL PROTECTED] / Voicemail  Facsimile: 07092 070518
it's very hard to talk quantum using a language originally
designed to tell other monkeys where the ripe fruit is
- Lu-Tze
___
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] RE: [Zope-dev] Prohibiting Spams on the List

2004-06-18 Thread Philip Kilner
Hi Tim,
Tim Peters wrote:
I'd be
happy to restrict posting to members, *if* people don't object to the idea.
I wouldn't ever even /expect/ to be able to submit from a non-member 
address...

I spend an increasingly resented part of each day doing list-admin triage
(for zodb-dev and about 6 other mailing lists).
(Snap!)
reject is the no-manual-intervention default action, but it would place a
new burden on members posting from non-member accounts (their posts would be
rejected, at least until they asked the list admin to add their other
posting accounts to Mailman's list of non-members to accept -- and they
would need to do that on a per-list basis).
...and I wouldn't expect the list admin to take special measures for me 
either - I'd expect to have to subscribe from two addresses and deal 
with the dupes if I wanted to send from two addresses. Does Mailman have 
a nomail facility that subscribers could set /themselves/ on secondary 
accounts?

In gentler times, your concern would be wonderful - in the current 
climate, you'll drown if you can't automate it. Save yourself, while you 
can!

;-)
--
Regards,
PhilK
Email: [EMAIL PROTECTED] / Voicemail  Facsimile: 07092 070518
The lyf so short, the craft so long to learne - Chaucer
___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope )