November 2010 - Koha-devel - lists.koha-community.org

use cases for authentication [was externalising translator and etc]
by LAURENT Henri-Damien 26 Nov '10

26 Nov '10

Hi, as I spotted in previous email some design flaws (in my opinion) in Authentication. >> It gets >> > worse if you consider changes such as adding or modifying an >> > authentication module, for which the default configuration changes are >> > almost invariably associated with code changes. > Same for authentication. I consider this as a design flaw. > We should split authentication and identification. > And manage identification in a modular way... So that administrators > would just have to edit configuration files in order to make correct > mappings, and not dive into the code, change and commit (if they know > git enough...) > I would like to gather some use cases of what hardcoded customization people had to implement in Auth_with_ldap in order to make them run. We have some... Most of which consist in date calculation for users, and hash values mappings for categories or other data or encoding. We also implemented search against multiple branches... (patch to be sent soon (still need some sanitizing) ). But I would be quite interested in more use cases. So that we could have a kind of test cases to implement in order to generalize the thing at its best. -- Henri-Damien LAURENT

1 0

Facets performance
by Fridolyn SOMERS 26 Nov '10

26 Nov '10

Hie, I have posted a proposed patch for Bug 3154 : http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3154 It's about the fact that facets computation is limited to the records in search results page. I think I've found a good way to improve the facets extraction performance. Any comment or modification is welcome. Regards, -- Fridolyn SOMERS ICT engineer PROGILONE - Lyon - France fridolyn.somers(a)gmail.com

4 4

Deleting Orders
by Colin Campbell 26 Nov '10

26 Nov '10

Hi, I'm just looking at the branch of acquisitions fixes from Biblibre one fix in there is an addition to DelOrder to delete any items associated with the order on its deletion. However it goes further and deletes the associated bib record if it has no items. thus: > diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm > index c1b837b..54b01fa 100644 > --- a/C4/Acquisition.pm > +++ b/C4/Acquisition.pm > @@ -28,6 +28,7 @@ use C4::Suggestions; > use C4::Biblio; > use C4::Debug; > use C4::SQLHelper qw(InsertInTable); > +use C4::Items; > > use Time::localtime; > use HTML::Entities; > @@ -1219,6 +1220,10 @@ sub DelOrder { > my $sth = $dbh->prepare($query); > $sth->execute( $bibnum, $ordernumber ); > $sth->finish; > + > + my @itemnumbers = GetItemnumbersFromOrder( $ordernumber ); > + C4::Items::DelItem( $dbh, $bibnum, $_ ) for @itemnumbers; > + DelBiblio( $dbh, $bibnum ) if C4::Items::GetItemsCount( $bibnum ) == 0; > } My gut feeling is that deleting the biblio automatically at this point is not a good idea but I thought I'd throw it open for comments. Cheers Colin -- Colin Campbell Chief Software Engineer, PTFS Europe Limited Content Management and Library Solutions +44 (0) 208 366 1295 (phone) +44 (0) 7759 633626 (mobile) colin.campbell(a)ptfs-europe.com skype: colin_campbell2 http://www.ptfs-europe.com

3 4

Branches awaiting QA
by Chris Cormack 25 Nov '10

25 Nov '10

Hi All I have pushed up 7 branches on git.koha-community.org new/awaiting_qa/biblibre_memb_circ_upd new/awaiting_qa/biblibre_admin new/awaiting_qa/biblibre_various new/awaiting_qa/biblibre_serials new/awaiting_qa/biblibre_cataloguing new/awaiting_qa/biblibre_opac new/awaiting_qa/biblibre_acquisitions They are all awaiting QA. Another branch new/biblibre_reports Has been through initial QA, and feedback has been sent to Biblibre, once that has been dealt with, that branch will be merged. The other branches do need QA done on them though, before they can move on. Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand

7 6

Re: [Koha-devel] BibLibre RFC's on Wiki Needing Updating
by Paul Poulain 24 Nov '10

24 Nov '10

1 0

Re: [Koha-devel] RE : Re: [koha-commits] main Koha release repository branch, master, updated. v3.02.00-rc-20-g45604b8
by Nicole Engard 22 Nov '10

22 Nov '10

