Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 10th September 2010, 11:02
ratson ratson is offline
Junior Member
 
Join Date: Sep 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Question 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.

rs
Reply With Quote
Sponsored Links
  #2  
Old 10th September 2010, 11:30
ratson ratson is offline
Junior Member
 
Join Date: Sep 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default

actually there were some inconsistencies which i manually resolved, but the MySQL setting is still missing.
Reply With Quote
  #3  
Old 10th September 2010, 11:37
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,964
Thanks: 825
Thanked 5,366 Times in 4,213 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
ratson (10th September 2010)
  #4  
Old 10th September 2010, 11:49
ratson ratson is offline
Junior Member
 
Join Date: Sep 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Unhappy

Quote:
Originally Posted by till View Post
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...

Last edited by ratson; 10th September 2010 at 11:57.
Reply With Quote
  #5  
Old 10th September 2010, 11:59
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,964
Thanks: 825
Thanked 5,366 Times in 4,213 Posts
 
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Tags
bug, config, error

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Customer Web Site: index.php with mysql queries take 18 seconds to load! Jcorrea920 General 4 29th December 2006 03:38
Site with MySQL problem?! edge Server Operation 2 13th August 2006 19:57
Can not enable Frontpage extensions / mySQL for the site Hans General 2 13th July 2006 13:30
after web-form edit, site creation from hostingplan gives wrong values raveneye Installation/Configuration 2 7th November 2005 00:51


All times are GMT +2. The time now is 03:19.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.