[Bug 6276] New: Access denied for user ...@localhost
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6276 Bug #: 6276 Summary: Access denied for user ...@localhost Classification: Unclassified Change sponsored?: --- Product: Koha Version: unspecified Platform: All OS/Version: Linux Status: NEW Severity: normal Priority: P5 Component: Packaging AssignedTo: robin@catalyst.net.nz ReportedBy: dubyk@library.lviv.ua QAContact: koha-bugs@lists.koha-community.org I create Koha-instance with command sudo koha-create --create-db eng_marc21 Since I have several instances, I have slightly edited Apache-files ~~~~ <VirtualHost *:3003> ServerName eng_marc21:3003 <VirtualHost *:3333> ServerName eng_marc21:3333 ~~~ Listen 3003 Listen 3333 ~~~ Then when I try to access the web-installer I got this error: Software error: Access denied for user 'koha_eng_marc21'@'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. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. To get rid of this error I had to execute the following commands (it is my grant.sh): MysqlRootPassword=myrootmysqlpass KohaDB=koha_eng_marc21 KohaDBuser=koha_eng_marc21 KohaDBpassword=mykohadbpass sudo mysql -uroot -p$MysqlRootPassword $KohaDB -e "GRANT ALL ON $KohaDB.* TO '$KohaDBuser'@'localhost' IDENTIFIED BY '$KohaDBpassword'; flush privileges;" sudo /etc/init.d/mysql restart -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6276 --- Comment #1 from Robin Sheat <robin@catalyst.net.nz> 2011-04-29 00:57:45 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6276 --- Comment #2 from Serhij Dubyk <dubyk@library.lviv.ua> 2011-05-05 08:43:53 UTC --- (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=... ? -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6276 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #3 from Owen Leonard <oleonard@myacpl.org> --- This bug is two years old with no new comments. I'm assuming it is no longer relevant. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org