- Zope - Zope lists

numer of roles in a directory
by Steffen Hausmann 30 Oct '02

30 Oct '02

Hi, we're planning a website with up to 30 roles in one directory. Has anyone tried this yet? Will there be problems if the mumber of roles gets this large? MfG Steffen -- Manche Maenner bemuehen sich ein ganzes Leben lang, das Wesen einer Frau zu verstehen. Andere befassen sich mit weniger schwierigen Dingen, z.B. der Relativitaetstheorie.

2 1

Examples of using the fmt attribute
by Sandy Donaldson 30 Oct '02

30 Oct '02

Hi Everyone, Very new to this list, first post in fact. Can anyone help me with the fmt atribute of DTML, or at least point me to some examples ... Consider the following: I need to format 2001-12-31 00:00:00.00 as 31-12-2001 I need to format 0.00 as nothing (leave blank) I need to format -2,782.50 as 2,782.50 (absolute) Can anyone help? Thanks in advance Best Regards, Sandy Donaldson +------------------------------------------------------------+ | TaskForce Systems Ltd, Jersey +44 1534 632 100 | | TaskForce Research Limited, Cardiff, UK +44 2920 504 090 | | http://www.taskforce.co.uk | | eMail : support(a)taskforce.co.uk (For support issues) | | : research(a)taskforce.co.uk (For R&D issues) | +------------------------------------------------------------+

3 2

Tickling ZEO?
by Paul Winkler 30 Oct '02

30 Oct '02

I've been looking for a "standard" way of saying "hey ZEO, are you up?" that I can work into our failover system. (btw, our production zeo server is nearly read-only; all changes are made on dev and then we sync to production using ZSyncer. So I'm not worried about losing state when we fail over.) The simplest thing would be this, swiped from zctl.py: def _check_for_service(host, port): """Return 1 if server is found at (host, port), 0 otherwise.""" s = socket.socket(socket.AF_INET, socket.SOCK_STREAM) try: s.connect( (host, int(port)) ) return 1 except socket.error: return 0 So we just make a raw socket connection to the ZEO port and say we succeeded if there's anything there. However, that doesn't seem very robust. Is it possible for ZEO to get into a state where it accepts socket connections but won't deliver data? I don't know, and I feel safer assuming "yes". As pointed out here in some thread or other months ago, we could always set up a script that makes a write transaction every so often, but this is Bad. the ZODB would grow and grow and grow with pointless undo data ... So here's what we came up with, hacked out of stuff found in the ZEO test scripts : we make a dummy ZEO client and connect it and try to pull the root object. def testzeo(): storage=ZEO.ClientStorage.ClientStorage((host, port), name='ZEO Heartbeat Test at %s:%s ' % (host, port), wait_for_server_on_startup=0, client=None, debug=1, cache_size=0) storage.registerDB(DummyDB(), None) storage.load('\0\0\0\0\0\0\0\0', '') storage._call.__haveMainLoop = 0 storage.notifyDisconnected = dummy storage.close() return 1 If that fails for any reason, ZEO is down. As far as we can tell, this *works*: if ZEO is shut down we get an error, if it's not, we get 1. Great. But this seems very non-kosher. I've never heard of anybody opening and closing ZEO connections every 5 seconds on a production site. And we've seen a couple of very weird errors just after ZEO starts - a page loads in Zope, following a link gives a weird error (like no doctstring on a DTML method), then all links after that are fine. I can't help but think that our test script is contributing to this sporadic, only-on-startup flakiness, but I have no real evidence for that. So back to the original question... Is there a Right Way to check if ZEO is really up and running? -- Paul Winkler http://www.slinkp.com "Welcome to Muppet Labs, where the future is made - today!"

5 9

simple sql user auth
by keo 30 Oct '02

30 Oct '02

hi! is there a way of authenticating through sql, the simplest way? i dont need all stuuf from exUserFolder, no registration form, no password or details change, no mailing, nothing, just a SELECT user_id,password,roles FROM users WHERE user_id=xyz ... perhaps with a z sql query ... i tried to install loginmanager & zpatterns too, but it seemed to me that: = it is old code and perhaps deprecated too = everywhere zope 2.3 or 2.4 was mentioned, there were lots of errors with my 2.5.1 zope is there another way? thanks for the help, k

3 2

Database connection problem in products folder
by Sebastian Sippl 30 Oct '02

30 Oct '02

