Re: [Zope-DB] MySQL gone away

2007-03-20 Thread Andreas Jung
--On 20. März 2007 09:18:19 +0100 [EMAIL PROTECTED] wrote: Hello, I am getting errors in queries on a MySQL 5.027 database using zmysqlda 2.0.9b3 and mysql-python 1.2.1 with Zope 2.10.2. The errors occured the next day after setting the whole thing up and while at first it was working all ri

Re: [Zope-DB] MySQL-python and MAC OS X

2007-03-12 Thread Andreas Jung
--On 12. März 2007 14:52:34 +0100 vw393 <[EMAIL PROTECTED]> wrote: Hi all, I'm having troubles in installing MySQL-python 1.2.2 on MAC OS X "troubles" means? If you have a particular problem, tell us about the problem :-) -aj pgpMTvFDmLz47.pgp Description: PGP signature _

Re: [Zope-DB] MySQL-python on solaris 10: installation problems

2007-03-08 Thread Charlie Clark
Am 08.03.2007, 10:23 Uhr, schrieb Comunian Alessandro <[EMAIL PROTECTED]>: I think that maybe the problem is that MySQL is compiled whith a compiler different than gcc... and the problem could be solved installing MySQL from sources, but I not yet been able to do it. Somebody have some sugg

Re: [Zope-DB] MySql connectivity on Windows - state of the art

2006-06-22 Thread Charlie Clark
On 2006-06-23 at 00:21:32 [+0200], Adriano <[EMAIL PROTECTED]> wrote: > Hello people, > > I'm going to ask a simple question, I took a look at the list > archives and didn't find any clear answer to this. > > On the page at http://www.zope.org/Products/DA/ZODBCDA/ > > I see a software for conne

Re: [Zope-DB] MySql connectivity on Windows - state of the art

2006-06-22 Thread Andreas Jung
--On 23. Juni 2006 00:21:32 +0200 Adriano <[EMAIL PROTECTED]> wrote: Hello people, I'm going to ask a simple question, I took a look at the list archives and didn't find any clear answer to this. On the page at http://www.zope.org/Products/DA/ZODBCDA/ I see a software for connecting Zope t

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

2006-04-07 Thread Dieter Maurer
Andreas Jung wrote at 2006-4-6 20:52 +0200: >>[Dieter] >>> We switched to Postgres, MySQL is used only for legacy components. > >Huh...google will tell you that it runs even on Windows. I probably should have written: we currently use MySQL only for remaining legacy components. I did not want to s

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

2006-04-06 Thread Andreas Jung
--On 6. April 2006 21:51:05 +0200 Charlie Clark <[EMAIL PROTECTED]> wrote: On 2006-04-06 at 20:46:36 [+0200], Jamie O'Keefe <[EMAIL PROTECTED]> wrote: Hi Dieter, > We switched to Postgres, MySQL is used only for legacy components. Isn't postgres linux only? We use FreeBSD. PostgreSQL w

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

2006-04-06 Thread Charlie Clark
On 2006-04-06 at 20:46:36 [+0200], Jamie O'Keefe <[EMAIL PROTECTED]> wrote: > Hi Dieter, > > > We switched to Postgres, MySQL is used only for legacy components. > > Isn't postgres linux only? We use FreeBSD. PostgreSQL was developed at the University of California, Berkeley and runs on a hu

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

2006-04-06 Thread Andreas Jung
--On 6. April 2006 14:46:36 -0400 Jamie O'Keefe <[EMAIL PROTECTED]> wrote: Hi Dieter, We switched to Postgres, MySQL is used only for legacy components. Huh...google will tell you that it runs even on Windows. -aj --

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 causi

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 Dieter Maurer
Jamie O'Keefe wrote at 2006-4-5 13:54 -0400: > ... >What version of MySQL are you using? An old one... We switched to Postgres, MySQL is used only for legacy components. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/

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

