- Zope - Zope lists

Re: sql_quote in dtml-var in zsql-Methods
by Elena Schulz 11 Aug '03

11 Aug '03

Hi Jim, > poof, goodbye data! thank you very, very much for your extensive answer. It enlighted my understandig a lot and I think it should be made more public, may be as a part of the Zope Book ZSQL-Section. I didn't find it that clear elsewhere and I am shure it will prevent many others from data loss ... My problems checking sql_quote were that I didn't use the ' ' around '<dtml-var color sql_quote>' so there could be no effect of course. I will take your advice of restrict myself of getting > cute trying to build all-singing, all-dancing queries. > The simpler the query is, the easier it is to audit, the easier it is to maintain, and the easier it is to modify. For SQL-Queries the philosopie "less is more" doesn't seem to be true. -- So thanks again, Elena

1 0

Problems installings TextIndexNG
by Roel Van den Bergh 11 Aug '03

11 Aug '03

Hi all, I tried installing TextIndexNG following the installation instructions but I'm stuck. Everytime I restart Zope I get the following error. I compiled puython extensions for TextIndexNG with Python-2.1.3 installed from source Zope 2.5.1 installed from source using Python 2.1.3 on fully patched (trough up2date) RedHat 7.3 from scratch last thursday Any suggestions? TIA, Roel [root@PlanetInterior 2-5-1]# ./start -D ------ 2003-08-10T09:35:01 INFO(0) Transparent Folders Applied patch version 0.3.2. ------ 2003-08-10T09:35:03 INFO(0) Hotfixes Applying Hotfix_2002-04-15 ------ 2003-08-10T09:35:03 INFO(0) NuxUserGroups.BasicUserWithGroups Patching BasicUser ------ 2003-08-10T09:35:03 INFO(0) NuxUserGroups.LocalRolesWithGroups Patching RoleManager ------ 2003-08-10T09:35:03 INFO(0) NuxUserGroups.CatalogToolWithGroups Patching CatalogTool ------ 2003-08-10T09:35:03 ERROR(200) TextIndexNG Import of Python extensions failed ------ 2003-08-10T09:37:23 INFO(0) ZODB Opening database for mounting: '142267408_1031568617.597256' ------ 2003-08-10T09:37:23 INFO(0) ZODB Mounted database '142267408_1031568617.597256' at /temp_folder ------ 2003-08-10T09:37:25 ERROR(200) Zope Couldn't install TextIndexNG Traceback (innermost last): File /home/zope/2-5-1/lib/python/OFS/Application.py, line 637, in install_product (Object: Zope) (Info: TextIndexNG) File /home/zope/2-5-1/lib/python/Products/TextIndexNG/__init__.py, line 81, in initialize File /home/zope/2-5-1/lib/python/Products/TextIndexNG/TextIndexNG.py, line 45, in ? File /home/zope/2-5-1/lib/python/Products/TextIndexNG/normalizers/__init__.py, line 14, in ? File /home/zope/2-5-1/lib/python/Products/TextIndexNG/Normalizer.py, line 12, in ? ImportError: No module named normalizer ------ 2003-08-10T09:37:26 INFO(0) Zope New disk product detected, determining if we need to fix up any ZClasses. ------ 2003-08-10T09:37:26 INFO(0) ZServer HTTP server started at Sun Aug 10 11:37:26 2003 Hostname: PlanetInterior Port: 8080 ------ 2003-08-10T09:37:26 INFO(0) ZServer FTP server started at Sun Aug 10 11:37:26 2003 Hostname: PlanetInterior Port: 8021 ------ 2003-08-10T09:37:26 INFO(0) ZServer PCGI Server started at Sun Aug 10 11:37:26 2003 Unix socket: /home/zope/2-5-1/var/pcgi.soc - - - Roel Van den Bergh Planet Interior bvba Brouwerijstraat 16 2200 Noorderwijk - Belgium tel: +32 (0)14 279393 fax: +32 (0)14 264790 http://www.planetinterior.com <http://www.planetinterior.com/> This email and any attached files are confidential and may be legally privileged. If you are not the intended recipient, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this email. Email transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore is in no way liable for any errors or omissions in the content of this message, which may arise as a result of email transmission. If verification is required, please request a hard copy.

2 2

RE: [Zope] Truncation Reading from ODBC
by David Orr 11 Aug '03

11 Aug '03

