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

database for Koha 3.0 : database schema cleaning
by Paul POULAIN 26 Jun '07

26 Jun '07

Hello all, i've committed a .sql file with uptodate SQL structure for Koha 3.0 ($KOHA/installer/kohastructure.sql), but get some question : - are the labels, label_conf, C4/Labels.pm, ... still needed ? by the label editor ? looking at Labels.pm, there is a reference to labels_templates table that I've never seen anywhere. Something missing ? - mediatypetable seems useless (used only by admin/mediatype.pl script, that is not used by anything) I've removed this table, cry if I was wrong - I had a sessionqueries table, that was empty and never used in CVS, i dropped it too - I've a category and subcategorytable tables that are called only by admin/itemtype[sub]category.pl, what are they done for ? They had been commited by genjimoto in 2005-06, and never updated (except "automatic" code cleaning) I removed both. Cry if I was wrong - I removed the uploadedmarc table, that was a reminder of something made by steve T. iirc, and no more useful Waiting for your feedback if something is wrong in this cleaning. -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19

1 0

translation to Portuguese of the npl-OPAC template
by Pedro Maia 26 Jun '07

26 Jun '07

Hello it's the first time i am sending an email to this list. I have a contribution to the Koha comunity, the translation to Portuguese of the npl-OPAC template. It was translated by me and revised by two other colleagues here in Instituto de Informática do Ministério das Finanças e Administração Pública in Portugal. I think the result is very good and accurate, but of course it can still have some errors. I'm not sure this is the right place to submit the file... I am now working in the translation of npl-INTRANET and as soon as it is finished i will send it to the comunity. Translation Team: Main Translator - Pedro Maia Revised by - Fernanda Lobo ; Dulce Matos Best Regards Pedro Maia Centro de Informação e Documentação Instituto de Informática do Ministério das Finanças e da Administração Pública pedro.maia(a)inst-informatica.pt +351 214723295 <http://www.inst-informatica.pt/cid>

2 1

Re: [Koha] Re: OpenSolaris and kohaadmin rights at installation
by Chris Cormack 25 Jun '07

25 Jun '07

On 25/06/2007, at 11:23 AM, Rick Welykochy wrote: > Chris Cormack wrote: > >> Ive fixed this in cvs now, in the rel_2_2 branch. >> So if you grab the Install.pm file from cvs you will get the fix. >> Otherwise, the change is line 1083 >> system("$mysqldir/bin/mysql '-u$mysqluser' -e \"GRANT ALL >> PRIVILEGES on ".$database.".* to '$user' IDENTIFIED BY '$pass' \" >> mysql"); >> becomes >> system("$mysqldir/bin/mysql '-u$mysqluser' -e \"GRANT ALL >> PRIVILEGES on ".$database.".* to '$user'\@'localhost' IDENTIFIED >> BY '$pass' \" mysql"); > > > Chris, > > IIRC, when I specify a host different from 'localhost' for the MySQL > configuration during install.pl, the install fails. This is because > 'localhost' is hardcoded in various parts of the install. > > See http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1323 > for details. > > Might I suggest that @'localhost' be replaced by @'$installhost' > in the above, so that it works with any server configured for > MySQ, not just localhost. > > Hi Rick Yep long term thats the plan, short term, there is no $installhost defined at that point, nor are we currently prompting the user for the host. So I wanted to get a fix out that would allow the people with mysql 5 (who were currently trying to install on localhost) get koha installed. Phase 2 can be to prompt the user for a hostname for the mysql db and use that. I'm taking volunteers? :) Chris PS Im trying to shift development discussion to the dev lists, so we dont clutter the main Koha list up. so if you could reply to there that would be great. -- Chris Cormack chris.cormack(a)liblime.com VP Research and Development www.liblime.com LibLime +64 21 542 131

2 1

Koha Project Day Summary
by Joshua M. Ferraro 25 Jun '07

25 Jun '07

