Hello I need some urgent help with a big problem. Somebody made a user with the name admin in ISPConfig, and then deleted the user. Now I cannot logon as admin anymore. I can still logon as administrator users for each domain. Any idea how I get my admin user back?
Execute this SQL statement in the ispconfig database. The login is user: admin, password: admin Code: INSERT INTO `sys_user` (`doc_id`, `doctype_id`, `groupid`, `username`, `passwort`, `pwcl`, `design`, `gueltig`, `language`, `mailmax`, `bookmark_order`, `email`, `news`, `modul`, `nav_color`, `box_color`, `site`, `domain`, `perms`, `modules`, `anrede`, `vorname`, `name`, `strasse`, `plz`, `ort`, `telefon`, `fax`, `email_home`, `alter1`, `woher`, `land`, `passwortRecover`, `newsletter`, `userid`) VALUES (1, 1, 0, 'admin', '21232f297a57a5a743894a0e4a801fc3', '', 'blau', 1, 'en', 5120000, 1, 'admin', 1, 'isp', '123456', 'E4E4E4', 'ISPConfig', 'ispconfig.de', 'rwa', 'sys,isp,dns,isp_file,isp_fakt,tools,help', 'Herr', '', '', '', '', '', '', '', '', '', '', 'Deutschland', '', 0, 1);
Thank you for superfast reply I got error running this, "#1062 - Duplicate entry '1' for key 1 " Any idea? It`s a old MY SQL version (4.1.16) might this be the problem?
Then your admin user has not been deleted. You can try to rest the password for the admin user, the password is md5 encrypted. No.