I would suggest that the issue is with the ODBC driver. I had similar issues getting data out of a DB2 database and after fiddling around for hours with code found a checkbox on a tab for the driver (DSN). Hope that helps. -----Original Message----- From: J Cameron Cooper [mailto:jccooper@jcameroncooper.com] Sent: Saturday, 9 August 2003 7:08 AM To: Zope user list Subject: Re: [Zope] Truncation Reading from ODBC > > >I'm trying to read (and later probably write) large strings to a >postgress database. >... >When I read a column with 20,000+ characters I only get the first >8194 characters. > >Is this: >1) a Zope restriction? > > This is a very unlikely cause, but I recall that certain Python data structures (files?) may look like strings up to a certain point, but then contain a link to another node with more data. You can get the whole of the contents by str(the_thing). But them, you're probably using the string type already. --jcc -- "My point and period will be throughly wrought, Or well or ill, as this day's battle's fought." _______________________________________________ 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 )

1 0

Re: [Zope] loading zope within python interpreter
by Michael Long 10 Aug '03

10 Aug '03

Thanks for the recipe. Things in 2.7 have changed significantly and to load the ZODB takes a little bit more work. This link http://mail.zope.org/pipermail/zope-dev/2003-August/020283.html has a recipe that shows how to do it. I found with 2.7.0b1 you must ignore the last 2 lines referencing *dropPrivileges*. --mike > On Fri, Aug 08, 2003 at 10:23:58AM -0400, Michael Long wrote: > > > > Hi, > > > > Is there a recipe/product that will load the ZODB as well as the zope > > environment from within the python interpreter? I would like to be able > > to play/test with a product that I am creating from within the interpreter. > > IIRC things have changed somehow for zope 2.7, but for zope <= 2.6 you > can do this: > > pw@kermit Zope-2.6.1-src $ export PYTHONPATH=lib/python/ > pw@kermit Zope-2.6.1-src $ python > Python 2.2.3 (#1, Jul 22 2003, 12:28:47) > [GCC 3.2.3 20030422 (Gentoo Linux 1.4 3.2.3-r1, propolice)] on linux2 > Type "help", "copyright", "credits" or "license" for more information. > >>> import Zope > >>> app = Zope.app() # this takes a few seconds > >>> app.objectIds() > ['acl_users', 'Control_Panel', 'standard_html_header', 'standard_html_footer', 'standard_error_message', 'index_html', 'temp_folder', 'browser_id_manager', 'session_data_manager', 'Examples', 'error_log', 'standard_template.pt'] > > -- > > Paul Winkler > http://www.slinkp.com > Look! Up in the sky! It's THE TENSILE AARDVARK! > (random hero from isometric.spaceninja.com) > > _______________________________________________ > 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 ) > >

1 0

SUMMARY: strange unicode behaviour, unicode and ZCTextIndex
by Giuseppe Bonelli 10 Aug '03

10 Aug '03

I post this for the mail archives. Everything is pretty obvious, but I think it can save some headaches to others. ABSTRACT: I hit some unicode related problems when testing a unicode aware, multilingual xml repository Zope product. What follows is what I learned and what is working (which now is, luckily enough, almost everything). T The following has been tested on Zope 2.6.1/Py2.1.3 installed from binaries on win32 (but it should be platform independent). THE QUICK ROUTE 1. have a sys.setdefaultconfig in sitecustomize.py 2. use RESPONSE.setHeader('content-type','text/html;charset=<dtml-var your_preferred_encoding>')"> in _both_ your user _and_ ZMI pages 3. let python/Zope do the encoding/decoding for you (i.e. don't use .encode(your_preferred_encoding), unless you know what you are doing) 4. You don't have to start Zope with any locale to have ZCTextIndex work nicely with unicode content. FOR THE BRAVE CURIOUSES **1. sys.setdefaultconfig** <quote from="Toby Dickenson"> <original msg from="Giuseppe Bonelli"> I have utf-8 as sys.defaultencoding and I do not load any locale when starting Zope. </original mg> That is old advice that predates Zope 2.6. It was never a particularly good idea, because it affects all of pythons internals. You only need to encode your unicode as utf-8 (or other encoding) before sending it over the network, and ZPublisher is capable of doing that itself if you tell it the encoding in the header. </quote> That's true, but you will definitely need to set a default encoding if you are going to use python code. If not set, the default encoding is ascii and you will get the usual "encode error, ordinal not in range (128)" error when doing as a simple thing as Print string_with_some_special_chars_inside. To set a default encoding: create (or edit) a sitecustomize.py file in your zope_install_dir\bin\lib (or in the phyton used by zope) and use: import sys sys.setdefaultencoding(my_encoding) ***2. content-type This is trivial for your user interface pages: just add <dtml-call "RESPONSE.setHeader('content-type','text/html;charset=<dtml-var your_preferred_encoding>')"> in the <head/> of your standard_html_header. I found it non trivial for the ZMI pages, as I discovered that the default encoding in the ZMI pages is governed by a variable named management_page_charset, which has a default of iso-8859-1 (and I was using utf-8 for automatically generated titles properties ...). If you need to change this default you can use a property named management_page_charset in the top folder of your app. This works, but is not future proof (see manage_page_header source under lib/python/app/dtml for details on this). The best option would probably be to use a <dtml-call "REQUEST.set('management_page_charset','your_preferred-encoding')">. Why REQUEST.set and not just use a meta "http_equiv=content-type" ? <quote from="Tino Wildenhain"> <original msg from="Dieter Maurer"> I never understood why the meta "http_equiv=content-type" did not work, just recognized that it did not work reliably. </original> This influencing of HTTP-headers via HTML is very problematic because 1) there are often real HTTP-headers, there seems to be no definition which takes precedence over the other 2) Downstream proxys cannot read HTML embedded HTTP-header, but base their caching strategy on the real headers. This will sometimes lead to confusing experiences In general, if you have control over the real HTTP headers, you should use it and not include something like that in HTML. With zope we are in the happy position to have control as opposite to a "web-business-card" where you just dump a couple of HTML files onto a hosters server. A patched ZPT could transport information from HTML meta to REQUEST... interesting idea. </quote> ***3. ZCTextIndex My original ZCTextIndexes problems were due to a combination of above and to leftover words from indexes removed during testing (Heisenberg Uncertainty Principle applied to s/w at play here: during testing, if you change something the testing itself is influencing the system). If you still experience problems, delete the lexicon, recreate it and reindex. If problems persist, double check that you are not mixing unicode/non unicode content in your indexes (if you followed quick route #3 above, this should not be the case). (H)ACKNOWLEDGMENTS Thanks to all who helped (Dieter, Tino, Toby, Hannu, Hugo). END NOTE As always, a debugging session is not fun, but you end up with some new python/Zope insights. __peppo

