- Zope - Zope lists

RE: [Psycopg] Authentication Problem with Postgres
by Paul Zwarts 26 Nov '01

26 Nov '01

Andre, Hmmm... This is a bit over my head. I don't see why zope would be sending something different after a restart. I've cross-posted this to the zope list because there are some hard-hitters there that will know more (if Frederico doesn't get to it first : )) You are correct though, the dbase connections should be persistent (at least they are for me). Perhaps you have manually coded your ZPsycopgDA to do the password encrypting? Because I'm reasonably _sure_ the connection string from within the zope management interface is cleartext. Perhaps something between Zope, ZPsycopgDA and postgres is going wrong. Sorry I cant help more, Paul Zwarts -----Original Message----- From: andre(a)oratrix.nl [mailto:andre@oratrix.nl] On Behalf Of Andre Schubert Sent: Friday, November 23, 2001 11:33 AM To: Paul Zwarts Cc: psycopg(a)lists.initd.org Subject: Re: [Psycopg] Authentication Problem with Postgres Hi Paul, Zope and Postgres are running on different machines. Postgres only allows crypted session. We have traced only crypted passwords. I think the problem is that there is a wrong password crypted and then sent to postgres, and after a restart the right password is crypted and sent to postgres???? But why does Zope send a password again, i thought the connections of Zope where persistent connections??? How can a track down connection-establishing?? Thanks as Paul Zwarts schrieb: > > Andre, > > How is your encryption done? Zope authenticates using cleartext locally > AFAIK... and then again I could be wrong. But perhaps this is why you > have the problem? > > Postgres (IMHO) should be set to restrict access to only local machines. > That way encrypted passwords are not necessary because it can only come > from the machine running zope (same machine if postgres lives there as > well) > > Regards, > Paul Zwarts > > -----Original Message----- > From: psycopg-admin(a)lists.initd.org > [mailto:psycopg-admin@lists.initd.org] On Behalf Of Andre Schubert > Sent: Friday, November 23, 2001 11:08 AM > To: psycopg(a)lists.initd.org; pgsql-admin(a)postgresql.org > Subject: [Psycopg] Authentication Problem with Postgres > > Hi all, > > sometimes i have a curios problem with my Zope. > Without any errors in any logs Zope could not authenticate himself with > postgres. > The error message is that there is a wrong password. > After a restart of Zope everything works fine until the eror occurs > again. > > My sysop has traced the protcols before and after the error. > Zope sends some data and then a crypted password with the salt. > If the error is occured the password that Zope sends is crypted wrong. > After a restart of Zope the password is right crypted. > > Could anybody help or explain me this problem, it is very important for > the further use of Zope > for our websites. > > Thanks as > _______________________________________________ > Psycopg mailing list > Psycopg(a)lists.initd.org > http://lists.initd.org/mailman/listinfo/psycopg > > _______________________________________________ > Psycopg mailing list > Psycopg(a)lists.initd.org > http://lists.initd.org/mailman/listinfo/psycopg

4 5

We are Now Able to Reach your Web Page
by adam.brett＠mail.internetseer.com 26 Nov '01

26 Nov '01

We are pleased to inform you that we no longer have a problem in reaching your Web page from the Philadelphia area: http://egenius.com:9090/pipermail/nyzug/2001-September/000124.html As recommended by the robot Guidelines, this email is to explain our research activity and to alert you about the connectivity error we encountered. InternetSeer, the world's largest web site monitoring service, does not store or publish the content of your pages, but rather uses the information to update our ongoing Web Connectivity Study. To learn more about our study results or request InternetSeer to continue to monitor your Web site and send you error messages, http://scclick.internetseer.com/sitecheck/clickthrough.jsp?I5s57h5i5h5j5i5h…. If you prefer not to receive these occasional error notices please let us know by replying to this email and placing "remove" in the subject line. You will be removed from receiving further email error notices. Adam Brett Analyst Manager cs-adam.brett(a)mail.internetseer.com InternetSeer.com "Your Remote Web Site Monitor" http://www.internetseer.com ##zope(a)zope.org##

1 0

Multiple sites, shared content
by Howard Hansen 26 Nov '01

26 Nov '01

I'm setting up a series of sites for different states. Some content is shared among the different states, other content will exist only in some states, other content will exist for all states. Ideally, I'd like to have a single folder for all shared content, which would allow us to eliminate dual maintenance. Each state will have its own domain and I'd like the shared content to appear to be local, and have the option of replacing the shared content with customized content for a state that has it. Finally, it would be very nice to have search catalogs treat shared data as local. I remember seeing code for inserting a location into the acquisition path. Would that do the trick? Would it still work if I had multiple levels in a folder structure? Alternatively, can I create something like a symbolic link in Zope? Thanks for any suggestions or comments! Howard Hansen http://howard.editthispage.com

2 1

ZMySQLDA Problem
by Ben Ocean 26 Nov '01

26 Nov '01

Hi; Does anyone know how to get this to work? This is my second request for help. Please. I followed the instructions to install ZMySQLDA but ran into problems. First up, it appears that I do have the necessary python modules: [root@hermes i386]# rpm -qa|grep MySQL MySQL-client-3.23.42-1 MySQL-3.23.42-1 MySQL-devel-3.23.42-1 ...and make -f Makefile.pre.in boot goes smoothly, but when I try make I get this: [root@hermes src]# make gcc -fPIC -g -O2 -Wall -Wstrict-prototypes -I/usr/include/python2.1 -I/usr/include/python2.1 -DHAVE_CONFIG_H -I/usr/local/mysql/include -I/usr/include/mysql -c ././MySQLmodule.c -o ./MySQLmodule.o ././MySQLmodule.c:199: warning: function declaration isn't a prototype ././MySQLmodule.c: In function `clear_channel': ././MySQLmodule.c:204: warning: suggest parentheses around assignment used as truth value ././MySQLmodule.c: At top level: ././MySQLmodule.c:217: warning: function declaration isn't a prototype ././MySQLmodule.c:229: warning: function declaration isn't a prototype ././MySQLmodule.c: In function `pythonify_row': ././MySQLmodule.c:238: warning: assignment from incompatible pointer type ././MySQLmodule.c: At top level: ././MySQLmodule.c:339: warning: function declaration isn't a prototype ././MySQLmodule.c: In function `pythonify_res': ././MySQLmodule.c:344: warning: `thisrow' might be used uninitialized in this function ././MySQLmodule.c: At top level: ././MySQLmodule.c:373: warning: function declaration isn't a prototype ././MySQLmodule.c: In function `pythonify_res_fields': ././MySQLmodule.c:384: invalid lvalue in unary `&' ././MySQLmodule.c:378: warning: `tf' might be used uninitialized in this function ././MySQLmodule.c: At top level: ././MySQLmodule.c:483: warning: function declaration isn't a prototype ././MySQLmodule.c:502: warning: function declaration isn't a prototype ././MySQLmodule.c:530: warning: function declaration isn't a prototype ././MySQLmodule.c:562: warning: function declaration isn't a prototype ././MySQLmodule.c:580: warning: function declaration isn't a prototype ././MySQLmodule.c:607: warning: function declaration isn't a prototype ././MySQLmodule.c:634: warning: function declaration isn't a prototype ././MySQLmodule.c:662: warning: function declaration isn't a prototype ././MySQLmodule.c:688: warning: function declaration isn't a prototype ././MySQLmodule.c:722: warning: function declaration isn't a prototype ././MySQLmodule.c:734: warning: function declaration isn't a prototype ././MySQLmodule.c:753: warning: function declaration isn't a prototype ././MySQLmodule.c:767: warning: function declaration isn't a prototype ././MySQLmodule.c:779: warning: function declaration isn't a prototype ././MySQLmodule.c:796: warning: function declaration isn't a prototype ././MySQLmodule.c: In function `DBH_clientinfo': ././MySQLmodule.c:799: warning: unused variable `info' ././MySQLmodule.c: At top level: ././MySQLmodule.c:815: warning: function declaration isn't a prototype ././MySQLmodule.c:832: warning: function declaration isn't a prototype ././MySQLmodule.c:849: warning: function declaration isn't a prototype ././MySQLmodule.c:866: warning: function declaration isn't a prototype ././MySQLmodule.c:885: warning: function declaration isn't a prototype ././MySQLmodule.c:902: warning: function declaration isn't a prototype ././MySQLmodule.c:920: warning: function declaration isn't a prototype ././MySQLmodule.c:973: warning: function declaration isn't a prototype ././MySQLmodule.c:986: warning: function declaration isn't a prototype ././MySQLmodule.c:994: warning: function declaration isn't a prototype ././MySQLmodule.c:1032: warning: function declaration isn't a prototype ././MySQLmodule.c:1040: warning: function declaration isn't a prototype ././MySQLmodule.c:1070: warning: function declaration isn't a prototype ././MySQLmodule.c:1085: warning: function declaration isn't a prototype ././MySQLmodule.c:1102: warning: function declaration isn't a prototype ././MySQLmodule.c: In function `STH_fetchdict': ././MySQLmodule.c:1125: invalid lvalue in unary `&' ././MySQLmodule.c:1147: invalid lvalue in unary `&' ././MySQLmodule.c:1111: warning: `tf' might be used uninitialized in this function ././MySQLmodule.c: At top level: ././MySQLmodule.c:1176: warning: function declaration isn't a prototype ././MySQLmodule.c:1192: warning: function declaration isn't a prototype ././MySQLmodule.c:1201: warning: function declaration isn't a prototype ././MySQLmodule.c:1210: warning: function declaration isn't a prototype ././MySQLmodule.c:1225: warning: function declaration isn't a prototype ././MySQLmodule.c:1234: warning: function declaration isn't a prototype ././MySQLmodule.c:1257: warning: function declaration isn't a prototype ././MySQLmodule.c:1265: warning: function declaration isn't a prototype ././MySQLmodule.c:1296: warning: function declaration isn't a prototype make: *** [MySQLmodule.o] Error 1 What are all these warnings and what have I done wrong? TIA, BenO

4 3

Global Variable
by Pascal Samuzeau 26 Nov '01

26 Nov '01

Hi, I've that code : <dtml-let TEST="'dir'"> <dtml-in "portal_catalog.searchResults(Type='Cas clinique', review_state='published', sort_on='Date', sort_order='reverse')" size=1 end=1> <dtml-var id> </dtml-in> </dtml-in> <script type="text/javascript"> var image = 0; var delai = 2000; var icone = new Array (); var lelien = ''; var max = <dtml-var "compte_images(repertoire='/uv/web/cnr/cas/&TEST;',prefixe='Ima-') - 1">; I need to get the value returned by the <dtml-var id> in the function called "compte_images" and in some others later in the code. My question : I need something like a global variable, that I may use here and there. But, infortunately, I don't know how to write it. Anyone knows it ? Thank you PS -------------------------------------------------- Oreka ! Nous sommes l'internet moins cher ! Surfez 25% moins cher avec http://www.oreka.com

1 0

Fast and easy Christmas shopping! Beautiful gifts under $20.00
by Dennis McCrindle 26 Nov '01

26 Nov '01

1 0

Problems viewing pdf's
by Orietta Barbari 26 Nov '01

26 Nov '01

Hi does anybody know if there are any problems with viewing pdfs on zope ? >From the management interface, if I add/upload a file from my local machine which is a .pdf, and give it the id of 'mypdf', the file uploads perfectly. The problem occurs when I come put a link in my site which calls the pdf. (ie. <a href="mypdf" target="_blank">View mypdf</a>) The problem is, when I select the link to view the pdf document in a browser - sometimes it gets displayed and sometimes it doesn't. If I can't view my pdf, I've found that going back to the management interface and checking that the pdf is viewable there (clicking on the 'view' tab on the file) then makes it viewable in the browser too - however this is not a universal solution. I've checked that the Content Type property of mypdf = application/pdf, and have followed the instructions in the following posting : http://zope.nipltd.com/public/lists/zope-archive.nsf/47ba74c812dbc5dd802 5687f0024bb5f/3e35f3fd59a9dd2a8025691a005c40eb?OpenDocument but I'm afraid I'm still having no joy. I'm sure I'm missing something really obvious, could anyone point me in the right direction ? Any help would be much appreciated. Zope version : 2.4.1 on windows 2k Browser version : IE 5.5 Ori -------------------------- Orietta Barbari http://www.ehive.co.uk

1 0

User acces to this()
by James van der Veen 26 Nov '01

26 Nov '01

Hi everybody, hope someone can help me. I have a mySQLuserfolder with a role Called Student. I now only want to show a piece of the page if the user is logged in as a student so I have this in my DTML Method: <dtml-if "AUTHENTICATED_USER.hasRole(this(), ['Student'])"> But If I log in having a student role I get a unauthorized exception saying I´m now authorized to access "this". Does anyone have a hint to help me on this? Do I need to set a security role or something? Hope someone can help me on this one. Greetz, James

1 0

structured text nonascii-characters, umlaute
by Elena Schulz 26 Nov '01

26 Nov '01

Dear List, I am starting Zope 2.4.2 on win98 like so: "J:\Zope\ZopeSite\bin\python.exe" "J:\Zope\ZopeSite\z2.py" -D -L "german" %1 %2 %3 %4 %5 %6 %7 %8 %9 and refer to structurd text like: <dtml-var stxTest fmt=structured-text> but the umlaute like ä, ü, ö and other non ascii-characters are not rendered properly. Does anybody know what to do or where the problem might be? Thanks for your replies, Elena

3 2

WebDAV locking problem, some more enlightment
by Joachim Schmitz 26 Nov '01

26 Nov '01

Hi, I installed the mod_dav in my local apache, to try if it shows the same symtoms, and found some interesting things. 1. Word opens documents not writeprotected on the apache DAV-store, even if they are not writable !!! 2. By accident I had the executable flag set on a htm-file, this file is opened writeprotected !!! This is reproduceble, if you unset the x-flag it is opened in readwrite mode. I took a log of both situations: the only difference I could find was in the response to the GET /dav/testdocweb.htm HTTP/1.1 Accept-Language: de, en-us;q=0.2 If-None-Match: "1cb27-8ce-3bf6bf01" Translate: f User-Agent: Microsoft Data Access Internet Publishing Provider DAV Host: 10.2.1.1 Connection: Keep-Alive wich in the readwrite case is: HTTP/1.1 200 OK Date: Sat, 17 Nov 2001 19:50:19 GMT Server: Apache/1.3.19 (Unix) (SuSE/Linux) mod_python/2.7.2 Python/2.0 DAV/1.0.2 Last-Modified: Sat, 17 Nov 2001 19:50:08 GMT ETag: "1cb25-8fb-3bf6bf70" Accept-Ranges: bytes Content-Length: 2299 Keep-Alive: timeout=15, max=99 Connection: Keep-Alive Content-Type: text/html <html xmlns:o="urn:schemas-microsoft-com:office:office" .... rest of document and in the writeprotected case HTTP/1.1 200 OK Date: Sat, 17 Nov 2001 19:28:14 GMT Server: Apache/1.3.19 (Unix) (SuSE/Linux) mod_python/2.7.2 Python/2.0 DAV/1.0.2 Keep-Alive: timeout=15, max=99 Connection: Keep-Alive Transfer-Encoding: chunked Content-Type: text/html 8fb <html xmlns:o="urn:schemas-microsoft-com:office:office" .... rest of document. in this case the document is fetched a second time, after unlocking. which is also the case, when fetching a htm-file from Zope-Dav storage here is the get for a doc-file: GET /test/testdoc11111111.doc HTTP/1.1 Accept-Language: de, en-us;q=0.2 If-None-Match: ts06033018.5 Translate: f User-Agent: Microsoft Data Access Internet Publishing Provider DAV Host: a.b.de:9800 Connection: Keep-Alive Authorization: Basic xxxxxxxx= and here the response: HTTP/1.1 200 OK Server: Zope/(Zope 2.4.3 (binary release, python 2.1, linux2-x86), python 2.1.0, linux2) ZServer/1.1b$ Date: Sat, 17 Nov 2001 21:38:41 GMT Accept-Ranges: bytes Content-Type: application/msword Content-Length: 19456 Last-Modified: Sat, 17 Nov 2001 21:36:58 GMT it follows the binary doc-file here is the get for an htm-file: GET /test/testweb1.htm HTTP/1.1 Accept-Language: de, en-us;q=0.2 Translate: f User-Agent: Microsoft Data Access Internet Publishing Provider DAV Host: a.b.de:9800 Connection: Keep-Alive Authorization: Basic xxxxxxxxxx= and the response: HTTP/1.1 200 OK Server: Zope/(Zope 2.4.3 (binary release, python 2.1, linux2-x86), python 2.1.0, linux2) ZServer/1.1b$ Date: Sat, 17 Nov 2001 21:38:12 GMT Content-Type: text/html Content-Length: 2703 The only thing which is not there in the writeprotected cases in the response is the "ETag:" and the "Accept-Ranges: bytes", perhaps that tells something to the wizards of the HTTP-protocol ;-) Mit freundlichen Grüßen Joachim Schmitz AixtraWare, Ing. Büro für Internetanwendungen Hüsgenstr. 33a, D-52457 Aldenhoven Telefon: +49-2464-8851, FAX: +49-2464-905163

2 2