- Zope - Zope lists

Using MySQL with ODBC causes re-authentification of Zope on WIN2000
by Richard S Herrington 25 Jul '00

25 Jul '00

Here is a perplexing problem I am experiencing. First, I was able to compile the MySQL database adapter (MySQLdb) for WIN2000 and connect successfully to a database I set up on Windows. I set up a ZSQL method to return rows from the database. Then I set up a DTML method to iterate over the rows and fill a html page using "dtml-in" to receive records from the ZSQL method: ...snip...snip... <dtml-in sqlQuery> <dtml-var last-name> <dtml-var first-name> </dtml-in> ...snip...snip.... This worked fine. Next, I was able to connect with a MicroSoft Access database using an ODBC method. Then I did the same as before. Create a ZSQL method (e.g. sqlQuery), then iterate over these rows with a "dtml-in" tag, filling an html page. Now here's my problem. When I set up a MySQL ODBC connection. The ZSQL method by itself returns rows from the database just fine. However when I access the index_html page that contains the "dtml-in" tags.....it causes a prompt to reauthenticate to Zope (username and password). No known username and password will work. I set all my MySQL permissions properly as far as I know. I've scoured the archvies but have found nothing. I need some leads as to what to try. Thanks in advance. Rich Herrington University of North Texas Academic Computing Services Research and Statistical Support Voice: 940 565 2140 Email: richherr(a)unt.edu "You live and learn. At any rate, you live." -- Douglas Adams "Where is the knowledge that is lost in information? Where is the wisdom that is lost in knowledge?" T.S. Eliot "Whenever I have a little money I buy books; if there's any left over, I buy food and clothes." Erasmus "It is impossible for a man to learn what he thinks he already knows." Epictetus (50-138 A.D.) "True wisdom is less presuming than folly. The wise man doubteth often, and changeth his mind; the fool is obstinate, and doubteth not; he knoweth all things but his own ignorance." Akhenaton? (c. B.C. 1375) "Happiness is the absence of the striving for happiness." Chuang-tzu (fl. B.C. 350)

1 0

Your feedback: what should DateTime strftime() behavior be?
by Spicklemire, Jerry 25 Jul '00

25 Jul '00

+1

1 0

Interbase 6.0 Open Source Release
by Jeff K. Hoffman 25 Jul '00

25 Jul '00

Hello, I just wanted to let everyone know that Interbase 6.0 has just been released as Open Source. Check out: http://www.borland.com/interbase/index.html If you need a high-quality, enterprise class RDBMS for Zope I suggest you download both Interbase 6.0 and our Zope DA, gvibDA. It is a truly nice setup. Let us know if you find any bugs, or if there are some new features you'd like to see added. We expect to make a 1.0 release of our DA next week, once we've had a chance to test against 6.0 final. Back to our regular programming, --Jeff --- Jeff K. Hoffman 704.849.0731 x108 Chief Technology Officer mailto:jeff.hoffman@goingv.com Going Virtual, L.L.C. http://www.goingv.com/

1 0

RE: [Zope] frustrating security problem
by jacques＠msaservice.com.br 25 Jul '00

25 Jul '00

> -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On > Behalf Of joel > grimes > Sent: terça-feira, 25 de julho de 2000 13:55 > To: zope(a)zope.org > Subject: [Zope] frustrating security problem > > [snip] > > What am I missing? > Nothing. Check http://lists.zope.org/pipermail/zope/2000-July/029375.html Jacques

1 0

App isolation
by Jacques Exelrud 25 Jul '00

25 Jul '00

Not sure if this list is the best place to put such question but here it is... I need to develop what would be a product if only Zope was the target. As it´s not I was thinking what could I do to not need to build such app twice: I came to 2 options both involving building a server of some kind and using Python to connect to this server. 1st Build the app as a COM server (the target OS is Windows) and using Python support build an interface to this COM server as a Zope product 2nd Build the app as a XMLRPC server and using Python support build an interface to this XMLRPC server The second options is better because I´m not attached to any platform but, as I said, that´s not an issue right now. Any sugestions on any of those or a 3rd option ? Thanks in advance, Jacques

