January 1999 - Zope - Zope lists

- Zope/ODBC and MS Sql Server 6.5 connection
by Kiss, Arpad 06 Jan '99

06 Jan '99

Hi! I couldn't connect to Sql Server 6.5 too. I looked at db.py (line 160-164 contains the important things) and ODBC log file and I found that: * the Zope uses SQLConnect function. It has three parameters: DSN, UID and AuthStr * db.py uses string.split(connect string), so we have to type in the connect string: dsn userid password. I tested it with Oracle and Access ODBC driver and it works. * but it doesn't work with SQL Server 6.5 driver, because in this case SQLConnect returns SQL_SUCCESS_WITH_INFO (=1) instead of SQL_SUCCESS(=0) and I suppose Zope handles it as it returns SQL_ERROR(=-1). I have found this in the SQL Server 6.5 driver help: SQLConnect retrieves the value of the LANGUAGE keyword from the ODBC data source definition. If the SQL Server driver is unable to use the specified language, it uses the default language for the specified user ID, and SQLConnect returns SQL_SUCCESS_WITH_INFO. If SQL Server is unable to use the default language for the specified user ID, SQLConnect returns SQL_ERROR. SQLConnect retrieves the value of the DATABASE keyword from the ODBC data source definition. If the SQL Server driver is unable to use the specified database, it uses the default database for the specified user ID, and SQLConnect returns SQL_SUCCESS_WITH_INFO. If SQL Server is unable to use the default database for the specified user ID, SQLConnect returns SQL_ERROR. In the ODBC data source definition I set the LANGUAGE and DATABASE to the defaults of the specified user ID but it couldn't help. Perhaps there is someone out who can help us based on the above pice of information. Thanks in advanvce: ¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤ Kiss Árpád akiss(a)geometria.hu ¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤

1 0

RE: [Zope] - Problem with pcgi on FreeBSD 2.2.8/Python 1.5.1
by Jeff Bauer 06 Jan '99

06 Jan '99

> Zope.cgi > Bad system call (core dumped) > /* > // pcgiStartProc: manages starting a pcgi resource. > */ > #ifdef UNIX > int pcgiStartProc(pcgiResource *r) > { > > [ lots of code deleted.....] > > /* Make sure another wrapper isn't already doing a restart */ [ dies here.... ] > if ((r->lock=semget(101, 1, 0700 | IPC_CREAT | IPC_EXCL)) == -1) > > [ more code deleted .....] Steve, Can you send Brian Lloyd and me the FreeBSD man pages on semget and semctl? Or better yet, point us to a browsable man page site for FreeBSD. Best regards, Jeff Bauer Rubicon, Inc.

2 1

- Re: dtml syntax query
by Simon Michael 05 Jan '99

05 Jan '99