If so, then we should probably change the description that says it's going to be removed. Nicole On Fri, Nov 19, 2010 at 1:49 PM, Henri-Damien LAURENT <henridamien.laurent(a)gmail.com> wrote: > As far as i know it is still used. > > Le 19 nov. 2010, 3:50 PM, "Nicole Engard" <nengard(a)gmail.com> a écrit : > > I am catching up on commits to update the manual and have a question > about this one. The homeorholdingbranch system preference says that > it's going to be removed soon in the description ... so how is this a > new preference? Or should the description be updated? > > Thanks > Nicole > > On Thu, Oct 21, 2010 at 8:12 PM, Git repo owner > <gitmaster(a)git.koha-community.org> wrote: >> This is an automated email from the git hooks/post-receive script. It was >> generated because a ref change was pushed to the repository containing >> the project "main Koha release repository". >> >> The branch, master has been updated >> via 45604b8d17e05adb98a98a8a2184bd290f72997a (commit) >> from 4a7bb77e4fcd7ad78ef7ba6f984ef69fccd8a163 (commit) >> >> Those revisions listed above that are new to this repository have >> not appeared on any other notification email; so we list those >> revisions in full, below. >> >> - Log ----------------------------------------------------------------- >> commit 45604b8d17e05adb98a98a8a2184bd290f72997a >> Author: Henri-Damien LAURENT <henridamien.laurent(a)biblibre.com> >> Date: Thu Sep 9 14:54:12 2010 -0400 >> >> (bug 3536) fix homeorholdingbranch on return >> >> this patch create a new systempreference "homeorholdingbranch"-like >> used only for returns. >> >> Signed-off-by: Galen Charlton <gmcharlt(a)gmail.com> >> >> An additional edit was made to circ/returns.pl by Ian Walls of ByWater >> Solutions to force the dialog message for the return to >> use the branch specified by the new HomeOrHoldingBranchReturn system >> preference, rather than always Homebranch. >> Signed-off-by: Ian Walls <ian.walls(a)bywatersolutions.com> >> Signed-off-by: Galen Charlton <gmcharlt(a)gmail.com> >> >> ----------------------------------------------------------------------- >> >> Summary of changes: >> C4/Circulation.pm | 3 ++- >> admin/systempreferences.pl | 1 + >> circ/returns.pl | 3 ++- >> installer/data/mysql/en/mandatory/sysprefs.sql | 1 + >> .../1-Obligatoire/unimarc_standard_systemprefs.sql | 1 + >> installer/data/mysql/updatedatabase.pl | 8 ++++++++ >> kohaversion.pl | 4 +--- >> 7 files changed, 16 insertions(+), 5 deletions(-) >> >> >> hooks/post-receive >> -- >> main Koha release repository >> _______________________________________________ >> koha-commits mailing list >> koha-commits(a)lists.koha-community.org >> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-commits >> > _______________________________________________ > Koha-devel mailing list > Koha-devel(a)lists.koha-community.org > http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > website : http://www.koha-community.org/ > git : http://git.koha-community.org/ > bugs : http://bugs.koha-community.org/

2 1

Koha 3.2.1 Released
by Chris Nighswonger 21 Nov '10

21 Nov '10

