Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MariaDB status should use systemd 'systemctl status'

Discussion in 'Database Discussion' started by marcuszan, Jun 20, 2019.

  1. marcuszan

    marcuszan Well-Known Member

    Joined:
    Apr 19, 2018
    Messages:
    54
    Likes Received:
    4
    Trophy Points:
    8
    Location:
    Netherlands
    cPanel Access Level:
    Root Administrator
    Hi,

    I am running a CentOS 7.6 server with cPanel on it. I run MariaDB 10.3
    Also I use Engintron.
    When in Engintron I check the mysql status, it gives me an arror message >
    Code:
    MariaDB is not running                                     [FAILED]
    The command to reproduce this from shell is >
    Code:
    service mysql status
    CentOS 7 has moved to systemd and 'service' is depreciated. There is some backwards compatibility, but not 100%
    The command that does work would be
    Code:
    systemctl status mysql
    SO my question is. Is Engintron executing a cPanel script that uses the old code or do they use their own script that uses the old CentOS 6 but NOT CentOS 7 compatible code?

    I am aware I should also take this to Engintron support. I created an issue on github but I am not able yet to find a solution with them.

    Thanks in advance
     
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,484
    Likes Received:
    187
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    It's an enginetron issue. The cpa el function work correctly as you can validate by looking at the service status in whm which will show mariadb as up.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    marcuszan likes this.
  3. marcuszan

    marcuszan Well-Known Member

    Joined:
    Apr 19, 2018
    Messages:
    54
    Likes Received:
    4
    Trophy Points:
    8
    Location:
    Netherlands
    cPanel Access Level:
    Root Administrator
  4. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,484
    Likes Received:
    187
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    I don't really know how to advise you. The guy in the thread is simply mistaken. On any Centos 7 server, service mysql status will return as not running even when it is. Service is not just an alias to systemctl, they are different commands.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    marcuszan likes this.
  5. marcuszan

    marcuszan Well-Known Member

    Joined:
    Apr 19, 2018
    Messages:
    54
    Likes Received:
    4
    Trophy Points:
    8
    Location:
    Netherlands
    cPanel Access Level:
    Root Administrator
    @GOT , thanks for your feedback. I will have to try to find some docs on this to show him. Right now there seems to be some miscommunication. If someone cares to reply on GitHub in some technical correct language that might convince him it would be great.
    Thanks a lot for the feedback so far
     
  6. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,484
    Likes Received:
    187
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    Enginetron is not great at fixing their development issues, we stopped using it a while ago.

    I do not think there is any harm done in the fact that it is reporting MariaDB as down. Its just an info-only function and since you have other indications that are more reliable, I would just ignore it.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. marcuszan

    marcuszan Well-Known Member

    Joined:
    Apr 19, 2018
    Messages:
    54
    Likes Received:
    4
    Trophy Points:
    8
    Location:
    Netherlands
    cPanel Access Level:
    Root Administrator
    Yes, you are right about the info-only thing. As I think I now understand better how CentOS7 works regarding systemd I can accept it as an unimportant bug and leave it.
    Positive thing, I learned some stuff today ;-)

    Thanks
     
    cPanelLauren likes this.
  8. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,484
    Likes Received:
    187
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    Happy to help!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,459
    Likes Received:
    503
    Trophy Points:
    263
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    I can second @GOT's evaluation here - ultimately the gentleman in the thread is incorrect, no part of that output showed that MariaDB was disabled, furthermore on systems using Systemd it is called for to use systemctl though this does not affect whether or not the service is actually running in this case.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    marcuszan likes this.
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice