Re: RE : Re: [Zope-dev] database

2007-01-09 Thread Maciej Wisniowski 

> I didn't find ZPsycopgDA but i have finded the package
> psycopg2.* who contain ZpsycopgDA,
> I buid it and install it,
> i don't know what doing else for installing ZpsycopgDA
> between my products?
> the file event.log don't give me any error?
You should write these posts to zope-db mailing list
not to zope-dev.

If you've installed psycopg2 and you put ZpsycopgDA
into your Zope instance Products directory then,
if everything is OK:
1. You should see ZpsycopgDA product at:
ControlPanel->ProductManagement in ZMI (Zope
Management Interface) and it's status shouldn't be
broken.

2. You should see ZPsycopgDAConnection (or
something like that) in the Add list in ZMI.

Take a look at Zope book (eg. Zope book 2.7
edition on plope.org) at relational database
connectivity.

-- 
Maciej Wisniowski


___
Zope-Dev maillist  -  Zope-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope )

RE : Re: [Zope-dev] database

2007-01-09 Thread Graziella Toutoungis 
I didn't find ZPsycopgDA but i have finded the package
psycopg2.* who contain ZpsycopgDA,
I buid it and install it,
i don't know what doing else for installing ZpsycopgDA
between my products?
the file event.log don't give me any error?

thanks fo all helps
 G.

> Graziella Toutoungis wrote at 2007-1-8 14:32 +:
> >In order to connect via Zope to a database
> (postgresql) i search an adapter for postgresql8.*.
> >I found it ZPoPyDa, i try to install it in
> MyZopeInsatance/Products without success , i tried
> in zope/lib/python/products no success also.
> >
> >Where i have to install this adapter (for seeing it
> in my product's list in the control panel)?
> >There is another adapter for postgresql8.*?
> 
> We are using "ZPsycopgDA" (with Zope 2.8.1 and
> Postgres 8) without
> problems.
> 
> 
> 
> -- 
> Dieter
> 


__
Do You Yahoo!?
En finir avec le spam? Yahoo! Mail vous offre la meilleure protection possible 
contre les messages non sollicités 
http://mail.yahoo.fr Yahoo! Mail 
___
Zope-Dev maillist  -  Zope-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope )

Re: [Zope-dev] database

2007-01-08 Thread Dieter Maurer 
Graziella Toutoungis wrote at 2007-1-8 14:32 +:
>In order to connect via Zope to a database (postgresql) i search an adapter 
>for postgresql8.*.
>I found it ZPoPyDa, i try to install it in MyZopeInsatance/Products without 
>success , i tried in zope/lib/python/products no success also.
>
>Where i have to install this adapter (for seeing it in my product's list in 
>the control panel)?
>There is another adapter for postgresql8.*?

We are using "ZPsycopgDA" (with Zope 2.8.1 and Postgres 8) without
problems.



-- 
Dieter
___
Zope-Dev maillist  -  Zope-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope )

[Zope-dev] database

2007-01-08 Thread Graziella Toutoungis 
Hello,

In order to connect via Zope to a database (postgresql) i search an adapter for 
postgresql8.*.
I found it ZPoPyDa, i try to install it in MyZopeInsatance/Products without 
success , i tried in zope/lib/python/products no success also.

Where i have to install this adapter (for seeing it in my product's list in the 
control panel)?
There is another adapter for postgresql8.*?

I use Zope2.9.4.

Thanks
   G.




__
Do You Yahoo!?
En finir avec le spam? Yahoo! Mail vous offre la meilleure protection possible 
contre les messages non sollicités 
http://mail.yahoo.fr Yahoo! Mail ___
Zope-Dev maillist  -  Zope-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope )

Re: [Zope-dev] Database mounting problem in 2.9.3?

2006-06-26 Thread Dieter Maurer 
Chris Withers wrote at 2006-6-26 14:16 +0100:
>> ...
>> You see here the new (ZODB 3.6) multi-database support.
>> 
>>Something tries to ad the database "packed" to a
>>multi-database that already contains a "packed".
>> 
>> This might happen when you mount the same storage at different places
>> into your hierarchy.
>
>Indeed, and this is a perfectly legitimate use case...
>
>I have a Packed.fs and an UnPacked.fs:
>
>/content from Packed.fs is mounted to /content of UnPacked.fs
>/Catalog from Packed.fs is mounted to /Catalog of UnPacked.fs
> ...
>So, two questions:
>
>1. Is this a ZODB or a Zope bug? (ie: which collector do I file this in?)

I do not know, yet.

We are still using ZODB 3.4 and multi-database support was added
in ZODB 3.6.

But, I expect it is a Zope bug because both of your mounts
could (and almost surely should) use the same database and connection.

Both Zope and ZODB use the same collector. ZODB bugs get
the category "database".

I would file the bug report in this way (Zope collector
with category "database") even if it is not a ZODB error
(at least it is database related).