Greetings: It is with pleasure that I announce the release of Koha 3.2.1 two days ahead of the scheduled release date. The package can be retrieved from: http://download.koha-community.org/koha-3.02.01.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.02.01.tar.gz.MD5 http://download.koha-community.org/koha-3.02.01.tar.gz.MD5.asc http://download.koha-community.org/koha-3.02.01.tar.gz.sig Come and get it! RELEASE NOTES FOR KOHA 3.2.1 - 20 November 2010 ======================================================================== Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.2.1 can be downloaded from: http://download.koha-community.org/koha-3.02.01.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation Koha 3.2.1 is a bugfix/maintenance release. Highlights of 3.2.1 ====================== Some of the higher profile bugs addressed in this release are: * Further fixes smoothing the upgrade process from 3.0.x to 3.2.x. (Bug 4141) * Subject links in search results are now properly formed. (Bug 4074) * Advanced notice preferences set during new patron creation are now saved correctly. (Bug 4254) * Img tags in XSLT templates are now handled correctly during automatic translation. (Bug 4472) * The "Show More" link listed with facets has been made to work. (Bug 4520) * Amanzon book covers will now work with ISBN13. (Bug 4305) * The staff client XSLT templates are now unique. (Bug 4423) * The Unimarc XSLT templates are now translated in English. (Bug 5204) Other notable fixes in this release include: * A number of spelling corrections * Various fixes to formerly non-translatable phrases * Some tweaks to fix display problems in Internet Explorer This release also contains a variety of minor enhancements improving Koha's interface. Maintenance activities performed in this release include: * A number of new and improved test cases * Removal of unused dependencies Bugs fixed in 3.2.1 ====================== 2122 Grayed out Fields not always visible 2567 008 editor falsely populating Illustrations and Nature of Contents positions 3013 Value builder for 006 and 008 need choices for all format types 3211 cataloging value plugin forms should be valid XHTML 3271 Missing message when adding to a list with no items selected 3811 biblios record.abs indexes 008 language as numeric (marc21) 4074 The 'Subject(s)' link(s) are malformed resulting in no search results 4141 reconcile 3.0.x and HEAD database updates for 3.2.0 4254 adding new patron advanced notice doesn't save 4261 keyword mapping should show which framework the map is for 4305 Amazon book covers do not work with ISBN13 4359 noItemTypeImages not active in OPAC 4423 Staff Client XSLT is just a copy of the OPAC one 4472 img tags in xslt broken after automatic translation 4498 Acq always shows '1 suggestions waiting' 4515 Few very small errors in opac-search.pl 4520 facets "show more" doesn't work 4866 Optionally enable Change event for item plugins 4912 After editing private list, user should be redirect to private lists 4913 Budget planning pages should show currency name instead of symbol 4924 Public/Internal notes missing in staff normal view 4933 Link to subfield's edit tab from MARC subfield structure admin summary 4963 sys prefs need date hints and/or picker 4979 Acq: input fields for new record are too short 4980 Acq: pull down 'Restrict access to:' for funds not translatable 4986 move serials prefs from cataloging tab 4991 Overhaul Calendar interface 5003 Can not search for organisation by name 5004 Do not block deletion of cities when instances exist in borrowers table 5008 "Remove" link missing when viewing Cart in expanded "More details" view 5019 funds link doesn't go to list 5037 If patron category is empty it shouldn't show 5050 Staff client's language preference should be grouped with I18N/L10N preferences 5056 Untranslatable strings in members.js 5059 Inconsistent use of ordering price and list price in vendor form 5066 Incorrect use of localtime function when calling _session_log 5075 Terms not highlighted w/ xslt on 5082 Not translatable name of default framework 'Default' in MARCdetail.tmpl 5110 NewItemsDefaultLocation should be under cataloging 5112 Organisation does not show links to professional patrons 5114 Can't edit basket in Internet Explorer 5117 Misspelled word: Orgnisztion 5118 Misspelled word: Currencey 5119 Misspelled word: correspounding 5121 Misspelled words: stripts biographyl Begininning 5122 Misspelled word: Transfered/transfered 5123 Misspelled words: Depdending Commited flutucations 5124 Duplicate and Misspelled words: periodicy outputing 5128 Define default 9xx fields for Unimarc setup in all languages 5130 Misspelled words: biblographic delimeter extention 5132 Misspelled words: Acquistion Succesfully professionnal 5133 Misspelled words: reservior notifiying deleete 5134 Misspelled words: exisiting anomolies genereated 5135 Authorized value input maxlength should match table column 5136 Replace embedded SQL query with call to GetAuthorisedValues 5137 Remove obsolete code for counting issues by item type in circulation 5142 Untranslatable strings in tag review template 5146 Patron Import Requires Header Row 5149 Link to noItemTypeImages pref on item types is wrong 5151 Saved Report Breadcrumb in bold 5152 confirm buttons different styles on lists 5162 patron attributes 'new' link should create blank value 5163 holds to pull is titled pending holds 5168 add holdings' should read 'add/edit items' 5171 edit items should be edit item when under 1 item 5175 The opac XSLTDetails view field Publisher: doesn't provide a hyperlink as the non XSLT view does. 5177 Descending sort search result defined by syspref doesn't work 5190 MARC and UNIMARC bibliographic fields documentation accesible when cataloging 5204 Unimarc xslt default templates are in french 5210 Function of back button on batch modification result page unclear 5214 undefined itype images cause broken image icon in request.pl 5219 Perltidy code 5221 Preselect tab containing itemtype/authorized value image in use 5223 related subjects' should read 'subjects' 5224 Replace Shopping Basket with basket 5235 checkout receipt should include patron name 5236 "hide my tags" link does nothing 5237 Special characters in patron barcodes cause renewals to fail. 5243 C4::Search::SimpleSearch call in AuthoritiesMarc.pm 5254 no need to scroll left to right on acq z search 5258 Order should read 'order line' in receive table 5301 In C4/XSLT.pm, itemcallnumber can contain special XML characters 5308 subscriptionroutinglist table is too lax 5309 Progress bar inaccurate 5311 Language dropdown in advanced search broken? 5315 Authority search Templates refer to unused variable 5318 rank weight error in ccl.properties 5322 pwgen not a dependency for the packages 5326 when ExtendedPatronAttributes off error links to old sys prefs 5327 Unit tests required for all C4 modules 5363 Remove dependency on Cache::Memcached::Fast 5368 Browse Shelf link appears even if there isn't an itemcallnumber 5370 Fix all the references to koha.org 5372 Editing a bilbio record, existing value can be replace by default value 5380 an end to copy-and-paste-itis 5381 Fines in notices prints always 0.00 5385 Correct POD errors as highlighted by podchecker 5389 Business::ISBN should be marked as required dependency 5392 reserve/renewscript logging lots of warnings 5393 test case for verifying XML/XSLT files are well-formed 5396 UseTablesortForCirc syspref to toggle table sorter on circ/ circulation.pl 5400 add test case to detect merge conflict markers in the code 5412 Double quotes in publisher name, no date cause search results links to break Commits in 3.2.1 without a referenced bug report: * Adding a simple test for Service.pm * create unit test files * Create Unit Test for ImportBatch * unit test stub for Z3950.pm * Test modules compile * Updated links in Main Page Help * remove extraneous semicolon * History updates * history updates - recent releases * Adding 3.2 Release Maintainer to Release Team List * Adding possibility to cleanup_database.pl to purge only older sessions * Display available error information during bulkmarcimport * add missing help file for merging records * (MT 2985) simplify CanBookBeReserved * fix use of outdated boilerplate * remove unused template include * Misspells: deleteing -> deleting * Misspell: Quanity -> Quantity System requirements ====================== Changes since 3.0: * The minimum version of Perl required is now 5.8.8. * There are a number of new Perl module dependencies. Run ./koha_perl_deps.pl -u -m to get a list of any new modules to install during upgrade. Upgrades ====================== The structure of the acquisitions tables have changed significantly from 3.0.x. In particular, the budget hierarchy is quite different. During an upgrade, a new database table is created called fundmapping that contains a record of how budgets were mapped. It is strongly recommended that users of Koha 3.0.x acquisitions carefully review the results of the upgrade before resuming ordering in Koha 3.2.x. Documentation ====================== As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, several translations of the Koha manual are available: English: http://koha-community.org/documentation/3-2-manual/ Spanish: http://koha-community.org/documentation/3-2-manual-es/ French: http://koha-community.org/documentation/3-2-manual-fr/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations ====================== Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * Chinese * Danish * English (New Zealand) * English (USA) * French (France) * French (Canada) * German * Greek * Hindi * Italian * Norwegian * Portuguese * Spanish * Turkish Translation related commits new to 3.2.1: * Staff interface .po file updates * Russian and Ukranian opac language updates * Ukranian and Russian syspref language updates * German and italian language updates Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://www.kohadocs.org/usersguide/apb.html for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha.org/ Release Team ====================== The release team for Koha 3.2 is Release Manager: Galen Charlton <gmcharlt(a)gmail.com> Documentation Manager: Nicole Engard <nengard(a)gmail.com> Translation Manager: Chris Cormack <chris(a)bigallofwax.co.nz> Release Maintainer (3.0.x): Henri-Damien Laurent < henridamien.laurent(a)biblibre.com> Release Maintainer (3.2.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Credits ====================== We thank the following individuals who contributed patches to Koha 3.2.1. Nahuel Angelinetti TomÃ¡s Cohen Arazi Jared Camins-Esakov Colin Campbell Galen Charlton Chris Cormack Nate Curulla FrÃ©dÃ©ric Demians Andrew Elwell Brian Engard Nicole Engard Magnus Enger Katrin Fischer Daniel Grobani Kyle M Hall Srdjan Jankovic Bernardo Gonzalez Kriegel Henri-Damien Laurent Owen Leonard Chris Nighswonger Paul Poulain MJ Ray Liz Rea Marcel de Rooy Robin Sheat ByWater Solutions Zeno Tajoli Ian Walls We regret any omissions. If a contributor has been inadvertantly missed, please send patch against these release notes to koha-patches(a)lists.koha-community.org. The 3.2.x Release Maintainer especially thanks the 3.4 Release Team and all who participated in QA for their diligent labors in testing and pushing well over 100 patches since the 3.2.0 relese. Their work very much makes possible the release of 3.2.1 on its announced schedule. Revision control notes ====================== The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of git://git.koha-community.org/koha.git The branch for Koha 3.2.x (i.e., this version of Koha and future bugfix releases) is 3.2.x. The next major feature release of Koha will be Koha 3.4.0. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Naku te rourou, nau te rourou, ka ora ai te iwi.

