- Zope - Zope lists

Re: [Zope] Zope and Databases
by tgraham＠speakeasy.net 25 Feb '02

25 Feb '02

Do You have Oracle Client tools installed on the box that Zope is running on? I'm pretty sure that the Zope DA will need to know what and where the database you are trying to connect to is located. This information is usually supplied to Oracle Client tools via a file called tnsnames.ora. I'd recommend searching Oracle site for client tools for linux. On 25 Feb 2002, Richard Hewison wrote: > Our Zope 2.4.3 install is running on a SuSE > Linux 7.3 server and we want to connect to an > Oracle database which is sitting on a > different server; a Sun Solaris based machine > running OS 5.8 with Oracle Enterprise Edition > 8.1.7.0 installed. > > We have downloaded the DCOracle2 product (for > Red Hat Linux > 7.1, Python 2.1) but we aren't using Red Hat > and we seem unable to get the product to > install properly. It complains about the > ORACLE_HOME. Also, skimming through the > documentation is extremely confusing. As far > as we can tell, the docs seem to assume that > the Oracle Database is installed (or to be > installed) on the same server as the one > that runs Zope. In our scenario, this isn't > the case. > > Basically, how can we discover the correct > ORACLE_HOME info from the Sun box and what > else do we need to do with DCOracle2 to get it > connecting to our Oracle database? (We know > very little about Oracle if you can't tell > already!). > > > > Richard H. > > _____________________________________________- > __ > 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/listinf- > o/zope-announce http://lists.zope.org/mailman- > /listinfo/zope-dev )

1 0

stack error with Python 2.1.2
by Frank Tegtmeyer 25 Feb '02

25 Feb '02

Hi, I tried to move to Python 2.1.2 with an existing site and got a stack error under some circumstances. The site provides five different websites distinguished by Virtual Site Root. The error: python: Python/ceval.c:687: eval_code2: Assertion `(stack_pointer - f->f_valuestack) <= f->f_stacksize' failed. I found some places where this is mentioned, mostly explained with illegal bytecode. Because I removed all bytecode and shared libraries before recompiling Zope and the C extensions I dont't assume that this is the case. The interesting part is: the site which was defined first (using VSR) is accessible. Every other site fails. Also the navigation frame in the management interface fails while the content frame works without problems. The Python interpreter is the (first and) only one on the system so interferences with other Python installations are not possible. The configure line for Python: ./configure --prefix=/usr/local --with-crypt --without-pymalloc --with-threads Additionally I enabled SSL for the socket module. I hope someone can reproduce this. I am not able to do debugging for this myself. I will switch back to Python 2.1.1. Regards, Frank

2 6

Zope users in the UK
by Tom Nixon 25 Feb '02

25 Feb '02

Are there any Zope developers in the UK? The only reference I can find is http://www.zope.co.uk which seems to be stagnant. If anyone is interested in a UK Zope developer's group then please e-mail me off-list. Cheers Tom

3 3

Upgrade Zope 2.1.1 to Current - Suggestions???
by Robert Geiger 25 Feb '02

25 Feb '02

I Would like to Upgrade my Zope installation to current version. Would like the best set of instructions available. I found this document: http://www.zope.org/Members/mcdonc/HowTos/zopeinstall/ZOPE-INSTALL-HOWTO would it be best to follow these instructions? Is there anything I should look out for, any gotcha's? Thanks. My current version information: Zope version: Zope 2.1.1 (binary release, python 1.5.2, linux2-x86) Python version: 1.5.2 (#10, Dec 6 1999, 12:16:27) [GCC 2.7.2.3] System Platform: linux2 -- Robert Geiger

4 5

virtual server problem
by Frank Tegtmeyer 25 Feb '02

25 Feb '02

Hi, I just tried to use VirtualHostMonster in Zope 2.5.1b1 for a setup that is quite common at our clients. Let me first explain the setup. We use Apache with mod_rewrite and mod_proxy to access the Zope server. Zope provides typically multiple virtual servers. To be able to manage the Zope server itself we always define an additional virtual server 'z' that is located at the root of the Zope server itself: z.do.main --> mapped to / a.do.main --> mapped to /a.do.main b.do.main --> mapped to /b.do.main With VHM I was not able to provide the mapping for 'z' because VHM insists on having a path. So I installed a SiteRoot for z as always. The result was, that the VHM mapping for a and b were broken. The use of absolute_url() inside of a and b always gives urls located in z (even they were wrong). I would like to use VHM because of it's centralizing of management - is there a way to get a VHM-only solution for our setup? At the moment we use a SiteRoot at the top and virtual site roots for a and b. To avoid questions: No, we cannot access the Zope server directly from the outside. Regards, Frank

3 3

How to insert objects
by dorian santner 25 Feb '02

25 Feb '02

e.g.: I have a directory structure like root +-test +-test2 i have a dtml-method in the root called index_html i have a dtml-method in test called myinput How can i insert myinput in the index_html ? I need a kind of <dtml-var myinput> but including the path to test. I know the other way around would work, as the namespaces could coope with that. Thanx Dorian

2 1

Zope.org troubles and what to do with errors.
by Marcin Kasperski 25 Feb '02

25 Feb '02

www.zope.org shows to me currently so: ----------------------------------------------- <DIV class=Section1> <P class=MsoNormal style="mso-list: none; mso-list-ins: '' 19991102T2025">  </P> <TABLE border=1 cellPadding=0 style="BORDER-BOTTOM: 4.5pt outset; BORDER-LEFT: 4.5pt outset; BORDER-RIGHT: 4.5pt outset; BORDER-TOP: 4.5pt outset; WIDTH: 100%; mso-cellspacing: 1.5pt" width="100%"> <TBODY> <TR> <TD style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt" width="22%"> <P class=MsoNormal><B>Problem Report</B></P> </TD> <TD style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt" width="78%"> <P class=MsoNormal>There was a communication problem.</P> </TD> </TR> (....) <P class=MsoNormal><ul><li>The Web server may be down.</li> <li>The Web server may be too busy.</li> <li>The Web server may be experiencing other problems, preventing it from responding to clients.</li> <li>The communication path may be experiencing problems.</li></ul> <SPAN class=msoIns><INSdatetime="1999-11-02T20:37" cite="mailto: %20 "></SPAN></p> </TD> (...) --------------------------------------------- Leaving the actual problem apart, it raises the question about the quality of zope error messages...

5 5

Log severity without stupid log file?
by Lennart Regebro 25 Feb '02

25 Feb '02

I want to start Zope (2.3.3) with a log severety of 0 but I'm not using stupid log file, but just loggin to stdout (this is Windows). How do I do this? Using -D makes it write out everything including debug info, which I don't want. Not using -D means it only writes out errors, and not INFO level logs. I want something in the middle, ans STUPID_LOG_SEVERITY obviously doens't work. So what now?

1 0

Re: Insert Help
by Todd Loomis 25 Feb '02

25 Feb '02

Dieter: Could you explain a little more I still seem to be trying to input everything all on one record. I need to break out in an array then each needs to be added to the database as a separate record. Maybe I missed something. Thanks, Todd Todd Loomis writes: > I want to insert to a database a id and a option, however each id can have > more than one option. And I want them inserted separately to make 2 records. > > The form will be checkboxes they check all the options they want and they > all get save in the database seperately but with the same id. I've tried to > no luck. Can anybody help? Some basic observations: ZSQL Method bodies are DTML objects. You use DTML there to generate SQL in the same way you use DTML usually to generate HTML. Especially, you have the "dtml-in" in order to iterate over sequences. A ZSQL Method can generate and execute several SQL commands. These commands need to be separated by "<dtml-var sql_delimiter>". Thus, you use something like: <dtml-in options> insert into ... <dtml-unless sequence-end><dtml-var sql_delimiter></dtml-unless> </dtml-in> You need to be a bit careful with your options in the form. It should probably contain something like: <input type="hidden" name="options:list" value="dummy"> ... <input type="checkbox" name="options:list" value="..."> ... The hidden variable ensures that you always get something for options. The ":list" ensures that the case of a single option leads to a list as well as multiple options. When you use the hidden variable approach as shown above, then your options list contains a bogus first element. You need to drop it again. The "dtml-in options" above becomes 'dtml-in expr="options[1:]"'. Dieter _______________________________________________ Zope maillist - Zope@z... 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

dtml-sqlgroup broken
by Andy Dustman 25 Feb '02

25 Feb '02

The following Z SQL Method used to work prior to 2.5.0, but now produces an error (2.5.1b1 included): Arguments: spam:int:optional SELECT spam, eggs, sausage FROM foo2 <dtml-sqlgroup where> <dtml-sqltest spam type="int" optional> </dtml-sqlgroup> Error Type: TypeError Error Value: unbound method __init__() must be called with instance as first argument Traceback (innermost last): File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/Publish.py, line 114, in publish File /home/andy/Zope-2.5.1b1-src/lib/python/Zope/__init__.py, line 159, in zpublisher_exception_hook (Object: SELECT) File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/Publish.py, line 98, in publish File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: manage_edit) File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: manage_edit) File /home/andy/Zope-2.5.1b1-src/lib/python/Shared/DC/ZRDB/DA.py, line 174, in manage_edit (Object: SELECT) File /home/andy/Zope-2.5.1b1-src/lib/python/DocumentTemplate/DT_String.py, line 350, in cook (Object: <string>) File /home/andy/Zope-2.5.1b1-src/lib/python/DocumentTemplate/DT_String.py, line 179, in parse (Object: <string>) File /home/andy/Zope-2.5.1b1-src/lib/python/DocumentTemplate/DT_String.py, line 246, in parse_block (Object: <string>) TypeError: (see above) Line numbers may be shifted slightly due to debugging code inserted. The line where the error occurs is: DEBUG and DLOG('parse_block: %s(%s)' % (`scommand`,`blocks`)) r=scommand(blocks) 2002-02-24T06:13:11 PROBLEM(100) DT DEBUG parse_block: <class Shared.DC.ZRDB.sqlgroup.SQLGroup at 0x8628afc>([('sqlgroup', 'where', <DocumentTemplate.DT_HTML.HTML instance at 0x89d999c>)]) I'd also like to draw attention to collector issues 6, 15, and 192... I particularly would like to see 15 implemented... If it will help, I'll put this in the collector as well. Basically, Z SQL Methods are nearly useless at this point. Andy Dustman PGP: 0x930B8AB6 @ .net http://dustman.net/andy You can have my keys when you pry them from my dead, cold neurons.

3 3