IRC log for #koha, 2007-06-29

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

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

← Previous day | Today | Next day → | Search | Index

koha1