- Zope - Zope lists

RE: [Zope-dev] Zope and MS Sql Server? - MS has a free SQL 7 serv er implementation now er implementation now
by Rob Page 26 Jul '99

26 Jul '99

> I thought I'd seen somewhere that the Oracle or Informix DA could be > used to talk to an MS SQL server. Is that true? You can use the SybaseDA to talk to MS SQL Server 6.5 I don't think anyone has _confirmed_ but a decent rumor is that from 6.5 -> 7.0, M$ changed the wire protocol to the point that the sybase client libs will no longer connect. --Rob

1 0

Shutting down Zope2
by Graham Chiu 26 Jul '99

26 Jul '99

Hi, I get this message in Win32. Is this normal? <TD WIDTH="90%"> <H2>Zope Error</H2> <P>Zope has encountered an error while publishing this resource. </P> <P><STRONG>exceptions.SystemExit</STRONG></P> Zope has exited normally.<p>  ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz

1 0

RE: [Zope] Zope 2 ODBC date errors
by Miller, John M. 26 Jul '99

26 Jul '99

Not quite non-US only, I had the same problem and I'm the Chicago-land area. I think part of the problem (if not all of it) is that Zope recognizes timezones as named in Unixen-land (hmm, sure am in a -land mood this morning), and has a little "difficulty" when it comes to recognizing what Windows considers to be proper timezone names (those guys never did figure out how to place nice with others). You can fix it locally by going in and editing DateTime.py, though of course you will have to reapply your changes the next time you upgrade. You just need to figure out what your system is calling the timezone you are in and adding an appropriate entry to the _zmap dictionary. Something like: 'Central Time':'GMT-6' Which, BTW, is what I had to do to get things working for my system. HTH, John > -----Original Message----- > From: Graham Chiu [SMTP:anon_emouse@hotmail.com] > Sent: Sunday, July 25, 1999 8:30 PM > To: zope(a)zope.org > Subject: Re: [Zope] Zope 2 ODBC date errors > > In article <D133051DBC4AD111B90800A0C969498391D592(a)natasha.auslabs.lucen > t.com>, Jay, Dylan <djay(a)lucent.com> writes > >Its that damm timezone problem in zope. If the python string returned as > >your timezone is not known to zope it barfs. This problem has been going > on > >for months and I feel because it is something that only effects > non-american > >zope users there has not been enough effort into fixing it. In fact I > have > >fixed this bug and submitted it and am disappointed that it has not made > >into the source yet as was promised. > >This is a show stopping bug. In certain countries any application that > uses > >dates from sql where a timezone is not supplied is going to crash!!! > > Is this something I can fix locally, or do I have to wait for the next > beta? > > ------- > Regards, Graham Chiu > gchiu<at>compkarori.co.nz > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev )

2 1

RE: [Zope] upgrade procedure
by Jens Vagelpohl 26 Jul '99

26 Jul '99

