IRC log for #koha, 2012-08-09

All times shown according to UTC.

Time S Nick Message
00:02 mtj yep :)
00:03 Judit joined #koha
00:03 Judit morning
00:03 mtj virtual one is already installed, already configured
00:04 mtj hi Judit  :)
00:05 melia left #koha
00:45 edveal left #koha
01:36 libsysguy joined #koha
02:05 jcamins_away joined #koha
03:15 Judit joined #koha
03:21 bag mtj?
03:21 wahanui DeM KraZy NutZ!!
03:21 bag love it!
03:25 mtj bag , ive just 'discovered' portlandia ->
03:25 bag yeah that's a funny show :)
03:26 mtj i'm kinda thinking about growing a sweet goatee, and getting some big holes in my earlobes...
03:27 mtj i mean *really* big holes
03:27 bag ha
03:28 bag do the goatee first then you can match the holes to that :)
03:28 rangi heh
03:28 mtj pop a kinder-surprise thingy in them, use them for additional storage
03:29 mtj rangi be noes where i be cumin' from
03:29 rangi <-- got the mobile theme running
03:29 rangi peep that on your phone
03:30 rangi (or just resize your browser to small)
03:30 Judit joined #koha
03:31 mtj handles a resize, real nice
03:35 mtj damn, i really that new opac look
03:35 mtj -> love
03:36 rangi yeah needs a few follow ups fixing translation issues but is pretty sweet
03:37 mtj and... its quite similar-ish  to my opac theming attempts, too
03:38 mtj cart and lists moved up tha' top, etc...
03:40 rangi yep, they work better up there i reckon
03:41 mtj i reckon too :)
03:52 bartsimpson joined #koha
03:58 mtj heya bart
04:01 bartsimpson hi :)
04:02 libsysguy joined #koha
04:07 bartsimpson rangi: is "text" the same as "varchar" when making mock data?
04:09 rangi yup, you can treat them the same
04:13 rangi mtj:
04:15 mtj rangi,  nice :) can we ring it so i get points for qa-ing stuff?
04:16 mtj s/ring/rig/
04:16 rangi heh, it only works on patches that improve the build (or don't break it)
04:16 rangi easiest way to get points, fix a failing test, or create new tests
04:17 rangi so bartsimpson is gonna get some points when his patches are pushed :)
04:17 cait joined #koha
04:21 mtj ah yep - i actually knew that (but then forgot it too)
04:22 cait good morning #koha
04:23 cait hi mtj :)
04:23 rangi mtj: i started adding descriptions, ill keep doing that :)
04:24 mtj hey cait
04:24 rangi
04:27 cait mtj: I love your logo :)
04:30 mtj thanx, its a 'work in progress'
04:30 mtj (as my inkscape skills get better)
04:31 cait :)
04:45 libsysguy joined #koha
04:50 mtj rangi++
04:52 mveron joined #koha
05:13 mbalmer joined #koha
05:31 mtompset joined #koha
05:32 mtompset Greetings, #koha.
06:31 julian_m joined #koha
06:40 mtompset Greetings, julian_m
06:40 mtompset I haven't had a chance to look at your feedback on the bug report yet.
06:40 julian_m hello mtompset
06:41 mtompset bug 8350
06:41 huginn Bug[…]w_bug.cgi?id=8350 normal, P5 - low, ---, gmcharlt, Needs Signoff , $search = '0' or 0 will fail to affect SQL statement correctly in C4::Breeding
06:41 mtompset I vaguely remember in some search looking for space.
06:41 mtompset ' '
06:43 hdl joined #koha
06:45 julian_m joined #koha
06:47 * magnuse waves
06:47 julian_m mtompset, network issues... what do you want to ask me?
06:48 mtompset Sorry to hear that. -- I vaguely recall locking for just a ' ' in some search related issue I encountered.
06:48 mtompset Perhaps the title is wrong, and it is a space?
06:48 mtompset I haven't had time to go look back at bug 8350.
06:48 huginn Bug[…]w_bug.cgi?id=8350 normal, P5 - low, ---, gmcharlt, Needs Signoff , $search = '0' or 0 will fail to affect SQL statement correctly in C4::Breeding
06:53 cait left #koha
06:55 Judit i sthere a maximum number of branches koha can handle
06:56 magnuse not that i have heard of
06:57 Judit what is the max at the moment out there
06:57 magnuse good question :-)
06:58 Judit 100?1000?
06:59 magnuse this is the biggest one i can think of off the top of my head:
07:00 magnuse looks like 45 branches
07:00 Judit oh
07:00 Judit hm
07:01 Judit the biggest db?
07:02 hdl joined #koha
07:02 magnuse maybe National Library of Venezuela: http://www.librarytechnology.o[…]
07:02 magnuse marshall breeding says they have 7131660 volumes, but they night not all be in koha
07:03 magnuse Near East University Library has the number 1.500.000, but not sure that's records or items
07:03 magnuse i started a list here:
07:04 Judit thanks
07:06 gaetan_B joined #koha
07:07 gaetan_B hello
07:08 magnuse bonjour gaetan_B
07:12 mveron good morning everybody
07:12 mveron :-)
07:18 kohakhan joined #koha
07:19 kf joined #koha
07:29 kf hi again #koha
07:29 magnuse guten morgen mveron and kf and kohakhan
07:30 kf morning magnuse :)
07:30 kf hey, have you heard? tomorrow is GBSD!
07:34 magnuse woohoo!
07:34 magnuse next gbsd is[…]bug_squashing_day
07:34 magnuse next gbsd?
07:34 wahanui next gbsd is probably[…]bug_squashing_day
07:34 magnuse wahanui: forget next gbsd
07:34 wahanui magnuse: I forgot next gbsd
07:34 magnuse next gbsd is[…]bug_squashing_day
07:34 magnuse next gbsd?
07:34 wahanui well, next gbsd is[…]bug_squashing_day
07:35 magnuse w00t!
07:35 rangi evening
07:35 magnuse morning
07:36 magnuse in fact, for rangi gbsd is only 4.5 hours away!
07:37 kf oh wow
07:37 kf and he is already leading the dashboard :)
07:39 WaqarAzeem joined #koha
07:42 magnuse dashboard?
07:42 wahanui dashboard is at
07:42 magnuse yay!
07:43 * magnuse hopes someone will take pity on the SIP patches that have been waiting a looong time...
07:43 kf yeah :(
07:43 kf still have not ifgured out how to test those
07:43 hdl magnuse:
07:43 kf there is also one for ldap
07:45 magnuse hdl: speaking of lots of branches?
07:45 hdl magnuse: in order to cope wih SIP, you need the machine.
07:45 hdl lots of items
07:45 magnuse ah, ok
07:45 kf there are programs to test SIP
07:45 hdl It is the biggest one I know of
07:45 kf if you don't have the machine :)
07:46 kf simulators
07:46 magnuse hdl: do you know the number?
07:46 wahanui somebody said the number was right
07:46 rangi plano is big
07:46 magnuse wahanui: that sounds promising
07:46 wahanui magnuse: sorry...
07:47 rangi 67 schools
07:48 rangi
07:48 hdl magnuse: nevermind: seems broken
07:48 magnuse would a page of "large koha installations" on the wiki be a good idea?
07:49 kf rangi: didn't you do a blog post about big libraries? :)
07:49 rangi yep
07:49 rangi[…]r-than-you-think/
07:50 rangi kf: you can actually test sip with telnet
07:50 rangi telnet and cut and paste :)
07:51 magnuse ah, cool blog post!
07:52 kf rangi: yeah, only never have used telnet so far :) and not sure where to cut and paste from - but I knwo it can be done. only not figured out the specifics yet :)
07:59 rangi actualy bug 7560 seems to work fine
07:59 huginn Bug[…]w_bug.cgi?id=7560 minor, P5 - low, ---, colin.campbell, Needs Signoff , SIP Self Checkout Ignoring Fines Thresholds for Not Being able to Check Out Books
08:16 magnuse woohoo!
08:22 kf woohoo :) rangi++
08:26 koyauni joined #koha
08:26 eythian joined #koha
08:30 eythian huginn: you have news for me?
08:30 huginn eythian: I'll give you the answer just as soon as RDA is ready
08:55 mtompset RDA?
08:55 wahanui RDA is probably a room in a twisty maze of standards
08:55 mtompset standards?
08:56 mtompset Well, that was a nice dead-end. :(
08:56 eythian wahanui: a standard is what you use to hold up a fence.
08:56 wahanui i haven't a clue, eythian
08:56 eythian wahanui: standard is what you use to hold up a fence.
08:56 wahanui eythian: bugger all, i dunno
08:56 eythian wahanui: standard is what \you use to hold up a fence.
08:56 wahanui i don't know, eythian
08:56 eythian ?!
08:56 eythian wahanui: standard is \what \you use to hold up a fence.
08:56 wahanui ...but standard is not so practical for that...
08:57 eythian wahanui: standards are \what \you use to hold up a fence.
08:57 wahanui OK, eythian.
08:57 eythian there we go
08:57 eythian finally
08:58 kf lol
08:59 kf I noticed he has some problemswith learning new facts lately
08:59 kf weather in germany is nice today
08:59 kf weather in Germany?
08:59 mtompset standards?
08:59 wahanui standards are what you use to hold up a fence.
08:59 eythian oh, no. It's just his grammar is a bit ... odd.
08:59 mtompset RDA?
08:59 wahanui RDA is, like, a room in a twisty maze of standards
08:59 mtompset standards?
08:59 wahanui standards are what you use to hold up a fence.
08:59 eythian wahanui: what is the saddest thing?
08:59 wahanui ⛄ U+26C4 SNOWMAN WITHOUT SNOW
08:59 kf eythian: yeah, but is/are used to work?
08:59 mtompset Nice.
08:59 eythian kf: they still do work. It was "what" that was causing the issue
09:00 eythian kf: they still do work. It was "what" that was causing the issue
09:00 eythian oops
09:00 eythian wahanui: what is the saddest thing?
09:00 wahanui ⛄ U+26C4 SNOWMAN WITHOUT SNOW
09:00 mtompset What is U+26C4?
09:00 kf something?
09:00 kf something is something
09:00 kf something?
09:00 kf not learning!
09:00 kf ok.. wouldn't be very useful :)
09:01 eythian mtompset: U+26C4 is the unicode for SNOWMAN WITHOUT SNOW
09:01 mtompset Yes, that is not useful.
09:01 eythian kf: I don't think he learns everything
09:01 eythian I'm not sure the criteria
09:02 eythian maybe length of the right-hand side (just a guess)
09:02 mtompset U+26C4
09:02 mtompset U+26C4?
09:02 wahanui U+26C4 is, like, the unicode for SNOWMAN WITHOUT SNOW
09:02 eythian heh
09:02 eythian wahanui: literal the saddest thing
09:02 wahanui eythian: the saddest thing =is= <reply>⛄ U+26C4 SNOWMAN WITHOUT SNOW
09:03 eythian wahanui: the saddest thing is <reply>⛄ U+26C4 SNOWMAN WITHOUT SNOW|
09:03 wahanui ...but saddest thing is <reply>⛄ U+26C4 SNOWMAN WITHOUT SNOW...
09:03 eythian no wahanui, the saddest thing is <reply>⛄ U+26C4 SNOWMAN WITHOUT SNOW|
09:03 wahanui okay, eythian.
09:03 eythian wahanui: what is the saddest thing?
09:03 wahanui ⛄ U+26C4 SNOWMAN WITHOUT SNOW
09:03 eythian wahanui: what is the saddest thing?
09:03 wahanui ⛄ U+26C4 SNOWMAN WITHOUT SNOW
09:03 eythian wahanui: what is the saddest thing?
09:03 wahanui ⛄ U+26C4 SNOWMAN WITHOUT SNOW
09:03 eythian wahanui: what is the saddest thing?
09:03 wahanui ⛄ U+26C4 SNOWMAN WITHOUT SNOW
09:03 eythian ?!
09:03 eythian wahanui: what is the saddest thing?
09:03 wahanui the saddest thing is, like,
09:05 drojf joined #koha
09:05 drojf hi #koha
09:06 eythian (that last one really is the saddest thing, too)
09:06 kf morning drojf
09:06 eythian hi drojf
09:06 drojf hey kf and eythian
09:07 mtompset Perhaps it resonates at 52Hz... that's touching.
09:16 chris_n` joined #koha
09:17 davidnind joined #koha
09:20 mtompset Greetings, drojf
09:21 koyauni joined #koha
09:22 drojf1 joined #koha
09:23 drojf hey mtompset
09:23 wahanui hmmm... mtompset is currently in the Philippines and is coding up a bash script storm in the midst of seasonal typhoons.
09:23 mtompset Yes, that's about right. :)
09:24 mtompset Lost internet connectivity for a while due to flooding in the local vicinity.
09:25 drojf @wunder berlin, germany
09:25 huginn drojf: The current temperature in Prenzlauer Berg, Berlin, Germany is 19.4°C (11:12 AM CEST on August 09, 2012). Conditions: Mostly Cloudy. Humidity: 51%. Dew Point: 9.0°C. Pressure: 30.24 in 1024 hPa (Rising).
09:25 mtompset @wunder MNL
09:25 huginn mtompset: The current temperature in Manila, Philippines is 28.0°C (5:00 PM PHT on August 09, 2012). Conditions: Mostly Cloudy. Humidity: 84%. Dew Point: 25.0°C. Pressure: 29.71 in 1006 hPa (Steady).
09:26 mtompset YAY! a 16% point drop. Hopefully my colleagues won't be flooded out of the office much longer.
09:29 itachi joined #koha
09:33 koyauni hi guys, I am new to Koha and I have used this to install it on my Debian dedicated server
09:33 koyauni[…]on_Debian_Squeeze
09:33 koyauni I am stock in the middle is there anyone who can guid me please
09:37 eythian Where is "the middle"?
09:39 jenkins_koha Starting build #128 for job Koha_3.8.x (previous build: SUCCESS)
09:42 drojf wow, external harddisks are still ridiculously expensive. when was that flood when prices went up? a year ago? yeah for collusive pricing
09:44 koyauni yes .config file
09:45 eythian There is no .config'll have to give more information.
09:45 drojf koyauni: it would help if you could ask a concrete question
09:47 koyauni there is in here[…]on_Debian_Squeeze
09:47 koyauni in this file /etc/koha/koha-sites.conf
09:47 eythian that's .conf, there's a difference :)
09:47 eythian (mostly in that if you mix them up, stuff won't work)
09:48 koyauni that is why I am stock :(
09:49 eythian you'll have to ask a question though, or we can't really help you.
09:49 itachi hey follow this to install koha on debian[…]LL.debian;hb=HEAD
09:51 eythian no, don't
09:51 eythian (unless you specifically want a git install)
09:52 drojf and spend a lot more time on your installation than necessary
09:55 itachi well can you please give me a link for a guide on how to install koha on debian
09:56 eythian[…]on_Debian_Squeeze <-- right there
09:57 mtompset There are three ways to install Koha.
09:57 koyauni I would rather follow the one on wiki as I have done most of it,
09:57 mtompset packages?
09:57 wahanui i think packages is at
09:57 mtompset git?
09:57 wahanui i think git is[…]Control_Using_Git
09:57 koyauni I do not want to get lost between different installation
09:57 mtompset tarball?
09:57 wahanui The tarballs are available at though if you are on a debian-based OS, try the packages.
09:57 mtompset which install to use?
09:57 wahanui If you're developing, you should use git. If you're not developing on a deb-based system, you should use packages. If you're not developing on a different flavour of Linux, you should use the tarball.
09:57 mtompset koyauni is doing a packages install, which is correct.
09:57 drojf koyauni: yes, continue with that, it is what you want
09:57 itachi thank you.....what is the difference between those two kind of installation
09:58 koyauni I am basic user in Linus and new to Koha
09:58 mtompset packages is pre-built for the user.
09:58 mtompset everything is assembled, and it comes with handy-dandy scripts to boot.
09:59 koyauni just need help with that ,conf file what I actually need to write
09:59 koyauni I wish one day Koha become as easy as installing Drupal
09:59 eythian what you write depends on your setup. It has explanations for each of the options.
10:00 mtompset koha is way easier than drupal... well, I did do drupal on an RPM-based OS.
10:00 eythian if you're stuck on one of them, you should ask about it.
10:00 koyauni I mean put the pack in on folder and do web based config that it with Drupal,
10:01 koyauni first line I did
10:01 koyauni DOMAIN=""  # Any library instance will be a subdomain of this string.
10:01 eythian seems fine
10:01 * mtompset nods.
10:01 koyauni 2nd one I left it as it is
10:01 koyauni INTRAPORT="80"  # TCP listening port for the administration interface
10:01 eythian sure
10:01 koyauni 3rd , INTRAPREFIX="admin"  # For administration interface URL: Prefix to be added to the instance name.
10:02 koyauni I have one user URL as
10:02 koyauni and admin as
10:02 eythian yep
10:02 eythian then that's what you want
10:03 mtompset wait, wouldn't that be SUFFIX not PREFIX?
10:03 eythian oh
10:03 eythian good point
10:03 eythian yes
10:03 mtompset leave INTRANETPREFIX=""
10:04 mtompset and put INTRANETSUFFIX="admin"
10:04 mtompset that will map like you have said.
10:04 eythian INTRAPREFIX
10:04 eythian and INTRASUFFIX
10:04 wahanui i heard INTRASUFFIX was so you can put -admin or something as the suffix on the name of the staff client
10:04 koyauni thats where I stock
10:04 mtompset Oops... I made a typo.
10:04 mtompset leave INTRAPREFIX=""
10:04 mtompset and put INTRASUFFIX="admin"
10:05 eythian koyauni: right, you just do what makes sense there, which is the way mtompset is explaining it.
10:05 koyauni yes,
10:05 mtompset that will give the staff client
10:05 mtompset and for OPAC.
10:05 koyauni oh I left the INTRAPREFIX empty
10:05 koyauni and next one "admin"
10:05 mtompset Yes.
10:06 eythian the "next one" is INTRASUFFIX, yes?
10:06 koyauni INTRASUFFIX="admin"
10:06 mtompset right.
10:06 koyauni INTRAPREFIX=""
10:06 * eythian really needs to make it ask these questions at install time.
10:06 mtompset yes.
10:06 koyauni what is OPACPORT=""
10:07 mtompset You could have it on a different port.
10:07 koyauni it did not ask me
10:07 mtompset if you wanted ... you'd put 12345 as the port.
10:07 koyauni ok
10:07 koyauni 8080
10:07 koyauni is ok then
10:07 eythian really?
10:07 wahanui Of course!
10:08 koyauni OPACPORT="8080"
10:08 mtompset no, because OPAC is NOT the staff client.
10:08 eythian normally you'd want port 80.
10:08 mtompset Yes, what eythian said.
10:08 koyauni OPACPREFIX="library"
10:08 eythian no
10:08 itachi no thats the users interface be careful
10:08 eythian that's a prefix, that's not the name
10:08 mtompset OPAC is the user client.
10:08 eythian if you do that you'll end up with "librarylibrary"
10:08 itachi yes
10:08 mtompset No, leave the OPACPREFIX and OPACSUFFIX blank.
10:08 koyauni so libraryadmin then
10:08 koyauni OPACPREFIX="libraryadmin"
10:09 mtompset No... blank.
10:09 itachi leaving it means 80 and nothing will show up
10:09 mtompset OPACPREFIX="SAMPLE"
10:09 mtompset means
10:09 eythian OPAC is Online Public Access Catalog, this is not your staff client.
10:10 mtompset OPACSUFFIX="EXAMPLE" means
10:10 thd-away joined #koha
10:10 mtompset
10:10 eythian this is why Koha can't be set up like drupal, drupal doesn't need multiple interfaces to one application like this.
10:11 koyauni ok I leave those blank then
10:11 eythian yes
10:11 mtompset Yes.
10:13 koyauni ok
10:14 koyauni like this
10:14 koyauni OPACSUFFIX=""
10:14 mtompset DOMAIN=""  # Any library instance will be a subdomain of this string.
10:14 mtompset INTRAPORT="80"  # TCP listening port for the administration interface
10:14 mtompset INTRAPREFIX=""  # For administration interface URL: Prefix to be added to the instance name.
10:14 mtompset INTRASUFFIX="admin"  # For administration interface URL: Suffix to be added to the instance name.
10:14 mtompset DEFAULTSQL=""  # only needed if you're pre-populating from another Koha database
10:14 mtompset OPACPORT="80"  # TCP listening port for the users' interface
10:14 mtompset OPACPREFIX=""  # For users' interface URL: Prefix to be added to the instance name.
10:14 mtompset OPACSUFFIX=""  # For users' interface URL: Prefix to be added to the instance name.
10:14 mtompset ZEBRA_MARC_FORMAT="marc21"  # Specifies format of MARC records to be indexed by Zebra. Possible values are 'marc21', 'normarc' and 'unimarc'
10:14 mtompset ZEBRA_LANGUAGE="en"  # Primary language for Zebra indexing. Possible values are 'en', 'fr' and 'nb'
10:14 mtompset Hmm.... should have pastebin'd that.
10:14 mtompset paste?
10:14 wahanui i guess paste is found at
10:14 thd-away joined #koha
10:15 pastebot "mtompset" at pasted "What your file should look like." (10 lines) at
10:15 mtompset I assumed you were using Marc21 and EN.
10:15 koyauni yes
10:16 thd-away joined #koha
10:16 mtompset I'm assuming it will ask for the hostname part, eythian? Or is it going to grab it from the machinename?
10:16 koyauni the host name is the same as the main domain]
10:17 eythian mtompset: the hostname is the name you give to koha-create
10:17 thd-away joined #koha
10:17 mtompset Ah, okay... so his koha-create command will be koha-create library?
10:17 eythian in koyauni's case, he'd want to do 'koha-create --create-db library' (later on, not now, work through the steps first, don't jump ahead)
10:18 eythian yeah, more or less
10:18 mtompset sudo koha-create --create-db library.
10:18 eythian no
10:18 eythian not yet
10:18 eythian also with no . at the end when the time comes
10:18 mtompset I know not yet... he's got a couple steps before that.
10:19 thd-away joined #koha
10:19 mtompset Oh, an koyauni --- ignore that /etc/koha/passwd thing... it is a confusing comment for power user setups.
10:19 eythian I was making sure he didn't go and do it now because it would fail and cause an annoying situation to fix.
10:20 mtompset He's got the sudo a2enmod rewrite, sudo apt-get install mysql-server first.
10:20 eythian yeah, that passwd thing needs to be removed.
10:20 eythian or put somewhere else
10:21 mtompset I'm still pondering the install process how to better synchronize the tarball, git, and packages install instructions.
10:22 eythian I want to get more of it automated eventually
10:23 mtompset Because the pre-install stuff is the same for all three: add repo, apt-get update, upgrade
10:24 mtompset technically, the install mysql-server step could be combined with the tarball's dselect steps.
10:25 mtompset It's when you do the install koha-common vs. building... that's when it deviates.
10:25 eythian yeah
10:25 mtompset But then it rejoins for some apache2 stuff...
10:26 mtompset sort of.
10:27 mtompset the koha-create step is kind of like the sudo make install.
10:27 eythian I won't conflate them, semantically and what they do is almost totally different.
10:27 mtompset but the the latter requires a bunch of linking.
10:27 eythian for example, running koha-create again is possible and will do something sensible, running make install won't
10:28 mtompset Yes, that is yet another advantage of packages... easy site management.
10:29 mtompset you can get multiple sites with packages, you can't with tarballs and gits.
10:33 itachi can i ask a question about managing the system? i mean koha
10:34 mtompset Seeing, as koyauni has gone quiet, why not? :)
10:34 itachi ok so after you have everything ready i mean the records and they all have Call Number and Control number
10:35 itachi how do you start sorting them in shelves ?
10:37 mtompset That sounds like a librarian type question. Sorry, I don't know.
10:37 itachi aha ok can you lead me to someone knows about those stuff
10:44 jenkins_koha Project Koha_3.8.x build #128: SUCCESS in 1 hr 5 min: http://jenkins.koha-community.[…]b/Koha_3.8.x/128/
10:44 jenkins_koha oleonard: Bug 8590 - checked out from missing on patron detail
10:44 huginn Bug[…]w_bug.cgi?id=8590 normal, P5 - low, ---, oleonard, Passed QA , checked out from missing on patron detail
10:44 jenkins_koha Starting build #129 for job Koha_3.8.x (previous build: SUCCESS)
10:46 * mtompset doesn't  know. Sorry. I'm still pretty new to the community.
10:47 * mtompset wanders off for a meal called supper.
11:00 thd-away joined #koha
11:18 jwagner joined #koha
11:34 jcamins Good morning, #koha.
11:41 mib_sdkm9v joined #koha
11:48 drojf hi jcamins
11:48 jwagner joined #koha
11:49 jenkins_koha Project Koha_3.8.x build #129: SUCCESS in 1 hr 5 min: http://jenkins.koha-community.[…]b/Koha_3.8.x/129/
11:49 jenkins_koha jcamins: Bug 8572: invalid auth shouldn't cause error
11:49 huginn Bug[…]w_bug.cgi?id=8572 major, P5 - low, ---, jcamins, Passed QA , Attempting to view an invalid authority in the OPAC gives an error instead of 404
11:53 nengard joined #koha
11:55 sophie_m joined #koha
12:00 mtompset Greetings, jcamins jwagner nengard and sophie_m
12:01 nengard :)
12:04 koyauni sorry guys,
12:04 koyauni I was doing what every father does, feeding my child :)
12:04 koyauni I have done up to sudo koha-create --use-db biblio where I force the installation to use our DB
12:05 mtompset no no no...
12:05 koyauni and created a passwd file as well
12:05 mtompset Okay... I just did this the other day.
12:05 mtompset taking my data from another system and putting it into the packages version.
12:05 koyauni it world not work
12:06 koyauni no thsi is just empty DB
12:06 mtompset okay... So, you haven't run the koha-create yet?
12:06 koyauni but the DB is created in Plesk and then I can have auto backup on that DB via Plesk
12:06 koyauni I did run sudo koha-create --use-db myDB
12:07 mtompset well 'library' was what you were supposed to use. :)
12:07 koyauni and it was fine
12:07 mtompset that way it sets up for
12:08 mtompset and
12:08 koyauni ok, so I do not need to do anything else then
12:08 mtompset well... let's see...
12:08 mtompset Pulling up the page
12:08 mtompset packages?
12:08 wahanui packages is at
12:08 jcamins koyauni: didn't rangi suggest using koha-create to create the database and then setting up Plesk to do the automatic backup?
12:08 koyauni thsi is a new server and DNS still point to the old server
12:09 eythian that would make a lot more sense
12:09 koyauni does it make any different
12:09 eythian you're trying to make shortcuts when you don't really know the way
12:09 eythian that's a bad idea doomed to failure
12:10 * mtompset nods, "Been there. Done than. Doomed ideas that is."
12:10 koyauni ok, I can do it that way
12:10 jcamins koyauni: yes. You are inexperienced with Linux, but you're trying to do something no one else has done.
12:10 koyauni :)
12:10 koyauni can I reverse that step
12:11 mtompset What is it? koha-remove?
12:11 eythian yeah
12:11 koyauni and do this now sudo koha-create --create-db biblio
12:11 eythian no
12:11 eythian where does biblio come from?
12:11 koyauni or it is now done! and way back
12:11 eythian why do you keep doing that?
12:12 mtompset koyauni: I told you use library, because you want
12:12 drojf because its in the example…
12:12 koyauni ohh that is from wiki instruction page
12:12 mtompset biblio is AN EXAMPLE.
12:12 koyauni sudo koha-create --create-db mykohaLibrary
12:12 mtompset Your case you want .....
12:12 mtompset NO.
12:12 mtompset library.
12:12 wahanui library is given the option, via the "/" of whether or not to be that specific in their own classification of the book.
12:13 mtompset sudo koha-create --create-db library
12:13 magnuse wahanui: forget library
12:13 wahanui magnuse: I forgot library
12:13 koyauni sudo koha-create --create-db library
12:13 mtompset yes
12:13 koyauni it has to be that then
12:13 mtompset yes, because you want
12:13 koyauni yes, so db should be the same as subdoamin
12:13 koyauni domain
12:14 eythian yeah
12:14 koyauni ok, lets do this then
12:14 eythian oh, someone's edited that page and made things more confusing
12:15 mtompset That would be you. :P
12:15 mtompset May 13-August 9... you made changes, eythian
12:16 mtompset Unless you are talking about Narcisgarcia's April 25-26 stint.
12:17 eythian I didn't add anything to do with the passwd stuff, I have changed it to make it more obvious that it's optional
12:17 eythian but not obvious enough
12:17 eythian Using an existing db should be considered advanced
12:18 eythian and not in the standard instructions
12:18 davidnind left #koha
12:18 jcamins julian_m++
12:19 mtompset Yes, it was Narcisgarcia. April 25.
12:20 mtompset But you did edit it after. You didn't read the whole page? ;)
12:20 julian_m :)
12:20 eythian Not with that in mind
12:20 eythian I've been putting it off a bit because I know it needs a start-from-scratch rewrite
12:21 koyauni I did that now
12:22 eythian cool. All going well, it might be working now.
12:23 mtompset I don't think it needs a start from scratch rewrite.
12:23 mtompset It generally is pretty good.
12:23 mtompset It needs a couple things cut and added, but not much.
12:23 eythian Well, I want to make it a bit more step-by-step really. And maybe link to optional things
12:24 eythian though right now, I'm going to remove that stuff about the passwd and existing database and such.
12:24 eythian It's tripped a few people up
12:24 mtompset And add a comment about the name after --create-db is linked to the subdomain.
12:25 koyauni I think screenshots are best
12:25 eythian koyauni: screenshots of terminal commands are hard to copy-paste :)
12:26 * mtompset grins, "Yes, it's sort of silly to have a screen shot."
12:26 mtompset If it was a graphical install, then most certainly, but terminal commands... just formatted text.
12:26 liw not having many steps to install is best
12:26 koyauni it need to be consistence references to element in this process. it need to be dummy prove !
12:27 mtompset Sadly, koyauni, there is a better dummy born every minute.
12:27 mtompset So dummy proof is extremely hard to get.
12:28 eythian koyauni: the problem is installing a server application onto a server operating system when you don't know how servers work properly. That's like saying it should be dummy-proof to add a room onto your house when you don't know anything about building.
12:28 mib_sdkm9v hey i take over for koyauni
12:28 mib_sdkm9v instancename:username:password:databasename
12:28 mtompset I cleaned up the tarball install instructions for Ubuntu, and someone complained I didn't explain how to set up a memcached server.
12:29 eythian There are so many possible configurations that it's hard to know what someone wants.
12:29 eythian mib_sdkm9v: you should ignore that step
12:29 eythian in about 3 minutes it'll be deleted
12:29 koyauni is this correct instancename:username:password:databasename
12:29 mtompset NO!
12:29 eythian no.
12:29 mtompset you don't need it.
12:29 mib_sdkm9v instance=library......databasename=what ever database we use
12:29 mtompset Trust me,... I had the pleasure of figuring that out lately.
12:29 edveal joined #koha
12:30 mtompset mib_sdkm9v: Don't follow that step.
12:30 mib_sdkm9v ok
12:30 mtompset Stop doing steps.
12:30 mib_sdkm9v then i delete the passwd file
12:30 koyauni so in my case that file of passwd should contain instancename:username:password:library
12:30 mib_sdkm9v right?
12:30 eythian koyauni: the password file doesn't need to exist at all
12:30 eythian mib_sdkm9v: yep, deleting it is fine
12:30 koyauni :( so no step thing
12:31 eythian koyauni: also, why have you gone backwards through the process?
12:31 drojf what is wrong with that file?
12:31 * drojf is confused now
12:31 koyauni ok I remove it
12:31 mtompset eythian is cleaning up the instructions, so please slow down, mib_sdkm9v.
12:31 koyauni I will be back in 2 hrs and check again
12:31 koyauni sorry I have to go, many thanks for your time
12:31 jcamins drojf: it confuses people.
12:31 eythian drojf: it's totally and completely unnecessary unless you are doing advanced things
12:32 eythian I've never ever used it.
12:32 eythian for example
12:32 mtompset I thought it was necessary as part of transplanting our DB into packages... it isn't.
12:32 drojf i dont know what advanced things it would do, i thought its just to set your password yourself
12:33 jcamins drojf: it lets you share a database between multiple instances.
12:33 mtompset You only need to log into koha ONCE as the default user.
12:33 mtompset No need to try to set your own password.
12:34 eythian drojf: it can be used to let you define the password yourself, but that's not something that's necessary.
12:34 drojf ah ok. i only used it with a database that i just created  in the koha-create command and that did not seem to be a problem. but then i did not really see what it would be useful for
12:35 mtompset By the way, does the koha package still exist? Is bug 5071 ever going to get fixed?
12:35 huginn Bug[…]w_bug.cgi?id=5071 enhancement, P5 - low, ---, robin, NEW , Make the 'koha' package set things up so that zebra etc. just work
12:35 jcamins We should probably remove it, I suppose.
12:35 eythian mtompset: it's on my "want to fix" list
12:36 eythian the problem you end up with though is that you can't pick a configuration that'll work for many people all that easily
12:36 mib_sdkm9v mtompset...eythian what should i do to finish the installation ? :)
12:36 eythian mib_sdkm9v: wait one moment
12:36 mib_sdkm9v ok :)
12:40 eythian[…]ueeze#Quick_Start <-- this is now hopefully less confusing
12:40 mib_sdkm9v thank you
12:41 liw eythian, "OPACSUFFIX=""  # For users' interface URL: Prefix to be added to the instance name." -- s/Prefix/Suffix/ ?
12:42 mib_sdkm9v can ai past a out put here
12:42 eythian liw: fixed, ta
12:42 mib_sdkm9v of koha-sites.conf
12:42 eythian mib_sdkm9v: if it's a couple of lines, yes. Otherwise use pastebin
12:42 eythian wahanui: paste
12:42 wahanui i guess paste is found at
12:42 eythian liw: I want to make debconf build that file at some stage.
12:43 jcamins nengard: Long Island City? Not exactly a hopping vacation spot. :)
12:43 mib_sdkm9v 9 lines exactly
12:43 nengard LOL
12:43 jcamins Use
12:43 liw eythian, *nod*
12:43 nengard Just going to teach them all about wordpress for the day
12:43 nengard and then home
12:43 nengard I use tripit to track work travel :)
12:43 mtompset
12:43 pastebot "mib_sdkm9v" at pasted "koha-sites.conf" (9 lines) at
12:43 mtompset This is what I pasted before for koyauni.
12:44 eythian mib_sdkm9v: that looks OK to me
12:44 jcamins There is a very good sea food restaurant in LIC. Don't know exactly where, though, or what it's called, so...
12:44 mtompset Yes.
12:44 mtompset That is fine, mib_sdkm9v
12:44 mib_sdkm9v ok very good
12:44 jcamins If you run into an excellent seafood restaurant, let me know 'cause Shari and I would like to go back. ;)
12:45 eythian mtompset: can you have a glance over that page and see if it's clearer for you now?
12:46 eythian (my problem is I know how it all works too deeply)
12:46 mtompset debian?
12:46 wahanui hmmm... debian is what most people use and there are good manuals and even packages for that
12:46 mtompset packages
12:46 wahanui packages is at
12:46 eythian yeah
12:46 mtompset I would have left the localhost version in.
12:47 eythian I was thinking that would be better off on another page
12:47 eythian I want to have a limited amount of options on here
12:47 mib_sdkm9v hmm when i enter it gets directed to
12:48 mib_sdkm9v dns problems right?
12:48 mtompset Yes, but inevitably, someone is going to ask, what if I don't have a named host?
12:48 eythian mib_sdkm9v: most likely
12:48 chris_n` joined #koha
12:48 eythian mib_sdkm9v:
12:48 eythian is an alias for
12:48 eythian has address
12:48 eythian has address
12:48 eythian definitely a DNS problem
12:49 eythian mtompset: in that case, I would suggest that they use their /etc/hosts file to set it up
12:49 eythian which means that as soon as they get DNS set up, it will work.
12:50 mtompset Yes, but I'm running in a local host VM environment. I don't want named hosts. I know the ip address of the machine and will be going to it.
12:50 mtompset particularly since the ip address is dynamic.
12:50 mib_sdkm9v so what i do with the host file
12:51 eythian mib_sdkm9v: nothing
12:51 eythian well
12:51 eythian it depends
12:51 eythian is it easier for you to fix your DNS now, or do you want something that'll make it go now?
12:52 mib_sdkm9v im not quite femiliar with cpanal if there is anything i can do in terminal tell me
12:52 mib_sdkm9v to fix the dns problem
12:52 mib_sdkm9v nope
12:52 eythian mib_sdkm9v: we can't guide you in that, it's up to your network administrators to do so.
12:52 mib_sdkm9v i want to fix the DNS
12:53 mib_sdkm9v i am my network administrator its my own
12:53 mib_sdkm9v :/
12:53 eythian mtompset: I'm running in a local host VM environment. My hostnames are 'koha' and 'koha-intra', and they're defined in /etc/hosts
12:53 mtompset yes, but then you get into the editor wars.
12:53 eythian in that case, however you've set up the DNS entry for library. and libaryadmin., you'll have to change them to point to your koha box
12:53 mtompset less edit'ing good.
12:54 mib_sdkm9v they are defined there cuz your are on a localhost
12:54 mib_sdkm9v and my koha box is>?
12:54 mtompset Yes, I know how to do it, but it's a pain.
12:54 eythian mtompset: the problem is that if you want to take your locally setup box and make it work on a LAN, it's now more work.
12:54 eythian which is the sort of thing people want to do.
12:55 mtompset Hmmm... I can see your point.
12:55 eythian mib_sdkm9v: use 'ifconfig' to find that out, it'll tell you your IP address.
12:55 eythian I think erring towards a best-practices setup is the best idea.
12:55 magnuse best-practices++
12:55 mib_sdkm9v so i got ifconfig after that what
12:57 eythian mib_sdkm9v: it tells you your IP address. You put that IP address into the system that runs your DNS in order to point the right domain names at the koha system.
12:57 mib_sdkm9v aha
12:57 mib_sdkm9v got it ;)
12:58 eythian cool
12:58 mib_sdkm9v but just so you knwo
12:58 mtompset Okay... so do I leave domain blank on the initial install, or do I take a wild guess at where I will be hosted?
12:59 mib_sdkm9v the koha is on the same server which handle everything
12:59 mib_sdkm9v you get me
12:59 eythian mib_sdkm9v: ohh
12:59 mib_sdkm9v yup
12:59 mib_sdkm9v -_-
12:59 eythian as in, it's supposed to be on the same server that hosts as well?
13:00 mib_sdkm9v yes its on the same server
13:00 eythian ah, then the DNS is correct.
13:00 eythian Most people put it on a different server
13:00 mib_sdkm9v yes
13:00 mib_sdkm9v well its on the same server
13:00 eythian in that case, you'll have to have a look at your apache configuration to see how it needs to change
13:01 mib_sdkm9v and there is only one ip which is's one
13:01 eythian you will have /etc/apache2/sites-enabled/library and that contains the config generated for koha
13:02 mib_sdkm9v yes i know i installed many git versions before without any problem  its a server problem
13:03 mib_sdkm9v editing the file been shortcut to sites-available is better
13:03 mib_sdkm9v right?
13:04 eythian cool, I usually find when that happens that I've done something silly with my virtual host config
13:04 jcamins mib_sdkm9v: it's the same file.
13:04 eythian mib_sdkm9v: they're both the same file
13:04 ago43 joined #koha
13:04 mib_sdkm9v i know but editing from the files and not the shorts
13:05 eythian it makes no difference really
13:06 mib_sdkm9v and the dns which handle them is on the same server
13:06 mib_sdkm9v you get me>?
13:06 jcamins mib_sdkm9v: are you are using A records for all the DNS?
13:06 eythian jcamins: the koha stuff is a CNAME
13:07 eythian mib_sdkm9v: that's a fairly bad idea, in general.
13:07 jcamins eythian: ah, missed that part.
13:07 mib_sdkm9v i well i dont know i just started working on this server 10 mins ago
13:07 mib_sdkm9v well thats how is it
13:07 eythian heh OK, not your fault then :)
13:07 mib_sdkm9v everything on one server
13:08 mib_sdkm9v and one dedicated ip address
13:08 eythian I think I'd probably make the gateway a reverse proxy so I could split servers up behind it in that situation.
13:09 mib_sdkm9v -_- more work
13:09 eythian or just make everybody move to IPv6 so it was no longer an issue :)
13:09 * jcamins would probably switch the DNS to A records... easier to troubleshoot.
13:09 mib_sdkm9v hhhhhhhhh
13:09 libsysguy joined #koha
13:09 eythian I've never had problems with CNAMEs
13:09 mib_sdkm9v jcamins i think its the way its working
13:10 eythian also, it's not the DNS issue here, I think it's an apache config thing
13:10 jcamins eythian: nor have I. However, right now www and koha are on the same box. I foresee fun times in a year when things are rearchitected, and the website gets moved without the CNAMEs being updated.
13:10 mib_sdkm9v which .conf exactly
13:10 mib_sdkm9v ?
13:11 eythian yeah, fair enough
13:11 eythian mib_sdkm9v: we could have no possible idea
13:11 mib_sdkm9v hhhhh damn -_-
13:11 mib_sdkm9v i must check them all
13:11 mtompset Isn't there a grep to help?
13:11 eythian[…]sts/examples.html <-- this kind of thing may be useful
13:12 jcamins mtompset: without knowing what the problem is, it would be problematic.
13:12 mib_sdkm9v no no i can find the files
13:12 mib_sdkm9v but which one has the problem ...looks like no one knows
13:12 mib_sdkm9v hey the httpd.conf file
13:13 eythian the problem is that it's caused by something that's specific to your configuration
13:13 mib_sdkm9v is it supposed to be empty?
13:13 eythian yeah
13:13 mtompset mine is?
13:14 mib_sdkm9v another question
13:15 mib_sdkm9v is the sites available there is library
13:15 mtompset which is the same as sites-enabled.
13:15 mib_sdkm9v dose adminlibrary need to be there too
13:15 eythian it should be inside that file
13:15 eythian it should have two virtualhost entries
13:15 mtompset ls
13:15 mib_sdkm9v yes
13:15 mtompset Oops...
13:15 mib_sdkm9v i know
13:16 mib_sdkm9v i found something
13:16 eythian the second one should say "ServerName" or similar
13:16 mib_sdkm9v the virtual host and the intranet (admin panal) are on the same port
13:16 mib_sdkm9v which is 80
13:16 eythian that's normal
13:16 eythian that's why they're virtual hosts :)
13:17 mib_sdkm9v :/ everything looks good there
13:18 mtompset Did you restart apache2?
13:18 eythian a good question.
13:18 mib_sdkm9v yup -_-
13:18 mtompset Are the named hosts in ports.conf?
13:19 mib_sdkm9v a sec
13:19 eythian I don't think you need to do that
13:19 eythian I just have, e.g. NameVirtualHost *:80
13:19 eythian or similar
13:19 mtompset But NameVirtualHost shouldn't be commented out, should it?
13:19 eythian No
13:19 mtompset Right.
13:20 * mtompset laughs, "We're agreeing in a bizarre way."
13:20 eythian :)
13:20 mib_sdkm9v hhhhhhh everything looks good guys
13:20 mib_sdkm9v it must be a dns problem
13:21 eythian I don't think it is
13:21 eythian the DNS looks OK
13:21 mtompset does the ip address of ifconfig match the ip address of
13:22 mtompset perhaps there is some bizarre reverse proxy that needs to know about it.
13:22 mib_sdkm9v is a subdomain
13:22 eythian it still has an IP address
13:22 eythian, specifically
13:24 mib_sdkm9v the ipconfig output and the are the same
13:24 mib_sdkm9v ifconfig*
13:24 mib_sdkm9v where did you get that its not that
13:25 mib_sdkm9v oh God
13:25 mib_sdkm9v let me make it clear
13:25 mib_sdkm9v that domain was hosted on another server
13:25 eythian $ host
13:25 eythian is an alias for
13:25 eythian has address
13:25 wahanui i already had it that way, eythian.
13:25 mib_sdkm9v which is the ip you got
13:25 mib_sdkm9v but now its on a new server with a new ip address
13:26 eythian If you've changed it within the past 4 hours or so, I could be seeing an old version
13:26 mib_sdkm9v maybe
13:26 mtompset I see the same as you, eythian.
13:27 mib_sdkm9v but if it changed why it get directed to our site right?
13:27 eythian I actually get: Site under maintenance
13:27 eythian Koya University's new web site is currently under construction. Thank you for your patience.
13:27 eythian maybe your internal DNS is doing something different
13:27 mib_sdkm9v yes thats it
13:28 eythian OK, fwiw that's not a redirect, that's apache serving it up under that name.
13:28 eythian minor difference, but maybe useful when debugging
13:28 mtompset I got a parallels page.
13:29 mtompset paste?
13:29 wahanui rumour has it paste is found at
13:29 eythian germs?
13:29 wahanui Germs originated in Germany, before rapidly spreading throughout the rest of the world.
13:29 mib_sdkm9v wait please
13:29 pastebot "mtompset" at pasted "Part of what I see when I go to" (10 lines) at
13:29 mib_sdkm9v i have an idea
13:30 eythian oh, I get something different from library and libraryadmin
13:30 eythian that is really quite odd
13:31 mtompset Yes, that is truly bizarre.
13:31 mib_sdkm9v damn odd -_-
13:31 eythian also terrifically insecure
13:31 mib_sdkm9v hmmmm
13:31 mtompset Oh shoot.... is down.
13:31 mib_sdkm9v i think i know why its  like that
13:32 mtompset Same site under maintenance message.
13:32 mib_sdkm9v thats because ppl are working on it
13:32 mtompset (as libraryadmin)
13:32 mib_sdkm9v listen to me for a sec
13:32 mib_sdkm9v i think the problem is the domain is hosted by 2 servers
13:33 mib_sdkm9v different servers
13:33 eythian ah, so you have a reverse proxy that's not set up right?
13:33 eythian (or similar)
13:33 mib_sdkm9v thats why one direct to somewhere and the other is directing to somewhere else
13:33 mtompset YAY! I guessed that already. ;)
13:34 mib_sdkm9v no no the domain was on another old server before they get it on this one
13:34 mib_sdkm9v but i think they didnt delete or disable it there
13:34 mib_sdkm9v thats why this shit is happning
13:34 mtompset Okay... so you were on domain X. Decided to jump domain providers.
13:34 eythian that'd make some sense
13:35 mtompset And now you are in the transitional mess?
13:35 mib_sdkm9v yup
13:35 mib_sdkm9v idk
13:35 mib_sdkm9v really
13:35 mib_sdkm9v just let me check that idea
13:35 mib_sdkm9v
13:35 mib_sdkm9v that might work
13:36 NateC joined #koha
13:36 jcamins You can't use subdomains with IP addresses.
13:36 mib_sdkm9v cuz the new ip directs to another place not the maintenance page
13:36 mib_sdkm9v -_-
13:37 mib_sdkm9v then what should i do
13:37 eythian edit the hosts file on your local machine?
13:37 eythian if you do that, just remember you did, or you'll get really confused why things behave differently on your machine vs. another one.
13:37 mib_sdkm9v yes yes
13:38 mib_sdkm9v thats why i dont want to do that :/
13:38 mtompset And this has become a networking/apache problem far beyond the typical scope of Koha.
13:39 mtompset out of curiousity... how many files were in the sites-enabled directory?
13:39 mib_sdkm9v yes sorry guys appreciate it
13:39 mib_sdkm9v aha
13:40 mib_sdkm9v 3 :/ should be 2 or 1 right
13:40 mtompset what are their names?
13:40 mib_sdkm9v the 000-default and library and another one
13:41 mtompset I don't know about everyone else here, but I tend to edit the 000-default to be port 4080, and then add a listen 4080 to the ports.conf
13:42 mtompset of course... if this hosts the university's pages, that's probably a bad idead.
13:42 mtompset idea.
13:43 mib_sdkm9v hey the get the maintenance page while the new server ip which detected to it get another page
13:43 drojf mib_sdkm9v: 000-default is the apache test page. you can turn that off with 'sudo a2dissite default'. unless you changed that page and it does something useful of course
13:44 mib_sdkm9v the is still one the 69 ip which should have changed to the new ip
13:44 mib_sdkm9v thats not a problem
13:45 mib_sdkm9v hey eythhian take a look at what i said and tell me if you have an idea
13:45 eythian well, it sounds a lot like 000-default is taking over
13:46 eythian are you able to disable that without it affecting anything else?
13:46 eythian (as drojf said really)
13:47 mib_sdkm9v well i can enable it after that right?
13:47 maximep joined #koha
13:47 mib_sdkm9v if anything got wrong
13:47 mib_sdkm9v or if it didnt change anything'
13:48 eythian yeah
13:48 eythian just a2dissite default. To turn it back on, you can recreate the symlink
13:48 eythian (a2ensite will probably give it a different name, hence not doing that)
13:50 mib_sdkm9v it didnt change anything
13:50 mib_sdkm9v tell me how to re do what i did
13:51 mib_sdkm9v undo*
13:51 mib_sdkm9v -_-
13:51 eythian sudo ln -s /etc/apache2/sites-available/default //etc/apache2/sites-available/000-default
13:51 eythian no wait
13:51 eythian sudo ln -s /etc/apache2/sites-available/default //etc/apache2/sites-enabled/000-default
13:51 eythian that one
13:51 eythian err
13:51 eythian sudo ln -s /etc/apache2/sites-available/default /etc/apache2/sites-enabled/000-default
13:51 eythian THAT one
13:52 eythian did you restart apache after you did the dissite?
13:52 talljoy joined #koha
13:52 mib_sdkm9v yup
13:53 mib_sdkm9v man lets do this one more time
13:53 mib_sdkm9v when you type host
13:53 mib_sdkm9v it get you an ip address
13:54 eythian
13:54 mib_sdkm9v that ip address is the old servers ip address
13:54 mib_sdkm9v the new one is different so whats wrong
13:54 mib_sdkm9v ?
13:54 mib_sdkm9v thats old server ip address
13:55 eythian your name server is at and is still reporting the old address
13:55 mib_sdkm9v nah those are all the old servers things
13:55 mib_sdkm9v you get me
13:56 eythian dig +trace should get the absolute latest one I think
13:56 eythian and it's still saying the old one
13:56 mib_sdkm9v yes exactly
13:56 mib_sdkm9v so i say why>?
13:57 eythian Sounds like the changes haven't been committed on the DNS server
13:58 bshum joined #koha
13:58 mib_sdkm9v or they are handled from 2 different servers and DNS s
13:58 mtompset Low can we go would have been better. ;)
13:58 drojf if i export marc biblio frameworks from the staff client in sql and import that sql into a fresh koha db, i don't see the new framework in the new staff client. what am i missing?
13:58 eythian mib_sdkm9v: also possible, yeah
13:59 eythian if one is out of sync, crazy things happen
13:59 mib_sdkm9v hum that could be it
14:00 mib_sdkm9v i will tell koyauni to disable the old servers things and i will tell him that his site is still handled by the old server
14:01 gaetan_B drojf: are you importing it directly in mysql or through the staff client ?
14:01 gaetan_B i've had problems importing through the staff client before
14:02 drojf directly in mysql
14:02 gaetan_B if a foreign key constraint fails, then the import fails silently
14:02 gaetan_B oh, can't help you i'm afraid then... :(
14:03 drojf thanks for trying though :)
14:03 eythian drojf: might be worth trying the non-SQL methods?
14:03 eythian the framework stuff is confusing to me
14:04 drojf eythian: yes we will have to do it that way. i think we have to manually create each framework and then load the csv or whatever out we have, i tried to avoid that. still way faster than clicking all the frameworks anew
14:05 drojf s/out/output/
14:05 eythian the only time I've really had it work is when loading all the frameworks from one site into another one
14:05 eythian I think otherwise some sequences get upset or something
14:06 drojf yes i would have a look at the whole dump but i would need to get rid of the biblio data first. no fun scrolling through a 1,4gb file
14:06 mib_fpxghe joined #koha
14:07 mib_fpxghe .
14:08 drojf
14:10 mtompset I blame auto-increment fields. ;)
14:22 drojf hm yes it might need a "drop table" and add all custom frameworks at once. "export all frameworks to one sql file" would be a nice option for that
14:23 drojf but that might lead to people complaining about losing all other frameworks after import ;)
14:26 mtompset BAH! Let them enter them again. We know how fun that is. ;)
14:26 drojf heh
14:31 drojf so it's gbsd for some people already? where's the music, the drinks, the people?
14:33 eythian ooh. awkward. No one invided drojf.
14:33 eythian *invited
14:34 drojf i may just sit quietly in the corner and do a frustration signoff later
14:35 eythian Try not to eat _all_ the ice cream ;)
14:35 kf drojf: technically it's not arrvied in germany yet :)
14:36 drojf i know, it seems to have not arrived in #koha too
14:38 mtompset Technically, it isn't for another 1.5hours for me.
14:38 mtompset I've never done a sign off before.
14:39 mtompset I much prefer finding and providing patches.
14:39 mtompset You need to work to your strengths. :)
14:39 drojf i'd like to start to avoid doing stuff that i should actually be doing
14:40 wizzyrea lol you guys are funny
14:40 drojf you should try signoffing too. it does not work if everybody adds patches and nobody does the testing
14:41 mtompset That would mean I'd have to know how to test.
14:41 * wizzyrea has done many signoffs in her day
14:41 wizzyrea i've been frustrated lately by failing tests.
14:41 mtompset I still haven't mastered the data model.
14:41 mtompset Let alone the interface.
14:42 drojf it's a way to get around all things koha. you go to places you have never been before ;)
14:42 mtompset Is there a list of bugs somewhere?
14:42 mtompset bugs?
14:42 wahanui bugs is found at Please fix any bugs you find. :) or reporting them is helpful, too.
14:42 drojf but yes, it takes quite some time, even for th easy stuff that i was able to signoff on
14:42 drojf[…]doesn%27t%20apply
14:42 drojf this is labelled "patches for gbsd" in the wiki
14:44 * drojf claims bug 8185
14:44 huginn Bug[…]w_bug.cgi?id=8185 enhancement, P5 - low, ---, tajoli, Needs Signoff , Plugin for linking records in MARC21
14:44 drojf i tested that one before
14:44 drojf and we could use it
14:45 drojf i think there used to be an etherpad or something to put it what you work on, so people don't work on the same stuff. at least we had that at the hackfest, no idea who provided that
14:45 drojf s/put it/put in/
14:47 eythian I can make you an etherpad if you want it
14:48 drojf would be cool!
14:50 drojf mtompset: there is this really cool and easy to test bug 8377 if you want to try a signoff later ;)
14:50 huginn Bug[…]w_bug.cgi?id=8377 enhancement, P5 - low, ---, mirko, Needs Signoff , Show HTML5 video/ audio for media files in OPAC and staff client
14:50 kf drojf++
14:51 mtompset ha ha ha....
14:51 drojf for spamming my patch? cool, i'll do that more often ;)
14:51 eythian <-- drojf and everyone
14:51 kf no, for bringing gbsd to germany :)
14:52 kf mtompset: drojf is right - all developers should do their part in testing, it's much needed and you learn a lot about how Koha works
14:52 drojf woops, i got 37 windows trying to give me a cookie for the etherpad
14:52 kf plus others will be more likely to sign off on your patches :)
14:52 eythian drojf: I don't know how that would work
14:53 mtompset Well, I'll try to do one... but no guarantees. I don't make promises I can't keep.
14:53 kf eythian: could you put the link in the wiki maybe?
14:53 kf on the page for today's gbsd?
14:53 kf gbsd?
14:53 wahanui hmmm... gbsd is Global Bug Squashing Day
14:53 kf next gbsd?
14:53 wahanui i guess next gbsd is[…]bug_squashing_day
14:53 drojf set firefox from "no cookies" to "ask" when it does not work without the cooky, get a lot of windows that ask instantly ;)
14:53 eythian ah right, it probably fired off a bunch of ajax requests and you got a popup for each one
14:54 eythian what's the wiki page?
14:55 drojf[…]bug_squashing_day
14:57 eythian cool, yeah add it there if you like
14:57 drojf i will in a minute
14:57 drojf thanks for setting it up
15:01 drojf done
15:13 nengard anyone know where we are with bug 6413 ?
15:13 huginn Bug[…]w_bug.cgi?id=6413 major, P5 - low, ---, chrish, Failed QA , Notes in Fines doing wonky things
15:15 wizzyrea looks like it failed qa for varying things
15:17 wizzyrea dunno, we should try it again I think
15:18 wizzyrea doesn't apply :(
15:18 nengard yeah - added a note to get a new patch maybe
15:18 nengard i would love to see this finally fixed in 3.10 at least
15:19 wizzyrea yep
15:19 gaetan_B bye !
15:22 wizzyrea I think facebook has changed the way I want to use most things.
15:22 wizzyrea and google +1
15:22 wizzyrea i'm looking at a bug, and I don't want to add a comment "yes, what he said"
15:22 wizzyrea I just want to +1 or like it
15:22 wizzyrea to say I agree.
15:22 * wizzyrea is impossibly lazy.
15:22 drojf write a patch for bugzilla ;)
15:23 wizzyrea :)
15:23 drojf i would not be suprprised to see that available in some form. you can have plugins in bugzilla, right?
15:24 wizzyrea hm yes
15:24 eythian wizzyrea: it's sorta how gerrit works I think
15:24 eythian well, a bit different
15:24 eythian launchpad has a "this affects me" button
15:24 wizzyrea yes, I like that too
15:25 wizzyrea slightly different context but also a better metric for judging severity
15:25 wizzyrea if lots say "yes I have this problem too" it's easy to know what to fix
15:25 eythian jcamins_away: have you ever seen a package build not run the makefile?
15:26 eythian it went straight into running the rest of the rules, which obviously failed.
15:37 jcamins eythian: never.
15:37 eythian damn. Me neither until today.
15:38 eythian Hmm
15:38 eythian I wonder if because I was working on the code in one timezone, moving stuff over with git, and attempting the build there that something was getting out of sync timestamp-wise
15:38 jcamins Maybe.
15:39 jcamins Pretty weird, though.
15:39 eythian yeah
16:00 mtompset It looks like I'll be focusing on a couple of my own bugs for a bit.
16:01 liw joined #koha
16:11 melia joined #koha
16:16 jcamins eythian: stop trying to be sensible and doing things correctly.
16:16 eythian it's a curse, I know
16:18 drojf there goes my signoff :/
16:19 eythian running builds on my fairly hefty laptop is still a lot slower than my 2.5 year old ddesktop machine.
16:20 * jcamins is counting on a new server being much much faster than his laptop.
16:20 eythian my laptop is an i7 with a hybrid HD, it should be speedy.
16:21 jcamins Mine is a Core2duo or whatever it's called, with an ordinary hard drive. I never thought it was going to be particularly speedy.
16:22 eythian so 00-valid-xml.t doesn't tell you where an error is when it fails :/
16:22 eythian > Parse errors: No plan found in TAP output
16:22 eythian not helpful
16:23 jcamins No, not at all.
16:23 jcamins Well, it must be whatever file was changed last?
16:23 eythian no, it was some stray data I had lying around
16:23 eythian but it didn't tell me that
16:24 cait joined #koha
16:30 mtompset 12:28... and it is sitting at 85.[…]bin/
16:31 cait that's not too bad
16:31 cait maybe we can go 70? :)
16:31 * cait likes reaching for the starts
16:31 cait stars
16:36 mtompset No, no... Dancing with the Stars. ;)
16:38 mib_fpxghe joined #koha
16:40 mtompset Oh shoot...
16:41 mtompset it should say "bug ####:"?
16:41 mtompset my git commits have been "bug #### - "
16:41 jcamins It doesn't matter.
16:41 jcamins As long as it is "Bug ####" it'll get into the release notes.
16:41 mtompset Well, it says to avoid [bug ####]
16:41 jcamins Right.
16:42 jcamins No brackets.
16:42 mtompset workflow?
16:42 mtompset work flow?
16:43 mtompset workflow is described at[…]nt-patch_Workflow
16:43 jcamins Usually one word, but it doesn't matter.
16:43 mtompset wahanui: workflow is described at[…]nt-patch_Workflow
16:43 wahanui i already had it that way, mtompset.
16:43 mtompset workflow?
16:43 wahanui rumour has it workflow is described at[…]nt-patch_Workflow
16:44 mtompset work flow is workflow spelled less correctly.
16:44 mtompset work flow?
16:44 wahanui work flow is workflow spelled less correctly.
16:45 jcamins Hehe.
16:46 mtompset guidelines?
16:46 mtompset coding guidelines?
16:46 wahanui coding guidelines are[…]Coding_Guidelines
16:46 mtompset formatting guidelines?
16:46 mtompset format guidelines?
16:47 mtompset document guidelines?
17:12 eythian joined #koha
17:15 bshum joined #koha
17:22 * mtompset grumbles, "ARG! Programming bug somewhere. Can't work on Koha. :("
17:22 * mtompset waves.
17:22 mtompset Bye, #koha.
17:44 adnc_ joined #koha
17:48 fcapovilla joined #koha
17:49 jcamins fcapovilla++ # for bug 8610
17:49 huginn Bug[…]w_bug.cgi?id=8610 normal, P5 - low, ---, fcapovilla, ASSIGNED , Normalize records imported from Z39.50 servers to prevent Zebra search problems.
17:54 libsysguy joined #koha
17:56 drojf i should have a virtual machine running all my virtual machines, it's getting confusing
17:59 maximep fcapovilla is a machine :p
18:00 maximep I can't keep up with him :p
18:05 talljoy joined #koha
18:10 drojf hrm. why would i have only the "set flags" button, but no actual flags to set when i want to set permissions for a user?
18:10 jcamins You can only set permissions that your user has.
18:11 drojf ah you mean my user that tries to set the permissions lacks the permissions so he cannot set them for the other user?
18:12 drojf but its the default user, shouldn't that be superlibrarian?
18:12 jcamins You mean database user?
18:12 drojf yes
18:12 jcamins Ah.
18:12 jcamins Yes.
18:17 drojf heh. that's odd. never used this vm, made it in edinburgh. i guess i made something funny when changing paths from package to git
18:26 eythian so the report date picker is only in 3.8?
18:27 eythian (and above)
18:43 eythian Query OK, 1708404 rows affected (4 min 42.31 sec)
18:43 eythian not as bad as I expected
19:11 rangi well, after 2 weeks of being the only one not to get the flu on level 7, or at home, ive sucumbed
19:11 eythian urg
19:12 rangi yeah, its a nasty one
19:12 eythian If you feel like SQL will help, I can't get a query to run in a reasonable time :)
19:12 rangi i suspect i got some strain of it from the ED, the vaccine had been protecting me up to there
19:12 eythian ED?
19:13 rangi atarau had a febrile seizure, caused by the flu, so we ended up at ED on wednesday
19:13 rangi ill just write my whereis
19:13 rangi and then ill take a look at the sql
19:13 jcamins I'm sure he's fine, but how are his parents doing? :)
19:13 eythian ah, no fun
19:14 talljoy joined #koha
19:22 eythian annoyingly, if I break it down into parts it's fast enough, it's when it's all together that it's not
19:23 rangi explain doesnt tell you anything useful?
19:23 jcamins eythian: are you doing a select over biblioitems?
19:24 eythian <-- jcamins
19:24 eythian the subqueries seem fast enough (I put indices in to help), it's the two joins
19:26 jcamins If you remove the items join temporarily, does it run quickly?
19:29 eythian yep
19:30 jcamins What does explain say?
19:30 eythian everything except aqorders is using a key
19:30 eythian (that's the case even when it's fast though)
19:31 jcamins What order is it selecting in?
19:34 eythian aqorders, biblio, items, then the two subqueries
19:38 jcamins Hmmm...
19:40 rangi http://us2.campaign-archive1.c[…]085&id=80ce9994ad  <-- who saw this coming
19:42 * jcamins is shocked, surely.
19:42 drojf damn fascists
19:43 jcamins Wasn't there supposed to be some new, more-open micropayments handler?
19:45 drojf we need one, that's for sure
20:05 rangi ok, apparently i have to play cars
20:05 rangi bbiab
20:09 jenkins_koha Starting build #130 for job Koha_3.8.x (previous build: SUCCESS)
20:09 hankbank joined #koha
20:12 kathryn joined #koha
20:13 * wizzyrea waves to the newcomers
20:13 * kathryn waves back
20:30 talljoy joined #koha
20:35 * cait waves too
21:07 eythian_ joined #koha
21:13 jenkins_koha Project Koha_3.8.x build #130: SUCCESS in 1 hr 4 min: http://jenkins.koha-community.[…]b/Koha_3.8.x/130/
21:13 jenkins_koha fridolyn.somers: Bug 8440: Dates does not appear in suggestions management
21:13 huginn Bug[…]w_bug.cgi?id=8440 minor, P5 - low, ---, fridolyn.somers, Passed QA , Dates does not appear in suggestions management
21:19 cait left #koha
21:34 ago43 joined #koha
21:50 mib_vqhg6h joined #koha
22:12 maximep left #koha
22:54 Callender_ joined #koha
22:59 mtate joined #koha
23:09 papa joined #koha
23:34 Callender joined #koha
23:58 dcook joined #koha
23:58 dcook Allo #koha
23:59 dcook Does anyone know what happens if you already have a systempreference in your DB but tries to insert it anyways?

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary