Get the most out of your Centmin Mod LEMP stack
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

    44,750
    10,204
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,815
    Local Time:
    9:02 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    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

    3,827
    370
    83
    May 31, 2014
    Ratings:
    +712
    Local Time:
    2:02 PM
    Nginx-1.17.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

    44,750
    10,204
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,815
    Local Time:
    9:02 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    yeah you can do that, probably should update 123.09beta01 to do that for cmd shortcuts
     
  4. pamamolf

    pamamolf Premium Member Premium Member

    3,827
    370
    83
    May 31, 2014
    Ratings:
    +712
    Local Time:
    2:02 PM
    Nginx-1.17.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

    3,827
    370
    83
    May 31, 2014
    Ratings:
    +712
    Local Time:
    2:02 PM
    Nginx-1.17.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

    44,750
    10,204
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,815
    Local Time:
    9:02 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    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

    3,827
    370
    83
    May 31, 2014
    Ratings:
    +712
    Local Time:
    2:02 PM
    Nginx-1.17.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

    3,827
    370
    83
    May 31, 2014
    Ratings:
    +712
    Local Time:
    2:02 PM
    Nginx-1.17.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

    44,750
    10,204
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,815
    Local Time:
    9:02 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    CentOS 7 officially would be mariadb service with Centmin Mod's installed official MariaDB 10 server