We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Updated to PHP7, but now phpMyAdmin is borked.. What do? (CentOS 7)
-
- Posts: 43
- Joined: Tue Apr 18, 2017 10:54 pm
- Os: Ubuntu 15x
- Web: apache + nginx
Updated to PHP7, but now phpMyAdmin is borked.. What do? (CentOS 7)
Hello and please help!
I have installed PHP7 on my CentOS 7 VPS, however I cannot seem to find a tutorial to help me re-install phpMyAdmin for PHP7. I followed the tutorial here: http://www.servermom.org/upgrade-vestac ... p-7-centos if that helps you know what plugins I have. I also installed ZIP after the install.
I have found many guides that simply say " I went into my public folder and installed it with this command:
git clone --depth=1 --branch=STABLE https://github.com/phpmyadmin/phpmyadmin.git" however I don't know how this would work, which "public folder" they mean, and if it works for PHP7 or not.
Thank you to anyone who can guide me!
I have installed PHP7 on my CentOS 7 VPS, however I cannot seem to find a tutorial to help me re-install phpMyAdmin for PHP7. I followed the tutorial here: http://www.servermom.org/upgrade-vestac ... p-7-centos if that helps you know what plugins I have. I also installed ZIP after the install.
I have found many guides that simply say " I went into my public folder and installed it with this command:
git clone --depth=1 --branch=STABLE https://github.com/phpmyadmin/phpmyadmin.git" however I don't know how this would work, which "public folder" they mean, and if it works for PHP7 or not.
Thank you to anyone who can guide me!
Re: Updated to PHP7, but now phpMyAdmin is borked.. What do? (CentOS 7)
I'm running PHPmyadmin under PHP7 without any problems. I'm guessing that you must just be missing some PHP modules.
The first place I'd look is in the error logs of your webserver, and in the PHP error log. You may have to enable PHP errror log depending on your installation. Plenty of help around the internet for doing that.
Another approach would be to see what php modules were installed originally and make sure you have some. You don't mention your OS, but looking at the original installation script, I can see that these are all the PHP related modules you need for PHP 7.
libapache2-mod-php7.0 php7.0 php7.0-common php7.0-cgi php7.0-mysql php7.0-curl php7.0-fpm php7.0-pgsql
On debian/ubuntu I'd make sure these were installed with "apt-get install libapache2-mod-php7.0 php7.0 php7.0-common php7.0-cgi php7.0-mysql php7.0-curl php7.0-fpm php7.0-pgsql"
Centos you'd use yum install.
If this installs additional modules, then you're probably OK. If all modules are already installed, then you have to keep looking.
The first place I'd look is in the error logs of your webserver, and in the PHP error log. You may have to enable PHP errror log depending on your installation. Plenty of help around the internet for doing that.
Another approach would be to see what php modules were installed originally and make sure you have some. You don't mention your OS, but looking at the original installation script, I can see that these are all the PHP related modules you need for PHP 7.
libapache2-mod-php7.0 php7.0 php7.0-common php7.0-cgi php7.0-mysql php7.0-curl php7.0-fpm php7.0-pgsql
On debian/ubuntu I'd make sure these were installed with "apt-get install libapache2-mod-php7.0 php7.0 php7.0-common php7.0-cgi php7.0-mysql php7.0-curl php7.0-fpm php7.0-pgsql"
Centos you'd use yum install.
If this installs additional modules, then you're probably OK. If all modules are already installed, then you have to keep looking.
-
- Posts: 43
- Joined: Tue Apr 18, 2017 10:54 pm
- Os: Ubuntu 15x
- Web: apache + nginx
Re: Updated to PHP7, but now phpMyAdmin is borked.. What do? (CentOS 7)
Thanks for the reply @plutocrat, however I simply gave up and just added a new folder with the latest version of phpMA.
Thanks again for offering your insight.
Thanks again for offering your insight.
Re: Updated to PHP7, but now phpMyAdmin is borked.. What do? (CentOS 7)
yea the issue was 80% most likely libapache2-mod-php need the php7 variation for it
Re: Updated to PHP7, but now phpMyAdmin is borked.. What do? (CentOS 7)
ohio, consider it a blessing you broke phpmyadmin,
Its just 1 more security risk you dont need..
you can do everything you need with your database from CLI
Im assuming you're using mysql.
CREATE DB
#mysql -u root -p
#CREATE DATABASE dbname;
#GRANT ALL PRIVILEGES ON dbname.* TO dbusername@localhost IDENTIFIED BY 'dbpassword';
BACKUP DB
#cd /choosepath/backup/location
#mysqldump -p -u dbusername database_name > backupname.sql
RESTORE DB
#cd /yourpath/backup/location
#mysql -uroot -p database_name < backupname.sql
REPAIR OPTIONS
#mysqlcheck --auto-repair -r databasename -u root -p
#mysqlcheck --auto-repair -o databasename -u root -p
#mysqlcheck -r --all-databases -u root -p
#mysqlcheck -o --all-databases -u root -p
If you ever need to manually view a table you can always install a phpmyadmin alternative adminer. It easily installs and you can easily uninstall it when you're done.
Its just 1 more security risk you dont need..
you can do everything you need with your database from CLI
Im assuming you're using mysql.
CREATE DB
#mysql -u root -p
#CREATE DATABASE dbname;
#GRANT ALL PRIVILEGES ON dbname.* TO dbusername@localhost IDENTIFIED BY 'dbpassword';
BACKUP DB
#cd /choosepath/backup/location
#mysqldump -p -u dbusername database_name > backupname.sql
RESTORE DB
#cd /yourpath/backup/location
#mysql -uroot -p database_name < backupname.sql
REPAIR OPTIONS
#mysqlcheck --auto-repair -r databasename -u root -p
#mysqlcheck --auto-repair -o databasename -u root -p
#mysqlcheck -r --all-databases -u root -p
#mysqlcheck -o --all-databases -u root -p
If you ever need to manually view a table you can always install a phpmyadmin alternative adminer. It easily installs and you can easily uninstall it when you're done.