IRC log for #koha, 2007-10-24

← 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,Routing​Serials,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 - [jlcopaco@box341 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 :yesans@gmail.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

koha1