Multi-server Setup: package for mail,sql and web/ftp

Discussion in 'Installation/Configuration' started by itanium, Sep 5, 2009.

  1. till

    till Super Moderator

    Please see my post above for the instructions in case that the uninstall script fails.
     
  2. skoena

    skoena Member

    Sometimes I feel I have too little experience with linux :)
    How can I delete the ispconfig user in the mysql.user table?

    When I connect to the main server I don't find a mysql.user table.
     
  3. till

    till Super Moderator

    The easiest way is to use phpmyadmin. Every mysql database server has a database called mysql and it must contain several tables incl. a user table.
     
  4. skoena

    skoena Member

    I deleted the mysql.user table. But now I can't login to mysql anymore all users are denied even root.
    Help.... how to restore the mysql.user database without access to mysql??
     
    Last edited: Sep 17, 2009
  5. skoena

    skoena Member

    What I have done to fix it.
    Edited the /etc/mysql/my.cnf file. I have added
    after
    . Restarted the mysql server
    I now was able to get into mysql without login and password. I imported the backupped mysql.user table. Deleted the "skip-grant-tables" from the my.cnf file. Rebooted the server and everyting was fine again. Phoeffffff.

    Another question now. What should I delete from the mysql.user table. I know now not the whole table. :rolleyes:
     
  6. till

    till Super Moderator

    Please delet just the record for the user named "ispconfig" instead of the complete table. Look also trough all other tables in the database "mysql" and delete records were the username is "ispconfig". Then restart mysql.
     
  7. skoena

    skoena Member

    Sorry for my noob problems :)

    I find this in the DB table:
    *localhost dbispconfig ispconfig Y Y Y Y N N N N N N N N N N N N N
    *192.168.1.102 dbispconfig ispcsrv6 Y Y Y Y N N N N N N N N N N N N N
    *192.169.1.102 dbispconfig ispcsrv2 Y Y Y Y N N N N N N N N N N N N N
    *nameofhost dbispconfig ispcsrv6 Y Y Y Y N N N

    And this in the user table:
    *localhost ispconfig *password* N N N N N etc.
    *% ispconfig *password* Y Y Y Y etc.

    Please tell me what should I do?
     
    Last edited: Sep 19, 2009
  8. skoena

    skoena Member

    So if i'm right I should delete:
    **localhost dbispconfig ispconfig Y Y Y Y N N N N N N N N N N N N N from the DB table.
    And
    **localhost ispconfig *password* N N N N N etc.
    **% ispconfig *password* Y Y Y Y etc. from the USER table right?
     
  9. till

    till Super Moderator

    Delete all entry for the user with the name "ispconfig" and also all "ispcsrv" users (you did not mentioned that this is the master database of a multiserver setup. After you cleaned this up, yopu will ahve to reinstall all slave servers too.
     
  10. skoena

    skoena Member

    So I deleted all the entries mentioned.
    I reinstalled ispconfig via de 2nd server and selected expert setup.

    Everyting was installed succesfully. But when I want to logon to ispconfig now I get these mysql errors:

    What to do?

    Also I notice that my sites are very slow. Also to get into ispconfig is very slow and into /phpmyadmin as well. When I restart apache it's speed is normal but decreases within minutes.
     
    Last edited: Sep 21, 2009
  11. till

    till Super Moderator

    Please see my post above. If this is a multiserver setup, you have to reinstall all nodes incl. the master and the master has to be installed first. On a reinstall you will loose all settings.
     
  12. skoena

    skoena Member

    What to do next?

    OK I'm having to many newbie problems to get a second server installed. So I will cancel this at this moment. I now just want one server. The master server is allready installed, online and running. How will I be able to login again on the main server?
     
  13. till

    till Super Moderator

    Ok, then you will have to copy back your backup of the mysql usertable.
     
  14. skoena

    skoena Member

    Till,
    I imported the last mysql table backup dump but still the access denied messages on ispconfig control panel.
     
  15. till

    till Super Moderator

    Have you reloaded mysql?
     
  16. skoena

    skoena Member

    Yes I restarted mysql.

     
  17. skoena

    skoena Member

    Any other ideas?
     
  18. till

    till Super Moderator

  19. skoena

    skoena Member

    Till,
    I did the manual update. Restarted mysql after it. When i connect to the ispconfig control panel I get this error on top of the page:

     
  20. till

    till Super Moderator

    Please check if you are able to login to mysql with the login details in the file /usr/local/ispconfig/interface/lib/config.inc.php when you use the "mysql" command on the shell.
     

Share This Page