I deleted the admin user :(

[Hagforce]

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?

[till]

Execute this SQL statement in the ispconfig database. The login is user: admin, password: admin

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);

[Hagforce]

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?

[till]

Then your admin user has not been deleted. You can try to rest the password for the admin user, the password is md5 encrypted.

It`s a old MY SQL version (4.1.16) might this be the problem?

No.

[Hagforce]

Thank you, you were right, all is ok now :)