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