#1  
Old 23rd May 2009, 17:02
Falrish Falrish is offline
Junior Member
 
Join Date: May 2009
Location: Canada
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Falrish Send a message via MSN to Falrish Send a message via Yahoo to Falrish
Default Server DB deleted

Hello,

I am running CentOS 4 with ISPConfig 2 and accidentally, the system database was deleted. Now no one can log in again. I followed the steps shown on http://www.howtoforge.com/forums/showthread.php?t=161 and even tried adding to the isp_isp_user table. However, none of this seems to work. I ensured it is pointing to the correct database as well. Any thoughts on what else could be the problem?

Any thoughts would be great help.
Reply With Quote
Sponsored Links
  #2  
Old 23rd May 2009, 17:41
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,409
Thanks: 834
Thanked 5,496 Times in 4,326 Posts
Default

Noone can login where?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 23rd May 2009, 23:14
Falrish Falrish is offline
Junior Member
 
Join Date: May 2009
Location: Canada
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Falrish Send a message via MSN to Falrish Send a message via Yahoo to Falrish
Default

Quote:
Originally Posted by till View Post
Noone can login where?
I am attempting to re-populate the database and the Admin user will not take. I have attempted straight password, PASSWORD('password') and MD5('password') for the admin password and it did not work any of these times. What I need is a push in the right direction to get the Admin user back online so I can rebuild the minimal settings I had already before the database was removed.
Reply With Quote
  #4  
Old 24th May 2009, 09:05
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,409
Thanks: 834
Thanked 5,496 Times in 4,326 Posts
Default

The admin user is in the sys_user table and not the isp_isp_user tabe. Adding the user there is not sufficient as you need several records like the doctypes and groups in other database tables. Also the server amd server_ip table have to be populated with values that are specific to your installation. Must of the records can be found in the sql dump which is in the ispconfig tar.gz but the server record is only created dynamically based on the setup of your server.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 24th May 2009, 17:22
Falrish Falrish is offline
Junior Member
 
Join Date: May 2009
Location: Canada
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Falrish Send a message via MSN to Falrish Send a message via Yahoo to Falrish
 
Default

So if I take the .sql file I can edit it and ensure that all the information I need is in it. The isp_user table needs to have the admin user, do you have a sample dump of a running database that I can see(edited of course)? If you do would you mind sharing it with me?

Thanks,
Reply With Quote
Reply

Bookmarks

Tags
centos, database, error, ispconfig, login

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
Webmail problems with only one domain? compner Installation/Configuration 14 16th February 2010 16:59
apache2 won't connect to localhost or 127.0.0.1 anw Server Operation 6 19th March 2009 18:51
procmail problem - mail delivery Lobanak Installation/Configuration 4 1st March 2009 22:24
What can be wrong martin_rudowicz Installation/Configuration 9 11th May 2008 19:42
Problems with Postfix Mysql Courier PatrickAdrichem Installation/Configuration 3 13th April 2007 15:44


All times are GMT +2. The time now is 17:41.


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