January 2000 - Zope - Zope lists

Zope/Linux/Oracle - Cannot establish DB connection
by Nerlich, Andrew 04 Jan '00

04 Jan '00

I have successfully installed Zope-2.0.1 (from the RPM) and ZOracleDA-2.1.0 over RedHat 6.0 for Intel x86. I am using Oracle 8.0.5.0.0 for Linux which runs SQLPlus, etc. just fine. The ZOracleDA install passes the DCOracle_test.py script when run from root and the dba account, so AFAIK everything s/b hunky dory and I have established (to myself at least) that I am not a complete moron. However, I am unable to set up a ZOracleDA connection and connect to Oracle. I can set up a connection object without connecting immediately, but subsequent connection attempts on this object fail. The browser (NC 4.6) gives me a "The document returned no data. Try again later or contact the server's administrator." message. Inspection of the /var/zope directory shows a sqlnet.log file which contains the following connection string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=oracle)(ARGV0=oracle)(ARGS='(DE SCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(C ID=(PROGRAM=)(HOST=localhost.localdomain)(USER=nobody)))) This fails with a number of errors TNS-12206 TNS-12545 TNS-00515 The Linux distro of Oracle does not include error message docs :-( But a copy of the WinNT docs I have does not include TNS messages over c TNS-05000 but does mention TNS-00515. This is a "Target not found" message - meaning either the Oracle executable cannot be found or the node cannot be found.The documentation indicates the the ORACLE_SID must be included in the bequeath protocal connection string, and it is notably absent from the above. I have put all my Oracle environment variables (ORACLE_SID, ORACLE_HOME, etc., and a PATH entry to the Oracle /bin directory) in /etc/profile. However, I am using nobody as the Zope user ID, and I cannot remember whether a non-login account such as nobody will execute /etc/profile or not. If not, how is Zope going to find out where oracle is and what the SID is? Should I use another account or is there some other way to pass the environment variables to ZOracleDA? Or is there some other problem? I have looked at various pieces of code, but have done no work with Python before, and haven't done anything professionally with Unix or Oracle for over 12 months, and that was a a developer, not a DBA. Any ideas as to how to attack this problem will be gratefully received TIA Andrew Andrew Nerlich Strategic Operating Solutions Pty Ltd (02) 9966 8707 0418 407 833 ajn(a)sosos.com.au

2 1

RE: [Zope] Zope/Linux/Oracle - Cannot establish DB connection
by Nerlich, Andrew 04 Jan '00

04 Jan '00

OK, that looks like it. When I stopped ZServer (which was originally started by init on boot) and restarted it from a logon (which would have run /etc/profile where all the Oracle environment variables were initialised), I was able to connect. It looks like I need to set these ORACLE_ environment variables in my startup scripts. Is it a good idea to do this in /etc/rc.d/init.d/zope, or would you recommend doing it somewhere else? BTW, Rob, I am extremely impressed by your prompt response. Many thanks. Andrew -----Original Message----- From: Rob Page [mailto:rob.page@digicool.com] Sent: Tuesday, 4 January 2000 11:15 To: 'Nerlich, Andrew' Cc: 'zope(a)zope.org' Subject: RE: [Zope] Zope/Linux/Oracle - Cannot establish DB connection Andrew Nerlich wrote: > I'm connecting http->ZServer. Does the user under which ZServer is running have ORACLE_HOME defined? --Rob _______________________________________________ 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] Zope/Linux/Oracle - Cannot establish DB connection
by Rob Page 04 Jan '00

04 Jan '00

Andrew Nerlich wrote: > I'm connecting http->ZServer. Does the user under which ZServer is running have ORACLE_HOME defined? --Rob

1 0

RE: [Zope] Zope/Linux/Oracle - Cannot establish DB connection
by Nerlich, Andrew 03 Jan '00

03 Jan '00

I'm connecting http->ZServer. -----Original Message----- From: Rob Page [mailto:rob.page@digicool.com] Sent: Tuesday, 4 January 2000 10:29 To: 'Nerlich, Andrew' Cc: 'zope(a)zope.org' Subject: RE: [Zope] Zope/Linux/Oracle - Cannot establish DB connection Andrew Nerlich wrote: > I have successfully installed Zope-2.0.1 (from the RPM) and > ZOracleDA-2.1.0 over RedHat 6.0 for Intel x86. I am using Oracle 8.0.5.0.0 > for Linux which runs SQLPlus, etc. just fine. In my experience, your Oracle setup is fine if you can successfully run sqlplus. How are your browsers talking to Zope? o http->ZServer o http->Apache->PCGI->ZServer ? --Rob _______________________________________________ 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] Zope/Linux/Oracle - Cannot establish DB connection
by Rob Page 03 Jan '00

03 Jan '00

Andrew Nerlich wrote: > I have successfully installed Zope-2.0.1 (from the RPM) and > ZOracleDA-2.1.0 over RedHat 6.0 for Intel x86. I am using Oracle 8.0.5.0.0 > for Linux which runs SQLPlus, etc. just fine. In my experience, your Oracle setup is fine if you can successfully run sqlplus. How are your browsers talking to Zope? o http->ZServer o http->Apache->PCGI->ZServer ? --Rob

1 0

Zope debugging, TmpStorage and other stuff
by Andrey V Khavryutchenko 03 Jan '00

03 Jan '00

Hi! To set up the debugging framework for my application, I have to do something that would: - construct the Zope object with temporary storage w/o starting any servers - build my site in this Zope object (trivial, not a problem) - pass requests to this Zope object Here's the sketch code: # -*- python -*- # sketch, not the real code import Zope, ZPublisher, ZODB Zope.DB = ZODB.TmpStore.TmpStore(Zope.Globals.DatabaseVersion) # at this point I want to have Zope ready to serve using the temporary # storage and w/o binding any inet ports import mysite mysite.build(Zope.root_folder) # here my site is constructed in previously build Zope object print ZPublisher.publish(Zope.root_folder, '/index_html') # this prints the main page of my site # end of python code Questions: (1) Will the stuff like this work? Would somebody, knowledgeable of Zope internals, to advise: - how to change ZODB storage? - how to access Zope root folder? - how correctly run requests against Zope object? (2) Rather stupid. I can't import Zope: Python 1.5.2 (#2, Nov 24 1999, 21:47:58) [GCC egcs-2.90.29 980515 (egcs-1.0.3 re on linux-%_target_cpu Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam >>> import sys >>> sys.path.append('/usr/share/zope/lib/python') >>> import Zope Traceback (innermost last): File "<stdin>", line 1, in ? File "/usr/share/zope/lib/python/Zope/__init__.py", line 95, in ? import Globals, OFS.Application, sys File "/usr/share/zope/lib/python/OFS/Application.py", line 96, in ? from AccessControl.User import UserFolder File "/usr/share/zope/lib/python/AccessControl/User.py", line 294, in ? raise 'InstallError', ( InstallError: No access file found at /usr/share/zope - see INSTALL.txt Investigation shows that the problem is wrong content of INSTANCE_HOME, but I have some difficulties to figure out at midnight how to pass it into AccessControl.User :) Thanks in advance. -- SY, Andrey V Khavryutchenko http://www.kbi.kiev.ua/~akhavr Software & SPI Engineer Visit my site Shick's Law: There is no problem a good miracle can't solve.

1 0

ZClass permissions
by Darcy Clark 03 Jan '00

03 Jan '00

I wrote a ZClass that uploads files and sets several properties for the file, which I am running 'programmatically' with the following code : <dtml-with "PARENTS[1].files"> <dtml-with "manage_addProduct['CourseDocument']"> <dtml-call "CourseDocumentClass_add(_.None, _, NoRedir=1)"> </dtml-with> </dtml-with> this code works only when I am logged in as Superuser.....I created a user-defined role called 'Editor' and set all of the permissions that I thought would be necessary for this role (e.g. Upload Files, etc...) but I get an error : "You are not authorized to access CourseDocumentClass" Is there a permission setting somewhere that I need to enable for Editors to be able to use this class ? thanks for any help, Darcy -- --------------------------------------------------- Ph: (734) 764 3377 Email: darcyc(a)engin.umich.edu URL: http://www-personal.engin.umich.edu/~darcyc/ --------------------------------------------------- 'If you're not part of the solution, you're part of the precipitate' ..... Steven Wright

1 0

jumping out of the tree
by Kyle Burnett 03 Jan '00

03 Jan '00

i'm am trying to control the default table values that the tree tag uses. i am really looking for a way to do this in the elements themselves and not have to monkey with the actual program code. is anyone familiar with this? kyle burnett http://www.newtimes.com/?zope

1 0

fastcgi problem
by Sam Gendler 03 Jan '00

03 Jan '00

I have fastcgi (the Oct 6 snapshot) installed on apache 1.3.9 I have the following configuration directives in my httpd.conf NameVirtualHost 207.71.228.21:7080 # # VirtualHost example: # Almost any Apache directive may go into a VirtualHost container. # <VirtualHost 207.71.228.21:7080> ServerName www.impossible.com DocumentRoot /home/httpd/impossible ServerAlias impossible.com *.impossible.com ServerAdmin admin(a)impossible.com ErrorLog /home/httpd/log/www.impossible.com-error_log CustomLog /home/httpd/log/www.impossible.com-access_log common FastCgiExternalServer /home/httpd/impossible/zope \ -socket impossible.soc \ -pass-header Authorization <Location /zope> Options ExecCGI SetHandler fastcgi-script </Location> </VirtualHost> However, when I attempt to access www.impossible.com:7080/zope/index_html, I get many broken graphics but the bulk of the page is there. If I try to go to any other page on the site, I still get the index_html page. I cannot access the /manage page at all. Accessing these pages through ZServer works just fine (go to www.impossible.com on port 80 to see ZServer, port 7080 for apache). I really want to have apache redirect anything in the root '/' directory to zope, but that wasn't working any better. Does anyone out there know what might be going wrong here? --sam

1 0

Can I send a job requirement to your mail list. Please read
by mmurphy＠newmill.com 03 Jan '00

03 Jan '00

To whom it may concern: My name is Michael Murphy and I represent New Millennium Inc., a leading supplier of Software consultants and IT professionals to end clients across the country. I'm emailing to seek permission to post a job position to your mail list subscribers. I currently have a client looking for a consultant with solid ZOPE experience to lead a web e-commerce development project. If this is not possible, perhaps you may know of a site that ZOPE consultants use that might allow me a chance to post this position. Thanks for your time and attention in this matter. I look forward to your speedy response. Best regards. Mike Murphy New Millennium Inc. 800-381-9507(v) 800-381-8708(f) 401-792-0997 mmurphy(a)newmill.com

1 0