January 2013 - Zope - Zope lists

SQL and Python Products
by Luiz Pasqual 16 Jan '13

16 Jan '13

Hi, We are trying to migrate a very old application on Zope 2.9, first we thought to migrate to Python Products and then upgrade Zope. We don't know what's the best way to deal with SQL querys in Python products. He is some options we are evaluating: - SQLAlchemy, leaving behind ZSQLMethods e Zope DA's - Psycopg - Python code access a Zope DA inside Zope So, what you guys think? Thanks. -- Luiz Fernando Pasqual S. Souza mail: luiz(a)pasquall.com

3 2

help
by Daniel Godefroy 15 Jan '13

15 Jan '13

Please remove me from the list At 07:00 2013-01-15, you wrote: >Send Zope mailing list submissions to > zope(a)zope.org > >To subscribe or unsubscribe via the World Wide Web, visit > https://mail.zope.org/mailman/listinfo/zope >or, via email, send a message with subject or body 'help' to > zope-request(a)zope.org > >You can reach the person managing the list at > zope-owner(a)zope.org > >When replying, please edit your Subject line so it is more specific >than "Re: Contents of Zope digest..." > > >Today's Topics: > > 1. ? Zope, Dhilip left a message for you (Badoo) > > >---------------------------------------------------------------------- > >Message: 1 >Date: Tue, 15 Jan 2013 10:41:49 +0000 >From: Badoo <noreply+356568750(a)badoo.com> >To: zope(a)zope.org >Subject: [Zope] ? Zope, Dhilip left a message for you >Message-ID: <mailman.20.1358251201.10567.zope(a)zope.org> >Content-Type: text/plain; charset="utf-8" > >Dhilip left a message for you > >Its sender and content will be shown only to you and you can delete >it at any time. You can instantly reply to it, using the message >exchange system. To find out what was written to you, just follow this link: >http://eu1.badoo.com/0308700839/in/aK06D1M0TPk/?lang_id=3&g=57&m=21&mid=50f… > >Some other people in the area who are on Badoo >Suhail (Bengaluru, India) >Maria (Bengaluru, India) >Kays Snkay (Jakarta, Indonesia) > >http://eu1.badoo.com/0308700839/in/aK06D1M0TPk/?lang_id=3&g=57&m=21&mid=50f… > >If clicking the links in this message does not work, >copy and paste them into the address bar of your browser. > >This email is a part of delivering a message sent by Dhilip on the >system. If you received this email by mistake, please just ignore >it. After a short time the message will be removed from the system. > >Have fun! >The Badoo Team > >You have received this email from Badoo Trading Limited (postal >address below). >http://eu1.badoo.com/impersonation.phtml?lang_id=3&email=zope%40zope.org&bl… >Badoo Trading Limited is a limited company registered in England and Wales >under CRN 7540255 with its registered office at Media Village, 131 - >151 Great Titchfield Street, London, W1W 5BB. >

2 1

★ Zope, Dhilip left a message for you
by Badoo 15 Jan '13

15 Jan '13

Dhilip left a message for you Its sender and content will be shown only to you and you can delete it at any time. You can instantly reply to it, using the message exchange system. To find out what was written to you, just follow this link: http://eu1.badoo.com/0308700839/in/aK06D1M0TPk/?lang_id=3&g=57&m=21&mid=50f… Some other people in the area who are on Badoo Suhail (Bengaluru, India) Maria (Bengaluru, India) Kays Snkay (Jakarta, Indonesia) http://eu1.badoo.com/0308700839/in/aK06D1M0TPk/?lang_id=3&g=57&m=21&mid=50f… If clicking the links in this message does not work, copy and paste them into the address bar of your browser. This email is a part of delivering a message sent by Dhilip on the system. If you received this email by mistake, please just ignore it. After a short time the message will be removed from the system. Have fun! The Badoo Team You have received this email from Badoo Trading Limited (postal address below). http://eu1.badoo.com/impersonation.phtml?lang_id=3&email=zope%40zope.org&bl… Badoo Trading Limited is a limited company registered in England and Wales under CRN 7540255 with its registered office at Media Village, 131 - 151 Great Titchfield Street, London, W1W 5BB.

1 0

attribute/name error after server migration… please advise?
by Dan Gaibel 10 Jan '13

