Bug 204144

Summary:	databases/percona55-server: updating port breaks ownership of /var/db/mysql
Product:	Ports & Packages	Reporter:	Sergey Akhmatov <sergey>
Component:	Individual Port(s)	Assignee:	Florian Smeets <flo>
Status:	Closed FIXED
Severity:	Affects Some People	Flags:	bugzilla: maintainer-feedback? (flo)
Priority:	---
Version:	Latest
Hardware:	Any
OS:	Any

Description Sergey Akhmatov 2015-10-30 11:58:22 UTC

On inital install /var/db/mysql is created owned by root:wheel
Directory ownership is changed by rc.d/mysql-server script in 'mysql_create_auth_tables' procedure on first startup.

When I reinstall port, e.g. for updating, /var/db/mysql ownership is changed to root:wheel
rc-script no longer changes directory owner because it's already populated with system tables.

SQL-server can't start until manual chown for /var/db/mysql

Comment 1 commit-hook freebsd_committer

2015-11-06 17:10:54 UTC

A commit references this bug:

Author: flo
Date: Fri Nov  6 17:10:18 UTC 2015
New revision: 400946
URL: https://svnweb.freebsd.org/changeset/ports/400946

Log:
  - update to 5.5.46-37.5
  - fix permission on db dir [1]

  PR:		204144 [1]
  Reported by:	<sergey@akhmatov.ru> [1]

Changes:
  head/databases/percona55-client/files/patch-CMakeLists.txt
  head/databases/percona55-server/Makefile
  head/databases/percona55-server/distinfo
  head/databases/percona55-server/pkg-plist

Comment 2 Florian Smeets freebsd_committer

2015-11-06 17:12:16 UTC

Fixed by r400946. Thanks for the report!