[Koha-bugs] [Bug 17513] New: koha-create does not set GRANTS correctly

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

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

            Bug ID: 17513
           Summary: koha-create does not set GRANTS correctly
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: ASSIGNED
          Severity: normal
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: jonathan.druart at bugs.koha-community.org
          Reporter: jonathan.druart at bugs.koha-community.org
        QA Contact: testopia at bugs.koha-community.org

There is a behavior change between MySQL and MariaDB:

With:
 CREATE DATABASE koha_kohadev;
 CREATE USER koha_kohadev at localhost IDENTIFIED BY 'password';
 CREATE USER koha_kohadev@'%' IDENTIFIED BY 'password';
 GRANT ALL PRIVILEGES ON koha_kohadev.* TO koha_kohadev;

Using Mysql, as admin user:
mysql> SHOW GRANTS FOR koha_kohadev@'localhost';
  GRANT USAGE ON *.* TO 'koha_kohadev'@'localhost' IDENTIFIED BY PASSWORD
'*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19'

mysql> SHOW GRANTS FOR koha_kohadev;
  GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD
'*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19'
  GRANT ALL PRIVILEGES ON `koha_kohadev`.* TO 'koha_kohadev'@'%'

Using Mysql, as koha_user user:

mysql> SHOW GRANTS FOR koha_kohadev@'localhost';
  GRANT USAGE ON *.* TO 'koha_kohadev'@'localhost' IDENTIFIED BY PASSWORD
<secret>

mysql> SHOW GRANTS FOR koha_kohadev;
  GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD <secret>
  GRANT ALL PRIVILEGES ON `koha_kohadev`.* TO 'koha_kohadev'@'%'


Using MariaDB, as admin user:
MariaDB [(none)]> SHOW GRANTS FOR kohaçkohadev at localhost;
  GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD
'*'2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19

MariaDB [(none)]> SHOW GRANTS FOR kohaçkohadev;
  GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD
'*'2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19
  GRANT ALL PRIVILEGES ON `koha_kohadev`.* TO 'koha_kohadev'@'%'

So all the same so far :)

But,
Using MariaDB, as koha_user user:
MariaDB [(none)]> SHOW GRANTS FOR kohaçkohadev at localhost;
  GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD
'*'2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19

MariaDB [(none)]> SHOW GRANTS FOR kohaçkohadev;
ERROR 1044 (42000): Access denied for user 'koha_kohadev'@'localhost' to
database 'mysql'

BOOM!
The installer does not parse the expected output and then raise an error.

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