[SOLVED] Proxmox Debian 10 Buster Template and mariadb

yarii

Renowned Member
Mar 24, 2014
141
7
83
I don't know is this a good place to post a bug:

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

Code:
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 ---
Code:
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?
 
Ok - If You use unprivileged type of LXC, You need to set Feature: Nesting=1 from GUI for mysql or completly disable apparmor.
Solved.
 
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?
 
Last edited:
Look inside the features in LXC Options - see attached screenshot
 

Attachments

  • features.png
    features.png
    147 KB · Views: 55
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?
 

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!