- Zope - Zope lists

damn sophisticated mysql security
by Horst Wald 04 Jan '02

04 Jan '02

Hello, MySQL is so damn secure I can't access my own database!!! .. but only if I try to connect to the MySQL-Server on the same host like the Zope-server; I get: Error Type: OperationalError Error Value: (1045, "Access denied for user: 'hsql@localhost' (Using password: YES)") I can connect to a MySQL-Server on a remote machine without problems. Let's see if I understood what you have to do if you want to connect to the Database "MyDataBase", being the user "MyUser" on the local machine with the IP "195.196.197.198" using the password "MyPassWord": 1. become root 2. mysql 3. create database MyDataBase; 4. use mysql 5. insert into db values ('195.196.197.198','MyUser','MyPassWord','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); 6. insert into user values('195.196.197.198','MyUser',PASSWORD('MyPassWord'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); 7. flush privileges; (or even restart MySQL or even reboot the computer) 8. then (in Zope) add a ZMySQLDatabaseConnection with the connection string "MyDataBase MyUser MyPassWord", deliberately omitting the host Any easier way? The easiest way? What I'd like best would be to disable the whole MySQL-security-stuff so I can start to work at last. I can care for security later. Thanks in advance Horst _________________________________________________________________ Testen Sie MSN Messenger für Ihren Online-Chat mit Freunden: http://messenger.msn.de

3 2

designing Python Scripts
by Roy Mathew 04 Jan '02

04 Jan '02

Dear ZoPeople, What is the normal way to handle complex logic in a PythonScript. I have a piece of code that is sufficiently complex, that it makes sense to have a number of classes and methods for it, but Zope doesn't seem to like the use of classes inside PythonScripts. Would one simply use External Scripts for this, or is there a a more "standard" way, such as fiddling with the access controls? Thanks, Roy. __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com

2 1

verifying existence
by Steven Turoff 04 Jan '02

04 Jan '02

Greetings, I am trying to figure out how a page can tell if it exists or is displayed using acquisition. For example, say I have defined /index_html but have not defined services/index_html. I know that I can do something like: <dtml-with "services.index_html.aq_explicit" only>

1 0

Re: [Zope] sorting a table
by hans 04 Jan '02

04 Jan '02

quoted manually from digest: >MySQL, as most SQL engines has sort capabilities. I use this feature in ZSQL >method like this: >Parameters : >order mode >ZSQL script: >select field1, field2, field3 from mytable where (...) order by <dtml-var >order> <dtml-var mode> >Pass as strings to this ZSQL method : >order : either 'field1', 'field2', 'field3' >mode: 'ascending' or 'descending' >The syntax may depend on your db engine. in DTML it looks like this for eg. sort col = FIELD: make the column heading an URL: <th> <a href="<dtml-var document_id >?col=FIELD&dir=<dtml-if "col=='TOP_NAME' and dir=='asc'" >desc<dtml-else >asc</dtml-if>" >Topic <dtml-if "col=='FIELD'"><dtml-if "dir=='asc'">V<dtml-else>A</dtml-if><dtml-else>=</dtml-if ></a> </th>

1 0

Q: How can i check the existence of an image?
by Andreas Pelzner 04 Jan '02

04 Jan '02

Hi Zopes, How can I check the existence on an image file in my image folder. I coded a workaround, but it doesn't fit my needs exactly: <dtml-let myTemp=id> 'Build the image file name <dtml-let MyID="'theme_'+myTemp+'.gif'"> 'loop over each image in the image folder <dtml-in expr="images.objectValues('Image')"> ' String find <dtml-if "_.string.find(id(),MyID) > -1"> ' -> if there is a matching file print image in HTML <img src="/images/<dtml-var id>" width="145" height="129"> 'print image in HTML </dtml-if> </dtml-in> </dtml-let> </dtml-let> ...but I'm looking for something like this: 'check if true or not <dtml-in expr="images.<image_name>"> TIA Gruesse Andreas Pelzner, AixVision GmbH,

1 0

Breadcrumbs with Squishdot
by Pieter Claerhout 04 Jan '02

04 Jan '02

Hello all, I'm trying to use breadcrumbs in my site, and all seems to work fine, except for the Squishdot part. Here's what I have setup so far. I have put the following code in my standard_html_header (which is in the root of my zope tree) to show the breadcrumbs: <dtml-in PARENTS reverse> <a href="<dtml-var absolute_url>"><dtml-var title_or_id></a> <dtml-unless sequence-end>»</dtml-unless> </dtml-in> In the root of my Zope tree, I also have a instance of squishdot, called news, that inherits the standard_html_header from the root of the tree. Strangely enough, wherever I am in the squishdot site, it doesn't take the title of the item I'm looking at (such as the title of a news item), but it always takes the title of the squishdot instance itself. Does anyone know how we can fix this? Thanks, Pieter

2 3

Folder and OrderedFolder
by Dirk Datzert 04 Jan '02

04 Jan '02

Hi, has anybody a pyhton script to change a Folder object into a OrderedFolder object ? Thanks, Dirk Datzert Rasselstein Hoesch GmbH Informatik / Anwendungsentwicklung D-56626 Andernach Koblenzer Strasse 141 http://www.rasselstein-hoesch.de Tel.: +49 (0) 2631 81-4595 Fax.: +49 (0) 2631 81-15-4595 mailto:Dirk.Datzert@rasselstein-hoesch.de

1 0

Re: [Zope] Capturing Site Errors
by Anthony Baxter 04 Jan '02

04 Jan '02

>>> marc lindahl wrote > I wouldnt do this - I got nailed by the NIMDA worm. 1000's of computers > that caught it after sept. 11th were each accessing something like 11 wierd > paths, which of course didn't exists, so my admin account was flooded with > over 100K emails within a couple of days. I would recommend doing a little > extra work and make it a form which has to be submitted by the user. > Otherwise, just check the log files. Or make sure that the 'not found' errors don't generate an email message. Anthony

1 0

zope<->flash<->Zsql
by mick polo 04 Jan '02

04 Jan '02

hi all, does anyone out there know how do I pass variables between flash and Zsql in zope? I can get the flash file to display in zope but to pass variables to and from Zsql methods is driving me nuts!! help! mike. _________________________________________________________________ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com

2 1

RE: [Zope] Photo: somes issues and thoughts
by Keith J. Farmer 04 Jan '02

04 Jan '02

version 1.2.3 Note that I've modified the ExtFile filename generator to use the ZODB path rather than the URL path (I have virtual hosts, and wanted each to be kept seperate). ---------- Keith J. Farmer kfarmer(a)thuban.org http://www.thuban.org -----Original Message----- From: Ron Bickers [mailto:rbickers-dated-1010728651.ce7a9e@logicetc.com] Sent: Thursday, January 03, 2002 21:58 Are you running the latest version 1.2.3? The SYNC setting is supported in that version so that cached photos (and the original) are stored in a ZODB hierarchy matching directory.

1 0