November 1999 - Zope

Re: [Zope] ODBC - 1 step forward - woops I tripped
by Thomas B. Passin 16 Nov '99

16 Nov '99

From: rgines(a)purina.com <rgines(a)purina.com> Could there be a file permissions issue? I'm not up on NT file permissions, but maybe the text file just has the wrong permissons. Anyway, I'd just go directly to one of your DB2 databases. I often have trouble getting those Jet drivers working right on the fly, but I never had a problem with SQLAnywhere. Cold Fusion requires the ODBC datasource to be set up as a "system" datasource. The ODBC default, however, is a "user" datasource. Maybe on NT Zope needs to see a system rather than a user odbc datasource. You can test that out easily. Tom Passin <dtml-snip> >to go directly to the connection. When I pointed to the ZSQL Method the >'__len__' error >disappeared but I am back to the error > >Error Type: sql.error > Error Value: ('S1000', -1032, "[Microsoft][ODBC Text Driver] The >Microsoft Jet > database engine cannot open the file 'ZopeTest.txt'. It is >already opened exclusively > by another user, or you need permission to view its data.") > >... I may just jump in feet first and try to connect to the DB2 >databases anyway. > >Thanks for setting me straight on where to point my Method. > </dtml-snip>

1 0

RE: Zope digest, Vol 1 #507 - 71 msgs
by Dan Pierson 16 Nov '99

16 Nov '99

> From: Jochen Haeberle <listen(a)MIDRAS.de> > Subject: Re: [Zope] Zope Init script? > > At 14:22 Uhr -0700 12.11.1999, Adrian Esteban Madrid wrote: > >Does anybody have an init script that will work with > Zope.2.0.1.src? I'm > >a Linux starter and for the light of my heart I can't get > Zope to start > >automatically. > > Hi, > > I have the same problem. Although the "start" script is there and > works all right, > it is by no mean a way for the Sys V Init... > > Did you get a solution to your problem, yet? > > Anyone else out there who could help us??? > > Jochen Here's what I'm using currently: #!/bin/sh # # Startup script for the Zope ZServer # # chkconfig: 345 85 15 # description: ZServer is a specialized Web server for use with Zope \ # it supports HTTP, FTP and Medusa monitoring connections. # processname: /home/zope/bin/python /home/zope/z2.py # pidfile: /home/zope/var/Z2.pid # lockfile: /home/zope/var/Data.fs.lock # Source function library. . /etc/rc.d/init.d/functions # See how we were called. case "$1" in start) echo -n "Starting zserver: " /home/zope/start echo # Lockfile maintained by start script # touch /var/lock/subsys/httpd ;; stop) echo -n "Shutting down http: " /home/zope/stop echo ;; status) status /home/zope/bin/python ;; restart) $0 stop $0 start ;; reload) echo -n "Reloading zserver by restarting it: " $0 stop $0 start echo ;; *) echo "Usage: $0 {start|stop|restart|reload|status}" exit 1 esac exit 0

1 0

RE: [Zope] Getting user roles
by Michel Pelletier 16 Nov '99

16 Nov '99

> -----Original Message----- > From: Daniel G. Rusch [mailto:drusch@globalcrossing.com] > Sent: Tuesday, November 16, 1999 11:38 AM > To: zope(a)zope.org > Subject: [Zope] Getting user roles > > > We are trying to get all the user roles for a given user (someone). > > we tried this: > > <dtml-var "acl_users.get_local_roles_for_userid('someone')"> > > all it does is returns an empty set. > > P.S. Someone does exist and someone does have roles. > > Any thoughts, <dtml-var "AUTHENTICATED_USER.getRoles()"> -Michel

3 2

Zope 2.1.0 beta 2 has been released
by Brian Lloyd 16 Nov '99

16 Nov '99

Hi all, Zope 2.1.0 beta 2 has been released. This release includes fixes for issues found in beta 1, an updated load_site.py script and Martijn Pieters' patches to implement try/except/else and try/finally constructs in DTML. Unless something major comes up, this will be the final beta before 2.1.0 final. You can download binary and source distribution of Zope 2.1.0 beta 2 from the Zope.org website: http://www.zope.org/Products/Zope/2.1.0b2/ Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

Re: [Zope] ODBC - 1 step forward - woops I tripped
by rgines＠purina.com 16 Nov '99

16 Nov '99

>I tested this exact syntax on my system and it worked perfectly. I'm running >Zope 2.01 on Windows95. My database is SQLAnywhere version 5. I am running a >4-user server database engine. The query returned the column requested by my >select statement. That's good to know. Thenks for checking my syntax. >Forgive me for asking, but did you create a ZSQL method in addition to the >connection? The "ZopeODBCTest" in your example must be the ZSQL method, not the >ZODBC Connection. The method contains your select statement. Well that was stupid used trip number one. For some reason I was thinking that I needed to go directly to the connection. When I pointed to the ZSQL Method the '__len__' error disappeared but I am back to the error Error Type: sql.error Error Value: ('S1000', -1032, "[Microsoft][ODBC Text Driver] The Microsoft Jet database engine cannot open the file 'ZopeTest.txt'. It is already opened exclusively by another user, or you need permission to view its data.") It is possible that the MS ODBC code is buggy .... naw I'm sure that could never be the problem ... must be me. I had hoped that trying to 'learn' the ODBC issues in Zope/Python would be simplest with a txt file. I may just jump in feet first and try to connect to the DB2 databases anyway. Thanks for setting me straight on where to point my Method.

1 0

Re: [Zope] ODBC - 1 step forward - woops I tripped
by Thomas B. Passin 16 Nov '99

16 Nov '99

From: rgines(a)purina.com <rgines(a)purina.com> <dtml-excerpt> >My client runs IBMs' UDB 5 database engine on OS/2 Servers with >NT clients (their choice not mine). I'm a newbie with Zope and wanted to >understand the ODBC very well before trying to tie into UDB5 (since >my guess is that I am the first one stupid enough to try this). > >So I started with something real simple. A text file with four columns >and three records. > >I can create an ODBC connection through Zope with no problem. >Going to the browse tab in the management screen actually >shows me the table with the column definitions ... so I am getting >from Zope, through the ODBC connector, through the WinNT >ODBC drivers to the text file. Cool! > >======= > >Now to do real work, I create a DTML Method with the following > >  > > .... > > <dtml-in ZopeODBCTest> > <dtml-var LAST_NAME> > </dtml-in> > >  I tested this exact syntax on my system and it worked perfectly. I'm running Zope 2.01 on Windows95. My database is SQLAnywhere version 5. I am running a 4-user server database engine. The query returned the column requested by my select statement. Forgive me for asking, but did you create a ZSQL method in addition to the connection? The "ZopeODBCTest" in your example must be the ZSQL method, not the ZODBC Connection. The method contains your select statement. Tom Passin > > >Running the 'View' returns the following result > >Zope has encountered an error while publishing this resource. > > Error Type: AttributeError > Error Value: __len__ > </dtml-excerpt>

1 0

restricted access to ZClass instances
by Timothy Wilson 16 Nov '99

16 Nov '99

Hi everyone, A student and I are working on a ZClass for displaying school news on our school district Web site. There will be a number of categories such as sports, academics, arts, etc. We plan to have someone in charge of submitting news item for each category. We'd also like to arrange it so that whoever is responsible for sports (for example), can only add sports news. What would be the most efficient, logical, and aesthetically pleasing way to do this? :-) -Tim -- Timothy Wilson | "The faster you | Check out: Henry Sibley H.S. | go, the shorter | http://slashdot.org/ W. St. Paul, MN, USA | you are." | http://linux.com/ wilson(a)visi.com | -Einstein | http://www.mn-linux.org/

1 0

ODBC - 1 step forward - woops I tripped
by rgines＠purina.com 16 Nov '99

16 Nov '99

My client runs IBMs' UDB 5 database engine on OS/2 Servers with NT clients (their choice not mine). I'm a newbie with Zope and wanted to understand the ODBC very well before trying to tie into UDB5 (since my guess is that I am the first one stupid enough to try this). So I started with something real simple. A text file with four columns and three records. I can create an ODBC connection through Zope with no problem. Going to the browse tab in the management screen actually shows me the table with the column definitions ... so I am getting from Zope, through the ODBC connector, through the WinNT ODBC drivers to the text file. Cool! ======= Now to do real work, I create a DTML Method with the following  .... <dtml-in ZopeODBCTest> <dtml-var LAST_NAME> </dtml-in>  Running the 'View' returns the following result Zope has encountered an error while publishing this resource. Error Type: AttributeError Error Value: __len__ So I ran grep on all the *.py files thinking that this might be a rare name ... woops. I'm still trying to figure out DTML and haven't dove into Python yet. Debugging the python code (or searching for my erroneous ways is still a week or so off .... if not more). ====== Assuming that my incredibly complicated code is buggy (proof reading three lines of code is tough), I decided to create a Z SQL Method with the following SQL. select * from ZopeTest Well I did and I get this result when running it. Error, sql.error: ('S1000', -1032, "[Microsoft][ODBC Text Driver] The Microsoft Jet database engine cannot open the file 'ZopeTest.txt'. It is already opened exclusively by another user, or you need permission to view its data.") Hmmm. Access issues? I'm logged on as a local Admin Already openned? The ODBC Connector gets there fine to read the tables (or is it just reading the schema.ini? ... not sure yet). Nothing else that I know of has it openned. ... no network locks, this is all done on a local system at this point. ======= So much for connecting to a real database, I can't even get to a text file. @>:-{ ======= Any pointers (pointing out my stupidity) or assistance would be greatly appreciated. Gracias.

1 0

including the contents of another page in a document?
by Sean McGerty 16 Nov '99

16 Nov '99

I'm building an intranet site with Zope and the reviews from the users are great - but I've hit a snag. I've got a squishdot site in /news/, and a number of business group pages in for example /ops/ /bus/ /dev/. The problem occurs when I try to include the squishdot contents inside the group pages. It sees objects with respect to the / directory - not the group directory I'm in. For example / has standard_header, and /dev/ has a modified version. a call to /dev/news sees the version in / not /dev/ - am I missing something obvious here? As well I believe it's been discussed before but I'm having trouble finding it - is it possible to include the contents of another URL in your present DTML document? Thanks in advance, Sean.

1 0

Logout question
by Daniel G. Rusch 16 Nov '99

16 Nov '99

Hey all, I went to the Zope site at http://www.zope.org/logout.html/view_source and this is the source that the Zope site uses to log members out:   When I execute the same source on my site, I don't get any errors and the user is redirected to the the logged_out page, but they are not "de-authenticated". In other words, unlike the Zope site, they can hit the back button and continue on their merry way. Any thoughts? Dan

3 2