I’m having several issues with my installation of Ubuntu 22.04. I’m trying to solve a database issue, but today when I went to update the system I go this message…
The following packages have unmet dependencies:
php5.6-ssh2 : Breaks: php-ssh2 (< 1:0.13-1+ubuntu22.04.1+deb.sury.org+1~)
E: Unable to correct problems, you have held broken packages.
Could you please help my solve this? Should I delete php5.6 then reinstall it? If so, what would be the best way to do that. I’d like to take care of it as soon as possible since I have a few programs that still use php5.6. I have multiple PHP versions installed on this server with the PPA installation
I still need it for the databases I’m working with. Connecting to MariaDB has caused problems regardless of the PHP version I’m using. I’m thinking if I install the updated version of MySql rather than Maria it may solve issues but no one seems to know how to do that and keep Virtualmin as my management system
Several people certainly do know, because I’ve posted instructions for how to do it several times. (Though I don’t recommend it, but you’re already soundly in “not recommended” territory by running an unmaintained PHP version.)
I’ve read your posts about changing it, but none of them worked! Every time I follow the instructions I wind up with the mysql being dead!
You had suggested that I install the new virtualmin script on a fresh install. Them without logging in, delete the MariaDB, then install the MySql 8 db. That’s exactly what I did and the mySql would not start!
I’ve probably done this at least 20 times with not luck!
Actually I’d rather keep the MariaDb, but I can’t seem to make it work with the databases I’ve imported from MySql 5.7. Maria reads the databases without a problem, but I can’t add new records or update them whithout a host of errors!
The other option is to keep everything in place with the new install and connect my scripts in this installation to the old database in the old installation… but I can’t figure out that one either!
So if you could give me the step by step to try installing an updated Ubuntu and then put the Mysql 8 database in it instead of the MariaDB then at least I can test it to see if indeed the problem is the MariaDB or simply the idea that I’m updating it.
I don’t plan on doing this on a production server, I’m more trying to figure out what the problem is when moving the database from the 5.7 version of MySql to a new version. In an ideal world I’d much rather be using the MariaDB in the new installation. But I don’t know exactly where the problem is.
Just on this point - you may want to look into MariaDB’s sql_mode setting. STRICT mode is now on by default and will throw errors if your older SQL queries aren’t perfect. You can disable strict mode to buy your self time to update the queries.
Thank you Wheeler, I’ll give that a try! Most of these queries I made 7 or 8 years ago. I went on a marathon of coding to get them written and then since everything has worked fine since, I rarely mess with it. Unfortunately I’ve forgotten how it did it!!! And the guy who helped me out with this is currently being treated for pancreatic cancer so he has more important battles to fight. If you happen to be good at this type of thing and were interested in modifying my code please let me know. We could maybe work something out. It would be nice to be compliant with the new systems rather than just putting a patch on it. Nonetheless… I really appreciate your assistance here and I’ll give that a try!