Marinodb not Starting

[infolloyd]

Hi

After config.d update marinodb not starting , Please help me to overcome this issue

mysqld: Can’t read dir of ‘/etc/mysql/conf.d/’ (Errcode: 2 “No such file or directory”)

[richardevcom]

Error explains what’s the issue: you’re missing /etc/mysql/conf.d dir OR it has no permission to read it.

[infolloyd]

i have created config.d file, database not starting?

systemctl start mariadb.service

** (pkttyagent:13212): WARNING **: 05:56:32.647: Unable to register authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject
Error registering authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject (polkit-error-quark, 0)

[richardevcom]

It is a file, that’s the issue. You need to create dir. mkdir /etc/mysql/conf.d/

[josephgodwinke]

Look at this and see if it helps

High CPU Usage, 4CPU 8GB RAM

Now to address this cancerous component issue that craps a systemd service out: Unable to register authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject Run the commands line by line: # add user to the group $ groupadd -g 23 nohidproc $ usermod -a -G nohidproc polkitd $ mount -o remount,rw,hidepid=2,gid=nohidproc /proc $ systemctl restart polkit # nano /etc/fstab or run it directly $ echo "proc /proc proc defaults,hidepid=2,gid=nohidproc 0 …

[infolloyd]

this issue was happened after cyberporson databast optimize tool. Cnf file tweak



● mariadb.service - MariaDB 10.4.26 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Sun 2022-11-06 20:02:18 CET; 56s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 3189 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 3174 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 3172 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 3189 (code=exited, status=1/FAILURE)

[josephgodwinke]

Check this out MariaDB / MySQL Tweaks As Default & Option

Basically run nano /etc/my.cnf use the keyboard shortcut CTRL+W to search for skip-name-resolve and comment it out. Restart mariadb systemctl restart mysqld