- Zope - Zope lists

RE: [Zope] FYI: Weekly Product Updates (2003/06/02)
by baiewola＠netscape.net 02 Jun '03

02 Jun '03

I love your "newsletter." Thanks for doing this. Baie Maik Jablonski <maik.jablonski(a)uni-bielefeld.de> wrote: >Hi, > >14 third-party-Zope-products changed in the last week. Here they are... > >Cheers, Maik > > >Product-Updates (2003/05/26 - 2003/06/02) > >AixtraTable >----------- >Version: current snapshot >Creator: perry >Updated: 2003/06/02 05:06:28.1077 GMT-4 >http://www.zope.org/Members/perry/AixtraTable > > >Epoz - a cross-browser-wysiwyg-editor for Zope >---------------------------------------------- >Version: 0.2.2 >Creator: mjablonski >Updated: 2003/05/28 13:16:10.5956 GMT-4 >http://www.zope.org/Members/mjablonski/Epoz > > >Honeyd Control Center >--------------------- >Version: 1.1 >Creator: Ioan >Updated: 2003/06/02 02:49:25.5759 GMT-4 >http://www.zope.org/Members/Ioan/HoneydCenter > > >KZMailman: Zope - Mailman integration >------------------------------------- >Version: 0.1.1 >Creator: khcarlso >Updated: 2003/05/27 14:05:09.13806 GMT-4 >http://www.zope.org/Members/khcarlso/KZMailman > > >MemoryCache >----------- >Version: v0.9 >Creator: leper >Updated: 2003/06/01 07:23:34.748 GMT-4 >http://www.zope.org/Members/leper/MemoryCache > > >SQL Forms >--------- >Version: 3.4 >Creator: Ioan >Updated: 2003/05/30 06:32:19.2576 GMT-4 >http://www.zope.org/Members/Ioan/SQLForms > > >SQL Forms Reporter >------------------ >Version: 3.4 >Creator: Ioan >Updated: 2003/05/30 06:38:14.3321 GMT-4 >http://www.zope.org/Members/Ioan/SQLFormsReporter > > >ZPhotoSlides >------------ >Version: 1.1b >Creator: p3b >Updated: 2003/05/31 09:56:44.8182 GMT-4 >http://www.zope.org/Members/p3b/ZPhotoSlides > > >ZWiki >----- >Version: 0.19.0 >Creator: simon >Updated: 2003/06/01 20:00:49.9523 GMT-4 >http://www.zope.org/Members/simon/ZWiki > > >Jsp for Zope >------------ >Version: 1.5 >Creator: Ioan >Updated: 2003/05/30 07:00:55.7635 GMT-4 >http://www.zope.org/Members/Ioan/ZopeJsp > > >ZopeTree >-------- >Version: 1.3 >Creator: philikon >Updated: 2003/05/30 18:30:31.6546 GMT-4 >http://www.zope.org/Members/philikon/ZopeTree > > >Zope SAP DB Database Adapter >---------------------------- >Version: 0.3 >Creator: jack-e >Updated: 2003/05/30 08:36:20.2944 GMT-4 >http://www.zope.org/Members/jack-e/ZsapdbDA > > >ZClass Based Message Board Product >---------------------------------- >Version: 1.0.3 and 1.1.3 (Zope 2.6.1) >Creator: speedbird >Updated: 2003/05/27 19:45:42.5282 GMT-4 >http://www.zope.org/Members/speedbird/fcForum > > >htmlArea for Zope >----------------- >Version: 0.2.5 >Creator: to_be >Updated: 2003/05/30 12:55:50.9965 GMT-4 >http://www.zope.org/Members/to_be/htmlarea > > > >_______________________________________________ >Zope maillist - Zope(a)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 ) > __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455

1 0

Postgress and zope...
by Jerry Westrick 02 Jun '03

02 Jun '03

