[SOLVED] Proxmox Debian 10 Buster Template and mariadb

[yarii]

I don't know is this a good place to post a bug:

I created CT with template debian-10 and then installed mariadb.

root@dev1:/var/www/html/dev/include# systemctl status mariadb.service
* mariadb.service - MariaDB 10.3.15 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset:
   Active: failed (Result: exit-code) since Sun 2019-08-04 10:00:13 UTC; 1min 10
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 10058 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/r
  Process: 10059 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_STAR
  Process: 10061 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VA
  Process: 10110 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_W
 Main PID: 10110 (code=exited, status=226/NAMESPACE)
Aug 04 10:00:12 dev1 systemd[1]: Starting MariaDB 10.3.15 database server..
Aug 04 10:00:13 dev1 systemd[1]: mariadb.service: Main process exited, code
Aug 04 10:00:13 dev1 systemd[1]: mariadb.service: Failed with result 'exit-
Aug 04 10:00:13 dev1 systemd[1]: Failed to start MariaDB 10.3.15 database s
lines 1-15/15 (END)

--- syslog ---

Aug  4 09:54:48 dev1 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Aug  4 09:54:48 dev1 systemd[1]: Failed to start MariaDB 10.3.15 database server.
Aug  4 09:54:48 dev1 systemd[1]: Reloading.
Aug  4 10:00:12 dev1 systemd[1]: Starting MariaDB 10.3.15 database server...
Aug  4 10:00:13 dev1 systemd[10110]: mariadb.service: Failed to set up mount namespacing: Permission denied
Aug  4 10:00:13 dev1 systemd[10110]: mariadb.service: Failed at step NAMESPACE spawning /usr/sbin/mysqld: Permission denied
Aug  4 10:00:13 dev1 systemd[1]: mariadb.service: Main process exited, code=exited, status=226/NAMESPACE
Aug  4 10:00:13 dev1 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Aug  4 10:00:13 dev1 systemd[1]: Failed to start MariaDB 10.3.15 database server.

How to make it running?
Is this case mariadb related, proxmox related or debian related?

 

[yarii]

Ok - If You use unprivileged type of LXC, You need to set Feature: Nesting=1 from GUI for mysql or completly disable apparmor.
Solved.

 

[yarii]

The other thing is to change open_files_limit.

You need to also set in '/etc/pve/lxc/CTID.conf'
lxc.prlimit.nofile: 100000

Maybe this option should be set from Proxmox GUI?

 

[souzahub]

Ok - If You use unprivileged type of LXC, You need to set Feature: Nesting=1 from GUI for mysql or completly disable apparmor.
Solved.

Where is this option? I can't find it.

Thank you.

 

[yarii]

Look inside the features in LXC Options - see attached screenshot

 

[souzahub]

Ok - If You use unprivileged type of LXC, You need to set Feature: Nesting=1 from GUI for mysql or completly disable apparmor.
Solved.

Where do we setup this nesting? Can you please give some hint?

 

[yarii]

Please see the attached image from earlier post.