Time Nick Message 10:27 chris you too 10:27 Fallor nice chatting with you 10:27 chris see you another time 10:27 Fallor so see you :) 10:27 chris oh cool 10:27 Fallor i've bought an appartment and i'm renewing it 10:27 chris good luck :) 10:27 Fallor now i have to go and carry my new kitchen in 10:26 chris cool 10:26 Fallor well, i'll send the .po to you later today or tomorrow 10:25 Fallor true 10:25 chris because sometimes you need to just go edit the templates because direct translations dont work 10:24 Fallor roll on the floor (i think that should be) 10:24 chris yeah, thats one of the reasons we went with html::templates 10:24 Fallor automatic machine translations usually make finns rolling on the floor 10:23 chris sometimes you cant just do it with po files 10:23 chris right 10:23 Fallor they are just very different languages 10:23 Fallor and that's not the only problem 10:22 Fallor it does indeed :D 10:21 chris ahh that would make it tricky 10:21 Fallor we express them with suffixes 10:21 Fallor for example we don't have words like from and to 10:21 Fallor the two are incompatible 10:21 Fallor it's difficult to translate english to finnish 10:21 chris hehe 10:20 Fallor it's _possibly_ better than your finnish translation would be ;) 10:19 Fallor some texts are a bad finnish 10:18 chris i bet its better than if i tried :) 10:18 Fallor mind you, it's not a perfect translation 10:17 Fallor so where shall i send it to? 10:16 chris ill get it added to the site 10:16 chris that would be great 10:16 Fallor i could send you the .po if you like 10:16 Fallor yep it's translated from the .po file 10:15 chris cool, the idea here is that we get the translated strings, and then can generate the templates for each version 10:15 Fallor it's quite complete but needs some brushing up 10:14 Fallor i do have somekind of finnish translation for the NPL templates 10:14 Fallor nope, i haven't seen that 10:14 chris ohhh, my wife would love that, shes an art teacher 10:14 chris oh and bonjour paul ( i forgot to say hi) 10:14 Fallor right now i'm doing one for the kuopio art museum 10:14 chris have you seen translate.koha.org? 10:13 Fallor i'm still studying 10:13 Fallor i've just done some random koha installations here 10:13 chris i worked for katipo from 1997, to 2007, and now for liblime 10:13 Fallor ok 10:12 paul I never worked for katipo myself, but works on koha since 4,5 years now. 10:12 chris paul is in france and works for paul :-) 10:12 Fallor well... both? ;) 10:11 chris i used to, until april this year 10:11 paul who ? me or chris ? 10:11 Fallor You work for Katipo? 10:11 paul good night chris 10:11 paul and frenchies will be afk soon : lunch time :-D 10:11 Fallor yes, of course 10:10 chris most of the US koha developers are still asleep :) 10:10 Fallor ah, ok 10:10 chris new zealand 10:10 Fallor you're from U.S.? 10:10 Fallor ok, welcome :) 10:08 chris its on my list of countries i want to visit one day 10:07 chris i met a couple of students from finland when i was in university 10:07 Fallor most people don't have a clue 10:07 Fallor and you understood it :) 10:07 Fallor yep :) 10:06 chris the suomi in ur host was what gave it away 10:06 chris heh 10:06 chris im guessing finland (as a random guess) 10:06 Fallor from finland 10:06 chris just out of curiousity can I ask where you are? 10:05 chris yep, there should be a koha-httpd.conf (in /etc) which is a decent start 10:05 chris sweet 10:05 Fallor now I'll just have to deal with httpd.conf 10:05 Fallor seems to be fine 10:04 chris cool 10:04 chris :) 10:04 Fallor wrong database... ;) 10:04 Fallor they exist alright 10:04 Fallor nope 10:03 Fallor and the same for Z3950servers; 10:03 Fallor ERROR 1146 (42S02): Table 'Koha.aqbudget' doesn't exist 10:03 Fallor they don't exist 10:02 chris if you get back table definitions from them, then all good, nothing to worry about 10:02 chris and describe z3950servers; 10:01 chris and do a describe aqbudget; 10:01 chris can you jump into the Koha db 10:01 chris when its finished the installer 09:56 chris ill just check what line 1717 is 09:56 chris by running some sql in mysql, so not a biggy 09:56 chris but we can fix that 09:56 chris i think you will be missing a table, or two 09:55 chris hmm could be 09:55 Fallor two DBD errors, is that a problem? 09:55 Fallor synch'ing borrowers 09:55 Fallor DBD::mysql::st execute failed: Invalid default value for 'id' at scripts/updater/updatedatabase line 1717. 09:55 Fallor DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at scripts/updater/updatedatabase line 1717. 09:53 chris in the installer 09:53 chris (or make a different user and db) 09:53 Fallor ok 09:53 chris so you will want to drop the db, and drop that user 09:53 Fallor let's try the installer again 09:53 chris cool 09:53 Fallor works now :) 09:53 chris to check if that works now 09:52 chris before you do, just try connecting as kohaadmin on the commandline 09:52 Fallor should I drop it first? 09:52 chris ive made a small fix to the installer in cvs to cope with htat, but for its easiest to just drop the default user 09:52 Fallor hmm, Koha database exists 09:51 chris which does have privileges 09:51 chris before it gets to the rule saying kohaadmin@% 09:51 chris its matching that 09:51 chris whats happened is that with mysql 5, there is a default user set for anything@localhost, with no privs 09:50 chris then try again 09:50 Fallor if i try to access the Koha database as kohaadmin 09:50 chris mysql> FLUSH PRIVILEGES; 09:50 chris mysql> DELETE FROM mysql.user WHERE User = ''; 09:50 chris shell> mysql -u root 09:50 Fallor ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' (using password: YES) 09:47 chris i know the fix for that 09:45 mason does that work? 09:45 mason $ mysql -ukohaadmin -pMyPassword Koha 09:44 mason hmm, so is koha creating the db ok, but not succeeding to create the 'kohaadmin' user... 09:42 Fallor and Install.pm doesn't have a line that http://lists.katipo.co.nz/pipermail/koha/2006/010477.html is talking about :( 09:37 Fallor it creates a new database fine, but doesn't let kohaadmin in 09:37 Fallor i don't understand 09:36 Fallor the same error 09:36 Fallor Problem updating database.. 09:36 Fallor Can't call method "prepare" on an undefined value at scripts/updater/updatedatabase line 1553. 09:36 Fallor 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 09:23 Fallor but i think i'll go the mysql 5 way 09:23 Fallor the ones provided by mysql :) 09:22 Fallor and it _is_ installed from rpms 09:14 Fallor it's not in centos repos 09:14 Fallor yum has no such packages 09:13 toins service mysqld start ? 09:12 toins Fallor: what's wrong ? error ? 09:11 Fallor ... and it doesn't even work ;) 09:09 Fallor toins: hmm... what difference would that make? 09:08 toins Fallor: so 'yum install MySQL-server-standard-4.1.22-0.rhel4' 09:08 Fallor well, if I can't get 4.1 working, then I'll try the other way 09:08 Fallor MySQL-shared-standard-4.1.22-0.rhel4 09:08 Fallor MySQL-server-standard-4.1.22-0.rhel4 09:07 Fallor toins: it lists the packages that I have installed, thus 09:07 chris (but if you can get mysql 4.1 going that would be easier) 09:06 chris and get the Search.pm and SearchMarc.pm files from there .. then all you need to do is edit the koha.mysql file 09:06 toins try rpm -qa | grep mysql 09:06 chris Fallor: or if you know your way around cvs .. you can checkout the rel_2_2 branch 09:05 Fallor i don't think there is a other mysql 4.1 rpm packages for centos beside the ones in mysql site 09:05 toins Fallor: i've just say if you want mysql4.1 try to get it from package instead from mysql website.... 09:04 chris the bits at the bottom 09:04 chris http://lists.katipo.co.nz/pipermail/koha/2006/010477.html 09:04 chris and 09:04 chris http://lists.katipo.co.nz/pipermail/koha/2006/010269.html 09:04 Fallor is there somekind of wikipage or something? 09:04 Fallor so to get it going with MySQL 5 what do I have to do? 09:03 Fallor toins: MySQL is from a package for rhel4, but it seemed to install without problems 09:02 chris then 2 or 3 modules 09:02 toins Fallor: you should take mysql from package 09:02 chris to get it installed 09:02 chris righto, to get it going with mysql 5 isnt actually too bad, you have to edit one file 09:02 Fallor but MySQL 4.1 refuses to start :( 09:02 mason hi toins 09:02 toins hi all 09:02 Fallor it had MySQL 5 which obviously is not a good choice, so I replaced it with MySQL 4.1 from MySQL's site 09:01 Fallor i'm trying to install koha 2.2.9 on a CentOS 5 system 09:01 mason heya chris and fallor 09:00 Fallor i have a bit of a problem here 08:59 Fallor hello chris 08:55 chris hi fallor 07:41 toins hello hdl 07:41 hdl lo toins 07:28 toins hi #koha 16:57 owen Somehow I'd never seen this before today: http://www.koha.com/