dear ladies and sirs: I'm about to install nmy second Zope installation, and wish to know if any one has any hints and/or tips on installing postgress sql with zope. In my first installation is had a real tough time getting the 2 to work. I was thinking about using all the standard SuSE 8.2 versions... Which postgress package should/could I use? and how dificult are they to install and get working? Jerry Wewtrick

2 1

RE: [Zope] setting null date in SQL-resolved
by Kelley, Sean 02 Jun '03

02 Jun '03

Thanks for your help- I realized that if I put this in the form input statement null="" then it all worked out. -----Original Message----- From: McDonnell, Larry [mailto:lmcdonnell@protonenergy.com] Sent: Monday, June 02, 2003 7:06 AM To: Kelley, Sean; 'zope(a)zope.org' Subject: RE: [Zope] setting null date in SQL Hi, I can do this to an MS Access DB: <dtml-if mea_creation_date><dtml-if "mea_creation_date==''">NULL<dtml-else> <dtml-sqlvar mea_creation_date type=string></dtml-if><dtml-else>NULL</dtml-if> -----Original Message----- From: Kelley, Sean [mailto:SKelley@ci.santa-rosa.ca.us] Sent: Friday, May 30, 2003 5:06 PM To: 'zope(a)zope.org' Subject: [Zope] setting null date in SQL I cannot seem to set date to NULL in MS SQL with INSERT but it seems to work on UPDATE with this code: Insert sets date to 1/1/1900 <dtml-if "AppDelDate==''"> AppDelDate=NULL, <dtml-else> '<dtml-var name="AppDelDate" sql_quote>', </dtml-if> Trying this request to the group again since I have not found a solution. Sean _______________________________________________ Zope maillist - Zope(a)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 )

1 0

RE: [Zope] Zope, COM and Outlook
by Igor Leturia 02 Jun '03

02 Jun '03

I tried your suggestion, but this time it says "Error Type: com_error, Error Value: (-2146959355, 'Error en la ejecuci\xf3n de servidor', None, None)" (in English it would be something like "Error executing server"). The traceback is the same as before. Igor > >Try this: > # Create instance of Outlook > pythoncom.CoInitialize() ### Added > o = win32com.client.Dispatch("Outlook.Application") > > >----- Original Message ----- >From: "Igor Leturia" <IGOR(a)emun.com> >To: <zope(a)zope.org> >Sent: Wednesday, May 28, 2003 5:49 PM >Subject: [Zope] Zope, COM and Outlook > > > Hi all! > > I need to obtain someone's e-mail address from Outlook's default >address book. I found a piece of python code in the internet which I >modified, and it now looks like this: > >import codecs, win32com.client > >def obtainaddress(name): > # Create instance of Outlook > o = win32com.client.Dispatch("Outlook.Application") > mapi = o.GetNamespace("MAPI") > folder = >mapi.GetDefaultFolder(win32com.client.constants.olFolderContacts) > print folder.Item("Igor Leturia").Address > o = None > >obtainaddress('Igor') > > The code needs win32com, so I installed ActivePython and copied the >win32com folder to Zope's lib. I tested the code in Zope's >python and it >works. > > But as I need to access it from Zope, I included the function in one >of the Zope source modules (User.py to be precise). And when I call it >from DTML, it gives me an error: > >Error Type: com_error >Error Value: (-2147221008, 'CoInitialize not called.', None, None) > > I've put some traces and I know the error is in the first line, o = >win32com.client.Dispatch("Outlook.Application"). > > Any ideas? Thanks in advance, > >Igor Leturia > >P.S.: Zope's traceback says: > >Traceback (innermost last): > File C:\Zope\lib\python\ZPublisher\Publish.py, line 150, in >publish_module > File C:\Zope\lib\python\ZPublisher\Publish.py, line 114, in publish > File C:\Zope\lib\python\Zope\__init__.py, line 159, in >zpublisher_exception_hook > (Object: Zope) > File C:\Zope\lib\python\ZPublisher\Publish.py, line 98, in publish > File C:\Zope\lib\python\ZPublisher\mapply.py, line 88, in mapply > (Object: AAAAA) > File C:\Zope\lib\python\ZPublisher\Publish.py, line 39, in >call_object > (Object: AAAAA) > File C:\Zope\lib\python\OFS\DTMLMethod.py, line 130, in __call__ > (Object: AAAAA) > File C:\Zope\lib\python\DocumentTemplate\DT_String.py, line 473, in >__call__ > (Object: AAAAA) > File C:\Zope\lib\python\DocumentTemplate\DT_Util.py, line >159, in eval > (Object: acl_users.getUser('IGOR').getMail()) > (Info: acl_users) > File <string>, line 2, in f > File C:\Zope\lib\python\AccessControl\User.py, line 299, in getMail > File C:\Archivos de >programa\Python21\Lib\site-packages\win32com\client\__init__.py, line >92, in Dispatch > File C:\Archivos de >programa\Python21\Lib\site-packages\win32com\client\dynamic.py, > line 81, >in _GetGoodDispatchAndUserName > File C:\Archivos de >programa\Python21\Lib\site-packages\win32com\client\dynamic.py, > line 72, >in _GetGoodDispatch >com_error: (see above) > > >