meant to cc the list. To: Tim Fraser Subject: RE: [Zope] - dtml syntax query > I wondered what the id[0:5] means? I can answer that.. :) This is python notation for "the first 5 characters of the id string". You can find more details on this notation in the python tutorial at www.python.org. > I want to insert a tag in a new page which will iterate through a number > of created "polls"(id's are p1,p2,p3...), all of which exist in one > folder and which will dynamically create a list of links. > > After reading the DTML User Guide I'm still unclear. The "in" tag seems > the correct choice. However I can't seem to arrive at the correct > syntax. I'll take a stab at this too.. there's more info on #in syntax in .../lib/python/DocumentTemplate/DT_In.py. Maybe these snippets will be of some help: A very simple list of hyperlinks to subobjects:  <A HREF=""></A><br>  No items  A tree, sorted by object id, listing only objects for which you have access rights. I use an #if statement to hide User Folders. You might need to adjust the HREF and TARGET:    <A HREF="/main" TARGET="main"></A>   -Simon

1 0

- Visual Demo
by Scott Robertson 05 Jan '99

05 Jan '99

A couple of days ago Paul was asking what format he should use if DC were to create a demo of Zope. I suggested Flash because it's small and runs on Win32/Mac/Linux. If you check out http://www.visio.com/products/enterprise/demos/index.html they have a bunch of online demos of their products in flash. So if you want to view these runover to www.macromedia.com download the flash plugin and check them out. Note: I'm not really sure how helpful an online demo of flash would really be, but I figured I'd point you in the right direction if you wanted to pursue that ave. --------------------------------------------------- - Scott Robertson Phone: 714.972.2299 - - CodeIt Computing Fax: 714.972.2399 - - http://codeit.com - ---------------------------------------------------

1 0

RE: [Zope] - fsimport sets mime type for .jpg, .gifs incorrectly
by Brian Lloyd 05 Jan '99

05 Jan '99

> Subject says it all. I used fsimport to load an existing web > site into a > new Zope "site". The .htm documents were correctly loaded, but all > images got flagged with "application/octet-...". > > I saw this also mentioned in the email archive, but no > resolution on that > thread yet. Note that this is an entirely unmodified fsimport. > > I was wondering if it's an fsimport issue, or a Zope issue. > Anyone else > seen this? I'm pretty sure this is related to a Zope bug I just fixed today. The fix will be in the next release. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

RE: [Zope] - Z RPC
by Jeffrey Shell 05 Jan '99

05 Jan '99

[mike] > Where can I find more information about Z RPC? I can find but one > tantalising reference on www.zope.org, and "fgrep -i rpc `find > Zope-1.9.0b3-src -name '*py'`" doesn't turn up a blessed line. Z RPC was formerly known as BCI (Bobo Call Interface). There are some tips on using it in the old Library on the Digital Creations site. Search for BCI http://www.digicool.com/site/Support/Library If grepping for RPC fails , try grepping for BCI instead. .jPS

2 1

- itemBrowse in collector
by Jeffrey Shell 05 Jan '99

05 Jan '99

After much frustration with trying to get the main reports in Collector to look decent at various window sizes from the legacy table thingy i was using, I've revamped the report into a new (more HTML/Resolution/Parser friendly) report, currently under the id "itemBrowse" http://www.zope.org/Collector/itemBrowse If recieved well, this will take over the old tableBrowse's job.

1 0

- Z RPC
by Mike Pelletier 05 Jan '99

05 Jan '99

Where can I find more information about Z RPC? I can find but one tantalising reference on www.zope.org, and "fgrep -i rpc `find Zope-1.9.0b3-src -name '*py'`" doesn't turn up a blessed line. Mike. -- --- | Mike Pelletier Work: 519-746-1607 /opeware! | Software Developer Home: 519-725-7710 --- | mike(a)zopeware.com Fax: 519-746-7566 http://www.zopeware.com | Zopeware is not endorsed by Digital Creations

1 0

- debugging notes (zope/python/emacs/windows)
by Simon Michael 05 Jan '99

05 Jan '99

Here are some rough notes from my recent zope debugging efforts - I hope that others will find them useful, or post corrections/improvements. - Environment: I am using NT Emacs and the cygwin bash shell on windows 98. So my paths generally have forward slashes. - I wanted to step through the code of an external method which was not working. So I tried debugging it with ZPublisher/Test.py, described in the zope docs. The command line I'm using now is: $Z/bin/python -i $Z/lib/python/ZPublisher/Test.py -d $Z/lib/python/Main /files/find_results python with the '-i' flag is required to get the interactive prompt in an emacs shell window. Also it ensures that I know exactly which version of python is being used. $Z is the path to my zope installation. /files/find_results is the url path to a DTML Document which calls my external method. - I could not set a breakpoint on my external method, apparently due to limitations of the standard pdb class. So I tried stepping right through zope's execution to that point, but it became clear that I needed a higher-level tool with good source display. So I explored various incarnations & versions of debugging tools: pdb, pydb, emacs modes, ddd. Eventually, I: - downloaded the latest python, 1.5.2b1. The pdb/bdb/cmd classes in this version incorporate various enhancements, in particular you can set a breakpoint in any file which is in your sys.path, as follows: pdb> import sys pdb> sys.path.append('/tools/zope/Extensions') pdb> b ExtranetFind.py:19 - running zope with the latest python gave warnings about API versions. Things were not working well at the time so for paranoia I copied the new pdb/bdb/cmd classes into zope's lib/python1.5 and used that. Either version seems to work fine aside from the warnings. - I downloaded the latest NT Emacs, 20.3.3.1.1. This fixed some problems, and has an up-to-date gud.el with pdb support. - I made a change to .../emacs/lisp/gud.el to get "M-x pdb" to work on windows: (defvar gud-pdb-marker-regexp "^> \$[-a-zA-Z0-9_/.:\\]*\\|<string>\$(\$[0-9]+\$)\$[a-zA-Z0-9_]*\\|\\?\$( )\$->[^\n]*\$?\n") ;fix for windows/dos pathnames - SKWM - I downloaded the latest python-mode.el from www.python.org - I added this in my ~/.emacs to match Test.py's altered pdb prompt (cosmetic fix): (add-hook 'pdb-mode-hook '(lambda () (setq comint-prompt-regexp "^pdb> *"))) ; for zope debugging - These made for a more convenient debug prompt: (eval-after-load "comint" '(define-key comint-mode-map "\M-p" 'comint-previous-matching-input-from-input)) (eval-after-load "comint" '(define-key comint-mode-map "\M-n" 'comint-next-matching-input-from-input)) (eval-after-load "comint" '(define-key comint-mode-map "\C-a" 'comint-bol)) (setq comint-input-ring-size 100) - NOW, I can step through zope in emacs with full source fontifying, etc (get help on the "gud-mode" function for keybindings). Type "M-x pdb", and at the "Run pdb" prompt enter the Test.py command line above. - In this situation, you can use "python -u" instead of "python -i" to skip the python prompt at the end of a run. -Simon

1 0

- how to validate access to an object, part 2
by Simon Michael 05 Jan '99

05 Jan '99

I'm close, but still not there. I'm sure it will turn out to be simple. Can any zope guru suggest a solution ? I wrote: > My search form uses an external method which is similar to > FindSupport.PrincipiaFind(). It has one problem - it lists [file objects] > for which the user does not have view permission. To recap, I want my find form/method to list only objects for which the user has view permission, like #tree does with the "skip_unauthorized" attribute. I saw that #in also has a skip_unauthorized attribute. So I tried using this in the dtml which displays the find results - no effect, it still lists all the file objects. Another dtml approach - in the results list I tried:  and this does raise an authorization error at the appropriate time (ie when listing an unauthorized object). I want to skip those objects, not cause an exception. So.. I've tried calling validate(), and I've tried calling careful_getattr in the find method, but only get TypeErrors and an unhelpful traceback. Debugging has been... an adventure.. :-\ I will send some notes on this. Here's the essence of my find method: def ExtranetFind(self, obj, obj_searchterm=None, obj_days=0, search_sub=0, REQUEST=None, result=None, pre=''): """extranet find function, based on PrincipiaFind""" ... base=obj if hasattr(obj, 'aq_base'): base=obj.aq_base ... for id, ob in base.objectItems(): # skip this object if user should not have access to it md=TemplateDict() md.validate = REQUEST.AUTHENTICATED_USER.validate try: d['getattr'](md,ob,'title') #<-- cannot find right syntax except: continue <check other search criteria> <append to results if match> -Simon

1 0