Welcome to Centmin Mod Community
Become a Member

MariaDB mysqlstop and mysqlstart shortcuts doesn't work

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by pamamolf, Jun 15, 2020.

  1. eva2000

    eva2000 Administrator Staff Member

    54,107
    12,179
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,739
    Local Time:
    8:50 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Yeah so it would of cleared the initial install's MariaDB journalctl logs on reboot. Guess only really way to know, is if you tried a fresh CentOS 7 reinstall and Centmin Mod 123.09beta01 install to see if you can reproduce the problem

     
  2. pamamolf

    pamamolf Premium Member Premium Member

    4,074
    427
    83
    May 31, 2014
    Ratings:
    +833
    Local Time:
    12:50 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    I tested again on a new page and it was ok .... so i am thinking to edit the:

    /usr/bin/mysqlstop/start/restart

    and replace the service command with systemctl to avoid the reinstallation

    is that ok to do for MariaDB and Centminmod ?
     
  3. eva2000

    eva2000 Administrator Staff Member

    54,107
    12,179
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,739
    Local Time:
    8:50 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yeah you can do that, probably should update 123.09beta01 to do that for cmd shortcuts
     
  4. pamamolf

    pamamolf Premium Member Premium Member

    4,074
    427
    83
    May 31, 2014
    Ratings:
    +833
    Local Time:
    12:50 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    Great !!!!

    As i mention before i think there should be a check if the system is Centos 6 to use the service command and if it is Centos 7 to use the systemctl :)

    Thank you
     
    Last edited: Jun 16, 2020
  5. pamamolf

    pamamolf Premium Member Premium Member

    4,074
    427
    83
    May 31, 2014
    Ratings:
    +833
    Local Time:
    12:50 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    Do you plan to add it in a day or two so i can wait to add it automatically using Centminmod or should i do it manually now?
     
  6. eva2000

    eva2000 Administrator Staff Member

    54,107
    12,179
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,739
    Local Time:
    8:50 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    you can do it manually now, will add it later - I don't recall why I haven't done it this way to date so will need to check
     
  7. pamamolf

    pamamolf Premium Member Premium Member

    4,074
    427
    83
    May 31, 2014
    Ratings:
    +833
    Local Time:
    12:50 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    You did that because some users like me had issues when we tried to restart Mariadb .... at least that's what i remember ....

    But now it seems to have issues (on rare cases) and the service command may not catch the systemct commands and can' find the pid file ?

    Anyway you know better but i think is better to use the default command for each operating system .

    Thank you !
     
  8. pamamolf

    pamamolf Premium Member Premium Member

    4,074
    427
    83
    May 31, 2014
    Ratings:
    +833
    Local Time:
    12:50 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    Also is it better to use:

    Code:
    systemctl stop/start/restart mysql
    or
    Code:
    systemctl stop/start/restart mariadb
    I think the service is mariadb.service and maybe the second one is better to use?

    Which one do you plan to add at Centminmod?

    Thank you !
     
  9. eva2000

    eva2000 Administrator Staff Member

    54,107
    12,179
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,739
    Local Time:
    8:50 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    CentOS 7 officially would be mariadb service with Centmin Mod's installed official MariaDB 10 server