April 2000 - Zope - Zope lists

Local FS manage_addFolder woes
by Chris Withers 05 May '00

05 May '00

Hi, I'm trying to create a folder within a localFS object if one doesn't exist already. I'm trying: <dtml-if "not localFSobject.fileIds(folderNameVar)"> <dtml-call "localFSobject.manage_addFolder(folderNameVar)"> <dtml-else> Folder exists... </dtml-if> The problem is that this creates the folder in the folder containing the localFS object, not in the localFS object. Do I want a dtml-with? If so, which one? Does LocalFS support manage_addFolder or is the above happening because it doesn't and so aquisition is causing manage_addFolder to be executed on the folder object containing the localFS object? If aquisition is hapening, what should I use instead of manage_addFolder? Am I totally up the wrong tree? Any help is good help... Chris

8 14

RE: [Zope] Newbie date/time + MySQL problem
by Yanko, Curtis (GSP) 04 May '00

04 May '00

Just figured this one out myself a week or two ago. I use something like this: <dtml-var date fmt=aCommon> If you are using a Zope Date/Time object, this should work. -Curt > -----Original Message----- > From: jeffr(a)odeon.net [SMTP:jeffr@odeon.net] > Sent: Tuesday, April 25, 2000 12:02 PM > To: zope(a)zope.org > Subject: [Zope] Newbie date/time + MySQL problem > > > Greetings folks, > > I've got a record in an SQL database that contains a date > field (2000-02-25 for example). > > I'm generating a table from an SQL query. The bit that displays > the date is pretty simple: <dtml-var date null=""> > > I want to format the date into something a little more readable > (like 'Feb 25, 2000' for example). I've been trying to figure out > how to use the date-time format functions mentioned in the DTML > guide in Appendix A. It mentions the special variable _, which > provides a method for constructing date time values from strings > and numeric data. > > I think my question is really a matter of syntax, as the DTML > guide doesn't provide any examples of usage in Appendix A. > > Would I use something like: <dtml-var _.aCommon(date) null=""> ? > > Any help would be greatly appreciated, > > Jeff > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev )

5 6

Problems with zope + MS SQL Server
by Robert Honore 03 May '00

03 May '00

Anyone ever figured out how to get ZOPE's ODBC DA to work with MS SQL Server? I am a Zope newbie using MS SQL Server 7.0, Zope version 2.1.6, Python 1.5.2 Win 386 and ZODBC Version 3.1.0b2. Whenever I attempt to open an ODBC connection to the SQL Server I get the message "Invalid connection string:" followed by the name of the DSN I am trying to use. Can anyone help me along with this or is this the curse for using Microsoft software? Yours sincerely, Robert Honore.

2 2

Re: [Zope] Zope's scalability across multiple web servers
by Michael Bernstein 03 May '00

03 May '00

Jason Spisak wrote: > > > Beyond the fact that this may not be a good idea, you might want to > > store the postings in Zope, but the moderation score on the FS, as it is > > likely to get overwritten A LOT (especially by moderation bots). You run > > the slight risk of a given moderation being overwritten > > Please forgive my ignorance, but could you explain the essencial difference > between writing to the ZODB and a Filesystem Backend. I'm just not getting > why... Basically, the ZODB is optimized in design for many reads and few writes, and the filesystem is not. This means that in many-write situations, the ZODB is working much harder than usual, and performance of the site will go down faster than under an equivalent number of reads. > > statistically it should even out with as many 'up' moderations being > > discarded accidentally as 'down' ones. > > Is it because there is no locking? Yes. > > And you prevent Zope from > > thrashing with many tiny committed transactions mucking up the 'Undo' > > tab. > > I definately understand that part. I really appreciate this BTW. It's an > area of the Zope scope (;-) that I have thought about for a while(storage). I beleive that this tradeoff (transactional integrity vs. efficient writes) would be made irrelevant if the FS in question was either ReiserFS or the IRIX Journalling FS, but I don't really know enough about either to be certain. HTH, Michael Bernstein, Information Architect.

5 16

bobobase_modification_time()
by Jonathan Park 03 May '00

03 May '00

Hello everyone, The return time that I get using bobobase_modification_time() is off by a day. I get Apr. 26, 2000 instead of Apr. 27, 2000 How can I modify this? Your help greatly appreciated! -jon Have a great day! :)

4 3

wget to manage zope - manage_restart
by Gustin Kiffney 03 May '00

03 May '00

