Time Nick Message 01:03 dcook tfw you find a non-core Perl module on your system and you can't figure out what module it's a dependency for.. 01:03 dcook Actually.. 01:05 dcook Actually.. 01:07 dcook Any Debian Koha users around here? 01:49 mtj hi dcook, i use debian 01:50 * wizzyrea raises her hand 01:50 wizzyrea sup dcook 01:58 mtj hiya wiz :) 01:58 mtj https://askubuntu.com/questions/13296/how-do-i-find-the-reverse-dependency-of-a-package 01:58 mtj dcook: you might be after that ? ^ (re: your previous Q) 01:59 mtj $ apt-cache rdepends perl-somemodule 02:17 dcook Oh hai all 02:17 dcook mtj: Ah, I'm not on Debian :) 02:17 dcook I was hoping one of you could do it for me 02:17 dcook perl-text-difflib? Is that the syntax? 02:17 dcook It's for Text::Diff 02:18 dcook Actually maybe I do have a Debian system around.. 02:18 dcook libtext-diff-perl 02:18 wizzyrea libtext-diff-perl 02:18 wizzyrea lol 02:19 wizzyrea if you have a devbox you'd have a debian system around 02:19 dcook I use Windows so I don't have a devbox 02:19 wizzyrea it should work? 02:19 dcook I guess Tomas made some recentish changes to make it work on Windows yeah 02:19 wizzyrea i mean, it's just virtualbox, vagrant, and ansible. 02:19 dcook Haven't gotten around to that yet 02:19 dcook Well it is now 02:19 dcook It used to use Ansible on the host end 02:19 dcook And you can't use Ansible on Windows 02:20 dcook Or it still uses Ansible on the host end, but you can opt to just use it locally within the guest now 02:20 wizzyrea err http://docs.ansible.com/ansible/intro_windows.html#installing-on-the-control-machine 02:20 dcook mtj: I'd already traced it back to Test::Differences 02:21 dcook wizzyrea: I think that's for controlling Windows machines 02:21 dcook Still requires a Linux host I think 02:21 wizzyrea mmm that's not how I understand the usage of "control machine" 02:21 dcook As the controlling machine 02:21 wizzyrea but ok 02:21 dcook I think you're misreading it? 02:21 wizzyrea idc to be honest, I don't use windows ;) 02:22 wizzyrea not for that anyway. ^.^ 02:22 dcook If you re-read it, I think you'll see it's about controlling Windows machines from a Linux machine 02:22 dcook But thanks in any case 02:22 dcook Yeah I have a Windows workstation 02:22 dcook Linux servers but Windows workstation 02:22 dcook Could have a headless virtualbox on a Linux server, but those are already virtualized servers.. 02:23 dcook Plus I don't use Koha on Debian anyway, so I don't really need the devbox 02:23 dcook Other than the occasional time I want to know something about those who do 02:24 dcook Maybe one day Nicholas and I will collaborate more on a more official RPM Koha... 02:24 * dcook actually really likes the RPM spec format 02:25 dcook Sometimes I wonder about Koha using a non-system Perl... it's certainly doable especially with Plack... 02:25 dcook But not all that nice with the package system.. 06:00 mtj dcook: perlbrew would be useful for your idea ^ 06:00 mtj https://perlbrew.pl/ 06:08 dcook mtj: Or plenv 06:09 dcook I mean... easy enough to do with perlbrew or plenv 06:09 dcook But I don't know how well that would work with the packages 06:09 dcook plenv + carton would make for something pretty easy I reckon for non-package users 06:10 dcook But I think... tools like these are more useful for companies and such that handle everything themselves 06:10 dcook I don't know how one would use them well for distributing software globally to people you don't control 06:13 mtj yeah... i woulnt recomend it for prod usage 06:15 mtj i think you might end up would playing cpan roulette 06:15 mtj s/would// 06:17 dcook Well with carton it uses a snapshot file to denote specific versions I believe 06:17 dcook So if you don't get the right versions, your deploy just fails I imagine 06:17 dcook Although yeah... as an open source thing I don't know how well that would work 06:17 dcook Easy to manage at a company level but not at a global level I think 06:19 dcook So I think it would be fine for prod usage for vendors, but not for regular people 06:19 dcook Of course, a person could package up their own dependencies, but that would be sooo much work 06:20 dcook I don't think mirko has time for that 06:27 dcook On an unrelated note, arg blank nooooodes in RDF 06:28 cait mtj: thx for taking a look - my jenkins used to be green, would like to get it back to that - it changed after my last big push session 06:29 cait bbiab 06:33 mveron-away Good morning #koha 06:36 LibraryClaire hi mveron 06:36 LibraryClaire hi #koha 06:37 mveron hi LibraryClaire 06:39 mtj cait: yep, me too :) 06:40 reiveune hello 06:48 * magnuse waves 06:49 LibraryClaire hei magnuse 06:49 * mveron waves as well 06:49 * dcook waves to magnuse 06:49 dcook Playing with Fuseki :) 06:50 magnuse dcook++ 06:50 dcook I wish I knew if these LIBRIS records were good linked data or not :S 06:50 magnuse hiya LibraryClaire mveron 06:50 dcook The downside of experimental stuff! 06:58 alex_a bonjour 07:34 gaetan_B hello 07:35 magnuse bonjour! 07:54 atheia kia ora 07:55 magnuse kia ora atheia 07:55 * magnuse is just about to dig into ill 07:56 magnuse atheia: in Koha::Illrequest there is _core_status_graph - is the idea that different plugins/backends can override that to define their own workflows? 07:58 atheia magnuse: yeah that's exactly right. 07:58 magnuse cool 07:58 atheia And normally the _core_status_graph is merged with the individual backend's status graph. 07:59 magnuse ah, ok 07:59 atheia When I say normally, I mean, always. 07:59 magnuse hehe 07:59 magnuse so when Dummy has sub status_graph { return {}; } it means it gets the core graph as is 08:00 magnuse i need to get my head around that merging 08:00 atheia That's right — it just implements the core workflows. 08:00 magnuse oh one more question: 08:01 atheia the assumption is that all backends should implement the core workflows, but can add additional flows. 08:01 atheia sure 08:01 magnuse i need to receive a message in NCIPServer and then call Koha code to create an ill request in koha 08:01 magnuse what's the recommended way to do that? 08:01 * magnuse has not looked through all the code yet 08:01 atheia You mean implementing all the core workflows? 08:03 magnuse i think my $illRequests = Koha::Illrequests->new(); 08:03 magnuse is what i am looking for 08:03 magnuse should that be "my $illRequest"? 08:04 magnuse and then pass some params to new()? 08:04 atheia ah sorry, missed your message about NCIP. Just parsing and thinking now :-) 08:05 atheia Right — so it depends. 08:06 atheia The illrequest->new stuff mostly just implements the Koha::Object interface 08:06 atheia You don't need to explicitly call that. 08:06 atheia When you receive a message from NCIP, is that for a request that is 'created' or 'confirmed' 08:07 atheia I.e. is this just a 'wish from a customer' or is this 'a request that has been request and will be placed no matter what'? 08:07 magnuse could be either, i guess 08:07 eythian hi 08:07 wahanui what's up, eythian 08:07 atheia So what happens is that 'create' creates the data in the koha store, so you'll need to invoke that anyway. 08:07 eythian wahanui: oh, you know. The sky. 08:07 wahanui eythian: sorry... 08:08 atheia Let me reference the right bit from an example in the code. 08:08 magnuse but the workflow is mainly librarian signs into remote opac and places an ill request. remote ils sends a message to local ils (koha) saying "this ill request has been created, please make a note of it" 08:08 atheia /ill/ill-requests.pl :: 55 08:09 atheia OK, so definitely start with 'create' 08:09 magnuse ah, yes i had not looked in that file yet 08:09 magnuse yeah, that looks like the way to go then 08:10 atheia in the example I reference you'll see it creates an ILL object, loads an explicit backend (in your case NNCIP I guess), and then invokes backend_create with the metadata on that request. 08:10 atheia Once that is done, you'll have data in the database and it'll show up in the ILLModule UI — then you can go from there. 08:11 magnuse yeah, awesome 08:11 magnuse thanks for pointing in the right direction! 08:11 magnuse atheia++ 08:11 atheia No problem :-) 08:38 ashimema anyone know if http fetching has recently been turned off on the community git repo? 08:44 cait hm i think maybe ot recently? 08:47 ashimema ot? 08:47 ashimema I've been using it for ages.. but not I'm dead in the water as it appears to be broken :( 08:49 cait git: cloning doesn't work? 08:51 cait https://wiki.koha-community.org/wiki/Version_Control_Using_Git#Cloning_over_HTTP 08:51 cait found this, maybe gmcharlt would know if that's correct or if it is really turned off 08:52 cait it seems it broke before: http://koha-devel.koha-community.narkive.com/8yW4tWUf/error-when-doing-a-git-koha-clone-over-http-refs-not-found-did-you-run-git-update-server-info-on 08:54 ashimema yup.. seems dead to me 08:54 ashimema who looks after the repo server these days? 08:55 cait https://wiki.koha-community.org/wiki/Website_Administration#git.koha-community.org 11:30 eythian https://twitter.com/alienated/status/850321574662209536 <-- for people in libraries 11:58 oleonard Hi all 12:00 LibraryClaire 'lo oleonard 12:00 oleonard Hi LibraryClaire how's it going? 12:00 LibraryClaire good thanks :) 12:01 LibraryClaire how're you? 12:01 oleonard Eating a donut. 12:01 LibraryClaire score 12:02 atheia Hi oleonard! Thanks for testing stockrotation! 12:02 atheia Will look at your feedback this afternoon :-) 12:02 LibraryClaire i have no donuts, but am contemplating tea 12:03 oleonard atheia: I have some other minor interface comments but what I was able to test looked good 12:04 atheia Good to hear. 12:06 magnuse oleonard++ 12:10 magnuse ...and it snows again 12:16 magnuse @quote get 123 12:16 wahanui http://xkcd.com/1172/ 12:16 huginn` magnuse: Quote #123: "rangi: #thingsihavelearnt if there is a mad scheme a library somewhere will be doing it ... except madder" (added by wizzyrea at 09:20 PM, March 30, 2011) 12:22 marcelr hi #koha 12:24 eythian hi marcelr, magnuse, atheia, oleopard, LibraryClaire 12:24 LibraryClaire hi marcelr 12:24 LibraryClaire and eythian 12:24 marcelr hi eythian and LibraryClaire 12:24 * magnuse waves 12:24 marcelr o/ 12:27 eythian marcelr: "Voor de test heb je 44,5 punten van maximaal 50 punten gehaald. Dat is 89 %." :) 12:27 marcelr en was dat genoeg ? 12:29 eythian yeah, I needed 65% 12:29 marcelr cool, congrats 12:30 eythian ta. of course, it just means more classes, but oh well. 12:38 * kidclamp_away waves 12:38 * kidclamp waves 12:39 * LibraryClaire waves 12:43 oleonard This is where Olivier Leonard may not be spending holidays because they don't remember their own email address: http://www.camping-vendee-lamotte.com/ 12:45 eythian oleonard: so what you're saying is you're heading to France for a camping holiday? 12:46 oleonard If only I could just pop over for a quick camping trip. 12:47 eythian it's only France. It's the same hemisphere even, you're practically neighbours. 12:47 * ashimema has actually camped there 12:48 oleonard Yes, I should use some of my United Airlines frequent-flyer miles :| 12:48 eythian heh 12:48 oleonard ashimema: So maybe you know Olivier Leonard? 12:48 eythian I hear he goes by Olivier Leopard. 12:48 ashimema never heard of her 12:48 ashimema lol 12:51 tcohen morning 12:52 andreashm hey tcohen 12:52 tcohen hi andreashm 12:52 tcohen khall: 18409 is for master? 12:52 eythian @wunder ams 12:52 huginn` eythian: Error: No such location could be found. 13:01 kidclamp tcohen, yup 13:10 cait bug 18409 13:10 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18409 critical, P5 - low, ---, koha-bugs, NEW , Error when updating pickup library on patron pages 13:27 * magnuse does a major facepalm after editing the wrong file for the last x hours 13:27 Joubu qa: bug 18373 is major and needed for stable releases 13:27 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18373 major, P5 - low, ---, jonathan.druart, Signed Off , `make upgrade` is broken 13:28 cait thx Joubu, I totally second that 13:28 cait tcohen or kidclamp maybe? *pings* 13:28 kidclamp looking right now 13:28 cait magnuse: i know exactly how you feel 13:28 cait there is also a nother bug i need help with in 16.11.x 13:29 * cait goes to look up bug numbers 13:29 * tcohen is trying to fix kohadevbox right now 13:29 cait bug 18411 13:29 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18411 normal, P5 - low, ---, chris, NEW , t/db_dependent/www/search_utf8.t fails on 16.11.x 13:29 cait and bug 18373 13:29 wahanui bug 18373 is major and needed for stable releases 13:30 cait hm bug 18372 i mean 13:30 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18372 normal, P5 - low, ---, koha-bugs, NEW , transits are not created at check in despite user responsing Yes to the prompt 13:39 magnuse hm, where does the new mojo-based api log errors? 13:42 andreashm Is it just me that get ssl errors when trying to apply patches with kohadevbox? 13:43 oleonard andreashm: I get errors when connecting to a particular cpan source. I think tcohen is working on it now 13:44 oleonard andreashm: This is the problem I ran into yesterday: https://github.com/digibib/kohadevbox/issues/178 13:45 oleonard Hey everyone I'm going to try to spend most of the day doing signoffs, so if anyone has any special requests let me know 13:45 andreashm oleonard: thanks. doesn't look similar, though. 13:53 tcohen plack-errors.log ? 13:55 cait oleonard: could you take a look at bug 18372 maybe? 13:55 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18372 normal, P5 - low, ---, koha-bugs, NEW , transits are not created at check in despite user responsing Yes to the prompt 13:56 cait the patches supposed to have caused it are template related 13:56 oleonard Sure cait 13:58 cait thx! 14:00 tcohen andreashm, oleonard: I broke kohadevbox permissions for some tasks last week. I've just pushed the fix 14:00 tcohen so please, git pull your kohadevbox and rebuild 14:00 tcohen sorry :-D 14:01 tcohen i was for a good cause 14:01 tcohen (the refactoring) 14:07 tcohen cait: this is how the task is set in jenkins 14:07 tcohen + KOHA_USER=kohaadmin 14:07 tcohen + export KOHA_PASS=katikoan 14:07 tcohen + KOHA_PASS=katikoan 14:07 tcohen + export KOHA_INTRANET_URL=http://koha_16_11:8080/ 14:07 tcohen + KOHA_INTRANET_URL=http://koha_16_11:8080/ 14:07 tcohen + export KOHA_OPAC_URL=http://koha_16_11/ 14:07 tcohen + KOHA_OPAC_URL=http://koha_16_11/ 14:07 cait i don't really understand it - just know it fails 14:07 cait is the url maybe not correct? 14:12 tcohen it is a configuration issue in apache 14:13 cait sorry i am lost - i just want jenkins happy 14:15 tcohen i'm working on it, cait 14:15 tcohen it seems that the old way we handled the git clone on the server doesn't work 14:15 tcohen we had a Koha_Master_D8 dir 14:16 tcohen which was symlinked to Koha_16.11_D8 14:16 andreashm tcohen: what's the easiest way to pull and rebuild? in the past I think I've only deleted kohadevbox and re-installed (cloned). As there a smoother way? =) 14:16 tcohen andreashm: first run $ vagrant destroy 14:16 tcohen then $ git pull 14:17 tcohen then $ SKIP_WEBINSTALLER=1 CREATE_ADMIN_USER=1 vagrant up 14:17 tcohen all of that, on your kohadevbox clone 14:17 tcohen ah, I forgot 14:17 tcohen SYNC_REPO=your/koha/clone 14:17 tcohen if you use SYNC_REPO 14:17 andreashm ok. I use SYNC_REPO. Should I dd that as well? 14:18 andreashm heh, ok. thanks! 14:18 tcohen if you don't have it set on your environment, permanently (I do) 14:18 tcohen you need to add it 14:18 tcohen so $ SYNC_REPO=your/koha/clone SKIP_WEBINSTALLER=1 CREATE_ADMIN_USER=1 vagrant up 14:28 marcelr jajm: i hope to have addressed all points in the followup on 9988 14:29 jajm marcelr, ok thanks, i will take a look asap 14:29 marcelr thx 14:34 andreashm can't git pull since my devbox folder isn't a git repository. guess I'll just delete and reinstall. thanks though tcohen! 14:34 tcohen hi marcelr 14:35 marcelr hi tcohen 14:35 tcohen andreashm: wow 14:35 tcohen andreashm: have you tweaked the vars/user.yml file or just using the stock one? 14:36 andreashm tweaked probably. can't remember. =) 14:37 oleonard cait: Did you try to reproduce Bug 18372? 14:37 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18372 normal, P5 - low, ---, koha-bugs, NEW , transits are not created at check in despite user responsing Yes to the prompt 14:38 cait i got a bit lost reading it 14:38 andreashm tcohen: yeah, it's tweaked 14:38 oleonard I don't really understand how to reproduce it. I'm not asked whether or not the item should be transferred when I check in. Unless that depends on a preference I'm forgetting. 14:39 tcohen andreashm: then back it up :-D 14:40 tcohen and then delete the dir and 14:40 tcohen git clone https://github.com/digibib/kohadevbox.git 14:40 andreashm thanks, that was my plan! 14:41 andreashm thanks for reminding me about the user.yml file! 14:46 oleonard Ah yes, AutomaticItemReturn, which I turned on 10 years ago and then forgot about 14:47 tcohen Joubu: you have access to the jenkins server running D8 14:47 tcohen I created an alias for it 14:47 tcohen d8-jenkins.theke.io 14:48 cait oleonard: maybe something about returning it home or hold on the other branch? 14:48 cait ah cool 15:02 reiveune bye 16:28 oleonard Oh cool my kohadevbox thinks it's yesterday. 17:27 cait oleonard++ ! 17:27 oleonard 75 days since I last submitted a patch and I'm out of practice. 17:30 sjenson Greetings all. I made the mistake of restoring from the wrong Koha back up which shouldn't be a problem; however, I keep getting an error which reads: ERROR 1133 (42000) at line 2: Can't find any matching row in the user table 17:31 sjenson whenever I try to use the command Koha-remove 17:33 sjenson My basic google search suggests that I need to set a mysql root password, but I already have one 19:31 kidclamp andrewwk++ 19:34 kidclamp cait: have you seen bug 18400 on any of your sites? 19:34 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18400 normal, P5 - low, ---, oleonard, Needs Signoff , Noisy warns in opac-search.pl during itemtype sorting 19:35 cait hm haven't heard of it 19:35 cait but we are 3.22 19:36 cait kidclamp: did you see the bug i opened depending on 18264? 19:36 kidclamp yeah, I looked and wasn't sure of best way to fix 19:37 kidclamp but is in my head and on my list 19:37 kidclamp (it is not a short list) 19:53 rangi morning 19:54 Joubu kidclamp: t 19:54 Joubu kidclamp: there is something wrong with the itemnumber and barcode 19:54 Joubu on this patch 19:55 Joubu why do you want to display this "(blank)" string? 19:55 Joubu hi rangi 19:55 kidclamp it was a lazy fix for when we get an itemnunber that isn't found (very rare) 19:55 kidclamp the syntax came out funny 19:55 kidclamp fixing it more correctly right now 19:55 Joubu 55 my $inumber = $itemnumber ? "(blank) (itemnumber:$itemnumber)" : ""; 19:56 Joubu nope, the itemnumber exists 19:56 kidclamp itenumber exists but no item found 19:56 kidclamp or supposedly anyways 19:57 Joubu I am pretty sure this string cannot be displayed 19:57 Joubu and we should simply remove these 3 lines 19:58 Joubu using the itemnumber instead of the barcode shold be enough 19:58 kidclamp hmmm..you may be right now that I test 19:58 kidclamp I though there was a way to get there 19:59 * kidclamp has been wrong before, it will happen again 20:01 sjenson Yesterday, I restored from a backup because I upgraded from Ubuntu 14.04 to 16.04. Well, the back up I restored from is a few days older than I was expecting, so I am trying to delete the instance so that I can restore an older backup 20:01 sjenson However, I keep getting this error: ERROR 1133 (42000) at line 2: Can't find any matching row in the user table 20:02 sjenson I probably asked this question a couple of hours ago, but I thought I would try again. 20:07 Joubu sjenson: sounds like a mysql error 20:07 Joubu check the DB user 20:10 sjenson any suggestions on how to do that? 20:11 cait kidclamp: i thinkremoving the string sounds good - the barcode is not really mandatory in Koha, so people are probably ok 20:13 kidclamp yeah, I think i had my eye on allowing itemnumber addition in the future so tried to plan for that - fixed it so the error shows now, I think 20:17 Joubu sjenson: `xmlstarlet sel -t -v 'yazgfs/config/user' $KOHA_CONF` 20:17 Joubu to know your Koha user 20:18 Joubu Koha DB user 20:18 Joubu then check the user table of mysql 20:18 Joubu something like "use mysql; select user from user;" 20:22 sjenson thanks for pointing the way, Joubu. 20:27 cait kidclamp++ 21:43 cait Joubu++ thx for taking a look at the failing test 21:44 Joubu cait: sounds like a jenkins problem 21:44 cait maybe tcohen can find a fix 21:44 Joubu I'd not worry to much :) 21:44 cait it happened after i pushed things... so I was not sure 21:45 Joubu remembered what you pushed? 21:47 cait a couple of patches 21:47 cait should be visible by the dates sec 21:48 cait i think it was hte patches from march 26 21:48 cait trying to verify 21:48 cait yeah 21:48 cait last stable build was on march 20 21:52 cait i don't see an obvious candidate there - must be missing something 22:09 stplibrary I created a new Ubuntu Koha server and was working but imported the msysql database and now cant get past the login screen through the web. Get a HTTP 500 error. Any ideas or help would be greatly appreciated! 22:09 wizzyrea what's the exact error? 22:10 stplibrary Not really sure other than the web says HTTP internal web error on the browser 22:11 stplibrary It is a brand new Ubuntu server that I spun up and followed the steps to setup koha. then exported the database from the older koha and imported to the new one 22:12 wizzyrea are there any messages in the error log? 22:12 stplibrary where would I go to find those? 22:12 wizzyrea /var/log/koha/instancename/intranet-error.log 22:12 stplibrary and I can grab them for you really quick 22:12 wizzyrea where instancename is the name of your instance 22:13 stplibrary [Fri Mar 24 12:38:45.919825 2017] [cgi:error] [pid 53656] [client 192.168.2.0:34978] AH01215: [Fri Mar 24 12:38:45 2017] Auth.pm: DBD::mysql::db do failed: Table 'koha_library.systempreferences' doesn't exist [for Statement ": /usr/share/koha/intranet/cgi-bin/mainpage.pl 22:13 wizzyrea how old is "older" koha 22:13 stplibrary Let me see if I can find that I still have the old one running 22:14 wizzyrea i mean, that error is pretty clear that tables are missing in the database 22:14 wizzyrea only a couple of ways this can happen 22:14 stplibrary 3.18.02.000 22:14 wizzyrea 1. your database is so old that it doesn't have that 22:14 stplibrary yeah is there a good way to fix that to get the new one running? 22:14 wizzyrea (not the case) 22:14 wizzyrea 2. you imported the old database into your mysql server, but the import didn't go into the instance db 22:14 wizzyrea if you do a sudo koha-mysql instancename 22:15 wizzyrea and you show tables 22:15 wizzyrea does it have tables? 22:15 Joubu log is from March 24, is it right? 22:15 Joubu nothing newer? 22:15 wizzyrea could be that it's in the plack log 22:16 wizzyrea if it's new NEW koha 22:18 stplibrary when I imported I went to see what databases were listed and saw Koha_library. Thats what I imported into 22:18 stplibrary and what exported form in the old koha server 22:18 stplibrary *and what I exported form the old koha server 22:19 wizzyrea do you have a plack.log in your /var/log/koha/library directory? 22:19 wizzyrea is there anything in it? 22:19 wizzyrea or plack.err 22:21 stplibrary I dont see one 22:21 stplibrary indexer-error.log 22:22 stplibrary intranet-error.log 22:22 stplibrary updatedatabase_2017-03-24T14:51:38_3.1802000_16.1105000.log 22:22 stplibrary zebra-error.log 22:22 wahanui zebra-error.log is for the zebrasrv not the cron job 22:23 stplibrary okay :) 22:23 stplibrary im not seeing anything with plac in it 22:23 stplibrary *plack 22:24 stplibrary there are a lot of other error logs though 22:24 wizzyrea is there anything in the intranet-error.log? 22:24 stplibrary let me check really quick 22:25 wizzyrea more recent than march 24 22:25 wizzyrea like, from today. 22:27 stplibrary yeah is there an easier way to copy and paste these logs for you to see? 22:27 wizzyrea paste.koha-community.org 22:29 stplibrary [Tue Apr 11 18:06:50.517676 2017] [cgi:error] [pid 2757] [client 192.168.0.51:65495] AH01215: [Tue Apr 11 18:06:50 2017] mainpage.pl: LEFT JOIN categories on borrowers.categorycode=categories.categorycode WHERE borrowernumber = ?" with ParamValues: 0="523"] at /usr/share/koha/lib/C4/Members.pm line 443.: /usr/share/koha/intranet/cgi-bin/mainpage.pl, referer: http://192.168.0.60:8080/ 22:29 wizzyrea what version is your new Koha? 22:29 stplibrary The newest one that is out 22:30 stplibrary 16.11 22:30 wizzyrea have you updated the database since you imported it? 22:31 bag schema? 22:31 wahanui schema is tracked in git. or found at http://schema.koha-community.org 22:31 wizzyrea i.e. did you go through the installer 22:31 stplibrary I think I did I ran sudo apt-get update 22:31 stplibrary then upgrade 22:31 stplibrary unless I did it the wrong way 22:31 wizzyrea you could try 22:31 wizzyrea sudo koha-upgrade-schema library 22:32 wizzyrea that will force it 22:32 wizzyrea no output means it didn't need it 22:32 wizzyrea but it doesn't hurt to do it. 22:33 wizzyrea but from your error, it seems possible that the user you are trying to log in as is in a category that doesn't exist, maybe. 22:33 Joubu guess it's the MySQL strict_mode value again 22:33 stplibrary K I just ran it and looks like its complete 22:33 wizzyrea yes probably 22:33 wizzyrea mysql 5.7 22:33 wizzyrea ? 22:33 Joubu [ 22:33 Joubu oops 22:34 stplibrary I thinks Is there a good way to check 22:34 Joubu mysql --version 22:34 stplibrary yup its 5.7.17 22:35 Joubu https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7 22:35 Joubu take a look at this section of this page 22:35 wizzyrea mysql 5.7 is <reply> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7 22:35 wizzyrea mysql 5.7? 22:35 wahanui https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7 22:35 wizzyrea yay 22:35 Joubu excellent idea :) 22:36 stplibrary so do you recommend installing the mariaDB then? 22:36 stplibrary Sorry I am kind of new to this but trying to keep up :) 22:37 Joubu you have 2 options, pick the one you prefer 22:37 Joubu if you do not know, install mariadb ;) 22:37 stplibrary not sure what its telling me to do in option 2 to be honest 22:37 stplibrary okay lol 22:38 stplibrary so after the mariaDB installs is there anything else I have to do? 22:39 Joubu I don't think so 22:39 stplibrary Errors were encountered while processing: /tmp/apt-dpkg-install-QXZIwx/0-mariadb-server- 10.0_10.0.29-0ubuntu0.16.10.1_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1) 22:39 stplibrary Is that a normal error 22:40 Joubu not a all 22:40 Joubu not at all 22:40 Joubu what did you do? 22:41 stplibrary ran the command to install form the link 22:42 stplibrary sudo apt-get install mariadb-server 22:42 stplibrary The following packages have unmet dependencies: 22:42 stplibrary koha-deps : Depends: mysql-server or virtual-mysql-server 22:43 stplibrary ariadb-server : Depends: mariadb-server-10.0 (>= 10.0.29-0ubuntu0.16.10.1) but it is not going to be installed 22:43 stplibrary E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution). 22:44 Joubu then try the -f install 22:44 stplibrary Just ran it waiting for it to complete :) 22:45 stplibrary should I reboot after it installs or try browsing the web to the apache site? 22:45 Joubu wait it to finish before anything :) 22:46 stplibrary k lol 22:46 stplibrary K its done and browsed the web and now have a db connection software error 22:46 stplibrary DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at /usr/share/koha/lib/Koha/Database.pm line 90 22:48 Joubu stplibrary: sorry it's late here and I have to run. The easiest way is to follow the wiki page to install a new Koha install from scratch 22:48 Joubu using the deb package 22:49 wizzyrea yeah you'll do better if you koha-remove library 22:49 stplibrary ok no worries thank you for all of your help 22:49 Joubu it's very well explained and straightforward 22:49 stplibrary really appreciate it :) 22:49 wizzyrea then koha-create --create-db library 22:49 Joubu then copy your DB 22:49 wizzyrea then copy it, and import it 22:50 stplibrary do I ahve to copy it then delete it, create a new one then import? 22:50 wizzyrea do you still have the original export? 22:50 stplibrary yeah I do :) 22:50 wizzyrea if you do, then just use that 22:50 * Joubu closes the door silently 22:50 wizzyrea by Joubu :) 22:50 wizzyrea bye& 22:50 stplibrary bye thank you 22:51 stplibrary K ill try that then when I run it, it says that it already exists. so guessing I need to delete it then? 22:51 wizzyrea did you koha-remove? 22:52 stplibrary no i did not 22:52 wizzyrea do that first :) 22:53 stplibrary ERROR 1133 (42000) at line 1: Can't find any matching row in the user table 22:55 stplibrary that is the error I get when I try to remove "library" 22:56 wizzyrea heh 22:56 stplibrary I looked in mysql and the koha_Library is gone. Probably moved to mariaDB? 22:56 stplibrary seems to be one thing after another lol 23:11 stplibrary any ideas on getting this to work it wont let me remove the library to re-create it? 23:17 wizzyrea you want to look at creating users and granting permissions in mariadb 23:17 wizzyrea you kinda did it back to front 23:17 wizzyrea before you installed mariadb, you should have koha-remove 23:17 wizzyrea but 23:17 wizzyrea that's in the past 23:17 wizzyrea so now to get you out of it 23:18 stplibrary I do have checkpoints I can revert back to 23:18 wizzyrea what you need to do is create a user for koha_library 23:18 wizzyrea and grant it permissions on the koha_library database 23:18 stplibrary okay whats the best way to do that? :) 23:18 wizzyrea the username and password it is expecting are in /etc/koha/sites/library/koha-conf.xmlo 23:18 wizzyrea xml* towards the bottom 23:19 wizzyrea https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql 23:20 wizzyrea sorry I have to go away now 23:20 stplibrary thats okay thank you for your help 23:20 stplibrary really appreciate it 23:20 wizzyrea but you should be able to get somewhere by making sure the db in koha-conf.xml matches up with a database + user combination that exists in mariadb 23:21 stplibrary K I will work on that :) 23:21 wizzyrea once you can get sudo koha-mysql library to work 23:21 wizzyrea you'll know it's time to import your database 23:21 stplibrary are the commands differnet since I am using mariaDB now? 23:21 stplibrary for importing? 23:21 wizzyrea nope 23:22 stplibrary k sweet have a nice rest of your day or night :) 23:22 wizzyrea zcat name-of-your-dump.sql.gz | sudo koha-mysql library 23:22 wizzyrea or just cat dump.sql | sudo koha-mysql library 23:22 wizzyrea if it's not gzipped. 23:23 stplibrary awesome thank you 23:23 wizzyrea good luck 23:23 stplibrary thanks lol