Join the community today
Become a Member

Fresh Beta01 Instal on CentOS7.x

Discussion in 'Install & Upgrades or Pre-Install Questions' started by cloud9, Dec 23, 2021.

  1. cloud9

    cloud9 Premium Member Premium Member

    219
    67
    28
    Oct 6, 2015
    England
    Ratings:
    +103
    Local Time:
    8:17 AM
    1.21.5
    10.3.32
    Please fill in any relevant information that applies to you:
    • CentOS Version: i.e. CentOS 6 32bit or 64bit / CentOS 7 64bit ?
    • Centmin Mod Version Installed: i.e. 123.08stable or 123.09beta01
    • Nginx Version Installed: i.e. 1.15.3
    • PHP Version Installed: i.e. 5.6.37, 7.0.31, 7.1.21, 7.2.9
    • MariaDB MySQL Version Installed: i.e. 10.0.x or 10.1.xx or 10.2.xx
    • When was last time updated Centmin Mod code base ? : i.e. run centmin.sh menu option 23 submenu option 2 or cmupdate command
    • Persistent Config: Do you have any persistent config file options set in /etc/centminmod/custom_config.inc ? You can check via this command:
      Code (Text):
      cat /etc/centminmod/custom_config.inc
      

      Post output in CODE tags.


     
  2. cloud9

    cloud9 Premium Member Premium Member

    219
    67
    28
    Oct 6, 2015
    England
    Ratings:
    +103
    Local Time:
    8:17 AM
    1.21.5
    10.3.32
    I have the mysql root pw from the install but its not working, I can reset this but just wondered why its not recognising it

    PHP8.1
    Version: 123.09beta01.b760
    Current Nginx Version: 1.21.4 (221221-171005-centos7-kvm-57b1995)

     
    Last edited: Dec 23, 2021
  3. eva2000

    eva2000 Administrator Staff Member

    47,837
    10,910
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,947
    Local Time:
    6:17 PM
    Nginx 1.21.x
    MariaDB 10.x
    Not working where? on command line like
    Code (Text):
    mysqladmin ver

    ?

    Could be auto generated password has a character in it that needs /root/.my.cnf to wrap the password in single quotes?
     
  4. cloud9

    cloud9 Premium Member Premium Member

    219
    67
    28
    Oct 6, 2015
    England
    Ratings:
    +103
    Local Time:
    8:17 AM
    1.21.5
    10.3.32
    Ok, reinstalled the VPS and still have the same issue
    Trying to creat a DB

    # mysqladmin -u root -pFDtCRfrczVvD3oxNboJUqwMIJxcF create ffa349

    mysqladmin: connect to server at 'localhost' failed

    error: 'Access denied for user 'root'@'localhost' (using password: YES)'
     
  5. cloud9

    cloud9 Premium Member Premium Member

    219
    67
    28
    Oct 6, 2015
    England
    Ratings:
    +103
    Local Time:
    8:17 AM
    1.21.5
    10.3.32
    I have tried the root pw for the server and also the mysql pw that Centmin generated on install - both give me the same error so cant create a db
     
  6. cloud9

    cloud9 Premium Member Premium Member

    219
    67
    28
    Oct 6, 2015
    England
    Ratings:
    +103
    Local Time:
    8:17 AM
    1.21.5
    10.3.32
    # mysqladmin ver

    mysqladmin: connect to server at 'localhost' failed

    error: 'Access denied for user 'root'@'localhost' (using password: YES)'
     
  7. eva2000

    eva2000 Administrator Staff Member

    47,837
    10,910
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,947
    Local Time:
    6:17 PM
    Nginx 1.21.x
    MariaDB 10.x
  8. cloud9

    cloud9 Premium Member Premium Member

    219
    67
    28
    Oct 6, 2015
    England
    Ratings:
    +103
    Local Time:
    8:17 AM
    1.21.5
    10.3.32

    Attached Files:

  9. eva2000

    eva2000 Administrator Staff Member

    47,837
    10,910
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,947
    Local Time:
    6:17 PM
    Nginx 1.21.x
    MariaDB 10.x
    Ah you sanitised the log but what was the old MariaDB MySQL root password set in the log next to the line
    Code (Text):
    MySQL root password: **************************

    Just curious if the auto generated password had a character MySQL didn't like.

    Yeah sounds like auto generated password had a character that MySQL maybe didn't like.
     
  10. eva2000

    eva2000 Administrator Staff Member

    47,837
    10,910
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,947
    Local Time:
    6:17 PM
    Nginx 1.21.x
    MariaDB 10.x
    FYI, I removed the log zip as some passwords still revealed. Probably best to do a fresh reinstall of OS and Centmin Mod.
     
  11. eva2000

    eva2000 Administrator Staff Member

    47,837
    10,910
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,947
    Local Time:
    6:17 PM
    Nginx 1.21.x
    MariaDB 10.x
    Checked the initial install log more and noticed a few MariaDB YUM repo error messages though MariaDB MySQL server itself was installed properly

    Code (Text):
    Not using downloaded mariadb/repomd.xml because it is older than what we have:
      Current   : Tue Nov  9 21:49:27 2021
      Downloaded: Tue Nov  9 21:42:47 2021
    http://mirror.zetup.net/repoforge/redhat/el7/en/x86_64/rpmforge/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
    Trying other mirror.
    To address this issue please refer to the below wiki article
    
    https://wiki.centos.org/yum-errors
    
    If above article doesn't help to resolve this issue please use https://bugs.centos.org/.
    

    But this one's weird, MariaDB 10.2 YUM packages attempted to install for MariaDB 10.3 repo?
    Code (Text):
    ================================================================================
     Package             Arch        Version                     Repository    Size
    ================================================================================
    Installing:
     MariaDB-shared      x86_64      10.2.41-1.el7.centos        mariadb      112 k
    
    Transaction Summary
    ================================================================================
    Install  1 Package
    
    Total download size: 112 k
    Installed size: 343 k
    Downloading packages:
    http://yum.mariadb.org/10.3/centos7-amd64/rpms/MariaDB-shared-10.2.41-1.el7.centos.x86_64.rpm: [Errno 14] HTTP Error 404 - Not Found
    Trying other mirror.
    To address this issue please refer to the below wiki article
    
    https://wiki.centos.org/yum-errors
    
    If above article doesn't help to resolve this issue please use https://bugs.centos.org/.
    
    
    
    Error downloading packages:
      MariaDB-shared-10.2.41-1.el7.centos.x86_64: [Errno 256] No more mirrors to try.
    

    Looks like MariaDB 10.2 was installed and not the default MariaDB 10.3 in 123.09beta01
    Code (Text):
    [1;33;40m--------------------------------------------------------
    (B[m[1;33;40mCheck MariaDB installed RPM Versions:
    (B[m[1;33;40m--------------------------------------------------------
    (B[mMariaDB-compat-10.2.41-1.el7.centos.x86_64
    MariaDB-devel-10.2.41-1.el7.centos.x86_64
    MariaDB-client-10.2.41-1.el7.centos.x86_64
    MariaDB-server-10.2.41-1.el7.centos.x86_64
    MariaDB-common-10.2.41-1.el7.centos.x86_64
    

    what does the contents of /etc/yum.repos.d/mariadb.repo look like?
    Code (Text):
    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.3/centos7-amd64
    gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck=1
    exclude=MariaDB-Galera-server
    
     
  12. cloud9

    cloud9 Premium Member Premium Member

    219
    67
    28
    Oct 6, 2015
    England
    Ratings:
    +103
    Local Time:
    8:17 AM
    1.21.5
    10.3.32
    Damn, thought I had deleted the PW's. Cant get you that file now as destroyed the VPS and starting over - its happened twice now so if I get the same issue ill post up that log before I apply the fix
     
  13. cloud9

    cloud9 Premium Member Premium Member

    219
    67
    28
    Oct 6, 2015
    England
    Ratings:
    +103
    Local Time:
    8:17 AM
    1.21.5
    10.3.32
    Ok, just installed centminmod - php8.1

    Really weird all the MySql PW's are now all blank in the installer screen

    Will post up logs in a bit
     
  14. eva2000

    eva2000 Administrator Staff Member

    47,837
    10,910
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,947
    Local Time:
    6:17 PM
    Nginx 1.21.x
    MariaDB 10.x
    well I tested 123.09beta01 fresh install and not getting the issue. It could be specific to your VPS server and it's location as something is funky with MariaDB 10.2 being installed instead of 10.3 so could be a MariaDB YUM mirror issue. I'd try on a different VPS host and see if you get the same issue.
     
  15. cloud9

    cloud9 Premium Member Premium Member

    219
    67
    28
    Oct 6, 2015
    England
    Ratings:
    +103
    Local Time:
    8:17 AM
    1.21.5
    10.3.32
    Screen shot of the no passwords's after fresh install, VPS is Vultr in Sweden
     

    Attached Files:

    Last edited: Dec 24, 2021
  16. cloud9

    cloud9 Premium Member Premium Member

    219
    67
    28
    Oct 6, 2015
    England
    Ratings:
    +103
    Local Time:
    8:17 AM
    1.21.5
    10.3.32
  17. eva2000

    eva2000 Administrator Staff Member

    47,837
    10,910
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,947
    Local Time:
    6:17 PM
    Nginx 1.21.x
    MariaDB 10.x
    You mean you didn't edit those, but they were blank by default ? inspect the full install log not the minimal log to be sure in /root/centminlogs there's 2 versions minimal and full logs
    Code (Text):
    ls -lahrt /root/centminlogs/ | grep installer
    -rw-r--r--   1 root root 3.7M Dec  7 06:27 installer_071221-010436.log
    -rw-r--r--   1 root root 1.2M Dec  7 06:27 installer_071221-010436_minimal.log
    
     
  18. cloud9

    cloud9 Premium Member Premium Member

    219
    67
    28
    Oct 6, 2015
    England
    Ratings:
    +103
    Local Time:
    8:17 AM
    1.21.5
    10.3.32
    Correct - Blank on install

    Cleansed log attached - note I didnt cleanse PW as they were not there

    Yes this is the same VPS - just another instance

    Yes a few testing issues, a bit rusty though, Just doing a new Invision on centminmod install ad haven't done one for a good few years
     

    Attached Files:

    Last edited: Dec 25, 2021
  19. eva2000

    eva2000 Administrator Staff Member

    47,837
    10,910
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,947
    Local Time:
    6:17 PM
    Nginx 1.21.x
    MariaDB 10.x
    Interesting issue, could be related to openssl as that is what is used to generate those specific passwords and I noticed in your logs these lines related to openssl that I don't see in mine
    Code (Text):
    Extra arguments given.
    rand: Use -help for summary.
    Extra arguments given.
    rand: Use -help for summary.
    

    what versions of openssl are installed on your problematic VPS?

    what is output for these commands
    Code (Text):
    which openssl
    

    Code (Text):
    openssl version -a

    Code (Text):
    /opt/openssl/bin/openssl version -a

    Code (Text):
    echo -e "$(openssl rand 31 -base64 | tr -dc 'a-zA-Z0-9')\n"
    

    Code (Text):
    echo -e "$(/opt/openssl/bin/openssl rand 31 -base64 | tr -dc 'a-zA-Z0-9')\n"


    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 :)

    examples
    Code (Text):
    which openssl
    /usr/bin/openssl

    Code (Text):
    openssl version -a
    OpenSSL 1.0.2k-fips  26 Jan 2017
    built on: reproducible build, date unspecified
    platform: linux-x86_64
    options:  bn(64,64) md2(int) rc4(16x,int) des(idx,cisc,16,int) idea(int) blowfish(idx)
    compiler: gcc -I. -I.. -I../include  -fPIC -DOPENSSL_PIC -DZLIB -DOPENSSL_THREADS -D_REENTRANT -DDSO_DLFCN -DHAVE_DLFCN_H -DKRB5_MIT -m64 -DL_ENDIAN -Wall -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -Wa,--noexecstack -DPURIFY -DOPENSSL_IA32_SSE2 -DOPENSSL_BN_ASM_MONT -DOPENSSL_BN_ASM_MONT5 -DOPENSSL_BN_ASM_GF2m -DRC4_ASM -DSHA1_ASM -DSHA256_ASM -DSHA512_ASM -DMD5_ASM -DAES_ASM -DVPAES_ASM -DBSAES_ASM -DWHIRLPOOL_ASM -DGHASH_ASM -DECP_NISTZ256_ASM
    OPENSSLDIR: "/etc/pki/tls"
    engines:  rdrand dynamic
    

    Code (Text):
    /opt/openssl/bin/openssl version -a
    OpenSSL 1.1.1l  24 Aug 2021
    built on: Tue Dec 14 14:55:51 2021 UTC
    platform: linux-x86_64
    options:  bn(64,64) rc4(16x,int) des(int) idea(int) blowfish(ptr)
    compiler: ccache /opt/rh/devtoolset-10/root/usr/bin/gcc -fPIC -pthread -m64 -Wa,--noexecstack -O3 -m64 -march=native -Wimplicit-fallthrough=0 -Wno-implicit-function-declaration -Wno-int-conversion -Wno-error=unused-result -fcode-hoisting -Wno-cast-function-type -Wno-format-extra-args -Wformat=0 -pipe -DOPENSSL_USE_NODELETE -DL_ENDIAN -DOPENSSL_PIC -DOPENSSL_CPUID_OBJ -DOPENSSL_IA32_SSE2 -DOPENSSL_BN_ASM_MONT -DOPENSSL_BN_ASM_MONT5 -DOPENSSL_BN_ASM_GF2m -DSHA1_ASM -DSHA256_ASM -DSHA512_ASM -DKECCAK1600_ASM -DRC4_ASM -DMD5_ASM -DAESNI_ASM -DVPAES_ASM -DGHASH_ASM -DECP_NISTZ256_ASM -DX25519_ASM -DPOLY1305_ASM -DNDEBUG
    OPENSSLDIR: "/opt/openssl"
    ENGINESDIR: "/opt/openssl/lib/engines-1.1"
    Seeding source: os-specific
    

    Code (Text):
    echo -e "$(openssl rand 31 -base64 | tr -dc 'a-zA-Z0-9')\n"
    Gdp4c2AKPZhbZX9ezRbb68i2Bsfbo1oQZyZyjLQ
    

    looks like the problem is the install is picking up Nginx's openssl 1.1.1 version
    Code (Text):
    echo -e "$(/opt/openssl/bin/openssl rand 31 -base64 | tr -dc 'a-zA-Z0-9')\n"
    Extra arguments given.
    rand: Use -help for summary.
    


    Looks like number of characters needs to be the last argument
    Code (Text):
    /opt/openssl/bin/openssl rand -base64 32
    2XZVoAMP+AfI8rEDdZFRN5ZzPdhxKUoMw/yQFvnnk
    

    Code (Text):
    openssl rand -base64 32
    oPq5S/JyIBA3m/6Z6xZPA9LPD2Bt1hYdmx2JA/isdxg=
    
     
    Last edited: Dec 25, 2021
  20. eva2000

    eva2000 Administrator Staff Member

    47,837
    10,910
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,947
    Local Time:
    6:17 PM
    Nginx 1.21.x
    MariaDB 10.x
    FYI, updated 123.09beta01 with the fix to ensure system /usr/bin/openssl is used for password generation. So try a fresh install