Hi gang, We had another Koha Project Day yesterday. Here's a summary of what we did: Chris worked on a few more unit tests, finishing off the tests for C4::Date. Quite a bit of wiki cleaning and thinking/talking about how to use git in the project. Of course, chris also blogged about his koha project day: http://blog.bigballofwax.co.nz/articles/2007/06/25/koha-project-day-2 Russ worked on the styles of the supplemental sites koahdocs.org, translate.koha.org, contribs.koha.org; took a look at Plone as a possible replacement for our current koha.org site; started doing some bug reports for version 3, and got selenium going: http://bugs.koha.org/cgi-bin/bugzilla/attachment.cgi?id=109 Mason did more bugzilla updates, and started on the process of updating default templates in rel_2_2 so they will be suitable for a 2.2.10 release Josh worked with Chris on git, and added some documentation (partial still) on how to use it for the Koha project. Ryan helped some folks who wandered in with questions they had. Feel free to join us next week, the festivities will start at 12:00pm EST and continue for about 12 hours. To join us, you'll need to download an IRC client (for Windows, mIRC is pretty good: www.mirc.com/) and point it at irc.katipo.co.nz and the channel #koha. We're also thinking of moving the day of the week we do this on to give more folks the opportunity to get involved ... is there a day of the week that would work best for you and your team? Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

1 0

Re: [Koha] Re: OpenSolaris and kohaadmin rights at installation
by Chris Cormack 24 Jun '07

24 Jun '07

On 22/06/2007, at 1:01 AM, Thommy M. wrote: > > Nope, exactly the same error from what I see... > > Creating the MySQL database for Koha... > > ERROR 1045 (28000): Access denied for user > 'kohaadmin'@'localhost' (using password: YES) > > DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied > for user 'kohaadmin'@'localhost' (using password: YES) at /usr/ > local/koha/intranet/modules/C4/Context.pm line 411 > Can't call method "prepare" on an undefined value at scripts/ > updater/updatedatabase line 1553. > Problem updating database... > root@schumi:/opt/local/src/koha-2.2.8# > > > Did this before running the new install: > > mysqladmin -f -uroot -p drop Koha > mysql -uroot -p -Dmysql -e"delete from user where user='kohaadmin'" > mysql -uroot -p -Dmysql -e"delete from db where user='kohaadmin'" > mysqladmin -uroot -p reload > > Shifting this to the devel list as it seems a better place to talk about it. I think I have round the problem, heres what happens essentially the installer runs mysql -uroot -e "GRANT ALL PRIVILEGES on Koha2.* to 'kohaadmin2' Identified by 'fish'" Then it tries to use that user .. this worked with MySQL 4 .. but with MySQL 5 we need mysql -uroot -e "GRANT ALL PRIVILEGES on Koha2.* to 'kohaadmin2'@'localhost' Identified by 'fish'" If someone who is running MySQL 4 could try the above statement and make sure it works fine with 4 ... i'll update the installer, if it doesnt, Ill update it to do a version check and then run the appropriate grant line. If I dont hear back by morning 7 time (about 11 hours), Ill get a version 4 up and running so I can test. For the people who want to install 2.2.9 with MySQL 5 you can edit line 1803 in Install.pm, to add the @'localhost' bit ie system("$mysqldir/bin/mysql '-u$mysqluser' -e \"GRANT ALL PRIVILEGES on ".$database.".* to '$user' IDENTIFIED BY '$pass' \" mysql"); becomes system("$mysqldir/bin/mysql '-u$mysqluser' -e \"GRANT ALL PRIVILEGES on ".$database.".* to '$user'\@'localhost' IDENTIFIED BY '$pass' \" mysql"); Hope this helps Chris -- Chris Cormack chris.cormack(a)liblime.com VP Research and Development www.liblime.com LibLime +64 21 542 131

1 1

Koha Day Report
by Joshua M. Ferraro 21 Jun '07

21 Jun '07

