After many updates site edit is broken (missing MySQL option)
Hi forum members,
i am a long time ispconfig user, and i am very satisfied with it.
recently i came into a problem namely when i wanted to add a mysql enabled site i just couldn't create the db user, than i found out that on the settings page the MySQL option is missing (hopefully the attached screenshot describes it well). I have started using ISPConfig years ago and upgraded since that many times, yesterday i upgraded to the most recent release version, but the problem was not solved.
please let me know if i can provide you additional information, i will now start to compare a brand new database to my current one and see if there are structural differences. i will report back when ready, please let me know if you have a good idea how i could fix this.
actually there were some inconsistencies which i manually resolved, but the MySQL setting is still missing.
This might happen if the doctype in the database is corrupted or the doctype does not match the installed ispconfig version. Download the latest isponfig 2.x version and run the update again.
i think the problem with my updates is that the mysql user running the update scripts doesn't have the needed rights to process the script properly. i have just checked and the user has:
-all the rights to db_ispconfig,
-reload, show_db and create_user privilages on Server
-every right except drop on all databases
-every right on information_schema
-every right on mysql
is this correct?
here is the end of yesterdays update log
The mysql user that is used for ispconfig has to be the root user or a suer that has the exact same permissions then the root user, otherwise several functions in ispconfig will fail incl. updates.
|All times are GMT +2. The time now is 21:56.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.