- Zope - Zope lists

need help with IIS/ODBC
by Jay Ashton 05 Mar '99

05 Mar '99

As a novice (who's loving Zope!) I'm having a terrible time trying to get Zope1.10.2 on NT with IIS to connect to MS SQL with a Z ODBC connection. Previously I had no problem getting Zope 1.9/ZopeHTTPServer to connect to MS SQL via Z ODBC. Recently I upgraded to 1.10.2 without a hitch, and was able to run it with IIS 4.0 after putting the (PCGI executable?) MYZOPE.exe in /InetPub/scripts/ and turning off in IIS both Basic Authentication and NT Challenge/Response as I read here in the list. My problem now is that when I try to open my db connection (exactly the same connection that was working with 1.9 & ZopeHTTPServer) I get the following error from IIS: >HTTP Error 400 >400 Bad Request >Due to malformed syntax, the request could not be understood by >the server. The client should not repeat the request without modifications. In trying to figure out what's going on I've noticed a couple things. First, and I think most illustrative, if I try to add a new Z ODBC connection, none of my ODBC sources are showing up in the available list (except the default 'LocalServer, SQL Server') - whereas if I run my 1.9 Zope with ZopeHTTPServer all my ODBC connections show up just fine. Also, running my new 1.10.2 Zope/IIS with the faulty db connection side by side with the functioning 1.9/ZopeHTTPServer, I printed our the environment variables of both and noticed some differences - USERPROFILE's are Default User vs. Administrator, and the 1.9/ZopeHTTPServer contains variables not contained in the 1.10.2/IIS environ: HOMEPATH, TEMP, USERNAME, HOMEDRIVE, USERDOMAIN, PROMPT, LOGONSERVER, TMP. I attempted to set at least USERDOMAIN in the 1.10.2/IIS environ, with no luck. I've read all the posts from the list that I could find dealing with IIS and ODBC, but couldn't find anything with info on this type of trouble. Have I made a boneheaded mistake and started to look in the wrong places for the fix? Any help/info/pointers would be hugely appreciated as I continue to bang my head on my keyboard hoping that I'll soon clear this hurdle and get back to having fun with Zope! Thanks! Jay

3 4

Re: [Zope] ZMySQLDA
by Phil Harris 05 Mar '99

05 Mar '99

Where exactly is the file? find out by doing a locate 'libmysqlclient'. Let's assume that it is in /usr/local/mysql/lib. The easiest way to accomplish what you want is this. 1. cd /etc 2. vi ld.so.conf 3. Goto the end of the file and add a line that says '/usr/local/mysql/lib' replace this with the exact location of you libmysqlient.so.6 4. save the file 5. run 'ldconfig' 6. run 'sync' twice, this just makes sure all changes are written to the disk. This adds the mysql lib directory to the lib search path. HTH Phil ----- Original Message ----- From: Timothy Grant <tjg(a)avalongroup.net> To: Zope Folk <zope(a)zope.org> Sent: Friday, March 05, 1999 4:05 AM Subject: Re: [Zope] ZMySQLDA >John Eikenberry wrote: > >> 1. Get everything cleaned up (ie. back in the condition after first >> untarring ZMySQL). >> 2. Edit Setup.in, add -L<the path to libmysqlclient> to the end of the >> last line. >> 3. Proceed as usual (make -f Makefile.pre.in boot; make) > >Thanks to both John and Ronald for their kind assitance. I have made it >past >my original error and got everything compiled correctly. However, my >general >Newbieness is still coming back and biting me on the you-know-what. > >The instructions state that I should start python, and then Import the >MySQL >module to make sure it works. When I do, I get yet another error. > >Traceback (innermost last): > File "<stdin>", line 1, in ? >ImportError: libmysqlclient.so.6: cannot open shared object file: No >such >file or directory > >The file does exist, so I am once again stumped. > >Thank you for your continued assitance. > > >-- >Stand Fast, > tjg. >=================================================== >Timothy Grant >VP Technology/CTO >Avalon Technology Group >tjg(a)avalongroup.net >www.avalongroup.net >(503) 246-3630 voice >(503) 246-3124 fax > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://www.zope.org/mailman/listinfo/zope > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://www.zope.org/mailman/listinfo/zope

1 0

An interim solution for the FAQ
by Pavlos Christoforou 05 Mar '99

05 Mar '99

Zopistas Until the SGML experts develop the FAQ format here is an interim solution: I have set up a Zope FAQ site at: http://www.gaaros.com:9673/FAQ <FAQ> <SECTION>FAQ Related</SECTION> <QUESTION>How can one contribute to the FAQ?</QUESTION> <ANSWER><![CDATA[ To contribute to the FAQ you just have to send e-mail to me or to the Zope list and include the word FAQ somewhere in the subject. In the body of your e-mail message you should include (somewhere) an XMLish faq entry as below: <FAQ> <SECTION>FAQ Related</SECTION> <QUESTION>How can one contribute to the FAQ?</QUESTION> <ANSWER>Answer One</ANSWER> <Answer>Answer Two</Answer> </FAQ> Tag case is not important.<QUESTION> <Question> and <question> are all equivalent as long as starting and ending tags match. If you want to include DTML or HTML in your answers or questions you need to include the ugly CDATA directive. If there is an error in the formating of your entry the parsing will fail and your entry will not be uploaded, but the entry will be logged. Structured Text is not supported because of the problems that Martijn Faassen discussed on the Zope List. If the section or question already exist in the FAQ then the entries will be appended to the already existing ones, otherwise the new categories will be created.]]></ANSWER> <question>How can I download the whole FAQ?</question> <answer>The whole FAQ can be exported by clicking on the "Export FAQ" in the navigation margin.</answer> <section>DTML Scripting</section> <question>How do I pass a non-form variable to the next requested URL?</question> <answer><![CDATA[ Use Hidden fields within the form: <input type="hidden" name="varname" value="">]]></answer> </FAQ> If everything works ok this e-mail will make the first entry to the FAQ! Pavlos

1 0

ZMySQLDA
by Timothy Grant 05 Mar '99

05 Mar '99

Hi, I'm playing with Zope, and have been trying to get Zope to talk to MySQL using the MySQLDA. I'm running RedHat 5.2 Since there were caveats about having MySQL development enabled, and such, I downloaded the source distribution for MySQL and made it. It appears to be working very nicely. When I follow the procedures outlined in the README, the following happens: I run make -f Makefile.pre.in boot and everything works correctly. I then run make and get the following error. gcc -fPIC -g -O2 -I/usr/include/python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG _H -I/usr/local/mysql/include -I/usr/include/mysql -c ./MySQLmodule.c ./MySQLmodule.c: In function `pythonify_row': ./MySQLmodule.c:238: warning: assignment from incompatible pointer type gcc -shared MySQLmodule.o -L/usr/local/mysql/lib -L/usr/lib/mysql -lmysqlclien t -lm -o MySQLmodule.so ld: cannot open -lmysqlclient: No such file or directory make: *** [MySQLmodule.so] Error 1 I did a locate on mysqlclient, and coudln't find the file. though I did find some called libmysqlclient. So I changed the both Setup and Setup.in to reflect that other name. however, I still get the above error. Any help would be greatly appreciated. -- Stand Fast, tjg. =================================================== Timothy Grant VP Technology/CTO Avalon Technology Group tjg(a)avalongroup.net www.avalongroup.net (503) 246-3630 voice (503) 246-3124 fax

3 4

Re: [Zope] evaluating attribute values
by Robin Dunn 04 Mar '99

04 Mar '99

Sorry, your ideas don't work either. This time I get a NameError for mhost in the following code in SendMailtag.py. mhost is never being created. if self.mailhost: mhost=md[self.mailhost] elif self.smtphost: mhost=MailBase() mhost._init(localHost=gethostname(), smtpHost=self.smtphost, smtpPort=self.port) mhost.send(self.section(md.this, md), self.mailto, self.mailfrom, self.subject) -- Robin Dunn robin(a)AllDunn.com http://AllDunn.com/robin/ http://AllDunn.com/wxPython/ Check it out! Try http://AllDunn.com/laughworks/ for a good laugh. -----Original Message----- From: John Eikenberry <jae(a)kavi.com> To: Robin Dunn <robin(a)alldunn.com> Cc: zope <zope(a)zope.org> Date: Thursday, March 04, 1999 1:17 PM Subject: Re: [Zope] evaluating attribute values >On Thu, 4 Mar 1999, Robin Dunn wrote: > >> For example, Zope doesn't like this: >> >>  --> >> >> or this: >> >>  >> >> (it tries to use smtpHost as the host name, instead of its value) > >Try: > > > >or this: > > > >--- > >John Eikenberry >[jae(a)kavi.com - http://taos.kavi.com/~jae/] >______________________________________________________________ >"A society that will trade a little liberty for a little order > will deserve neither and lose both." > --B. Franklin > >

2 1

Using Zope with CORBA (new user question)
by Jody Winston 04 Mar '99

04 Mar '99

I have a long running process that will be started by Zope. This process has a CORBA interface that is implemented using ILU. I would like to be able to asynchronously have this process generate data for Zope. My basic questions are: o Can I have an ILU mainloop inside of Zope? (I really don't care if I have to hack Zope or if I can use an external method.) o Should I fork/exec the long running process and give the process a URL that indicates where the data should be written? (I can use pickles or sql.) o How do I tell Zope that new data is avaliable if the process is external to Zope? Jody Winston

2 1

gadfly bug in charstring literal recognition [fixable]
by Aaron Watters 04 Mar '99

04 Mar '99

Oops. One "zope bug" I complained of was mine. If it had been reported to the gadfly-rdbms list it would have been fixed back when. viz: Aaron Watters wrote: > [copied to gadfly-rdbms list] > > Jim Fulton wrote: > >...most RDBMSs (as in all but gadfly) > > > accept: > > > > cursor.execute(""" > > select name > > from table > > where descr = 'this > > doesn''t work for two reasons' > > """) > > > > Are you saying that the SQL spec disallows newlines in > > quoted strings? > > I actually was unaware of that. I'll look to my docus. In the > mean time if you want it, in sqlgen.py change the charstre to > > charstre = "'[^']*'" > > ===interactively > >>> c.execute(""" > select 'this > doesn''t work for two reasons' > from dual""") > >>> print c.pp() > <const "this\012doesn't work for two reasons" at 9340320> > ========================================================= > this > doesn't work for two reasons > ===end ... > -- Aaron Watters > > ps: and thanks. post script: The current usage of gadfly in Zope makes gadfly do lots of parsing as in insert into table(a,b,c) values (1,2,3) insert into table(a,b,c) values (6,2,3) insert into table(a,b,c) values (1,7,3) insert into table(a,b,c) values (1,2,8) The "right" way to do this would be to take advantage of gadfly's dynamic parameter/multiinsert feature executing insert into table(a,b,c) values (?,?,?) ONCE with dynamic parameters list [(1,2,3), (6,2,3), (1,7,3), (1,2,8)] which would run much faster than thrashing the parser with the individual inserts above (with kjbuckets present). In general dynamic parameters on repeated statements reduce parsing and binding overhead (even for other types of statements). However, I understand this may be hard to implement as it would require special features for the gadfly "adapter" not of value for the other adapters. Oh well. Anyway, in future please post/forward/crosspost any gadfly related issues to the gadfly list. I just discovered a pile of complaints on the zope list this morning and I found it distressing. I don't normally read the zope list. -- Aaron Watters http://www.chordate.com

1 0

Can Zope*src/lib/python be copied to .../python1.5/site-packages?
by skip＠mojam.com 04 Mar '99

04 Mar '99

Can the contents of Zope's lib/python directory safely be copied to the site-packages directory of the Python install directory? Thx, Skip Montanaro | Mojam: "Uniting the World of Music" http://www.mojam.com/ skip(a)mojam.com | Musi-Cal: http://www.musi-cal.com/ 518-372-5583

1 0

RE: [Zope] [ZDP] Announcing the Zope Documentation Project
by Paul Everitt 04 Mar '99

04 Mar '99

Philip wrote: > Maybe Michigan/Ontario area? Ahh, we'll just have to rent a bus and go on a nationwide tour. :^) No, right now we're considering partnering with a technology training company in Washington DC. --Paul

2 1

Re: [Zope] [ZDP] Showing form data
by Jeffrey P Shell 04 Mar '99

04 Mar '99

>From: Martijn Pieters <mj(a)antraciet.nl> >To: Zope Mailinglist <zope(a)zope.org> >Subject: [Zope] [ZDP] Showing form data >Date: Thu, Mar 4, 1999, 4:30 AM > > * How can I show all form data/cookies/REQUEST vars without knowing their > names? > > By using the #in tag, you can easily all show all data in any dictionary > object, like REQUEST.form, REQUEST.cookies and even REQUEST itself. Just > call the items() method of the dictionary, and the #in tag will provide > a sequence-key and sequence-item variable for every item in the > dictionary. > > Show showing all form data can be done like this:: > >  > : <BR> >  > > Use REQUEST.cookies.items() for all your cookies, and REQUEST.items() > for all REQUEST variables, including CGI Environment variables. The most supremely easy way is:: <PRE></PRE> :) .jPS | jeffrey(a)digicool.com zope, through the web. www.zope.org

1 0