From owner-freebsd-ports-bugs@FreeBSD.ORG Wed May 15 12:00:01 2013 Return-Path: Delivered-To: freebsd-ports-bugs@smarthost.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.FreeBSD.org [8.8.178.115]) by hub.freebsd.org (Postfix) with ESMTP id B2DD7516 for ; Wed, 15 May 2013 12:00:01 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:1900:2254:206c::16:87]) by mx1.freebsd.org (Postfix) with ESMTP id 99EBA6BA for ; Wed, 15 May 2013 12:00:01 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.7/8.14.7) with ESMTP id r4FC0161016025 for ; Wed, 15 May 2013 12:00:01 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.7/8.14.7/Submit) id r4FC01Jp016019; Wed, 15 May 2013 12:00:01 GMT (envelope-from gnats) Resent-Date: Wed, 15 May 2013 12:00:01 GMT Resent-Message-Id: <201305151200.r4FC01Jp016019@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Thomas Mueller Received: from mx1.freebsd.org (mx1.FreeBSD.org [8.8.178.115]) by hub.freebsd.org (Postfix) with ESMTP id 63A3647A for ; Wed, 15 May 2013 11:54:06 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from oldred.FreeBSD.org (oldred.freebsd.org [8.8.178.121]) by mx1.freebsd.org (Postfix) with ESMTP id 3D7F967E for ; Wed, 15 May 2013 11:54:06 +0000 (UTC) Received: from oldred.FreeBSD.org ([127.0.1.6]) by oldred.FreeBSD.org (8.14.5/8.14.5) with ESMTP id r4FBs5ov095620 for ; Wed, 15 May 2013 11:54:05 GMT (envelope-from nobody@oldred.FreeBSD.org) Received: (from nobody@localhost) by oldred.FreeBSD.org (8.14.5/8.14.5/Submit) id r4FBs5D3095619; Wed, 15 May 2013 11:54:05 GMT (envelope-from nobody) Message-Id: <201305151154.r4FBs5D3095619@oldred.FreeBSD.org> Date: Wed, 15 May 2013 11:54:05 GMT From: Thomas Mueller To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Subject: ports/178657: audio/squeezeboxserver: Start failure with mysql-server-5.0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 15 May 2013 12:00:01 -0000 >Number: 178657 >Category: ports >Synopsis: audio/squeezeboxserver: Start failure with mysql-server-5.0 >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Wed May 15 12:00:00 UTC 2013 >Closed-Date: >Last-Modified: >Originator: Thomas Mueller >Release: 9.1-STABLE amd64 >Organization: >Environment: FreeBSD tmu 9.1-STABLE FreeBSD 9.1-STABLE #51: Mon Apr 22 16:35:08 CEST 2013 toor@tmu:/usr/obj/usr/src/sys/TOM amd64 >Description: The most recent version of squeezeboxserver (7.5.4_6) fails to start with mysql-server-5.0 due to an unsupported MySQL configuration variable. Variable 'table_open_cache' was known as table_cache in MySQL 5.1.2 and earlier, so replacing 'table_cache' with 'table_open_cache' in the port's Makefile should depend on the MySQL version in use. >How-To-Repeat: tmu:~# pkg_info | grep -e squeezeboxserver -e mysql-serv mysql-server-5.0.95 Multithreaded SQL database (server) squeezeboxserver-7.5.4_6 Slim Devices audio streaming server tmu:~# /usr/local/etc/rc.d/squeezeboxserver start Starting squeezeboxserver. [13-05-15 13:43:39.5303] main::init (326) Starting Squeezebox Server (v7.5.4, r32171, Thu Apr 14 10:19:04 MDT 2011) perl 5.014002 130515 13:43:39 [ERROR] /usr/local/libexec/mysqld: unknown variable 'table_open_cache=64' >Fix: My ports foo is limited, but this appears to work: tmu:/usr/ports/audio/squeezeboxserver# diff -u Makefile.orig Makefile --- Makefile.orig 2013-05-15 13:50:46.454763932 +0200 +++ Makefile 2013-05-15 13:50:39.069763074 +0200 @@ -174,12 +174,16 @@ -e 's|%%TMP_SLIMDIR%%|${TMP_SLIMDIR}|g' \ ${WRKSRC}/scanner.pl \ ${WRKSRC}/slimserver.pl - ${REINPLACE_CMD} \ + @${REINPLACE_CMD} \ -e 's/skip-locking/skip-external-locking/' \ -e 's/default-character-set/character-set-server/'\ - -e 's/table_cache/table_open_cache/'\ -e 's/default-collation/collation-server/' ${WRKSRC}/MySQL/my.tt - ${REINPLACE_CMD} \ +# table_open_cache was known as table_cache in MySQL 5.1.2 and earlier + @if [ "$(MYSQL_VER)" != "50" ] ; then \ + ${REINPLACE_CMD} \ + -e 's/table_cache/table_open_cache/' ${WRKSRC}/MySQL/my.tt ;\ + fi + @${REINPLACE_CMD} \ -e 's/TYPE=InnoDB/ENGINE=InnoDB/' ${WRKSRC}/SQL/mysql/schema_*.sql do-build: >Release-Note: >Audit-Trail: >Unformatted: