Date: Wed, 15 May 2013 11:54:05 GMT From: Thomas Mueller <tmueller@sysgo.com> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/178657: audio/squeezeboxserver: Start failure with mysql-server-5.0 Message-ID: <201305151154.r4FBs5D3095619@oldred.FreeBSD.org> Resent-Message-ID: <201305151200.r4FC01Jp016019@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201305151154.r4FBs5D3095619>