- Zope - Zope lists

RE: [Zope] - ODBC on Win32
by Brian Lloyd 21 Dec '98

21 Dec '98

> C:\Zope>"C:\Zope\bin\python.exe" "C:\Zope\serve.py" -p 80 > Traceback (innermost last): ... > File "C:\Zope\lib\python\Products\ZODBCDA\db.py", line 98, in ? > from sql import * > ImportError: DLL load failed: A device attached to the system > is not functioning Brad, Are you sure you have ODBC support installed? MS Access and other db applications generally install ODBC support as a part of their installation procedure, but if you haven't installed any database on your system, it's possible that the core Windows ODBC support isn't installed on your system. In the windows Control Panel there should be an "ODBC" icon if you have ODBC support installed - do you have this on your system? If so, does the windows ODBC manager or the Event Log show any kind of errors occurring with ODBC? Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

- can't __call__ objects?
by skip＠calendar.com 21 Dec '98

21 Dec '98

I'm experimenting with ZPublisher directly, since I think it will fit my needs better than full-blown Zope. If I have a class with a __call__ method, ZPublisher won't let me call the instance. I realize __call__ violates the "no underscore" publishing rule, but if an object is an instance and is otherwise publishable, shouldn't __call__ be called (no pun)? Revisiting my simple ASCII calendar, if I define class Calendar: """simple calendar class""" def show(self, year=time.localtime(time.time())[0], month=0): """return plain ASCII calendar month == 0 ==> display calendar for entire year year defaults to the current year, month to 0 """ if year < 1902 or year > 2037: raise ValueError, ("year out of range: %d" % year) if month < 0 or month > 12: raise ValueError, ("month out of range: %d" % month) save_stdout = sys.stdout sys.stdout = cStringIO.StringIO() if month: calendar.prmonth(year, month) else: calendar.prcal(year) sys.stdout.seek(0,0) _c = sys.stdout.read() sys.stdout = save_stdout return _c cal = Calendar() then publish it with ZopeHTTPServer, I can easily access it with URLs like http://localhost:8043/cal/show?year:int=1999&month:int=4 If, however, I change the definition of the Calendar class to have a __call__ method instead: class Calendar: """simple calendar class""" def __call__(self, year=time.localtime(time.time())[0], month=0): """return plain ASCII calendar month == 0 ==> display calendar for entire year year defaults to the current year, month to 0 """ if year < 1902 or year > 2037: raise ValueError, ("year out of range: %d" % year) if month < 0 or month > 12: raise ValueError, ("month out of range: %d" % month) save_stdout = sys.stdout sys.stdout = cStringIO.StringIO() if month: calendar.prmonth(year, month) else: calendar.prcal(year) sys.stdout.seek(0,0) _c = sys.stdout.read() sys.stdout = save_stdout return _c then try to access URLs like http://localhost:8043/cal?year:int=1999&month:int=4 I get Sorry, the requested document does not exist. showcal.Calendar instance at 814c158 Traceback (innermost last): File /home/dolphin/skip/src/Zope-1.9.0b3-src/lib/python/ZPublisher/Publish.py, line 879, in publish_module File /home/dolphin/skip/src/Zope-1.9.0b3-src/lib/python/ZPublisher/Publish.py, line 576, in publish (Info: /cal) File /home/dolphin/skip/src/Zope-1.9.0b3-src/lib/python/ZPublisher/Response.py, line 300, in setBody NotFound: (see above) I realize it's not a big deal in this simple example, but it seems to me that if an instance is otherwise publisher-ready, that it should be __call__able. Skip Montanaro | Mojam: "Uniting the World of Music" http://www.mojam.com/ skip(a)calendar.com | Musi-Cal: http://concerts.calendar.com/ 518-372-5583

4 4

RE: [Zope] - ODBC on Win32
by Brian Lloyd 21 Dec '98

21 Dec '98

> Hi, > > I just installed the ODBC package for Win32. Unzipped in the > c:\zope directory, let the package put things in the > appropriate folders. > > Reading the README (after zope subsequently fails to start) > tells me I need sql.dll, perhaps available from the Python.org site. That was wrong -- you don't need any external modules to use the ODBC DA. We've fixed the documentation on this. How did Zope fail to start? What errors did it give? Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

2 1

- ODBC on Win32
by Brad Marsh 21 Dec '98

21 Dec '98

Hi, I just installed the ODBC package for Win32. Unzipped in the c:\zope directory, let the package put things in the appropriate folders. Reading the README (after zope subsequently fails to start) tells me I need sql.dll, perhaps available from the Python.org site. Today I am probably responsible for half the hits to their site looking for any sql stuff that includes sql.dll. Does anyone know where I can find it? TIA, Brad Brad Marsh, Computer Specialist Center for Evaluation and Research, LLC (530) 527-5537 or 527-5638 fax http://www.tchp.org/cer/

3 2

RE: [Zope] - PCGI with IIS 4.0
by Brian Lloyd 21 Dec '98

21 Dec '98

> >You should be able to install b3 on an NT machine and choose > >the > >"Install as an NT service and run with my existing web server" > >option. > > > >This will install the Zope instance as a service, and prompt you > >for a CGI directory into which it will place the cgi exe. Pick > >a directory set up for cgi with IIS when prompted. > > Just wondering, > > I tried installing Zope b3 onto this (the machine I'mat right > now) NT Workstation, choosing to run it as a service and use > my existing web server (Xitami - I haven't even gotten that far yet). > > The service will not run, claiming: > > "The Zope (Zope) service failed to start due to the following error: > %1 is not a valid Windows NT application" I've never heard of this one before -- are there any other messages in the Event Log (Application Log) pertaining to the Zope service? The error message as stated makes it sound like you have an incompatible or corrupt binary. You aren't running NT on an Alpha or anything are you? Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

2 2

RE: [Zope] - PCGI with IIS 4.0
by Brian Lloyd 21 Dec '98

21 Dec '98

> > My problem is that lured by the simplicity of getting > > pcgi to work on linux/apache I have promised to port > > my web app to IIS. > > > I remember that there used to be several references > > for getting PCGI to work on IIS, but I can't find > > any of them now ;( > > > and the included readme points to > > http://starship.skyport.net/crew/jbauer/persistcgi/ > > which is also not very helpful for IIS newbie like me > > (I have no idea how to make IIS execute the info file > > using pcgi_wrapper.exe, which I guess is the thing I > > should do) > > Hannu, > > Amos got pcgi-wrapper.exe successfully working with IIS > back in August. I'll let him provide the details, then > I'll add them to the pcgi docs. ;-) > > I think one of the things he did was create a file > association, .pcgi extensions to pcgi-wrapper.exe. > > The pcgifile.py sanity tester should work (works with > Win32/Apache) and the pcgitime.py is a good starter > example to get pcgi working on NT. > > Keep in mind that process creation is more expensive > on NT vs. Unix. So although it should work for you, > it may not sustain heavy loads. Don't tell us you're > surprised <wink>. > > Best regards, > > Jeff Bauer Note that on winNT Zope also supports an alternate publishing mechanism that was developed in-house by Digital Creations. This mechanism is similar to (but not exactly like) pcgi. It runs your Zope process as a win32 service, and provides a lightweight cgi exe which knows how to communicate requests to the Zope service (the moral equivalent of pcgi-wrapper). You should be able to install b3 on an NT machine and choose the "Install as an NT service and run with my existing web server" option. This will install the Zope instance as a service, and prompt you for a CGI directory into which it will place the cgi exe. Pick a directory set up for cgi with IIS when prompted. Note that you probably have to tweak your IIS configuration to get IIS to pass authentication headers to Zope. You need to make sure that BOTH "Windows NT Challenge/Response" AND "Basic Authentication" are DESELECTED for the cgi directory where you placed the cgi exe. Otherwise, IIS will intervene on every request and try to do the authentication itself (which will fail, of course). We hope to roll pcgi support into the win32 Zope release soon. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

3 2

RE: [Zope] - Speed difference (pcgi/ZHTML)?
by Brian Lloyd 21 Dec '98

21 Dec '98

> Is there a big speed difference between using Zope w/pcgi and > ZopeHTTPServer? We've never timed them, but I doubt that there is any noticeable difference between the two in most cases. The only time you'll notice any difference is the very first request to the Zope process. ZopeHTTPServer will respond immediately because it runs in the Zope process - pcgi will take a few seconds to respond to the very first request because it is external to the Zope process and doesnt crank up the Zope process until the first request for it is actually received. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

2 1

- mailman password.
by Andreas Kostyrka 21 Dec '98

21 Dec '98

Hi! Question: What is my mailman password? Or how can I get it resent? *wonder* Andreas -- Win95: n., A huge annoying boot virus that causes random spontaneous system crashes, usually just before saving a massive project. Easily cured by UNIX. See also MS-DOS, IBM-DOS, DR-DOS, Win 3.x, Win98.

1 0

- Speed difference (pcgi/ZHTML)?
by Magnus Lie Hetland 21 Dec '98

21 Dec '98

Is there a big speed difference between using Zope w/pcgi and ZopeHTTPServer? -- Magnus Lie Hetland www.pvv.org/arcadia <arcadia(a)pvv.org>

1 0

RE: [Zope] - Zope Ports
by Dave Goodrich 21 Dec '98

21 Dec '98

On Sun, 20 Dec 1998, Jeff Bauer scratched: >>> My first thought as well (Linux box) and Zope starts, but not >> on Port 80. > >To run port 80 on Unix you'll have to be root, which is probably >not a good idea for development, if you can avoid it. > >these-days-everyone-gets-to-be-"super"-user-ly yr's, > >Jeff Bauer Now I'm confused, had to happen didn't it? 1) Can't install Zope as root because my machine doesn't run as root. Check. 2) Install Zope as me and Zope runs now, can start and stop. Check. 3) Can't run Zope on port 80 unless I'm root. No Check. Why is development on port 80 bad? I've done it many times on a spare IP address with Webstar and QPQ and Webten. When eveything works I move the site to an address with the proper domain. Is this a Unix thing I should know about? Do I need to create a user with root access to control Zope and su <zopeuser> whenever I need to maintain the Zope directory? DAve.

2 1