From owner-freebsd-ports@FreeBSD.ORG  Thu Jun  3 10:31:43 2004
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
Delivered-To: freebsd-ports@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id B7F7216A4CE
	for <freebsd-ports@freebsd.org>; Thu,  3 Jun 2004 10:31:43 -0700 (PDT)
Received: from mail.cepheid.org (wintermute.cepheid.org [66.119.232.7])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 7F26743D39
	for <freebsd-ports@freebsd.org>; Thu,  3 Jun 2004 10:31:43 -0700 (PDT)
	(envelope-from jeff@cepheid.org)
Received: by mail.cepheid.org (Postfix, from userid 1000)
	id 10B596447; Thu,  3 Jun 2004 12:31:43 -0500 (CDT)
Date: Thu, 3 Jun 2004 12:31:42 -0500
From: Jeff Bachtel <jeff@cepheid.org>
To: freebsd-ports@freebsd.org
Message-ID: <20040603173142.GM46423@cepheid.org>
References: <20040531190956.G81588@ganymede.hub.org>
	<20040531223231.GA17254@i18n.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20040531223231.GA17254@i18n.org>
User-Agent: Mutt/1.4.2.1i
Sender: jeff@cepheid.org
Subject: Re: MySQL db connect after upgrade to Zope 2.7.0 ...
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 03 Jun 2004 17:31:43 -0000

This is not valid unless you are running a MySQL DB that supports
transactions (4.0 or later). If you are still running 3.23,
self.transactions should be 0.

jeff

> According to:
> http://www.google.com/search?q=cache:Oti-fgNOtvoJ:www.dzug.org/mailinglisten/zope/archive/2004/2004-04/1082980237427+AttributeError:+server_capabilities&hl=ko
> http://www.google.com/search?q=cache:Eoq-GsF17nUJ:mooya.ath.cx/CubeDeZope/1068486456/index_html+AttributeError:+server_capabilities&hl=ko
> 
> This may be working fix.
> 
> --- ZMySQLDA/db.py.orig	Tue Jun  1 07:29:02 2004
> +++ ZMySQLDA/db.py	Tue Jun  1 07:29:32 2004
> @@ -180,7 +180,7 @@
>          self.connection=connection
>          self.kwargs = kwargs = self._parse_connection_string(connection)
>          self.db=apply(self.Database_Connection, (), kwargs)
> -	self.transactions = self.db.server_capabilities & CLIENT.TRANSACTIONS
> +	self.transactions = 1
>          if self._try_transactions == '-':
>              self.transactions = 0
>          elif not self.transactions and self._try_transactions == '+':
> 
> Hye-Shik