localhost, with no privs← 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 anythinglocalhost, 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
