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

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

Page 2 of 4
  1. till

    till Super Moderator Staff Member ISPConfig Developer

    Please see my post above for the instructions in case that the uninstall script fails.
     
    till, Sep 15, 2009
    #21
  2. ikrudolf

    ikrudolf 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.
     
    ikrudolf, Sep 15, 2009
    #22
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
    till, Sep 16, 2009
    #23
  4. ikrudolf

    ikrudolf 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
    ikrudolf, Sep 16, 2009
    #24
  5. ikrudolf

    ikrudolf 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:
     
    ikrudolf, Sep 17, 2009
    #25
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
    till, Sep 17, 2009
    #26
  7. ikrudolf

    ikrudolf 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
    ikrudolf, Sep 17, 2009
    #27
  8. ikrudolf

    ikrudolf 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?
     
    ikrudolf, Sep 19, 2009
    #28
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
    till, Sep 21, 2009
    #29
  10. ikrudolf

    ikrudolf 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
    ikrudolf, Sep 21, 2009
    #30
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
    till, Sep 21, 2009
    #31
  12. ikrudolf

    ikrudolf 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?
     
    ikrudolf, Sep 21, 2009
    #32
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, then you will have to copy back your backup of the mysql usertable.
     
    till, Sep 21, 2009
    #33
  14. ikrudolf

    ikrudolf Member

    Till,
    I imported the last mysql table backup dump but still the access denied messages on ispconfig control panel.
     
    ikrudolf, Sep 21, 2009
    #34
  15. till

    till Super Moderator Staff Member ISPConfig Developer

    Have you reloaded mysql?
     
    till, Sep 21, 2009
    #35
  16. ikrudolf

    ikrudolf Member

    Yes I restarted mysql.

     
    ikrudolf, Sep 21, 2009
    #36
  17. ikrudolf

    ikrudolf Member

    Any other ideas?
     
    ikrudolf, Sep 22, 2009
    #37
  18. till

    till Super Moderator Staff Member ISPConfig Developer

    till, Sep 22, 2009
    #38
  19. ikrudolf

    ikrudolf 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:

     
    ikrudolf, Sep 22, 2009
    #39
  20. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
    till, Sep 22, 2009
    #40
Page 2 of 4

Share This Page