Tried installing ISPConfig using this article The Perfect Server (CentOS 7...), the VPS is running CentOS 7.7. When the installation is complete, I access the GUI using the admin account (which is the only available account being a fresh install). I want to use the ISPConfig Migration Toolkit to migrate everything from an older server. When I go to System > Remote Users, I get the following error: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation But that is not the only place I get that error, even when going to Monitoring > Show System-Log, Show Jobqueue, Show Data Log History; DNS > Zones, Secondary DNS-Zones; Support > Send Message, etc. What is happening in there? any idea how do I fix it? Or is it better to start from scratch (reinstall OS, etc). Thanks, Ronald
Please try a forced ISPConfig update by using these Code: cd /tmp wget http://www.ispconfig.org/downloads/ISPConfig-3.1.15.tar.gz tar xvfz ISPConfig-3.1.15.tar.gz cd ispconfig3_install/install php -q update.php commands, choose 'yes' when the updater asks to reconfigure services, to see if the updater is able to fix the issue.
Yes. That's the reason I proposed a manual update as the normal update script would just say that your server is up to date.
I just googled the error message, I thought it was the ispconfig super admin error but in fact, it is an error from mysql. Might be related to something that's new in CentOS 7.7 as the guide is for centOS 7.6. Try to run this sql command as mysql root user in mysql. Login to mysql on the shell with: mysql -u root -p and then run these sql queries: GRANT SUPER ON *.* TO ispconfig@localhost; GRANT SUPER ON *.* TO [email protected];
And one more question, did you install mariadb-server as described in the tutorial, or did you install mysql instead or did you add a different source to get a newer mysql or mariadb version?
Ok, then you know the fault now. Please follow installation instructions and install the software described there to get a fully working system, your decision to use an unsupported MySQL version caused this and you will get probably other failures as well in future, MySQL 8 is not completely downwards compatible to older MySQL releases, so software that is written to support older MySQL versions will not fully work on your server, only software developed specifically for MySQL 8 will work flawlessly.
Till, thanks for the feedback. will try it as soon as possible. Btw, is there a road-map when will MySQL 8 be supported?
ISPConfig supports the software versions that ship with the supported Linux distributions. When MySQL is shipped as default version with a supported Linux Distribution, then we will add support for it in ISPConfig.
One last question, hopefully. What is the recommended path when migrating from an old ISPConfig server running MySQL 5.5 using the migration toolkit?
The path is one hop. You have old system, run migrator there and it migrates to the new system. The version of MySQL on the old host does not matter. You just need to have an ISPConfig setup that works so you can run the migrator there.
Wow that's terrific! Thought maybe I had to upgrade MySQL data manually before running the migration tool. Giving it a try right now. Thanks for the feedback!