>2. Given that this is an exception being raised rather than a log 
>message, how come everything works fine even after the exception has 
>been reported?

I do not know -- as I did not yet analyse such a problem.



-- 
Dieter
___
Zope-Dev maillist  -  Zope-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope )

Re: [Zope-dev] Database mounting problem in 2.9.3?

2006-06-26 Thread Chris Withers 

Dieter Maurer wrote:

Chris Withers wrote at 2006-6-23 17:12 +0100:

Get this error on startup with one project I've just moved to Zope 2.9.3:

  File "/usr/local/zope/2.9.3/lib/python/Zope2/Startup/datatypes.py", 
line 175, in createDB

return ZODBDatabase.open(self, databases)
  File "/usr/local/zope/2.9.3/lib/python/ZODB/config.py", line 105, in open
databases=databases)
  File "/usr/local/zope/2.9.3/lib/python/ZODB/DB.py", line 262, in __init__
raise ValueError("database_name %r already in databases" %
ValueError: database_name 'packed' already in databases


You see here the new (ZODB 3.6) multi-database support.

   Something tries to ad the database "packed" to a
   multi-database that already contains a "packed".

This might happen when you mount the same storage at different places
into your hierarchy.


Indeed, and this is a perfectly legitimate use case...

I have a Packed.fs and an UnPacked.fs:

/content from Packed.fs is mounted to /content of UnPacked.fs
/Catalog from Packed.fs is mounted to /Catalog of UnPacked.fs

...for this project, content is managed elsewhere and often imported 
into Zope, so packing very often is a necessity.


Unpacked.fs contains code, user information, etc, which should never be 
packed.


So, two questions:

1. Is this a ZODB or a Zope bug? (ie: which collector do I file this in?)

2. Given that this is an exception being raised rather than a log 
message, how come everything works fine even after the exception has 
been reported?


cheers,

Chris

--
Simplistix - Content Management, Zope & Python Consulting
   - http://www.simplistix.co.uk

___
Zope-Dev maillist  -  Zope-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
http://mail.zope.org/mailman/listinfo/zope-announce

http://mail.zope.org/mailman/listinfo/zope )

Re: [Zope-dev] Database mounting problem in 2.9.3?

2006-06-24 Thread Dieter Maurer 
Chris Withers wrote at 2006-6-23 17:12 +0100:
>Get this error on startup with one project I've just moved to Zope 2.9.3:
>
>   File "/usr/local/zope/2.9.3/lib/python/Zope2/Startup/datatypes.py", 
>line 175, in createDB
> return ZODBDatabase.open(self, databases)
>   File "/usr/local/zope/2.9.3/lib/python/ZODB/config.py", line 105, in open
> databases=databases)
>   File "/usr/local/zope/2.9.3/lib/python/ZODB/DB.py", line 262, in __init__
> raise ValueError("database_name %r already in databases" %
>ValueError: database_name 'packed' already in databases

You see here the new (ZODB 3.6) multi-database support.

   Something tries to ad the database "packed" to a
   multi-database that already contains a "packed".

This might happen when you mount the same storage at different places
into your hierarchy.



-- 
Dieter
___
Zope-Dev maillist  -  Zope-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope )

[Zope-dev] Database mounting problem in 2.9.3?

2006-06-23 Thread Chris Withers 

Hi All,

Get this error on startup with one project I've just moved to Zope 2.9.3:

  File "/usr/local/zope/2.9.3/lib/python/Zope2/Startup/datatypes.py", 
line 175, in createDB

return ZODBDatabase.open(self, databases)
  File "/usr/local/zope/2.9.3/lib/python/ZODB/config.py", line 105, in open
databases=databases)
  File "/usr/local/zope/2.9.3/lib/python/ZODB/DB.py", line 262, in __init__
raise ValueError("database_name %r already in databases" %
ValueError: database_name 'packed' already in databases

I still seem to be able to access stuff in this database just fine so I 
don't know what's going on...


Any ideas greatfully received...

cheers,

Chris

--
Simplistix - Content Management, Zope & Python Consulting
   - http://www.simplistix.co.uk
___
Zope-Dev maillist  -  Zope-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
http://mail.zope.org/mailman/listinfo/zope-announce

http://mail.zope.org/mailman/listinfo/zope )

[Zope-dev] Database Cursors and Gargabe collection ?

2002-09-08 Thread Romain Slootmaekers 

Yo,

we have a problem using garbage collection to clean up open database 
cursors. Our approach is really simple, but doesn't work. :(

we have a method( on a SimpleItem object) getCursor:

def getCursor(self):
 """
 doc
 """
 if not hasattr(self,'_v_cursor'):
 from MySQLdb import connect,escape_string
 db=connect(...)
 cursor=db.cursor()
 self._v_cursor=CursorWrapper(cursor)
 cursor=self._v_cursor.getCursor()
 return cursor

the cursorwrapper is a class that closes the cursor on GC.

class CursorWrapper:
 def __init__(self,cursor):
 print "created"
 self.__cursor=cursor

 def getCursor(self):
 print "given out"
 return self.__cursor

 def __del__(self):
 self.__cursor.close()
 del self.__cursor
 print "deleted"

So in theory, the cursor will be closed on GC.

In practice however, we get multiple 'created' a lot of 'given out' but 
no 'deleted' messages in the cucu debugging.

After searching the web/zope site the only related thing we could find 
was a quote from Jim: "old objects don't die, they just fade away'
not very useful.

So the questions are:
1) why doesn't the __del__ get called on our wrapper ?
2) do we have to resort to closing and opening database cursors every 
single time we access the RDB ?


