[Koha-bugs] [Bug 16690] New: Installing DB on remote server fails without *.* permissions

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16690

            Bug ID: 16690
           Summary: Installing DB on remote server fails without *.*
                    permissions
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Installation and upgrade (command-line installer)
          Assignee: mtompset at hotmail.com
          Reporter: mtompset at hotmail.com
        QA Contact: testopia at bugs.koha-community.org

KohaDB: 192.168.71.250

> CREATE DATABASE koha_ils;
> GRANT ALL ON koha_ils.* TO 'kohauser'@'192.168.71.251' IDENTIFIED BY 'kohapass';
> FLUSH PRIVILEGES;
> QUIT;

KohaApp: 192.168.71.251
Do an install.
Hack the kohaconf username, hostname, passwords to match.
Try to run the web install steps.
You will get told you don't have enough permissions.
Why? Because 'hostname' is 192.168.71.250 to connect to the DB, but the app
server is 192.168.71.251, and you should be checking against those GRANTS in
installer/install.pl around line 116.

Hacked in a <webserver> tag to the kohaconf
and used that value instead in the script. Everything works.

-- 
You are receiving this mail because:
You are watching all bug changes.