- Zope - Zope lists

Re: [Zope] SQL
by Anderson Ami 11 Aug '99

11 Aug '99

Jeff, I have zope 1.10.3 installed on a machine running windows nt Server system and i am going to install a linux Red Hat based system and MySql on another machine on the same local network. What steps i need to do to access the database on the linux machine using zope that is installed on the NT Machine ? Where i can find mysql's DA for win32 zope ? I am a beginner and if possible i would like some document examples for a better understand DataBases & Zope. Thanks a lot Anderson Sao Paulo - Brasil >Anderson Ami wrote: > > Can I work with mySQL in NT using Zope or only mySQL for Linux ? > > How i work with mySQLxZope ? > >I've got a win32 binary for using python+MySQL on the >starship. It's only for a MySQL client, though. Last >time I checked, MySQL's NT db server was commercial. > >I don't use it. It's not supported. But occasionally >I test to make sure I can still access MySQL databases >residing Linux/Solaris boxes from an NT workstation. > >If that's your situation (and without spending $$$ for the >NT server version, it will have to be) then you're welcome >to use it. > >ftp://starship.python.net/pub/crew/jbauer/mysql-python151-win32.zip > >I've tested it (well, tested is too strong a word) with >Python 1.5.1 and 1.5.2. > >Regards, > >Jeff Bauer >Rubicon, Inc. > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0

Removing "unremoveable" items
by Alexander Staubo 11 Aug '99

11 Aug '99

When do you do when you've imported an old Zope 1.x database into a subfolder of a Zope 2.0 database and you want to delete redundant objects such as Control Panel, standard_error_message and so on? In a Zope 1.x installation I exported the complete root folder, then converted it to ZODB3 format using bbb.py, and then imported it into the Zope 2.0b3 installation. Now I sit here with things I cannot remove. Is there really any sane reason why a user shouldn't be permitted to remove special objects that are not on the root level? -- Alexander Staubo http://www.mop.no/~alex/ "He won a first at Oxford, squandered three fortunes, made love to a thousand women, imbibed strange drugs, sold his soul for Rock 'n' Roll, almost pipped Einstein for the Nobel Prize, was barred from every Chinese noodle parlour in West London and died penniless, at a Hastings boarding-house in his ninetieth year." --Robert Rankin, _The Book of Ultimate Truths_

1 0

Variable problems...
by Donald Holten 11 Aug '99

11 Aug '99

It appears that Zope pre-type checks python. I have a situation where I pass a file to a python routine (through an attach HTML command) to copy the file eventually. But sometimes the page I have isn't called from the attach form. Is there a way in Zope or HTML to create a fake file to use as a placeholder? For python I could just use a string as a place holder, but Zope causes my python to type-check before running. Does anyone know a way to simulate an attached file in Zope? Thanks! Donner

1 0

What's the default database connection status at Zope startup?
by Constantin Teodorescu 11 Aug '99

11 Aug '99

I have different Z PyGreSQL database connection objects. What will be the default connection status when I'll start Zope (at boot process). Should the connections be opened manually? If yes, is there a "startup folder" like object? Are they opened by Zope when a client access a Z SQL method at the first time? The connections are opened just one for the Zope server or one per client? I'm asking those questions because I intend to build an Intranet with 20-30 users that will heavily use a PostgreSQL server. I have searched the ZSQL documentation and didn't find any clue. Maybe that kind of questions would find a better place in a FAQ. Best regards, -- Constantin Teodorescu FLEX Consulting Braila, ROMANIA

2 2

External Creation of ZClasses
by Jason Spisak 11 Aug '99

11 Aug '99

Zopesters, I want to create ZClasses without using the web interface. It should be a external method right? How do I get activated by a link in Zope? Any help is greatly appreciated. -- Jason Spisak webmaster(a)mtear.com

1 0

RE: [Zope] how to ZODB 2 when using pcgi w/Zope2.0.0b3 ?
by Brian Lloyd 11 Aug '99

11 Aug '99

> Hi (and !help), > > I've just set up Zope2.0.b3 with pcgi and Apache1.3.6. > It works great but I've just learned that the Oracle > thingy only works with ZODB 2, not 3. > > I was using the '-2' option to z2.py before I had set > up pcgi and that worked great. Reed, The "-2" option is no longer supported in the 2.0 betas. If you need to use ZODB2, you'll have to stay with Zope 1.10.3 for now, since Zope 2 is ZODB3 only. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

RE: [Zope] Database choice
by Alexander Staubo 11 Aug '99

11 Aug '99

As for PostgreSQL I can't say, but Sybase on Linux is quite good. Specifics: It lacks the wonderful management tools, great query optimizer, and automatic memory/disk tuning features of MSSQL 7.0, but beyond that it's very functional. Fast? That depends. But given that Sybase 11.3 for Linux is free and if you know Transact SQL well, and you're able to configure your databases through its ISQL interface, it's excellent value for money. But let's just say that if Zope had supported DB2 (which also has a free Linux version) I'd probably have switched right away. The problem with Sybase right now is Zope support. Brian Hooper's DA has a number of bugs and quirks (which I've reported to him), and Digital Creation's DA has even more bugs (which I've also reported). I went back to Brian's DA after testing the DC DA, as Brian's bugs proved more endurable. Right now I can't recommend the DC DA as it is too buggy for even a testing environment, unless you're a very casual user. (I have patched Brian's Python code to fix some odd quirks, I can send the the fixes on request to anyone who wants them.) -- Alexander Staubo http://www.mop.no/~alex/ "He won a first at Oxford, squandered three fortunes, made love to a thousand women, imbibed strange drugs, sold his soul for Rock 'n' Roll, almost pipped Einstein for the Nobel Prize, was barred from every Chinese noodle parlour in West London and died penniless, at a Hastings boarding-house in his ninetieth year." --Robert Rankin, _The Book of Ultimate Truths_ >-----Original Message----- >From: Tom Deprez [mailto:tom.deprez@uz.kuleuven.ac.be] >Sent: 11. august 1999 16:58 >To: zope(a)zope.org >Subject: [Zope] Database choice > > >Hi all, > >This is an off-topic question, but I wonder if somebody can >help me decide. > >What database should you use? SyBase or PostGresSql? Both are free... > >Regards, Tom. > >_______________________________________________ >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

RE: [Zope] Database choice
by Rob Page 11 Aug '99

11 Aug '99

> What database should you use? SyBase or PostGresSql? Both are free... Sybase is free? --Rob

2 1

File uploading problems...
by Donald Holten 11 Aug '99

11 Aug '99

I have the following upload DTML: <FORM METHOD="POST" ACTION="resultpage"> Data File:<INPUT TYPE="FILE" NAME="data" SIZE="20"> <INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="SUBMIT"> </FORM> And the following result page:  And the following python file resultstuff: #! /usr/local/bin/python def resultstuff(data): import os, shutil # Variables: returnstring = "" # The messages this page # will print out. if data.read(1) == '': returnstring = "<H2> File does not exist</H2>" else: data.seek(0) for element in file.readlines(): returnstring = returnstring + element return returnstring I get the following error: Error Type: AttributeError Error Value: 'string' object has no attribute 'read' The traceback says it's from line 9 of the program, which is: if data.read(1) == '': Is Zope converting my file to a string or something? Is there some way to fix this? Thanks! Donner

2 1

RE: [Zope] Database choice
by Tom Deprez 11 Aug '99

11 Aug '99

Sybase for Linux not? >> What database should you use? SyBase or PostGresSql? Both are free... > >Sybase is free? > >--Rob >

1 0