- Zope - Zope lists

Re: [Zope] Help Help Help
by Kevin Dangoor 27 May '99

27 May '99

This is a MySQL access issue. The user that is trying to access the database (possibly 'nobody' depending on how your webserver is set up) is not in the mysql access tables. Check out the MySQL docs for info on how to configure access. Also, don't forget to refresh the mysql server so that it reads in your revised grant tables after you've made changes. Kevin CURTIS David wrote: > Greetings, > > I am a newbie who needs help! I recently installed Zope 1.10.2 (most stable version), MySQL and python 1.5.1. I am trying to connect to the MySQL database. I get the following error: > Errorm MySQL, error > Access denied for user '@localhost' to database 'database1' > SQL used > select * > from table1; > > Any ideas would be very apprechiated!!! > Also, In the Add Connection I have the > following items setup. msql database1 > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev )

1 0

Help Help Help
by CURTIS David 27 May '99

27 May '99

Greetings, I am a newbie who needs help! I recently installed Zope 1.10.2 (most stable version), MySQL and python 1.5.1. I am trying to connect to the MySQL database. I get the following error: Errorm MySQL, error Access denied for user '@localhost' to database 'database1' SQL used select * from table1; Any ideas would be very apprechiated!!! Also, In the Add Connection I have the following items setup. msql database1

1 0

RE: [Zope] Variablizing size parameter
by Jay, Dylan 27 May '99

27 May '99

> -----Original Message----- > From: Martijn Pieters [mailto:mj@antraciet.nl] > Sent: Thursday, May 27, 1999 18:17 > To: Jay, Dylan; 'zope(a)zope.org' > Subject: Re: [Zope] Variablizing size parameter > > > At 08:54 27/05/99 , Jay, Dylan wrote: > >I want to variablize the size parameter as I have done below > > > ><TR> > > <TD VALIGN="TOP"> > > <STRONG></STRONG> > > </TD> > > <TD VALIGN="TOP"> > > <i></i> > > </TD> > ></TR> > > > >It seems however that I get the error "a size attribute was > used in a var > >tag with a non-integer value.". So it appears to me that > this can't be done. > >Is that so? > > Is it a property on a DTML Document or Folder? If so, you can > specify it as > being a integer, instead of a string. > > If the variable came from a form, you can add :int to the > name on the form > (filedID:int) so Zope will cast it to an integer. This will make the > variable required, however. > > You could also convert the variable to an integer on the spot, using > _.string.atoi, like so (untested): > >  Sorry, I should have specified. Its coming from a namspace ie  Which I'm presuming would keep fieldSize as an int?

1 0

Re: zope on a nearly bare win98 box?
by zhaoway 27 May '99

27 May '99

[snip] >> Got bunch of err msg ended with >> "ImportError: No mudule named ExtensionClass" > > ExtensionClass is a C extension module. It ships with Zope, but >uncompiled for obvious reasons. wo_pcgi.py tries to compile it, but if you >don't have a C compiler installed, you're SOL. You can get a good, free >compiler from www.cygnus.com. cygwin is what i've got. could you be kind enough to put a HOW-TO guide on my situation now :) TIA --zhaoway

2 1

RE: [Zope] zope on a nearly bare win98 box?
by Michel Pelletier 27 May '99

27 May '99

