I've just installed ISPConfig 2 - well nearly anyway. Ubuntu 10.04 Server. In the last few steps where it asks for the MYSQL details, I entered a \ in the password accidentally. This has the result of the insaller being unable to create the required databases and as a result there is no user table and I can't login to ISPConfig.... Without uninstalling and re-installing from scratch, can I manually create the required tables or preferably, is there a scrip to do this? Here's the output from the last few steps of the install process... Code: Please select the protocol (http or https (SSL encryption)) to use to access the ISPConfig system: 1) HTTPS 2) HTTP Your Choice: 1 Connected successfully to MySQL server sh: ee94: command not found [COLOR="Red"](** ee94 was part of the password I entered**)[/COLOR] ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) no crontab for root Restarting some services... * Stopping Postfix Mail Transport Agent postfix [ OK ] * Starting Postfix Mail Transport Agent postfix [ OK ] * Stopping ftp server proftpd [ OK ] * Starting ftp server proftpd [ OK ] Starting ISPConfig system... /root/ispconfig/httpd/bin/apachectl startssl: httpd started Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47 No results found!ISPConfig system is now up and running! Congratulations! Your ISPConfig system is now installed. If you had to install quota, please take the steps described in the installation manual. Otherwise your system is now available without reboot. Please direct your browser to ERROR 1146 (42S02) at line 1: Table 'db_ispconfig.sys_user' doesn't exist https://example1.domainname.com:81 and log in: Username: admin Password: xyz123 Thanks for looking! -v3
You have to rerun the ispconfig installation as the mysql datbase is populated with server specific details,so you cant load the data from a sql dump manually.
Delete the directories /root/ispconfig and /home/admispconfig, the ispconfig mysql database, then unpack the ispconfig.tar.gz and run the setup script.
