Get the most out of your Centmin Mod LEMP stack
Become a Member

Install MariaDB MariaDB 10.4 on clean install

Discussion in 'Install & Upgrades or Pre-Install Questions' started by pdinh97qng, Sep 3, 2019.

  1. pdinh97qng

    pdinh97qng Member

    71
    8
    8
    Jan 24, 2016
    Ratings:
    +19
    Local Time:
    3:25 PM
    Got this error when installing Centmin Mod on Centos 7, the provider is DigitalOcean.
    I use the below code in custom_config.inc to force install MariaDB 10.4
    Code:
    MARIADB_INSTALLTENFOUR='y'
    Code (Text):
    **********************************************************************
    * Starting Services...
    **********************************************************************
    Starting nginx (via systemctl):  [  OK  ]
    ./centmin.sh: line 2259: /etc/init.d/mysql: No such file or directory

    Don't know whether this error is normal as when I tried to install MariaDB 10.3, there's no error.
    Tried to restart via command service mysql restart, and got this Redirecting to /bin/systemctl restart mysql.service
    But when use this command mysqlrestart, got this -bash: mysqlrestart: command not found
    Execute command mysql and got
    Code (Text):
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 5
    Server version: 10.4.7-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

     
  2. eva2000

    eva2000 Administrator Staff Member

    41,731
    9,397
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,434
    Local Time:
    8:25 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
  3. pdinh97qng

    pdinh97qng Member

    71
    8
    8
    Jan 24, 2016
    Ratings:
    +19
    Local Time:
    3:25 PM
    :blackeye: Some how it is missing /etc/init.d/mysql
     
  4. eva2000

    eva2000 Administrator Staff Member

    41,731
    9,397
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,434
    Local Time:
    8:25 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    that is comestic bug as /etc/init.d/mysql only applies to centos 6 and not centos 7 - i have already fixed that bug in latest 123.09beta01 updates

    i removed your initial install log as you didn't mask your login details, i would if possible do a fresh centos 7 install of centmin mod to regenerate all the mysql root user/password and php zend opcache/memcached stat page logins etc.

    But other than that you install looks good for mariadb 10.4 just cosmetic bug that I have corrected for future 123.09beta01 installs
     
    • Informative Informative x 1
  5. eva2000

    eva2000 Administrator Staff Member

    41,731
    9,397
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,434
    Local Time:
    8:25 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    but mysqlrestart command should of worked

    if you run centmin.sh once, then try mysqlrestart does it work ?

    what's contents of /usr/bin/mysqlrestart ?
    command
    Code (Text):
    cat /usr/bin/mysqlrestart
     
    Last edited: Sep 5, 2019
  6. pdinh97qng

    pdinh97qng Member

    71
    8
    8
    Jan 24, 2016
    Ratings:
    +19
    Local Time:
    3:25 PM
    mysqlrestart doesn't work @@
    Code (Text):
    cat: /usr/bin/mysqlrestart: No such file or directory
     
  7. eva2000

    eva2000 Administrator Staff Member

    41,731
    9,397
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,434
    Local Time:
    8:25 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Run these 3 commands to manually setup command shortcuts for mariadb mysql on centos 7
    Code (Text):
    echo "systemctl daemon-reload; service mysql stop" >/usr/bin/mysqlstop ; chmod 700 /usr/bin/mysqlstop
    echo "systemctl daemon-reload; service mysql start" >/usr/bin/mysqlstart ; chmod 700 /usr/bin/mysqlstart
    echo "systemctl daemon-reload; service mysql restart" >/usr/bin/mysqlrestart ; chmod 700 /usr/bin/mysqlrestart
    

    but
    i'd do this to ensure you regenerate all logins but also to be 100% sure initial install is working 100% as no idea if anything else is broken as cmd shortcut setup wouldn't be related to mariadb 10.4 install it's a separate routine dealing with that
     
    • Useful Useful x 1