[Bug 280052] databases/mysql84-server: failed to start after pkg install

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=280052

            Bug ID: 280052
           Summary: databases/mysql84-server: failed to start after pkg
                    install
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: joneum@FreeBSD.org
          Reporter: dsh@bamus.cz
             Flags: maintainer-feedback?(joneum@FreeBSD.org)
          Assignee: joneum@FreeBSD.org

Created attachment 251779
  --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=251779&action=edit
mysql84-server.diff

Hi,

after `pkg install mysql84-server`, `service mysql-server start` failed to
start the server. In the log I see

mysqld: Can't create/write to file '/var/db/mysql_tmpdir/ibe7JpUJ' (OS errno 13
- Permission denied)

And I see `/var/db/mysql_tmpdir` owned by root, instead of mysql user. Looks
like the reason is pkg-plist, which has

@dir %%ETCDIR%%/keyring
@dir %%MY_SECDIR%%
@dir %%MY_TMPDIR%%

instead of

@dir(mysql,mysql,0750) %%ETCDIR%%/keyring
@dir(mysql,mysql,0750) %%MY_SECDIR%%
@dir(mysql,mysql,0750) %%MY_TMPDIR%%

like `databases/mysql80-server` has.

It's the same problem, like in
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=277598

-- 
You are receiving this mail because:
You are the assignee for the bug.