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