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