Hi everyone, Well, our first Koha day went off swimingly, got lots of project stuff accomplished, met some new people, and had loads of fun. But starting at 9:00am on a Sunday is just nutty for the US team, so we've decided to give ourselves a break and pick it up at noon next week :-). Feel free to join us this Sunday starting at 12:00pm EST. So ... it's really amazing what can be accomplished in a day, here are the highlights: We met some great new folks: Frederic from France, Luis from Peru, gganno the librarian from Mali Africa, bureado, lloyd from the UK, and jamesa. Mason investigated automatic testing with Selenium, which will really be helpful for QA testing. Also spent some time on bugzilla, cleaning some stuff up. Russ hacked on the mailman pages on the koha website, making them prettier and had some productive discussions with Tina about improvements to the koha.org site. Plan is to continue the discussions week after next. Chris actually blogged about his Koha day: http://wiki.koha.org/doku.php?id=meetingnotes07july02 If you were watching CVS you'll notice chris committed a bunch of test scripts; and if you were watching the wiki, there's quite a bit of technical documentation added as well. Randy took a look at the koha.org site and talked about improvements to be made from a project image standpoint; he also spent some time evaluating forum software and concluded that phpbb is probably the way to go Tina and Sara spent some time doing usability testing on the koha.org site and the koha interfaces. Also played around with some new project -specific graphics, mostly related to the koha.org website Finally, I worked on the 3.0 roadmap and read the Producing Open Source book, trying to glean some ideas for improving the project's release theory. i also worked a bit on the translation site, having some issues with the latest release's translation script I plan to hack further on next week. -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

2 1

Koha Developers' Meeting Minutes for June 18 2007
by Joshua M. Ferraro 21 Jun '07

21 Jun '07

ROLL CALL: ryan, paul, toins, tumer, thd, cm, kyle, jbrice, russel, pecisk, sanspach notably missing: hdl, chris, slef NEW MEMBERS, INTRODUCTIONS Crawford County Federated Library System welcomed to the dev chat. CCFLS launched their Koha system last month at their biggest library is running strong and looking forward to 8 more libraries joining later this year. Welcomed Pecisk to the community, he's a linux admin and developer and a big fan of OSS. Looking to start with translating and testing and move to development long-term GENERAL DEVELOPER NEWS Paul reports that 2 libraries are up and running on the soon-to-be 3.0 version of koha; the French team has also launched a new French bug tracker that will assist with French libraries reporting bugs; SAN-OP has published a RFP for a new acquisitions module; one more large public library in New Caledonia has signed up to switch to Koha in 2007. A French Non-Profit Organization for Koha has been created, called KohaLA Tumer reports a windows installable file for the NEU version of Koha. http://library.neu.edu.tr/cgi-bbin/koha/opac-downloads The Parliament library of Turkey plans to install Koha in about a month GIT DISTRIBUTED VERSION CONTROL + VERSION 3.0 RELEASE PLANS Kados described LibLime's adoption of Git internally for distributed version control and proposed moving the Koha code to CVS; developers decided that it was mainly up to the heavy committers and since all were in attendence we decided it's a go. LibLime team is responsible for pulling it off and providing good documentation for what the new procedures are, etc. kados described a proposed change to the release theory of the project: time-based releases. The theory is to do 6 releases a year broken into three types of releases: alpha,beta,stable. alpha - maybe some bugs, feature freeze, please test beta - most bugs fixed, we think it's stable, please test stable - tested, in production at some places Q: what if a bug appears in a sept-stable version that is discovered in, say, november? A: we release the stable version with the bug fix, so if the buggy release is 2.2.10, we releas 2.2.10b Q: how will we handle major new features that could not be done in just 6 months ? A:they can be created on a branch and merged when they are ready. Q:how will we handle when two teams are working on a similar feature at the same time? A: lots of options, probably best to make something complex like acquisitions a plugin so someone can use whatever acq module they want. best to make clear intention of developing a new module on the koha-devel list; discuss as much as possible with other interested parties; share the results. VERSION 2.2 RELEASE PLANS problem with rel_2_2 branch is that some changes added were only added to the npl templates. To avoid having a 2.2 and a 2.4, LibLime agreed to commit all changes made to default templates too and to make sure everything's working with both templates. Goal is to have 2.2.10 working with both templates and based on rel_2_2. COPYRIGHT CONVENTIONS We decided to discuss this further on-list, thd agreed to post some explainations of why there are some problems with the existing thread. OPENCATALOGER Toins previewed the OpenCataloger project, which is a new cataloging tool created to work independently from Koha, but also integrate with it. It's designed with professional catalogers in mind and has a more standard MARC editor look and feel. Well, very productive meeting folks, looking forward to the next one. Feel free to correct or add to my summary if I got something wrong or ommitted. Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

