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

Koha + LDAP
by Pablo Bianchi 11 Jun '13

11 Jun '13

Hi all! I'm trying to set up a Koha instance (stable, v3.12, koha-common) with an OpenLDAP. I already setup koha-conf.xml and fix every LDAP error I had, using the output of: /usr/share/koha/opac/cgi-bin/opac/opac-user.pl userid="10000" password="1234" >/dev/null But now this only gives me: Use of uninitialized value $pki_field in string eq at /usr/share/koha/lib/C4/Auth.pm line 789, <DATA> line 522. Use of uninitialized value $pki_field in string eq at /usr/share/koha/lib/C4/Auth.pm line 789, <DATA> line 522. Use of uninitialized value $retuserid in string ne at /usr/share/koha/lib/C4/Auth.pm line 826, <DATA> line 522. Same on intranet-error.log or opac-error.log, trying via web; same lines if ldap user or local user. But logging with local accounts works fine, the problem is just with LDAP, which AFAIK use MD5, so I was wondering if all this have something to do with bug #9611<http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9611>. Already installed Crypt::Eksblowfish::Bcrypt and Crypt::Random::Source without luck. Using ldapsearch to fetch user information works fine. Any ideas? Regards, Pablo PS: JFTR, I needed to touch Auth_wiith_ldap.pm line ~81 (*my $filter...*) to have only one hit (strange LDAP tree).

3 3

Koha QA repo changes
by Mason James 07 Jun '13

07 Jun '13

hi All just a heads-up, I've renamed (corrected) the github QA repo to match the kc.org repo from koha-qa-test to qa-test-tools the reason? koha-qa-test name is used for another koha project, already here the new repo -> https://github.com/Koha-Community/qa-test-tools the github repo is *temporarily* the primary until we sort some ssh access problems to git.kc.org until then, the git.kc.org repo is being updated from github every hour for the curious, heres the kc.org repo -> http://git.koha-community.org/cgi-bin/gitweb.cgi?p=qa-test-tools.git thanks, Mason

2 2

Old bugs to check
by MJ Ray 06 Jun '13

06 Jun '13

Would you check some of these rather old bugs to suggest what to do, please? Maybe some can be RESOLVED FIXED by now or need a question. Please leave your reply on the bug web page - I might not see replies to this mail. Ideally, tell irc.oftc.net #koha know that you're looking at a bug. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5697 Automatic linking in guided reports http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6223 Patron categories should have a default set of permissions http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5627 lock symbol even on not locked fields http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6344 Hold priority displayed incorrectly when "Toggle Lowest Priority" option is used http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4231 Placing holds from cart fails silently http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4418 Enable required option for patron attributes http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6041 Errors from _koha_modify_item are ignored in ModItem (C4/Items) http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5985 Incorrect date in budgets and failed to edit funds children http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2465 availability of a reserved book http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5968 News display on opac-main.pl is particular about browser language settings http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5286 Problems with dates on expected issues in serials http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3796 Place a hold on a specific copy allows impossible items http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5365 cannot reopen a basket http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5535 users tags not appearing until approved http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5144 Duplicate holds allowed if patron clicks back button after placing hold http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5823 Repeated check in of on-hold item fails to show hold information http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6421 ability to have different opac styles for different libraries http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3578 different_IP auth is too strict for many services http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5272 can't import just patron attributes -- Email robot driven by MJ Ray (slef), member of www.software.coop, http://koha-community.org supporter, web and library systems developer. Available for hire (including development) at http://www.software.coop/

1 0

3.6.1 upgrade to 3.8.5 and bug 8071
by Paul 06 Jun '13

06 Jun '13

