- Zope - Zope lists

SQLSession not working
by Paul Zwarts 24 Jan '01

24 Jan '01

Hi all, I have a unix machine with PGSQL and Zope 2.2.1? and my app uses SQL session brilliantly. But I've created another test machine with Zope 2.2.5, Win2kPro and MySQL 3.3.23 (i think)... and SQL Session no longer works properly. Every time I call a page, a different Session is used and Im not maintaining any kind of session context... which basically destroys my whole navigation system... Beyond that, I can put stuff into MySQL using Zope, but nothing comes out... not even a simple SELECT * from TABLE does nothing... Can anyone make suggestions? Im using the ZMySQLDA product... 0.1.2 Cheers, Paz

1 0

Some help required but no sarcastic comments this time please
by alankirk 24 Jan '01

24 Jan '01

Hi there, i sent an email the other week regarding problems i've been experiencing with zope and MySQL. I've set up a database connection for zope and mysql and it sort of works. I can send queries to add data to my database ok but when i send a query to get data from my database i get one of 3 errors and my python server that zope runs from stops. The errors i get are Python experienced an error in (either nothing,MYSQL.DLL or PYTHON15.DLL). I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic comments this time) I've sent a few emails about this problem to various people (including to this address) and the response has been pretty poor, i've even tried to email people involved with the mysql database adaptors and got no response. It is really important that i get this problem sorted now if possible as my final year project for university depends on this 'bug' getting fixed. If you can give me help on this or point me in the direction of someone who can, i'd be grateful Cheers Alan

7 6

RE: [Zope] Is it possible to make a thumbnail from an added image..?
by dale.w.lance＠mail.sprint.com 24 Jan '01

24 Jan '01

You could try: http://www.zope.org/Members/haqa/archive/ZPhotoAlbum http://www.zope.org/Members/Drew/Photo These seem to do something similar to what you are asking. If not well, <dtml-var typical_open_source_quote>. Dale -----Original Message----- From: thomas [mailto:thomas@3dfestival.com] Sent: Wednesday, January 24, 2001 4:28 AM To: zope Cc: thomas Subject: [Zope] Is it possible to make a thumbnail from an added image..? Just a quick Idea: Can somebody make a routine RESIZING an image...? It would be great if someone could make something like that... Just imagine it: You add an Image_with_thumb... Browse for the image, then it adds your image to the site AND it is being resized to, for instance, 16x16pixels, and you can use that thumb as an icon for the image...! Wouldn't that be great...? Sorry about this silly question... It will not happen again (I hope) = ) ( = Stoons = ) - Webmaster @ 3D festival (http://www.3dfestival.com) _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

Re: [Zope] Cache manager in zope 2.3.0b1
by Bak ＠ kedai 24 Jan '01

24 Jan '01

-----Original Message----- From: Shane Hathaway <shane(a)digicool.com> To: Bak@kedai <kedai(a)kedai.com.my> Date: Wednesday, January 24, 2001 9:10 PM Subject: Re: [Zope] Cache manager in zope 2.3.0b1 >"Bak@kedai" wrote: >> >> >From HelpSys for RAM CAche >> """ >> Finally, you can configure the list of REQUEST variables >> that will be used in the cache key. This can be a simple >> and effective way to distinguish requests from >> authenticated versus anonymous users or those with >> session cookies. >> """ >> so, if i access a particular DTML Method as such >> http://myserver.com/mymethod?objId=xxx >> can i use objId to distinguish between different objects? >> i tried by setting objId as the cache key in my RAM Cache object. however, >> nothing were cached. even after accessing mymethod with different objId. > >I'd like to help you out with this--could you give more details? What >did you do to test the caching? Are you sure it wasn't being cached? > >Shane > sorry. my mistake. i think more info on how/what should/can be a cache key is good. currently, there's two cache key fields, one in the object itself, one in the cache manager instance. the field in object can contain more than one cache keys, while the cache key in the cache manager instacne can contain only one. now that i can cache object, i can't invalidate it automatically ( the cache don't expire). how do i expire the cached object automatically? sorry for being a pain :) if i understand it more, i'll try and write up a howto/note

2 1

RE: [Zope] Zope is not getting MySQL SELECT results ...
by Tom Jenkins 24 Jan '01

24 Jan '01

Hello Gerald, > > Hi all. > [snip] > but it does not seem to be able return any data through a > SELECT query. > This does not work in the "test" table nor in a SQL method. > Using a query, > such as "select * from test", it always replies with: > > -------------------------------------------- > There was no data matching this My Query query. > > SQL used: > select * from test > -------------------------------------------- > This may seem like a silly response, but have you tried the same select statement from outside zope - say from the mysql client? perhaps your select statement is truly returning an empty set. We use zope with PostgreSQL and MySQL (and have been for a few years) and haven't had any problems. -------------------------------------------- Tom Jenkins |<xml>Its devIS - Development InfoStructure |all you 703.525.6485 tjenkins(a)devis.com |need it http://www.devis.com |to be</xml>

1 0

Re: [Zope] Some help required but no sarcastic comments this time please
by Petter Enholm 24 Jan '01

24 Jan '01

Hi, I see that you get all kinds of responses on the zope mailing list regarding Zope, mySQL and Windows. Hate to see that ... well .. to your problems: I run Windows 2000 on my laptop with Zope 2.2.4 and mySQL 3.23.30. I even run the same Zope and mySQL setup on a Compaq server with Windows 4.0 in a production environment. Not the kind of setup I would prefer, but my customer wanted it installed on this server. Anyway: the setup is 100% stable, and I and my customer is really satisfied with the solution. I had problems getting things working when I compiled the mysql.dll file manually. Instead, I downloaded the files as specified in the HOW-TO on mySQL in win32 environment. With these files installed I have no problems performing different queries, inserts, updates etc in the mySQL database. I have not experienced one crash!! The setup has also been tested (though not thorougly) under Windows 95 and Windows 98! So: try to follow the HOW-TO and download the files specified there. Setting up Zope & mySQL on Win32 machines takes no for me at all, and it always runs very well!! Best of luck to you! Best regards Petter Enholm

1 0

: Postgre installation problem
by K H Subrahmanyan 24 Jan '01

24 Jan '01

I have installed postgre SQL in my linux server. I have installed ZpopyDA to my zope installation. but when I run the server I get the following error. help me. what else I have to do. kindly give the necessary links. thanks in advance. ZPoPyDA Import Traceback Traceback (innermost last): File "/Zope-2.2.5-linux2-x86/lib/python/OFS/Application.py", line 397, in import_products product=__import__(pname, global_dict, global_dict, silly) File "/Zope-2.2.5-linux2-x86/lib/python/Products/ZPoPyDA/__init__.py", line 32, in ? import sys, os, Globals, DA File "/Zope-2.2.5-linux2-x86/lib/python/Products/ZPoPyDA/DA.py", line 35, in ? from PoPy_db import DB File "/Zope-2.2.5-linux2-x86/lib/python/Products/ZPoPyDA/PoPy_db.py", line 35, in ? raise "The PoPy module is not installed" The PoPy module is not installed

4 4

Here is a Challenge: Import + Export folder...
by 3dfestival - WebMaster 24 Jan '01

24 Jan '01

Couldn't some Python / Zope EXPERT make some kind of feature with zope, which makes it possible to sit somewhere else and then via http (or ftp) IMPORT some object into a zopeserver from somewhere else...? The thing is that you have to be with the comp where the server is running from, if you want to install some new feature.... ( = Stoons = ) - Webmaster @ 3D festival (http://www.3dfestival.com) PS: I know that u can use telnet, but I do not know how to use telnet....

3 3

Re: [Zope] Some help required but no sarcastic comments this time please
by Geoffrey L. Wright 24 Jan '01

24 Jan '01

