- Zope - Zope lists

DCOracle Problem
by David A Lipsky 29 Jun '00

29 Jun '00

I was wondering if you could help me with a problem I've been having with DCOrale, connecting to Oracle8i. import DCOracle conn = DCOracle.Connect(...) curs = conn.cursor() conn.procedures.some_stored_procedure(curs) curs.fetchall() curs = conn.cursor() conn.procedures.some_other_stored_procedure(curs) curs.fetchall() some_stored_procedure and some_other_stored_procedure return different rowtypes. Either the second call throws the following error, or it returns the wrong set of columns (it will return only those columns that were returned in the first call): Traceback (innermost last): File "<stdin>", line 1, in ? File "/usr/lib/python1.5/DCOracle/ociProc.py", line 134, in __call__ for c in iocursors: c._describe() File "/usr/lib/python1.5/DCOracle/ociCurs.py", line 130, in _describe if rc!=1007: self._error() File "/usr/lib/python1.5/DCOracle/ociCurs.py", line 109, in _error raise error, (rc, oci_.OracleErrorMessage(self._c.lda, rc)) oci.error: (1003, 'ORA-01003: no statement parsed') Explicitly closing the cursor between the calls doesn't seem to help, nor does reusing the same cursor. The only way I've been able to call two stored procedures in this way is by closing the connection itself between calls. Here's an actual session: Note that get_sentence_ids should return one integer per row, and get_sentences should return that integer along with some text. >>> import DCOracle >>> conn = DCOracle.Connect('********/********') >>> curs = conn.cursor() >>> conn.procedures.get_sentence_ids(curs) >>> curs.fetchall() [(6,), (5,), (8,)] >>> conn.procedures.get_sentences(curs) >>> curs.fetchall() [(6,), (5,), (8,)] >>> curs = conn.cursor() >>> conn.procedures.get_sentences(curs) Traceback (innermost last): File "<stdin>", line 1, in ? File "/usr/lib/python1.5/DCOracle/ociProc.py", line 134, in __call__ for c in iocursors: c._describe() File "/usr/lib/python1.5/DCOracle/ociCurs.py", line 130, in _describe if rc!=1007: self._error() File "/usr/lib/python1.5/DCOracle/ociCurs.py", line 109, in _error raise error, (rc, oci_.OracleErrorMessage(self._c.lda, rc)) oci.error: (1003, 'ORA-01003: no statement parsed') Any advice or help you can give would be greatly appreciated. Thanks! -David Lipsky Openmind Commonsense Group MIT Media Lab

2 1

Authentication, Anonymous and Public
by Capesius, Alan 29 Jun '00

29 Jun '00

I'm running into a problem after implementing jcNTUserFolder in a subfolder of my site. Users can access the root level or particular subfolders anonymously. Once a user accesses the protected NTUserFolder, the credentials are saved in the browser. If the user then returns to the anonymous area, they can no longer access th folder due to the browser credentials. Does Zope have a mechanism equivalent to the Novell NDS Public access? that is to say: Anonymous = not authenticated. Everyone = authenticated users (that are members of the group) Public = authenticated and anonymous users. I'd like the default access to be "anybody and their brother" rather than "those people who haven't logged in"

1 0

PowerMac 7500 with LinuxPPC and Zope?
by Daniel Muller 29 Jun '00

29 Jun '00

Hi, I would like to turn an old Mac 7500 into a Zope server. LinuxPPC installs on the Mac PowerPC using the Red Hat 6.1 linux distribution. Does anyone have any experience with Zope with this type of set up? Should I consider a different linux distribution than PPC? Thanks, Daniel

7 6

bobobase_modification_time off by 1 day - why?
by Luke Tymowski 29 Jun '00

29 Jun '00

Hello, Zope reports the bobobase_modification_time to be off by one day (1 day behind). The box has the right time (when checked from the OS), and asking Zope to return ZopeTime returns the correct date and time. Anyone know why? thanks, Luke

1 0

WebOS and Zope
by Jason Spisak 29 Jun '00

29 Jun '00

