Time Nick Message 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 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 http://wiki.koha-community.org/wiki/Koha_on_Debian 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 http://irc.koha-community.org/irclog/koha/ 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 http://25.media.tumblr.com/tumblr_lpm3j6aNaN1qh8hleo1_400.gif 01:39 wizzyrea A+ confetti-ing 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: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:48 * eythian assumes that gmcharlt's library police are really good at issuing fines. 01:50 gmcharlt joy; unexpected reboot 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 k-c.org 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 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 http://lists.scsys.co.uk/pipermail/dbix-class/2006-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: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:02 tcohen byeeeee 03:11 * eythian does not understand tcohen's "dental plan" reference on the list 03:22 eythian http://bwipp.terryburton.co.uk/ <-- 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 https://www.youtube.com/watch?v=4OD9_HOjrVg 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: https://www.youtube.com/watch?v=I94w30LszoQ 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 https://www.youtube.com/watch?v=epIT4-gF__M <-- 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... https://www.youtube.com/watch?v=Pg_ArW8lrl0 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 https://www.youtube.com/watch?v=Pg_ArW8lrl0 03:58 dcook hard? 03:58 wahanui hmmm... hard is https://www.youtube.com/watch?v=Pg_ArW8lrl0 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: http://paste.koha-community.org/ 05:09 IceCube yep gimme a sec 05:12 pastebot "IceCube" at 127.0.0.1 pasted "-- -- Current Database: `name_" (5 lines) at http://paste.koha-community.org/111 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 127.0.0.1 pasted "-- MySQL dump 10.13 Distrib 5." (22 lines) at http://paste.koha-community.org/112 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:39 * magnuse waves 05:39 * IceCube waves back 05:40 magnuse :-) 05:40 * magnuse needs a reboot 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 04Bug http://bugs.koha-community.org/bugzilla3/show_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 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 127.0.0.1 pasted "Software error: Can't call met" (6 lines) at http://paste.koha-community.org/113 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:44 fridolin hie there 06:44 IceCube hi 06:45 reiveune hello 06:45 wahanui hola, reiveune 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: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: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:01 alex_a bonjour 07:01 wahanui hola, alex_a 07:02 gaetan_B hello 07:02 Joubu IceCube: what's your error? 07:04 IceCube Can't call method "do" on unblessed reference at /usr/share/koha/lib/C4/Context.pm line 794. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 89. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl 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: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/Context.pm 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 04Bug http://bugs.koha-community.org/bugzilla3/show_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:26 pastebot "IceCube" at 127.0.0.1 pasted "==> /var/log/koha/olgs/intrane" (34 lines) at http://paste.koha-community.org/114 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/DBI.pm line 2064. 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 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:13 IceCube ok it started 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:43 drojf hi #koha 08:43 andreashm hi drojf! 08:43 drojf hi andreashm 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: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: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 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14645 enhancement, P5 - low, ---, tomascohen, ASSIGNED , Koha::RecordProcessor should deal with Koha::MetadataRecord objects 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. https://github.com/digibib/marc2rdf) 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 https://twitter.com/ranginui/status/656419531905200128 11:27 magnuse sure! 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) 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 04Bug http://bugs.koha-community.org/bugzilla3/show_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 https://en.wikipedia.org/wiki/List_of_subject-predicate-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 http://www.loc.gov/bibframe/ 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 13:00 dojobo magnuse: yeah, even the website has "use cases" with no link, and MARC mapping says "coming soon" :P 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 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: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:57 Joubu my 10£ ikea standing desk have just fallen down :-/ 14:03 huginn New commit(s) kohagit: Bug 8236: (QA followup) fix test count error due to bad merge <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=0dfa8c2b67792b86f054b32c82122607bcade2b5> / Bug 11759: DBRev 3.21.00.038 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ac9f9ced724fd61403650c5854fd1da075e7ed63> / Bug 11759: (QA followup) Sysprefs should be kosher <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=2f 14:29 cbrannon Would love it if someone could run 14694 and 11565 through QA. :) 14:47 tcohen jajm: could you take a look at 14674 please? 14:48 tcohen bug 14694 14:48 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14694 enhancement, P5 - low, ---, kyle.m.hall, Signed Off , Make decreaseloanHighHolds more flexible 14:48 tcohen bug 11565 14:48 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_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 04Bug http://bugs.koha-community.org/bugzilla3/show_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:06 cait Joubu: around? 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 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8436 enhancement, P5 - low, ---, julian.maurice, Signed Off , Add branch limit on checkexpiration.pl 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 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 04Bug http://bugs.koha-community.org/bugzilla3/show_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 cait :) 15:36 pianohacker :) 16:06 Joubu bye #koha 16:42 pianohacker ashimema: around? 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:16 tcohen is there a Template::Toolkit function for lowercase text? 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 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3aafdf91b0e725d65e44c8f4a64a04d7998898fb> / Bug 14676: (QA followup) Make title, breadcrumbs and labels consistent <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5d23b55e0accaef7de974ed20d9c91651bd98fd1> / Bug 14676: (QA followup) remove useless patroncards-menu.inc file <http:/ 18:38 huginn New commit(s) kohagit: Translation files update <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9a5b6528fdbbd9f1764b1875038f484c531836bd> 18:46 tcohen later #koha 19:41 * andreashm waves 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: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: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 waves 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 http://wiki.koha-community.org/wiki/Roles_for_3.24 21:18 hbraum but staging/importing records still isn’t working as expected. staging bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15032 21:18 huginn 04Bug 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 04Bug http://bugs.koha-community.org/bugzilla3/show_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: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 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 04Bug http://bugs.koha-community.org/bugzilla3/show_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: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 pianohacker what! 22:54 Francesca what???? 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 http://www.alftv.com/quotes.php <-- 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 https://en.wikipedia.org/wiki/ALF_%28TV_series%29 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 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.wordpress.com/2012/02/20120202-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> http://media1.giphy.com/media/6OWIl75ibpuFO/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 http://media1.giphy.com/media/6OWIl75ibpuFO/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 https://youtu.be/jJOwdrTA8Gw 23:14 wahanui OK, eythian. 23:14 pianohacker wahanui: plack issues is also http://i.imgur.com/uTnI2.gif 23:14 wahanui okay, pianohacker. 23:16 wizzyrea http://i.imgur.com/JmBkN.gif < also for plack 23:18 pianohacker ha! Yes. 23:22 pianohacker good night all :)