1 0

Announcing Koha Project Day
by Joshua M. Ferraro 17 Jun '07

17 Jun '07

Hi all, The management team here at LibLime is happy to announce a new initiative to foster community development and growth of the Koha project. As of this week, _every_ Sunday is Koha Project Day here at LibLime (for our NZ staff, this translates into Monday). Of course, throughout the week, we LibLimers spend the majority of our time working for our customers: writing specifications, doing development work, implementation, and support. Koha Project Day gives us a chance to give back to you -- the community that makes all of this possible! Barring any urgent support requests, or last-minute proposals due, we're planning to focus our energy entirely on the Koha Project itself during Koha Project Day -- every week. We'd like to extend the invitation to you, dear community. Join us any time on any Sunday and pitch in. Or, alternatively, pick a regular day/time that you find convenient and announce it to the rest of the community. It's strictly voluntary of course (for our staff too), so if you're unable to participate, we won't hold a grudge :-). But if you're able, join us and help out, there's plenty to do. Speaking of which, what is there to do? Glad you asked. Here's just a partial list: * organize and write documentation * write specifications for new proposed features * write technical documentation for existing Koha features * respond to questions/comments on the Koha lists * test features and report bugs * fix bugs :-) * read through the code and make comments * translate Koha into your native language * write that new feature you thought of * talk to the developers and tell them how to improve Koha Where is all of this happening? Well, you can join us in real time on the #koha channel on irc.katipo.co.nz. If you've not used IRC before, and you're running Windows, give mIRC a shot: http://www.mirc.com/ Well, that sums it up. Our first Koha Project Day starts tomorrow morning at 9:00am here in Ohio and runs for 15 hours to 5:00pm in New Zealand. If you're around, pop in and say hello :-) Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

1 0

Naming Conventions
by Joshua M. Ferraro 16 Jun '07

16 Jun '07

Hi all, A while back, I posed a question to these lists asking what the naming conventions were in your library for referring to patrons/ borrowers/users/etc. Thank you all for responding! The overwhelming majority of you said that you use the term 'patrons' most frequently. As a result, I suggest we change the naming convention within Koha's default templates to represent that majority. Some of you had feedback on other naming conventions as well. For instance, several said that 'check-out' and 'check-in' were preferred terms over 'issue' and 'return'. I've gotten the same feedback from quite a few libraries in my demos around North America. So, I'd also like to propose we adjust the default templates to reflect that majority. Of course, with our flexible translation framework, it's a fairly trivial procedure to change the wording in your local installation, if you prefer the current conventions. Any objections? Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

1 0

news from France
by Paul POULAIN 15 Jun '07

15 Jun '07

Hello world, There are 2 libraries in france that are running koha "3.0", from head CVS repository. One is a migration from Koha 2.2 The tools & method to migrate are working quite good now (I mean at least in UNIMARC). I've written some directions on the wiki. I also have written (in french) a doc that describes all new features. It's available on www.koha-fr.org (documentation section) It's provided in PDF. If someone volunteers to do a french => english translation, just ask for the OpenOffice version. Just note that it's 33 pages long... (with a lot of screenshots -in french too-, but still a lot of text) -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19

1 0