2006-04-06 Thread Charlie Clark
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 this problem. Jamie, you should be > > talking > > to the DBA or looking at the DB side of things. > > Well it is a volunteer op

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 Charlie Clark
On 2006-04-06 at 09:51:49 [+0200], Chris Withers <[EMAIL PROTECTED]> wrote: > >>> Exception TypeDatabase Error > >>> Exception Value updatePerson is not connected to a database > >> What version of Zope/MySQL/mysqldb/ZMySQLDA are you using? > > > > Zope is 2.6.4 > > Good grief. Up

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

2006-04-06 Thread Chris Withers
Jamie O'Keefe wrote: 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 k

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 http://mail.zope.org/mailm

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. > > > >

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

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

2006-04-05 Thread Dieter Maurer
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, if enough people use it, the number of open db >connections g

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

2006-04-05 Thread Charlie Clark
On 2006-04-05 at 07:32:46 [+0200], Jamie O'Keefe <[EMAIL PROTECTED]> wrote: > 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 peop

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

2006-04-05 Thread Chris Withers
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. The traceback error is: Exception Type Database Error Exception Value updatePe

Re: [Zope-DB] MySQL connection

2005-12-22 Thread Andreas Jung
# --On 22. Dezember 2005 10:06:11 +0100 Fabio <[EMAIL PROTECTED]> wrote: Hi! I need to create a new database MySQL (and a new Z MySQL Database Connection) at user login. Can I create a new Z MySQL Database Connection dynamically in python? How? How can I bind new Z MySQL Database Connection

Re: [Zope-DB] MySQL

2005-10-21 Thread Chris Withers
Dario Antonelli wrote: Grazie michele, When I try to execute MySQL-python.exe-1.2.0.win32-py2.4.exe I receive a message Box saying: "...MSVCR71.dll not found" Zope doesn't run with Python 2.4, try downloading the right file ;-) The nasty bit of the dance is that to use the windows installers f

Re: [Zope-DB] MySQL

2005-10-21 Thread Michele Marcionelli
When I try to execute MySQL-python.exe-1.2.0.win32-py2.4.exe I receive a message Box saying: "...MSVCR71.dll not found" (I receive a message in italian..) Thanks Dario I'm sorry, but I don't live in the Windows world... With a quick google-search I found: ".NET Framework SDK Version 1.1:

Re: [Zope-DB] MySQL

2005-10-21 Thread Michele Marcionelli
Ciao Dario, I want to use MySQL in my Zope Installation. But I'm not able to install software (I don't really understand what shall I use and what shall I do...) I'm using Zope: 2.8.1 MySQL 4.1 Windows XP You have to install "MySQL for Python": http://sourceforge.net/projects/mysql-pyt

Re: [Zope-DB] ... MySql connection pooling

2005-08-18 Thread Michele Marcionelli
Salut Sébastien, For performance reasons, I want to use connection pooling. It seems that Zmsqlda/mysqldb implements this I don't know what do you mean with "connection pooling". But... (in somme circumstances mysqladmin processlist shows multiple connections). ... I had also the problem t

Re: [Zope-DB] ... MySql connection pooling

2005-08-18 Thread Andreas Jung
--On 18. August 2005 18:39:29 +0200 [EMAIL PROTECTED] wrote: Bonjour, I'm new to zope/mysql. I succedeed in installing Zmsqlda/mysqldb (tested a "Z SQL method" referencing a "Z Mysql Database connection"). For performance reasons, I want to use connection pooling. It seems that Zmsqlda/mysql

Re: [Zope-DB] MySQL ZSQL Transactions or Commit in Zope?

2005-05-17 Thread Dieter Maurer
Michael Schwartz wrote at 2005-5-15 16:30 -0400: >I am trying to find sample code for performing transactions in ZSQL with >mysql 4.1. I'd like to do something like this: > >1 - Insert record A into USER table >2 - Get auto_increment id for record A >3 - Insert record B into WIDGET table with aut