- Zope - Zope lists

[SQL] Retrieving info from the previous SQL insert
by Stephane Bortzmeyer 12 Dec '01

12 Dec '01

I have a SQL method which performs an INSERT in one table, followed by an INSERT into another table. The two INSERTs have to be in the same method because they need to be atomic. In the first table, there is an auto-incrementing field that the PostgreSQL DBMS assigns itself. I need the value of that field for the second INSERT and I don't see how to retrieve it inside the SQL method. Yes, I'll read more deeply PostgreSQL documentation and Zope documentation and <dtml-var my_postgresql_zope_adapter> documentation but, in the mean time, if someone has a ready-to-use solution?

4 4

Zope 2.4.3 crashing continually
by Jin Choi 12 Dec '01

12 Dec '01

I'm having continual crashing problems with Zope 2.4.3 running on Solaris. I first noticed it when loading the management interface would sometimes give error pages in one or more of the frames. Checking the Control Panel, the uptime would be under a minute; the server had crashed and the zdaemon had restarted it. Has anyone else seen this sort of problem? I turned on the error log, and it shows that the server is going down fairly often, sometimes several times per hour, with an Aiieee and an error code of 256. I was reading somewhere that that indicates that some Product had exited. The only non-distribution product I have installed is the latest DCOracle2; might that be causing it?

2 1

WebDAV or FTP "type"s?
by Derek Simkowiak 12 Dec '01

12 Dec '01

I asked this before, as part of a longer email, but got no response. How do I specify the "type" for objects which are uploaded via WebDAV or FTP? That is, I want *.html (or *.css or *.js) to be something other than a DTML Document (or DTML Method). Where do I specify that? Also, I want *.jpg and *.gif to be something other than "Image". This is the core question for using Zope to solve my clients' problem. Thank You, Derek Simkowiak dereks(a)realloc.net

4 5

Zope digest, Vol 1 #1824 - 45 msgs
by a.dewit＠niwa.cri.nz 12 Dec '01

12 Dec '01

Hi, I'll be back on Monday Dec 17th but may check my mail periodically while away. Arian

1 0

Re: [Zope] Running a method automatically
by H.de.Wit＠SFK.NL 12 Dec '01

12 Dec '01

You can use a zope product named xron Hans de Wit "Josef Meile" <jmeile@hotma To: <zope(a)zope.org> il.com> cc: Sent by: Subject: [Zope] Running a method automatically zope-admin@zo pe.org 12-12-01 10:17 AM I'm just wondering if it is possible to execute a method (it could be a DTML Method or a Python script) automatically. ie: once a day. How can I do it? Thanks in advanced, Josef.

1 0

Running a method automatically
by Josef Meile 12 Dec '01

12 Dec '01

I'm just wondering if it is possible to execute a method (it could be a DTML Method or a Python script) automatically. ie: once a day. How can I do it? Thanks in advanced, Josef.

1 0

Re: Sendmail problem
by olpa＠sybcom.de 12 Dec '01

12 Dec '01

On Yesterday, Jin Chen wrote: > Delivered-To: olpa(a)sybcom.de > Subject: Sendmail problem > Date: Tue, 11 Dec 2001 09:50:13 -0800 > To: olpa(a)sybcom.de > From: Jin Chen <jchen(a)nautilus.org> > > Dear Oliver, > > I am very excited to read your posting. I was bothered by the same problem > for a long time and didn't solve it. I follow your idea and modified my > code but I had the same error message as before. Would you please give me > any suggestion? i will try to do my best > How can I set up the 'SMTP Host' in MailHost object? create a mailhost object, and put in "smtp host" the hostname of your smtp server. you can test the smtp server by doing a telnet on port 25 on it and he should answer "220 blabla" > Can I use a variable in the mailfrom, such as mailfrom=<dtml-var > pemail>? yes, directly with mailfrom=pemail > Feedback code is: > > <dtml-var standard_html_header> > > <H2>We want your Feedback!</H2> > > <form action="SendFeedback" method="post"> > Your Name: <input type="text" name="name" size="40"> > <br> > Email: <input type="text" name="pemail" size="40"> > <br> > <textarea name="comments" rows="10" cols="50"> > Type your comments here. > </textarea><br> > <input type="submit" value="Send Feedback"> > </form> > > <dtml-var standard_html_footer> > --------------------------------------------------------------- > SendFeedback Code is: > > <dtml-var standard_html_header> > <dtml-sendmail mailhost=MailHost mailfrom=jen(a)nautilus.org > mailto=jen(a)nautilus.org> this is bad and should be (you just forgot some quotes) <dtml-sendmail mailhost=MailHost mailfrom="jen(a)nautilus.ort" mailto="jen(a)nautilus.org"> > From: jen(a)nautilus.org > To: jen(a)nautilus.org > Subject: blabla > > Feedback from : <dtml-var name> > </dtml-sendmail> > > > <h1>Thank you for your input!</h1> > <p>Your comments have been sent.</p> > > <dtml-var standard_html_footer> > ****************************************** > Error is: > > Zope Error > Zope has encountered an error while publishing this resource. > > Error Type: error > Error Value: (10061, 'Connection refused') the connection refused can be checked with the telnet trick... simply do telnet smtphost 25 and look if you can connect. If you cannot connect, then you must ask your sysadmin what is the name of the smtp server. --- "I suppose the secret to happiness is learning to appreciate the moment." -Calvin --- Oliver Pabst .-------------------------. mailto:olpa@sybcom.de : : phone :+49 681 56600600 : project department : SYBCOM GmbH fax :+49 681 56600660 : : http://www.sybcom.de

1 0

Zope with IIS using NT security, remote user mode
by Michael Wills 12 Dec '01

12 Dec '01

Hello all: I was kindly reminded not to send messages in HTML format. Many thanks for the reminder. It took a while to figure out how to turn it off. Sorry for the nuisance. I am wondering if anyone can point me to information about setting up Zope to run in remote user mode. I am trying to get Zope to work with IIS and use NT security. I have followed the documentation but haven't been successful. The only thing I can think of is remote user mode. I am not sure exactly what that is or how to properly set it up. Any help or pointers would be greatly appreciated. Thanks! Michael

1 0

Zope with IIS using NT security, remote user mode
by Michael Wills 12 Dec '01

12 Dec '01

Hello all: I am wondering if anyone can point me to information about setting up Zope to run in remote user mode. I am trying to get Zope to work with IIS and use NT security. I have followed the documentation but haven't been successful. The only thing I can think of is remote user mode. I am not sure exactly what that is or how to properly set it up. Any help or pointers would be greatly appreciated. Thanks! Michael

1 0

making subclasses persistent
by Jerry McRae 12 Dec '01

12 Dec '01

Hi Zopeople, Sorry for the long post. I seem to spend 2 hours programming and 7 hours searching the archives. Things I have learned trying to convert my Python App to Zope: I can place my un-pickled objects in the root of data.fs and then access them from Zope. Works great, although it took me quite a while to figure out how to access them from and External Method with self._p_jar.root() (which wasn't intuitive or found in any documentation). I was able to access my external database (non-SQL) from an External Method, although I had to pre-set a list of dictionaries for access from DTML. The built in sequence of C extension types caused the Zope security prompt to prevent all access. I also found the __setstate__ method for re-opening my files if my objects get reloaded from ZODB (if I ever get them saved in the ZODB!) Then I struggled for hours this morning trying to solve my 'first parameter must be an instance' in my Product's __init__() where I was trying to call the super class's __init__. I was elated to find inheritedAttribute in the ML archives. Then my hopes of using the same code as my Python ap were dashed when I found it didn't work for super classes. application class design (not necessarily the 'right' way): class Ap() - repository for all files, tables, and common methods. ONLY used as a super class. class com(Ap) - methods, files, and tables specific to the 'com' application. Still only used for 'com' app. super class. class comtest(com) - objects specific to a running application. There is only one instance created, but there is much custom methods in this class. Running from Python (through aprun.py, which instanciates (sp?) the class, loads the tables, and runs the method: c:\> python aprun.py comtest run_this_method >From Zope: ??. * I have attempted at making a Product, but I cannot include 'comtest' as a super class, because I cannot initialize it. Even though I would only need one instance of 'comtest', I don't see how to make it (or its class) persistent. * I thought of just using External Methods, but cannot figure out how to create instances from class definitions in External Methods. My options at this point seem to be re-write my class structure to work with Zope. Unfortunately, I would loose my class hierarchy and this would then require two sets of classes, which would be inconvenient. Any other suggestions? (if this makes any sense) would be much appreciated! Does anyone else feel like they have been handed a Ferrari, and it's really cool and great and all that. Now if I could only find the KEYS... --Jerry /\_/\ Jerry McRae \|||/ mail safely: The Bat! 1.53d (~o o~) (stuck in win98) (. .) Zope v2.4.1 - dryer than golf )'Y'( _______________-o00-(_)-00o-____________________________________ ( ) / Habit, if not resisted, soon becomes necessity. --St. Augustine

1 0