May 2012 - Koha-bugs - lists.koha-community.org

[Bug 7443] New: Change the mysql commands in the INSTALL.* files
by bugzilla-daemon＠bugs.koha-community.org 09 Dec '12

09 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7443 Bug #: 7443 Summary: Change the mysql commands in the INSTALL.* files Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 - low Component: Documentation AssignedTo: nengard(a)gmail.com ReportedBy: magnus(a)enger.priv.no QAContact: ian.walls(a)bywatersolutions.com Currently the instructions in INSTALL.debian, INSTALL.ubuntu and INSTALL.ubuntu.lucid for setting up the database looks like this: 103 $ mysqladmin -uroot -p<password> create <kohadatabasename> 104 $ mysql -uroot -p<password> 105 106 Welcome to the MySQL monitor. Commands end with ; or \g. 107 Your MySQL connection id is 22 108 Server version: 5.0.51a-24 (Debian) 109 110 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. 111 112 mysql> grant all on <kohadatabasename>.* to '<kohadatabaseuser>'@'localhost' identified by '<kohadatabaseuserpassword>'; 113 Query OK, 0 rows affected (0.00 sec) 114 115 mysql> flush privileges; 116 Query OK, 0 rows affected (0.00 sec) Speaking as a not overly experienced Linux user, I think this would be slightly easier to understand: -------------------------------------------------------- $ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 22 Server version: 5.0.51a-24 (Debian) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database <kohadatabasename>; mysql> grant all on <kohadatabasename>.* to '<kohadatabaseuser>'@'localhost' identified by '<kohadatabaseuserpassword>'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) -------------------------------------------------------- This would: - avoid the constrct -uroot, which might be mistaken for a long option with one dash - use the mysql command for everything, and not drag mysqladmin into it - avoid putting the password on the commandline and thence potentially into the output of commands like top and ps, and the bash history file Opinions? Not so sure about these: - INSTALL.fedora7 has "mysql-u root-p" which i assume is a typo for "mysql -u root -p"? - INSTALL.opensuse has "mysqladmin -uroot create koha -p" which i think might be re-written in the way i suggest above? -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.

1 1

[Bug 8062] New: Cart email broken for non english templates
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '12

05 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8062 Priority: P5 - low Change sponsored?: --- Bug ID: 8062 Assignee: frederic(a)tamil.fr Summary: Cart email broken for non english templates Severity: critical Classification: Unclassified OS: All Reporter: katrin.fischer(a)bsz-bw.de Hardware: All Status: NEW Version: rel_3_6 Component: I18N/L10N Product: Koha Sending an email with the contents of your cart is broken in non english templates. To reproduce: - Search OPAC - Add some titles to your cart - Open cart and try to send you the contents - log in, if you didn't before - Send cart to any email address - Check email text and attachements The mail sent from the translated templats has subject "no subject" and is empty. The marc files are attached. The mail sent from the english templates is all correct. This is an important OPAC feature for some libraries. Bug has been confirmed in 3.6.3 with German templates and in 3.6.4 with Arabic templates. Still has to be confirmed against master and 3.8. -- You are receiving this mail because: You are watching all bug changes.

1 42

[Bug 5424] New: Intranet interface references intranet/htdocs/opac-tmpl which does not exist
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '12

05 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5424 Summary: Intranet interface references intranet/htdocs/opac-tmpl which does not exist Change sponsored?: --- Product: Koha Version: rel_3_2 Platform: All OS/Version: All Status: NEW Severity: normal Priority: P5 Component: Searching AssignedTo: gmcharlt(a)gmail.com ReportedBy: dpk(a)randomnotes.org QAContact: koha-bugs(a)lists.koha-community.org Estimated Hours: 0.0 A number of different searches appear to generate references to intranet/htdocs/opac-tmpl which does not exist. Example: Home > Authorities Authority search for "England" => get a hit with 611 biblios. Select biblios to see the first 20 => a list of biblio entries This was the URL: http://kohaadmin.efdss.org/cgi-bin/koha/catalogue/search.pl?type=intranet&o… This was logged in koha-error_log: [Sun Nov 21 13:48:59 2010] [error] [client 92.234.0.16] File does not exist: /usr/share/koha/intranet/htdocs/opac-tmpl, referer: http://kohaadmin.efdss.org/cgi-bin/koha/catalogue/search.pl?type=intranet&o… -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.

1 4

[Bug 7439] New: Mailmap for 3.6.x not complete
by bugzilla-daemon＠bugs.koha-community.org 03 Dec '12

03 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7439 Bug #: 7439 Summary: Mailmap for 3.6.x not complete Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_6 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 - low Component: Developer documentation AssignedTo: gmcharlt(a)gmail.com ReportedBy: jcamins(a)cpbibliography.com QAContact: ian.walls(a)bywatersolutions.com The mailmap for 3.6.x is not complete. This bug is for tracking patches to fill in missing information. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.

1 24

[Bug 7475] New: Option to overlay authorities
by bugzilla-daemon＠bugs.koha-community.org 03 Dec '12

03 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7475 Bug #: 7475 Summary: Option to overlay authorities Classification: Unclassified Change sponsored?: Seeking cosponsors Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 - low Component: MARC Authority data support AssignedTo: jcamins(a)cpbibliography.com ReportedBy: jcamins(a)cpbibliography.com QAContact: koha.sekjal(a)gmail.com Depends on: 7284 Right now it is impossible to overlay existing records when importing new authority records. There needs to be a script that handles the following overlay options: * Overlay (or discard) based on matching preferred headings (1xx in MARC21, 2xx in UNIMARC) * Overlay (or discard) based on matching LCCNs (010 in MARC21) * Overlay (or discard) based on matching control numbers (001 for both MARC21 and UNIMARC) * Overlay (or discard) based on matching an earlier form of the heading (4xx$w/2=[aeo] in MARC21, 4xx$5=a in UNIMARC) * Select which record to keep based on the date last modified (003 in MARC21) This script will enable libraries to keep their authority records up to date with the latest national authority files, without polluting the local authority file with numerous copies of authority records (every time they are updated). -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.

