Installation error: Path to MySql is incorrect"

[Borofkin]

Hi all,

I get the following error when running the installation script:

======================
ERROR: Missing or invalid...

Path to MySql is incorrect (tried 'C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql')
======================

The path is correct and there is definitely a mysql.exe at that location. Any ideas?

I'm running Windows Server 2003, IIS 6.0, PHP 5.2, MySQL5.

Regards,
Dave.

[Sean.mcclowry]

Hi Dave,

Can you please try with a \ after the directory, e.g.:

Code: Select all

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql\

Sean

[Andreas.rindler]

have you tried adding another \ at the end of the path?

[Borofkin]

The path that I'm using is "C:\Program Files\MySQL\MySQL Server 5.0\bin\" -- it already has a trailing backslash. The "mysql" part is added by the installation script -- I assumed it was the executable it was looking for.

I also tried with forward slashes and double backslashes, with the same result.

Why does it need that path anyway? What would I do if I was using a separate database server?


Dave.

[Andreas.rindler]

The build.php script imports all databases and needs the path.

Code: Select all

 
foreach( $aDbs as $sDb ){
    $sCommand = "$sMySqlExecutable "
              . "-h {$build['omcollab_db_hostname']} "
              . "-u {$DbIni[$sDb]['Username']} "
              . "-p{$DbIni[$sDb]['Password']} "
              . "{$DbIni[$sDb]['Database']} < "
              . realpath("_InstallationResources/om{$sDb}_temp.sql");
    echo " * Building $sDb database {$DbIni[$sDb]['Database']} for {$DbIni[$sDb]['Username']}/{$DbIni[$sDb]['Password']}\n";
    exec( $sCommand, $aOutput );
    $aExecResults[$sCommand][] = $aOutput;
  }


I don't know how you would set up a separate db server. But presumably you would have some URI?!

I don't know why you are getting the error if you have the correct path and executable as you say. The message comes from here, where the install script can't find the executable:

Code: Select all

#path to mysql binary ('nix) or exe (win)
$path_to_mysql    = $expected_args['mysql_path'];
$sMySqlExecutable = "{$path_to_mysql}mysql" . ( $is_windows ? '.exe' : '' );
if( ! $preserve_data ){
    #verify location of mysql executable
    if( ! file_exists( $sMySqlExecutable ) || is_dir( $sMySqlExecutable ) ){
        $aErrors[] = "Path to MySql is incorrect (tried '$sMySqlExecutable')";
    }
}

[Borofkin]

The fact that my error message contains "mysql" instead of "mysql.exe" suggests that the script isn't properly detecting the OS type. I'll take a closer look at this today...