- Zope - Zope lists

Re: [Zope] mssql system dsn hangs causing zope to be no more
by julio dinis 09 Jun '00

09 Jun '00

I'm using 2.1.6. Regards, Julio >From: "Harald Ragger" <h.ragger(a)aon.at> >To: "julio dinis" <juliodinis(a)hotmail.com> >CC: "Zope List" <zope(a)zope.org> >Subject: Re: [Zope] mssql system dsn hangs causing zope to be no more >Date: Thu, 8 Jun 2000 18:02:33 +0200 > >Julio: >what version of zope do you run? > >harald >----- Original Message ----- >From: "julio dinis" <juliodinis(a)hotmail.com> >To: <zope(a)zope.org> >Sent: Thursday, June 08, 2000 1:49 PM >Subject: [Zope] mssql system dsn hangs causing zope to be no more > > > > Hi Zopistas! > > > > After some time of heavy use of the site the > > zserver goes zombie, and even restarting will put zope > > automatically zombie, never more. > > > > If I remove the system dsn I use with zodbc and restart zope, > > then zope runs like a ferrari. I than create again the odbc system > > dsn and everything is back again. > > > > But some time after the zombie arise from the grave :-( > > > > I'm looking at logs. > > Anyone with this problem? > > > > Júlio Dinis Silva > > ________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > > > > _______________________________________________ > > 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 ) > > > > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

1 0

Zope.org Hidden Stats
by J. Atwood 09 Jun '00

09 Jun '00

Just making my daily visit to Zope.org and stumbled across the statistics at http://www.zope.org/About/Statistics Very nice... There is a bunch more on the about page http://www.zope.org/About/ Cheers to DC and letting us see what they are doing behind the scenes.... How are you going to spend that $1,000 when you get ZEO working? :) JMA

4 7

problem in creating portal
by P Chandra Sekhar 09 Jun '00

09 Jun '00

Hi everybody, Right now I'm trying to create Portal. I've established the ODBC database connection and ZSQL method every thing is working fine. The problem in creating portal is , in second page of wizard I've not seen any info regarding members(theme, layout, public view) as it mentioned in document, it has only design scheme. In third page I've provided all the info including portal manager.After clicking finish button I'm getting the error like this..... Zope Error Zope has encountered an error while publishing this resource. Error Type: sql.error Error Value: ('S0002', 208, "[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'users'.") Troubleshooting Suggestions The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. Traceback (innermost last): File C:\PROGRA~1\WebSite\lib\python\ZPublisher\Publish.py, line 214, in publish_module File C:\PROGRA~1\WebSite\lib\python\ZPublisher\Publish.py, line 179, in publish File C:\PROGRA~1\WebSite\lib\python\Zope\__init__.py, line 202, in zpublisher_exception_hook File C:\PROGRA~1\WebSite\lib\python\ZPublisher\Publish.py, line 165, in publish File C:\PROGRA~1\WebSite\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: Portal_add) File C:\PROGRA~1\WebSite\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: Portal_add) File C:\PROGRA~1\WebSite\lib\python\OFS\DTMLMethod.py, line 150, in __call__ (Object: Portal_add) File C:\PROGRA~1\WebSite\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: Portal_add) File C:\PROGRA~1\WebSite\lib\python\DocumentTemplate\DT_With.py, line 148, in render (Object: Portal.createInObjectManager(REQUEST['id'], REQUEST)) File C:\PROGRA~1\WebSite\lib\python\DocumentTemplate\DT_Util.py, line 335, in eval (Object: apply_wizard(REQUEST)) (Info: REQUEST) File <string>, line 0, in ? File C:\Program Files\WebSite\lib\python\Products\PTKDemo\Portal.py, line 248, in apply_wizard (Object: DemoPortalBase) File C:\Program Files\WebSite\lib\python\Products\PTKDemo\Portal.py, line 172, in addMember (Object: DemoPortalBase) File C:\PROGRA~1\WebSite\lib\python\AccessControl\User.py, line 501, in _addUser (Object: DemoSQLMemberFolderBase) File C:\Program Files\WebSite\lib\python\Products\PTKDemo\SQLMember.py, line 92, in getUser (Object: DemoSQLMemberFolderBase) File C:\PROGRA~1\WebSite\lib\python\Shared\DC\ZRDB\DA.py, line 430, in __call__ (Object: sqlUserQuery) File C:\Program Files\WebSite\lib\python\Products\ZODBCDA\db.py, line 198, in query sql.error: (see above) .... Can any body help me..what to do next... Thanks in advance.... Chandra Sekhar. P Version details: Zope version: Zope 2.1.6 (binary release, python 1.5.2, win32-x86) Python version: 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)] System Platform: win32

1 0

Re: [Zope] Urgent Help Required- Installation
by System Administrator 09 Jun '00

09 Jun '00

Hi Daryl this did not work. it gave a conflict with the exisiting installed packages. On Fri, 9 Jun 2000, Daryl Tester wrote: > python-devel is an RPMism (which means you won't find it on python.org) > On my RedHat 6.1 box, it's python-devel-1.5.2-7.rpm . chkconfig, > according to "rpm -qf `which chkconfig`", is owned by chkconfig-1.0.7-2. > > > Regards, > Daryl Tester > Parag Mehta <admin(a)puretech.co.in> System Administrator. Puretech Internet Pvt. Ltd. http://puretech.co.in/ 77 Atlanta. Nariman Point. Mumbai - 400021. India. Tel: +91-22-2833158 ============================================================ Support is now available thru our Web Based Support System. http://support.puretech.co.in ============================================================

1 0

RE: [Zope] Q: Accessing ZSQL methods from Python
by a.wacknitz＠francotyp.com 09 Jun '00

09 Jun '00

> -----Original Message----- > From: Dieter Maurer [mailto:dieter@handshake.de] > Sent: Thursday, June 08, 2000 10:21 PM > To: a.wacknitz(a)francotyp.com > Cc: zope(a)zope.org > Subject: Re: [Zope] Q: Accessing ZSQL methods from Python > > > a.wacknitz(a)francotyp.com writes: > > my question is what type or value is returned by a ZSQL > method that is > > invoked from Python? > ZSQL methods return "Shared.DC.ZRDB.Results.Results" instances. > Such an instance essentially behaves like a sequence of > objects each describing one result row. > These objects have been set up such that a column value > can be accessed as attribute with the column name. > Thus, "results[i].column" gives the value of "column" of > the i.th row. Yes, that works fine. But I need to know of NULL values. > > How to determine, how "Null" values are recognized, > is less a Zope than a database adapter question. > I would expect, that most (if not all) database > adapters will map SQL Null to None. That was what I thought but at least ZODBC won't do this. What I have found out is, that repr(SQL NULL) == 'Missing.Value'. > > However, even some well established SQL databases do not > treat Null standards-conform but represent it as > the empty string. Then, the database adapter has > no chance to map this to None but must use '', too. ZODBC won't do this either. > > > Dieter > Andreas ********************************************************************** This email message has been swept by MIMEsweeper for the presence of computer viruses. Francotyp-Postalia AG & Co.

1 0

ANN: ZUBB 0.3.2 (Zope Ultimate Bulletin Board)
by J. Atwood 09 Jun '00

09 Jun '00

http://www.zope.org/Members/BwanaZulia/ZUBB/ A few bugs fixed. A few more features added. Almost ready for prime time. Take a look and email me with your comments. If you are using it and would like to be linked to as an "example" site please send me the url. The idea is to make sure the release works and then submit it for cataloging on Zope.org. Thanks, J

4 5

unsubscribcription
by rapha�l zamochnikoff 09 Jun '00

09 Jun '00

hello ! i would like to unsuscribe the zope mailing list as soon as possible, because the end of my training course comes near. thanks in advance ! raphael zamochnikoff ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

1 0

Urgent Help Required- Installation
by System Administrator 09 Jun '00

09 Jun '00

Hi can anyone help with the following errors : error: failed dependencies: python-devel is needed by Zope-2.1.6-1 /sbin/chkconfig is needed by Zope-2.1.6-1 i'm using suse6.4 linux box wherein i have installed all the available python packages. i also tried to search python.org for python-devel package but couldn't find it. awaiting a reply at the very earliest, regards. Parag Mehta <admin(a)puretech.co.in> System Administrator. Puretech Internet Pvt. Ltd. http://puretech.co.in/ 77 Atlanta. Nariman Point. Mumbai - 400021. India. Tel: +91-22-2833158 ============================================================ Support is now available thru our Web Based Support System. http://support.puretech.co.in ============================================================

1 0

Wrong mime type sent by Zope on every page
by dillera＠isc.upenn.edu 09 Jun '00

09 Jun '00

Hello: It was just brought to my attention that Zope (using Zserver) is sending the wrong MIME type of all its pages. Here is the header from zope: (some lines have been cut) ------------------ HTTP/1.0 200 OK Server: Zope/Zope 2.1.6 (source release, python 1.5.2, linux2) ZServer/1.1b1 Date: Thu, 08 Jun 2000 15:45:23 GMT Ms-Author-Via: DAV Content-Type: application/octet-stream Last-Modified: Thu, 8 Jun 2000 15:45:07 GMT Here is one from apache: ------------------------- HTTP/1.1 400 Bad Request Date: Thu, 08 Jun 2000 15:29:59 GMT Server: Apache/1.3.6 (Unix) Content-Type: text/html I want Zope to be sending text/html, as some browsers want to download the page rather than view it. I haven't discovered anywhere to configure this. I read the Setting the MIME Type of a DTML Method http://www.zope.org/Members/anser/howto_dtml_mimetype which claims that you can set the mime type of a method by putting it at the top of the method. I did this on a test page, but still received the same header from Zope. Can someone shed some light on this? 1. how to set the mime type for all methods and documents of Zope 2. What is the Ms-Author-Via: DAV in the Zope header? WebDAV? thanks, andy diller

4 6

Getting a specific user role
by Mabe, Brad 09 Jun '00

09 Jun '00

Forgive me if this has been covered before. I am implementing a login/security scheme through the use of GUF and SQL methods. My user and role information is kept in a SQL database and a user can have more than one role assigned to him/her. What I would like to do is check if a specific role has been assigned to the current user, and then display some additional menu items if that role has been assigned. I haven't been able to figure out how to get and check the roles that have been assigned to the current user. As usual, any help will be greatly appreciated. -=Brad=-

3 2