Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 14th November 2006, 10:19
sn3f3ru sn3f3ru is offline
Junior Member
 
Join Date: Nov 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Deleted admin account

Hi,

I've done a very stupid mistake and deleted the admin account on a OS level.

Is there any way I can still access my ISPConfig?

I've tried recreating the username, but without success.

Thank you.
Reply With Quote
Sponsored Links
  #2  
Old 14th November 2006, 11:42
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,495
Thanks: 835
Thanked 5,534 Times in 4,352 Posts
Default

You mean the ISPConfig admin user in the mysql database? Do you have access to the database with e.g. phpmyadmin?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 14th November 2006, 12:38
sn3f3ru sn3f3ru is offline
Junior Member
 
Join Date: Nov 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

the ISPConfig admin; I have access to the database (no phpmyadmin, but console).
Reply With Quote
  #4  
Old 14th November 2006, 12:50
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,495
Thanks: 835
Thanked 5,534 Times in 4,352 Posts
Default

Quote:
Originally Posted by sn3f3ru
the ISPConfig admin; I have access to the database (no phpmyadmin, but console).
Please run this SQL command in the ISPConfig database to get a new admin user:


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);
The password is "admin".
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 14th November 2006, 13:03
sn3f3ru sn3f3ru is offline
Junior Member
 
Join Date: Nov 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Many thanks Till, this did the trick.

Have a nice day.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Update] admin account adriaan Installation/Configuration 23 23rd August 2006 15:54
overall admin ftp account whitty Installation/Configuration 3 17th May 2006 00:17
can ispconfig account tables become corrupted? darthpaul General 3 24th March 2006 19:58
clamav functionality domino Technical 5 16th February 2006 15:10
The reseller was not deleted. Hellbound General 2 6th September 2005 11:05


All times are GMT +2. The time now is 22:54.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.