In my continuing quest to upgrade 3.6.1 to 3.8.x without loss of functionality (specifically authorities, generally zebra) I have now upgraded my sandbox (db fully synchronized with the production box) to 3.8.5 along the lines of "bug 8071 blocker" ... however in 3.8.5: Results 1 to 20 of 424 Summary Used in Delete World War, 1914-1918 Details 0 biblio(s) Delete World War, 1914-1918 Aerial operations. Details 0 biblio(s) Delete / ... / in 3.6.1: World War, 1914-1918 Details 5 biblio(s) World War, 1914-1918 Aerial operations. Details 16 biblio(s) / ... / So, are authorities during the upgrade still broken? Is it my db? I did do a "test" during the upgrade: paul@server:/koha-3.08.05$ sudo make test / ... / Test Summary Report ------------------- t/Barcodes_ValueBuilder.t (Wstat: 512 Tests: 0 Failed: 0) Non-zero exit status: 2 Parse errors: Bad plan. You planned 10 tests but ran 0. Files=89, Tests=8155, 15 wallclock secs ( 0.72 usr 0.13 sys + 13.75 cusr 0.86 csys = 15.46 CPU) Result: FAIL Failed 1/89 test programs. 0/8155 subtests failed. make: *** [test_dynamic] Error 255 but decided (despite that) to try: paul@server:/koha-3.08.05$ sudo make upgrade No errors reported From web interface: Update report : Upgrade to 3.08.04.001 done (Bug 8657 - Default sort by call number does not work. Correcting system preference value.) Upgrade to 3.08.04.002 done. (Bug 8002: Update patron attribute types table from varchar(1) to varchar(10) category_code) Warning to Koha System Administrators: If you use borrower attributes defined by borrower categories, you have to check your configuration. A bug may have removed your attribute links to borrower categories. Please check, and fix it if necessary.Upgrade to 3.08.05.000 (3.8.5 release) done So ... is 3.8.x repairable? What am I missing? thanks - Paul

3 7

Broken url in arabic facets.. and fix
by Bernardo Gonzalez Kriegel 06 Jun '13

06 Jun '13

Hi, Karam made an interesting discovery for Bug 10176 [1], putting "use utf8;" on Search.pm fixes URL of facets (not display well for me, but url works). Digging a little I found that on line 574 of master Search.pm there is a strange symbol (last between []). Seems to be an inverted question mark. Karam saids that is Arabic one. 572:# Sanitize the link value : parenthesis, question and exclamation mark will cause errors with CCL 573- my $facet_link_value = $one_facet; 574- $facet_link_value =~ s/[()!?¡¿؟]/ /g; 575- Question: this char is a typo? Was introduced on Bug 9183 [2] 'use utf8;' fixes the substitute, and the URLs. Also removing that char gives the same effect (without 'use utf8:' Patch is from jcamins Regards, bernardo [1] http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10176 [2] http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9183 -- Bernardo Gonzalez Kriegel bgkriegel(a)gmail.com

4 6

does anyone have any updates to the XSLT stylesheets in Koha, to the latest MARC21 specs?
by Mason James 06 Jun '13

06 Jun '13

hi Folks has anyone made any start on updating the XSLT stylesheets in Koha to the latest MARC21 specs i am about to start on this task and i do not want to duplicate any existing effort :) i guess i should look at the Kobli code, to see if they have made some updates… thanks, Mason

1 0

OPAC dir structure redesign
by Mason James 05 Jun '13

05 Jun '13

hi All Owen and I were talking recently about a plan to improve the current OPAC directory structure... the big problem is there is currently much duplication of unnecessary dirs/files. each theme has many duplicated files - and each language for each theme has many duplicated files all this duplication means that subtle bugs can occur... now that we have got the awesome new CCSR theme added, the next step is to fix the OPAC dir structure to accommodate multiple themes easily and safely :) i have a proposed redesign, which i think is the best balance of removing all duplication, and making the least number of changes to the existing structure in the new design there are 2 new top-level dirs, 'themes' and 'langs'. note: these are the *only* newly created dirs - the rest of the redesign is simply moving existing dirs from one location to another location each theme's dir (eg: prog or ccsr) only needs a 'css' dir, all other theme's existing subdirs can be moved to the shared top-level 'lib' and 'images' dirs again, with the language subdirs… each 'langs' subdir (eg: en or fr-FR) only needs an 'includes', 'modules', and 'xslt' dir (as these are the only dirs that have any actual language translation/substiution applied to them) all other existing language's subdirs can be moved to the shared top-level 'lib' and 'images' dirs, too below is an example of a redesigned OPAC dir structure, for 2 themes, with 2 languages (en and fr-FR) the directory/file count has been reduced from from 124 directories, 2542 files… to 60 directories, 1857 files any thoughts or improvements...? opac-tmpl └── themes (new) ├── ccsr │ └── css └── prog └── css ├── langs (new) │ ├── en │ │ ├── includes │ │ │ └── search │ │ ├── modules │ │ │ ├── errors │ │ │ ├── sco │ │ │ ├── search │ │ │ ├── svc │ │ │ └── text │ │ └── xslt │ └── fr-FR │ ├── includes │ │ └── search │ ├── modules │ │ ├── errors │ │ ├── sco │ │ ├── search │ │ ├── svc │ │ └── text │ └── xslt ├── images (existing, shared for all themes and langs) │ ├── datatables │ └── itemtypeimg │ ├── bridge │ ├── carredart │ ├── colors │ ├── crystal-clear │ ├── liblime-kids │ ├── npl │ ├── Seshat │ └── vokal ├── lib (existing, shared for all themes and langs) │ ├── famfamfam │ │ ├── mini │ │ └── silk │ ├── greybox │ │ └── GreyBox_v5_5 │ │ ├── adobe_images │ │ ├── compression_lib │ │ ├── greybox_source │ │ │ ├── base │ │ │ ├── gallery │ │ │ ├── set │ │ │ └── window │ │ └── static_files │ ├── jquery │ │ ├── images │ │ └── plugins │ │ └── themes │ │ └── classic │ └── yui │ ├── container │ ├── menu │ └── utilities

