#include <tunables/global>

# MariaDB server. Runs as the mysql user.
# Binds only veth (bind-address 10.200.2.1 in /etc/rc.d/rc.mysqld)
profile mariadbd /usr/libexec/mariadbd flags=(attach_disconnected) {
  #include <abstractions/base>

  # Dropped dac_override. The mysql user owns the data dirs.
  capability chown,
  capability fowner,
  capability fsetid,
  capability kill,
  capability setgid,
  capability setuid,

  # Dropped inet6 and unix dgram (netns is IPv4 only)
  network inet stream,
  network unix stream,

  /usr/libexec/mariadbd mr,
  /lib64/ld-linux-x86-64.so.2 mr,
  /lib64/libaio.so.1* mr,
  /lib64/libbz2.so.1* mr,
  /lib64/libc.so.6 mr,
  /lib64/libcrypt.so.2* mr,
  /lib64/libcrypto.so.3 mr,
  /lib64/liblzma.so.5* mr,
  /lib64/libm.so.6 mr,
  /lib64/libnss_compat.so.2 mr,
  /lib64/libpcre2-8.so.0* mr,
  /lib64/libssl.so.3 mr,
  /lib64/libz.so.1* mr,
  /usr/lib64/libgcc_s.so.1 mr,
  /usr/lib64/liblz4.so.1* mr,
  /usr/lib64/liblzo2.so.2* mr,
  /usr/lib64/libstdc++.so.6* mr,
  /usr/lib64/liburing.so.2* mr,
  /usr/lib64/mysql/plugin/** mr,
  /etc/ld.so.cache r,

  # Configs
  /etc/my.cnf r,
  /etc/my.cnf.d/ r,
  /etc/my.cnf.d/** r,
  /etc/default/mariadb r,

  # Data and runtime directories
  /var/lib/mysql/ rw,
  /var/lib/mysql/** rwk,
  /run/mysql/ rw,
  /run/mysql/** rwk,

  # Restrict /tmp access.
  # Allow read/write, but explicitly deny mmap/execution.
  /tmp/ rw,
  /tmp/mysql* rwk,
  /tmp/#sql* rwk,
  deny /tmp/** m, 
  deny /tmp/** x,

  /dev/null rw,
  /dev/urandom r,
  /dev/random r,
  /dev/zero r,

  /proc/self/** r,
  /proc/meminfo r,

  # --- Explicit Denials ---
  
  # 1. Blanket denial: MariaDB should never execute ANY external binary.
  # (If you use myisamchk for auto-repair, you may need to explicitly allow it).
  deny /** x,

  # 2. Sensitive files
  deny /etc/shadow r,
  deny /etc/gshadow r,
  deny /etc/ssh/** r,
  deny /root/** r,
  deny /home/** rw,

  # 3. System writes
  deny /bin/**   w,
  deny /sbin/**  w,
  deny /lib/**   w,
  deny /lib64/** w,
  deny /usr/**   w,
  deny /etc/**   w,
  deny /boot/**  w,
  deny /root/**  w,

  # 4. Dangerous capabilities
  deny capability sys_admin,
  deny capability sys_module,
  deny capability sys_rawio,
  deny capability sys_boot,
  deny capability sys_ptrace,
  deny capability mac_admin,
  deny capability mac_override,
}