I've got zope running on an intranet NT server and its ODBC connection keeps a number of database files open at all times which my backup system can't handle. Hitting the zope control panel restart button closes those files long enough to get them backed up, but I'd like to do this later at night and automatically because the files get opened again as soon as someone hits the site (all the picklists, etc come out of the ODBC database files). So far I can't figure out how to do this. It looks like just hitting the URL http://superuser:password@myserver/Control_Panel/manage_restart? should work (I'm using wget on a linux box to do this) should work, and it DOES work from IE, but it doesn't work from wget - here's what happens with wget doing this with that exact same url: I guess wget tries without authorization first: Server: Zope/Zope 2.1.4 (binary release, python 1.5.2, win32-x86) ZServer/1.1b1 Date: Thu, 27 Apr 2000 20:47:13 GMT Www-Authenticate: basic realm="Zope" Bobo-Exception-File: C:\PROGRA~1\WEBSITE3\lib\python\ZPublisher\HTTPResponse.py Bobo-Exception-Type: Unauthorized Content-Type: text/html Connection: close Bobo-Exception-Value: <strong>You are not authorized to access this resource.</s trong> Content-Length: 1376 Bobo-Exception-Line: 551 then wget says this: Closing fd 4 Connecting to 128.1.1.200:8080... Created fd 4. connected! ---request begin--- GET /Control_Panel/manage_restart? HTTP/1.0 User-Agent: Mozilla/4.0 Host: 128.1.1.200:8080 Accept: */* Authorization: Basic c3VwZXJ1c2VyOnRob21hcw== ---request end--- HTTP request sent, awaiting response... HTTP/1.0 500 Internal Server Error Server: Zope/Zope 2.1.4 (binary release, python 1.5.2, win32-x86) ZServer/1.1b1 Date: Thu, 27 Apr 2000 20:47:13 GMT Bobo-Exception-File: C:\PROGRA~1\WEBSITE3\lib\python\App\ApplicationManager.py Content-Type: text/html Bobo-Exception-Type: exceptions.SystemExit Connection: close Bobo-Exception-Value: bobo exception Content-Length: 875 Bobo-Exception-Line: 320 Closing fd 4 16:48:29 ERROR 500: Internal Server Error. Then, from that point on, trying to access anything on that site gives me this: Error: Error Type: ValueError Error Value: I/O operation on closed file Traceback: Traceback (innermost last): File C:\PROGRA~1\WEBSITE3\lib\python\ZPublisher\Publish.py, line 165, in publish File C:\PROGRA~1\WEBSITE3\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_main) File C:\PROGRA~1\WEBSITE3\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: manage_main) File C:\PROGRA~1\WEBSITE3\lib\python\App\special_dtml.py, line 120, in __call__ (Object: manage_main) File C:\PROGRA~1\WEBSITE3\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: manage_main) File C:\PROGRA~1\WEBSITE3\lib\python\DocumentTemplate\DT_In.py, line 691, in renderwob (Object: objectItems) File C:\PROGRA~1\WEBSITE3\lib\python\App\PersistentExtra.py, line 114, in locked_in_version (Object: MailHost) File C:\PROGRA~1\WEBSITE3\lib\python\ZODB\Connection.py, line 380, in modifiedInVersion File C:\PROGRA~1\WEBSITE3\lib\python\ZODB\DB.py, line 356, in modifiedInVersion File C:\PROGRA~1\WEBSITE3\lib\python\ZODB\FileStorage.py, line 593, in modifiedInVersion (Object: C:\PROGRA~1\WEBSITE3/var/Data.fs) ValueError: I/O operation on closed file and the only way to get zope going again is to manually restart it in NT Control Panel using the Services dialog box. Anybody see what I'm doing wrong here?

2 1

Tree tags using LocalFS objects
by Eric Shuman 02 May '00

02 May '00

Thanks for the tip on the LocaFS product. Definitely a very cool addition! Here is my current floundering. I am trying to get a tree of a LocalFS object "folder", but I seem to be getting odd behavior from the tree that gets displayed. (Branches won't open, or open sporadically, and when they do open it is just a repeat of the original tree. Also they don't always open under the branch that was clicked on but in other locations.) Here is the code: <dtml-tree name=folder branches_expr=fileValues()> <dtml-if "meta_type=='Folder'"> <IMG SRC="<dtml-var icon>" BORDER=0> <b><dtml-var id></B> <dtml-else> <IMG SRC="<dtml-var icon>" BORDER=0> <A HREF="<dtml-var tree-item-url>"><dtml-var id></A> </dtml-if> </dtml-tree> If I call a Zope object and use objectValues() for my branch expression everything works fine. It seems that the id's are not getting set correctly and that "meta_type" is not a valid object property for LocalFS objects. I am not very familiar with the LocalFS objects. What am I missing? Thanks for your help, Eric Shuman

2 1

Cascading Style Sheets and Zope
by Eric L. Walstad 01 May '00

01 May '00

Hello All, In my experimenting with my first Zope website, I'm finding that I am spending a lot of time getting the different portions of the site to look the same. I've set up a few DTML methods like <dtml-var font_14pt> and <dtml-var table_format> that I use, but I bet there's a better way. I don't know anything about CSS, other than the concept, and am wondering if something like a DTML method that holds all the style sheet info is a good idea. That way, each page could simply reference that style sheet method. If the look of the site needed to be changed, the change would only have to happen in one location. I'm interested in hearing what others are doing to achieve this same goal. Should I go down the CSS road or is there a better way? TIA, Eric.

6 5

Error Packing Data.fs
by Eric L. Walstad 01 May '00

01 May '00

Hi, I am getting a permission denied error when I try to pack the Data.fs file I found one answer to this in the archives, but I need a little more explanation. Here's the answer from the archive: > That is the point - when Zope is run under root, it automatically drops > to nobody, and nobody doesn't have permissions to your Data.fs. > > Error Type: IOError > Error Value: [Errno 13] Permission denied: > '/usr/local/Zope/var/Data.fs' > >Oleg. (All opinions are mine and not of my employer) My question is: Do I change the ownership of Data.fs to "nobody" or do I change the user Zope is run as? I guess I don't understand the consequenses of each option so I don't know which is the best way to go. Thanks, Eric.

2 3

Granting rights to shutdown server?
by Chui Tey 01 May '00

01 May '00

Is there anyway grant a shutdown server role without giving away root? CHui

2 1