10 Jan '13

Hi folks, I'm in the process of migrating to a new server, and I've bumped into a problem. I'm using macports and virtualenv to get everything to play nicely on my OS X 10.8 server. It's admittedly a atypical configuration... The python version has moved from 2.3.5 to 2.4.6. The Zope version is the same at 2.8.6.Everything works great, except for ONE folder. It's quite frustrating to not even be able to go to /manage on this folder. When I go to any object within this particular folder, I get: (thanks in advance for any guidance that you might provide!) Site Error An error was encountered while publishing this resource. AttributeError Sorry, a site error occurred. Traceback (innermost last): * Module ZPublisher.Publish, line 188, in publish_module_standard * Module Products.s.PatchStringIO, line 51, in new_publish * Module ZPublisher.Publish, line 145, in publish * Module Zope2.App.startup, line 216, in zpublisher_exception_hook * Module ZPublisher.Publish, line 105, in publish * Module ZPublisher.BaseRequest, line 443, in traverse * Module ZPublisher.BaseRequest, line 547, in old_validation AttributeError: __getitem__ (Also, the following error occurred while attempting to render the standard error message, please see the event log for full details: name 'REQUEST' is not defined) ________________________________ 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 error log. If the error persists please contact the site maintainer. Thank you for your patience. Digging into the error_log I have this: REQUEST form -C '' cookies __utmz '215042506.1349997112.16.7.utmccn=(referral)|utmcsr=backup.lrc.cornell.edu<http://backup.lrc.cornell.edu>:8082|utmcct=/|utmcmd=referral' __utmb '88364185' tree-s 'eJzT0MgpMOQKVneEAn2XfFt1rgIjrsSSAmMuPQB5pQeW' verify_netid 'f0ec5d8f10a3aed2e9e312df21f4555c' __utma '23486248.2137924914.1346079782.1352756706.1355855277.6' BALANCEID 'balancer.cf015' __utmc '23486248' cuwltgttime '1357806665' ql_meta_types '[]' lazy items SESSION <bound method SessionDataManager.getSessionData of <SessionDataManager at /session_data_manager>> other TraversalRequestNameStack [] URL 'http://server.lrc.cornell.edu/asian/courses/be/index_html' SERVER_URL 'http://server.lrc.cornell.edu' PUBLISHED <DTMLMethod at /asian/index_html used for /asian/courses/be> ACTUAL_URL 'http://server.lrc.cornell.edu/asian/courses/be/' URL0 http://server.lrc.cornell.edu/asian/courses/be/index_html URL1 http://server.lrc.cornell.edu/asian/courses/be URL2 http://server.lrc.cornell.edu/asian/courses URL3 http://server.lrc.cornell.edu/asian URL4 http://server.lrc.cornell.edu BASE0 http://server.lrc.cornell.edu BASE1 http://server.lrc.cornell.edu BASE2 http://server.lrc.cornell.edu/asian BASE3 http://server.lrc.cornell.edu/asian/courses BASE4 http://server.lrc.cornell.edu/asian/courses/be BASE5 http://server.lrc.cornell.edu/asian/courses/be/index_html environ CONNECTION_TYPE 'keep-alive' HTTP_USER_AGENT 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_2) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.101 Safari/537.11' HTTP_COOKIE 'tree-s="eJzT0MgpMOQKVneEAn2XfFt1rgIjrsSSAmMuPQB5pQeW"; verify_netid=f0ec5d8f10a3aed2e9e312df21f4555c; __utmz=215042506.1349997112.16.7.utmccn=(referral)|utmcsr=backup.lrc.cornel…<http://backup.lrc.cornell.edu>:8082|utmcct=/|utmcmd=referral; BALANCEID=balancer.cf015; __utma=23486248.2137924914.1346079782.1352756706.1355855277.6; __utmc=23486248; __utmz=23486248.1346079782.1.1.utmcsr=lrc.cornell.edu<http://lrc.cornell.edu>|utmccn=(referral)|utmcmd=referral|utmcct=/asian/courses/vi/viet301/; cuwltgttime="1357806665"; __utma=215042506.2123988513.1344957398.1356475993.1357831430.39; __utmc=215042506; __utma=88364185.1508772392.1357836182.1357836182.1357836182.1; __utmb=88364185; __utmc=88364185; __utmz=88364185.1357836182.1.1.utmccn=(direct)|utmcsr=(direct)|utmcmd=(none); ql_meta_types="[]"' SERVER_NAME '0.0.0.0' GATEWAY_INTERFACE 'CGI/1.1' HTTP_ACCEPT 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' SERVER_SOFTWARE 'Zope/(Zope 2.8.6-final, python 2.4.6, darwin) ZServer/1.1' REMOTE_ADDR '10.32.74.32' HTTP_ACCEPT_LANGUAGE 'en-US,en;q=0.8' SCRIPT_NAME '' REQUEST_METHOD 'GET' HTTP_HOST 'server.lrc.cornell.edu<http://server.lrc.cornell.edu>' PATH_INFO '/asian/courses/be/' SERVER_PORT '80' SERVER_PROTOCOL 'HTTP/1.1' HTTP_ACCEPT_CHARSET 'ISO-8859-1,utf-8;q=0.7,*;q=0.3' channel.creation_time 1357837924 HTTP_ACCEPT_ENCODING 'gzip,deflate,sdch' PATH_TRANSLATED '/asian/courses/be' Finally, event.log shows this: 013-01-10T12:28:34 ERROR Zope.SiteErrorLog http://server.lrc.cornell.edu/asian/courses/be/index_html Traceback (most recent call last): File "/home/zope/envLRC/Zope2.8.6/lib/python/ZPublisher/Publish.py", line 105, in publish object=request.traverse(path, validated_hook=validated_hook) File "/home/zope/envLRC/Zope2.8.6/lib/python/ZPublisher/BaseRequest.py", line 443, in traverse user=old_validation(groups, request, auth, roles) File "/home/zope/envLRC/Zope2.8.6/lib/python/ZPublisher/BaseRequest.py", line 547, in old_validation for d in groups: AttributeError: __getitem__------ 2013-01-10T12:28:34 ERROR root Exception while rendering an error message Traceback (most recent call last): File "/home/zope/envLRC/Zope2.8.6/lib/python/OFS/SimpleItem.py", line 209, in raise_standardErrorMessage v = s(client, REQUEST, **kwargs) File "/home/zope/envLRC/Zope2.8.6/lib/python/OFS/DTMLMethod.py", line 144, in __call__ r=apply(HTML.__call__, (self, client, REQUEST), kw) File "/home/zope/envLRC/Zope2.8.6/lib/python/DocumentTemplate/DT_String.py", line 476, in __call__ try: result = render_blocks(self._v_blocks, md) File "/home/zope/envLRC/Zope2.8.6/lib/python/DocumentTemplate/DT_Util.py", line 196, in eval return eval(code, d) File "<string>", line 1, in <expression> File "/home/zope/envLRC/Zope2.8.6/lib/python/OFS/DTMLMethod.py", line 137, in __call__ r=apply(HTML.__call__, (self, client, REQUEST), kw) File "/home/zope/envLRC/Zope2.8.6/lib/python/DocumentTemplate/DT_String.py", line 476, in __call__ try: result = render_blocks(self._v_blocks, md) File "/home/zope/envLRC/Zope2.8.6/lib/python/DocumentTemplate/DT_Util.py", line 196, in eval return eval(code, d) File "<string>", line 1, in <expression> NameError: name 'REQUEST' is not defined

