Time Nick Message 23:22 pianohacker good night all :) 23:18 pianohacker ha! Yes. 23:16 wizzyrea http://i.imgur.com/JmBkN.gif < also for plack 23:14 wahanui okay, pianohacker. 23:14 pianohacker wahanui: plack issues is also http://i.imgur.com/uTnI2.gif 23:14 wahanui OK, eythian. 23:14 eythian wahanui: llama is https://youtu.be/jJOwdrTA8Gw 23:11 tcohen LOL 23:10 Francesca lol 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:09 Francesca hahahaha 23:09 wahanui hmmm... plack issues is http://media1.giphy.com/media/6OWIl75ibpuFO/giphy.gif 23:09 tcohen wahanui: plack issues? 23:08 pianohacker ^ same 23:08 Francesca dont think anyone in the family watches alf 23:07 Francesca so I was exposed as a little kid 23:07 Francesca and so does dad 23:07 Francesca mum likes star trek 23:07 pianohacker :) 23:07 pianohacker clearly this must be debated to death 23:07 eythian you understand that star trek is older than alf, right? 23:07 pianohacker are we calling alf a classic like Asimov, or a classic like Star Wars? 23:07 Francesca cool 23:07 Francesca ohh theres a start trek one there now 23:06 pianohacker wow 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 Francesca wahanui literal facepalm 23:06 Francesca it gets better 23:06 pianohacker haha wtf wahanui 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:05 * Francesca facepalms 23:04 eythian ^^^ 23:03 ibeardslee oh, if Francesca took classics she really should know about Alf. It is a classic. 23:03 pianohacker Francesca: excellently! Doing a lot of Hanon :P 23:02 Francesca so pianohacker - hows the piano hacking going? 23:02 pianohacker hi kathryn :) 23:02 kathryn hi pianohacker :) 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:01 tcohen heh, keep one eye open cait 23:01 cait ... now i probably can't sleep! 23:01 cait um thx for the picture 23:01 Francesca hahahaha 23:01 tcohen f 23:01 tcohen if they had bigger claws, they would just rip our heads of 23:00 kathryn and all. there! 23:00 Francesca sup 23:00 kathryn and hi francesca :) 23:00 eythian later cait 23:00 tcohen bye cait 23:00 Francesca cait 23:00 Francesca bye cair 23:00 kathryn hi tcohen :) 23:00 tcohen we want them to have them, but they don't 23:00 wahanui goodnight cait. You'll be back. 23:00 cait night all 23:00 cait :) 23:00 tcohen they have no feelings 23:00 kathryn night cait :) 23:00 tcohen it is pretty clear 23:00 tcohen they only want food, if you think about it 22:59 cait ok, time to sleep 22:59 cait both are cool? 22:59 Francesca tcohen how is a cat like a robot? 22:59 * Francesca is also a cat person 22:58 Francesca hahaha 22:58 * tcohen loves them 22:58 wizzyrea the trolling is strong today. 22:58 tcohen cats are like robots 22:58 Francesca lol 22:58 pianohacker hahahaha okay 22:58 eythian pianohacker: yes. 22:58 Francesca I know about the roman empire - took classics 22:58 pianohacker and alf is of the same magnitude? ;) 22:57 wizzyrea ^^^ 22:57 eythian that's no excuse. I know about the moon landing and the roman empire. 22:57 wizzyrea RUDE. 22:57 Francesca lol 22:57 pianohacker just smile and nod until the old people go away 22:57 ibeardslee oh right yes, Francesca is a youngun 22:57 Francesca hahahaha 22:57 pianohacker it's something from before we were born, Francesca 22:57 Francesca ah lol 22:57 eythian what sort of person doesn't know about Alf? 22:56 wizzyrea https://en.wikipedia.org/wiki/ALF_%28TV_series%29 22:56 Francesca not sure what I just read but ok 22:56 wizzyrea lol alf. 22:55 Francesca ok 22:55 eythian http://www.alftv.com/quotes.php <-- I feel like you need more culture 22:55 Francesca cats are cute 22:55 Francesca glad someone agrees with me 22:55 pianohacker dangerous business 22:54 pianohacker hey now, you're saying bad things about cats around _librarians_ 22:54 Francesca what???? 22:54 pianohacker what! 22:54 eythian no wahanui, cats is <reply>The only good cat is a stir-fried cat. 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:46 Francesca @wunder wlg 22:46 wahanui cats are endlessly entertaining. or cuddly and cute 22:46 Francesca wahanui cats 22:41 tcohen hey wahanui 22:40 wahanui hi, tcohen 22:40 tcohen hi 22:35 huginn cait: The operation succeeded. 22:35 cait @later tell hbraum thought of another one - uploading invoice files in acq 22:29 hbraum i’m headed out shortly. will try to coninue test a bit more tomorrow. have a great/day/evening all. 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:28 cait super helpful 22:28 cait thx a lot for your testing 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:27 cait wish you hadn#t found so many things... but glad they are found the same time :) 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:22 eythian oh right 22:22 cait just reading today's bug mails 22:22 cait the last comment is for you i think 22:22 eythian should I have? 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 wahanui bug 14778 is ready for testing (cc ashimema :)) 22:22 eythian bug 14778 22:21 cait eythian: did you see 14778? 21:38 * cait waves back 21:37 * Francesca waves 21:35 cait and that's not even in the list 21:35 cait yeah that too 21:34 * pianohacker whispers "raaaaaancooooor" 21:33 cait long list 21:33 * cait sighs looking at the list of enh and new features in qa queue 21:31 hbraum no worries; yes it is. 21:31 cait long list :) 21:31 cait ah sorry, missed that 21:31 hbraum tyvm 21:31 hbraum yep got batch edit/delete on my list to check. 21:31 cait tools 21:31 cait and the batch edit/delete 21:31 cait oh and inventory 21:31 cait from the patron record and with the batch tool 21:31 hbraum ty! 21:30 cait hm patron image upload maybe? 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:26 cait trying to finish some things i started on the train 21:26 pianohacker no worries 21:26 cait not tonight probably, but still trying 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:24 pianohacker I won't rewrite it from scratch... just make it pretty :) 21:24 pianohacker oh! I see what you mean 21:24 cait ok 21:23 pianohacker the patches on the bug are the latest, yes :) 21:23 cait just been travelling too much :( 21:23 cait i am still owing you a proof read 21:22 pianohacker I had to rebase the patches 21:22 pianohacker (to your second question) 21:22 pianohacker cait: ? 21:22 cait morning eythian :) 21:22 eythian hi 21:22 cait pianohacker: not sure rewriting it from scratch was the idea for maintainers :P 21:21 hbraum will do thanks pianohacker 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 pianohacker hbraum: I'd say attach it to bug 15032 21:21 cait pianohacker: are patches on the rancor bug now the latest? 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:20 pianohacker ALL OF IT 21:20 pianohacker cait: All of admin will be pretty 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: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:17 cait pianohacker++ too http://wiki.koha-community.org/wiki/Roles_for_3.24 21:15 pianohacker hbraum++ 21:15 pianohacker tcohen++ 21:15 pianohacker woot! 21:15 cait hbraum++ :) 21:15 hbraum pianohacker plack system no longer timing out on me so yes fix worked 20:26 pianohacker kk cool 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:25 pianohacker hbraum: tcohen's fix work for you? 20:24 hbraum tcohen andreashm just saw your comments about the timeouts; I saw the same earlier. glad it wasn’t just me. 20:19 * cait waves 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:16 wizzyrea hi sorry what? 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:11 andreashm Tcohen: It seems to work now. 20:03 pianohacker oh, no, that makes sense I guess 20:03 pianohacker wtf? 19:57 tcohen ok, setting to mysql made it kick me out 19:55 tcohen maybe i should leave mysql 19:54 pianohacker is that generally more reliable? I thought they were all mostly equivalent 19:54 tcohen it is memcached now 19:54 tcohen it was mysql 19:54 pianohacker what sessionstorage are we using, tcohen? 19:53 tcohen andreashm: can u try? 19:53 tcohen i'm not kicked out anymore 19:52 tcohen andreashm: i disabled SessionRestrictionByIP and am trying 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:46 tcohen andreashm: that's new :-/ 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:44 andreashm hi tcohen 19:41 * andreashm waves 18:46 tcohen later #koha 18:38 huginn New commit(s) kohagit: Translation files update <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9a5b6528fdbbd9f1764b1875038f484c531836bd> 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:25 huginn tcohen: Error: No such location could be found. 18:25 tcohen @wunder wellington 18:25 tcohen wizzyrea: ? 18:19 tcohen FILTER lower 18:16 tcohen is there a Template::Toolkit function for lowercase text? 17:45 xarragon_ Sorry, mis-pressed ^^ 17:44 xarragon_ sophie_m: 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:40 xarragon_ pianohacker: Ok, great! thanks 17:38 pianohacker xarragon_: there's some precedent for that, see UpdateNotForLoanStatusOnCheckin 17:36 xarragon_ If I need to store something like a list of key-value pairs, is that suitable for a syspref? 16:42 pianohacker ashimema: around? 16:06 Joubu bye #koha 15:36 pianohacker :) 15:36 cait :) 15:34 tcohen hi cait! 15:33 cait looking at 8296 now 15:33 * cait waves at tcohen from the train 15:33 cait tcohen: sonds like a good rule 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:28 * tcohen strongly belives we shouldn't be pushing stuff between 23:00 and 23:59 (bug 15029) 15:23 cait at least i hope it's fixing :) 15:23 cait i could have failed it... but then ended up fixing it 15:23 cait i understand,maybe julian can take a look 15:22 cait that's alright 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 too shocked? :P 15:22 Joubu cait: i haven't answered anything :) 15:22 cait Joubu: sorry, lost connection 15:22 reiveune bye 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:21 cait @wunder Konstanz 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:19 tcohen bug 8436 15:10 * cait moves on to messing up the next bug 15:08 cait i blame too much time on trains.... 15:07 cait could you take a look? 15:07 cait i am gulty of writing 2 follow ups 15:07 cait i just uploaded 8436 (managed barely) 15:07 Joubu If it's not for patching tests, I can help 15:07 cait internet connection is really bad 15:07 Joubu cait: yep 15:06 cait Joubu: around? 15:03 ashimema thanks Joubu++ 15:03 ashimema will try to take a look this evening.. 15:03 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 Joubu bug 14778 is ready for testing (cc ashimema :)) 15:00 Joubu magnuse: why? :) 15:00 * Joubu is blaming andreashm 15:00 magnuse Joubu: blame andreashm ;-) 14:53 tcohen i mean, I consider it blocker 14:53 tcohen jajm: might be blocker for the 'attach files' functionality 14:52 jajm tcohen, sure 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:48 tcohen bug 11565 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 14694 14:47 tcohen jajm: could you take a look at 14674 please? 14:29 cbrannon Would love it if someone could run 14694 and 11565 through QA. :) 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 13:57 Joubu my 10£ ikea standing desk have just fallen down :-/ 13:36 * magnuse wanders off to make dinner 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: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:31 magnuse then use circ etc as normal 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:28 magnuse so far, i have only thought about the opac :-) 13:24 andreashm but I kind of like the thought. =) 13:24 andreashm also, I'm considering how such an approach would impact the harvesting of records. 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:21 magnuse andreashm: yup. not perfect, but doable, i think 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:18 magnuse s/item detail for/item detail form/ 13:17 magnuse much easier if you can dumb the rdf down to (very, very) minimal marc records that koha can chew on 13:17 magnuse but ripping marc out of koha and replacing it with rdf is going to be a huge thing 13:17 magnuse andreashm: yeah, maybe :-) 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:16 andreashm But items shouldn't be a problem really as that is not Marc, but separate tables in the database? 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:15 andreashm hehe 13:14 magnuse one notch less radical than deichman :-) 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:12 andreashm tcohen: no, haven't had time today. might look around a little now though. 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:11 andreashm the problem of going out to get some coffee and end up talking to co-workers for a long time. =) 13:11 * andreashm was away, but now stumbles back 13:00 dojobo magnuse: yeah, even the website has "use cases" with no link, and MARC mapping says "coming soon" :P 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:47 dojobo http://www.loc.gov/bibframe/ 12:46 dojobo looks like they do have a marcxml -> rdf transformation tool though 12:45 huginn tcohen: The operation succeeded. 12:45 tcohen @later tell marcelr come back 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 huginn tcohen: marcelr was last seen in #koha 1 day, 6 hours, 8 minutes, and 56 seconds ago: <marcelr> hi #koha 12:45 tcohen @seen marcelr 12:43 dojobo it's an initiative to do linked data with library catalogs 12:43 dojobo magnuse have you looked at bibframe at all? 12:41 Joubu tcohen: back 12:39 dojobo i know DPLA (digital public library of america) is using apache marmotta 12:39 dojobo https://en.wikipedia.org/wiki/List_of_subject-predicate-object_databases 12:37 magnuse ah, virtuoso 12:37 tcohen Joubu: import is incredibly slow now, but doesn't break the app 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:35 tcohen your patches for bug 14778 fix the problems with MySQL connection drops 12:35 magnuse it's been a while since i looked, there might be better alternatives now 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:32 Joubu tcohen: yep, finishing my lunch and I am back 12:24 dojobo magnuse what kind of (R)DBMS do you use for a triple store? 12:23 dojobo uh, my name is Dominic, i work at an astronomical library 12:22 tcohen who are you dojobo? 12:22 dojobo tcohen, magnuse was discussing the idea of implementing linked data in koha 12:21 magnuse hiya tcohen and dojobo 12:21 tcohen dojobo? 12:20 wahanui que tal, dojobo 12:20 dojobo hello 12:20 tcohen hi #koha 12:20 tcohen Joubu: did u see my message? 12:20 tcohen andreashm: did you re-try the plack server? :-D 12:19 dojobo magnuse, very cool ideas 12:19 tcohen morning 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 11:51 andreashm (The OAI-PMH harvester, that is) 11:44 andreashm (Leaving all the fun stuff for later, like enriching the OPAC) 11:43 wahanui okay, andreashm. 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:27 magnuse sure! 11:27 magnuse "Alone you go faster, together we go further" #kohacon15 https://twitter.com/ranginui/status/656419531905200128 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: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 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 10:39 andreashm I guess Tomás bug 14645 is also needed? 10:37 andreashm what else is needed to provide RDF support for Koha? Mappings to Marc, the ability to add Thesauri etc? 10:36 andreashm magnuse: (picking up on your last comment) so the idea is to add a triple-store to Koha? 10:33 * andreashm waves' 09:46 magnuse lunch? yeah! 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:31 * andreashm is of for lunch, and then meeting. bbl. 09:30 andreashm ? 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:23 magnuse maybe next year? 09:23 magnuse andreashm: i ran out of time 08:43 drojf hi andreashm 08:43 andreashm hi drojf! 08:43 drojf hi #koha 08:37 IceCube nm got that figured out 08:36 IceCube I'm sure I just have to delete it somewhere but can't figure out where 08:35 IceCube so now when I do "koha-create --create-db dbname" I get the error "user dbname-koha already exists" 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:13 IceCube ok it started 08:09 IceCube wt* now apache won't start 08:08 magnuse ah, cool 08:08 magnuse it depends on how the dump was created, i think 08:08 IceCube yep 08:08 magnuse ? 08:08 magnuse did you do that 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:06 IceCube ok 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 07:57 IceCube except it's a vm so that makes that impossible 07:54 IceCube :) 07:53 IceCube I am thinking of my favorite word: defenestration. 07:53 IceCube This has been going on for almost 11 hours now 07:53 IceCube well I already deleted everything 07:52 Joubu So you have to give rights to this user 07:52 IceCube I thiiiiinnkk I used root 07:52 Joubu ok is it olgs? 07:51 Joubu it seems there is a typo... 07:51 IceCube right 07:51 IceCube I think I used a different uername 07:51 Joubu IceCube: the error you got was " Access denied for user 'koha_olgs'@'localhost'" 07:51 IceCube I had to provide credentials to import it 07:50 magnuse a different username for the same database? 07:50 IceCube I imported the database using a different mysql username - would that matter? 07:49 wahanui one possibility is that my vhost definitions are listening on the external interface but not the internal one 07:49 IceCube ok one possibility 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:47 IceCube exactly 07:46 magnuse f.xml? 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: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:44 IceCube I must have made a mistake somewhere 07:44 IceCube I really appreciate all your guys' help 07:44 IceCube I'm just going to uninstalland try again I think. This is ridiculous. 07:44 magnuse no worries, we like to help :-) 07:43 IceCube I apologize 07:43 Joubu no, only in this config file 07:43 IceCube I know these are prob noob questions but this is new territory 07:42 IceCube well wrong compared to what, I guess. Are there credentials in the imported db? 07:42 Joubu IceCube: but the credentials in your koha-conf.xml file was wrong, and that's quite weird :) 07:42 IceCube it is 07:41 Joubu magnuse: it's not on the same server 07:41 IceCube but it didn't :( 07:41 magnuse and that should work after importing the db too 07:41 IceCube before importing the db 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:40 magnuse what user were you trying to log in as? 07:40 IceCube I imported the db and was then not able to log in to see the upgrade screen 07:40 IceCube Well when I logged in the first time to the site with the browser it let me 07:40 magnuse IceCube: you should have got a upgrade screen after you imported the old database and logged in 07:39 IceCube If I do it over the same thing will just happen, I think. 07:39 Joubu no, the credentials were wrong, so you didn't install Koha correctly 07:39 IceCube I installed everything from scratch today on a VM and it was working fine until I imported the old database 07:38 IceCube That's what this is 07:37 Joubu you should try a fresh install on a fresh server, using the packages 07:36 Joubu IceCube: I am not sure what you did, but it's not normal to get all these errors 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:30 Joubu update these info to fit your needs :) 07:30 IceCube yep I'm there 07:29 Joubu with database/hostname/user/pass 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 IceCube I found that user. It's some random default password 07:29 fridolin Joubu: mmmm no idea 07:28 IceCube ok 07:27 Joubu edit $KOHA_CONF 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 IceCube I could access the page before importing the db 07:27 IceCube sigh ok any idea how to make them right? 07:26 Joubu your credentials are wrong 07:26 Joubu IceCube: Access denied for user 'koha_olgs'@'localhost' (using password: YES) 07:26 fridolin Joubu: it uses MARC::Crosswalk::DublinCore 07:26 Joubu so you have it :) 07:26 IceCube Joubu there's the logs 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:23 andreashm magnuse: hej! 07:23 Joubu fridolin: do you know how dublin core export works in Koha? 07:22 magnuse and tjänare andreashm 07:22 fridolin :D 07:22 magnuse yay! 07:22 fridolin in master at laaaaaaaaaaast 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:21 fridolin congratulations to Lyon3 Univ Team for Bug 8236 07:20 * andreashm waves 07:20 IceCube sure gimme a sec 07:20 Joubu could you edit C4/Context.pm and give me what is your line 794? 07:19 IceCube hold on let me output it to a file 07:19 Joubu Something like "Can't connect to mysql server"? 07:18 Joubu nothing else before? :) 07:16 IceCube also name-koha-zebra: client killed by signal 15, stopping 07:15 IceCube yep it says the same thing in there 07:14 Joubu then reload the page 07:14 Joubu tail -f /var/log/koha/$instance/*.log # replace $instance 07:14 Joubu try the Koha logs :) 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:13 Joubu check in the Koha log files, you could have another error 07:13 IceCube mysql Ver 14.14 Distrib 5.5.44 for debian-linux-gnu ... 07:12 Joubu mysql 14.14? 07:12 IceCube no that's what I get when I point my browser to the site 07:12 IceCube mysql 14.14 07:11 Joubu Do you have another error before the "can't call do on unblessed ref"? 07:11 IceCube mysql 07:11 Joubu mysql or mariadb? if mysql, which version are you using? 07:10 IceCube does that make sense? 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: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:08 IceCube Just installed today 07:08 IceCube latest 07:07 Joubu What's your Koha version? 07:06 Joubu what about the credentials? 07:06 IceCube server isn't down, I'm on it now 07:05 IceCube yeah... trying to figure out those possibilities! 07:05 Joubu or a lot of other possibilities 07:05 Joubu your db is not reachable, either your credentials are wrong, or the server is down 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:02 Joubu IceCube: what's your error? 07:02 gaetan_B hello 07:01 wahanui hola, alex_a 07:01 alex_a bonjour 06:59 IceCube well I've run into an error the solution to which is eluding me 06:59 Joubu I don't know, it depends on the area I'd say 06:58 IceCube are you a koha guru? 06:58 IceCube hi Joubu 06:58 Joubu hi 06:57 wahanui magnuse is afraid that we added another 10000 bugs while he was eating pizza. 06:57 IceCube magnuse? 06:57 IceCube thanks for your help dcook 06:57 IceCube well I hope so 06:56 dcook Europe is coming online, while we Oceanic folk go home 06:56 dcook Sorry, IceCube. Got to go, but I'm sure some of these fine people can help you 06:45 wahanui hola, reiveune 06:45 reiveune hello 06:44 IceCube hi 06:44 fridolin hie there 06:33 IceCube I'm looking through to see if anything is helpful 06:33 IceCube it looks like a number of people have experienced this problem and discussed it recently on here 06:32 IceCube I can log into the database fine 06:32 IceCube I'm really stuck here. This is annoying. 06:13 IceCube well I thought they were, they seemed to be working earlier and I haven't changed them 06:12 dcook I'm guessing perhaps your credentials are set up correctly? 06:12 dcook Ahh... 06:11 IceCube I know in the end it will be satisfying 06:11 dcook I've heard of this error before but I haven't seen it myself I think 06:11 dcook It's tough cleaning up a bad mess, but it's worth it! 06:10 IceCube thanks magnuse 06:10 IceCube haha 06:10 magnuse IceCube++ for persistence :-) 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:09 IceCube I feel like that is progress going from one error to a different one 06:09 IceCube wellll.... now I'm getting a different error 06:02 magnuse kia ora cait! 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.. 05:59 dcook And then you can toggle between different language files 05:59 dcook Where in your code or your template you refer to an identifier in a file 05:59 dcook And I kind of like the way that Java projects seem to do things 05:59 dcook I've recently started working on Android apps for fun 05:58 dcook That would be great :) 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:49 magnuse being able to translate things like authorized values 05:49 dcook Oooo 05:49 dcook What's it about? 05:49 dcook Ooh. I've seen mentions of this. 05:48 dcook Just about! 05:48 magnuse and Joubu++ of course 05:48 magnuse cait++ 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 bug 14100 - woohoo! 05:46 magnuse time to go? :-) 05:46 magnuse hiya dcook 05:44 dcook yo magnuse 05:42 * magnuse waves again 05:40 * magnuse needs a reboot 05:40 magnuse :-) 05:39 * IceCube waves back 05:39 * magnuse waves 05:19 IceCube you're prob right I'll go do it individually 05:19 dcook But that's liekly to be more error prone I think 05:19 dcook Or you can edit the SQL that comes out 05:19 IceCube ok 05:19 dcook Then do them individually I'd say 05:19 IceCube we have other things running that use mysql 05:19 dcook Koha only needs one 05:19 dcook Several of them? 05:19 dcook That'll give you the syntax 05:19 IceCube Well I need several of them but only one is a koha db 05:18 dcook check out "man mysqldump" 05:18 dcook Which I'm guessing is almost certainly not what you want to do 05:18 dcook Because that's going to dump all databases into that file 05:18 IceCube I don't think so... I don't see it in the irc log 05:18 dcook Someone here? 05:17 IceCube that's what someone told me to do 05:17 dcook Wow... 5.1... 05:17 dcook Why the -A? 05:17 IceCube 5.1.73-1 05:17 dcook O_o 05:17 IceCube mysqldump -A > FILENAME.sql 05:17 dcook What version of MySQL? 05:17 IceCube mysqldump to a file 05:17 dcook How did you do the backup? 05:16 dcook That looks really weird though 05:16 IceCube yep ok I see it 05:16 dcook CREATE DATABASE /*!32312 IF NOT EXISTS*/ `koha_koha` /*!40100 DEFAULT CHARACTER SET la$ 05:16 IceCube didn't realize they were also -- 05:16 dcook But at the bottom it does have some real SQL 05:16 IceCube ahhh ok got it 05:16 IceCube Well that's the top of the file 05:16 dcook Yeah SQL comments are "--" and "/* */" 05:16 dcook Ahhh at the bottom 05:16 IceCube oh so the -- is comment? 05:16 IceCube there it is 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:15 dcook For humans 05:15 dcook That should just be a comment, I believe 05:14 dcook Bi-directional clipboard is awesome for that :D 05:13 IceCube actually I think I can get it to work 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:12 pastebot "IceCube" at 127.0.0.1 pasted "-- -- Current Database: `name_" (5 lines) at http://paste.koha-community.org/111 05:09 IceCube yep gimme a sec 05:09 dcook You can use this link: http://paste.koha-community.org/ 05:09 dcook Can you copy and paste? 05:09 dcook I've never heard of a line like that 05:09 IceCube What about the line "Current Database" 05:08 dcook Hmm I don't see anything in a normal dump specific to the database 05:07 dcook Let's see if I have a dump around to see... 05:07 dcook Yeah you might need to go into the sql and change the name 05:03 IceCube right 05:03 dcook You mean a database name? 04:59 IceCube I'm moving it to a new system and the new one has a different name 04:59 IceCube well she said I should change the entry and I _think_ she meant the old name 04:58 IceCube ok well then I have another question 04:58 dcook What's wrong with the dump? 04:58 dcook Alas, I have no idea what you're talking about 04:48 IceCube I'm wondering if that is the line that says "Current Database" 04:48 IceCube before I migrate it to the new system 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:47 IceCube ahh ok 04:46 dcook daylight savings caught up.. 04:46 dcook Ah after 5pm 04:46 dcook What's up? 04:46 dcook I think it's after 6pm where she is 04:46 dcook She might not be around now 04:45 IceCube if you don't mind 04:45 IceCube wizzy, question about something you said earlier 03:58 wahanui hmmm... hard is https://www.youtube.com/watch?v=Pg_ArW8lrl0 03:58 dcook hard? 03:58 dcook hard is https://www.youtube.com/watch?v=Pg_ArW8lrl0 03:58 dcook hard? 03:58 dcook Next time someone brings out 10 minutes, I'll bring out that 10 hours 03:58 dcook Exactly 03:58 eythian why do you need 10 minutes when you have 10 hours? 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:56 eythian heh 03:56 dcook I sometimes wonder if meeting you is a good idea, eythian ;) 03:56 eythian https://www.youtube.com/watch?v=epIT4-gF__M <-- here you go dcook 03:55 dcook I think there is probably a Simpsons quote or I Heart Huckabees quote for pretty much any situation 03:53 eythian that's excellent 03:52 dcook I think tcohen was also the one who showed me: https://www.youtube.com/watch?v=I94w30LszoQ 03:51 dcook I'm not a religious watcher of The Simpsons, but "dental plan" is a classic :p 03:37 ibeardslee so not someone needing a knuckle sandwich? 03:36 wizzyrea I didn't get it at first either, as I'm not a religious watcher of the simpsons 03:35 eythian I see. 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:33 wizzyrea I think it's a simpsons quote 03:22 eythian http://bwipp.terryburton.co.uk/ <-- interesting, I wonder if we could use that (a postscript barcode generating library.) 03:11 * eythian does not understand tcohen's "dental plan" reference on the list 03:02 tcohen byeeeee 02:54 wizzyrea shoo* 02:54 wizzyrea shooe 02:54 * wizzyrea orders tcohen to bed 02:53 huginn tcohen: The operation succeeded. 02:53 tcohen @later tell ribasushi need to talk about thread safe DBIC usage 02:49 wahanui okay, eythian. 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: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:48 eythian wahanui: literal good night 02:36 IceCube night 02:36 tcohen night jcamins 02:34 wahanui If you feel like someone is looking through wahanui's window, it's OK, it's just me. 02:34 jcamins Good night. 02:34 jcamins Didn't the prince try to sing about that in Monty Python and the Holy Grail? 02:32 tcohen automagically++ 02:32 wizzyrea automagically 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:29 huginn tcohen: The operation succeeded. 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:27 jcamins (you'll have to use ps to see when the upgrade's finished running) 02:26 jcamins Unless you already started doing it in the web browser, in which case, just deal. 02:26 jcamins Better: koha-upgrade-schema instancename 02:07 IceCube haha eventually! 02:07 wizzyrea at least, hopefully you profit ^.^ 02:07 IceCube ok I'll go ahead and start doing that 02:06 wizzyrea profit. 02:06 wizzyrea and say "yes, update it" 02:06 wizzyrea log in with the db creds 02:06 wizzyrea then you go to the intranet, 02:05 wizzyrea then cat dump.sql | sudo koha-mysql instancename (instancename is the name you gave your instance, if that's unclear) 02:05 wizzyrea move it to the new server 02:05 wizzyrea edit the dump, if necessary, to get rid of the use database entry if it's wrong 02:04 wizzyrea mysqldump the old database 01:57 IceCube what's the best process for doing this 01:56 gmcharlt hi tcohen 01:56 tcohen hi gmcharlt 01:56 IceCube Everything seems to be in order so far 01:56 IceCube ok so now I'm ready to export the old database into the new system 01:54 wizzyrea I mean, that sucks. 01:54 wizzyrea ? 01:53 wizzyrea haha, was that it 01:53 gmcharlt wizzyrea: whoops, turns out I had completely missed the notification 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 Francesca @wunder wlg 01:52 Francesca didn't realise he'd quit 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 gmcharlt @quote random 01:52 Francesca oh hello huginns back 01:52 wizzyrea cuz linode is going to reboot it at some point for xen updates 01:51 wizzyrea I need to send a hazard notice for k-c.org 01:51 wahanui i think linode is better/cheaper than slicehost 01:51 wizzyrea oh, linode? 01:50 gmcharlt joy; unexpected reboot 01:48 * eythian assumes that gmcharlt's library police are really good at issuing fines. 01:47 IceCube ok 01:47 IceCube lol 01:47 wizzyrea jinx. 01:47 wizzyrea or take it out 01:46 eythian if it does, edit that line out. 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 so long as it won't try to "USE" the original name 01:46 IceCube ok 01:46 eythian IceCube: the database name isn't really important 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:40 IceCube_ LOL 01:40 dcook That mouse has a mind of its own 01:39 dcook Well then... 01:39 wizzyrea A+ confetti-ing 01:39 wahanui i heard confetti was http://25.media.tumblr.com/tumblr_lpm3j6aNaN1qh8hleo1_400.gif 01:39 dcook confetti? 01:39 wizzyrea \o/ 01:37 dcook \o/ 01:37 eythian awesome 01:37 IceCube_ I restarted apache after I changed the port to 80 and that did the trick 01:35 IceCube_ perfect, thanks. Bookmarked :) 01:34 eythian that'll get you what you missed 01:34 wahanui irc logs are http://irc.koha-community.org/irclog/koha/ 01:34 eythian wahanui: irc logs 01:33 wizzyrea you're so nearly there :) 01:33 IceCube_ Sorry I missed the last thing 01:32 wahanui http://wiki.koha-community.org/wiki/Koha_on_Debian 01:32 wizzyrea koha on debian? 01:32 eythian it's possible you changed it in koha-sites.conf, that's where the defaults come from 01:32 IceCube ok 01:31 IceCube huh 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 eythian yeah, just checked, they don't 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 IceCube I don't think I changed the default 01:30 eythian (I think) 01:30 eythian the packages don't set anything on 8080 by default 01:30 wizzyrea ^ 01:30 eythian I tend to give each one its own DNS name and have them both run on 80 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 it's up to you how you configure it 01:30 eythian it doesn't have to be 01:29 IceCube the admin one is port 8080? 01:29 eythian they'll both need a correct servername definition 01:29 eythian one for opac, one for the admin interface 01:28 eythian yeah, so there are two vhost definitions in that file 01:28 IceCube there is the library name but not the libraryname-intra 01:27 IceCube I did check that actually 01:27 IceCube oh ok yeah I have the one site but not the other 01:26 eythian /etc/apache2/sites-enabled/something.conf 01:26 IceCube I'm sorry for what are probably obvious questions 01:26 eythian no 01:24 IceCube apache-shared-intranet.conf? 01:24 IceCube and...? 01:24 IceCube apache-shared.conf 01:19 eythian *one 01:19 dcook IceCube: What do you mean by which one? 01:19 eythian the ones that was created 01:19 IceCube which one do I look in 01:18 IceCube ok... 01:18 IceCube as far as I can tell 01:18 eythian the koha-create process would have made one 01:18 eythian have a look in the apache config 01:17 IceCube I think that site isn't set up in apache 01:17 eythian did you ensure that ServerName in the apache config matches the DNS names, in both places? 01:17 IceCube yep 01:17 eythian did you set up DNS? 01:17 IceCube does that make sense 01:16 IceCube I just get the "Apache works" page 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 hi dcook, thanks 01:16 dcook What's up? 01:16 dcook Sort of here 01:16 IceCube ok I have some questions, if anyone is still there