> -----Original Message----- > From: zhaoway [mailto:zhaoway@mud.jlonline.com] > Sent: Saturday, May 29, 1999 10:47 AM > To: Zope > Subject: [Zope] zope on a nearly bare win98 box? > > > Dear Zoper, > > I wanna learn zope by practising. > I wanna test Chinese. I currently have no Linux box by hand. > And Linux cannot support Chinese inputing very well. > (If all goes well, I will make a probablly big site > on the Zope on top of a local distribution of Linux system, > Xteam Linux, if you wanna know :) > > I got python 1.5.2 installed on my Windoze. > Zope 2.0.0a1 compiled from src with double clicking > on wo_pcgi.py and got compiled well, I guess :) > > Then following the INSTALL.txt, I tried > \path\python z2.py -d 127.0.0.1 > Got bunch of err msg ended with > "ImportError: No mudule named ExtensionClass" > ExtensionClass, and several other Zope components, are written in C. If you do not have a C compiler on this windows box, then it will not work. 2.0.0 is alpha software. I do not recommend running it unless you are prepared to go to some extra effort to bootstrap yourself into using it. We cannot help you install it because all of our resources are commited to fixing bugs in 2.0, not doing tech support on install issues. I'd recommend downloading 1.10.2, which comes with Windows binaries. -Michel > Sure I have no Name server running on my box. > (Seems it won't be easy to find one.) I've Hosts > file under /windows though. > > Please someone could help me out. If necessary, > I could go downloading some bit. TIA > > --zhaoway > > .________________________________ > /http://mud.jlonline.com/~zhaoway\ 闷罐船 > \zhaoway(a)public1.ptt.js.cn / 水世界 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

zope on a nearly bare win98 box?
by zhaoway 27 May '99

27 May '99

