HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials - After many updates site edit is broken (missing MySQL option)

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)

- General (http://www.howtoforge.com/forums/forumdisplay.php?f=15)

- - After many updates site edit is broken (missing MySQL option) (http://www.howtoforge.com/forums/showthread.php?t=48667)

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.

http://img828.imageshack.us/img828/1486/ispconfig.png

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.

rs

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.

Quote:

Originally Posted by till (Post 238929)

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.

thank you for the help, recreating the doctype table from script did it!

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

Code:

All prerequisites are fulfilled.

Here we go...



Connected successfully to db db_ispconfig

cp: stat "customized_templates/*" failed: No such file or directory

Restarting some services...

Stopping Postfix Mail Transport Agent: postfix.

Starting Postfix Mail Transport Agent: postfix.

Stopping ftp server: proftpd.

Starting ftp server: proftpd - setting default address to 127.0.0.1

.

Shutting down ISPConfig system...

/root/ispconfig/httpd/bin/apachectl stop: httpd (no pid file) not running

ISPConfig system stopped!

Starting ISPConfig system...

/root/ispconfig/httpd/bin/apachectl startssl: httpd started

ISPConfig system is now up and running!

Congratulations! Your ISPConfig system is now installed. If you had to install quota, please take the steps described in the installation manual. Otherwise your system is now available without reboot.

it looks ok to me...

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.