CentOS 7.9 | MariaDB 10.5 not using default my.cnf and status inside panel also stopped

[hassaan-dev]

Operating System (OS/VERSION):

CentOS 7.9

VestaCP Version:

Version: 1.0.0 (x86_64) Release: 6

Installed Software (what you got with the installer):

MariaDB status in panel is stopped but its running when check via terminal but default my.cnf not being used

Screenshot of VestaCP Panel

https://filehush.com/muR2Tx_c97lN6Lp

Terminal Output

[root@s22002 ~]# service mariadb status
Redirecting to /bin/systemctl status mariadb.service
● mariadb.service - MariaDB 10.5.17 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: active (running) since Fri 2022-09-02 18:36:49 EDT; 14min ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 986 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 861 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: 824 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 953 (mariadbd)
   Status: "Taking your SQL requests now..."
   CGroup: /system.slice/mariadb.service
           └─953 /usr/sbin/mariadbd

Sep 02 18:36:49 s22002 mariadbd[953]: 2022-09-02 18:36:49 0 [Note] InnoDB: 10.5.17 started; log sequence number 102057; transaction id 126
Sep 02 18:36:49 s22002 mariadbd[953]: 2022-09-02 18:36:49 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Sep 02 18:36:49 s22002 mariadbd[953]: 2022-09-02 18:36:49 0 [Note] Plugin 'FEEDBACK' is disabled.
Sep 02 18:36:49 s22002 mariadbd[953]: 2022-09-02 18:36:49 0 [Note] Server socket created on IP: '::'.
Sep 02 18:36:49 s22002 mariadbd[953]: 2022-09-02 18:36:49 0 [Note] InnoDB: Buffer pool(s) load completed at 220902 18:36:49
Sep 02 18:36:49 s22002 mariadbd[953]: 2022-09-02 18:36:49 0 [Note] Reading of all Master_info entries succeeded
Sep 02 18:36:49 s22002 mariadbd[953]: 2022-09-02 18:36:49 0 [Note] Added new Master_info '' to hash table
Sep 02 18:36:49 s22002 mariadbd[953]: 2022-09-02 18:36:49 0 [Note] /usr/sbin/mariadbd: ready for connections.
Sep 02 18:36:49 s22002 mariadbd[953]: Version: '10.5.17-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
Sep 02 18:36:49 s22002 systemd[1]: Started MariaDB 10.5.17 database server.

Steps to Reproduce:

I have installed fresh OS. Before install vestacp, I created MariaDB 10.5 repo so that should be installed by default when vestacp's installer run

I put the following line inside nano /etc/yum.repos.d/mariadb.repo

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.5/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

After that I simple run VestaCP Setup with following command

bash vst-install.sh --nginx yes --apache yes --phpfpm no --named yes --remi yes --vsftpd yes --proftpd no --iptables yes --fail2ban yes --quota no --exim no --dovecot no --spamassassin no --clamav no --softaculous no --mysql yes --postgresql no --force

[hassaan-dev]

No update in 2 days :(

[anton-reutov]

I will check it on our test server tomorrow.

[hassaan-dev]

Is this bug is confirmed? Actually I want to reinstall OS on my server which should work fine with VestaCP

I am not doing it just because, may you need some other information from my end or may be the solution you want me to try out to fix this issue

[anton-reutov]

this repo is not working for me. can you reinstall CentOS, and provide access to your server? after reinstalling , please enable mariadb repo. credentials you can send to [email protected]

[hassaan-dev]

this repo is not working for me. can you reinstall CentOS, and provide access to your server? after reinstalling , please enable mariadb repo. credentials you can send to [email protected]

Email has been sent, can you confirm you have received the email?

[hassaan-dev]

@anton-reutov do you get time to access the my server? Is there any update?

[anton-reutov]

i need to a few days, waiting to my reply here

[hassaan-dev]

@anton-reutov I waited for days but sorry, I need to use this server so I am reinstalling OS that fully functional with vestacp. I hope you fix this issue soon and update here

[anton-reutov]

i'm not received email with credentials from you. Can you send again to [email protected]

[hassaan-dev]

I am surprised to see this update after many days from your side, I sent that email on 5th September. Email Screenshot

BTW as I mentioned in my last comment, I have reinstall OS and now this server is being used as production now. I try to get another server

[jaapmarcus]

By default 10.5 run as mariadb service instead of mysqld

https://github.com/hestiacp/hestiacp/blob/54704ee77332bfc56a23b420bc6de54a8e58c8ff/bin/v-list-sys-services#L232-L274

You might need to verify if is correct