jpenny(a)universal-fasteners.com writes: > On Tue, Jan 23, 2001 at 11:17:32PM -0000, alankirk wrote: > > Hi there, > > > > i sent an email the other week regarding problems i've been > > experiencing with zope and MySQL. I've set up a database > > connection for zope and mysql and it sort of works. I can send > > queries to add data to my database ok but when i send a query to > > get data from my database i get one of 3 errors and my python > > server that zope runs from stops. The errors i get are Python > > experienced an error in (either nothing,MYSQL.DLL or > > PYTHON15.DLL). > > > > I am using Zope 2.2.2 on windows(this time i'd appreciate no > > sarcastic comments this time) I've sent a few emails about this > > problem to various people (including to this address) and the > > response has been pretty poor, i've even tried to email people > > involved with the mysql database adaptors and got no response. > > It is really important that i get this problem sorted now if > > possible as my final year project for university depends on this > > 'bug' getting fixed. > > > > If you can give me help on this or point me in the direction of > > someone who can, i'd be grateful > > > > Cheers > > > > Alan > > Alan: > > This is not meant sarcastically. > > You are probably the only person who has ever tried to do this! > Probably no one can help you. (In case people don't remember, Alan > is working on Win9x; windows 98, as I recall.) I thought it was ME. But hopefully it was 98.... > You are working on a platform which is known for instability, with > limited debugging capabilities. > > I urge you to either change to NT/SQL Server or to Linux/MySql or to > Linux/PostgeSQL. I can help you with the last, I suspect others can > help you with either of the first two. [...] I have to concur here. I do a _lot_ of development against MySQL -- I've dealt with it on both Win32 and various *NIXes. MySQL is really much more at home in a *NIX environment. If you're completely tied to Win32, you'd likely save yourself a lot of grief by moving to Win NT. And if you go that far, I have to agree with Mr. Penny that SQL Server would be a much better choice on NT for a DB. My experiences with MySQL on NT have tended to be frustrating -- but then I'm a fairly poor NT admin. But on *NIX MySQL is both extremely easy to administer and solid as a rock. Of course, I was a college student not so long ago, and know well that an NT license isn't cheap. And neither is SQL Server. But maybe you have a rich relative. If not and you still really want this to work, here's my sarcasm-free suggestion. Pick up a used low-end Pentium. I just grabbed a P120 with 32 megs of RAM, a 750 meg HD and a 3Com EtherLink III for 80 bucks for use as a firewall. You could probably do better if you shopped around. If you intend to put both Zope and MySQL on the this box, I would up the RAM to 64 megs. The whole thing should certainly set you back less than 100 bucks. Now install Linux. If you're new to it, pick an easy distro like RedHat or Mandrake. Both have a very strait-forward install process. If the idea if installing Linux by yourself for the first time makes your hands tremble, find your local Linux User Group (LUG). If you're at a big university, check with the CS department. They can probably give you a contact. In all likelihood, somebody in the LUG will be falling over himself (herself?) to help you out. FreeNIX people are usually like that. Worst come to worst, a case of cheap beer should buy you a working install of Linux/MySQL. In fact, if you happen to live in Alaska I'll do it for that price! Once you're at that point you'll probably find a lot more help. I think your problem at this point is simply that you have a fairly exotic configuration. Most people haven't seen the problems you're having because they aren't using the same platform. Both Zope and MySQL are server software packages, and server software usually finds its home on server OSes. And even though Zope seems to bridge the great MS/*NIX cultural divide quite nicely, MySQL is really from a *NIX world. I think it's just not a common choice for databases amongst Microsoft devotees. I would guess that 95+ percent of people who have tried to connect Zope and MySQL have been working with some UNIX variant, and of those the majority are probably using some flavor of Linux. So I guess I could distill all of this advice down to one simple statement: If you pick a software combination used by a large number of people, you'll likely find yourself with a strong base of user support. If you use an unusual combination, you may have to tough it out on your own. Best 'o luck! //glw

1 0

dtml-let + 'expr=' possible?
by Lee 24 Jan '01

24 Jan '01

Hi, I have one quick question about the 'let' tag; <dtml-var expr="classcode_to_table(classcode)"> gives me the value 'class52225'. Is there anyway I can use the 'let' tag to push this onto the namespace stack? I was thinking something *like*; <dtml-let table expr="classcode_to_table(classcode)"> The python method, classcode_to_table, takes in a string, alters it and returns it. This is going to be an argument for some ZSQL methods and some Python methods. Thanks, Lee

2 1