Bug 280052 - databases/mysql84-server: failed to start after pkg install
Summary: databases/mysql84-server: failed to start after pkg install
Status: Closed DUPLICATE of bug 280456
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Only Me
Assignee: Jochen Neumeister
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-06-29 16:28 UTC by Denis Shaposhnikov
Modified: 2024-07-28 20:56 UTC (History)
3 users (show)

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

Attachments
mysql84-server.diff (1.02 KB, patch)
2024-06-29 16:28 UTC, Denis Shaposhnikov 		no flags Details | Diff
View All 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 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 ***