2 1

Error on ZDataQueryKit
by ratem＠censanet.com.br 02 Jun '03

02 Jun '03

Hi, I am using ZDataqueryKit on Zope233, runnning on a Conectiva Linux box. I have already some queries working but when I try to run a stored procedure call I got the error below. Since other queries are working I don't think it is a configuration problem. Also, the procedure runs without problems on the W2K machine. Any hint? The error: Z ODBC Client at /fdrNotas/odbcNotas Error, exceptions.AttributeError: currentColumn SQL used: {CALL consultaNotas(293482)} Traceback (innermost last): File /usr/local/zope-2.3.3/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /usr/local/zope-2.3.3/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/zope-2.3.3/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: odbcNotas) File /usr/local/zope-2.3.3/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/zope-2.3.3/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_test) File /usr/local/zope-2.3.3/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_test) File /usr/local/zope-2.3.3/lib/python/Shared/DC/ZRDB/DA.py, line 396, in manage_test (Object: odbcNotas) File /usr/local/zope-2.3.3/lib/python/Shared/DC/ZRDB/DA.py, line 374, in manage_test (Object: odbcNotas) File /usr/local/zope-2.3.3/lib/python/Products/ZDataQueryKit/ZODBCClient.py, line 217, in __call__ (Object: odbcNotas) File /usr/local/zope-2.3.3/lib/python/Products/ZDataQueryKit/OSSClient.py, line 70, in __init__ File /usr/local/zope-2.3.3/lib/python/Products/ZDataQueryKit/OSSClient.py, line 126, in cdata AttributeError: (see above) ------------------------------------------------- E-mail enviado pelo Webmail CensaNET http://www.censanet.com.br/webmail

1 0

Error on Tutorial
by Francis 02 Jun '03

02 Jun '03

Zope 2.6.1 run on Solaris 8 with Python 2.2. Test and Manage Ok. When I try to install the tutorial, Zope send this error : Error Type: Bad Request Error Value: The ZGadflyDA product must be installed! The ZGadflyDA product is in the list under Product Management at /Control_Panel/Products On my PC it work's fine What's wrong? Francis

2 1

RE: [Zope] setting null date in SQL
by McDonnell, Larry 02 Jun '03

02 Jun '03

Hi, I can do this to an MS Access DB: <dtml-if mea_creation_date><dtml-if "mea_creation_date==''">NULL<dtml-else> <dtml-sqlvar mea_creation_date type=string></dtml-if><dtml-else>NULL</dtml-if> -----Original Message----- From: Kelley, Sean [mailto:SKelley@ci.santa-rosa.ca.us] Sent: Friday, May 30, 2003 5:06 PM To: 'zope(a)zope.org' Subject: [Zope] setting null date in SQL I cannot seem to set date to NULL in MS SQL with INSERT but it seems to work on UPDATE with this code: Insert sets date to 1/1/1900 <dtml-if "AppDelDate==''"> AppDelDate=NULL, <dtml-else> '<dtml-var name="AppDelDate" sql_quote>', </dtml-if> Trying this request to the group again since I have not found a solution. Sean _______________________________________________ Zope maillist - Zope(a)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 )

1 0

FYI: Weekly Product Updates (2003/06/02)
by Maik Jablonski 02 Jun '03

02 Jun '03

Hi, 14 third-party-Zope-products changed in the last week. Here they are... Cheers, Maik Product-Updates (2003/05/26 - 2003/06/02) AixtraTable ----------- Version: current snapshot Creator: perry Updated: 2003/06/02 05:06:28.1077 GMT-4 http://www.zope.org/Members/perry/AixtraTable Epoz - a cross-browser-wysiwyg-editor for Zope ---------------------------------------------- Version: 0.2.2 Creator: mjablonski Updated: 2003/05/28 13:16:10.5956 GMT-4 http://www.zope.org/Members/mjablonski/Epoz Honeyd Control Center --------------------- Version: 1.1 Creator: Ioan Updated: 2003/06/02 02:49:25.5759 GMT-4 http://www.zope.org/Members/Ioan/HoneydCenter KZMailman: Zope - Mailman integration ------------------------------------- Version: 0.1.1 Creator: khcarlso Updated: 2003/05/27 14:05:09.13806 GMT-4 http://www.zope.org/Members/khcarlso/KZMailman MemoryCache ----------- Version: v0.9 Creator: leper Updated: 2003/06/01 07:23:34.748 GMT-4 http://www.zope.org/Members/leper/MemoryCache SQL Forms --------- Version: 3.4 Creator: Ioan Updated: 2003/05/30 06:32:19.2576 GMT-4 http://www.zope.org/Members/Ioan/SQLForms SQL Forms Reporter ------------------ Version: 3.4 Creator: Ioan Updated: 2003/05/30 06:38:14.3321 GMT-4 http://www.zope.org/Members/Ioan/SQLFormsReporter ZPhotoSlides ------------ Version: 1.1b Creator: p3b Updated: 2003/05/31 09:56:44.8182 GMT-4 http://www.zope.org/Members/p3b/ZPhotoSlides ZWiki ----- Version: 0.19.0 Creator: simon Updated: 2003/06/01 20:00:49.9523 GMT-4 http://www.zope.org/Members/simon/ZWiki Jsp for Zope ------------ Version: 1.5 Creator: Ioan Updated: 2003/05/30 07:00:55.7635 GMT-4 http://www.zope.org/Members/Ioan/ZopeJsp ZopeTree -------- Version: 1.3 Creator: philikon Updated: 2003/05/30 18:30:31.6546 GMT-4 http://www.zope.org/Members/philikon/ZopeTree Zope SAP DB Database Adapter ---------------------------- Version: 0.3 Creator: jack-e Updated: 2003/05/30 08:36:20.2944 GMT-4 http://www.zope.org/Members/jack-e/ZsapdbDA ZClass Based Message Board Product ---------------------------------- Version: 1.0.3 and 1.1.3 (Zope 2.6.1) Creator: speedbird Updated: 2003/05/27 19:45:42.5282 GMT-4 http://www.zope.org/Members/speedbird/fcForum htmlArea for Zope ----------------- Version: 0.2.5 Creator: to_be Updated: 2003/05/30 12:55:50.9965 GMT-4 http://www.zope.org/Members/to_be/htmlarea

2 1

Re: [Zope] Backing up Data.fs
by Toby Dickenson 02 Jun '03

02 Jun '03

On Monday 02 June 2003 12:48, Peter Sabaini wrote: > Toby Dickenson wrote: > > On Monday 02 June 2003 10:18, Peter Sabaini wrote: > > Think > > of backup as a database operation - this script has no ACID. > > please explain -- why would i need transactions and concurrency with a > backup script? Suppose this morning (Monday) the machine locks up (or power failure, or network loss if this is on a network mount, etc) immediately after this backup script has terminated. Some, but not all of the changes to /archive/monday/data.fs will have been written to disk, and some will have been lost. There is every chance that todays backup has been mashed together with the backup from last weeks monday in some arbitrarily confusing way. There is no new backup, and the old backup has been destroyed. Sure, if this happens only once then this script leaves you with six other good daily copies. But during a disaster recovery is the worst possible time to have to be thinking about which "backup" directory contains a data.fs that has recently been destroyed by a non-transactional backup script. Sean Upton talks about disaster-prepardness here: http://zope.nipltd.com/public/lists/zope-archive.nsf/AGByKey/6036CE8DFC2D34… This "bug" can be fixed for FileStorage backup scripts, check out the link I posted earlier. The cost is in performance. > > for local backups (like this script) > > rsync > > cant beat "cp". > > not that i have any numbers to back this up but i think that just > copying the difference of two similar Data.fs's can be advantageous with > large files -- of course this will really only make a difference if the > backup is to a network mount or something like that. In the form used in that script, rsync has to read the whole of both the source file and orgininal version of the destination file, then write the changes. There is no way it can beat cp on network traffic when the destination is a network mount. It only has a chance of winning in I/O terms too if your archive is on something like raid5, where writes are very much more expensive than reads rsync over ssh is different. > > I strongly recommend DirectoryStorage if you want to keep daily backups > > like this. It has a standard tool for creating local incremental backups > > as tar files, or synchronising a remote replica of the storage. These > > tools are ACID, and efficient. Unlike all the home-brew FileStorage > > schemes I have seen. > > DirectoryStorage sounds great if you have the requirements, but for > simpler sites (or sites which host their data in an RDBMS anyway) > FileStorage is just ok. Sure. FileStorage is ideal for sites that either: 1. can afford the IO and storage costs of robust backup scripts like the one I posted a link to earlier. 2. can stick with manually scheduled backups, not automated backups. -- Toby Dickenson http://www.geminidataloggers.com/people/tdickenson

2 2

Re: [Zope] Problem with cursor
by Troy Farrell 02 Jun '03

02 Jun '03

Please keep your replies on the list so others can help and the discussion is archived. Knowing that the call works if called just once on a page verifies that the bug is with ZODBCDA not moving the cursor as it ought (or not caching the results...) If you must host on W2k, look at the eGenix solution. Troy Antonio Carlos Bortoletto wrote: > I will read these links.. thanks . .. you are helping me very. . > . . . but. . .answering its pergunta: yes. . .'my_query' work if it is > called only once int that page.. . > This file (with the querys) was running in linux, with ODBC driver of sybase > . . . and this error did not exist.. . . > but, now, it´s running in Windows2000. . with ODBC driver of microsoft. .. > > ----- Original Message ----- > From: "Troy Farrell" <troy(a)entheossoft.com> > To: "Antonio Carlos Bortoletto" <antonio.bortoletto(a)websolucoes.com.br> > Cc: "Zope" <Zope(a)zope.org> > Sent: Tuesday, May 27, 2003 4:56 PM > Subject: Re: [Zope] Problem with cursor > >>That is the traceback we need. Unfortunately, I can't make much sense >>of it. Does 'my_query' work if it is called only once in that page? >> >>After a little bit of google searching, I've found two things: >> >>1) http://mail.zope.org/pipermail/zope/2000-January/101259.html >> >>ZODBCDA has been doing this for a long time and no one has posted any >>(easily located) fixes. >> >>2) http://www.zope.org/Products/DA/ZODBCDA >> >>ZODBCDA is free, but is old and hasn't been updated/bugfixed. It is a >>binary release, but is licensed ZPL - unusual. I wonder if the creator >>would release source for this... >> >>The other options I see would be to use freeTDS on a *nix system or >>purchase eGenix.com's mxODBC Zope DA. >> >>Troy

2 1