1 0

RE: [Zope] Your feedback: what should DateTime strftime() behavio r be?
by Webmaster 25 Jul '00

25 Jul '00

+1 > -----Original Message----- > From: Brian Lloyd [SMTP:Brian@digicool.com] > Sent: Tuesday, July 25, 2000 11:35 AM > To: 'zope(a)zope.org' > Subject: [Zope] Your feedback: what should DateTime strftime() > behavior be? > > Hi all - > > There has recently been some confusion over the expected > behavior of various approaches to DateTime formatting in > Zope regarding timezone representation. I would like to > resolve this for the next release by making a proposal > and asking you to reply to the list with a "vote": > > +1 == agree > > +/-0 == no strong opinion > > -1 == disagree > > > So then, here is the situation. In Zope 2.2 (and earlier), > formatting a date using either: > > <dtml-var theDate fmt="%A, %B %d %Y, %H:%M:%S"> > > <dtml-var "theDate.strftime('%A, %B %d %Y, %H:%M:%S')"> > > ...would give you the date *formatted based on GMT rather than > the timezone (usually local) representation of the object*. > Simply doing: > > <dtml-var theDate> > > ...however, would print the date in the current timezone of > the datetime object. > > Many feel that this difference is unintuitive and a pain. The > proposal is that both: > > <dtml-var theDate fmt="%A, %B %d %Y, %H:%M:%S"> > > <dtml-var "theDate.strftime('%A, %B %d %Y, %H:%M:%S')"> > > ...would be changed to apply the format to the current TZ > representation of the object rather than convert to GMT. Of > course, this could be a problem if there are people currently > counting on the output being GMT, which is why we're putting it > to a vote. If this change is made for 2.2.1, those who still > wanted the output in GMT could just call the 'toZone()' method > of the datetime object to get a GMT version before formatting: > > <dtml-var "theDate.toZone('GMT').strftime('%A, %B %d %Y, %H:%M:%S')"> > > > What do you think? > > > Brian Lloyd brian(a)digicool.com > Software Engineer 540.371.6909 > Digital Creations http://www.digicool.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

ZClasses to RDBMS
by Satheesh Babu 25 Jul '00

25 Jul '00

Hi, Is there any recommended way to get data from ZClass instances to a corresponding RDBMS (Oracle 8i specifically) table? What I could think of as options are: (I've'nt tried out any!) 1. In manage_add for my Zclass call the corresponding ZSQL insert method - Can this be done? - What can be done for updates? 2. Create masking DTML methods to create Zclass instances dynamically. Call ZSQL methods alongside as well. 3. Do periodic downloads of ZClass instances - say XML format - and batch upload to database. Why I need this? 1. I need to make a RDBMS driven system for managing content. I don't want to use Zope's ZODB for storing important content, because of these reasons: 1. It can quickly grow up to 2GB and much more 2. It needs to store and SEARCH through binary documents (Oracle can do this easily) 3. The way site is to be build from DBMS contents has to be / can be different - ASP, PHP or Java Even a 100% static site might be a requirement. 2. I've tried with ZODB3 with data upto 500MB and it is kind of shaky (was on an NT4 server. don't ask me, if it was my decision, I would've picked up linux!). H/W: Compaq dual PIII 500MHz server with NT4, SP5 (or 6, I don't remember. The latest one). 512MB RAM and 1GB Virtual memory. With RDBMS, we've DBA's and good SQL programmers, so data recovery is much more easier. Also, I really don't need much of versioning or undo capabilities. It also brings up another solution, make an Oracle storage along the lines of Interbase storage, hook up ZCatalog to Oracle's interMedia search. Two problems - I'm little tight on time, and DCOracle's support for BLOBs are not yet tried out. I plan to start on this soon anyway. So, any suggestion for this would be greatly appreciated. Note to DC: I love Zope and I would say it is anyday better than these Java appservers, to code, to maintain and to train people. But, lack of any industry strength RDBMS storage is really a big problem in selling to suits. vsbabu(a)csoft.net http://vsbabu.csoft.net

1 0

frustrating security problem
by joel grimes 25 Jul '00

25 Jul '00

I imagine this topic has been thoroughly gone over, but I didn't catch it so I'm pulling my hair out. I'm using Zope 2.2 (upgraded yesterday) on a Win98 box. I have a ZSQL Method that allows me to view data from an Access database. But when I try to create a Search Interface for that ZSQL Method, I'm asked for a login and password before I can view it and NONE of my logins work. The interface IS created and I can edit it, I just can't view it. I only have 2 users. The superuser and the one that created the ZSQL Method AND Search Interface. What am I missing? joel grimes joelgrimes(a)hotmail.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

1 0

Re: [Zope] zzLocale 0-0-3a released on Zope Japan
by Johan Carlsson 25 Jul '00

25 Jul '00

STIL IN SWEDISH, SORRY Hej Peter och alla andra svensk språkiga, Jag så inte ditt meddelande för än nu, men jag är intresserad. Kan vi inte forstätta diskutionerna på min svensk språkiga mailinglista (skapad mycket för just denna typ av sammarbete). För att gå med klickar du dig till: http://www.torped.se/mailman/listinfo.cgi/zope Postar gör man på: zope(a)torped.se Johan Carlsson Torped AB > > IN SWEDISH - ABOUT SWEDISH > > > > Finns det ett intresse av fler an mig att jobba med detta? > > Om, det gor det, hur manga blir vi, och hur ska vi lagga upp arbetet? > > > > Smidigast vore ju att ge deltagare access till .dtml filer, med version'ing, > > pa en och samma server. > > Syftet ar nog mest att skriva om sidor som klienter kan tenkas anvanda. > > > > Intresserad? > > > > ----- Original Message ----- > > From: Yves-Eric Martin <yemartin(a)garage.co.jp> > > To: <zope(a)zope.org> > > Sent: Friday, July 21, 2000 10:53 AM > > Subject: [Zope] zzLocale 0-0-3a released on Zope Japan > > > > > > > Hi Zopistas, > > > > > > > > > This is the second alpha release of zzLocale, a Zope locale support > > > Product. > > > > > > zzLocale provides a framework for Zope interface internationalization > > > (Zope and Products management screens). The localization is done on a > > > per request basis, which allows developers from different countries to > > > work on the same Zope while each of them having an interface in his > > > native language. > > > > > > With zzLocale, Product developers can easily provide localized > > > interfaces for their Products. All that is needed is to put the > > > localized interface DTML templates in a "locales/[lang]" subdirectory of > > > the Product, and zzLocale does the rest. > > > > > > This version of zzLocale is pretty useable, and usually falls back > > > nicely when something goes wrong. However, it is still alpha, and we > > > would not recommend using it on a production server. > > > > > > This release includes a complete (I mean, as complete as current > > > zzLocale features permit) French interface, and a partial Japanese one. > > > Tranlators are welcome to provide other languages. Please send us your > > > translated templates so that we can include them in the next release. > > > > > > > > > For more information and download: > > > http://www.zope.ne.jp/users/yemartin/zzLocale > > > > > > > > > > > > Regards, > > > > > > > > > -- > > > Yves-Eric Martin > > > Digital Garage Inc. > > > yemartin(a)garage.co.jp > > > > > > _______________________________________________ > > > 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 ) > > > > > > > > > _______________________________________________ > > 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 ) > > > > _______________________________________________ > Zope mailing list > Zope(a)torped.se > http://www.torped.se/mailman/listinfo.cgi/zope

1 0

ZTopics and 2.2 - solved.
by Jonathan Cheyne 25 Jul '00

25 Jul '00

Just a follow up after much gnashing. I deleted the old catalog and recreated. I also noticed that some ztopics displayed whilst others did not (these are original ones not new). I tracked the difference to field types in the catalog. the catalog is less tolerent of sloppy setups i think - so i deleted an index and recreated as a different field type and bingo - no probs. Hope this makes sense. Cheers Jonathan

1 0