1 0

Re: [Koha-devel] [Koha] Borrowers' password encryption method in database
by Altaf Mahmud 20 Nov '10

20 Nov '10

I found a solution for php: $str = rtrim (base64_encode (pack ('H*', md5 ('123456'))), '='); This returns the desired string in 22 characters, rtrim used for discarding trailing '=' pad characters. Thanks for the help. 2010/11/20 Paul <paul.a(a)aandc.org> > At 07:01 AM 11/20/2010 -0500, Chris Nighswonger wrote: > > 2010/11/20 Altaf Mahmud <altaf.mahmud(a)gmail.com> > Hi, > I want to know how Koha saves its borrowers' password in database? Is it > one-way conversion? For example, if a password is saved as > '4QrcOUm6Wau+VuBX8g+IPg', can I decode it back to its original text which > was '123456'? > They are stored as MD5 hashes and you cannot "decode" them as such. IIRCC, > what you must do is make an MD5 hash of the password and then compare the > two hashes. They should be the same. > > > The above is not a "pure" MD5 hash [32 character hexadecimal value]; for > 123456, it would be > > e10adc3949ba59abbe56e057f20f883e > > However, the decrypt function at <http://www.cmd5.org/> does return 123456 > for 4QrcOUm6Wau+VuBX8g+IPg > > Best - Paul > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > -- Altaf Mahmud System Programmer Ayesha Abed Library BRAC University Bangladesh.

