August 2001 - Zope - Zope lists

invokeFactory....
by Rustad, Aaron 24 Aug '01

24 Aug '01

Anyone know where invokeFactory is? It gets called by the action in folder_factories. I would like to add default pages when a new folder is created. Thanks! AR.

2 1

RE: [Zope] ZSQLMethod modification
by Schmidt, Allen J. 24 Aug '01

24 Aug '01

Don't leave us hanging! How did you do it? -Allen Kerekes Lajos wrote: >> Hi! >> >> I have an ZSQL method, named testSQLMethod. >> How can I modify this from python script? I try this, but it >> cant find manage_edit. >> >> container.manage_edit(title="testSQLMethod", >> connection_id="Test_Oracle", arguments="", template=query) >Sorry. I found the way. > > Bye: > > Lajos Kerekes

2 1

ZSQLMethod modification
by Kerekes Lajos 24 Aug '01

24 Aug '01

Hi! I have an ZSQL method, named testSQLMethod. How can I modify this from python script? I try this, but it cant find manage_edit. container.manage_edit(title="testSQLMethod", connection_id="Test_Oracle", arguments="", template=query) Thanks: Lajos Kerekes

1 1

Zope/PostgreSQL/PoPy
by Matt Hand 24 Aug '01

24 Aug '01

Hello all, I have successfully installed the PoPyDA product in Zope and am able to query existing PostgreSQL databses but am getting the following error when I try to INSERT a new record into the database: Error, exceptions.NameError: global name 'string' is not defined <snip/> File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 544, in __call__ (Object: <string>) File /usr/local/zope/lib/python/Shared/DC/ZRDB/sqlvar.py, line 206, in render (Object: job_num) File /usr/local/zope/lib/python/Products/zpopyda/PoPy_DA.py, line 103, in sql_quote__ (Object: RoleManager) NameError: (see above) I'm using the <dtml-sqlvar name type="string"> tag to insert the variables, which works fine when I use Gadfly. If anyone has any suggestions (or a FM I can R), I be most appreciative. Thanks, Matt Hand matt(a)bitflip.com

6 10

permissionsOfRole
by Ivan Raikov 24 Aug '01

24 Aug '01

Hello, I have the following situation: in a custom Folder object, there's a permissionsOfRole method, which is a slightly modified form of the original in AccessControl.Role in that it filters out all the permissions that do not belong to my product (and their names have a certain prefix, so that they can be distinguished from the default Zope permissions). I'm also using the roleEdit DTML file from the Zope distribution. It uses the permissionsOfRole method in order to present the user with all permissions that are assigned to a certain user-defined role, and, in my case it finds the modified permissionsOfRole method via acquisition, and correctly displays only the permissions that have been defined within my product. I also have a piece of code that tries to retrieve all the permissions for a certain role from within an object that's contained in the aforementioned custom Folder. When this code calls self.permissionsOfRole on a role that has been successfully edited via the DTML form, it receives strange results: the user-defined role appears to have _no_ permissions associated with it, although it has just been edited via the DTML interface. I tried creating new roles multiple times, but whenever I call permissionsOfRole programmatically, I get an empty set of permissions. Has anyone experienced similar problems with permissionsOfRole? Please let me know... Regards, Ivan Raikov

1 0

image upload
by Roman V. Isaev 24 Aug '01

24 Aug '01