TIA,

Sloot.


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )

[Zope-dev] Database pack error.

2001-11-20 Thread Terry Kerr 

Hi,

I posted to [EMAIL PROTECTED] regarding this error with no useful reponse.

I am running Zope-2.4.1 on linux with python2.1.1.  Whenever I try to
pack the database I get:

Error Type: FileStorageError
Error Value: The database has already been packed to a later time or no
changes have been
 made since the last pack

traceback (innermost last):
  File /home/zope/Zope-2.4.1-src/lib/python/ZPublisher/Publish.py, line
223, in publish_module
  File /home/zope/Zope-2.4.1-src/lib/python/ZPublisher/Publish.py, line
187, in publish
  File /home/zope/Zope-2.4.1-src/lib/python/Zope/__init__.py, line 226,
in zpublisher_exception_hook
(Object: Fake)
  File /home/zope/Zope-2.4.1-src/lib/python/ZPublisher/Publish.py, line
171, in publish
  File /home/zope/Zope-2.4.1-src/lib/python/ZPublisher/mapply.py, line
160, in mapply
(Object: manage_pack)
  File /home/zope/Zope-2.4.1-src/lib/python/ZPublisher/Publish.py, line
112, in call_object
(Object: manage_pack)
  File /home/zope/Zope-2.4.1-src/lib/python/App/ApplicationManager.py,
line 419, in manage_pack
(Object: LockableItem)
  File /home/zope/Zope-2.4.1-src/lib/python/ZODB/DB.py, line 535, in
pack
  File /home/zope/Zope/lib/python/ZODB/FileStorage.py, line 1240, in
pack
(Object: /home/zope/instance/var/Data.fs)
FileStorageError: (see above)

I have tried making changes to the database, setting the system clock
forward several years, and it made no difference.  I also commented out
the redundancy check at line 1240 in FileStorage.py and tried the pack. 
In that case, it was seemingly successfull, except that the DB size
didn't reduce.

Any ideas on how my DB was corrupted and how I can fix it?

(I am happy to provide the 1.5gig Data.fs if that would help ;-) )


terry

-- 
Terry Kerr ([EMAIL PROTECTED])
Chief Technical Officer
Adroit Internet Solutions (www.adroit.net)
Phone: +61 3 9563 4461
Fax: +61 3 9563 3856
ICQ: 79303381

___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )

[Zope-dev] Database Authentication Problem

2001-10-04 Thread Andre Schubert 

Hi,

a have amysterious problem with my database-adapters.
The problem is that sometimes all my database-adapters couldn't connect
to my database.
after a zope-restart everything works fine.
I use Zope-2.2.5
Immunix Redhat 6.2
PostgreSQL 7.1.3
ZopeDA's are ZPygreSQL and ZPsycopg.

If the error happens then all Database-connections are closed.
No error in the stupid-log.
The postgres log say's - Password authentication failed for user 'foo' -
for every ZopeDA.

Could anyone help me ?
Is there a bug which is fixed in a later version of Zope ?

thanks as

___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )

RE: [Zope-dev] Database indexing using Z Catalogs

2001-04-12 Thread Loren Stafford 

http://www.zope.org/Members/rbickers/cataloganything

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> Of Honey George
> Sent: Thursday, April 12, 2001 00:46
> To: [EMAIL PROTECTED]
> Subject: [Zope-dev] Database indexing using Z Catalogs
> 
> 
> Hello,
>   I am not able to find a way to index and external
> database say PostgreSQL using Z Catalogs and search
> the contents. Can anybody help me in this. I couldn't
> find a complete documentation in the zope site. It
> will be helpfull to me if somebody can explain to me
> using an example.
> 
> Regards,
>Honey
> 
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> 
> ___
> Zope-Dev maillist  -  [EMAIL PROTECTED]
> http://lists.zope.org/mailman/listinfo/zope-dev
> **  No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope )
> 

___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )

[Zope-dev] Database indexing using Z Catalogs

2001-04-12 Thread Honey George 

Hello,
I am not able to find a way to index and external
database say PostgreSQL using Z Catalogs and search
the contents. Can anybody help me in this. I couldn't
find a complete documentation in the zope site. It
will be helpfull to me if somebody can explain to me
using an example.

Regards,
   Honey

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )