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

Fwd: [Koha-zebra] Apache issue
by Mason James 26 Mar '12

26 Mar '12

Begin forwarded message: > From: luis diaz <luisete2106(a)gmail.com> > Date: 24 March 2012 12:41:41 AM NZDT > To: koha-zebra(a)lists.koha-community.org > Subject: [Koha-zebra] Apache issue > > Hello > > I have a rhel6 server (Linux el6.x86_64 #1 SMP Fri Feb 10 15:22:22 EST 2012 x86_64 x86_64 x86_64 GNU/Linux) > Red Hat Enterprise Linux Server release 6.2 (Santiago) > > and I have install koha version 3.06.04 > So, all the steps have been done without errors, inclusive the compilation of all the perl packages. > But, I have an error with the apache configuration, the web pages do not appear, and I have this error: > > Internal Server Error > > The server encountered an internal error or misconfiguration and was unable to complete your request. > > Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error. > > More information about this error may be available in the server error log. > > Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request > > > I don't know what to look, the error_log do not helps here: > > [Fri Mar 23 06:43:20 2012] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) > [Fri Mar 23 06:43:20 2012] [notice] Digest: generating secret for digest authentication ... > [Fri Mar 23 06:43:20 2012] [notice] Digest: done > [Fri Mar 23 06:43:20 2012] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations > [Fri Mar 23 07:36:37 2012] [notice] caught SIGTERM, shutting down > [Fri Mar 23 07:36:38 2012] [notice] SELinux policy enabled; httpd running as context unconfined_u:system_r:httpd_t:s0 > [Fri Mar 23 07:36:38 2012] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) > [Fri Mar 23 07:36:38 2012] [notice] Digest: generating secret for digest authentication ... > [Fri Mar 23 07:36:38 2012] [notice] Digest: done > [Fri Mar 23 07:36:38 2012] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations > The specidif koha error log is empty: > > koha]# tail -200f /var/log/koha/koha-error_log > > Maybe I must disable this: > > SELinux policy enabled? > > Hope some one can help here. > > Thanks a lot in advance > > >

2 1

Adding support for PostgreSQL, no new MySQLisms, please
by Marc Balmer 24 Mar '12

24 Mar '12

Dear Koha-Devels, during the Marseille Hackfest 2012 I started together with Stephane and Christophe from BibLibre to add support for the PostgreSQL database. The ultimate goal of this work is that Koha can run on a PostgreSQL server as as good as it does now on a MySQL server. This mostly boils down to removing the MySQLisms in the current code, which I am currently doing. The collect-all-activity bug for this is 7365, it holds dependencies to the individual bugs like 7802, 7806 etc. (more to come, obviously). There is also a wiki page wiki.koha-community/wiki/PostgreSQL which I update frequently. This work also means that you must not add new MySQLisms in new code. Especially don't use backuotes in column names, write INSERT INTO foo (bar) VALUES (42); instead of INSERT INTO foo(`bar`) VALUES (42); For more idioms, consult above mentioned Wiki page, and if in doubt you can contact me, I am always willing to help with database issues. And please be advised that adding MySQLisms in new code will fail in QA. Thanks for your cooperation! If all goes well, this work should be concluded in a few months (but we are not in a hurry). - Marc Balmer

8 16

Next week is Global Bug Squashing Week!
by Magnus Enger 24 Mar '12

24 Mar '12

Dear Community, The deadlines for getting stuff into version 3.8 are drawing near: http://wiki.koha-community.org/wiki/Roadmap_to_3.8 As most of you are probably aware now, there will be a super cool hackfest in Marseille next week: http://drupal.biblibre.com/en/blog/entry/2012-hackfest-in-europe For those of us who can't be there in person, it's still possible to contribute to the fun, by joining the Global bug squashing week: http://wiki.koha-community.org/wiki/2012-03-19_Global_bug_squashing_week As far as I can tell, the beginning of this week will be the last chance for having new features signed off with any hope of getting them into 3.8. And there are bugfixes and minor improvements to look after. Not sure how you can help? Jump on the IRC channel ( http://koha-community.org/get-involved/irc/ ) and we will help you get started! And with the sandboxes provided by BibLibre all you need in order to join the fun is a web browser! http://wiki.koha-community.org/wiki/2012-03-19_Global_bug_squashing_week See you there! Magnus Enger

6 6

Hackfest 2012 in Marseille feedback
by Paul Poulain 23 Mar '12

23 Mar '12

Hello, If you want to know what we made during the hackfest i've written an entry in koha-community.org : http://koha-community.org/marseille-hackfest-2012-feedback/ Happy reading & thanks to all of those who came ! -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

Hourly loans -bug 5549- pushed, please test
by Paul Poulain 22 Mar '12

22 Mar '12

Hello, I just pushed a large patch that is related to hourly loans. It has been tested by a lot of ppl (including at the hackfest), but it's worth more tests, so feel free to update your git repositories and report the result of your tests here ! -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

For those running master
by Paul Poulain 22 Mar '12

22 Mar '12

Hello koha-devel, if any of you is running master, I pushed a large patch with a DB revision mistake yesterday. The 3.07.00.032 DBrev won't apply correctly. If you've already updated and have applied this DBrev, I suggest you run the following SQL commands: ALTER TABLE virtualshelves MODIFY COLUMN owner int; UPDATE virtualshelves vi LEFT JOIN borrowers bo ON bo.borrowernumber=vi.owner SET vi.owner=NULL where bo.borrowernumber IS NULL; DELETE FROM virtualshelves WHERE owner IS NULL and category=1; ALTER TABLE virtualshelves ADD COLUMN allow_add tinyint(1) DEFAULT 0, ADD COLUMN allow_delete_own tinyint(1) DEFAULT 1, ADD COLUMN allow_delete_other tinyint(1) DEFAULT 0, ADD CONSTRAINT `virtualshelves_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL; UPDATE virtualshelves SET allow_add=0, allow_delete_own=1, allow_delete_other=0 WHERE category=1; UPDATE virtualshelves SET allow_add=0, allow_delete_own=1, allow_delete_other=0 WHERE category=2; UPDATE virtualshelves SET allow_add=1, allow_delete_own=1, allow_delete_other=1 WHERE category=3; UPDATE virtualshelves SET category=2 WHERE category=3; ALTER TABLE virtualshelfcontents ADD COLUMN borrowernumber int, ADD CONSTRAINT `shelfcontents_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL; UPDATE virtualshelfcontents co LEFT JOIN virtualshelves sh USING (shelfnumber) SET co.borrowernumber=sh.owner; CREATE TABLE virtualshelfshares (id int AUTO_INCREMENT PRIMARY KEY, shelfnumber int NOT NULL, borrowernumber int, invitekey varchar(10), sharedate datetime, CONSTRAINT `virtualshelfshares_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `virtualshelfshares_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacAllowPublicListCreation',1,'If set, allows opac users to create public lists',NULL,'YesNo'); INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacAllowSharingPrivateLists',0,'If set, allows opac users to share private lists with other patrons',NULL,'YesNo'); If you haven't updated between yesterday and now, you have nothing to do, i've pushed a fix that will make your update work smoothly -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 1

Koha patron import
by ZUULU COOPER 22 Mar '12

22 Mar '12

Can anyone send me a copy a patron import file for me to try. I have run out of options. I recently installed Koha 3.06.04 Live DVD and I am getting errors the surname, borrowernumber, branchcode and categorycode. I do not know what I am doing wrong. I installed the Koha GSDL and I get the same error. I enter the some of sample data from the GSDL version into the LIVE DVD and I still get the same error. -- Zuulu Cooper Founder & Executive Director Libraries for Liberia Foundation 5919 Dakar Road West Suite 100 Westerville, OH 43081 614 270 3464 Skype: Shaka_zu00 website : http://librariesforliberiafoundation.com email: info(a)librariesforliberiafoundation.com *“Cause change and lead, accept change and survive, resist change and die.” * Ray Noorda - 1924-2006, technology pioneer, Novell Corporation CEO.

1 0

koha / installation
by Samuel desseaux 22 Mar '12

22 Mar '12

Hi, My question is very short and easy: what sort of installation of koha could you advice? By git or by the tarball? I work on a migration of our ILS for koha. Best regards samuel

2 1

Translation question
by Marcel de Rooy 22 Mar '12

22 Mar '12

Hi all, Sorry for cross-posting ;) Something in between.. Does anyone of you foresee problems with translating a construction like this one just as in the sysprefs? Allow/Do not allow (in combo) -- followed by text like: -- anyone to delete items from the list See screenshot: http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=8467 Thanks for your attention. Marcel

1 0

Call for News for the March Newsletter
by Daniel Grobani 21 Mar '12

21 Mar '12

Dear Koha Kommunitarians, I'm harvesting news for the March newsletter. Please send me by the 25th anything you think your fellow community members might like to know about. "News" can be as short as a sentence or as long as a paper. I especially encourage you to send me a line or two about what you're currently working on for publication in the gossip/society column. And if you know of a go-live not announced on the list, please be sure to let me know about it. Thanks, Daniel Grobani

2 1