Welcome to Centmin Mod Community
Register Now

SSL Letsencrypt Phpmyadmin: There is a mismatch between HTTPS indicated on the server and client.

Discussion in 'Add Ons' started by pamamolf, Dec 29, 2019.

  1. eva2000

    eva2000 Administrator Staff Member

    53,486
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    1:46 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    oh actually doing yarn install does fix phpmyadmin 5's mismatch errors it seems ! interesting :)

     
  2. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    6:46 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    Perfect !!!

    So i just need only to install it again using your latest setup script?
     
  3. eva2000

    eva2000 Administrator Staff Member

    53,486
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    1:46 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    no more updates needed to revise yarn detection install for update cronjob
     
  4. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    6:46 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    Ok :)

    Then i must wait.

    Thank you !
     
  5. eva2000

    eva2000 Administrator Staff Member

    53,486
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    1:46 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    seems still get error trying to log in with
    so more work to be done for phpmyadmin 5 to work

    edit: seems this error is reported when in enter incorrect mysql user password !
     
  6. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    6:46 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    If you enter the correct password is working?
     
  7. eva2000

    eva2000 Administrator Staff Member

    53,486
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    1:46 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yup - strange I know.

    Anyway fixed and updated phpmyadmin.sh for phpmyadmin 5+ to work via git clone.

    Missing css in phpmyadmin 5+ installed via git clone triggers a mismatch http/https error in phpmyadmin 5+ and requires nodejs + yarn installed to generate the missing css via yarn run css-compile command. Something that phpmyadmin 4.9+ didn't need to do as the css was already bundled in git cloned phpmyadmin repos before.

    Without the missing css files, phpmyadmin 5 installed via git clone reports this message:

    Existing Centmin Mod LEMP stack users should uninstall their existing phpmyadmin installation installed via phpmyadmin.sh and re-install updated phpmyadmin.sh via commands outlined for phpmyadmin 5+ at centminmod/phpmyadmin

    Code (Text):
    # uninstall existing phpmyadmin install
    /root/tools/phpmyadmin_uninstall.sh
    
    # download phpmyadmin.sh
    cd /usr/local/src/centminmod/addons
    wget --no-check-certificate https://github.com/centminmod/phpmyadmin/raw/master/phpmyadmin.sh -O phpmyadmin.sh
    
    # permissions
    chmod 0700 /usr/local/src/centminmod/addons/phpmyadmin.sh
    
    # install phpmyadmin lastest stable
    ./phpmyadmin.sh install


    @jcat :)
     
  8. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    6:46 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    I am testing it now.... :)
     
  9. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    6:46 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    It works great !!!

    Thank you !

    Is it ok to use the cron for auto update?

    Let's hope that the official fix will not break your cron auto update script :)


    Edit: I just tried also with a wrong root password and i didn't get the error that you get...

    I got only the normal:

    Code:
    mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)
    [​IMG]

    Maybe it was your cache/cookies?
     
    Last edited: Dec 31, 2019
  10. eva2000

    eva2000 Administrator Staff Member

    53,486
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    1:46 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yeah strange that i got that message but don't get it now

    the cronjob updater should work fine too as I updated the code their too to run yarn command to generate the css
     
  11. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    6:46 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    Two of my servers was ok but 1 of them still has the mismatch error :(

    I tried also to run after the installation the autoupdater and i got this:

    Code:
    Updating dependencies
    Writing lock file
    Generating autoload files
    /usr/lib/node_modules/yarn/lib/cli.js:46099
      let {
          ^
    
    SyntaxError: Unexpected token {
        at exports.runInThisContext (vm.js:53:16)
        at Module._compile (module.js:373:25)
        at Object.Module._extensions..js (module.js:416:10)
        at Module.load (module.js:343:32)
        at Function.Module._load (module.js:300:12)
        at Module.require (module.js:353:17)
        at require (internal/module.js:12:17)
        at Object.<anonymous> (/usr/lib/node_modules/yarn/bin/yarn.js:24:13)
        at Module._compile (module.js:409:26)
        at Object.Module._extensions..js (module.js:416:10)
    I will check the 3 more servers that i have and i will report back ...
     
    Last edited: Dec 31, 2019
  12. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    6:46 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    All my servers are ok except only one that i am getting the above error :(

    Weird :(
     
  13. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    6:46 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    Ok i found the issue:

    I have an old version of nodejs on the server that is not working...

    No idea how ....

    working server:
    node -v
    Code:
    v12.14.0
    not working server:
    node -v
    Code:
    v4.9.1
    i don't remember to touch anything related ....

    Any ideas how can update it?

    Thank you
     
  14. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    6:46 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    I just tried:

    cd /usr/local/src/centminmod/addons
    ./nodejs.sh install

    and i got this:
    Code:
    node.js install already detected
    
    if node.js was installed via this addon you can update node.js
    using below command to uninstall previous version:
    
     yum -y erase $(rpm -qa nodejs)
    
    then re-run this script to install node.js again
    Should i erase it or i will break something and is better to do it using:
    Code:
    yum -y install nodejs --disableplugin=priorities
    Don't know how to update it now :(
     
  15. eva2000

    eva2000 Administrator Staff Member

    53,486
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    1:46 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yeah just do
    Code (Text):
    yum -y erase $(rpm -qa nodejs)
    /usr/local/src/centminmod/addons/nodejs.sh install
    /usr/local/src/centminmod/addons/phpmyadmin.sh install
    
     
  16. eva2000

    eva2000 Administrator Staff Member

    53,486
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    1:46 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yeah just do
    Code (Text):
    yum -y erase $(rpm -qa nodejs)
    /usr/local/src/centminmod/addons/nodejs.sh install
    /usr/local/src/centminmod/addons/phpmyadmin.sh install
    
     
  17. manhdv

    manhdv New Member

    3
    0
    1
    Jun 1, 2019
    Ratings:
    +1
    Local Time:
    10:46 PM
  18. eva2000

    eva2000 Administrator Staff Member

    53,486
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    1:46 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  19. Kintaro

    Kintaro Member

    106
    11
    18
    Dec 2, 2016
    Italy
    Ratings:
    +30
    Local Time:
    5:46 PM
    1.15.x
    MariaDB 10
    I'm getting the same issue.

    phpMyAdmin version:
    Code (Text):
    [17:11][root@domain.com ~]# head -n4 /usr/local/nginx/html/XXXX_mysqladminXXXXX/ChangeLog
    phpMyAdmin - ChangeLog
    ======================
    
    5.0.2 (2020-03-20)
    


    I need to do manually do this, right?

     
    Last edited: May 18, 2020
  20. Kintaro

    Kintaro Member

    106
    11
    18
    Dec 2, 2016
    Italy
    Ratings:
    +30
    Local Time:
    5:46 PM
    1.15.x
    MariaDB 10
    yes, you need to do it manually. Done and worked. :rolleyes:
     
  21. eva2000

    eva2000 Administrator Staff Member

    53,486
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    1:46 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yup do manually :)