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!
PhpMyAdmin Bug after latest update
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.
- myVesta
- Site Admin
- Posts: 932
- Joined: Fri Jun 19, 2020 9:59 am
- Has thanked: 8 times
- Been thanked: 6 times
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:
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