From owner-freebsd-ports  Mon Dec  4  7:10: 5 2000
From owner-freebsd-ports@FreeBSD.ORG  Mon Dec  4 07:10:01 2000
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
Delivered-To: freebsd-ports@hub.freebsd.org
Received: from freefall.freebsd.org (freefall.FreeBSD.org [216.136.204.21])
	by hub.freebsd.org (Postfix) with ESMTP id 1BEDF37B401
	for <freebsd-ports@hub.freebsd.org>; Mon,  4 Dec 2000 07:10:01 -0800 (PST)
Received: (from gnats@localhost)
	by freefall.freebsd.org (8.11.1/8.11.1) id eB4FA1O50381;
	Mon, 4 Dec 2000 07:10:01 -0800 (PST)
	(envelope-from gnats)
Resent-Date: Mon, 4 Dec 2000 07:10:01 -0800 (PST)
Resent-Message-Id: <200012041510.eB4FA1O50381@freefall.freebsd.org>
Resent-From: gnats-admin@FreeBSD.org (GNATS Management)
Resent-To: freebsd-ports@FreeBSD.org
Resent-Reply-To: gnats-admin@FreeBSD.org, louie@TransSys.COM
Received: from whizzo.transsys.com (whizzo.TransSys.COM [144.202.42.10])
	by hub.freebsd.org (Postfix) with ESMTP
	id DD7E737B400; Mon,  4 Dec 2000 07:04:16 -0800 (PST)
Received: (from louie@localhost)
	by whizzo.transsys.com (8.11.1/8.11.0) id eB4F4G143254;
	Mon, 4 Dec 2000 10:04:16 -0500 (EST)
	(envelope-from louie)
Message-Id: <200012041504.eB4F4G143254@whizzo.transsys.com>
Date: Mon, 4 Dec 2000 10:04:16 -0500 (EST)
From: Louis Mamakos <louie@TransSys.COM>
Sender: louie@whizzo.transsys.com
Reply-To: louie@TransSys.COM
To: FreeBSD-gnats-submit@freebsd.org, dirk@freebsd.org
X-Send-Pr-Version: 3.2
Subject: ports/23266: mysql323-server port broken - can't create /var/run/mysql.sock
Resent-Sender: gnats@FreeBSD.org
Sender: owner-freebsd-ports@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.org


>Number:         23266
>Category:       ports
>Synopsis:       mysql server can't create mysql.sock in /var/run as user mysql
>Confidential:   no
>Severity:       serious
>Priority:       high
>Responsible:    freebsd-ports
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Mon Dec 04 07:10:00 PST 2000
>Closed-Date:
>Last-Modified:
>Originator:     Louis Mamakos
>Release:        FreeBSD 4.2-STABLE i386
>Organization:
>Environment:

Recent mysql323-server port, with change to move socket to /var/run/mysql.sock;
running 4.2-STABLE

>Description:

If mysqld is started as user 'mysql', it doesn't have permissions to
create a socket in /var/run.  According to /etc/mtree/BSD.var.dist,
/var/run has mode 0755 and is owned by root.

>How-To-Repeat:

Install new version of port, run standard ${DESTDIR}/etc/mysql-server.sh
script to run server as mysql user; see hostname.err file in /var/db/mysql

>Fix:

I dunno.  Short-term hack is to chmod 1777 /var/run, but this doesn't
seem like the right answer.  Previously, socket was /tmp/mysql.sock
which seemed to work.  Should safe_mysqld create socket before changing
effective user to mysql (or whatever was named?)



>Release-Note:
>Audit-Trail:
>Unformatted:


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-ports" in the body of the message