3 4

authentication via form
by BORGULYA Gergely 10 Aug '03

10 Aug '03

Hi, I'm developing a small site in Zope with a simple, own management interface (where the contets of Documents can be easily changed using forms). The last few days' change in the ZopeBook on www.zope.org seems to be very useful, thanks for the authors! Although I could not find out, how to authenticate users not by calling a zope object that needs special permissions to access, but using a form with a login/passwd box and passing the arguments to some kind of functions. Can REQUEST.['AUTHENTICATED_USER'] be modified somehow? I could not find any function that I suppose to do this. Gergely Borgulya

2 1

Re: squishdot
by Lee Harr 10 Aug '03

10 Aug '03

>I need help to install Squishdot. >In my PC I have installed Zope 2.6.2b5 and I didn't >know in what directory put the zip that gets off the >page zope.org. neither how to make to use it (Is it >necessary to configure something?) > It depends on the product zipfile.... The Squishdot folder needs to end up in ${ZOPE_DIR}/lib/python/Products/ Sometimes the zips are from the ${ZOPE_DIR} and sometimes they are from the ${ZOPE_PRODUCTS_DIR} Your best bet may be to unpack it in an empty folder and see what you get. Look for the Squishdot folder and move that in to place. There is also probably a README file in the zip that gives instructions on how to install it. _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

1 0

TextIndexNG
by Juan Manuel Ruiz Garcia 10 Aug '03

10 Aug '03

I'm trying to install TextIndexNG2.0 in my Zope. I have unzipped the distribution pack at the Products directory, as usual. Wiki-Documentation tells that I have to "grab the the prebuild TextIndexNGExtension? binaries for Windows from Sourceforge"... Well I have them, but where I should put them to make it work? Thanks in advance,

2 2

zsql-Methods: how to make a dynamic where-clause?
by Elena Schulz 09 Aug '03

09 Aug '03

Hi, is there any convenient way, to have a dynamic where-clause in zsql-Methods? All my effords had severe limitation up to now: 1. <dtml-sqltest .. needs a fixed column=.... expression 2. WHERE <dtml-var ...> with the whole clause in the var doesn't work because of quoting problems. ... So it seems that there is only very limited scope with <sql-group and explicit column=myExplicitColumnName constructs or am I missing something? A completely dynamic query with python script would be also a good alternative but how to do that? -- thanks for any input, Elena

2 2

can't pack large Data.fs (2.5GB)
by Marcus Schopen 09 Aug '03

09 Aug '03

Hi, can't pack a 2.5GB big Data.fs through the ZMI: ---------- Zope Error Zope has encountered an error while publishing this resource. Error Type: OverflowError Error Value: integer addition ---------- System: Debian woody with ext3 ---------- (Zope 2.6.2 (CVS 20030518 source release, python 2.1, linux2), python 2.1.3, linux2) Python Version 2.1.3 (#1, Sep 7 2002, 15:29:56) [GCC 2.95.4 20011002 (Debian prerelease)] System Platform ---------- If it was a LFS problem the zope wouldn't run. And I think the woody's python (Version: 2.1.3-3.2) is built with LFS support. Any ideas? Cheers, M.

1 1