[Bug 277598] databases/mysql81-server: failed to start after pkg install

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

            Bug ID: 277598
           Summary: databases/mysql81-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

Hi,

after `pkg install mysql81-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.

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