[Bug 8066] New: action logs default value
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8066 Priority: P3 Change sponsored?: --- Bug ID: 8066 CC: gmcharlt@gmail.com Assignee: paul.poulain@biblibre.com Summary: action logs default value Severity: normal Classification: Unclassified OS: All Reporter: paul.poulain@biblibre.com Hardware: All Status: ASSIGNED Version: master Component: Installation and upgrade (web-based installer) Product: Koha Bu default, most log systempreferences are ON. The consequence is that we get the action_logs table filled "silently". It would be better to have those values set to OFF by default when installing a new Koha -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8066 --- Comment #1 from Paul Poulain <paul.poulain@biblibre.com> --- Created attachment 9499 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=9499&action=edit Bug 8066 default values set to 0 for loging syspreferences Bu default, most log systempreferences are ON. The consequence is that we get the action_logs table filled "silently". It would be better to have those values set to OFF by default when installing a new Koha -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8066 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8066 --- Comment #2 from Jared Camins-Esakov <jcamins@cpbibliography.com> --- I disagree. I think most people expect the logs to be populated by default. Audit logs are a standard feature in ILSes. I think it's better to leave the default as it is, and if you would like to make sure people know that the logs are enabled by default, add a message to that effect during installation. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8066 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi Paul, I think I agree with Jared here. An option, could be to make it part of the web installer. For example you could add a French system preferences file if there is none yet. I have one for German to change some of the default values. It could also be its own SQL file making the required change on demand. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8066 --- Comment #4 from Paul Poulain <paul.poulain@biblibre.com> --- (In reply to comment #2)
I disagree. I think most people expect the logs to be populated by default.
Most people who *know* there are logs expect them to be populated by default. However, small libraries, will never know. And I think it's much more harmfull to have them ON by default than to discover it would have been useful to have them ON and discover they're OFF ! If the cleaning was automatic, I wouldn't object. But it's not the case, and we have discovered that one of our small customer had ... 2 millions lines in this log, for a database of less than 10k items ! -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8066 Chris Nighswonger <cnighswonger@foundations.edu> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |cnighswonger@foundations.ed | |u --- Comment #5 from Chris Nighswonger <cnighswonger@foundations.edu> --- (In reply to comment #4)
(In reply to comment #2)
I disagree. I think most people expect the logs to be populated by default.
Most people who *know* there are logs expect them to be populated by default. However, small libraries, will never know. And I think it's much more harmfull to have them ON by default than to discover it would have been useful to have them ON and discover they're OFF ! If the cleaning was automatic, I wouldn't object. But it's not the case, and we have discovered that one of our small customer had ... 2 millions lines in this log, for a database of less than 10k items !
I expect logs to be enabled by default. This is consistent with nearly 100% of software which I have had experience with, including all *nix packages. I think that this is more of a training issue than a software issue. Train librarians/system admins to check/truncate/archive/whatever their logs and this problem will go a way. I would not be opposed to some sort of auto-archiving feature similar to what *nix logs typically have. My $0.02 worth... -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8066 --- Comment #6 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- What about making it a choice with explanation at install time? I think an additional SQL file for the webinstaller shoudl work here. It would inform the libraries about the logs and give an option to turn them off. Or we could add a script to the cronjobs to clean the log tables regularly? -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8066 Magnus Enger <magnus@enger.priv.no> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |magnus@enger.priv.no --- Comment #7 from Magnus Enger <magnus@enger.priv.no> --- I agree with Katrin et al. I expect logging to be on by default. And I disagree with Paul: I think "to discover it would have been useful to have them ON and discover they're OFF" would be worse than taking up some extra database space. Creating an SQL file for the webinstaller that makes it possible to choose to turn logging off during installation would be a good workaround, though. Something like: UPDATE systempreferences SET value = 0 WHERE variable = 'IssueLog'; etc... -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8066 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |In Discussion CC| |chris@bigballofwax.co.nz -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8066 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|In Discussion |RESOLVED Resolution|--- |INVALID --- Comment #8 from Paul Poulain <paul.poulain@biblibre.com> --- OK, won't argue more and accept letting the syspref to 1 -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org