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.
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.
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.
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,
