[Bug 37971] New: Koha Bug Report: Database Access Error During Upgrade 24.05
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37971 Bug ID: 37971 Summary: Koha Bug Report: Database Access Error During Upgrade 24.05 Change sponsored?: --- Product: Koha Version: 24.05 Hardware: PC OS: Linux Status: NEW Severity: critical Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: mdmiansarilib@gmail.com QA Contact: testopia@bugs.koha-community.org Created attachment 171818 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=171818&action=edit snapshot of terminal During an upgrade of Koha to version 24.05.03-1, the process failed due to a database access error. The upgrade script was unable to connect to the MySQL/MariaDB database, suggesting a potential issue with database permissions or configuration. Steps to Reproduce: Attempt to upgrade Koha-common package to version 24.05.03-1 Run sudo apt-get install mariadb-server Confirm the installation/upgrade process Observed Behavior: The upgrade process fails during the database schema upgrade step An error message indicates that access is denied for the Koha database user Error Message: "DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_monirul;host=localhost;port=3306','koha_monirul',...) failed: Access denied for user 'koha_monirul'@'localhost' (using password: YES) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Database.pm line 139" Environment: Koha version being upgraded to: 24.05.03-1 Database: MariaDB (version 1:10.11.8-0ubuntu0.24.04.1) Operating System: Ubuntu (likely 24.04 based on package versions) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37971 Md Monirul <mdmiansarilib@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - low |P1 - high -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37971 Magnus Enger <magnus@libriotech.no> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |magnus@libriotech.no --- Comment #1 from Magnus Enger <magnus@libriotech.no> --- Does this work for you? sudo koha-mysql monirul -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37971 --- Comment #2 from Md Monirul <mdmiansarilib@gmail.com> --- I have solved the prevuious problem, its happend because of the mismatch with the username and passowrd in MySQL and username and password in koha-conf.xml , After I changed my password in both location, the error has been solved. But Koha webpage is not loading, rather showing this error, "BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Koha.pm line 25. Compilation failed in require at /etc/koha/plack.psgi line 29. BEGIN failed--compilation aborted at /etc/koha/plack.psgi line 29. Child process 161801 exited with status 13 I/O error : Permission denied I/O error : Permission denied Error while loading /etc/koha/plack.psgi: Error reading file /etc/koha/sites/monirul/koha-conf.xml. Try running this again as the koha instance user (or use the koha-shell command in debian) " -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37971 --- Comment #3 from Md Monirul <mdmiansarilib@gmail.com> --- Created attachment 171823 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=171823&action=edit koha-mysql monirul -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37971 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- OS|Linux |All Hardware|PC |All Summary|Koha Bug Report: Database |Database access error |Access Error During Upgrade |during upgrade 24.05 |24.05 | -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37971 --- Comment #4 from Magnus Enger <magnus@libriotech.no> --- I think this was solved on Mattermost? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37971 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |WORKSFORME CC| |martin.renvoize@ptfs-europe | |.com -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org