Re: [Zope] Zope database file grows when no one is modifying it

2007-10-19 Thread Jamie O'Keefe
Thank you Andreas and Martijn, I checked the root undo log and that pointed me to to the problem. It proved to be spammers on one of our under used public boards. Problem solved for now. Any suggestions as to how to thwart such attempts besides requiring user accounts for even the most minor

[Zope] Zope database file grows when no one is modifying it

2007-10-18 Thread Jamie O'Keefe
I am administering a Zope/CMF site running Zope 2.6.4 with python 2.2.3. We have been running low on space and have not been able to clean out the database of old edits. We are moving other sites over to a new server and were able to free up about 3GB. Unfortunately, our main Zope site has

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Jamie O'Keefe
On 4/6/06, Charlie Clark [EMAIL PROTECTED] wrote: This still should not be causing this problem. Jamie, you should be talking to the DBA or looking at the DB side of things. Well it is a volunteer operation, so we don't specifically have a dba, but will talk with the person who set up the db.

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Jamie O'Keefe
Hi Dieter, We switched to Postgres, MySQL is used only for legacy components. Isn't postgres linux only? We use FreeBSD. Jamie ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Jamie O'Keefe
Thanks for the suggestions, Charlie. Will try as you suggested. Jamie On 4/6/06, Charlie Clark [EMAIL PROTECTED] wrote: On 2006-04-06 at 16:34:01 [+0200], Jamie O'Keefe [EMAIL PROTECTED] wrote: On 4/6/06, Charlie Clark [EMAIL PROTECTED] wrote: This still should not be causing

Re: [Zope-DB] mysql / zope db connection issue

2006-04-05 Thread Jamie O'Keefe
Hi Chris On 4/5/06, Chris Withers [EMAIL PROTECTED] wrote: Jamie O'Keefe wrote: try: result = context.updatePerson(**query_args) return text except Exception: This is insane code. If you want to get mailed errors, look at the MailingLogger product. Did. What if you don't know

Re: [Zope-DB] mysql / zope db connection issue

2006-04-05 Thread Jamie O'Keefe
Hi Dieter, On 4/5/06, Dieter Maurer [EMAIL PROTECTED] wrote: Jamie O'Keefe wrote at 2006-4-5 01:32 -0400: I have written a series of zope pages for a person to update their record in our mysql database. They use a zpt-python-db sql-db driver-db flow and work pretty well. Unfortunately

Re: [Zope-DB] mysql / zope db connection issue

2006-04-05 Thread Jamie O'Keefe
What version of Zope/MySQL/mysqldb/ZMySQLDA are you using? Zope is 2.6.4 MySql is 3.22.32 ZMySQLDA 2.0.8 i don't know the version of mysqldb. I think this is 0.9. Jamie ___ Zope-DB mailing list Zope-DB@zope.org

[Zope-DB] mysql / zope db connection issue

2006-04-04 Thread Jamie O'Keefe
Hi, I have written a series of zope pages for a person to update their record in our mysql database. They use a zpt-python-db sql-db driver-db flow and work pretty well. Unfortunately, if enough people use it, the number of open db connections grows until it hits a limit and the db stops

[Zope] Re: DateTime().Time() gets Insufficient Privileges error, why?

2005-12-29 Thread Jamie O'Keefe
Nevermind. I later found that I could not call HTTPConnection from my python script in Zope and ended up going straight to running it in python 2.3. Jamie On 12/28/05, Jamie O'Keefe [EMAIL PROTECTED] wrote: I am trying to get the latest time in a Python Script. I declare: from

[Zope] Re: DateTime().Time() gets Insufficient Privileges error, why?

2005-12-29 Thread Jamie O'Keefe
Thanks Andreas and Jens for the helpful tip. Jamie ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce

[Zope] DateTime().Time() gets Insufficient Privileges error, why?

2005-12-28 Thread Jamie O'Keefe
I am trying to get the latest time in a Python Script. I declare: from DateTime.DateTime import DateTime But when I run: t = DateTime().latestTime() or t = DateTime().Time() I always get an Insufficient Privileges error. I have combed through the archives and the web and as far as