Want more timely Centmin Mod News Updates?
Become a Member

mysqladmin_shell.sh issues

Discussion in 'Add Ons' started by Qu Don, Jun 12, 2018.

  1. Qu Don

    Qu Don Member

    46
    5
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +9
    Local Time:
    2:58 AM
    Pardon me if this isnt the appropriate thread.
    I have been trying to create a user, a database and grant all permissions to install a CMS. Im not sure whats wrong.
    I have attached a screencap

    clip.PNG
     
    Last edited: Jun 12, 2018
  2. eva2000

    eva2000 Administrator Staff Member

    35,603
    7,841
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,085
    Local Time:
    4:58 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    looks like mariadb mysql wasn't installed properly

    what's output for commands below ?
    Code (Text):
    yum list MariaDB-*
    

    Code (Text):
    mysql -V
    

    example
    Code (Text):
    mysql -V
    mysql  Ver 15.1 Distrib 10.1.33-MariaDB, for Linux (x86_64) using readline 5.1
    

    Code (Text):
    yum list MariaDB-*
    Loaded plugins: fastestmirror, priorities, versionlock
    Loading mirror speeds from cached hostfile
     * base: repos.dfw.quadranet.com
     * epel: fedora-epel.mirror.lstn.net
     * extras: mirror.dal10.us.leaseweb.net
     * rpmforge: mirror.lstn.net
     * updates: mirror.compevo.com
    293 packages excluded due to repository priority protections
    Installed Packages
    MariaDB-client.x86_64                                                                                                             10.1.33-1.el7.centos                                                                                            @mariadb
    MariaDB-common.x86_64                                                                                                             10.1.33-1.el7.centos                                                                                            @mariadb
    MariaDB-compat.x86_64                                                                                                             10.1.33-1.el7.centos                                                                                            @mariadb
    MariaDB-devel.x86_64                                                                                                              10.1.33-1.el7.centos                                                                                            @mariadb
    MariaDB-server.x86_64                                                                                                             10.1.33-1.el7.centos                                                                                            @mariadb
    MariaDB-shared.x86_64                                                                                                             10.1.33-1.el7.centos                                                                                            @mariadb
    Available Packages
    MariaDB-backup.x86_64                                                                                                             10.1.33-1.el7.centos                                                                                            mariadb 
    MariaDB-cassandra-engine.x86_64                                                                                                   10.1.33-1.el7.centos                                                                                            mariadb 
    MariaDB-connect-engine.x86_64                                                                                                     10.1.33-1.el7.centos                                                                                            mariadb 
    MariaDB-cracklib-password-check.x86_64                                                                                            10.1.33-1.el7.centos                                                                                            mariadb 
    MariaDB-gssapi-client.x86_64                                                                                                      10.1.33-1.el7.centos                                                                                            mariadb 
    MariaDB-gssapi-server.x86_64                                                                                                      10.1.33-1.el7.centos                                                                                            mariadb 
    MariaDB-oqgraph-engine.x86_64                                                                                                     10.1.33-1.el7.centos                                                                                            mariadb 
    MariaDB-test.x86_64                                                                                                               10.1.33-1.el7.centos                                                                                            mariadb 
    mariadb.x86_64                                                                                                                    1:5.5.56-2.el7                                                                                                  base   
    mariadb-bench.x86_64                                                                                                              1:5.5.56-2.el7                                                                                                  base   
    mariadb-devel.x86_64                                                                                                              1:5.5.56-2.el7                                                                                                  base   
    mariadb-embedded.x86_64                                                                                                           1:5.5.56-2.el7                                                                                                  base   
    mariadb-embedded-devel.x86_64                                                                                                     1:5.5.56-2.el7                                                                                                  base   
    mariadb-libs.x86_64                                                                                                               1:5.5.56-2.el7                                                                                                  base   
    mariadb-server.x86_64                                                                                                             1:5.5.56-2.el7                                                                                                  base   
    mariadb-test.x86_64                                                                                                               1:5.5.56-2.el7                                                                                                  base   
    


    for posting code or output from commands to keep the formatting, you might want to use CODE tags for code How to use forum BBCODE code tags :)

    You'll need to post on the forums with the following info
    • Server or VPS details ? XEN, KVM, OpenVZ, VMWare or dedicated server ? OS ? CentOS 6.9 or 7.4 ? 32bit or 64bit ?
    • What version of Centmin Mod ? .07 stable or 08 stable or .09 beta01 or another branch version ?
    • Was it fresh install or upgrade ?
    • Method of install ? Via centmin.sh menu option 1, Git install or curl one liner install as outlined at centminmod.com/download.html ?
    • How long ago did you install Centmin Mod ?
    • There's numerous code changes, bug fixes over time, so ensure you have latest Centmin Mod code installed by upgrading your Centmin Mod code as instructed below.

    Troubleshooting Initial Install



    To troubleshoot initial installation, you need to check the initial install log at /root/centminlogs and instructions under Sharing logs and errors heading for using Pastebin.com or Gists to share a sanitised version of the contents of the initial install log. You can see full details at How to troubleshoot Centmin Mod initial install issues

    Example list /root/centminlogs files in date ascending order and grep for install.log
    Code (Text):
    ls -lahrt /root/centminlogs | grep install.log
    

    example output returns install log at /root/centminlogs/centminmod_1.2.3-eva2000.09.001_111016-112321_install.log
    Code (Text):
    ls -lahrt /root/centminlogs | grep install.log
    -rw-r--r--  1 root root 2.2M Oct 11 01:40 centminmod_1.2.3-eva2000.09.001_111016-112321_install.log
    

    in SSH use cat to ouput contents of /root/centminlogs/centminmod_1.2.3-eva2000.09.001_111016-112321_install.log. Clear your SSH client window/buffer so only output is the contents of the file
    Code (Text):
    cat /root/centminlogs/centminmod_1.2.3-eva2000.09.001_111016-112321_install.log
    

    Then copy and paste into Pastebin.com or Gists entry. If your SSH window scroll buffer isn't that large to get the whole contents of the install log, you can download file manually and copy and paste contents. But makes sure it's sanitised version of the contents of the initial install log as outlined at How to troubleshoot Centmin Mod initial install issues
     
    • Like Like x 1
  3. Qu Don

    Qu Don Member

    46
    5
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +9
    Local Time:
    2:58 AM
    Thanks, this was the result but I'll just do a re-installation and see how it goes.

    Code:
    [12:07][[email protected] addons]#
    [12:07][[email protected] addons]# yum list MariaDB-*
    Loaded plugins: fastestmirror, priorities, versionlock
    Loading mirror speeds from cached hostfile
     * base: ftp.osuosl.org
     * epel: epel.mirror.constant.com
     * extras: mirror.ash.fastserv.com
     * rpmforge: mirror.us.leaseweb.net
     * updates: mirrors.centos.webair.com
    275 packages excluded due to repository priority protections
    Available Packages
    MariaDB-backup.x86_64                                               10.1.33-1.el7.centos                               mariadb
    MariaDB-cassandra-engine.x86_64                                     10.1.33-1.el7.centos                               mariadb
    MariaDB-client.x86_64                                               10.1.33-1.el7.centos                               mariadb
    MariaDB-common.x86_64                                               10.1.33-1.el7.centos                               mariadb
    MariaDB-compat.x86_64                                               10.1.33-1.el7.centos                               mariadb
    MariaDB-connect-engine.x86_64                                       10.1.33-1.el7.centos                               mariadb
    MariaDB-cracklib-password-check.x86_64                              10.1.33-1.el7.centos                               mariadb
    MariaDB-devel.x86_64                                                10.1.33-1.el7.centos                               mariadb
    MariaDB-gssapi-client.x86_64                                        10.1.33-1.el7.centos                               mariadb
    MariaDB-gssapi-server.x86_64                                        10.1.33-1.el7.centos                               mariadb
    MariaDB-oqgraph-engine.x86_64                                       10.1.33-1.el7.centos                               mariadb
    MariaDB-server.x86_64                                               10.1.33-1.el7.centos                               mariadb
    MariaDB-shared.x86_64                                               10.1.33-1.el7.centos                               mariadb
    MariaDB-test.x86_64                                                 10.1.33-1.el7.centos                               mariadb
    mariadb.x86_64                                                      1:5.5.56-2.el7                                     base
    mariadb-bench.x86_64                                                1:5.5.56-2.el7                                     base
    mariadb-devel.x86_64                                                1:5.5.56-2.el7                                     base
    mariadb-embedded.x86_64                                             1:5.5.56-2.el7                                     base
    mariadb-embedded-devel.x86_64                                       1:5.5.56-2.el7                                     base
    mariadb-libs.x86_64                                                 1:5.5.56-2.el7                                     base
    mariadb-server.x86_64                                               1:5.5.56-2.el7                                     base
    mariadb-test.x86_64                                                 1:5.5.56-2.el7                                     base
    [12:07][[email protected] addons]# mysql -V
    -bash: mysql: command not found
    [12:09][[email protected] addons]#
    
     
  4. Qu Don

    Qu Don Member

    46
    5
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +9
    Local Time:
    2:58 AM
    Solved with reinstall. Thanks!

    Code:
    [[email protected] addons]# mysql -V
    mysql  Ver 15.1 Distrib 10.1.33-MariaDB, for Linux (x86_64) using readline 5.1
    [[email protected] addons]#
    
     
  5. eva2000

    eva2000 Administrator Staff Member

    35,603
    7,841
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,085
    Local Time:
    4:58 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    • Like Like x 1
  6. Qu Don

    Qu Don Member

    46
    5
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +9
    Local Time:
    2:58 AM
    I noticed user granted privileges identified by a password different from username password. It is also not the same as my.conf.
    Whats the difference?

    Code:
    ./mysqladmin_shell.sh setuserdb
    --------------------------------------------------------------
    Basic MySQL Admin - create mysql user & databases
    --------------------------------------------------------------
    --------------------------------------------------------------
    
     Do you want to create a new MySQL username (type = y) or
     Add a new database name to existing MySQL username (type = n) ?
     Enter y or n: y
    ---------------------------------
    Create MySQL username:
    ---------------------------------
     Enter new MySQL username you want to create: ydbuser1
     Enter new MySQL username's password: ydbpass1
    ---------------------------------
    Create MySQL database:
    ---------------------------------
     Enter new MySQL database name: ydb1
    
    Grants for [email protected]
    GRANT USAGE ON *.* TO 'ydbuser1'@'localhost' IDENTIFIED BY PASSWORD '*34CE4FFBB62702263F1970A79FB0BA6CF651489B'
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `ydb1`.* TO 'ydbuser1'@'localhost'
    
    Ok: MySQL user: ydbuser1 MySQL database: ydb1 created successfully
    Sometimes I wonder what will happen if you abandon this project since you're a lone dev.
    Do you have any contigency plans?
    What kind of knowledge is needed to maintain this project?

    Is there any kind of help you will like from members of this forum?
     
  7. eva2000

    eva2000 Administrator Staff Member

    35,603
    7,841
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,085
    Local Time:
    4:58 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    that show grant output is encrypted version of your password hence different

    Yes currently only developer - though I eat my own dog food and have 160+ servers of which 95% run Centmin Mod LEMP stack. So I am very motivated to keep Centmin Mod up to date :) Though I only work on Centmin Mod in my spare time. If financially I was able to work on Centmin Mod full time, that would be great too - at which time, I would be also able to hire Centmin Mod staff - yes can dream :D Though for now it's what it is :)

    But Centmin Mod code is fully open source and hosted on github at centminmod/centminmod so anyone can fork the project (some have already done so) and take over if they feel like it or if they want to custom the code for themselves. FYI, current centmin mod public development roadmap/dashboard centminmod/centminmod

    Knowledge wise you'd need to know shell bash scripting as that's what the code is just a bunch of shell bash wrapper scripts with a shell menu interface. But then you need knowledge of centos, nginx/nginx ssl/https, php/php-fpm, mariadb mysql, memcached, redis and general linux system admin knowledge including how to source compile software like nginx, php-fpm, memcached and various extra php extensions. And of course knowledge of how to use git/github.

    As to help from forum members, my main focus Centmin Mod user wise would be naturing future Centmin Mod experts Attention Future Centmin Mod Experts ! - which would be the user base I would hire from if I was ever able to financially work on Centmin Mod full time ;)

    For regular Centmin Mod users/members there's a few Ways To Support Centmin Mod too ;) :)
     
    • Like Like x 1
    • Agree Agree x 1
  8. Qu Don

    Qu Don Member

    46
    5
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +9
    Local Time:
    2:58 AM
    Thanks for the detailed response. This really puts issues into perspective.
     
..