[Zope] SQL-Session 3.0 -- session won't be writen to database

2000-09-03 Thread Andy Pahne



Hi,

I'm playing around with SQLSession-3.0

When I do something like the following:


   dtml-call Session
   dtml-call "SESSION.set('foo','bar')"
   dtml-var "SESSION['foo']"

my session variable "foo" renders as I expected. But when I move to another
page my session-variable "foo" is not available.

Creating a session works perfect and the next page remembers about the
created session and gives me the correct name, but no session-variables.

I checked the database and there werde no entries in my session-data table.
Am I missing something like
  dtml-call "SESSION.nowWriteItIntoTheDatabase()"
or what?



Andy Pahne
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] ZClass and Propertysheets

2000-08-30 Thread Andy Pahne



Hi,

I have created a ZClass with a propertysheet called "Basic". I added a
property "db_id", integer value with a default value of 0. Then I created
two instances and changed the value to 1 in the first and 2 in the second
instance.

When I try to render the property with a dtml-var db_id I get a 1 in both
instances. That's not what I expected in the beginning. In particular not
because there doesn't seen to be anything wrong when I have a look at the
property sheet in the instance's management screen. I have different values
there.

Am I wrong or is there something wrong with Zope 2.2.1 and ZClasses?


Andy Pahne
[EMAIL PROTECTED]


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] search on www.zope.org

2000-07-28 Thread Andy Pahne



Can anybody please tell me the search on www.zope.org does not find any
pages containing?

  - mod_pcgi2

In fact there are numerous pages including this term.


Andy Pahne
[EMAIL PROTECTED]

net22 GmbH
Bad Meinberger Strasse 1
32760 Detmold
Tel.: 05231 - 580 640



___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] monitoring the zope-process with daemontools

2000-07-27 Thread Andy Pahne



hi,

not really a zope-problem, but maybe someone can help me:

I have posted a few days ago that I have problems with my zope dying
suddenly.

Someone suggested to use D. Bernsteins daemon-tools, not as a solution to my
problem, but helpful anyway. I made this tool working on my production
system, but there's one problem with it: as long as I start it by hand with
the command
  svscan /service 
everything works fine.

But when I start it automatically at boot time (through an entry in
rc.local) then Zope starts up as I wanted it to do, it gets monitored and
restarted again in case of a sudden death, but my DCOracle Database
Connection tells me "not connected" and when I try to open it, Zope dies.

I have trouble connecting to Oracle since month now, it never works as I
expect. Is there anybody out there having no problems with Zope and Oracle
databases? I'd really like to know that.


Yours,

Andy Pahne
[EMAIL PROTECTED]

net22 GmbH
Bad Meinberger Strasse 1
32760 Detmold
Tel.: 05231 - 580 640



___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] zope 2.2.0 simply dies

2000-07-24 Thread Andy Pahne


I have a Zope-2.2.0 installation running on a Redhat 6.0 Linux Box. It
simply dies sometimes. Three times in the last 72 hours?!?

There's only DCOracle and ZOracleDA installed, nothing more. I cannot see
any other problems on the machine and it does not have that much load.

Is there a solution? Has anybody had the same problem?

Andy Pahne
[EMAIL PROTECTED]

net22 GmbH
Bad Meinberger Strasse 1
32760 Detmold
Tel.: 05231 - 580 640



___
Zope maillist  -  [EMAIL PROTECTED]
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 )




Re: [Zope] 2.2 installation problem on Linux

2000-07-17 Thread Andy Pahne


not for me. everything worked fine on my redhat 6.0 box.
first I thought upgrading would be a nightmare but after all it took me 10
minutes and all my sites are up and running smoothly :-)

andy


Hi,

this seams to be a bugglet in the final distribution, the pcgi_wrapper is
not build by the install script. This worked in beta 4. You can fix it by
running it manally in the pcgi-directory like:

cd pcgi
sh configure
make

On Sat, 15 Jul 2000, Ragnar Beer wrote:

 Howdy!

 Zope 2.2 (linux2) installs and works fine using ZServer but for
 whatever reason there is no pcgi-wrapper built in the pcgi dir so
 that I cannot call Zope.cgi. I checked again and again but ./install
 doesn't give an error message. What am I doing wrong?

 --Ragnar



___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] oracle8 and cursors

2000-07-05 Thread Andy Pahne



hi, there,


i've been using oracle8 with zope succesfully for a while. now my database
programmer came up with a solution for a certain problem, which "we cannot
solve with an easy select statement". he told me, that we are gonna have to
use db-cursors instead.

i must admit that i have heard the therm cursor before, but i am not sure
how to use them with zsql-methods.

my question is fairly simple: is there any difference in handling cursors
with zsql-methods in comparison to handling 'simple' select-statements? can
i use dtml-in "..."/dtml-in to iterate over the result sets?

I read DCOracle.txt which comes along with DCOracle-Product, but I do not
understand it very well.

Any recommended readings?


Andy Pahne
ap@net22

net22 GmbH
Bad Meinberger Strasse 1
32760 Detmold
Tel.: 05231 - 580 640



___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] another nice error-message

2000-06-05 Thread Andy Pahne



humor
 I replaced the standard_error_message whth dtml-fortune.
 Now I'm havin much fun everytime some obscure error occurs.

 I highly recommend, you developers do the same, not only for you but for
your visitors as well
/humor


Andy Pahne
ap@net22

net22 GmbH
Bad Meinberger Strasse 1
32760 Detmold
Tel.: 05231 - 580 640



___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] SQL-Query works with MySQL-monitor but not with ZMySQLDA

2000-05-29 Thread Andy Pahne



Hi, there,

if I use my mysq-monitor to execute the following query, everything works
fine:

 SELECT YEAR(START_DATE) FROM EVENT;

but it doesn't work via the ZMySQLDA!?!

Here's the traceback:

Error, exceptions.KeyError: unhandled

Traceback (innermost last):
  File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 214,
in publish_module
  File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 179,
in publish
  File /zope/ttl/Zope-2.0.1-src/lib/python/Zope/__init__.py, line 201, in
zpublisher_exception_hook
(Object: sql_get_years_unique)
  File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 165,
in publish
  File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/mapply.py, line 160,
in mapply
(Object: manage_test)
  File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 102,
in call_object
(Object: manage_test)
  File /zope/ttl/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/DA.py, line 316,
in manage_test
(Object: sql_get_years_unique)
  File /zope/ttl/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/DA.py, line 297,
in manage_test
(Object: sql_get_years_unique)
  File /zope/ttl/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/DA.py, line 401,
in __call__
(Object: sql_get_years_unique)
  File /zope/ttl/Zope-2.0.1-src/lib/python/Products/ZMySQLDA/db.py, line
191, in query
KeyError: (see above)





Andy Pahne
ap@net22

net22 GmbH
Bad Meinberger Strasse 1
32760 Detmold
Tel.: 05231 - 580 640



___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] newbie question: parameter passing for ZSQL Object

2000-05-26 Thread Andy Pahne

It's pretty easy:

  dtml-call "sql_method(argument1=value1, argument2=value2)"



There's a problem with your SQL-statement:


INSERT INTO plan
(field1, field2, field3, field4)
VALUES
(dtml-var param1, dtml-var param2, dtml-var param3, dtml-var
param4)


It should be:

INSERT INTO plan
(field1, field2, field3, field4)
VALUES
(dtml-sqlvar param1 type=string,
 dtml-sqlvar param2 type=string,
 dtml-sqlvar param3 type=string,
 dtml-sqlvar param4 type=string)



Andyman


___
Zope maillist  -  [EMAIL PROTECTED]
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 )