Ick. Ack. I've switched from zope's standalone webserver to apache + fastcgi + zope and so far it looks stable and doesn't go wild with that accept error. But I stumbled on another problem -- images do not upload correctly at all. Then stared apache at port 80 and zope at 8080. If I upload image through site:8080/manage interface it uploads fine. But if I upload image through site/manage (or my own cgi form), image corrupts on the way! When I export both good and bad images into xml format and diff them, these files are slightly different in binary part. What can corrupt image on its way through apache and fastcgi? Of couse, it's easy to say use 8080 port to update the site. Unfortunately, I can't run zope at 8080 port, because of previous bug with accept :( I can't find that bug because it happens only once in two or three days, only under normal conditions (i.e. I ran httperf and put a big load on the site... everything worked okay, only to hang several hours later). And since my boss is very unhappy with webserver going down at odd hours when I'm unavailable, I can't really debug this situation :( -- Roman V. Isaev http://www.aroma.ru System Administrator P.S. My configuration is: Apache/1.3.20 mod_fastcgi/2.2.10 zope 2.4.0 python 2.1.1 openbsd 2.7

3 4

RAM [was MERLINO Nuovo Motore di ricerca Italiano]
by Huston, Virgil H. 24 Aug '01

24 Aug '01

This is true, but what I really don't get is the spam from China or Taiwan where my email client only sees a bunch of gibberish :-) To get on topic, is there a minimum amount of RAM required for good Zope performance on a Raq3? Or will it work fine for lower traffic sites with a lessor amount? Thanks, Virgil > Im my opinion, yes. Here's why: > > Most English spam we tend to ignore, because we immediately recognize it > AS > spam. We don't even bother to read or skim thru the message. > > Now Italian spam, it captures our attention. It looks different, which > draws > in our attention. Even if you can't read it, you still tend to skim thru > the > message, trying to discern what certain sentences, phrases, or sections > mean. So even though it IS spam, AND you can't understand it, you still > spend 5 minutes reading it. > >

2 1

API of ObjectManager
by Thomas Guettler 24 Aug '01

24 Aug '01

Why is _getOb() private (leading underscore)? -- Open Source Software Solutions Thomas Guettler <thomas(a)thomas-guettler.de> http://www.thomas-guettler.de

2 1

(no subject)
by sanket.deshmukh＠medienhaus-bremen.de 24 Aug '01

24 Aug '01

hello friends, can u please tell me where can i find information about the zope converters. this symbol " : " here are some example, <input type="submit" name="fireEmployees:action" value="Fire!"> <input type="text" name="people.lname:records"></p> i want to know the various possible use of these converters. i couldn't find detail information in the zope documentation. thanks, Sanket.

3 2

Re: [Zope] Zope/PostgreSQL/PoPy. Solution v0.0.1. Author: Jim Penny
by Antonio Carrasco 24 Aug '01

24 Aug '01

Hello again. I´m at work now and I´ve tried some codes. Sorry again, I´m spanish and my english is quite bad. ----- Original Message ----- From: "Jim Penny" <jpenny(a)universal-fasteners.com> To: "Antonio Carrasco" <antoniojezu(a)hotmail.com> Sent: Thursday, August 23, 2001 11:59 PM Subject: Re: [Zope] Zope/PostgreSQL/PoPy > On Wed, Aug 22, 2001 at 11:50:05PM +0200, Antonio Carrasco wrote: > > Ok, Jim, Let?s go again... > > > > > select from Departments where name=<dtml-sqlvar name type=string> > > I tried it. > > > > > > > > Also, > > > does > > > select from Departments where name='<dtml-var name sql_quote>' > > > work? OK! It works successfully! And it seems to be a good solution. Because: "<< sql_quote Converts single quotes to pairs of single quotes. This is needed to safely include values in SQL strings. >>". From Zope Help System, DTML Reference, var. But, Why doesn´t <dtml-sqlvar name type=string> work?. I think everyone of us want to know. > > Now just a cotton picking minute. The form just above does not > reference string at all. I don't see how it can be failing on > a string error message. > > This is not suitable for production code, due to security reasons. > does > select from Departments where name='<dtml-var name>' > work? Yes, it works too. But we have the security problem. "<<In addition to avoiding errors, SQL quoting is important for security. Suppose you had a query that makes a select: select * from employees where emp_id=<dtml-var emp_id> This query is unsafe since someone could slip SQL code into your query by entering something like 12; drop table employees as an emp_id. To avoid this problem you need to make sure that your variables are properly quoted.>>" From ZopeBook. Chapter 10: Relational Database Connectivity, Dinamic SQL queries, Inserting arguments with sql-var. Anyway. <dtml-var name sql_quote> doesn´t resolve our problem because: "<< SELECT * FROM Departments <dtml-sqlgroup where> <dtml-sqltest id op=eq type=int optional> <dtml-and> <dtml-if nombre> nombre='<dtml-var name sql_quote>' </dtml-if> </dtml-sqlgroup> >>".From my code. We have to use dtml-if in all our multiple arguments queries with strings. Or is there another way to do it? > > (Make sure punctuation is exactly as shown.) > > Jim > > > > > I have tried it. > > And I have tried another ways. But nothing. I have been today two hours > > making and thinking different ways. My last try is find someone who can make > > the query without problems in this list. Farrell seems to be. But in RedHat. > > Tomorrow I?m going to write and specifie all the products version data and > > OS used(It?s Linux, but I can?t remember now more). Thanks again. Jim > > > > Antonio Carrasco > > > > > Thanks a lot, Jim and others. I wish I help all you someday. Antonio Carrasco

3 2