From owner-freebsd-ports@FreeBSD.ORG  Fri May 18 17:18:33 2007
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
X-Original-To: freebsd-ports@freebsd.org
Delivered-To: freebsd-ports@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 2186316A405
	for <freebsd-ports@freebsd.org>; Fri, 18 May 2007 17:18:33 +0000 (UTC)
	(envelope-from swhetzel@gmail.com)
Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.241])
	by mx1.freebsd.org (Postfix) with ESMTP id C3E8F13C45E
	for <freebsd-ports@freebsd.org>; Fri, 18 May 2007 17:18:32 +0000 (UTC)
	(envelope-from swhetzel@gmail.com)
Received: by an-out-0708.google.com with SMTP id d23so240025and
	for <freebsd-ports@freebsd.org>; Fri, 18 May 2007 10:18:32 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=kOi7RN0LhejyY0ZKOzxCTkrQjsAV/M8oWiSVTB0A3Ed5kJvpactSW067Gv0gCO7x3ke2kXY6JEoXjK5xbOYOeqk/mCLyVt/2XgL5HH0AxhTv0cmk88aTXa0jZHxC/Ip2fkD6OB9WJZmNYa3HpshaXGnz7kW72fY1PnVrvQJud8M=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=UQElJ+g/bcZrg/0awVCj/H10Lxq96BbmDC2B3PFiUgdw7VP4y3tIS5jgBYBJmlxBidrdBTy4VadlsUmGlxotYpXeKIvWUULxKtYVhUHD2gQV6USLFVs/hkwBrNyBvVblVgRkLxHnD4jubvEho8fiiQWVCS8FYZvPR3Qc+gaCo/8=
Received: by 10.100.136.8 with SMTP id j8mr1289939and.1179508711289;
	Fri, 18 May 2007 10:18:31 -0700 (PDT)
Received: by 10.100.139.10 with HTTP; Fri, 18 May 2007 10:18:31 -0700 (PDT)
Message-ID: <790a9fff0705181018ya6ec0e2w1ff8a378bff97e61@mail.gmail.com>
Date: Fri, 18 May 2007 12:18:31 -0500
From: "Scot Hetzel" <swhetzel@gmail.com>
To: "David Southwell" <david@vizion2000.net>
In-Reply-To: <200705180948.20172.david@vizion2000.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <200705180948.20172.david@vizion2000.net>
Cc: freebsd-ports@freebsd.org
Subject: Re: www/trac with mysql
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.5
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: Fri, 18 May 2007 17:18:33 -0000

On 5/18/07, David Southwell <david@vizion2000.net> wrote:
> Hi
>
> How do I configure trac to use  mysql rather than sqlite??
>
You'll need to make the following changes to the ports Makefile:

1. Add `MYSQL	   "Use MySQL instead of SQLite3" Off \' to OPTIONS

2. Make the following change to the database selection code:

.if defined(WITH_PGSQL)
RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/psycopg2/__init__.py:${PORTSDIR}/databases/py-psycopg2
.elif defined(WITH_MYSQL)
RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/MySQLdb/__init__.py:${PORTSDIR}/databases/py-MySQLdb
.else
RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/pysqlite2/__init__.py:${PORTSDIR}/databases/py-pysqlite20
.endif

NOTE: the trac website says that MySQL support is experimental.

Scot
-- 
DISCLAIMER:
No electrons were mamed while sending this message. Only slightly bruised.