November 1999 - Zope

Sybase DA + FreeBSD + TDS
by Andrew Kenneth Milton 25 Nov '99

25 Nov '99

Ok I said I was going to get it to work, and damnit I did (well missing some non-crucial functionality like ct_diag() ), but, don't get excited yet because there is some bad news... You have to do some serious munging of the freetds codebase including copying over all the Sybase include files from the sybase distribution, as well as commenting out a lot of stuff from the SybaseAdapter (the Linux Sybase libraries I had didn't seem to be as up to date as the ones the Adapter was linked against). Because I actually had to use the Sybase files and alter them a bit, I don't think I'm going to be able to put up any code to help anyone out :-( I was really really hoping it might compile almost out of the box and I wouldn't have to compromise myself by looking at the Sybase files. It only took a few hours of hacking to pull the FreeTDS library into shape and about 30 mins to clean up the Sybase Adapter enough to get it to compile... So if you were wondering if it is possible, I can tell you that it is, but, with some non-trivial effort. -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm(a)theinternet.com.au|

2 1

Re: [Zope] ZODB Storage Error
by Anthony Baxter 25 Nov '99

25 Nov '99

>>> Jim Fulton wrote > > 1999-11-24T05:51:23 PANIC(300) ZODB An storage error occurred in the last > > phase of a two-phase commit. This shouldn't happen. The application may > > be in a hosed state, so we will not allow transactions to commit from here > Waaaa. This should include a traceback, but it doesn't. I wonder > if there is a bug in the logging machinery. Well, the above went to stdout - I can't find anything in any of the logs. > As the message indicates, this happens if an error occurs during > the final stage of a two-phase commit. If this happens, then database > integrity cannot be assured unless further writes are prevented. The only > case in which I've seen this happen is if the disk fills up. Could this be > happening to you? Nope - there's plenty of free space on the disk. Where should I start looking? I'm going to force the bit of the code that generated this error to spit out a traceback... Anthony -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

2 1

Zope Weekly News
by Mike Pelletier 25 Nov '99

25 Nov '99

G'day, Zope Weekly News is a digest of some of the useful and interesting events which have occurred on the various Zope mailing lists and the Zope.org site. It is published each Wednesday evening. New Products and Announcements * "jwashin" released ZRTChat, an entirely ZClass real-time chat object. No java or javascript! http://www.zope.org/Members/jwashin/ZRTChat * The new Sybase Database Adapter has been released. It has been completely rewritten. http://www.zope.org/Products/DA/SybaseDA * "tseaver" submitted an internationalisation ZClass. It contains a set of translations of a document and serves the correct language to the user. http://www.zope.org/Members/tseaver/ZI18N * "Zen" has released GenericUserFolder, which seems to allow you to mix and match authentication methods to suit your needs. GenericUserFolder is very much beta, and not to be used on production sites. http://www.zope.org/Members/Zen/GenericUserFolder Updates * "anthony" released an update of his SQL Session product. SQL Session provides SQL database-based session objects, keyed to browser cookies. Unlike the previous update, this one does not break existing SQL Session objects. http://www.zope.org/Members/anthony/software/SQLSession * "rossl" has updated the LDAPAdapter product, which allows you to authenticate web users with an LDAP server. http://www.zope.org/Members/rossl/LDAPAdapter_0.7 * Itmar Shtull-Trauring has released v0.3 of ZCache. http://www.zope.org/Members/itamar/ZCache Zope.org items * "AlexR" posted a How-To about using ZCatalog's keyword index facility. A keyword index is something halfway between a text index and a field index-- it is a list of values which are treated atomically. http://www.zope.org/Members/AlexR/KeywordIndexes * Brian Lloyd has submitted a patch for Apache which allows you to use WebDAV with Zope through Apache. Normally Apache intercepts the HTTP OPTIONS request. With this patch, the request gets passed to Zope so it can offer WebDAV services. http://www.zope.org/Members/Brian/Misc/mod_cgi_webdav_patch.html * "Earthtone" wrote a mini-review of the Zope coverage in a new book, "The Quick Python Book". http://www.zope.org/Members/Earthtone/news-zope_chapter Notable Discussions * Sachin Shah wrote in to suggest that the Properties management view should include each of the property's type. Martijn Faassen agreed and suggested including the ability to change property types. Evan Simpson pulled a property-type-changer out of a hat! Oleg Broytmann suggests cut/copy/paste support. http://www.zope.org/pipermail/zope/1999-November/014379.html * "Chas" asked for advice selecting an OS for his Zope server. He will be using it with an Oracle server on another machine, and so the operating system must be supported by Oracle. Suggestions so far: Linux and Sun Sparc and FreeBSD with Linux emulation. No one has verified whether FreeBSD, Chas's preference, would actually work. http://www.zope.org/pipermail/zope/1999-November/014366.html * "Milt" wants to move a Zope server from a Windows machine to a Linux one. He solicited advice for accomplishing this. Solution: copy var/Data.fs from one machine to the other. It is platform-independent. http://www.zope.org/pipermail/zope/1999-November/014359.html * Ross Boylan gives us a heads-up on a bug in Zope Products. It seems that a failure in Product registration (ie, in the Product's __init__.py file) can cause Zope to misreport an old error, leading to the occasional headache. http://www.zope.org/pipermail/zope/1999-November/014340.html * Alexander Limi is understandably concerned about sending cleartext passwords over the Internet when authenticating Zope users and managers. Christopher Petrilli offers some solutions. http://www.zope.org/pipermail/zope/1999-November/014339.html * Jason Jone kicked off a brisk discussion of FastCGI and Zope. The verdict: to get full functionality, you have to use a snapshot (prerelease) of version 2.2.3 of mod_fastcgi. Using prerelease code made some people uncomfortable. This will change when 2.2.3-final is released. http://www.zope.org/pipermail/zope/1999-November/014254.html See also, doc/WEBSERVER.txt of the Zope CVS -- Mike Pelletier.

1 0

User access / acl_users
by Alexander Limi 24 Nov '99

24 Nov '99

Hi. In the neverending series of questions from me, I give you another: Is both the userdb and GenericUserFolder compatible with the original acl_users? I.e, can I develop my site with the basic acl_users functionality, and add one of the two products later on? Or should I start using one of those products right away? I need cookie authentication, but I don't think I understand enough Zope yet to see the big picture, security-wise. And the documentation for GenericUserFolder isn't exactly stunning (not from the newbie spot atleast, no offence :) I would like to concentrate on the main functionality of my site, and add this functionality when my zope zen is a bit better. I'm not doing a horrible mistake thinking that way? Regards, Alexander Limi

2 1

arrays in sql methods and dtml-in
by Dennis Moore 24 Nov '99

24 Nov '99

I have a document with a checkbox group in it. This group corresponds to an array in my Postgres database. So, for example, the user does this: Letters: [ ] A [x] B [ ] C [x] D Then my dtml method gets: ['B', 'D'] which i would like to insert into my database. In Postgres, a normal array insertion looks like: insert into foo (letters) values ('{"B", "D"}'); so i tried this: <dtml-with REQUEST> INSERT INTO foo ( letters ) VALUES ( <dtml-in letters> <dtml-if sequence-start> '{ </dtml-if> "<dtml-sqlvar sequence-item type=string>" <dtml-if sequence-end> '} </dtml-if> <dtml-else> null </dtml-in> ) </dtml-with> This gives me the error: Error Type: InError Error Value: Strings are not allowed as input to the in tag. Traceback (innermost last): File /local/zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /local/zope/lib/python/ZPublisher/Publish.py, line 179, in publish File /local/zope/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook (Object: ElementWithAttributes) File /local/zope/lib/python/ZPublisher/Publish.py, line 165, in publish File /local/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: PerformSignup) File /local/zope/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: PerformSignup) File /local/zope/lib/python/OFS/DTMLMethod.py, line 145, in __call__ (Object: PerformSignup) File /local/zope/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: PerformSignup) File /local/zope/lib/python/DocumentTemplate/DT_In.py, line 691, in renderwob (Object: getuser) File /local/zope/lib/python/Shared/DC/ZRDB/DA.py, line 395, in __call__ (Object: sqlUserInsert) File /local/zope/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: <string>) File /local/zope/lib/python/DocumentTemplate/DT_With.py, line 148, in render (Object: REQUEST) File /local/zope/lib/python/DocumentTemplate/DT_In.py, line 641, in renderwob (Object: software) InError: (see above) When I initially had just <dtml-sqlvar letters type=string> I got the content of letters, but it wasn't in the proper format for Postgres. Now it seems like I can't get the elements of 'letters' or something. Has anyone used Postgres arrays with Zope and has a better way of doing this? Or at least one works? (= -- pity this busy monster, manunkind, | Dennis Moore | Sarah not. Progress is a comfortable disease. | rainking(a)frenzy.com | McLachlan -e.e. cummings: One Times One | archon on the irc | "Black" If I cried me a river of all my confessions would I drown in my shallow regret?

2 1

RE: [Zope] odbc database adapter ... problem with "like"
by Clarence T. Pate 24 Nov '99

24 Nov '99

> |>Use % instead of the asterisk: > |>where NAME like 'Pate%' > > MS Access in it's infinite wisdom decided to go against the convention of > using '%' as a wildcard and decided to use '*', so the SQL is correct for > Access. >You are of course right concerning Access' use of >wildcards. But in >ZSQL-Methods only the '%' gives me the expected results - >the '*' as >wildcard will be ignored. I use Access 97 as database and >ODBC 4.00. Thomas, Thanks! "%" as the wilcard did the job. Clarence T. Pate

1 0

Browsing Local File System with a ZOPE-like Interface
by Kevin Howe 24 Nov '99

24 Nov '99

I'd like to create a standalone python program which browses the hard drive of a server using the ZOPE Content Manager style interface. (Expandable Menus on the left, contents on the right, etc.) Does ZOPE separate the Content Manager functions into a module(s) which could be taken and dropped into a standalone application such as this? Thanks KH

1 0

HAPPY THANKSGIVING TO ALL!
by Theodore Patrick 24 Nov '99

24 Nov '99

Zope & All, Thanks for the code and all the trimmings (Plus the Recipe!)! Have a wonderful Thanksgiving! Keep up the great work! Theodore E. Patrick Ishophere.com - Where do you shop?

1 0

Tree ordering?
by Art Hampton 24 Nov '99

24 Nov '99

How do you (assuming you can) control the ordering of a tree? For example, in the QuickStart, lets say that I wanted to move Database Integration below Application Development. Can I do that? If so, how? Thanks for any help.

3 2

ZODB Storage Error
by Anthony Baxter 24 Nov '99

24 Nov '99

Several times lately, we've seen our development Zope server (running CVS of a few days ago) go into a mode where all requests return back this: Error Type: TransactionError Error Value: A serious error, which was probably a system error, occurred in a previous database transaction. This application may be in an invalid state and must be restarted before database updates can be allowed. Beware though that if the error was due to a serious system problem, such as a disk full condition, then the application may not come up until you deal with the system problem. See your application log for information on the error that lead to this problem. The only thing in the log is this: 1999-11-24T05:51:23 PANIC(300) ZODB An storage error occurred in the last phase of a two-phase commit. This shouldn't happen. The application may be in a hosed state, so we will not allow transactions to commit from here on How can I debug this further??? Help? Anthony

2 1