2 7

Removing Zope and Python version info from request header
by Allen Schmidt Sr. 08 Jan '13

08 Jan '13

I know I have seen this in the past but can't find any references as to how to do this. Anyone have a quick pointer?

2 1

Re: [Zope] external method and forms
by murat bilal 07 Jan '13

07 Jan '13

At last I find and change everything.Now it looks like this: ------MY DTML DOCUMENT----- <form action="" method="post"><br /> <p><br> KULLANICI ADI <br> <input type="text" name="name"> <p><br> SIFRE<br> <input type="text" name="sifre"> <p><br> SIFRE YENIDEN<br> <input type="text" name="sifret"> <input type="submit" name="formParams:action" value="degistir"> </form> ----MY EXTERNAL PYTHON METHOD------ import crypt import MySQLdb def formParams(self,name,sifre,sifret): conn = MySQLdb.connect(host="localhost", user = "xxxx", passwd = "yyyy", db = "xxxzzz") cursor = conn.cursor() self.name=name self.sifre=sifre self.sifret=sifret if sifre == sifret: cryp = crypt.crypt(sifre,'mysecret') cursor.execute("""update mytable set PASS_WORD=%s where USERNAME=%s""",(cryp,name)) return "BASARI ILE DEGISTIRILDI" else: return "Sifreler uyusmadi.Tekrar deneyiniz." cursor=conn.close() On Mon, Jan 7, 2013 at 11:16 PM, Mike Cullerton <plone(a)bakednotfried.com>wrote: > It looks like you missed some quotes. > > this line > cryp = crypt.crypt(sifre,'mysecret') > > should probably be > cryp = crypt.crypt('sifre','mysecret') > > Mike > > On Jan 7, 2013, at 1:33 PM, murat bilal <murat.bilal(a)gmail.com> wrote: > > Hi, > > I try to make a simple paswd recovery page for my site.Username and > password stored in mysql db.My DTML document is: > <form action="deg" method="POST"> > <h2>Şifre değiştirme sayfasına hoşgeldiniz<h2> > <br> > KULLANICI ADI: <br><input type="text" name="name:ignore_empty"></br> > <p><br> ŞİFRE: <br> <input type="text" name="sifre:ignore_empty"></br> > <p><br> ŞİFRE TEKRAR: <br> <input type="text" > name="sifret:ignore_empty"></br> > <p><br> <input type="submit" value="yenile" align="center" > > <dtml-var "deg(REQUEST)"> > </form> > > and my external python method is as follows: > > import crypt > import MySQLdb > conn = MySQLdb.connect(host="localhost", > user = "rxxxx", > passwd = "yyyy", > db = "zzzz") > cursor = conn.cursor() > #return context.responseMessage() > def deg(self): > > cryp = crypt.crypt(sifre,'mysecret') > if request.form["sifre"] == request.form["sifret"]: > cursor.execute("""update mytable set PASS_WORD=%s where > USERNAME=%s""",(cryp,name)) > print "SUCCESS" > else: > print "please try again!" > cursor=conn.close() > But when i tested from DTML Document I got this error > > *Error Type: NameError* > *Error Value: global name 'sifre' is not defined* > > Can anybody help me? > > Regards > > MuratB > > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > https://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > https://mail.zope.org/mailman/listinfo/zope-announce > https://mail.zope.org/mailman/listinfo/zope-dev ) > > >

