- Zope - Zope lists

Re: [Zope] sql returning number
by Roger Mallett 25 Sep '03

25 Sep '03

1) I think I would put the project names in a table of their own with the key (id) set to "auto_increment", such would solve your numbering/display problem. [create table trash (id int not null auto_increment,...);] Then insert like: insert into trash values (null,....); the null causes the auto_increment to kick in. 2) use <dtml-var name="ID" sql_quote> (actually, I'm not sure whether or not you need the "sql_quote" part, but you do need the "name=" part. Hope this helps. >From: "Derek S. Wilson" <dwilson(a)vhswest.com> >To: <zope(a)zope.org> >Subject: [Zope] sql returning number >Date: Thu, 25 Sep 2003 13:14:15 -0700 > >I have a slight problem... I'm working on a project management zope >site, and I need to create a new sequential project ID for each project. >I made a zsql statement as follows... > > > >select MAX(ID)+1 from AllProjects > > > >This gives the expected: > > > >(Maximum(ALLPROJECTS.ID))+() > >3 > > > >I now want to take that value(3) and use it as my ID. The column name is >ID, So, here's how I go about doing it. > > > ><dtml-in getNewProjectID> > >Here's the ID: <dtml-var ID> > ></dtml-in> > > > >but it keeps giving me a 'KeyError" - "ID" > >of course, lowercase id just shows the name of the folder that the dtml >document is in. > >So, does anyone know how I can put that result into my webpage? > > > >Thanks, > >Derek S. Wilson > > > > > >*****HIPAA Confidentiality Notice***** >The documents inside this electronic transmission contain confidential >information belonging to the sender that is legally privileged. This >information is intended only for the use of the individual or entity >named above. The authorized recipient of this information is prohibited >from disclosing this information to any other party and is required to >destroy the information after its stated need has been fulfilled, unless >otherwise required by law. If you are not the intended recipient, you >are hereby notified that any disclosure, copying, distribution, or >action taken in reliance on the contents of these documents is strictly >prohibited. If you received this electronic transmission in error, >please notify the sender immediately to arrange for return. > > > ><< DerekS.Wilson.vcf >> >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://mail.zope.org/mailman/listinfo/zope >** No cross posts or HTML encoding! ** >(Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) _________________________________________________________________ Help protect your PC. Get a FREE computer virus scan online from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

1 0

directory checksum error
by Norman Khine 25 Sep '03

25 Sep '03

I tried to download the source for 2.6.2, but get errors when unzipping x Zope-2.6.2-src/lib/python/Products/PluginIndexes/TextIndex/Splitter/Unic odeSplitter/src, 0 bytes, 0 tape blocks tar: directory checksum error OR x Zope-2.6.2-solaris-2.8-sparc/lib/python/Products/PageTemplates/tests/inp ut/CheckBatchIteration.html, 275 bytes, 1 tape blocks x Zope-2.6.2-solaris-2.8-sparc/lib/python/Products/PageTemplates/tests/inp ut/CheckI18nTranslate.html, 348 bytes, 1 tape blocks tar: directory checksum error Any idea? Cheers Norman

4 4

Cookie less session, how can I erase all variables
by Alexander Alvarado 25 Sep '03

25 Sep '03

Is it posible to errase all variables from a session at once or should I set them one by one? _________________________________________________________________ ¿Estás buscando un auto nuevo? http://www.yupimsn.com/autos/

3 2

Hoy to install LDAP with Zope 2.6.1 and python2.1.3 under redhat 9.0...
by Gelin Patrick 25 Sep '03

25 Sep '03

Hi, I'm trying to use LDAPUserFolder with Zope 2.6.1 and python2.1.3 under RedHat 9.0. (By the way, RedHat 9.0 installed python2.2 too) I installed python-ldap-2.0.Opre13.tar.gz. The result go through /usr/lib/python2.2/site-packages/ld* files and sub directory ldap... I copied /usr/lib/python2.2/site-packages/ld* files and subdirectory ldap to /zope/lib/python2.1/site-packages. (Is it really necessary?) Now if I go to /zope/bin/python and type import _ldap I've got an error message which is: importError /usr/lib/python2.2/site-packages/_ldap.so: undefined symbol:ldap_first_reference I believed /zope/bin/python use /zope/lib/python2.1 but its seems wrong!!! Now I think I have to install an openldap package to resolve ldap_first_reference but I don't know it's name for redhat 9.0... Is there anybody to help me? Thanks. Patrick Gelin

2 1

Security of a Web Application in Zope
by Edward Pollard 25 Sep '03

25 Sep '03

Hello All, We've been working with Zope on a few projects, and have come to realize that our development methodology has left some wide gaps in security. Let me demonstrate with an example: The project heirarchy basically looks like this: /root index.html otherfiles.html /queries all Z SQL Methods /scripts all python scripts The problem as I percieve it is that you can feed my Z SQL Methods and python scripts any input you want if you know what they are called. This is bad. Security via Obscurity is not secure. I *thought* that perhaps I could revoke all rights to Anonymous from the methods and scripts, and then give them to Owner, and Proxy Role the .html files to Owner, but that seems to block inter-script and script-to-query calls. I would have to Proxy Role every object, of which there is no easy interface to do so. Anyone with better thoughts on securing my scenario? (Or, indeed, if I need to turn my scenario on its head?) Ed

3 2

zopectlrc missing
by Kwesi Aguillera 25 Sep '03

25 Sep '03

I also posted this on the Yahoo groups. Ok this is my problem that I hope that someone out there can help with. I have been using zope for about six mouth to do various things for my work. We recently got a new server that is based away for our company and it runs Debian Linux. I had used apt-get to install a zope insallation on the new server and it had worked fine. However, my boss told me that I needed Zope 2.6.1 in order to transfer the site that we have on the intranet Zope site. So I used apt-get to uninstall the Zope that it had installed and used it again to install the 2.6.1. NB I believe that apt-get had installed Zope 2.6.1 the first time around but I did not really check. Anyways on the second instal of Zope 2.6.1 Zope doesn't start it gives the following error: zopectl: E: cannot find configuration file: /etc/zope/zopectlrc I know that the first time I installed the Zope using apt-get the file was there cause I had actually seen it is /etc/zope because I had to run zopectl create to create the INSTANCE_HOME in that file and then zopectl start in order to start Zope. NOw (after the second install) when I run zopectl create I get the same error message as above. The thing is I know that if I get a copy of the zopectlrc file I can edit it to suit my installation and make the zope run but I can't find a copy of this file on the net anywhere. I am asking if possible if some one can post a copy of the file or suggest a way around this problem if possible tanx...

2 1

correct 404 error page?
by Jaroslav Lukesh 25 Sep '03

25 Sep '03

Hi all, I was move or delete some subfolders from long running site, but _all_ search engines (google etc.) still does searching at these failed URLs for more than 2 months. Does somebody have correct error message that these search engines will respect? I do not mean redirect <dtml-call expr="RESPONSE.redirect('/notfound.html', lock=1)">, I want to set "something" into HTML header response. Many thanks Jaroslav Lukesh

4 4

Starting Zope and Zeo problem
by Jet Wilda 25 Sep '03

25 Sep '03

When I try to start ZEO and Zope using ./zctl.py start it seems that only the ZEO Server starts. I get this in the Zope log file: ------ 2003-09-18T16:55:24 INFO(0) zdaemon Started subprocess: pid 11661 ------ 2003-09-18T16:55:26 INFO(0) ZCS:11661 ClientStorage (pid=11661) created RW/normal for storage: '1' ------ 2003-09-18T16:55:26 INFO(0) ZEC ClientCache: storage='1', size=20971520; file[0]=None ------ 2003-09-18T16:55:26 INFO(0) ZCS:11661 Testing connection <ManagedConnection ('127.0.0.1', 5800)> ------ 2003-09-18T16:55:26 INFO(0) ZCS:11661 Connected to storage ------ 2003-09-18T16:55:26 PANIC(300) z2 Startup exception Traceback (innermost last): File /usr/local/Zope/z2.py, line 585, in ? File /usr/local/Zope-2.6.2-src/lib/python/Zope/__init__.py, line 46, in startup (Object: startup) File /usr/local/Zope-2.6.2-src/lib/python/Zope/App/startup.py, line 87, in startup (Object: ('', 5800)) File /usr/local/Zope-2.6.2-src/lib/python/ZODB/ZApplication.py, line 30, in __init__ File /usr/local/Zope-2.6.2-src/lib/python/ZODB/DB.py, line 477, in open File /usr/local/Zope-2.6.2-src/lib/python/ZODB/Connection.py, line 227, in _setDB AttributeError: ClientStorage instance has no attribute 'sortKey' I installed python-2.1.3 from source. I have been following these directions: http://www.zope.org/Members/dshaw/AdvancedSiteSetup to setup ZEO-2.0 and these directions: http://www.zope.org/Members/beacon/install_instructions to setup Zope-2.6.2-src. How do I fix this and get Zope and ZEO to run on the same machine? Thanks in advance Jet

5 5

Edit Subclass of File using ExternalEditor fails
by Harald Koschinski 25 Sep '03

25 Sep '03

Hi, I have a ZCLass with File as the base. I need the possebility to edit Instances of this class with ExternalEditor (0.7). Opening the Editor works fine, but when I try to save the file back to the server it claims Error occured during HTTP put: 405 Method not allowed I have all permissions to "777" - it can't be something with permissions - or ? Any subbestions? regards Harald

1 0

Mailhost and relay problem.
by Paolo Dina 25 Sep '03

25 Sep '03

Hi, this is the scenario. I have implemented a sort of simple newsletter manager for my site based on double optin, so users can subscribe, remove and modify their account info easily. The problem arise when mailserver must send to subscriber the mail that confirm their subscription. To do so i use mailhost, that gives this error message: smtplib.SMTPRecipientsRefused on {'subscriber(a)domain.tld': (550, '5.7.1 ... we do not relay ')} in "", at line 35, column 1 This happens because mailserver need that account that send mail gives his credentials, username and password. This is called "POP before SMTP". Now, is there an easy way to accomplish this authentication? Do you think that a python script could help? How..? Thankyou Paolo Dina

1 1