Issues with MySQL on new install

R

ralphie

New member
Joined
Nov 14, 2024
Messages
4
Hi friends,

I just installed my first directadmin panel on a personal project server yesterday. Everything seems functional, however I feel like there is still a problem with MySQL.

Here is what I've noticed:
1. When I try to restore a remote backup, everything restores except for the databases/users.
2. When I try to open the "Databases" tap on the user dashboard, it says "Internal error: Failed to get information about database running on the server" and "Internal error: Failed to load database list".
3. When I try to open roundcube, it says "Oops something has gone wrong". After trying to rebuild it, the first line says "ensure_my_cnf: cannot find /usr/local/directadmin/conf/mysql.conf" along with multiple access denied errors along the way.

MySQL service is running. When I attempt to rebuild MySQL, it says
" /proc/self/fd/3: line 5523: [: 80
022: integer expression expected
Automatic migration from MySQL 8.0
0.22 to MySQL 8.0 is not supported. Migration can be done in increments, upgrading 8.0
0.22 to the next version released, and going up until you reach 8.0."

Any thoughts on how to fix this? There is no mysql.conf file in the conf folder and also no setup.txt file in the scripts folder.

I'm not a complete noob but I'm also trying to learn a lot of this as I go.

Thanks :)
 
Look like youre backups or you running an old mysql versions?
ralphie said:
Automatic migration from MySQL 8.0
0.22 to MySQL 8.0 is not supported. Migration can be done in increments, upgrading 8.0
0.22 to the next version released, and going up until you reach 8.0."
Click to expand...
 
So I think I may have found one issue. My old 'shared' server was using mariadb not mysql. So I've changed my custombuild option to be mariadb instead of mysql.

However when I try to install mariadb via custombuild it says

"Automatic migration from MySQL 8.0
0.22 to MariaDB 10.6 is not supported. More info: "URL redacted"

I'm not sure where the 0.22 is coming from? Should I uninstall mysql completely via terminal and then attempt to install mariadb via custombuild?

Thank you all for your help so far.
 
Alright, I ended up completely wiping MySQL manually via root terminal. After that, then I was able to install mariadb and everything seems fixed.

While I still don't quite understand what happened with the initial MySQL installation, I wanted to post what I did in case others find this thread in the future.

Cheers!
 
You must log in or register to reply here.
Back
Top