Summary: | Access denied for user ...@localhost | ||
---|---|---|---|
Product: | Koha | Reporter: | Serhij Dubyk <dubyk> |
Component: | Packaging | Assignee: | Robin Sheat <robin> |
Status: | CLOSED FIXED | QA Contact: | Bugs List <koha-bugs> |
Severity: | normal | ||
Priority: | P5 - low | CC: | dubyk |
Version: | unspecified | ||
Hardware: | All | ||
OS: | Linux | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: |
Description
Serhij Dubyk
2011-04-28 08:38:00 UTC
Do you see any errors when you run koha-create? The database creation process is: CREATE DATABASE \`$mysqldb\`; CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd'; GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`; FLUSH PRIVILEGES; I'm not sure what situation there would be where half of this works, but the grant fails however. (In reply to comment #1) > Do you see any errors when you run koha-create? Action log: # koha-create --create-db test Koha instance is empty, no staff user created. Enabling site test. Run '/etc/init.d/apache2 reload' to activate new configuration! Restarting web server: apache2apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName ... waiting apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName . Starting Zebra server for test All log from /var/log/koha/test/ are empty. /var/log/syslog: only May 5 10:55:01 Vognyk /USR/SBIN/CRON[21798]: (root) CMD (test -x /usr/sbin/koha-rebuild-zebra && koha-rebuild-zebra $(koha-list --enabled)) May 5 10:57:44 Vognyk Koha Zebraqueue [1924]: failed to connect to DB: (but, maybe, it is not connected with koha-create) #firefox http://127.0.0.1:2222/ Software error: Access denied for user 'koha_test'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 692. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 33. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 33. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 23. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 23. /var/log/koha/test/intranet-error.log: [Thu May 05 11:25:58 2011] [error] [client 127.0.0.1] [Thu May 5 11:25:58 2011] VirtualShelves.pm: DBI connect('dbname=koha_test;host=localhost;port=3 306','koha_test',...) failed: Access denied for user 'koha_test'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 692 [Thu May 05 11:25:58 2011] [error] [client 127.0.0.1] [Thu May 5 11:25:58 2011] mainpage.pl: Access denied for user 'koha_test'@'localhost' (using pas sword: YES) at /usr/share/koha/lib/C4/Context.pm line 692. [Thu May 05 11:25:58 2011] [error] [client 127.0.0.1] [Thu May 5 11:25:58 2011] mainpage.pl: Compilation failed in require at /usr/share/koha/lib/C4/A uth.pm line 33. [Thu May 05 11:25:58 2011] [error] [client 127.0.0.1] [Thu May 5 11:25:58 2011] mainpage.pl: BEGIN failed--compilation aborted at /usr/share/koha/lib/ C4/Auth.pm line 33. [Thu May 05 11:25:58 2011] [error] [client 127.0.0.1] [Thu May 5 11:25:58 2011] mainpage.pl: Compilation failed in require at /usr/share/koha/intranet /cgi-bin/mainpage.pl line 23. [Thu May 05 11:25:58 2011] [error] [client 127.0.0.1] [Thu May 5 11:25:58 2011] mainpage.pl: BEGIN failed--compilation aborted at /usr/share/koha/intr anet/cgi-bin/mainpage.pl line 23. I'm not very perfect with MySQL but why not use creation db and grant exactly as mentioned in http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=INSTALL.debian;hb=HEAD ? This bug is two years old with no new comments. I'm assuming it is no longer relevant. |