~/talk

SELinux Fun With MySQL and Friends

Talkat Percona Live Online 2020 · 2020-10-20..10-21· [security, databases]
speakerdeck:mcrauwel
slides:none on file

Moves MySQL data to /data/mysql fails to start until file contexts are set with semanage fcontext and applied with restorecon; changing MySQL to listen on port 3307 fails until the port is added to SELinux with semanage and then binds successfully. Generating a custom policy from audit logs with audit2allow yields a Proxysql module that permits rename create unlink and admin‑socket access; iterative permissive→audit→compile→load workflow produces a working, locked‑down system.

AI-written summary · about

  1. 0:00Intro
  2. 1:59What is SELinux?
  3. 5:31Check current SELinux status
  4. 6:14SELinux: users, policies, contexts
  5. 9:30MySQL and SELinux
  6. 10:36Custom data directory
  7. 14:23Custom port
  8. 17:30ProxySQL and SELinux
  9. 18:39ProxySQL log rotation
  10. 19:22To the audit log!
  11. 19:39Let's create a policy for that!
  12. 21:01Still not working?
  13. 21:56Final policy
  14. 22:53Great success!
  15. 23:35Best solution?
  16. 25:03Alternatives to SELinux
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.