- Zope - Zope lists

RE: [Zope] ZPygreSQL woes
by TFE MMS JARVIS JOHN 27 Jul '99

27 Jul '99

oh... This query outright crashes Zope on my system! PostgreSQL 6.5 Vine linux 1.1 (Japanese Red Hat clone) Linux 2.2.9 (with appropriate updates :^) Python 1.5.1 Zope 1.10.3 ZPyGreSQLDA 0.3 I noticed that if you take out both MONEY types from the query, Zope doesn't crash. If you take out one, Zope doesn't crash, but only returns one row. It sure looks like a ZPyGreSQLDA bug. I've never had any other problems like this. pcgi.log entry: -------------------- Tue Jul 27 10:39:22 1999 pcgi-wrapper: unexpected out-of-bound data in stdin t[0] = 80 queries: ----------- vvvvvvvvvvvvvvv CRASHES: ^^^^^^^^^^^^^^^ select prodname, description, retailprice, prodVis, IMpartNumber, size, speed , color, weight , height , width , onhand , reorder , discontinued , supplier , supplierPartNumber , manufacturer, cost from items ==== select retailprice, cost from items ------------------------------ Returns only one row: ------------------------------ select prodname, description, prodVis, IMpartNumber, size, speed , color, weight , height , width , onhand , reorder , discontinued , supplier , supplierPartNumber , manufacturer, cost from items ==== select retailprice from items ==== select cost from items ------------------------ Returns all rows: ------------------------ select prodname, description, prodVis, IMpartNumber, size, speed , color, weight , height , width , onhand , reorder , discontinued , supplier , supplierPartNumber , manufacturer from items -- John Jarvis > -----Original Message----- > From: nathan frund [SMTP:ndf@rocketmail.com] > Sent: Tuesday, July 27, 1999 2:04 AM > To: Hannu Krosing > Cc: zope(a)zope.org > Subject: Re: [Zope] ZPygreSQL woes > > > ---Hannu Krosing <hannu(a)trust.ee> wrote: > > > > ndf(a)rocketmail.com wrote: > > > > > > I've run into a problem with Zope with > PostgreSQL. The query runs and > > > runs and runs till all the memory on the server > is used up and Zope > > > falls over. > > > > I'm using it all the time with no major problems. > > > > Do the same queries run fine from psql ? > > > > Yea, even from from 'regular old Python' and with > PGaccess. > > Here is the SQL that I used to create the table. > ------------------------------- > items.sql > ------------------------------- > CREATE TABLE items ( > prodname char(20), > retailPrice money, > description char(80), > prodVis char(80), > IMpartNumber char(20), > size float4, > speed float4, > color char(8), > weight int8, > height int8, > width int8, > onhand int8, > reorder int8, > discontinued boolean, > supplier char(20), > supplierPartNumber char(20), > manufacturer char(16), > cost money > ); > > > copy items from stdin using delimiters ','; > "15"" 5VX 28mm",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004520,0,200 > "17"" 7SP .28mm 1280x1024(1yrs warr)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004190, > 0,250 > "17"" 70+ .28mm 1280x1024",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004120,0,300 > ----------------------------------------------------- > > psql database < items.sql > > > > Python code that works. > ------------------------------------------ > > from pg import * > > cnx=connect('database','localhost',5432) > > query=cnx.query('select * from items') > print "\n" > > fields=query.listfields() > print fields > > ------------------------------------------ > > > > Schemas, row counts, queries executed ? > > > The query with Zope is the same exact query with the > python... "Select * from items" > > > It stops even with only three rows in the database. > The SQL above for me stops Zope and Postgres in their > tracks. > > > > Also OS, postgres and ZPygreSQLDA versions. > > > I'm running Red Hat Linux 5.2 with kernel 2.2.9 > Python 1.5.2 from Oliver Andrich's site. > Postgres is version 6.4.2-5. > ZPyGreSQLDA version is 0.3. > Zope 2.0.0b1 and Zope 1.10.3 > > I also have python-PyGreSQL-2.3.2.rpm installed. I > got it from rufus.w3.org. I removed it thinking that > it conflicted or caused the problem. But removing it > didn't seem to help so I reinstalled the package. > > > I haven't tried yet but I'm going to write an > external method and see if that works. > > > I've put up a lot of info, thanks for your help. > _________________________________________________________ > DO YOU YAHOO!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > _______________________________________________ > 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] RE: [Zope-dev] Zope and MS Sql Server? - MS has a free SQL 7 serv er implementation now er implementation now
by Anthony Baxter 27 Jul '99

27 Jul '99

