Page 1 of 1

PhpMyAdmin Bug after latest update

Posted: Tue Apr 06, 2021 2:01 pm
by rdcstarr
Hello,

I have a PhpMyAdmin bug after latest MyVestaCP update from 4 April, I will put here some screenshots. I mention that I had phpmyadmin 5.1.0 and that after this bug I tried to upload to phpmyadmin in "/usr/share" but in vain. Can someone help me? Thank you!

Re: PhpMyAdmin Bug after latest update

Posted: Tue Apr 06, 2021 2:10 pm
by myVesta
Probably you broke it when you uploaded in /usr/share
Try to execute installer steps: https://github.com/myvesta/vesta/blob/m ... 1092-L1129

Re: PhpMyAdmin Bug after latest update

Posted: Tue Apr 06, 2021 2:11 pm
by myVesta

Re: PhpMyAdmin Bug after latest update

Posted: Tue Apr 06, 2021 2:28 pm
by rdcstarr
Hi, unfortunately I can't run the installer again because I already host a few hundred sites, the problem is that it worked perfectly until the April 4 myvestacp update. And the second solution is still not good for me because I can't access phpmyadmin as an administrator.

Re: PhpMyAdmin Bug after latest update

Posted: Tue Apr 06, 2021 4:52 pm
by myVesta
Update couldn't brake phpmyadmin because fixes have nothing with phpmyadmin, and does not affect phpmyadmin in anyway.

I asked you to copy-paste in SSH just a higlighted part from installer - https://github.com/myvesta/vesta/blob/m ... 1092-L1129
here it is:

Code: Select all

      mkdir /root/phpmyadmin
      mkdir /usr/share/phpmyadmin
      
      pma_v='4.9.7'
      echo "(*) Installing phpMyAdmin version v$pma_v..."

      cd /root/phpmyadmin

      # Download latest phpmyadmin release
      wget -nv -O phpMyAdmin-$pma_v-all-languages.tar.gz https://files.phpmyadmin.net/phpMyAdmin/$pma_v/phpMyAdmin-$pma_v-all-languages.tar.gz

      # Unpack files
      tar xzf phpMyAdmin-$pma_v-all-languages.tar.gz

      # Delete file to prevent error
      rm -fr /usr/share/phpmyadmin/doc/html

      # Overwrite old files
      cp -rf phpMyAdmin-$pma_v-all-languages/* /usr/share/phpmyadmin

      # Set config and log directory
      sed -i "s|define('CONFIG_DIR', '');|define('CONFIG_DIR', '/etc/phpmyadmin/');|" /usr/share/phpmyadmin/libraries/vendor_config.php
      sed -i "s|define('TEMP_DIR', './tmp/');|define('TEMP_DIR', '/var/lib/phpmyadmin/tmp/');|" /usr/share/phpmyadmin/libraries/vendor_config.php

      # Create temporary folder and change permission
      mkdir /usr/share/phpmyadmin/tmp
      chmod 777 /usr/share/phpmyadmin/tmp

      # Clear Up
      rm -fr phpMyAdmin-$pma_v-all-languages
      rm -f phpMyAdmin-$pma_v-all-languages.tar.gz
      
      wget -nv -O /root/phpmyadmin/pma.sh http://c.myvestacp.com/debian/10/pma/pma.sh 
      wget -nv -O /root/phpmyadmin/create_tables.sql http://c.myvestacp.com/debian/10/pma/create_tables.sql
      bash /root/phpmyadmin/pma.sh
      blowfish="RANDOM_HASH"
      echo "\$cfg['blowfish_secret'] = '$blowfish';" >> /etc/phpmyadmin/config.inc.php