Final steps of installation failed (wrong mysql details)

Discussion in 'Installation/Configuration' started by vector3, Mar 1, 2012.

  1. vector3

    vector3 New Member

    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
     
  2. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    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.
     
  3. vector3

    vector3 New Member

    From scratch? Uninstall and remove the directories?
     
  4. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

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

    vector3 New Member

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

Share This Page