All 3 LAMP stacks on the DO marketplace have outdated/insecure components and the default PPA does not let me upgrade PHP, MySQL, Apache, PHPMyAdmin to their latest secure versions.
What would be the easiest/safest way to get a fully updated LAMP droplet?
(latest MySQL 5 or 8 would both be ok I guess)
Hello,
What you can do is to backup your droplet and upgrade the components manually. In this was if anything goes wrong you will be able to revert the changes. Also before upgrading LAMP you need to make sure your application/site is compatible with the newer versions of PHP, MySQL and Apache, this is really important.
If you can provide more information about the droplet - what’s OS is using, I can give you more information about the process.
Alex
UBUNTU 18.04
My droplet doesn’t have anything on it right now that I’m not willing to lose. Just a mostly fresh PHPMyAdmin OneClick droplet.
I’d be more than willing to create a new fresh droplet for this.
I also think that having a new tutorial (even if just as an answer to this question) available to future users coming across this issue would be worth starting over with a fresh droplet.
If you are able and willing to explain how to install a fully updated LAMP stack (preferably with certbot and PHPMyAdmin as well) on a DO droplet, that would be really awesome. I don’t understand why there is nothing like this available for digitalocean at this time. I’m only finding very outdated information.
As for my webapp, it’s running on fully updated WAMP for development, so I’m not worried about it not being compatible.
Could you please let me know which are the current versions of Apache, MySQL and PHP installed on your droplet?
Alex
It’s the default DO PHPMyAdmin One-Click install:
Package / Version
phpMyAdmin / 4.6.6
MySQL Server / 5.7.23
Apache / 2.4.29
PHP / 7.2
Certbot / 0.23.0
Hello and sorry for the delayed response.
If it’s a blank or new droplet you can simply deploy a new one as it should have greater versions, although the provided versions are not that outdated.
You can update phpMyAdmin manually using the following steps:
Backup phpMyAdmin:
mv /usr/share/phpmyadmin/ /usr/share/phpmyadmin.bak
Download Latest phpMyAdmin (4.9.1):
wget https://files.phpmyadmin.net/phpMyAdmin/4.9.0.1/phpMyAdmin-4.9.0.1-all-languages.zip
unzip phpMyAdmin-4.9.0.1-all-languages.zip
As I told the existing phpMyAdmin was installed with Apt package manager. Therefore you need to specify the TEMPDIR and CONFIGDIR location under the vendor_config.php file.
Edit vendor_config.php file in your favorite text editor:
vim /usr/share/phpmyadmin/libraries/vendor_config.php
and update the following values.
define('TEMP_DIR', '/var/lib/phpmyadmin/tmp/');
define('CONFIG_DIR', '/etc/phpmyadmin/');
Save the file and access check the phpMyAdmin version. You should be running the lastest version:
Which version of MariaDB you would like installed on your droplet? The same question is valid for Apache and PHP.
Have in mind that you can always try to upgrade the packages using apt-get
Looking forward to your reply.
Alex