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

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

Page 3 of 4
  1. ikrudolf

    ikrudolf Member

    I get this:

     
    ikrudolf, Sep 22, 2009
    #41
  2. ikrudolf

    ikrudolf Member

    Any ideas to get user ispconfig back in?
     
    ikrudolf, Sep 23, 2009
    #42
  3. damir

    damir New Member

    You can always add the user through phpmyadmin, don't forget to reload privileges after user is added.
     
    damir, Sep 23, 2009
    #43
  4. ikrudolf

    ikrudolf Member

    (I was using the skip grant option)
    I added the user ispconfig via phpmyadmin, used the password found in /usr/local/ispconfig/interface/lib/config.inc.php

    Flushed privileges. Restarted mysql. But now the password for ispconfig is changed? And my sites are extremely slow. Also for example site/phpmyadmin is not available or takes very long.
    I changed back to the skip grant t option. I think I will reinstall my server from scratch.
     
    Last edited: Sep 23, 2009
    ikrudolf, Sep 23, 2009
    #44
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Why shall it has been changed? The ispconfig password is in /usr/local/ispconfig/interface/lib/config.inc.php and the password is in cleartext. So if you add it in phpmyadmin, you have to choose "PASSWORD" to encrypt it.

    Regarding the slow server, you should test if the login for the ispconfig user works now and if thats the case, then reboot your server.
     
    till, Sep 24, 2009
    #45
  6. ikrudolf

    ikrudolf Member

    Sorry Till I was unclear.

    I added the user ispconfig via phpadmin and used the password like mentioned in the config.inc.php file.

    After that when I want to login to ispconfig control panel it sais access denied for admin with the same password I always used before.

    Rudolf.
     
    ikrudolf, Sep 24, 2009
    #46
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    Have you tested that you are able to login to the mysql database and switch to the ispconfig database with the username "ispconfig" and the password from the file? You can test this with the mysql command or phpmyadmin.
     
    till, Sep 24, 2009
    #47
  8. ikrudolf

    ikrudolf Member

    I get access denied.
    How can I grant access to dbispconfig for user ispconfig?

    I was looking in phpmyadmin (under dbispconfig, permissions) but there I can't add user ispconfig for db dbispconfig.

    Cheers,
    Rudolf.

    Os should I set "ALL PRIVILEGES" for user ispconfig?
     
    ikrudolf, Sep 24, 2009
    #48
  9. ikrudolf

    ikrudolf Member

    Under the user settings of user ispconfig I "GRANT" the user ispconfig to use the db dbispconfig. Is this enough?

    I flushed privileges and I restarted mysql. But I still get this error at the login of the ispconfig controlpanel:

    I checked and now I can use DB in mysql with user ispconfig, I don't get access denied message.
     
    Last edited: Sep 24, 2009
    ikrudolf, Sep 24, 2009
    #49
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    Should be ok but please test it, you will see if you can enter to the ispconfig database with phpmyadmin.
     
    till, Sep 24, 2009
    #50
  11. ikrudolf

    ikrudolf Member

    Via phpadmin, logged in as user "ispconfig" I can enter the database "ispconfig".

    But at the the ispconfig control panel still

    when I try to login as admin.
     
    ikrudolf, Sep 24, 2009
    #51
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    Then look at the dbispconfig database, is there a user with username "admin" in the sys_user table? If yes, try to set a new password. The password has to be encrypted with "md5".
     
    till, Sep 24, 2009
    #52
  13. ikrudolf

    ikrudolf Member

    I reset the admin password in md5 in phpmyadmin.
    But now I see that none of the users can login into the ispconfig control panel?
     
    ikrudolf, Sep 24, 2009
    #53
  14. till

    till Super Moderator Staff Member ISPConfig Developer

    And does the password work afetr you reset it?
     
    till, Sep 24, 2009
    #54
  15. ikrudolf

    ikrudolf Member

    No nobody can login.
    Also admin after reset can still nog login.
     
    ikrudolf, Sep 24, 2009
    #55
  16. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, then I guess there must be still a permission problem with the ispconfig mysql user.
     
    till, Sep 24, 2009
    #56
  17. ikrudolf

    ikrudolf Member

    OK but I can connect with user ispconfig to the db dbispconfig via mysql and in phpmyadmin. Now the ispconfig user is granted "USAGE" of the dbispconfig. Should I change this to "ALL PRIVILEGES"? And how do I do this?
     
    ikrudolf, Sep 24, 2009
    #57
  18. till

    till Super Moderator Staff Member ISPConfig Developer

    The ispconfig user is connecting only to the ispconfig database. I'am not sure if the problem can be solved witthout more debugging of the mysql connections
     
    till, Sep 24, 2009
    #58
  19. ikrudolf

    ikrudolf Member

    Did this file change on new version of ISPconfig3?
    /usr/local/ispconfig/server/lib/config.inc.php
     
    ikrudolf, May 7, 2010
    #59
  20. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes. But not the values within that file as the updater copies the values from the old file to the new file during update.
     
    till, May 7, 2010
    #60
Page 3 of 4

Share This Page