Bug 280052

Summary: databases/mysql84-server: failed to start after pkg install
Product: Ports & Packages Reporter: Denis Shaposhnikov <dsh>
Component: Individual Port(s)Assignee: Jochen Neumeister <joneum>
Status: Closed DUPLICATE    
Severity: Affects Only Me CC: mfburdett, samm, steve
Priority: --- Flags: bugzilla: maintainer-feedback? (joneum)
Version: Latest   
Hardware: Any   
OS: Any   
Attachments:
Description Flags
mysql84-server.diff none

Description Denis Shaposhnikov 2024-06-29 16:28:08 UTC 
Created attachment 251779 [details]
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
Comment 1 Steve Watt 2024-07-23 23:44:59 UTC 
I just ran into this as well, attempting to upgrade to mysql84-* from mysql80-*.
Comment 2 Oleksii Samorukov freebsd_committer freebsd_triage 2024-07-28 20:56:28 UTC 
Thank you for the report. Already handling in https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=280456, will be fine once merged

*** This bug has been marked as a duplicate of bug 280456 ***