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

    52,657
    12,071
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,597
    Local Time:
    5:37 AM
    Nginx 1.25.x
    MariaDB 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

    4,067
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    10:37 PM
    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

    52,657
    12,071
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,597
    Local Time:
    5:37 AM
    Nginx 1.25.x
    MariaDB 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

    4,067
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    10:37 PM
    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,067
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    10:37 PM
    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

    52,657
    12,071
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,597
    Local Time:
    5:37 AM
    Nginx 1.25.x
    MariaDB 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

    4,067
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    10:37 PM
    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,067
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    10:37 PM
    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

    52,657
    12,071
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,597
    Local Time:
    5:37 AM
    Nginx 1.25.x
    MariaDB 10.x
    CentOS 7 officially would be mariadb service with Centmin Mod's installed official MariaDB 10 server