Hi, I need to create a database connection in my products folder. Creating the connection works without problems. Also, creating the z-sqlquery works. But if i try, submit a test query, i get the error message: Error, exceptions.AttributeError: The database connection ASF cannot be found Traceback (innermost last): File /home/people/sebastian/Zope-2.5.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /home/people/sebastian/Zope-2.5.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 114, in publish File /home/people/sebastian/Zope-2.5.0-linux2-x86/lib/python/Zope/__init__.py, line 158, in zpublisher_exception_hook (Object: a) File /home/people/sebastian/Zope-2.5.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 98, in publish File /home/people/sebastian/Zope-2.5.0-linux2-x86/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: manage_test) File /home/people/sebastian/Zope-2.5.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: manage_test) File /home/people/sebastian/Zope-2.5.0-linux2-x86/lib/python/Shared/DC/ZRDB/DA.py, line 328, in manage_test (Object: a) File /home/people/sebastian/Zope-2.5.0-linux2-x86/lib/python/Shared/DC/ZRDB/DA.py, line 306, in manage_test (Object: a) File /home/people/sebastian/Zope-2.5.0-linux2-x86/lib/python/Shared/DC/ZRDB/DA.py, line 394, in __call__ (Object: a) AttributeError: (see above) Does anybody know how to get this working ?

2 1

FTP error when using plone/CMF
by Kristofer Bengtsson 30 Oct '02

30 Oct '02

Hi I have problem with ftp in my plone site. I get an error when i try to upload files to a Zope folder but not when uploading to a Plone Folder via ftp. (error creating file). So It's ok to upload to a Plone Folder but to the standard Zope Folder. The problem is that i don't want to add content to the folder and I need the traversel lookup of index_html. (Can you do that with a Plone folder or do you always get the default view?) I use plone 1.0b1 and zope 2.5.1. _________________________________________________________________ Broadband? Dial-up? Get reliable MSN Internet Access. http://resourcecenter.msn.com/access/plans/default.asp

1 0

Post Copy actions
by Antonio Beamud Montero 30 Oct '02

30 Oct '02

Hi all: I want to add some actions after an object has been copied. I have supposed that I need to rewrite the manage_clone, but in the source of manage_close I have seen a method than can be util... ob._postCopy() But this method is commented... What is the best way to implemente some actions after an object is copied...? I need to rewrite manage_clone or manage_copyObject to do the things I need...? Thanks Greetings -- Microsoft merges technologoies: Windows CE + Windows ME + Windows NT = Windows CEMENT ---- Antonio Beamud Montero Agora Systems S.A. http://www.agoratechnologies.com

1 0

Check uploaded file for valid contents
by Andreas Tille 30 Oct '02

30 Oct '02

Hello, I wonder if there is an elegant method to check a file which is intended to be stored as (Ext)File in the ZODB according to the validity of its contents. The reason is thatr I have to store some PDF files but I have users who do not really know the difference between DOC and PDF. I want to refuse DOCs (or any other non-PDF) to enforce users to upload just PDF. Kind regards ANdreas.

3 4

MySQL-Python problems on Win32
by Bryan Capitano 29 Oct '02

29 Oct '02

I am trying to install the MySQL-Python-0.9.0 package onto my WinXP Prof. machine with Zope 2.5.1. Having problems: the MySQL-Python-0.9.0.exe installer stops with: "Select Python Installation to use: Select Installation directory:" Well,... there is nothing to select in this window. And the textbox won't let me type an installation directory either. This is as far as I can get with this exe installer. I have to cancel out of it because it won't let me go to "Next-->". I've also tried the "platform independent" MySQL-Python-0.9.0.tgz from sourceforge. Have tried running the `python setup.py build` and `python setup.py install` commands from the Windows command line. But I get this error: .... ....build process seems to be going okay.... .... building '_mysql' extension cl.exe /c /nologo /0x /MD /W3 /GX -Ic:\mysql\include "-IC:\Program Files\Website\bin\Include" /Tc_mysql.c /Fobuild\temp.win32-2.1\Release\_mysql.obj error: command 'cl.exe' failed: No such file or directory Don't get me wrong: I'm a serious Linux user. But I need to make some traveling presentations on the merits of Zope and I only have a WinXP laptop right now for my demonstrations/presentations. No Linux laptop just yet. :( Any help getting MySQL adapters installed on Windows will be much appreciated! Thanks, Bryan P.S. I have tried both the .exe and .tgz in versions 0.9.0 as well as 0.9.2. And I have tried both of these on Zope 2.6.0 on Windows as well. No luck in any of these combinations.

3 3

invalid date problem
by Jeff Sacksteder 29 Oct '02

29 Oct '02

I have a Zsql query that returns a date field as part of the result. If the result contains a row where that field has not yet been filled in, I get the following error: Error Type: ValueError Error Value: Invalid value, 0000-00-00, for DATE_START in record 6 How can I work around this?

3 2