HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   Server DB deleted (http://www.howtoforge.com/forums/showthread.php?t=35393)

Falrish 23rd May 2009 17:02

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.

till 23rd May 2009 17:41

Noone can login where?

Falrish 23rd May 2009 23:14

Quote:

Originally Posted by till (Post 190094)
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.

till 24th May 2009 09:05

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.

Falrish 24th May 2009 17:22

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,


All times are GMT +2. The time now is 21:24.

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