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

web installer (fix & new feature)
by Paul POULAIN 03 Jul '07

03 Jul '07

Hi folks, I've updated/fixed the installer : Now the database Version (defined in version systempreference) is compared to the Koha version (defined by <kohaversion>XXX</kohaversion> in koha.xml file). If the Version systempref does not exist or is lower than kohaversion, you're redirected to installer. If there is no Version, you're redirected to the 1st step of the installer (full install). If Version < kohaversion, you're redirected to step 3 (updatedatabase). With this new feature, when installing a new version [1], you'll automatically be redirected to the step 3 of the installer to run updatedatabase. WARNING : check that you have <kohaversion> in you koha.xml, otherwise, you'l loop forever to the installer... HTH [1] once the tech installer/updater will be written and if it updates correctly the kohaversion, which is, now something that it will have to do ! -- 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

Summary of Koha Project Day
by Joshua M. Ferraro 03 Jul '07

03 Jul '07

Hi all, Yesterday we had another Koha Project Day. Below is a summary of the goings on. We're 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 koha project team? Let us know. Summary follows: We met some new folks, so extending a welcome to martinmorris, who's working on configuring Koha; and thanks to jaron for some support help on that front. Dewey was up to his usual tricks, and we fed him multitudinous botsnacks :-) Slef worked on improvements to the installation process, thanks for the commits! Tina and I picked up some books on interface design and started learning about typical processes for designing application interfaces (not just websites), with the intent to improve the 3.0 interfaces before the release. I also installed plone and played around with some workflows for managing users, groups, and roles. We discovered that, like Koha, plone is quite powerful, but requires plenty of customization :-) Chris spent most of the day fixing bugs in HEAD and commiting fixes to the CSS for Russ. Chris and I also spent some time refining our plan for moving to Git. Russ played around with plone, learned up on the plone help center product, moving some content into a plone install to see how it might work (see http://new.koha.org:8080/koha/author/rwgarlick for some of he content created. The Plone Help Center product looks like the goods for Koha documentation, but there are still some kinks to iron out before we have it going properly. Russ also did some testing of HEAD (version 3), in particular fixed a bug with the san-op.css which was obscuring the secondary navigation. Reported a few other bugs that Chris is working on. Ryan and Mason were super busy getting ready for a golive that happened this morning, so they opted out this time. I'm sure they'd rather be working on project stuff, just don't tell the clients :-). Sara spent some time updating lists of koha users found in the wild (they're everywhere! :-)). The best lists now are libwebcats and the Koha wiki, but we're working on a new worldmap that we hope will launch within the next coupla months. 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. 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

2 1

IRC Meeting Logs
by Bradley Peters 03 Jul '07

03 Jul '07

Greetings, Are logs of the IRC developer meetings available somewhere on the web? On koha.org [1] it just says the channel is logged, but I don't know anything about the logbot that is mentioned. [1] http://www.koha.org/community/irc.html Thanks, Bradley Peters.

3 2

Koha Developers' Meeting Summary
by Joshua M. Ferraro 03 Jul '07

03 Jul '07

Koha Developers' Meeting Summary Hi gang, we had another well-attended (and exciting!) developers' meeting today. Here's a very brief summary of what went on. Feel free to expand on stuff I missed, etc. Agenda: http://wiki.koha.org/doku.php?id=meetingnotes07july02 Time: 19:00 GMT: http://tinyurl.com/3ajpxh Place: irc.katipo.co.nz #koha Moderated by: Joshua Ferraro Roll Call: paul, chris, russ, ryan, owen, WPL, kolibrie, Irma, thd, tumer, sanspach, pecisk Brief intros, welcome to newbies, Bart library IT guyfrom Westerville Ohio, USA and kolibrie, a programmer from Fairfax, VA USA Open Positions in the Community We need role descriptions, and we can ask for volunteers and people can nominate their favorite volunteer Translations Manager - kados can continue to do this, he enjoys it, but doesn't have quite enough time to do a great job, but will happily hand it over if someone with a vested interest wants to take over Documentation Manager - Russ volunteered, no-one objected :-) Quality Assurance Manager - Chris volunteered, no-one objected :-) FAQ Manager - jaron expressed interest, he'll let us know if he is willing to commit to it next week we'd like to get more users involved in the process, aren't sure how to attract them it'd be useful to send a mail to koha and koha-devel list explaining what a Kaitaiki is, why we need one, and finding out if anyone would be interested in filling that role. Git - Distributed Version Control -- we're still hashing out the details, nothing solid to show yet, check back at the next meeting. Release of 3.beta goal is to release it in July a new installer is top priority second might be a new set of templates if we have time bug fixing continues Koha and Copyright thd sent through some clarification on copyright to help us understand the issues http://lists.gnu.org/archive/html/koha-devel/2007-07/msg00001.html (section 5) there's some good data there, check it out -- 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

Koha Developers' Meeting
by Joshua M. Ferraro 02 Jul '07

02 Jul '07

At the last meeting, we tentatively picked Monday, July 2nd at 19:00 GMT for the next meeting. Here's the time in your area: http://tinyurl.com/3ajpxh I'd like to give the folks who weren't able to attend last time a chance to suggest alternate times, so please let us know if that date/time wont work for you and we'll try to find another. Also, I've put an agenda up. It includes some of the items we didn't have time for at the last meeting as well as some new ones. Feel free to add stuff you'd like to discuss: http://wiki.koha.org/doku.php?id=meetingnotes07july02 Cheers, Joshua -- 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

3 3

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 25 Jun '07

25 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