I downloaded the tarball, and used the single installation method. The computer I tested on is running Ubuntu 7.10. The command line portion of the installer appeared to work very well. When I got to the web portion I wasn't sure which username to use as there were 2 in the commandline portion. The one I tried first (kohauser) was the wrong one. Further along at step 3, the installer said it had all the required privileges on the database but on the next screen I got the following error message. ERROR 1142 (42000) at line 22: DROP command denied to user 'kohaadmin'@'localhost' for table 'accountlines' Sincerley, Bradley Peters
Hi, On 12/12/07, Bradley Peters <koha@moberley.com> wrote:
When I got to the web portion I wasn't sure which username to use as there were 2 in the commandline portion. The one I tried first (kohauser) was the wrong one.
OK, I'll work on the README to make that more clear.
Further along at step 3, the installer said it had all the required privileges on the database but on the next screen I got the following error message.
ERROR 1142 (42000) at line 22: DROP command denied to user 'kohaadmin'@'localhost' for table 'accountlines'
Odd, it should check for 'ALL PRIVILEGES' or for specific grants, including 'DROP'. Could you send me the output of the following mysql query: SHOW GRANT FOR 'kohaadmin'@'localhost'; Thanks, Galen -- Galen Charlton Koha Application Developer LibLime galen.charlton@liblime.com p: 1-888-564-2457 x709
On 12/12/07, Galen Charlton <galen.charlton@liblime.com> wrote:
Odd, it should check for 'ALL PRIVILEGES' or for specific grants, including 'DROP'. Could you send me the output of the following mysql query:
SHOW GRANT FOR 'kohaadmin'@'localhost';
Apparently kohaadmin is only granted SELECT. I guess I did something wrong when I created that database. Here is the reponse copied from the mysql shell (I just deleted the long "--" lines). + | Grants for kohaadmin@localhost | + | GRANT USAGE ON *.* TO 'kohaadmin'@'localhost' IDENTIFIED BY PASSWORD '*CAAD8B29D8D65D2737D51F1A3F726F262C5EE65E' | | GRANT ALL PRIVILEGES ON `mbom-test`.* TO 'kohaadmin'@'localhost' | | GRANT SELECT ON `koha`.* TO 'kohaadmin'@'localhost' | +
Hi, On 12/12/07, Bradley Peters <koha@moberley.com> wrote:
On 12/12/07, Galen Charlton <galen.charlton@liblime.com> wrote:
SHOW GRANT FOR 'kohaadmin'@'localhost';
Apparently kohaadmin is only granted SELECT. I guess I did something wrong when I created that database.
Here is the reponse copied from the mysql shell (I just deleted the long "--" lines).
[snipped]
OK, I see the problem now -- install.pl parses the output of 'SHOW GRANTS', but needs to be a little smarter about it. It was misinterpreting the 'ALL PRIVILEGES' grant on the other database as if it applied to the koha database. I'll work on a patch. In the meantime, if you fix the privileges and drop any objects that install.pl managed to create, you should be able to resume testing from the web installer. Regards, Galen -- Galen Charlton Koha Application Developer LibLime galen.charlton@liblime.com p: 1-888-564-2457 x709
On 12/12/07, Galen Charlton <galen.charlton@liblime.com> wrote:
In the meantime, if you fix the privileges and drop any objects that install.pl managed to create, you should be able to resume testing from the web installer.
I was certain that I had given kohaadmin all privileges, but obviously not. In any case, yes, once I fixed that the rest of the web installer worked fine. Thanks. Bradley Peters.
participants (2)
-
Bradley Peters -
Galen Charlton