Loop in install.php after abort in case of mistype

Discussion in 'ISPConfig 3 Priority Support' started by muekno, Feb 23, 2015.

  1. muekno

    muekno Active Member HowtoForge Supporter

    i added a new server and did a mistake at the mysql entries, so I did a Ctrl-C.
    at the next try it looped here at line 417 in the install script
    //* Initialize the MySQL server connection
    if(@mysql_connect($tmp_mysql_server_host, $tmp_mysql_server_admin_user, $tmp_mysql_server_admin_password)) {
    $conf['mysql']['master_host'] = $tmp_mysql_server_host;
    $conf['mysql']['master_admin_user'] = $tmp_mysql_server_admin_user;
    $conf['mysql']['master_admin_password'] = $tmp_mysql_server_admin_password;
    $conf['mysql']['master_database'] = $tmp_mysql_server_database;
    $finished = true;
    } else {
    swriteln($inst->lng('Unable to connect to mysql server').' '.mysql_error());
    }
    } while ($finished == false);
    unset($finished);
    by reasking the questions.
    No /usr/local/ispconfig created yet
    No entry from the new server in the master database yet
    No ispconfig database in the new server
    Who to fix?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Check if there is already a user "ispconfig" in the local mysql database and delete it manually if it exists.
     
  3. muekno

    muekno Active Member HowtoForge Supporter

    There is no ispconfig user, only 3 root , for hosts localhost, 127.0.0.1 and ::1
    The external users on the master exists too
     
  4. muekno

    muekno Active Member HowtoForge Supporter

    FIXED I do not know how and why. I realized I could not login via command line from slave to master. The DB entries in mysql user where identical except host for all slaves. could log in from all slaves but not from the one mentioned above. I had a text file (cut and past from the manual, other IP addresses, hostnames, password) with the mysql commands from where I cut paste the sql command to the mysql command line. I deleted the entry for the problem host in phpMyAdmin und did a cut and paste, for the problem host, from the text file to mysql command line. Comparing screen shots from before an now no difference, but login works, adding slave host to master works too.
    Sorry to disturb you
    Thank you
    Rainer
     

Share This Page