← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
Time | Nick | Message |
---|---|---|
11:08 | Irma | hi all |
11:09 | Is Paul around? | |
11:10 | Just needing to check the meaning of a few French words... | |
11:11 | Is HdL perhaps able to help? | |
12:24 | kados | morning all |
12:24 | paul_: you around? | |
12:24 | paul | kados : yes |
12:24 | kados | paul: if you rebase, you'll find a script called check_sysprefs.pl |
12:25 | it was written by chris to check for missing systempreferences referenced in the code but not in the database | |
12:25 | I find several missing ones on a en MARC21 install | |
12:26 | language, SearchMyLibraryFirst,dontmerge,ManageZebra,RoutingSerials,Z3950authortemplate,BiblioAddsAuthorities | |
12:26 | I'd be curious to find out if there are ones missing from UNIMARC fr too | |
12:30 | wow, ModAuthority looks to me to be busted | |
12:31 | :-) | |
12:32 | also AddAuthority uses hard-coded tags | |
12:32 | paul | which ones ? the 152 ? |
12:33 | kados | 001, 152, 100 |
12:33 | paul | 100 if only in UNIMARC I think/hope |
12:33 | 001 and 152 are for both UNIMARC 1 MARC21 | |
12:33 | kados | doesnt' look like it |
12:33 | there's no 'if UNIMARC' for the 100 stuff | |
12:34 | note: i'm just looking at code, I haven't actually tested authorities, so maybe it's fine :-) | |
12:37 | paul: can you explain the RoutingSerials syspref? | |
12:37 | paul | nope |
12:38 | kados | hdl: ? |
12:40 | hdl | imported from kiwis code. |
12:40 | kados | ok I'll ask chris |
12:40 | hdl | It allows people to route serials or not. |
12:59 | kados | hdl: how about SearchMyLibraryFirst and 'dontmerge' ... are you familiar with those? |
12:59 | hdl | SearchMyLibraryFirst is used at OPAC |
13:00 | in order to search by default in user branch rather than all branches | |
13:00 | paul | (when a user is logged, of course) |
13:00 | kados | I see |
13:02 | and dontmerge? | |
13:02 | looks like an authorities feature | |
13:02 | something to do with updating or not updating biblios maybe? | |
13:02 | when you edit an auth? | |
13:03 | paul | yes, that should be that. hdl, yo uconfirm ? |
13:03 | hdl | If a library thinks that updating all biblios is a long process and wishes to leave that to a cron job to use merge_authotities.p |
13:03 | ### they should have a system preference "dontmerge=1" otherwise by default biblios will be updated | |
13:03 | ### the $merge flag is now depreceated and will be removed at code cleaning | |
13:04 | in AuthoritiesMarc.pm | |
13:04 | kados | so is it deprecated or not? :-) |
13:10 | hdl: ? | |
13:10 | ahh, ok | |
13:10 | hdl: while you're looking, I noticed that ModAuthorities has some hard-coded values | |
13:11 | 001, 100, 152 | |
13:11 | why aren't we just using the framework for those? | |
13:11 | hdl | 001 : authid |
13:11 | 152 : authtypecode. | |
13:12 | Because authid and authtypecode is not selectable in framework. | |
13:12 | 100 stands for UNIMARC leader. | |
13:12 | There seems to be a problem with him. | |
13:12 | (it) | |
13:13 | kados | *nod* |
13:13 | thx | |
13:13 | paul: can you confirm that z3950authortemplate is fully deprecated? I see it in a code comment but nowhere else | |
13:13 | (in addbiblio | |
13:14 | paul | z3950authortemplate ??? /me don't know what it is |
13:14 | hdl | Should be deprecated. |
13:14 | Was introduced in 2.2.9 | |
13:14 | kados | ok |
13:14 | there is one last one: BiblioAddsAuthorities | |
13:14 | paul | ah, this one is VERY interesting ! |
13:15 | if you activate it, it will automatically add authorities if needed (= it doesn't exist) | |
13:15 | kados | how does it know if one exists? |
13:15 | paul | to see if it already exists, it search on authid vs $3 (unimarc specific) |
13:15 | or authority main entry excatly the same | |
13:16 | kados | k |
13:16 | paul | if : poulain, paul, 1968-09-01 will fit my authority entry, but not poulain, paul, 1964-01-03 or poulain, Jean paul, 1968-01-09 |
13:17 | hdl : do you think this feature is production ready ? | |
13:17 | hdl | No. |
13:18 | require testing | |
13:18 | kados | I think it's a good start, but I know US libraries will want a lot more functionality, and they will want to be able to run reports on what these 'fake' authorities are, and overlay they later |
13:18 | overlay them later | |
13:18 | paul | users always want more ;-) |
13:18 | kados | hehe |
13:18 | I'll add it to the sysprefs | |
13:19 | SearchMyLibraryFirst is in Catalogue, but it's an OPAC feature, right? | |
13:20 | or does it work for both staff and OPAC? | |
13:21 | paul | right, should be on OPAC iirc |
13:30 | kados | morning joe |
13:31 | atz | greets |
14:27 | fbcit | g'morning all |
14:28 | kados: auth_tag_structure.authtypecode is char(10) while auth_types.authtypecode is varchar(10)... I assume they should be the same type? | |
14:29 | kados | yes, all char should be varchar now |
14:30 | as of 5.0, in mysql, there's not much reason to use char anymore | |
14:30 | used to be it was faster | |
14:30 | and varchar was smaller | |
14:30 | but now varchar is just as fast | |
14:30 | and smaller | |
14:30 | so char is kinda pointless I guess | |
14:30 | paul_ | (except for very small chars, as varchar has 3 digits to store size. So a 1 or 2 digit char is smaller than varchar !) |
14:31 | kados | paul_++ |
14:31 | paul_ | (3 or 2 to store, not sure so remember well) |
14:31 | but with a 1TB hard disk, who care ;-) | |
14:31 | kados | hehe |
14:31 | fbcit | The different types will cause slow indexing in pg... |
14:32 | auth_tag_structure looks like the only table with char's. I'm switching them to varchar in the pg structure. | |
14:32 | kados: I'll get this to you in a bit. Trying to polish it.... | |
14:33 | kados | I see some char(10) in other places too |
14:33 | aqbookfund | |
14:33 | aqbudget | |
14:34 | wow, quite a few | |
14:35 | huh, and somehow we've got quoted integers again :/ | |
14:35 | atz | booo |
14:36 | paul_ | faar |
14:38 | owen | Hi everyone |
14:39 | gmcharlt | hello |
14:39 | owen | kados, are you on the road today? |
14:50 | kados | owen: yea, I'm leaving at about 3pm to go to MD |
14:56 | owen | I noticed something strange about the upgrade process I went through this last time. When I went to log in, it wouldn't accept my password and I didn't understand why. Only after I logged /out/ would it let me log in with the same credentials I'd just been trying |
14:56 | kados | yea, that is something I noticed a while back as well |
14:57 | so maybe it needs to kill the cookie if your user/password fail | |
14:57 | although ... that might not work if you simply don't have permission to view a page | |
14:57 | in that case you would be annoyed logging back in | |
14:57 | owen | Strange, it's the first time it has happened to me. Very counterintuitive. |
15:02 | fbcit | kados:kohastructure_pg.sql has been submitted |
15:02 | kados:Note: It will probably not run without modes to the installer scripts. | |
15:04 | kados | w00t |
15:04 | fbcit++ | |
15:07 | fbcit: I've also send through a patch for quoted integers and the s/char/varchar/ | |
15:08 | owen: I'll bring it up to chris this afternoon | |
15:08 | owen: I think it's worth doing a bug report on, but unfortunately we've probably got bigger fish to fry atm | |
15:09 | who knows, maybe it's an easy fix, but my eyes get all wonky every time I look at Auth.pm :-) | |
15:12 | fbcit | kados: (got distracted...)I'll work on those as soon as I get a copy up and running over mysql.... |
15:14 | kados:FWIW: kohastructure_pg.sql is subject to change as I get working on the installer scripts.... | |
15:24 | kados | *nod* once it enters Git you'll be able to track those changes |
15:25 | well, we'll be able to ... I assume it's already entered your local git repo or you wouldn't have been able to send a patch :-) | |
15:25 | fbcit: what I'd be extremely interested in, is patches that make Koha multi-db compliant out of the box | |
15:26 | fbcit | kados: I plan on attempting that approach. |
15:26 | kados | I think the web installer is a micro-cosm of the whole codebase |
15:26 | so if we can get the conventions for how to do that defined in there, that'll be a huge step forward to portability | |
15:27 | fbcit | sql statements will need to adhere as much as possible to the general standard... |
15:27 | this might somewhat limit capitalizing on the strengths of certain dbms over others. | |
15:28 | kados | *nod* |
15:28 | fbcit | there a balance there somewhere. |
15:29 | kados | yea, I can imagine in some cases it'd be useful to use dbms-specific stuff, but maybe test for the db in use and default to sql-92 or something |
15:30 | someone recently suggested we could have Koha ship by default running sqllite | |
15:30 | so you woudln't even need a database :-) | |
15:30 | maybe we need a system preference for the DBMS | |
15:31 | fbcit | with the zebra option, do certain tables move to zebra? |
15:32 | kados | no, but I think there is one unused table |
15:32 | owen | atz++ for his great Koha list responses |
15:32 | kados | but it's safe to leave it in there |
15:33 | yea, nice one atz | |
15:33 | atz | thx |
15:34 | kados | fbcit: getting your zebra setup is probably not worth the effort at the moment, I've been working with slef (the command-line installer guy) to get the installer to do all the heavy lifting there |
15:34 | fbcit: so I'd start with nozebra if you just want a working system | |
15:34 | atz | i was thinking, is there a DBI module for Informix (which is what Unicorn uses anyway) |
15:34 | ? | |
15:35 | kados | looks like our one supports informiz |
15:35 | informix even | |
15:35 | DBD::Informix | |
15:35 | http://search.cpan.org/ohnl/DB[…]05.02/Informix.pm | |
15:36 | atz | cool. if that works it might be possible to import Unicorn files directly without dumping data |
15:36 | kados | hehe, that'd rock |
15:37 | atz | D'oh, your link gives me a CPAN error |
15:37 | kados | http://search.cpan.org/ohnl/DB[…]05.02/Informix.pm works for me :/ |
15:37 | sounds like your local cpan mirror might be down | |
15:37 | or it's your DNS again :-) | |
15:38 | atz | this time I get a CPAN-served error page |
15:39 | here's the newer one, apparently: | |
15:39 | http://search.cpan.org/~johnl/[…].0914/Informix.pm | |
15:41 | (very new... last month) | |
17:25 | owen | Should I post bugs related to date formatting, or is the whole date situation too much in flux? |
17:30 | kados | owen: I'd definitely post them |
17:30 | owen: are you seeing lots of minor issues, or one in particular? | |
17:31 | owen | Just some places where dates aren't displaying in the right format |
17:31 | Like news items on the home page | |
17:32 | kados | ahh, on my install they are showing in metric I guess |
17:32 | 22/10/2007 | |
17:32 | that's metric, right? | |
17:33 | looks like the GetNewsToDisplay is the prob | |
17:33 | yep, that's the prob | |
17:33 | hardcoded date format: | |
17:33 | SELECT *,DATE_FORMAT(timestamp, '%d/%m/%Y') AS newdate | |
17:35 | owen | The other place I noticed was on koha-news.pl, where the creation date is formatted correctly and the expiration date isn't |
17:35 | ...when you're viewing existing news | |
17:37 | kados | atz: an unintended function of the DHTMLCalendar function/method is the capability to send that to mysql as the requested date format |
17:39 | w00t, that's all fixed | |
17:41 | ok, checking why expiration date isn't working properly | |
17:49 | atz | yeah, i wasn't sure about the SQL format strings |
17:50 | they appear to be POSIXy, which is what DHTMLCalendar is anyway | |
17:51 | certain comparison approaches are destroyed by loosening the format | |
17:51 | kados | owen: ok, fixed all those bugs, submitting patches now |
17:51 | atz | for example, you could compare the first 4 digits in US format and get logical results (MM/DD) |
17:52 | but once the format is loosened to allow metric, you get confusion (DD/MM) | |
17:52 | kados | yea |
17:53 | I think for comparison we use a known format | |
17:53 | atz | this is god's punishment for cheesy sort routines |
17:53 | kados | iso seems to mke the most sense |
17:53 | hehe | |
17:53 | owen: any other places dates aren't showing up? | |
17:53 | showing up right I mean | |
17:53 | owen | That's the only place I've noticed at the moment |
17:54 | kados | I notice that they don't actually expire though |
17:54 | ie, I've got one set to expire the first of the month and it still show sup | |
17:54 | I wonder if that's because I'm superadmin or what | |
17:54 | owen | It's working properly fo rme |
17:55 | kados | ahh, right from the main page it does |
17:55 | of course :-) | |
17:55 | owen | I'm adding some styles to the koha-news page to distinguish current from expired items |
17:55 | kados | cool |
17:56 | yea, already it looks much much better | |
17:56 | owen++ | |
18:15 | fbcit | kados: trying to follow the debian install (http://www.kohadocs.org/Instal[…]ebian_sarge.html) |
18:16 | kados: does the latest Debian netinst do the 2.4 kernel by default? | |
18:16 | kados | ahh, that's super old |
18:17 | there aren't any docs for 3.0 installation just yet | |
18:17 | but in your git repo there is a README | |
18:17 | you'll want to just follow that | |
18:17 | fbcit | so just take whatever kernel the latest debian gives me? |
18:17 | kados | yea, kernel isn't a prob anymore, we don't use Event |
18:18 | so you want Debian Etch (4.0) | |
18:18 | running MySQL 5.x and Apache 2 | |
18:18 | fbcit | will dual 1.1G P3 w/1GB ram be fine? |
18:18 | kados | that's the best environment for 3.0, the one most of us are testing on |
18:18 | oh, yea, plenty | |
18:18 | our testing environments are running on VPSes | |
18:18 | fbcit | I do want to be on the same page... |
18:18 | kados | with like 128MB of ram |
18:19 | fbcit | ouch. |
18:22 | kados | we should include a shell script that has the configuration keywords in it |
18:22 | so you can just edit it and run it and then install | |
18:23 | fbcit: you happy with that README.txt? | |
18:23 | :-) | |
18:26 | fbcit | one sec |
18:27 | a script for db creation might be nice... | |
18:27 | I read this the other day. | |
18:27 | I need to get Debian installed first. | |
18:39 | kados: is the "minimal base system" sufficient to start with? | |
18:40 | kados | fbcit: yup |
18:42 | fbcit | kados:"Standard System" under 'Software selection'? or nothing? |
18:43 | kados | hmmm, I'm not familiar with that option |
01:25 | carrots | hello |
01:26 | anyone tried installing koha on CentOS and using XAMPP as its LAMP server???? | |
01:26 | kados | carrots: I know someone installed on centos, not sure about xampp |
01:27 | shouldn't matter though, it's just a apache distro, right? | |
01:27 | carrots | yup |
01:27 | but i am having problems on the mysql side | |
01:27 | kados | is this for a testing system? |
01:27 | carrots | the DBD::mysql perl module wont install |
01:27 | kados | or you planning to roll it out in production asap? |
01:28 | carrots | its a testing system |
01:28 | kados | cool, then I'd recommend giving 3.0 a shot |
01:28 | carrots | if we get to install the koha right we might use this in our library |
01:28 | kados | you can give us feedback on the fancy new installer :-) |
01:28 | carrots: have you used git before? | |
01:29 | carrots: http://wiki.koha.org/doku.php?[…]lopment:git_usage | |
01:29 | carrots | nope |
01:29 | kados | carrots: you can have a look there, soon as you clone the repo, you can have a look at the README.txt file for install directions |
01:29 | carrots | will check thanks |
01:29 | what does git do??? | |
01:29 | kados | git is a version control system |
01:30 | the wiki page should explain it's purpose | |
01:30 | carrots | okey thanks |
01:30 | kados | it basically lets everyone in the community share their changes with each other |
01:30 | carrots | ohhh okey =) |
01:31 | thanks kudos! | |
01:31 | kados | no worries |
01:31 | let us know how it goes | |
01:32 | carrots | yup yup |
01:33 | ohh ohh i hope the person who installed koha on CentOS can do a docu and upload at wiki... i am really having a hard time on this matter | |
01:33 | =\ | |
01:34 | kados | it sounds like you're having trouble installing depencies of Koha, not koha itself |
01:34 | personally, I find debian to be the easiest | |
01:34 | carrots | yep your right... the dependencies..... |
01:36 | i tried using debian etch | |
01:36 | kados | yea, that's the way to go IMO |
01:36 | carrots | but i had a hard time since i'm more of a red hat |
01:36 | kados | 3.0 will run beautifully on that |
01:37 | you a command-line guy or GUI? | |
01:37 | carrots | some command line are different from debian |
01:38 | kados | mostly just the package manager |
01:38 | carrots | more on GUI |
01:38 | kados | I like apt much better, it does more than yum |
01:39 | carrots | but etch has GUI but you have to use teh console to login as root and make changes..... |
01:40 | *the | |
01:40 | kados | servers I mean |
01:40 | I just install the minimal debian system and work from the command line from there | |
01:46 | hehe | |
01:46 | how so ? | |
01:47 | fbcit-1 | it kept wanting to look at the netinst cd rather than the repos.... |
01:47 | kados | ahh, that's an easy fix |
01:47 | edit /etc/apt/source.list | |
01:48 | add: | |
01:48 | deb http://linux.csua.berkeley.edu/debian/ stable main | |
01:48 | deb-src http://linux.csua.berkeley.edu/debian/ stable main | |
01:48 | and comment out the lines for the netinst | |
01:48 | then do: | |
01:48 | apt-get update | |
01:48 | and you should be good to go | |
01:48 | while you're in there, I'd also put in the index data sources, you'll need those for yaz and zebra | |
01:49 | fbcit-1 | ok. I edited one of the files in /etc/apt, but it must have been the wrong one. |
01:49 | kados | deb http://ftp.indexdata.dk/debian etch main |
01:49 | deb-src http://ftp.indexdata.dk/debian etch main | |
01:49 | huh, you want to edit /etc/apt/sources.list | |
01:50 | fbcit-1 | right... |
01:50 | I'll be back on the box tomorrow after 11am ... right after Greek :) | |
01:50 | kados | hehe |
01:56 | fbcit-1 | kados: add both sets: 'stable main' and 'etch main'? |
01:57 | nevermind.... go it... | |
01:57 | kados | just etch |
01:57 | sarge is the prevous version | |
01:58 | unless you're running sarge | |
01:58 | then you want sarge and not etch | |
01:58 | fbcit-1 | no, etch |
01:58 | kados | but never both |
02:07 | fbcit-1 | tnx. g'night. |
06:18 | yesan | I have a problem with Bluehost.com that neither they allow their customers to have root access to their servers nor provide dedicated ports. As it is required for librarian interface and webopac. |
06:19 | Can anybody suggest better way to get koha installed on any of the webhosting services provider's servers? We are desperately need of constructive suggestions, this will decide our future course of action on installing/using koha for our union catalogue. There are 25 theological and religious libraries in Bangalore would be joining to provide their catalogues for union catalogue project. | |
06:19 | masonj are u there | |
06:22 | it looks no one there | |
08:00 | Brooke | howdy |
09:49 | yesan | while installing koha on Bluehost.com, i encountered following error message - [jlcopacobox341 koha-2.2.9]$ ./installer.pl Cannot write to /etc! Please set the etcdir environment variable to a writeable directory. |
10:12 | masonj, do you hear me, | |
10:12 | glad to see you are back, masonj | |
10:13 | masonj | hi yesan |
10:14 | yesan | hi, masonj i was looking for you |
10:14 | masonj | ah, cool, so how are you getting on? |
10:15 | you are having some problems with access at bluehost.com ? | |
10:15 | yesan | i had a problem while installing koha on blue host.com and gave following error msg = ./installer.pl Cannot write to /etc! Please set the etcdir environment variable to a writeable directory. |
10:16 | how do i over come this problem | |
10:16 | masonj | hmm, short answer is you need to be root to write to /etc |
10:17 | but ... you can modify the install scripts to write the /etc/koha.conf file somewhere else | |
10:18 | yesan | the directory which i can create in my domain? |
10:19 | masonj | hmm, domain? |
10:19 | yesan | somewhere else means - on my domain directories - jlcopac.org |
10:20 | masonj | perhaps a directory under your home directory on the box you are installing to |
10:20 | /home/yesan/koha/etc/koha.conf | |
10:20 | like that perhaps... | |
10:23 | its possible to install koha on a bluehost type system, yesan | |
10:23 | yesan | masonj, should edit this in the perl script |
10:23 | masonj | but you are making things so much harder for yourself |
10:24 | yesan | very encouraging to note that I could do that using Bluehost |
10:24 | what do you mean by harder for myself? | |
10:25 | masonj | harder = much more difficult |
10:25 | yesan | is it required to have dedicted ports for librarian interface and webopac |
10:25 | how do i assign the ports | |
10:25 | masonj | find a old linux box, and get koha successfully installed on it first |
10:26 | then you can compare all the broken things that dont work on your bluehost koha, and then try to work out how to fix them | |
10:27 | thats how you will succeed with your bluehost install | |
10:28 | yesan | How do I assign dedicated ports |
10:28 | masonj | if you have some good experience with linux, apache mysql and perl then your bluehost install will be not so hard |
10:29 | yesan | i have a colleague, he is to some extent good in these |
10:31 | masonj, what do you do back nz | |
10:32 | masonj | 1 tic yesan... |
10:33 | yesan | i am presently serving in South Asia Institute of Advanced Christian Studies, Bangalore |
10:34 | i got to go for a short break, I shall meet you. if you are still around. bye for now | |
10:34 | masonj | cool , my freinds have been to bangalore and love it |
10:34 | yesan | is it |
10:34 | masonj | i work for liblime as a programmer |
10:35 | yesan | it is good to know that you are with liblime. i enjoyed using liblime webpage |
10:35 | masonj | and was working for katipo.co.nz before |
10:35 | yesan | my brother-in-law is coming to NZ next month |
10:36 | send me your email id? Myemail id is :yesansgmail.com | |
10:36 | masonj | nice, we are in wellington, (capital) |
10:36 | yesan | Do you there is a bible college in Wellington. |
10:37 | masonj | hmmm, im sure there are many |
10:37 | yesan | Our founder Dr. Houghton is from NZ |
10:37 | masonj | wellington is very biblical |
10:37 | yesan | Do you have some contacts with Seminary libraries |
10:38 | I know there is one NZ Bible College | |
10:38 | sorry it is Bible College of NZ | |
10:38 | masonj | yesan: setting up koha's dedicated ports is in koha's apache config file |
10:39 | usually in /etc/koha-httpd.conf | |
10:39 | yesan | sorry for taking your valuable time in takling something else than koha |
10:39 | masonj | awww, thats ok yesan :) |
10:40 | yesan | thank you for understanding |
10:40 | masonj | find yourself an old pc, install debian on it, and get a koha running on there first |
10:41 | once you can see it running, you can then work out what you need to do manually install it , without root access on bluehost | |
10:43 | ah, and send some emails to the koha mailing-lists too, other koha users that have done it might be able to help you | |
10:52 | yesan | thats fine. i shall do that as well |
10:53 | masonj | cool, nice talking to you again yesan |
10:53 | yesan | bye for you |
← Previous day | Today | Next day → | Search | Index