IRC log for #koha, 2015-10-20

All times shown according to UTC.

Time S Nick Message
00:08 barton|away joined #koha
01:13 tcohen joined #koha
01:16 IceCube ok I have some questions, if anyone is still there
01:16 dcook Sort of here
01:16 dcook What's up?
01:16 IceCube hi dcook, thanks
01:16 IceCube well I followed the instructions exactly to a certain point and then I'm having a problem accessing the libraryname-intra site
01:16 IceCube I just get the "Apache works" page
01:17 IceCube does that make sense
01:17 eythian did you set up DNS?
01:17 IceCube yep
01:17 eythian did you ensure that ServerName in the apache config matches the DNS names, in both places?
01:17 IceCube I think that site isn't set up in apache
01:18 eythian have a look in the apache config
01:18 eythian the koha-create process would have made one
01:18 IceCube as far as I can tell
01:18 IceCube ok...
01:19 IceCube which one do I look in
01:19 eythian the ones that was created
01:19 dcook IceCube: What do you mean by which one?
01:19 eythian *one
01:24 IceCube apache-shared.conf
01:24 IceCube and...?
01:24 IceCube apache-shared-intranet.conf?
01:26 eythian no
01:26 IceCube I'm sorry for what are probably obvious questions
01:26 eythian /etc/apache2/sites-enabled/something.conf
01:27 IceCube oh ok yeah I have the one site but not the other
01:27 IceCube I did check that actually
01:28 IceCube there is the library name but not the libraryname-intra
01:28 tcohen joined #koha
01:28 eythian yeah, so there are two vhost definitions in that file
01:29 eythian one for opac, one for the admin interface
01:29 eythian they'll both need a correct servername definition
01:29 IceCube the admin one is port 8080?
01:30 eythian it doesn't have to be
01:30 eythian it's up to you how you configure it
01:30 IceCube but the one that is port 8080 by default is the second one (the regular library site defaulting to port 80)?
01:30 eythian I tend to give each one its own DNS name and have them both run on 80
01:30 wizzyrea ^
01:30 eythian the packages don't set anything on 8080 by default
01:30 eythian (I think)
01:31 IceCube I don't think I changed the default
01:31 wizzyrea no, they don't, I just did that and am looking at a fresh package created config file (for unrelated reasons)
01:31 eythian yeah, just checked, they don't
01:31 eythian so you have two virtual host sites. You need to make sure the servername for each of them is correct.
01:31 IceCube huh
01:32 IceCube ok
01:32 eythian it's possible you changed it in koha-sites.conf, that's where the defaults come from
01:32 wizzyrea koha on debian?
01:32 wahanui[…]ki/Koha_on_Debian
01:33 IceCube_ joined #koha
01:33 IceCube_ Sorry I missed the last thing
01:33 wizzyrea you're so nearly there :)
01:34 eythian wahanui: irc logs
01:34 wahanui irc logs are
01:34 eythian that'll get you what you missed
01:35 IceCube_ perfect, thanks.  Bookmarked :)
01:37 IceCube_ I restarted apache after I changed the port to 80 and that did the trick
01:37 eythian awesome
01:37 dcook \o/
01:39 wizzyrea \o/
01:39 dcook confetti?
01:39 wahanui i heard confetti was[…]1qh8hleo1_400.gif
01:39 wizzyrea A+ confetti-ing
01:39 dcook joined #koha
01:39 dcook Well then...
01:40 dcook That mouse has a mind of its own
01:40 IceCube_ LOL
01:45 IceCube ok if I am migrating the database from the old server to this new one, do I need to have the new database have the same name as the old one or can I import the data into a new database with a new name?
01:45 Francesca joined #koha
01:45 cdickinson joined #koha
01:46 chrisvella joined #koha
01:46 eythian IceCube: the database name isn't really important
01:46 IceCube ok
01:46 eythian so long as it won't try to "USE" the original name
01:46 wizzyrea so you'll need to make the databases match, but it's easy to do by editing the sql dump to match the new name (at least that's how I do it)
01:46 eythian if it does, edit that line out.
01:47 wizzyrea or take it out
01:47 wizzyrea jinx.
01:47 IceCube lol
01:47 IceCube ok
01:47 gmcharlt joined #koha
01:48 * eythian assumes that gmcharlt's library police are really good at issuing fines.
01:50 gmcharlt joy; unexpected reboot
01:51 huginn joined #koha
01:51 wizzyrea oh, linode?
01:51 wahanui i think linode is better/cheaper than slicehost
01:51 wizzyrea I need to send a hazard notice for
01:52 wizzyrea cuz linode is going to reboot it at some point for xen updates
01:52 Francesca oh hello huginns back
01:52 gmcharlt @quote random
01:52 huginn gmcharlt: Quote #273: "rangi: The main thing I came to realise is -- 'Your cataloguing standards are bad, and you should feel bad' - which translates to - 'friends don't let friends use RDA'" (added by wizzyrea at 01:04 AM, August 30, 2013)
01:52 Francesca didn't realise he'd quit
01:53 Francesca @wunder wlg
01:53 huginn Francesca: The current temperature in Wellington, New Zealand is 17.0°C (2:30 PM NZDT on October 20, 2015). Conditions: Clear. Humidity: 52%. Dew Point: 7.0°C. Pressure: 30.01 in 1016 hPa (Steady).
01:53 gmcharlt wizzyrea: whoops, turns out I had completely missed the notification
01:53 wizzyrea haha, was that it
01:54 wizzyrea ?
01:54 wizzyrea I mean, that sucks.
01:56 IceCube ok so now I'm ready to export the old database into the new system
01:56 IceCube Everything seems to be in order so far
01:56 tcohen hi gmcharlt
01:56 gmcharlt hi tcohen
01:57 IceCube what's the best process for doing this
02:04 wizzyrea mysqldump the old database
02:05 wizzyrea edit the dump, if necessary, to get rid of the use database entry if it's wrong
02:05 wizzyrea move it to the new server
02:05 wizzyrea then cat dump.sql | sudo koha-mysql instancename (instancename is the name you gave your instance, if that's unclear)
02:06 wizzyrea then you go to the intranet,
02:06 Francesca joined #koha
02:06 wizzyrea log in with the db creds
02:06 wizzyrea and say "yes, update it"
02:06 wizzyrea profit.
02:07 IceCube ok I'll go ahead and start doing that
02:07 wizzyrea at least, hopefully you profit ^.^
02:07 IceCube haha eventually!
02:26 jcamins Better: koha-upgrade-schema instancename
02:26 jcamins Unless you already started doing it in the web browser, in which case, just deal.
02:27 jcamins (you'll have to use ps to see when the upgrade's finished running)
02:29 tcohen @later tell Joubu this has some answers[…]-June/001690.html we need to move bug 14778
02:29 huginn tcohen: The operation succeeded.
02:32 wizzyrea yeah, koha-upgrade-schema is better and I always forget about it, mostly because my databases get upgraded when I upgrade with the packages
02:32 wizzyrea automagically
02:32 tcohen automagically++
02:34 jcamins Didn't the prince try to sing about that in Monty Python and the Holy Grail?
02:34 jcamins Good night.
02:34 wahanui If you feel like someone is looking through wahanui's window, it's OK, it's just me.
02:36 tcohen night jcamins
02:36 IceCube night
02:45 z0k joined #koha
02:48 eythian wahanui: literal good night
02:48 wahanui eythian: good night =is= <reply>I watch you sleep.|<reply>I'll be waiting for you to come back, $who.|<reply>If you feel like someone is looking through wahanui's window, it's OK, it's just me.|<reply>Don't go, $who. Stay a while. Stay forever.|<reply>sleep tight
02:49 eythian no wahanui, good night is <reply>I watch you sleep.|<reply>I'll be waiting for you to come back, $who.|<reply>Don't go, $who. Stay a while. Stay forever.|<reply>sleep tight
02:49 wahanui okay, eythian.
02:53 tcohen @later tell ribasushi need to talk about thread safe DBIC usage
02:53 huginn tcohen: The operation succeeded.
02:54 * wizzyrea orders tcohen to bed
02:54 wizzyrea shooe
02:54 wizzyrea shoo*
03:01 IceCube_ joined #koha
03:02 tcohen byeeeee
03:11 * eythian does not understand tcohen's "dental plan" reference on the list
03:22 eythian <-- interesting, I wonder if we could use that (a postscript barcode generating library.)
03:33 wizzyrea I think it's a simpsons quote
03:33 wizzyrea as in I think he hears "background tasks" like homer hears dental plan
03:35 eythian I see.
03:36 wizzyrea I didn't get it at first either, as I'm not a religious watcher of the simpsons
03:37 ibeardslee so not someone needing a knuckle sandwich?
03:51 dcook I'm not a religious watcher of The Simpsons, but "dental plan" is a classic :p
03:52 dcook I think tcohen was also the one who showed me:
03:53 eythian that's excellent
03:55 dcook I think there is probably a Simpsons quote or I Heart Huckabees quote for pretty much any situation
03:56 eythian <-- here you go dcook
03:56 dcook I sometimes wonder if meeting you is a good idea, eythian ;)
03:56 eythian heh
03:57 dcook I would've seen your 10 hours and raise you 10 minutes, but that would be the wrong way around...
03:58 eythian why do you need 10 minutes when you have 10 hours?
03:58 dcook Exactly
03:58 dcook Next time someone brings out 10 minutes, I'll bring out that 10 hours
03:58 dcook hard?
03:58 dcook hard is
03:58 dcook hard?
03:58 wahanui hmmm... hard is
04:45 IceCube wizzy, question about something you said earlier
04:45 IceCube if you don't mind
04:46 dcook She might not be around now
04:46 dcook I think it's after 6pm where she is
04:46 dcook What's up?
04:46 dcook Ah after 5pm
04:46 dcook daylight savings caught up..
04:47 IceCube ahh ok
04:48 IceCube well she said that I have to edit the dump (mysqldump) of the old database to get rid of the entry if it's wrong
04:48 IceCube before I migrate it to the new system
04:48 IceCube I'm wondering if that is the line that says "Current Database"
04:58 dcook Alas, I have no idea what you're talking about
04:58 dcook What's wrong with the dump?
04:58 IceCube ok well then I have another question
04:59 IceCube well she said I should change the entry and I _think_ she meant the old name
04:59 IceCube I'm moving it to a new system and the new one has a different name
05:03 dcook You mean a database name?
05:03 IceCube right
05:07 dcook Yeah you might need to go into the sql and change the name
05:07 dcook Let's see if I have a dump around to see...
05:08 dcook Hmm I don't see anything in a normal dump specific to the database
05:09 IceCube What about the line "Current Database"
05:09 dcook I've never heard of a line like that
05:09 dcook Can you copy and paste?
05:09 dcook You can use this link:
05:09 IceCube yep gimme a sec
05:11 Viktor joined #koha
05:12 pastebot "IceCube" at pasted "-- -- Current Database: `name_" (5 lines) at
05:12 IceCube I couldn't get it to cut/past because debian is running in a vm and it won't copy from there into here but I just typed out the line
05:13 IceCube actually I think I can get it to work
05:14 dcook Bi-directional clipboard is awesome for that :D
05:15 dcook That should just be a comment, I believe
05:15 dcook For humans
05:15 pastebot "IceCube" at pasted "-- MySQL dump 10.13 Distrib 5." (22 lines) at
05:15 mario joined #koha
05:16 IceCube there it is
05:16 IceCube oh so the -- is comment?
05:16 dcook Ahhh at the bottom
05:16 dcook Yeah SQL comments are "--" and "/* */"
05:16 IceCube Well that's the top of the file
05:16 IceCube ahhh ok got it
05:16 dcook But at the bottom it does have some real SQL
05:16 IceCube didn't realize they were also --
05:16 dcook CREATE DATABASE /*!32312 IF NOT EXISTS*/ `koha_koha` /*!40100 DEFAULT CHARACTER SET la$
05:16 IceCube yep ok I see it
05:16 dcook That looks really weird though
05:17 dcook How did you do the backup?
05:17 IceCube mysqldump to a file
05:17 dcook What version of MySQL?
05:17 IceCube mysqldump -A > FILENAME.sql
05:17 dcook O_o
05:17 IceCube 5.1.73-1
05:17 dcook Why the -A?
05:17 dcook Wow... 5.1...
05:17 IceCube that's what someone told me to do
05:18 dcook Someone here?
05:18 IceCube I don't think so... I don't see it in the irc log
05:18 dcook Because that's going to dump all databases into that file
05:18 dcook Which I'm guessing is almost certainly not what you want to do
05:18 dcook check out "man mysqldump"
05:19 IceCube Well I need several of them but only one is a koha db
05:19 dcook That'll give you the syntax
05:19 dcook Several of them?
05:19 dcook Koha only needs one
05:19 IceCube we have other things running that use mysql
05:19 dcook Then do them individually I'd say
05:19 IceCube ok
05:19 dcook Or you can edit the SQL that comes out
05:19 dcook But that's liekly to be more error prone I think
05:19 IceCube you're prob right I'll go do it individually
05:30 BobB joined #koha
05:39 * magnuse waves
05:39 * IceCube waves back
05:40 magnuse :-)
05:40 * magnuse needs a reboot
05:41 saiful joined #koha
05:41 magnuse joined #koha
05:42 * magnuse waves again
05:44 dcook yo magnuse
05:46 magnuse hiya dcook
05:46 magnuse time to go? :-)
05:48 magnuse bug 14100 - woohoo!
05:48 huginn Bug[…]_bug.cgi?id=14100 new feature, P5 - low, ---, jonathan.druart, Passed QA , Generic solution for language overlay
05:48 magnuse cait++
05:48 magnuse and Joubu++ of course
05:48 dcook Just about!
05:49 dcook Ooh. I've seen mentions of this.
05:49 dcook What's it about?
05:49 dcook Oooo
05:49 magnuse being able to translate things like authorized values
05:50 magnuse eventually, being able to translate all sorts of strings that are in the db and that until now has only been possible to have in one language
05:58 dcook That would be great :)
05:59 dcook I've recently started working on Android apps for fun
05:59 dcook And I kind of like the way that Java projects seem to do things
05:59 dcook Where in your code or your template you refer to an identifier in a file
05:59 dcook And then you can toggle between different language files
06:00 dcook Although even then I think they run into problems with having strings in a db in one language so an overlay would still be useful..
06:02 cait joined #koha
06:02 magnuse kia ora cait!
06:09 IceCube wellll.... now I'm getting a different error
06:09 IceCube I feel like that is progress going from one error to a different one
06:10 pastebot "IceCube" at pasted "Software error: Can't call met" (6 lines) at
06:10 magnuse IceCube++ for persistence :-)
06:10 IceCube haha
06:10 IceCube thanks magnuse
06:11 dcook It's tough cleaning up a bad mess, but it's worth it!
06:11 dcook I've heard of this error before but I haven't seen it myself I think
06:11 IceCube I know in the end it will be satisfying
06:12 dcook Ahh...
06:12 dcook I'm guessing perhaps your credentials are set up correctly?
06:13 IceCube well I thought they were, they seemed to be working earlier and I haven't changed them
06:32 IceCube I'm really stuck here.  This is annoying.
06:32 IceCube I can log into the database fine
06:33 IceCube it looks like a number of people have experienced this problem and discussed it recently on here
06:33 IceCube I'm looking through to see if anything is helpful
06:35 fridolin joined #koha
06:42 reiveune joined #koha
06:44 fridolin hie there
06:44 IceCube hi
06:45 reiveune hello
06:45 wahanui hola, reiveune
06:54 BobB_ joined #koha
06:56 dcook Sorry, IceCube. Got to go, but I'm sure some of these fine people can help you
06:56 dcook Europe is coming online, while we Oceanic folk go home
06:56 laurence joined #koha
06:57 IceCube well I hope so
06:57 IceCube thanks for your help dcook
06:57 IceCube magnuse?
06:57 wahanui magnuse is afraid that we added another 10000 bugs while he was eating pizza.
06:58 Joubu hi
06:58 IceCube hi Joubu
06:58 IceCube are you a koha guru?
06:58 Viktor joined #koha
06:59 Joubu I don't know, it depends on the area I'd say
06:59 IceCube well I've run into an error the solution to which is eluding me
07:00 alex_a joined #koha
07:00 cdickinson joined #koha
07:01 alex_a bonjour
07:01 wahanui hola, alex_a
07:02 gaetan_B joined #koha
07:02 gaetan_B hello
07:02 Joubu IceCube: what's your error?
07:04 lari joined #koha
07:04 IceCube Can't call method "do" on unblessed reference at /usr/share/koha/lib/C4/ line 794. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/ line 89. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/ line 25. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/ line 25.
07:05 Joubu your db is not reachable, either your credentials are wrong, or the server is down
07:05 Joubu or a lot of other possibilities
07:05 IceCube yeah... trying to figure out those possibilities!
07:06 IceCube server isn't down, I'm on it now
07:06 Joubu what about the credentials?
07:07 Joubu What's your Koha version?
07:08 IceCube latest
07:08 IceCube Just installed today
07:08 IceCube the creds... ok well it was working earlier and then I imported the data from a mysqldump from an old koha server and since then I've gotten this error
07:10 IceCube I set up a new server with the latest debian and koha and wanted to migrate the old database into it from the old server
07:10 IceCube does that make sense?
07:11 Joubu mysql or mariadb? if mysql, which version are you using?
07:11 IceCube mysql
07:11 Joubu Do you have another error before the "can't call do on unblessed ref"?
07:12 IceCube mysql 14.14
07:12 IceCube no that's what I get when I point my browser to the site
07:12 Joubu mysql 14.14?
07:13 IceCube mysql Ver 14.14 Distrib 5.5.44 for debian-linux-gnu ...
07:13 Joubu check in the Koha log files, you could have another error
07:13 IceCube I should mention I'm not a linux guy or a koha guy.  I've done windows tech support for a long time so I'm not afraid to try things, I just don't know what to try
07:14 Joubu try the Koha logs :)
07:14 Joubu tail -f /var/log/koha/$instance/*.log # replace $instance
07:14 Joubu then reload the page
07:15 IceCube yep it says the same thing in there
07:16 IceCube also name-koha-zebra: client killed by signal 15, stopping
07:18 Joubu nothing else before? :)
07:18 andreashm joined #koha
07:19 Joubu Something like "Can't connect to mysql server"?
07:19 IceCube hold on let me output it to a file
07:20 Joubu could you edit C4/ and give me what is your line 794?
07:20 IceCube sure gimme a sec
07:20 * andreashm waves
07:21 fridolin congratulations to Lyon3 Univ Team for Bug 8236
07:21 huginn Bug[…]w_bug.cgi?id=8236 enhancement, P5 - low, ---, koha, Pushed to Master , Prevent renewing if overdue or restriction
07:22 fridolin in master at laaaaaaaaaaast
07:22 magnuse yay!
07:22 fridolin :D
07:22 magnuse and tjänare andreashm
07:23 Joubu fridolin: do you know how dublin core export works in Koha?
07:23 andreashm magnuse: hej!
07:25 sophie_m joined #koha
07:26 pastebot "IceCube" at pasted "==> /var/log/koha/olgs/intrane" (34 lines) at
07:26 IceCube Joubu there's the logs
07:26 Joubu so you have it :)
07:26 fridolin Joubu: it uses MARC::Crosswalk::DublinCore
07:26 Joubu IceCube: Access denied for user 'koha_olgs'@'localhost' (using password: YES)
07:26 Joubu your credentials are wrong
07:27 IceCube sigh ok any idea how to make them right?
07:27 IceCube I could access the page before importing the db
07:27 Joubu fridolin: yes I know, but do you know what kind of file (format, data, etc.) is expected on exporting a unimarc record?
07:27 Joubu edit $KOHA_CONF
07:28 IceCube ok
07:29 fridolin Joubu: mmmm no idea
07:29 IceCube I found that user.  It's some random default password
07:29 Joubu IceCube: locate a koha-conf.xml file (which is defined by $KOHA_CONF), in it you have a config section
07:29 Joubu with database/hostname/user/pass
07:30 IceCube yep I'm there
07:30 Joubu update these info to fit your needs :)
07:34 IceCube ok done.  I got the login screen.  I logged in and received this error: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.20/ line 2064.
07:35 paul_p joined #koha
07:36 Joubu IceCube: I am not sure what you did, but it's not normal to get all these errors
07:37 Joubu you should try a fresh install on a fresh server, using the packages
07:38 IceCube That's what this is
07:39 IceCube I installed everything from scratch today on a VM and it was working fine until I imported the old database
07:39 Joubu no, the credentials were wrong, so you didn't install Koha correctly
07:39 IceCube If I do it over the same thing will just happen, I think.
07:40 magnuse IceCube: you should have got a upgrade screen after you imported the old database and logged in
07:40 IceCube Well when I logged in the first time to the site with the browser it let me
07:40 IceCube I imported the db and was then not able to log in to see the upgrade screen
07:40 magnuse what user were you trying to log in as?
07:41 IceCube I logged in as the koha_olgs on via the browser with the password that was in the koha-conf.xml file and that worked.
07:41 IceCube before importing the db
07:41 magnuse and that should work after importing the db too
07:41 IceCube but it didn't :(
07:41 Joubu magnuse: it's not on the same server
07:42 IceCube it is
07:42 Joubu IceCube: but the credentials in your koha-conf.xml file was wrong, and that's quite weird :)
07:42 IceCube well wrong compared to what, I guess.  Are there credentials in the imported db?
07:43 IceCube I know these are prob noob questions but this is new territory
07:43 Joubu no, only in this config file
07:43 IceCube I apologize
07:44 magnuse no worries, we like to help :-)
07:44 IceCube I'm just going to uninstalland try again I think.  This is ridiculous.
07:44 IceCube I really appreciate all your guys' help
07:44 IceCube I must have made a mistake somewhere
07:45 IceCube I really don't know what that would be, though.  I was careful to follow the guide and the advice of wizzyrea and dcook
07:46 magnuse let me see if i got the facts right: you got an old sql dump from an old koha on an old server. then you did a fresh install of current koha on a fresh vm. after running koha-create you could log in to the instance with the username and password from koha-conf.xml. then you loaded the old sql dump into the fresh database with something like "sudo koha-mysql <instance> < dump.sql" and after that you could not log in with the username and password from koha-con
07:46 magnuse f.xml?
07:47 IceCube exactly
07:49 saiful joined #koha
07:49 magnuse the username and password from koha-conf.xml should work the same, no matter what you loaded into the database, so there is something weird going on
07:49 IceCube ok one possibility
07:49 wahanui one possibility is that my vhost definitions are listening on the external interface but not the internal one
07:50 IceCube I imported the database using a different mysql username - would that matter?
07:50 magnuse a different username for the same database?
07:51 IceCube I had to provide credentials to import it
07:51 Joubu IceCube: the error you got was " Access denied for user 'koha_olgs'@'localhost'"
07:51 IceCube I think I used a different uername
07:51 IceCube right
07:51 Joubu it seems there is a typo...
07:52 Joubu ok is it olgs?
07:52 IceCube I thiiiiinnkk I used root
07:52 Joubu So you have to give rights to this user
07:53 IceCube well I already deleted everything
07:53 IceCube This has been going on for almost 11 hours now
07:53 IceCube I am thinking of my favorite word: defenestration.
07:54 IceCube :)
07:57 IceCube except it's a vm so that makes that impossible
08:04 magnuse when you have a new instance, make sure you can log in with the username/password from koha-conf.xml. then load the dump with "sudo koha-mysql <instance> < dump.sql" and make sure you can still log in with the username/password from koha-conf.xml
08:06 IceCube ok
08:08 magnuse if the name of the database is different in the old and the new server, you might have to edit the start of the sql dump file
08:08 magnuse did you do that
08:08 magnuse ?
08:08 IceCube yep
08:08 magnuse it depends on how the dump was created, i think
08:08 magnuse ah, cool
08:09 IceCube wt* now apache won't start
08:11 Viktor joined #koha
08:13 IceCube ok it started
08:15 sophie_m joined #koha
08:32 andreashm magnuse: what happened to SemantiKoha? I tried looking for it on your site but could find it. (but Google was my friend of course)
08:35 IceCube so now when I do "koha-create --create-db dbname" I get the error "user dbname-koha already exists"
08:36 IceCube I'm sure I just have to delete it somewhere but can't figure out where
08:37 IceCube nm got that figured out
08:37 Viktor joined #koha
08:39 saiful2 joined #koha
08:43 drojf joined #koha
08:43 drojf hi #koha
08:43 andreashm hi drojf!
08:43 drojf hi andreashm
08:53 janPasi__ joined #koha
09:23 magnuse andreashm: i ran out of time
09:23 magnuse maybe next year?
09:29 andreashm magnuse: cool. but the idea is to use a triple-store outside of Koha? I though you wanted to have more semantic capabilites _within_ Koha.
09:30 andreashm ?
09:31 * andreashm is of for lunch, and then meeting. bbl.
09:31 reiveune left #koha
09:34 reiveune joined #koha
09:45 magnuse andreashm_away: well, the triplestore would be outside koha in the same way that mysql is outside koha. and yes, the end goal would definitely be to integrate all the tools necessary inside koha to provide a superb end user experience based on rdf
09:46 magnuse lunch? yeah!
10:13 reiveune joined #koha
10:33 andreashm joined #koha
10:33 * andreashm waves'
10:36 andreashm magnuse: (picking up on your last comment) so the idea is to add a triple-store to Koha?
10:37 andreashm what else is needed to provide RDF support for Koha? Mappings to Marc, the ability to add Thesauri etc?
10:39 andreashm I guess Tomás bug 14645 is also needed?
10:39 huginn Bug[…]_bug.cgi?id=14645 enhancement, P5 - low, ---, tomascohen, ASSIGNED , Koha::RecordProcessor should deal with Koha::MetadataRecord objects
10:42 saiful joined #koha
10:58 irma joined #koha
11:14 alex_a joined #koha
11:24 magnuse andreashm: there are several ways to do it. my idea is first to keep marc, but transform marc to rdf (with e.g. and build better end user services on that. then we can start to talk about cataloguing in rdf and getting rid of marc
11:27 andreashm magnuse: sounds like a good plan. but it is also a good idea to allow ingestion of rdf directly (in Sweden we have LIBRIS cataloging in RDF for instance).
11:27 magnuse "Alone you go faster, together we go further" #kohacon15[…]56419531905200128
11:27 magnuse sure!
11:38 saiful joined #koha
11:43 andreashm magnuse: it is also something we could get funding for (hint, hint). =) so what would you think is needed more than adding a triple-store for Koha to be able to harvest records from LIBRIS (if we also develop the harvester to handle RDF)? Any ideas?
11:43 wahanui okay, andreashm.
11:44 andreashm (Leaving all the fun stuff for later, like enriching the OPAC)
11:51 andreashm (The OAI-PMH harvester, that is)
11:55 meliss joined #koha
12:12 Callender joined #koha
12:17 tcohen joined #koha
12:19 magnuse andreashm: well, if you are already getting rdf from somewhere else, i would say enriching the opac is the next step - to show some practical use
12:19 tcohen morning
12:19 dojobo magnuse, very cool ideas
12:20 tcohen andreashm: did you re-try the plack server? :-D
12:20 tcohen Joubu: did u see my message?
12:20 tcohen hi #koha
12:20 dojobo hello
12:20 wahanui que tal, dojobo
12:21 tcohen dojobo?
12:21 magnuse hiya tcohen and dojobo
12:22 dojobo tcohen, magnuse was discussing the idea of implementing linked data in koha
12:22 tcohen who are you dojobo?
12:23 dojobo uh, my name is Dominic, i work at an astronomical library
12:24 dojobo magnuse what kind of (R)DBMS do you use for a triple store?
12:32 Joubu tcohen: yep, finishing my lunch and I am back
12:35 magnuse not a dbms, but an actual triplestore. i have played with a really simple one which is just one php file, called ARC2. also one that is a beast to configure that i can't remember the name of
12:35 magnuse it's been a while since i looked, there might be better alternatives now
12:35 tcohen your patches for bug 14778 fix the problems with MySQL connection drops
12:35 huginn Bug[…]_bug.cgi?id=14778 normal, P5 - low, ---, jonathan.druart, ASSIGNED , DBIC should create/own the DB handler
12:37 tcohen Joubu: import is incredibly slow now, but doesn't break the app
12:37 magnuse ah, virtuoso
12:39 dojobo[…]-object_databases
12:39 dojobo i know DPLA (digital public library of america) is using apache marmotta
12:41 Joubu tcohen: back
12:43 dojobo magnuse have you looked at bibframe at all?
12:43 dojobo it's an initiative to do linked data with library catalogs
12:45 tcohen @seen marcelr
12:45 huginn tcohen: marcelr was last seen in #koha 1 day, 6 hours, 8 minutes, and 56 seconds ago: <marcelr> hi #koha
12:45 dojobo i'm not sure it provides much technical help yet though, it might be more oriented towards RDF vocabularies and such
12:45 tcohen @later tell marcelr come back
12:45 huginn tcohen: The operation succeeded.
12:46 dojobo looks like they do have a marcxml -> rdf transformation tool though
12:47 dojobo
12:47 Dyrcona joined #koha
12:47 magnuse dojobo: i have not looked at it, but i think it is too early to decide on anything, and i think it has been critized for creating another library gettho, without building on things others have already done
12:55 edveal joined #koha
12:55 drojf1 joined #koha
13:00 dojobo magnuse: yeah, even the website has "use cases" with no link, and MARC mapping says "coming soon" :P
13:05 Dyrcona joined #koha
13:11 * andreashm was away, but now stumbles back
13:11 andreashm the problem of going out to get some coffee and end up talking to co-workers for a long time. =)
13:12 NateC joined #koha
13:12 andreashm magnuse: yes, showing some practical use is good - but first we need to have circulation and so forth working with the imported RDF
13:12 andreashm tcohen: no, haven't had time today. might look around a little now though.
13:14 magnuse andreashm: yeah, that is why i prefer to transform marc2rdf, and use the rdf to build cool things while circ etc still works with the marc data
13:14 magnuse one notch less radical than deichman :-)
13:15 andreashm hehe
13:16 andreashm well, our perspective is how we can get Koha to work better with LIBRIS XL - which would probably be better of not converting the data to Marc.
13:16 andreashm But items shouldn't be a problem really as that is not Marc, but separate tables in the database?
13:16 magnuse i have a serial set to create items on receiving, but when i get to the item detail for no barcode ($y) is generated when i click in the barcode field. anyone else seen that?
13:17 magnuse andreashm: yeah, maybe :-)
13:17 magnuse but ripping marc out of koha and replacing it with rdf is going to be a huge thing
13:17 magnuse much easier if you can dumb the rdf down to (very, very) minimal marc records that koha can chew on
13:18 magnuse s/item detail for/item detail form/
13:18 JoshB joined #koha
13:21 andreashm magnuse: so keep RDF for OPAC (and perhaps staff?) for fun stuff, and at the same time create slim marc record for circulation etc.?
13:21 magnuse andreashm: yup. not perfect, but doable, i think
13:22 andreashm since my perspective is the staff interface (we don't use the OPAC) - how will that be affected by your idea?
13:24 andreashm also, I'm considering how such an approach would impact the harvesting of records.
13:24 andreashm but I kind of like the thought. =)
13:28 magnuse so far, i have only thought about the opac :-)
13:29 magnuse but yeah, transform rdf to minimal marc and store that in koha so items and issues etc can hang off them
13:31 magnuse then use circ etc as normal
13:32 magnuse i guess browsing and searching in the staff client could also be enhanced with rdf data, to make it easier for staff to help patrons
13:32 magnuse but the real interesting thing about rdf to me is the possibility to create meaningful connections between things, thus enhancing discovery
13:36 * magnuse wanders off to make dinner
13:39 cma joined #koha
13:52 rocio joined #koha
13:57 Joubu my 10£ ikea standing desk have just fallen down :-/
13:57 amyk joined #koha
14:03 rocio1 joined #koha
14:03 huginn New commit(s) kohagit: Bug 8236: (QA followup) fix test count error due to bad merge <[…]c82122607bcade2b5> / Bug 11759: DBRev <[…]854fd1da075e7ed63> / Bug 11759: (QA followup) Sysprefs should be kosher <[…]a=commitdiff;h=2f
14:23 hbraum joined #koha
14:24 cbrannon joined #koha
14:29 cbrannon Would love it if someone could run 14694 and 11565 through QA.  :)
14:32 talljoy joined #koha
14:40 rocio joined #koha
14:47 tcohen jajm: could you take a look at 14674 please?
14:48 tcohen bug 14694
14:48 huginn Bug[…]_bug.cgi?id=14694 enhancement, P5 - low, ---, kyle.m.hall, Signed Off , Make decreaseloanHighHolds more flexible
14:48 tcohen bug 11565
14:48 huginn Bug[…]_bug.cgi?id=11565 enhancement, P5 - low, ---, kyle, Signed Off , decreaseLoanHighHolds needs Override
14:52 jajm tcohen, sure
14:53 tcohen jajm: might be blocker for the 'attach files' functionality
14:53 tcohen i mean, I consider it blocker
15:00 magnuse Joubu: blame andreashm ;-)
15:00 * Joubu is blaming andreashm
15:00 Joubu magnuse: why? :)
15:03 Joubu bug 14778 is ready for testing (cc ashimema :))
15:03 huginn Bug[…]_bug.cgi?id=14778 normal, P5 - low, ---, jonathan.druart, ASSIGNED , DBIC should create/own the DB handler
15:03 ashimema :)
15:03 ashimema will try to take a look this evening..
15:03 ashimema thanks Joubu++
15:04 TGoat joined #koha
15:05 cait joined #koha
15:06 cait Joubu: around?
15:06 fridolin left #koha
15:07 Joubu cait: yep
15:07 cait internet connection is really bad
15:07 Joubu If it's not for patching tests, I can help
15:07 cait i just uploaded 8436 (managed barely)
15:07 cait i am gulty of writing 2 follow ups
15:07 cait could you take a look?
15:08 cait i blame too much time on trains....
15:10 * cait moves on to messing up the next bug
15:19 tcohen bug 8436
15:19 huginn Bug[…]w_bug.cgi?id=8436 enhancement, P5 - low, ---, julian.maurice, Signed Off , Add branch limit on
15:21 cait joined #koha
15:21 cait @wunder Konstanz
15:22 huginn cait: The current temperature in Konstanz, Germany is 11.0°C (5:00 PM CEST on October 20, 2015). Conditions: Scattered Clouds. Humidity: 48%. Dew Point: 4.0°C. Pressure: 30.16 in 1021 hPa (Falling).
15:22 reiveune bye
15:22 cait Joubu: sorry, lost connection
15:22 reiveune left #koha
15:22 Joubu cait: i haven't answered anything :)
15:22 cait too shocked? :P
15:22 Joubu I am doing dozen of things at the same time, I don't think I will have a look today
15:22 cait that's alright
15:23 cait i understand,maybe julian can take a look
15:23 cait i could have failed it... but then ended up fixing it
15:23 cait at least i hope it's fixing :)
15:28 * tcohen strongly belives we shouldn't be pushing stuff between 23:00 and 23:59 (bug 15029)
15:28 huginn Bug[…]_bug.cgi?id=15029 major, P5 - low, ---, jonathan.druart, Signed Off , Tests fail if launched after 23:00
15:33 cait tcohen: sonds like a good rule
15:33 * cait waves at tcohen from the train
15:33 cait looking at 8296 now
15:34 tcohen hi cait!
15:36 pianohacker joined #koha
15:36 cait :)
15:36 pianohacker :)
15:38 hbraum joined #koha
15:51 edveal joined #koha
16:06 cait left #koha
16:06 Joubu bye #koha
16:18 laurence left #koha
16:42 pianohacker ashimema: around?
16:59 barton joined #koha
17:20 saiful joined #koha
17:34 z0k joined #koha
17:36 sophie_m joined #koha
17:36 xarragon_ If I need to store something like a list of key-value pairs, is that suitable for a syspref?
17:38 pianohacker xarragon_: there's some precedent for that, see UpdateNotForLoanStatusOnCheckin
17:40 xarragon_ pianohacker: Ok, great! thanks
17:42 xarragon_ pianohacker: Ah, yeah, multiline edit box will work fine. I forgot you could use them. Single-line would be cumbersome as it is a list of potentially long URLs. Thanks agaiN!
17:44 xarragon_ sophie_m:
17:45 xarragon_ Sorry, mis-pressed ^^
18:00 ibeardslee joined #koha
18:16 tcohen is there a Template::Toolkit function for lowercase text?
18:19 Techservspec joined #koha
18:19 tcohen FILTER lower
18:25 tcohen wizzyrea: ?
18:25 tcohen @wunder wellington
18:25 huginn tcohen: Error: No such location could be found.
18:28 huginn New commit(s) kohagit: Bug 14676: (QA followup) Fix case problems carried from the past <[…]4a64a04d7998898fb> / Bug 14676: (QA followup) Make title, breadcrumbs and labels consistent <[…]20d9c91651bd98fd1> / Bug 14676: (QA followup) remove useless file <http:/
18:38 huginn New commit(s) kohagit: Translation files update <[…]5038f484c531836bd>
18:46 tcohen later #koha
18:50 mveron-away joined #koha
19:01 tcohen joined #koha
19:09 rocio joined #koha
19:41 andreashm joined #koha
19:41 * andreashm waves
19:42 markvandenborre joined #koha
19:44 tcohen joined #koha
19:44 andreashm hi tcohen
19:45 andreashm I'm trying to test again but keep getting session time-outs - sometimes after only a few seconds (the first thing I click on even)
19:46 tcohen andreashm: that's new :-/
19:48 andreashm I thought it was a bad internet connection on the train home, but it's the same here. I tried different log-ins and browsers
19:52 tcohen andreashm: i disabled SessionRestrictionByIP and am trying
19:53 tcohen i'm not kicked out anymore
19:53 tcohen andreashm: can u try?
19:54 pianohacker what sessionstorage are we using, tcohen?
19:54 tcohen it was mysql
19:54 tcohen it is memcached now
19:54 pianohacker is that generally more reliable? I thought they were all mostly equivalent
19:55 tcohen maybe i should leave mysql
19:57 tcohen ok, setting to mysql made it kick me out
20:03 pianohacker wtf?
20:03 pianohacker oh, no, that makes sense I guess
20:10 andreashm joined #koha
20:11 andreashm Tcohen: It seems to work now.
20:14 andreashm My daughter was crying in her sleep, so I had to go check on her and got logged out of IRC.
20:16 wizzyrea hi sorry what?
20:17 northcottc joined #koha
20:18 wizzyrea interesting, wonder if that's the thing the guy on the list was seeing, that mysql session storage caused weird timeouts
20:19 cait joined #koha
20:19 * cait waves
20:24 hbraum joined #koha
20:24 hbraum tcohen andreashm just saw your comments about the timeouts; I saw the same earlier. glad it wasn’t just me.
20:25 pianohacker hbraum: tcohen's fix work for you?
20:26 hbraum pianohacker: I haven’t been back in to check; still trying to get a ticket audit done :) will check again in a bit.
20:26 pianohacker kk cool
21:15 hbraum pianohacker plack system no longer timing out on me so yes fix worked
21:15 cait hbraum++ :)
21:15 pianohacker woot!
21:15 pianohacker tcohen++
21:15 pianohacker hbraum++
21:17 cait pianohacker++ too[…]ki/Roles_for_3.24
21:18 hbraum but staging/importing records still isn’t working as expected. staging bug[…]_bug.cgi?id=15032
21:18 huginn Bug 15032: major, P5 - low, ---, gmcharlt, In Discussion , Plack testing -- Stage MARC records for import -- Internal Server Error/Stalled Staged Import
21:20 pianohacker cait: All of admin will be pretty
21:20 pianohacker ALL OF IT
21:20 hbraum and i got another internal server error when trying to import a staged record batch — file another bug report? Or reopen 15034 that tomas had marked as duplicate of 14778? I’m a little confused on how/where to file these for the plack testing.
21:21 cait pianohacker: are patches on the rancor bug now the latest?
21:21 pianohacker hbraum: I'd say attach it to bug 15032
21:21 huginn Bug[…]_bug.cgi?id=15032 major, P5 - low, ---, gmcharlt, In Discussion , Plack testing -- Stage MARC records for import -- Internal Server Error/Stalled Staged Import
21:21 hbraum will do thanks pianohacker
21:22 cait pianohacker: not sure rewriting it from scratch was the idea for maintainers :P
21:22 eythian hi
21:22 cait morning eythian :)
21:22 pianohacker cait: ?
21:22 pianohacker (to your second question)
21:22 pianohacker I had to rebase the patches
21:23 cait i am still owing you a proof read
21:23 cait just been travelling too much :(
21:23 pianohacker the patches on the bug are the latest, yes :)
21:24 cait ok
21:24 pianohacker oh! I see what you mean
21:24 pianohacker I won't rewrite it from scratch... just make it pretty :)
21:26 pianohacker cait: and if you want to view the code in a different format, bz11559 on my github is up to date
21:26 cait not tonight probably, but still trying
21:26 pianohacker no worries
21:26 cait trying to finish some things i started on the train
21:30 hbraum cait: I’m trying to continue to test some of the upload features for Plack to see if anything fails; here’s where I know of upload areas: 1) staging marc records 2) patron import 3) image for biblio record 4) barcode files for batch edit & delete 5) exporting record data 6) deleted biblios 7) uploading files to patron record. Is there anything I missed?
21:30 cait hm patron image upload maybe?
21:31 hbraum ty!
21:31 cait from the patron record and with the batch tool
21:31 cait oh and inventory
21:31 cait and the batch edit/delete
21:31 cait tools
21:31 hbraum yep got batch edit/delete on my list to check.
21:31 hbraum tyvm
21:31 cait ah sorry, missed that
21:31 cait long list :)
21:31 hbraum no worries; yes it is.
21:33 * cait sighs looking at the list of enh and new features in qa queue
21:33 cait long list
21:33 Francesca joined #koha
21:34 * pianohacker whispers "raaaaaancooooor"
21:35 cait yeah that too
21:35 cait and that's not even in the list
21:37 * Francesca waves
21:38 * cait waves back
21:42 cdickinson joined #koha
21:51 rocio left #koha
22:09 papa joined #koha
22:21 cait eythian: did you see 14778?
22:22 eythian bug 14778
22:22 wahanui bug 14778 is ready for testing (cc ashimema :))
22:22 huginn Bug[…]_bug.cgi?id=14778 major, P5 - low, ---, jonathan.druart, Needs Signoff , DBIC should create/own the DB handler
22:22 eythian should I have?
22:22 cait the last comment is for you i think
22:22 cait just reading today's bug mails
22:22 eythian oh right
22:26 hbraum thx cait for the help on the upload testing list; filed two more patches in the process of my plack testing.
22:27 cait wish you hadn#t found so many things... but glad they are found the same time :)
22:27 hbraum i hate it, too, but…. better found than not found! what i’m finding may in the end be unrelated to plack — but not assuming anything at this point.
22:28 cait thx a lot for your testing
22:28 cait super helpful
22:29 hbraum you’re welcome. :) i put our test server through these paces before every major version upgrade. this stuff I can do. And I want Plack to work!
22:29 hbraum i’m headed out shortly. will try to coninue test a bit more tomorrow. have a great/day/evening all.
22:35 cait @later tell hbraum thought of another one - uploading invoice files in acq
22:35 huginn cait: The operation succeeded.
22:39 tcohen joined #koha
22:40 tcohen hi
22:40 wahanui hi, tcohen
22:41 tcohen hey wahanui
22:46 Francesca wahanui cats
22:46 wahanui cats are endlessly entertaining. or cuddly and cute
22:46 Francesca @wunder wlg
22:46 huginn Francesca: The current temperature in Wellington, New Zealand is 17.0°C (11:30 AM NZDT on October 21, 2015). Conditions: Clear. Humidity: 55%. Dew Point: 8.0°C. Pressure: 29.89 in 1012 hPa (Falling).
22:54 eythian no wahanui, cats is <reply>The only good cat is a stir-fried cat.
22:54 kathryn joined #koha
22:54 pianohacker what!
22:54 Francesca what????
22:54 kathryn joined #koha
22:54 pianohacker hey now, you're saying bad things about cats around _librarians_
22:55 pianohacker dangerous business
22:55 Francesca glad someone agrees with me
22:55 Francesca cats are cute
22:55 eythian <-- I feel like you need more culture
22:55 Francesca ok
22:56 wizzyrea lol alf.
22:56 Francesca not sure what I just read but ok
22:56 wizzyrea
22:57 eythian what sort of person doesn't know about Alf?
22:57 Francesca ah lol
22:57 pianohacker it's something from before we were born, Francesca
22:57 Francesca hahahaha
22:57 ibeardslee oh right yes, Francesca is a youngun
22:57 pianohacker just smile and nod until the old people go away
22:57 Francesca lol
22:57 wizzyrea RUDE.
22:57 eythian that's no excuse. I know about the moon landing and the roman empire.
22:57 wizzyrea ^^^
22:58 pianohacker and alf is of the same magnitude? ;)
22:58 Francesca I know about the roman empire - took classics
22:58 eythian pianohacker: yes.
22:58 pianohacker hahahaha okay
22:58 Francesca lol
22:58 tcohen cats are like robots
22:58 wizzyrea the trolling is strong today.
22:58 * tcohen loves them
22:58 Francesca hahaha
22:59 * Francesca is also a cat person
22:59 Francesca tcohen how is a cat like a robot?
22:59 cait both are cool?
22:59 kathryn joined #koha
22:59 cait ok, time to sleep
23:00 tcohen they only want food, if you think about it
23:00 tcohen it is pretty clear
23:00 kathryn night cait :)
23:00 tcohen they have no feelings
23:00 cait :)
23:00 cait night all
23:00 wahanui goodnight cait. You'll be back.
23:00 tcohen we want them to have them, but they don't
23:00 kathryn hi tcohen :)
23:00 Francesca bye cair
23:00 Francesca cait
23:00 tcohen bye cait
23:00 eythian later cait
23:00 kathryn and hi francesca :)
23:00 Francesca sup
23:00 kathryn and all. there!
23:01 tcohen if they had bigger claws, they would just rip our heads of
23:01 tcohen f
23:01 Francesca hahahaha
23:01 cait um thx for the picture
23:01 cait ... now i probably can't sleep!
23:01 tcohen heh, keep one eye open cait
23:01 pianohacker </trolling>never really watched or heard much about alf... parents were into different 80s shows like mork and mindy or night court
23:02 kathryn hi pianohacker :)
23:02 pianohacker hi kathryn :)
23:02 Francesca so pianohacker - hows the piano hacking going?
23:03 pianohacker Francesca: excellently! Doing a lot of Hanon :P
23:03 ibeardslee oh, if Francesca took classics she really should know about Alf.  It is a classic.
23:04 eythian ^^^
23:05 * Francesca facepalms
23:05 wahanui rumour has it facepalms is a tiny member of the Arecaceae family whose preference for warm, humid environments makes it a perfect choice for cultivation in the human nasal cavity
23:06 pianohacker haha wtf wahanui
23:06 Francesca it gets better
23:06 Francesca wahanui literal facepalm
23:06 wahanui Francesca: facepalm =is= <reply>http://buikitty.files.wordpres[…]120202-094434.jpg|a tiny member of the Arecaceae family whose preference for warm, humid environments makes it a perfect choice for cultivation in the human nasal cavity.|<reply>[…]5ibpuFO/giphy.gif
23:06 pianohacker wow
23:07 Francesca ohh theres a start trek one there now
23:07 Francesca cool
23:07 pianohacker are we calling alf a classic like Asimov, or a classic like Star Wars?
23:07 eythian you understand that star trek is older than alf, right?
23:07 pianohacker clearly this must be debated to death
23:07 pianohacker :)
23:07 Francesca mum likes star trek
23:07 Francesca and so does dad
23:07 Francesca so I was exposed as a little kid
23:08 Francesca dont think anyone in the family watches alf
23:08 pianohacker ^ same
23:09 tcohen wahanui: plack issues?
23:09 wahanui hmmm... plack issues is[…]5ibpuFO/giphy.gif
23:09 Francesca hahahaha
23:10 pianohacker can we make plack issues return a gif of "ludicrous speed" 90% of the time and that gif 10% of the time?
23:10 Francesca lol
23:11 tcohen LOL
23:14 eythian wahanui: llama is
23:14 wahanui OK, eythian.
23:14 pianohacker wahanui: plack issues is also
23:14 wahanui okay, pianohacker.
23:16 Francesca joined #koha
23:16 wizzyrea < also for plack
23:18 pianohacker ha! Yes.
23:22 pianohacker good night all :)
23:23 Francesca joined #koha
23:33 Francesca joined #koha
23:41 JoshB joined #koha
23:57 tcohen joined #koha

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