Zopists, I have been away for a bit, and will be gone again soon, but I found this the other day: Has anyone checked out http://www.webos.com ? It's free to sign up, just use explorer 5.0 and try it. I was amazed. It has drag and drop, looks like a real desktop. Now for the Zope angle: I am curious if anyone thinks Zope can server up content like this? XML Desktop? I think they are using ColdFusion though. An actual webtop powered by Zope. What would it take? They say they are going to release it OpenSource on their developer page. ;) All my best, -- Jason Spisak 444(a)hiretechs.com

1 0

Multiple Languages
by Christian Zagrodnick 29 Jun '00

29 Jun '00

Hi all, has anybody figured out how to make a zope website multilingual? I have to make a website in German and English - but the database stuff etc. is all the same. Did anybody do that? -- Christian Zagrodnick - Progressive Media Production http://www.promp.de/ Die Haftung ist auf das Gesellschaftsvermoegen beschraenkt.

3 3

DTML TREE TAG problem ???
by Frederic Quin 29 Jun '00

29 Jun '00

Hi all, it's really bizarre... I use the dtml-tree tag with the "single" option activated, and also with the "sort" option. The tree is generated successfully but when I click on the "plus" image, Zope change the order of my items... Frederic

1 0

RE: [Zope] Creating PythonMethod from ZClass constructor/method.
by Brian Lloyd 29 Jun '00

29 Jun '00

> > Using Zope 2.2b3, I am trying to create a PythonMethod from the > constructor of my ZClass and keep getting an authorization > dialog. In my > MyZClass_add method, I have: > > <dtml-with "MyZClass.createInObjectManager(...)"> > <dtml-call "manage_addFolder(id='testFolder')">  > <dtml-with "manage_addProduct['PythonMethod']"> > <dtml-call "manage_addPythonMethod( > this(), > 'testMethod', > 'Test Method', > 'self', > 'pass' > )"> > </dtml-with> > </dtml-with> > > Every pemutation I have tried gives the same result: an Unauthorized > exception. Hi Jeff - Thanks for reporting this. It turns out that there was a missing security assertion in the product dispatcher (manage_addProduct) that was causing this. The fix will be in b4. If you want to patch your install in the meantime, edit lib/python/App/FactoryDispatcher.py and change: class ProductDispatcher(Acquisition.Implicit): " " def __getitem__(self, name): ... to: class ProductDispatcher(Acquisition.Implicit): " " # Allow access to factory dispatchers __allow_access_to_unprotected_subobjects__=1 def __getitem__(self, name): ... Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

Getting at Zope (Version) Transactions
by Darin Lee 29 Jun '00

29 Jun '00

Hail Zopistas, I would like to develop a "what's new" method that parses/accesses the undo transactions list for certain documents so I can post basic information about when they were added, updated etc. in a DTML method for display on my index page. This would also come in very handy for a file-archive system I am planning on building. (I'm talking about the info that shows up when you hit the "undo" link in Zope manager). Is there a way to get at the transaction data? Is this data stored after a version is merged back into the main ZOBD? What would be the best way in Zope to parse this log for certain types, and generate a DTML method? Does Zope support Regular Expressions? I hail from the Perl coders guild (where generating and parsing text/sql is a relatively easy, albeit messy, task) - but am new to Python and OOP in general. However, now that I have Zoped, I can see there's no turning back. Any help would be greatly appreciated! -Darin Lee Darin M. Lee Analyst / Web Administrator Office of Automation Coordination Michigan Department of Environmental Quality Phone: 517.241.5214 leedm(a)state.mi.us

1 0

Urgent problem: Database and large clock skew
by Jim Flanagan 29 Jun '00

29 Jun '00

Hi, In trying to fix a problem with Zope httpd server sockets getting wedged in TIME_WAIT state, I set my system clock ahead by a year, then set it back. Unfortunately, connections to the Zope httpd server occurred while the clock was set in the future, and now when I try to start Zope, it dies with: DatabaseError: The database contains records, starting at position 189587919, that have time stamps 2540023.19965 seconds in the future. This could lead to database corruption. Please double check your system clock! I'm using a pre-2.0 version of Zope (Though I can't determin exacly which version...) Is there any way to correct insane timestamp values? I'm pretty much dead in the water. Alternatively, I have found the section in BoboPOS.py where this exception is generated. Is it really a problem to have future timestamps? What if I just snipped this portion of the code out? Please respond to jimfl(a)tensegrity.net. TIA -- Jim Flanagan jimfl(a)tensegrity.net http://jimfl.tensegrity.net

4 3