>>> Rob Page wrote > 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. It's only the new stuff in 7.0 that's broken. So long as you stick to the traditional SQL Server functionality (or should that be "functionality"?[*]) things will work. See also the FreeTDS work (search Freshmeat) - they intend to support 6.5 and 7.0 eventually. Anthony [*] SQL Server is _not_ my friend.

1 0

RE: [Zope] Shutting down Zope2
by Michel Pelletier 27 Jul '99

27 Jul '99

> -----Original Message----- > From: Graham Chiu [mailto:anon_emouse@hotmail.com] > Sent: Monday, July 26, 1999 6:03 PM > To: zope(a)zope.org > Subject: [Zope] Shutting down Zope2 > > > Hi, > > I get this message in Win32. Is this normal? > > SystemExit: 0 > Yes. -Michel

1 0

RE: [Zope] Starting Zope2 on Win95
by James M. Slack 27 Jul '99

27 Jul '99

I finally got Zope2 running by supplying the IP address with -a: start -a 127.0.0.1 At first I didn't think it was working, because I didn't see any confirmation message -- it just appeared to hang. (On my Linux machine at work, I get a rather detailed message showing the ports in use, etc.) Everything seems to work otherwise, so I guess I'm happy. Thanks for your help...

4 3

Installation
by Shan Vosseller 26 Jul '99

26 Jul '99

I just downloaded the 1.10.3-3 complete main and pcgi rpms from jbauer's site and installed them for use with pcgi and apache 1.3.6. I installed both packages, edited the access file, and copied the cgi to my cgi-bin directory. When I go to: http://localhost/cgi-bin/Zope.cgi/manage I get: Temporarily Unavailable The resource you requested is temporarily unavailable - please try again later. (102) failure during connect I went to the online troubleshooting guide, and 'nobody' owns the /var/local/zope/var directory with all privs enabled. The only file in that directory is Data.bbb and that is also owned by nobody with rw permissions. /var/tmp is empty and pcgifile.py says that the Zope.cgi file looks okay. HTML comment says: Connection refused pcgi-wrapper-version 2.0a5 I am out of ideas. Any suggestions? Sorry for the newbie-ish question, but I seem to have exhausted everything I can think of. Feel free to reply directly to shannonv(a)vsarts.org. -Shan

2 1

Newbie Question revisited
by Donald Holten 26 Jul '99

26 Jul '99

Hi, again, all! I'm looking for a way of adding 1 to a variable then storing it into the Zope database (Gadfly) through DTML. I don't want to use any External Methods if possible. I understand that External Methods would be easier, but it's important that it not be such a method. Thanks again! Donner

2 1

problem with bbb.py
by Chad McDaniel 26 Jul '99

26 Jul '99

I tried to use the bbb.py in the Zope2b1 by exporting the Quickstart from Zope1 and trying to convert it to ZODB3: --- ~/work/Zope-2.0.0b1-src/utilities % python bbb.py -f foo.fs ../../QuickStart.bbe Bad previous record pointer (-1022202112) at 9 Corrupted data record at 9 Traceback (innermost last): File "bbb.py", line 389, in ? if __name__=='__main__': main(sys.argv[1:]) File "bbb.py", line 387, in main forgive=1, export=export) File "bbb.py", line 232, in _read_and_report rpt(None, None, None, None, None, None, None, None, None) File "/usr/people/chadm/work/Zope-2.0.0b1-src/utilities/FS.py", line 114, in rpt self.tpc_finish() File "/usr/people/chadm/work/Zope-2.0.0b1-src/utilities/FS.py", line 184, in tpc_finish id=self._serial AttributeError: _serial ~/work/Zope-2.0.0b1-src/utilities % --- -- -chad

2 1

RE: [Zope] Zope 2 ODBC date errors
by Jay, Dylan 26 Jul '99

26 Jul '99

> -----Original Message----- > From: Brian Lloyd [mailto:Brian@digicool.com] > Sent: Tuesday, July 27, 1999 04:05 > To: 'Jay, Dylan'; 'Graham Chiu'; zope(a)zope.org > Subject: RE: [Zope] Zope 2 ODBC date errors > > > > 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. Its in the collector as being completed http://www.zope.org/Collector/314/view The not sure if the line number is still valid but the patch was: DateTime.py replace line 664 with except: try: t= time() localzone = mktime(gmtime(t)) - t localzone = int(round(-localzone/(60*60))) if (localzone >=0): localzonename = '+'+str(localzone) else: localzonename = str(localzone) _localzone = _cache._zmap[lower('GMT'+localzonename)] except: _localzone=''

1 0

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