Dear Zoper, I wanna learn zope by practising. I wanna test Chinese. I currently have no Linux box by hand. And Linux cannot support Chinese inputing very well. (If all goes well, I will make a probablly big site on the Zope on top of a local distribution of Linux system, Xteam Linux, if you wanna know :) I got python 1.5.2 installed on my Windoze. Zope 2.0.0a1 compiled from src with double clicking on wo_pcgi.py and got compiled well, I guess :) Then following the INSTALL.txt, I tried \path\python z2.py -d 127.0.0.1 Got bunch of err msg ended with "ImportError: No mudule named ExtensionClass" Sure I have no Name server running on my box. (Seems it won't be easy to find one.) I've Hosts file under /windows though. Please someone could help me out. If necessary, I could go downloading some bit. TIA --zhaoway .________________________________ /http://mud.jlonline.com/~zhaoway\ 闷罐船 \zhaoway(a)public1.ptt.js.cn / 水世界 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2 1

RE: [Zope] ZODB and large data sets
by Michel Pelletier 27 May '99

27 May '99

> -----Original Message----- > From: Riedel [mailto:s.ridel@arcormail.de] > Sent: Wednesday, May 26, 1999 6:01 PM > To: Howard Clinton Shaw III > Cc: Jimmie Houchin; zope(a)zope.org > Subject: Re: [Zope] ZODB and large data sets > > > Hi, > > first i'm sorry for my English :-I > > I wont use ZOPE for a big commercial use case, i must programming a > trading system: > > 1.) Do you thing ZOPE is ready for big use cases ? Yep. We've easily stored on the order of a million objects and the DB didn't mind at all. I would be confident going two orders of magnitude over that (100 million). I am being conservative with that estimate, Jim may give good technical reasons why you could go even higher. > 2.) I need big databases to ! Remember, Zope has excellent relational database integration. Zope and SQL servers have a very powerful symbiotic relationship. If you have lots of tabular, relational data and you'd like to use that data from other tools too, using SQL as part of your backend can be a very good idea. -Michel > > thanks a lot > Steph > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

RE: [Zope] New Zope user...how to create lists...and what happens to files
by Michel Pelletier 27 May '99

27 May '99

> -----Original Message----- > From: steve(a)hosys.com [mailto:steve@hosys.com] > Sent: Wednesday, May 26, 1999 11:41 PM > To: zope(a)zope.org > Subject: [Zope] New Zope user...how to create lists...and what happens > to files > <snip> > > -------------------------------------------------------------- > -------------- > -------- > doAddPosting (this is the document that takes the variables from the > AddPosting > document, creates a new "applicant record" and stuffs the > data into the new > rec, > and calls index_html which displays the updated list > -------------------------------------------------------------- > -------------- > -------- > >  >  >  >  >  >  BTW, here your not actually creating anything, just rendering variable passed into this method. > >  Well here is where you have great freedom. You can use a ZSQL method to insert your applicant into a table, or you can use a ZClass and instanciate an 'applicant' object. You could also use an external method to write the information out to disk so you can use it in another system (however if that other system supported SQL it would be preferable to use SQL) or you can use ZTables, a commercial product from Digital Creations. Of these I would recommend ZTables first, and SQL second. I would not recommend instanciating a ZClass because they are not designed to hold vast quantities of relational like information, they are good at abstracting out new Zope objects. Writing to a filesystem is a pretty ugly hack. Assuming you want to go the cheaper way (unless you pay more for your SQL server than ZTables costs (BTW, when you buy ZTables you get the source code, it's just not open and you can't redistribute it in any way)) then you probably will install a SQL server, create a Database Connection to that server, and then write a ZSQL method an 'INSERT' SQL operation in it. Then you can just call the method at this point. Note that your method must be looking for the above variables (in it's Arguments field) and that the above arguments should be valid, otherwise it will fail with an exception, so you may want to sanity check all your variables in some  blocks.  <h1>You got a name, right?</h1>    > >  > Why are you calling this here? It looks like you just want it to show the user information in a table, when you showed the information above. Perhaps you should factor this out and make the display of all users or a range of users a different component, and keep your component that adds records a simple component that just adds records. Overburdening one system with two functions is a recipie for bad design. Also, I wouldn't call a method in this context index_html, index_html has the special feature of being the default method called of an object (like a folder) if you don't specify one. Unless you plan on making this method also the default method, *and* you want to call it here, then go for it, otherwise I'd call it something like showTabulatedUsers or such. -Michel > > -------------------------------------------------------------- > -------------- > --------- > index_html should build a table from a list pf recoreds (instances) > -------------------------------------------------------------- > -------------- > --------- > > >

1 0

Python-Web (Zope if possible) Contract Northern VA
by steve＠hosys.com 27 May '99

27 May '99

Have immediate need to get fairly simple web app on line by June 4 (mock up on line at www.hosys.com/cfc <http://www.hosys.com/cfc> with login:steve passwd: panpanpan. Prefer to use Python (Zope in particular) but will consider other options. Much work can be remote, but some on-site likely. Any independent minded folks want to give it a go for $75-$100/hr ? Companies also welcome to reply... Please contact Steve Hunter Hunter Object Systems Inc. 12166 Derriford Ct. Woodbridge Va. 22192 703-878-2475, steve(a)HOSYS.com <mailto:steve@HOSYS.com>

1 0

RE: [Zope] RE: What method do I use to check access?
by Rob Page 27 May '99

27 May '99

> I'm not sure what your proposing other than using having > different roles for > each restricted area. And that makes roles a restrictive > device. I have Yes, this was what I was proposing. > several areas and several groups of users. My roles represent > a type of user > not a type of access to a particular area. A role may enable > access to many > areas. This is how it supposed to work with roles as I understand it. > The problem I'm trying to addess, which for some reason I > can't seem to get > across to anyone, is as follows. If say I development area to > only users > with role developer this is fine. I can then in my main page > add a link to > this development area that is viewable to only developers like so > >  > <LI> <A HREF="development_area/index_html">Development Area</A> >  > > This is fine and what I currently do. My argument is that if > later I want > say users with supervisor role to access the development area > then I have to > change the permissions on the development are and find all > the has_role > conditions in my code and change them. This is not huge point > I realize but > it seems to me a logical function that I should be able to > perform. Show > something if the user has permission to see it. It also means I can > conditionally include DTML only if that user has permission > to view that > DTML. > ie What if you could define assign a role to a role? In your example above you have the developer role and the supervisor role. You might then be able to assign the developer role to the supervisor role. Now, this IS NOT the way it works today. Would this approach meet your requirement? With this approach the notion of role becomes much more like a notion of groups. >  >  >  At first glance exposing this stuff at this level would be pretty difficult since different objects can have different permissions associated with them. --Rob

2 1