13 22

git koha >koha 3.12.00
by Samuel Desseaux 05 Jun '13

05 Jun '13

hi, i've a git question: I've made a git remote update and a git rebase v3.12.00 on my test instance but i keep the same version( 3.11.00.203), An idea? Best regards, Samuel

3 3

search on opac: no results
by Samuel Desseaux 04 Jun '13

04 Jun '13

Hi, We have a bug with the opac since a few days. Whatever the search give no results. I don't know what happen and it seems very strange. I put here all the logs i have. The ownership of the files are ok but something is missing.... koha@tst-koha:~/var/log$ ls koha-error_log koha-opac-error_log koha-zebradaemon.err koha-zebradaemon-output.log README koha@tst-koha:~/var/log$ tail -f koha-opac-error_log [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:38 2013] [error] [client 138.195.30.33] File does not exist: /home/koha/kohaclone/koha-tmpl/images, referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search-history.pl ^C koha@tst-koha:~/var/log$ tail -f koha-zebradaemon.err 20130529 14:03:41 koha-zebra-ctl.bibecp: client (pid 17514) exited with 1 status 20130529 14:03:41 koha-zebra-ctl.bibecp: client (pid 17515) exited with 1 status 20130529 14:03:41 koha-zebra-ctl.bibecp: terminating too quickly, waiting 30 seconds 20130529 14:04:11 koha-zebra-ctl.bibecp: client (pid 17521) exited with 1 status 20130529 14:04:11 koha-zebra-ctl.bibecp: client (pid 17522) exited with 1 status 20130529 14:04:11 koha-zebra-ctl.bibecp: client (pid 17523) exited with 1 status 20130529 14:04:12 koha-zebra-ctl.bibecp: client (pid 17524) exited with 1 status 20130529 14:04:12 koha-zebra-ctl.bibecp: client (pid 17525) exited with 1 status 20130529 14:04:12 koha-zebra-ctl.bibecp: terminating too quickly, waiting 30 seconds 20130529 14:04:19 koha-zebra-ctl.bibecp: fatal: terminated ^C koha@tst-koha:~/var/log$ tail -f koha-zebradaemon-output.log 14:03:41-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:03:41-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:03:41-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:03:41-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:03:41-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:04:11-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:04:11-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:04:11-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:04:12-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:04:12-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] koha@tst-koha:~/var/log$ ps -aux | grep zebra Warning: bad ps syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html koha 17633 0.0 0.3 99752 8224 ? S May29 0:00 zebrasrv -f /home/koha/etc/koha-conf.xml koha 29582 0.0 0.0 9616 908 pts/0 S+ 16:05 0:00 grep zebra koha@tst-koha:~/var/log$ Thank you for your help samuel

2 1

Re: [Koha-devel] Extracting bibliographic records with specified
by Stefano Bargioni 04 Jun '13

04 Jun '13

A possibile solution: mysql_prompt> SELECT marc FROM biblioitems WHERE ExtractValue(marcxml,'count(//datafield[@tag="040"]/subfield[@code="a"])>0') into outfile '/full/path/to/yourfile.mrc' fields terminated by '' lines terminated by ''; HTH. Stefano On 04/giu/2013, at 12.00, Mohamed zalabany wrote: > Date: Tue, 4 Jun 2013 07:28:27 +0000 > From: Mohamed zalabany <mh_zalabany(a)hotmail.com> > To: koha_developers <koha-devel(a)lists.koha-community.org> > Subject: [Koha-devel] Extracting bibliographic records with specified > criteria > Message-ID: <BLU165-W99C24B66C171B9107F681979E0(a)phx.gbl> > Content-Type: text/plain; charset="iso-8859-1" > > Hi all > i wish you all fine > I need to extract some bibliographic record from my catalog depanding on search criterea in MARC field 040$c > how could i do that and extract this records in one file > i think i could do that from the reports but how to make one file of all the record to import it later in another system > Thanks, > Best Regrades > > Mohamed El-Zalabany > Librotech group > for library systems and information technology

1 0