[Bug 16402] New: Web Installation fails - Step 3 Importing the Database Structure
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Bug ID: 16402 Summary: Web Installation fails - Step 3 Importing the Database Structure Change sponsored?: --- Product: Koha Version: unspecified Hardware: PC OS: Linux Status: NEW Severity: critical Priority: P5 - low Component: About Assignee: nengard@gmail.com Reporter: gk.bmsit@gmail.com QA Contact: testopia@bugs.koha-community.org Created attachment 51046 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51046&action=edit Web Installation Error OS: Ubuntu 16.04 Type: Ubuntu package installation Koha: Current Stable Version on 29th April 2016 Blank Database creation was successful. Very first login prompted for password. At Step 3 persistent error: The following error occurred while importing the database structure: mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1171 (42000) at line 1385: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead Please contact your system administrator On second instance creation - did not appear Login Page at all. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=14637 CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Hello Gopalakrishna, Please try to comment the sql_mode=STRICT_TRANS_TABLES line in your MySQL/MariaDB config file. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|critical |normal -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Charles Gruener <cgruener@gruener.us> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |cgruener@gruener.us -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 --- Comment #2 from Charles Gruener <cgruener@gruener.us> --- I attempted to change the sql_mode as suggested and the error persists upon trying to import the database structure. The file /usr/share/koha/intranet/cgi-bin/installer/data/mysql/kohastructure.sql needs to be updated to comply with the changes introduced in MySQL release 5.7.3. See: http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-3.html Specifically: Columns in a PRIMARY KEY must be NOT NULL, but if declared explicitly as NULL produced no error. Now an error occurs. For example, a statement such as CREATE TABLE t (i INT NULL PRIMARY KEY) is rejected. The same occurs for similar ALTER TABLE statements. (Bug #13995622, Bug #66987, Bug #15967545, Bug #16545198) Since I don't know much about how the database needs to be structured to properly function, I'll just call out the fields that MySQL is erroring out on in kohastructure.sql rather than attempting to write my own patch. On line 1385: CREATE TABLE 'letter' uses 'branchcode' as part of its PRIMARY_KEY, but is "default NULL" On line 2476: CREATE TABLE 'permissions' uses 'code' as part of its PRIMARY_KEY but is "DEFAULT NULL" If I change those two (branchcode and code) to be "NOT NULL", I am able to get the installer to continue, but as I stated above, I don't know if this is the correct fix as I don't know how this impacts the database structure for the usability of koha. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Charles Gruener <cgruener@gruener.us> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also|https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=14637 | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 --- Comment #3 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Created attachment 51235 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51235&action=edit Bug 16402: Make kohastructure.sql valid for MySQL v5.7 A primary key should not contain null value, and MySQL v5.7 is now more strict and won't accept our errors in the DB structure. Test plan: mysql < installer/data/mysql/kohastructure.sql should work using MySQL v5.7 QA: - letter.branchcode should not be NULL, the default (all) is an empty string - permissions.code should not be NULL, it's always a string -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Richard Gardner <rtgardner90@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |rtgardner90@gmail.com --- Comment #4 from Richard Gardner <rtgardner90@gmail.com> --- Hey there, Was having this same problem. Just wanted to give you all a shout-out for the fix. Was having trouble locating the file but eventually got it all worked out. Still ended up getting:: mysql: [Warning] Using a password on the command line interface can be insecure. but I found a workaround for that and now i've created and access the staff interface via command line. I am still having some trouble connecting via web-browser, but I suspect it's because I just set my nameservers up earlier today and they haven't had time to propagate. I hope that is the "problem" at least. Otherwise I may need to figure out my host files, .conf files, or the proper settings for my server's DNS manager. Anyway, thanks again. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- If one of you could tell that Jonathan's patch works (sign off on it), this would help to get the fix into Koha :) -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=16393 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |g.meyer@esgbonn.de --- Comment #6 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- *** Bug 16393 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #51235|0 |1 is obsolete| | --- Comment #7 from Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> --- Created attachment 51301 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51301&action=edit [SIGNED-OFF] Bug 16402: Make kohastructure.sql valid for MySQL v5.7 A primary key should not contain null value, and MySQL v5.7 is now more strict and won't accept our errors in the DB structure. Test plan: mysql < installer/data/mysql/kohastructure.sql should work using MySQL v5.7 QA: - letter.branchcode should not be NULL, the default (all) is an empty string - permissions.code should not be NULL, it's always a string Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> Clean install of Ubuntu 16.05, MySQL 5.7.11 kohastructure.sql loads ok, just one warning No errors -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 --- Comment #8 from g.meyer@esgbonn.de --- (In reply to Richard Gardner from comment #4)
Hey there,
Was having this same problem. Just wanted to give you all a shout-out for the fix. Was having trouble locating the file but eventually got it all worked out.
Still ended up getting::
mysql: [Warning] Using a password on the command line interface can be insecure.
but I found a workaround for that and now i've created and access the staff interface via command line. I am still having some trouble connecting via web-browser, but I suspect it's because I just set my nameservers up earlier today and they haven't had time to propagate. I hope that is the "problem" at least.
Otherwise I may need to figure out my host files, .conf files, or the proper settings for my server's DNS manager.
Anyway, thanks again.
Hello Richard, I did not find the file. Could you please give me a hint? Thanks -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|normal |major --- Comment #9 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Upping severity as this blocks people from being able to install Koha. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |gmcharlt@gmail.com Assignee|nengard@gmail.com |koha-bugs@lists.koha-commun | |ity.org Component|About |Installation and upgrade | |(web-based installer) Version|unspecified |master -- 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=16402 --- Comment #10 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hm, I think this will work for new installations, but shouldn't we change existing ones to match? -- 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=16402 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Failed QA -- 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=16402 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #51301|0 |1 is obsolete| | --- Comment #11 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 51305 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51305&action=edit [PASSED QA] Bug 16402: Make kohastructure.sql valid for MySQL v5.7 A primary key should not contain null value, and MySQL v5.7 is now more strict and won't accept our errors in the DB structure. Test plan: mysql < installer/data/mysql/kohastructure.sql should work using MySQL v5.7 QA: - letter.branchcode should not be NULL, the default (all) is an empty string - permissions.code should not be NULL, it's always a string Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> Clean install of Ubuntu 16.05, MySQL 5.7.11 kohastructure.sql loads ok, just one warning No errors Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> -- 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=16402 --- Comment #12 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (In reply to Katrin Fischer from comment #10)
Hm, I think this will work for new installations, but shouldn't we change existing ones to match?
Yes indeed we must, I have thought about that during the week-end :) Patches coming soon... -- 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=16402 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Signed Off -- 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=16402 --- Comment #13 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Created attachment 51328 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51328&action=edit Bug 16402: Fix fox existing installations -- 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=16402 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |jonathan.druart@bugs.koha-c |ity.org |ommunity.org -- 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=16402 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #51305|0 |1 is obsolete| | --- Comment #14 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Created attachment 51540 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51540&action=edit Bug 16402: Make kohastructure.sql valid for MySQL v5.7 A primary key should not contain null value, and MySQL v5.7 is now more strict and won't accept our errors in the DB structure. Test plan: mysql < installer/data/mysql/kohastructure.sql should work using MySQL v5.7 QA: - letter.branchcode should not be NULL, the default (all) is an empty string - permissions.code should not be NULL, it's always a string Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> Clean install of Ubuntu 16.05, MySQL 5.7.11 kohastructure.sql loads ok, just one warning No errors Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #51328|0 |1 is obsolete| | --- Comment #15 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Created attachment 51541 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51541&action=edit Bug 16402: Fix fox existing installations Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 --- Comment #16 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Created attachment 51542 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51542&action=edit Bug 16402: (QA followup) Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA CC| |tomascohen@gmail.com --- Comment #17 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Works as expected. I added a followup to ease the task for the RM. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Web Installation fails - |DB structure cannot be |Step 3 Importing the |loaded in MySQL 5.7 |Database Structure | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|major |critical -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master CC| |kyle@bywatersolutions.com --- Comment #18 from Kyle M Hall <kyle@bywatersolutions.com> --- Pushed to master for Koha 16.05. Thanks Jonathan! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Julian Maurice <julian.maurice@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |julian.maurice@biblibre.com Status|Pushed to Master |Pushed to Stable --- Comment #19 from Julian Maurice <julian.maurice@biblibre.com> --- Patches pushed to 3.22.x, will be in 3.22.7 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 --- Comment #20 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I am trying to install Koha on Ubuntu 16.05 and I can't finish the web installer. After the tables are created (and they are), the web installer is stuck with this error: [Warning] Using a password on the command line interface can be insecure. You can't continue to choose the sample data, install the mandatory data etc. Leaving this here for now - if needed I can file a new bug report tomorrow. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 --- Comment #21 from Tomás Cohen Arazi <tomascohen@gmail.com> --- (In reply to Katrin Fischer from comment #20)
I am trying to install Koha on Ubuntu 16.05 and I can't finish the web installer. After the tables are created (and they are), the web installer is stuck with this error:
[Warning] Using a password on the command line interface can be insecure.
You can't continue to choose the sample data, install the mandatory data etc.
Leaving this here for now - if needed I can file a new bug report tomorrow.
There's a bug filled for that already, it mentions mysql 5.6 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=13669 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 --- Comment #22 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- bug 13669 doesn't mention the error - was this the one you were thinking about? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 --- Comment #23 from Tomás Cohen Arazi <tomascohen@gmail.com> --- (In reply to Katrin Fischer from comment #22)
bug 13669 doesn't mention the error - was this the one you were thinking about?
The first comment explains the failure. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Fridolin SOMERS <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |fridolin.somers@biblibre.co | |m -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=16583 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |17258 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 [Bug 17258] [OMIBUS] MySQL 5.7 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Mason James <mtj@kohaaloha.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mtj@kohaaloha.com -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org