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...
Please select the protocol (http or https (SSL encryption)) to use to access the ISPConfig system:
Your Choice: 1
Connected successfully to MySQL server
sh: ee94: command not found (** ee94 was part of the password I entered**)
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
and log in:
Thanks for looking!