RE: [Zope] Centralized sessions with ZEO
You're nearly there! 1. Change the mount point to be something like /session_folder 2. Mount the data fs and create the mount point 3. Create a new transient object container in /session_folder 4. Change /session_data_manager to point to /session_folder/your_new_transient_object_container Restart your zope servers and they should all start to use the same shared session back end. -John --- Unix Web Infrastructure Management Faculty of Medical Sciences Computing University of Newcastle Email : [EMAIL PROTECTED] Web: http://www.ncl.ac.uk/medev -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sours, Kevin Sent: 10 March 2008 21:55 To: zope@zope.org Subject: [Zope] Centralized sessions with ZEO I apologize if this has been asked ad nauseam. I've uncovered enough information online to suggest that it has, but too little to get any kind of definitive answer. My problem is that I am running a number of zope instances against a zeo instance. I would like to store the session data in the ZEO instance so that the session data is shared between the different zope instances. The question is how best to do it. What I've settled on is the approach given at http://www.zopelabs.com/cookbook/1061234337. This appears to work fine, however I don't really like the idea of using an undoable store and having to constantly pack it. I definitely don't need persistent data (if the sessions go away when I restart ZEO so be it). I tried the same approach using a tempstorage instead of filestorage. This works up until ZEO is stopped and started, at which point the transient object container in the temporary storage disappears (which makes sense, but is a little inconvenient). I also tried the approach at http://longsleep.org/1/howto/sharesessionwithzeo. This is absolutely perfect for what I want to do save for the fact that it doesn't work. No matter what I tried with it, the sessions don't get shared. In fact, it doesn't look like the database on ZEO get recognized at all. When I go to add a mount point it tells me that there is something in the way of /temp_folder (presumably the autocreated temporary folder object for the default sessions). What I find particularly odd is that this appears to be the case for anything configured to mount at /temp_folder - including the temporary storage configured as part of the default zope.conf file. Changing that part of the default config or removing it entirely doesn't appear to have any impact on how zope runs. I feel like I'm missing something. It seems like configuring the sessions to use tempstorage on the ZEO instance shouldn't be this hard. I'm also confused by the seemingly spurious block in the zope.conf: zodb_db temporary # Temporary storage database (for sessions) temporarystorage name temporary storage for sessioning /temporarystorage mount-point /temp_folder container-class Products.TemporaryFolder.TemporaryContainer /zodb_db I haven't been able to find much documentation on what the various options for this block mean (particularly the container-class) member. I should probably mention that I am running 2.8.7, which I realize is more than a little out of date at this point. I'm hoping that somebody can fill me in a little or point me to some documentation I may have missed. Thanks in advance Kevin ___ 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 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] zope starts in foreground but not normaly
Hi there, after a software upgrade (system and zope/plone) we have a strange problem. we have an old site that runs under plone 2.1 Zope-2.8.9-final python 2.3.5 when I start it in the foreground with bin/zopectl fg everything works fine. if I however start it with bin/zopectl start bin/zopectl status shows after some seconds [EMAIL PROTECTED]:~ instances/kanneweb3/bin/zopectl start daemon process started, pid=26697 [EMAIL PROTECTED]:~ instances/kanneweb3/bin/zopectl status daemon manager running; daemon process not running [EMAIL PROTECTED]:~ I see no entries in the logs, so I have no idea where to look. for any hints how the caus of this problem, I would be gratefull robert This is what the controllpanel shows: Zope Version (Zope 2.8.9-final, python 2.3.5, linux2) Python Version 2.3.5 (#3, Mar 11 2008, 10:14:33) [GCC 4.1.2 20061115 (prerelease) (SUSE Linux)] System Platform linux2 SOFTWARE_HOME /home/zope/Zope-2.8.9-final/lib/python ZOPE_HOME /home/zope/Zope-2.8.9-final INSTANCE_HOME /home/zope/instances/kanneweb3 CLIENT_HOME /home/zope/instances/kanneweb3/var Network Services ZServer.HTTPServer.zwebdav_server (Port: 8290) ZServer.HTTPServer.zhttp_server (Port: 8280) Process Id 26719 (-1229186160) Running For 1 min 21 sec ___ 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 starts in foreground but not normaly
robert rottermann wrote: [EMAIL PROTECTED]:~ instances/kanneweb3/bin/zopectl status daemon manager running; daemon process not running [EMAIL PROTECTED]:~ I see no entries in the logs, so I have no idea where to look. Check the ownership of the log files. When this happens to me, it's usually because the user zope is running as doesn't have permission to write to the log files or the Data.fs or the var directory... cheers, Chris -- Simplistix - Content Management, Zope Python Consulting - http://www.simplistix.co.uk ___ 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 starts in foreground but not normaly
Chris Withers schrieb: robert rottermann wrote: [EMAIL PROTECTED]:~ instances/kanneweb3/bin/zopectl status daemon manager running; daemon process not running [EMAIL PROTECTED]:~ I see no entries in the logs, so I have no idea where to look. Check the ownership of the log files. When this happens to me, it's usually because the user zope is running as doesn't have permission to write to the log files or the Data.fs or the var directory... cheers, Chris thanks this is not the reason. zope runs as the user that created the whole instance. after zope stopped two files are left in the var directory: Z2.pid, Z2.lock both containing an int that was probably the pid of the crashed zope. any more ideas? robert ___ 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: zope starts in foreground but not normaly
robert rottermann, on 2008-03-11: Hi there, after a software upgrade (system and zope/plone) we have a strange problem. we have an old site that runs under plone 2.1 Zope-2.8.9-final python 2.3.5 when I start it in the foreground with bin/zopectl fg everything works fine. if I however start it with bin/zopectl start This is a problem with Zope 2.8.9. It was fixed in the shortly after released 2.8.9.1. See the top of this file: http://www.zope.org/Products/Zope/2.8.9.1/CHANGES.txt -- Maurits van Rees | http://maurits.vanrees.org/ Work | http://zestsoftware.nl/ This is your day, don't let them take it away. [Barlow Girl] ___ 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] How to make a trigger handler on moved object
Hello, I want to make method that as a handler when some content is moved to a new location. I want to capture another event, like deleted content, access and modify the content's title, etc. Inside the handler method/function/procedure, it will create a connection to another host. Anybody know how to make this happen? Any sample or tutorial will be great. Once more, I'm using Plone 2.5.2. Thank you. Regards, -jay- ___ 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-Annce] Grokkerdam sprint!
The Grokkerdam Grok sprint It was planned for a long time, but at last we are going to hold a Grok sprint in the Netherlands. To be more precise, in Rotterdam. Rotterdam will be Grokkerdam for the duration of the sprint! Where: Rotterdam, the Netherlands When: 30 april - 5 may 2008 Who: hopefully, you! A number of experienced Grokkers will be there. People of all experience levels are welcome, as long as you're interested in helping us improve Grok. Tasks could be anything Grok related. Some possible topics: * improving the Grok introspector UI * relational database integration for Grok * Polishing Grok's KSS integration * Preparing for Grok's 1.0 release * Documentation ... or whatever you want to work on! Sign up for the sprint on our wiki page, here: http://wiki.zope.org/grok/GrokkerdamSprint If you have any comments or questions, please mail me! Our generous host for this sprint is The Health Agency (http://www.thehealthagency.com/), a company that uses Grok for its own web applications here in Rotterdam. Note: this sprint is back-to-back with the Plone 3 sprint in Paris (25-27 april), hosted by Ingeniweb. Rotterdam is 3 hours away from Paris by train. You could participate in both sprints and enjoy a few days of Paris (or Rotterdam) in between. ___ Zope-Announce maillist - Zope-Announce@zope.org http://mail.zope.org/mailman/listinfo/zope-announce Zope-Announce for Announcements only - no discussions (Related lists - Users: http://mail.zope.org/mailman/listinfo/zope Developers: http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope-dev] Zope Tests: 5 OK
Summary of messages to the zope-tests list. Period Mon Mar 10 12:00:00 2008 UTC to Tue Mar 11 12:00:00 2008 UTC. There were 5 messages: 5 from Zope Tests. Tests passed OK --- Subject: OK : Zope-2.8 Python-2.3.6 : Linux From: Zope Tests Date: Mon Mar 10 21:58:47 EDT 2008 URL: http://mail.zope.org/pipermail/zope-tests/2008-March/009230.html Subject: OK : Zope-2.9 Python-2.4.4 : Linux From: Zope Tests Date: Mon Mar 10 22:00:18 EDT 2008 URL: http://mail.zope.org/pipermail/zope-tests/2008-March/009231.html Subject: OK : Zope-2.10 Python-2.4.4 : Linux From: Zope Tests Date: Mon Mar 10 22:01:49 EDT 2008 URL: http://mail.zope.org/pipermail/zope-tests/2008-March/009232.html Subject: OK : Zope-2.11 Python-2.4.4 : Linux From: Zope Tests Date: Mon Mar 10 22:03:19 EDT 2008 URL: http://mail.zope.org/pipermail/zope-tests/2008-March/009233.html Subject: OK : Zope-trunk Python-2.4.4 : Linux From: Zope Tests Date: Mon Mar 10 22:04:49 EDT 2008 URL: http://mail.zope.org/pipermail/zope-tests/2008-March/009234.html ___ Zope-Dev maillist - Zope-Dev@zope.org 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 )
Re: [Zope-dev] Re: zope.sendmail Retry fixes and new state machine.
Hi Andreas. I think your response gets to the heart of the issue. For software to be useful, it is often more important for folks other than the author to understand it. This can only occur with communication. Sometimes it is the understanding of edgecases in particular, that gets lost over time. I find generally that I cannot keep in memory all of the details of the code I write. Several months afterwards without my own documentation, these details can be lost. So it is just important if I need to come back to it myself as for anyone else. If the test is worth writing, it is not difficult to add a small amount of text to communicate about it. If the software is worth writing in the first place, I consider the code incomplete without doctests. For community projects, it is often the case that it is not the author maintaining the code in the future. This only strengthens the argument for doctests and the reason this has become the standard for zope. Regards, David Andreas Jung wrote: usage of your module. It's basically not of interest for telling them all edgecases. Addressing edgecase is unittests is basically good enough for me. They sometime require more code to test and put this into a doctest is often just overhead. Andreas ___ Zope-Dev maillist - Zope-Dev@zope.org 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 ) ___ Zope-Dev maillist - Zope-Dev@zope.org 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 )
Re: [Zope-dev] Re: zope.sendmail Retry fixes and new state machine.
I hate to add more to this discussion, but I think some folks might have some miss-conceptions about doctests: On Mar 10, 2008, at 12:39 PM, Tres Seaver wrote: ... Becuase they make for poor unit tests? Using them to document the mainline use cases for an API is one thing: using them to do thorough coverage of edge cases is quite another. I find that for the latter, they fail *both* as documentation *and* as tests: their value as documentation drops as the amount of scaffoldiing rises, and the lack of isolation between tests sharply reduces their value for testing the corners. It is certainly straightforward enough to create isolated doctests. For edge cases, I do typically create separate isolated short doctests that deal just with that case. The assertion that doctests don't allow isolation is simply not correct. I'm not sure what scaffolding you're referring to. Do you mean test set up? Or the tools for normalizing output? For test set up, I don't think there's any difference. I can sympathize with the skepticism with normalizing output. Sometimes, I think it might be better to write documented tests rather than executable documentation and use assertion of a more traditional nature, if the test is still readable, although I suspect that it will often be easier to normalize output rather than make lots of assertions about the output. Jim -- Jim Fulton Zope Corporation ___ Zope-Dev maillist - Zope-Dev@zope.org 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 )
Re: [Zope-dev] Re: zope.sendmail Retry fixes and new state machine.
--On 11. März 2008 09:42:11 -0300 David Pratt [EMAIL PROTECTED] wrote: Hi Andreas. I think your response gets to the heart of the issue. For software to be useful, it is often more important for folks other than the author to understand it. This can only occur with communication. Sometimes it is the understanding of edgecases in particular, that gets lost over time. I find generally that I cannot keep in memory all of the details of the code I write. Several months afterwards without my own documentation, these details can be lost. So it is just important if I need to come back to it myself as for anyone else. You can also document your edgecase in the same way as comments within your unittests. It matters that you have tests for the related edgecases. It's up to every developer to decide which test type is best for the individual case. If you're good in story telling (I am not so good), go with doctest but there can not be law that everything must be in doctests. If the test is worth writing, it is not difficult to add a small amount of text to communicate about it. If the software is worth writing in the first place, I consider the code incomplete without doctests. For community projects, it is often the case that it is not the author maintaining the code in the future. This only strengthens the argument for doctests and the reason this has become the standard for zope. Agreed. But unittests are for certain tests more suitable. E.g. if you need a complex and bigger fixture or something like that. Andreas pgpD0OJ80QkUV.pgp Description: PGP signature ___ Zope-Dev maillist - Zope-Dev@zope.org 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 )
Re: [Zope-dev] Re: zope.sendmail Retry fixes and new state machine.
On Mar 11, 2008, at 9:46 AM, Andreas Jung wrote: ... You can also document your edgecase in the same way as comments within your unittests. This is true in theory, but in practice, it almost never happens. There is no guarantee that doctests will contain useful text, but they encourage text which has a greater chance of being useful than no text at all. Agreed. But unittests are for certain tests more suitable. E.g. if you need a complex and bigger fixture or something like that. Unit testst don't make it any easier or harder to write test fixtures. They *do* encourage the use of inheritance to write text fixtures, which tends, in my experience to make them harder to understand. Jim -- Jim Fulton Zope Corporation ___ Zope-Dev maillist - Zope-Dev@zope.org 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 )
[Zope-dev] Grokkerdam sprint!
The Grokkerdam Grok sprint It was planned for a long time, but at last we are going to hold a Grok sprint in the Netherlands. To be more precise, in Rotterdam. Rotterdam will be Grokkerdam for the duration of the sprint! Where: Rotterdam, the Netherlands When: 30 april - 5 may 2008 Who: hopefully, you! A number of experienced Grokkers will be there. People of all experience levels are welcome, as long as you're interested in helping us improve Grok. Tasks could be anything Grok related. Some possible topics: * improving the Grok introspector UI * relational database integration for Grok * Polishing Grok's KSS integration * Preparing for Grok's 1.0 release * Documentation ... or whatever you want to work on! Sign up for the sprint on our wiki page, here: http://wiki.zope.org/grok/GrokkerdamSprint If you have any comments or questions, please mail me! Our generous host for this sprint is The Health Agency (http://www.thehealthagency.com/), a company that uses Grok for its own web applications here in Rotterdam. ___ Zope-Dev maillist - Zope-Dev@zope.org 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 )
Re: [Zope-dev] zope.sendmail Retry fixes and new state machine.
Hi! On Sun, 2008-03-09 at 20:54 -0400, Gary Poster wrote: I did have one somewhat trivial thought. I generally prefer durations and intervals expressed as datetime.timedeltas myself, because they convey their meaning without having to look it up docs (is that number value a number of seconds? milliseconds? minutes?). There might even be a zcml built in for schema field for that; I believe I remember that there is in ZConfig. Minor detail - yes it has warts - there are other things that will need doing to, its just time that this code was put out there. Also, some variety of doctest would be nice. Even when a package is not using doctests, I add new tests as doctest unless there's a really good reason not to. It was the only way I could debug and introspect the problems from the Unit tests - the python debugger does not run properly from the doctests, and the original test are all unit tests... In this case, it looks like you've made the code significantly more robust, which has added some probably necessary complexity. The code looks readable, but I recommend a maintainer-oriented overview/ introduction as a doctest, at the least. For instance, perhaps you could think about documentation about the rationale for the approach and about the dance that this code participates in (with the lock files and all the possible SMTP error conditions and the code's responses). Of course, even more friendly docs than that would be nice, but I'm only asking for what I myself tend to give, unfortunately. A little does need adding there - I have scanned state machine diagrams and the design rationale. I will go and put those in the checkin when I have a spare moment. Regards, Matthew signature.asc Description: This is a digitally signed message part ___ Zope-Dev maillist - Zope-Dev@zope.org 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 )
Re: [Zope-dev] zope.sendmail Retry fixes and new state machine.
On Mar 11, 2008, at 5:01 PM, Matthew Grant wrote: Hi! On Sun, 2008-03-09 at 20:54 -0400, Gary Poster wrote: I did have one somewhat trivial thought. I generally prefer durations and intervals expressed as datetime.timedeltas myself, because they convey their meaning without having to look it up docs (is that number value a number of seconds? milliseconds? minutes?). There might even be a zcml built in for schema field for that; I believe I remember that there is in ZConfig. Minor detail - yes it has warts - there are other things that will need doing to, its just time that this code was put out there. Completely agree. Also, some variety of doctest would be nice. Even when a package is not using doctests, I add new tests as doctest unless there's a really good reason not to. It was the only way I could debug and introspect the problems from the Unit tests - the python debugger does not run properly from the doctests, and the original test are all unit tests... Understood. For future reference, if you out the set_trace on the same line, you *can* use pdb. For instance, this would let you walk into the ``do_foo`` function. import pdb; pdb.set_trace(); do_foo() In this case, it looks like you've made the code significantly more robust, which has added some probably necessary complexity. The code looks readable, but I recommend a maintainer-oriented overview/ introduction as a doctest, at the least. For instance, perhaps you could think about documentation about the rationale for the approach and about the dance that this code participates in (with the lock files and all the possible SMTP error conditions and the code's responses). Of course, even more friendly docs than that would be nice, but I'm only asking for what I myself tend to give, unfortunately. A little does need adding there - I have scanned state machine diagrams and the design rationale. I will go and put those in the checkin when I have a spare moment. Sounds like a great start. Thanks for your work. Gary ___ Zope-Dev maillist - Zope-Dev@zope.org 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 )
[ZWeb] wiki.zope.org
i found http://zope-org.hosting.amaze.nl:8100/wiki.zope.org/ by change through google. looks like the port is exposed, shouldn't there be an apache fronting the site? michael -- http://www.zope.org/Members/d2m http:/planetzope.org ___ Zope-web maillist - Zope-web@zope.org http://mail.zope.org/mailman/listinfo/zope-web
Re: [ZWeb] wiki.zope.org
There is an apache, but zope was listening on all ports. Michael showed me how to restrict it to 127.0.0.1, thanks guys. -Simon ___ Zope-web maillist - Zope-web@zope.org http://mail.zope.org/mailman/listinfo/zope-web
[Zope-DB] Help me.
Dear friends, I am using plone for deploying the website, but I have some problems such as: - Using relational (internal) database Gadfly database: I do not know where the database is stored in the Zope. Can I manipulate directly this database visual? - Users and groups: How to assign this permissions to my website. Could you show me how to implement that easily. Cheers, Cu Vinh Loc. ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Help me.
Cu Vinh Loc schrieb: Dear friends, I am using plone for deploying the website, but I have some problems such as: - Using relational (internal) database Gadfly database: I do not know where the database is stored in the Zope. Can I manipulate directly this database visual? - Users and groups: How to assign this permissions to my website. Could you show me how to implement that easily. Cheers, Cu Vinh Loc. ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db gadfly is stored in the var directory of your zope instance. however I belive it is not supported anymore. user and groups: in your instance go to confiration (using your browser to access a running plone). there you find users ang groups. for every object (a document, a folder) you can define who (what user/group) has what permission. this you do using the sharing tab. robert ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Help me.
--On 11. März 2008 22:13:29 +0700 Cu Vinh Loc [EMAIL PROTECTED] wrote: Dear friends, I am using plone for deploying the website, but I have some problems such as: - Using relational (internal) database Gadfly database: I do not know where the database is stored in the Zope. Please forget Gadfly. If you are seriously thinking about using a RDBMS for whatever reason then consider using a real database like Mysql, Postgres... There are various ways for interacting with a RDBMS in Zope: - using ZSQL methods (check THe Zope Book 2.7 edition RDBMS Chapter) - wrappers based on SQLAlchemy: collective.lead or z3c.sqlalchemy or ZSQLAlchemyDA -aj pgpiUtGRHbhWO.pgp Description: PGP signature ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Help me.
Am 11.03.2008, 16:13 Uhr, schrieb Cu Vinh Loc [EMAIL PROTECTED]: Dear friends, I am using plone for deploying the website, but I have some problems such as: - Using relational (internal) database Gadfly database: I do not know where the database is stored in the Zope. Can I manipulate directly this database visual? - Users and groups: How to assign this permissions to my website. Could you show me how to implement that easily. Dear Cu Vin Loc, you have simply reposted your e-mail to the Archetypes list this morning apparently without looking at the documentation I suggested. While you are reading up on the basics of using Zope and relational databases it might be an idea to let us know exactly what you want to do. As a kick-start on using Zope you might also wish to look at my presentation at EuroPython last year. It covers the very basics of using ZSQL in Zope and there is a download with code for your to play with. http://www.egenix.com/library/presentations/EuroPython2007-Zope-and-RDBMS/ Good luck! Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com/ Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48 D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg Registered at Amtsgericht Duesseldorf: HRB 46611 ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db