thanks for the helpful hints, i now have b1 running on my laptop (which will be used to present my project to the professor). but.... one little weird thing... i transferred the Data.fs from my a3-install and everything works fine, until i am using the only locally created role i have to access ZSQL-methods. all of a sudden this user is no longer authorized. the user is basically a replica of an anonymous user with permissions to view, access contents information, and use database methods. this is to cordon off one website area to authorized users only. here is the traceback: Traceback (innermost last): File /usr/src/Zope-2.0.0b1-src/lib/python/ZPublisher/Publish.py, line 256, in publish_module File /usr/src/Zope-2.0.0b1-src/lib/python/ZPublisher/Publish.py, line 161, in publish File /usr/src/Zope-2.0.0b1-src/lib/python/ZPublisher/mapply.py, line 154, in mapply (Object: kdsearch_DTML) File /usr/src/Zope-2.0.0b1-src/lib/python/ZPublisher/Publish.py, line 98, in call_object (Object: kdsearch_DTML) File /usr/src/Zope-2.0.0b1-src/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: kdsearch_DTML) File /usr/src/Zope-2.0.0b1-src/lib/python/OFS/DTMLMethod.py, line 145, in __call__ (Object: kdsearch_DTML) File /usr/src/Zope-2.0.0b1-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: kdsearch_DTML) File /usr/src/Zope-2.0.0b1-src/lib/python/DocumentTemplate/DT_In.py, line 601, in renderwb (Object: kdsearch_SQL) Unauthorized: (see above) it seems to be happening when the ZSQL method is being called. funny enough, the same method is called by anonymous unauthenticated users at another location in the website. and: if i answer the user/password screen with my manager name/password it works. the same thing with the very same settings still works fine on the main install on my server, which is still a3. anyone have any idea? did b1 introduce some subtle permissions changes that i don't know about??? Jens Vagelpohl > -----Original Message----- > From: Christopher Petrilli [mailto:petrilli@digicool.com] > Sent: Monday, July 26, 1999 16:05 > To: Jens Vagelpohl; zope(a)zope.org > Subject: Re: [Zope] upgrade procedure > > > > hi everyone, > > > > since all is so quiet in zope-land... let me throw out a question here > > :) > > > > what is the best way to upgrade (in my case from 2.0.0a3 to b1) an > > existing site without endangering the existing objects? i'm running > > it on RH6. > > I would say the best way is to install the new Zope in a new > directory, then > copy the Data.fs over... this has all the objects in it. If you > have added > products, I'd readd them (I always keep the tar.gz files around for just > such an occasion). This way you have the old version if > something should go > wrong. > > Chris > -- > | Christopher Petrilli Python Powered Digital > Creations, Inc. > | petrilli(a)digicool.com > http://www.digicool.com >

1 0

Re: [Zope] upgrade procedure
by Christopher Petrilli 26 Jul '99

26 Jul '99

> hi everyone, > > since all is so quiet in zope-land... let me throw out a question here > :) > > what is the best way to upgrade (in my case from 2.0.0a3 to b1) an > existing site without endangering the existing objects? i'm running > it on RH6. I would say the best way is to install the new Zope in a new directory, then copy the Data.fs over... this has all the objects in it. If you have added products, I'd readd them (I always keep the tar.gz files around for just such an occasion). This way you have the old version if something should go wrong. Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli(a)digicool.com http://www.digicool.com

1 0

Accessing the parent folder of a DTML document
by Carlos Henrique Bauer 26 Jul '99

26 Jul '99

Hi, How do I get access from inside of a DTML document to the properties of the its parent folder ? Best regards, -- Carlos Henrique Bauer

1 0

permissions on var... nevermind
by Kevin Swope 26 Jul '99

26 Jul '99

oh, not /var, but var

1 0

permissions on /var
by Kevin Swope 26 Jul '99

26 Jul '99

Hello, I just joined this list and I'm also in the process of setting up zope on my machine. Something immediately concerned me and thats mostly why I'm here. giving a web server write permissions to /var doesn't seem wise, am I wrong to think that? Thanks

1 0

RE: [Zope] Zope 2 ODBC date errors
by Brian Lloyd 26 Jul '99

26 Jul '99

> Its that damm timezone problem in zope. If the python string > returned as > your timezone is not known to zope it barfs. This problem has > been going on > for months and I feel because it is something that only > effects non-american > zope users there has not been enough effort into fixing it. > In fact I have > fixed this bug and submitted it and am disappointed that it > has not made > into the source yet as was promised. > This is a show stopping bug. In certain countries any > application that uses > dates from sql where a timezone is not supplied is going to crash!!! > > Please stop being so US centric and fix this bug!!! Jay, Did you submit this patch to the Collector, or just to the list? I don't see it in the Collector anywhere, but if you'll copy it to me via email I can put it in there to make sure it gets attention. Thanks! Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

RE: [Zope] upgrade procedure
by Michel Pelletier 26 Jul '99

26 Jul '99

> -----Original Message----- > From: Jens Vagelpohl [mailto:tommymi@concentric.net] > Sent: Monday, July 26, 1999 1:23 PM > To: zope(a)zope.org > Subject: [Zope] upgrade procedure > > > hi everyone, > > since all is so quiet in zope-land... let me throw out a > question here > :) > > what is the best way to upgrade (in my case from 2.0.0a3 to b1) an > existing site without endangering the existing objects? i'm running > it on RH6. > Back up your database, install the beta, and replace the beta's var/Data.fs file with your own. Start the beta, it should work. The most important phrase here is, 'Back up'. -Michel > > Jens Vagelpohl > > > > > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0