Bug 204144 - databases/percona55-server: updating port breaks ownership of /var/db/mysql
Summary: databases/percona55-server: updating port breaks ownership of /var/db/mysql
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Some People
Assignee: Florian Smeets
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-10-30 11:58 UTC by Sergey Akhmatov
Modified: 2015-11-06 17:12 UTC (History)
0 users

See Also:
bugzilla: maintainer-feedback? (flo)

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 freebsd_triage 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 freebsd_triage 2015-11-06 17:12:16 UTC 
Fixed by r400946. Thanks for the report!