Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 1st March 2012, 17:56
vector3 vector3 is offline
Junior Member
 
Join Date: Mar 2012
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Unhappy 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
Reply With Quote
Sponsored Links
  #2  
Old 1st March 2012, 18:08
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,036
Thanks: 841
Thanked 5,655 Times in 4,464 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
vector3 (1st March 2012)
  #3  
Old 1st March 2012, 18:14
vector3 vector3 is offline
Junior Member
 
Join Date: Mar 2012
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default

From scratch? Uninstall and remove the directories?
Reply With Quote
  #4  
Old 1st March 2012, 18:28
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,036
Thanks: 841
Thanked 5,655 Times in 4,464 Posts
Default

Delete the directories /root/ispconfig and /home/admispconfig, the ispconfig mysql database, then unpack the ispconfig.tar.gz and run the setup script.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 1st March 2012, 18:32
vector3 vector3 is offline
Junior Member
 
Join Date: Mar 2012
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

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

Bookmarks

Tags
incorrect password, ispconfig2, mysql connections, ubuntu 10.04

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
strange fail2ban behaviour > doesn't ban specific IP Djamu Server Operation 2 13th January 2012 03:29
Monitoring server Ubuntu wiss Installation/Configuration 7 20th November 2010 13:56
Sites stopped working Toucan Installation/Configuration 21 4th January 2010 00:27
MySQL installation roblem [/me sad] Nejko Installation/Configuration 16 11th January 2006 14:28
Failed at MySQL lhatle Installation/Configuration 4 29th November 2005 02:26


All times are GMT +2. The time now is 12:48.


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