Changing defaut login "admin"

Discussion in 'General' started by crisarno, Feb 15, 2017.

  1. crisarno

    crisarno New Member

    Helllo,

    I'm new on this forum and also in using ISP Config 3... :(

    The version i'm using is 3.0.5.4p8 and i'm afraid to have made a mistake by changing the default login "admin" by another word.
    Now, when i'm logging using my new login, i don't have acces any more to users configuration.
    Is there a way to solve this ?

    thanks a lot for any help.
    Christophe

    As i'm a newbie, is there a place on this forum where i can introduce myself ?
     
  2. sjau

    sjau Local Meanie Moderator

    you could alter the username "non-admin" to "admin" directly in the db. The username is not hashed so direct edit should work - never tried though.
     
    crisarno likes this.
  3. crisarno

    crisarno New Member

    Hi Sjau, thanks a lot for this quick reply, i'll try this
    i have an other question which may look silly, but i have only one db on my server working with the hosted website,
    is it in this one or there is another one especially for ispconfig ?
     
  4. sjau

    sjau Local Meanie Moderator

    there is one for ispconfig.. by default it's dbispconfig I think.
     
  5. crisarno

    crisarno New Member

    Thanks, i can easily acces to the one linked to my website using phpmyadmin,
    but i cannot find any to acces to the ispconfig db, is there a different way from the control panel ?
     
  6. sjau

    sjau Local Meanie Moderator

    did you login as root?
     
  7. crisarno

    crisarno New Member

    Last edited: Feb 15, 2017
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Changing the name of the admin user in ISPConfig is ok under System > CP Users. But maybe you accidently changed the type to user or another setting of the user so he lost admin privileges.

    To check the user in the database, you have to login as MySQL root user in phpmyadmin.
     
  9. crisarno

    crisarno New Member

    Hi Till,
    ok i understand, thanks a lot !
    that's fine if i can access through phpmyadmin, i thought i need to use a SSH console
     
  10. crisarno

    crisarno New Member

    well, i can connect to phpmyadmin as root,
    in the table "sys_user", "sys_perm_user" and "sys_perm_group" are set to "riud", just like a user
    do you know the term to use to set rights to admin ?
    Thanks in advance
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    that's ok.

    Is the type set to admin?
     
  12. crisarno

    crisarno New Member

    yes, the type is set to admin
    and in "sys_group", description is set to "Administrators group"
     
    Last edited: Feb 15, 2017
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    Did you ry to change the username back to "admin", does it work then again?
     
  14. crisarno

    crisarno New Member

    Not yet, i'll try to do that and tell you what happen
     
  15. crisarno

    crisarno New Member

    well, i do the changes in the db, the good news is that my isp is still alive and i can connect using default login "admin"
    the bad one is that nothing change... may be i'm only missing a tab on the home page ?
    i have only
    Home / Client / Help / Email / Monitor / Sites / Tools / Vserver
    and compare to isp config demo, "System" is missing

    In "Sys_user" table, "modules section" i have only : dashboard,help,tools,monitor,sites,vm,mail,client
    May i add this module in db ?
     
  16. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes, the "admin" module is missing there. So your original problem was probably caused by that missing module and not the change of the name.
     
    crisarno likes this.
  17. crisarno

    crisarno New Member

    When i add the module "admin" in the db, it's working fine, i get back the missing tab.
    Now i know how to solve this issue, i try again to change default login name "admin" and when i do that change, in module section admin come unchecked... then if i save, i lost it !
    Thanks a lot for your help and your quick replies
    Have a nice day
     

Share This Page