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)
-   -   Final steps of installation failed (wrong mysql details) (http://www.howtoforge.com/forums/showthread.php?t=56395)

vector3 1st March 2012 16:56

Final steps of installation failed (wrong mysql details)
 
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 (** 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
https://example1.domainname.com:81

and log in:
Username: admin
Password: xyz123

Thanks for looking!

-v3

till 1st March 2012 17:08

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.

vector3 1st March 2012 17:14

From scratch? Uninstall and remove the directories?

till 1st March 2012 17:28

Delete the directories /root/ispconfig and /home/admispconfig, the ispconfig mysql database, then unpack the ispconfig.tar.gz and run the setup script.

vector3 1st March 2012 17:32

Ok, I'll do that. Thanks for your help.


All times are GMT +2. The time now is 09:42.

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