installer.pl fails when connecting to remote database?

[Mothra]

Not sure if this is a PEBKAC error, or a bug I should be reporting...

I'm setting up a new OTRS 3.0.4 system, but with MySQL running on a separate server 10.30.0.18. I've allowed root access from the OTRS server (10.30.0.17) and can verify this by connecting as root via the MySQL command line client.

However, when I try to run the installer.pl, everything works except the very last step:

Code: Select all

Creating database 'otrs':   Done.
Creating tables 'otrs-schema.mysql.sql':   Done.
Inserting initial inserts 'otrs-initial_insert.mysql.sql':   Done.
Foreign Keys 'otrs-schema-post.mysql.sql':   Done.
Creating database user 'otrs@localhost':   False! :-(
       ---==> Access denied for user 'root'@'10.30.0.17' to database 'otrs'

This error seems quite obvious, except that I can connect to the database 'otrs' as root, from 10.30.0.17 using the command-line client. Also, as I can't get past this screen, I can't proceed with the rest of the install, so will have to go through the tedious process of configuring everything else by hand

Unless, of course, I've missed something obvious/done something stupid?

[crythias]

You're the second person who's posted about that Access denied error.

Kernel/Modules/Installer.pm is trying to do this:

Code: Select all

 !$DBH->do(
                    "GRANT ALL PRIVILEGES ON $DB{Database}.* TO $DB{DatabaseUser}\@$DB{NewHost} IDENTIFIED BY '$DB{DatabasePw}' WITH GRANT OPTION;"

[crythias]

"NewHost" is defined in Installer.pm from asking for this ...

Code: Select all

 $DB{NewHost}      = $Self->{ParamObject}->GetParam( Param => 'OTRSDBConnectHost' ) || '';

Which is obtained from the InstallerDBStart.dtl here:

Code: Select all

 <label for="OTRSDBConnectHost">$Text{"DB--- host"}:</label>
                    <div class="Field">
                        <input type="text" id="OTRSDBConnectHost" name="OTRSDBConnectHost" value="localhost" class="W25pc"/>