1 19

[Bug 7698] New: Add ICU option to Koha out of the box
by bugzilla-daemon＠bugs.koha-community.org 03 Dec '12

03 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7698 Priority: P5 - low Change sponsored?: --- Bug ID: 7698 Assignee: frederic(a)tamil.fr Blocks: 3216 Summary: Add ICU option to Koha out of the box QA Contact: koha.sekjal(a)gmail.com Severity: enhancement Classification: Unclassified OS: All Reporter: jcamins(a)cpbibliography.com Hardware: All Status: NEW Version: master Component: I18N/L10N Product: Koha Word search with multi-part facets works properly only with Zebra ICU tokenization. This patch add a new question to Koha command line installer: Zebra has two methods to perform records tokenization and characters normalization: CHR and ICU. ICU is recommended for catalogs containing non-Latin characters. (chr, icu) [chr] How to test: - perl ./Makefile.PL - Try each possible value for new parameter - Take a look at zebradb/etc/default.idx file. Depending of the parameter you get this line: icuchain words-icu.xml or this one: charmap word-phrase-utf.chr (copied from bug 3216) -- You are receiving this mail because: You are watching all bug changes.

1 6

[Bug 8092] New: Koha should use CHI caching framework
by bugzilla-daemon＠bugs.koha-community.org 03 Dec '12

03 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8092 Priority: P5 - low Change sponsored?: --- Bug ID: 8092 Assignee: jcamins(a)cpbibliography.com Summary: Koha should use CHI caching framework Severity: enhancement Classification: Unclassified OS: All Reporter: jcamins(a)cpbibliography.com Hardware: All Status: NEW Version: master Component: Architecture, internals, and plumbing Product: Koha Rather than directly accessing Memcached, etc., we should use CHI and its already-existing cache drivers. -- You are receiving this mail because: You are watching all bug changes.

1 24

[Bug 6800] New: Koha authentication should handle proxies better
by bugzilla-daemon＠bugs.koha-community.org 03 Dec '12

03 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6800 Bug #: 6800 Summary: Koha authentication should handle proxies better Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_6 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Authentication AssignedTo: jcamins(a)cpbibliography.com ReportedBy: jcamins(a)cpbibliography.com QAContact: koha-bugs(a)lists.koha-community.org CC: dpavlin(a)rot13.org At the moment, Koha's authentication/session feature uses the remote address for its sessions. In situations with load balancers or other proxies, the REMOTE_ADDRESS will be the proxy address rather than the client address. In order to handle proxied clients (or any clients when behind a load balancer), Koha needs to use the X-Forwarded-For header to identify the ultimate client. This problem can be seen by configuring Koha to listen on 127.0.0.1 and setting up a Squid proxy with the following configuration options on the same server: # BEGIN SQUID CONFIGURATION # The next two lines must go at the top of the squid configuration file: http_port ${PUBLIC_IP}:80 accel defaultsite=${YOUR_DOMAIN} vhost cache_peer 127.0.0.1 parent 80 0 no-query originserver name=myAccel # The next four lines must go AFTER the line "acl CONNECT method CONNECT acl our_sites dstdomain .${YOUR_DOMAIN} http_access allow our_sites cache_peer_access myAccel allow our_sites cache_peer_access myAccel deny all # END SQUID CONFIGURATION If you view the session log after connecting via ${PUBLIC_IP}:80, you will see an entry for 127.0.0.1. Although X-Forwarded-For can be spoofed, in situations where all clients would have the same immediate REMOTE_ADDRESS (e.g. load balancing, reverse proxy, corporate firewall), using X-Forwarded-For seems the lesser of two evils (if you're running the proxy, you can guarantee that the most recent entry in X-Forwarded-For is accurate). -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 13

[Bug 8159] New: Error in kohastructure.sql
by bugzilla-daemon＠bugs.koha-community.org 03 Dec '12

03 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8159 Priority: P5 - low Change sponsored?: --- Bug ID: 8159 CC: gmcharlt(a)gmail.com Assignee: jcamins(a)cpbibliography.com Summary: Error in kohastructure.sql Severity: critical Classification: Unclassified OS: All Reporter: jcamins(a)cpbibliography.com Hardware: All Status: NEW Version: master Component: Installation and upgrade (web-based installer) Product: Koha A missing semicolon in kohastructure.sql causes the webinstaller to give a very scary-looking error. It actually works fine, however, and when the install is entirely automated you quite likely won't even notice. Patch forthcoming. -- You are receiving this mail because: You are watching all bug changes.

1 6

[Bug 8117] New: Divide budget periods into two tabs
by bugzilla-daemon＠bugs.koha-community.org 03 Dec '12

03 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8117 Priority: P5 - low Change sponsored?: --- Bug ID: 8117 Assignee: henridamien(a)koha-fr.org Summary: Divide budget periods into two tabs Severity: enhancement Classification: Unclassified OS: All Reporter: jonathan.druart(a)biblibre.com Hardware: All Status: NEW Version: unspecified Component: Acquisitions Product: Koha Budget periods are now divided into two tabs : active and inactive budget periods. -- You are receiving this mail because: You are watching all bug changes.

1 43