1 0

external method and forms
by murat bilal 07 Jan '13

07 Jan '13

Hi, I try to make a simple paswd recovery page for my site.Username and password stored in mysql db.My DTML document is: <form action="deg" method="POST"> <h2>Şifre değiştirme sayfasına hoşgeldiniz<h2> <br> KULLANICI ADI: <br><input type="text" name="name:ignore_empty"></br> <p><br> ŞİFRE: <br> <input type="text" name="sifre:ignore_empty"></br> <p><br> ŞİFRE TEKRAR: <br> <input type="text" name="sifret:ignore_empty"></br> <p><br> <input type="submit" value="yenile" align="center" > <dtml-var "deg(REQUEST)"> </form> and my external python method is as follows: import crypt import MySQLdb conn = MySQLdb.connect(host="localhost", user = "rxxxx", passwd = "yyyy", db = "zzzz") cursor = conn.cursor() #return context.responseMessage() def deg(self): cryp = crypt.crypt(sifre,'mysecret') if request.form["sifre"] == request.form["sifret"]: cursor.execute("""update mytable set PASS_WORD=%s where USERNAME=%s""",(cryp,name)) print "SUCCESS" else: print "please try again!" cursor=conn.close() But when i tested from DTML Document I got this error *Error Type: NameError* *Error Value: global name 'sifre' is not defined* Can anybody help me? Regards MuratB

1 0

Read-only mode for Zope 2.8.6?
by Dan Gaibel 03 Jan '13

03 Jan '13

Happy new year, Zope gurus! I am migrating to a new server and I'd like to be able to put the old machine into a read-only mode so that no new transactions occur as I transfer data over. In zope.conf there is a "read-only-database" directive, which I set to "on" and it has no effect (I can still make changes.) Is there an easy way to make the database inaccessible for updating? Many thanks, Dan

1 0