After many updates site edit is broken (missing MySQL option)

Discussion in 'General' started by ratson, Sep 10, 2010.

  1. ratson

    ratson New Member

    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.

    [​IMG]

    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
     
  2. ratson

    ratson New Member

    actually there were some inconsistencies which i manually resolved, but the MySQL setting is still missing.
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  4. ratson

    ratson New Member

    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: Sep 10, 2010
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     

Share This Page