1 0

Borrowers' password encryption method in database
by Altaf Mahmud 20 Nov '10

20 Nov '10

Hi, I want to know how Koha saves its borrowers' password in database? Is it one-way conversion? For example, if a password is saved as '4QrcOUm6Wau+VuBX8g+IPg', can I decode it back to its original text which was '123456'? Thanks. -- Altaf Mahmud System Programmer Ayesha Abed Library BRAC University Bangladesh.

3 3

Re: [Koha-devel] [koha-commits] main Koha release repository branch, master, updated. v3.02.00-rc-20-g45604b8
by Nicole Engard 19 Nov '10

19 Nov '10

I am catching up on commits to update the manual and have a question about this one. The homeorholdingbranch system preference says that it's going to be removed soon in the description ... so how is this a new preference? Or should the description be updated? Thanks Nicole On Thu, Oct 21, 2010 at 8:12 PM, Git repo owner <gitmaster(a)git.koha-community.org> wrote: > This is an automated email from the git hooks/post-receive script. It was > generated because a ref change was pushed to the repository containing > the project "main Koha release repository". > > The branch, master has been updated > via 45604b8d17e05adb98a98a8a2184bd290f72997a (commit) > from 4a7bb77e4fcd7ad78ef7ba6f984ef69fccd8a163 (commit) > > Those revisions listed above that are new to this repository have > not appeared on any other notification email; so we list those > revisions in full, below. > > - Log ----------------------------------------------------------------- > commit 45604b8d17e05adb98a98a8a2184bd290f72997a > Author: Henri-Damien LAURENT <henridamien.laurent(a)biblibre.com> > Date: Thu Sep 9 14:54:12 2010 -0400 > > (bug 3536) fix homeorholdingbranch on return > > this patch create a new systempreference "homeorholdingbranch"-like used only for returns. > > Signed-off-by: Galen Charlton <gmcharlt(a)gmail.com> > > An additional edit was made to circ/returns.pl by Ian Walls of ByWater Solutions to force the dialog message for the return to > use the branch specified by the new HomeOrHoldingBranchReturn system preference, rather than always Homebranch. > Signed-off-by: Ian Walls <ian.walls(a)bywatersolutions.com> > Signed-off-by: Galen Charlton <gmcharlt(a)gmail.com> > > ----------------------------------------------------------------------- > > Summary of changes: > C4/Circulation.pm | 3 ++- > admin/systempreferences.pl | 1 + > circ/returns.pl | 3 ++- > installer/data/mysql/en/mandatory/sysprefs.sql | 1 + > .../1-Obligatoire/unimarc_standard_systemprefs.sql | 1 + > installer/data/mysql/updatedatabase.pl | 8 ++++++++ > kohaversion.pl | 4 +--- > 7 files changed, 16 insertions(+), 5 deletions(-) > > > hooks/post-receive > -- > main Koha release repository > _______________________________________________ > koha-commits mailing list > koha-commits(a)lists.koha-community.org > http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-commits >

1 0