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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
There is a behavior change between MySQL and MariaDB:
With:
CREATE DATABASE koha_kohadev;
CREATE USER koha_kohadev@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@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@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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
