IRC log for #koha, 2016-11-25

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
00:05 StomproJ joined #koha
00:06 papa joined #koha
00:17 papa joined #koha
00:20 dcook Mojolicious is still optional in Koha, yeah?
00:21 papa joined #koha
00:45 papa joined #koha
00:57 papa joined #koha
01:00 kathryn joined #koha
01:52 sunny joined #koha
01:55 sunny hello everyone! i come from china,my english is not good . i'm looking for help.
01:56 wizzyrea hi, we can help :)
01:56 (usually)
02:00 sunny thank you so much . i want to install koha on debian following the instruction about apache,mysql ,at the end ,there is a system maintenance
02:00 wizzyrea ok, Koha has two virtualhosts, you are going to the public (opac) one
02:00 you need to go to the staff interface one
02:01 sunny i want it run on local
02:01 or on lan
02:01 wizzyrea how are you accessing (with what address) what you are seeing now?
02:01 sunny 127.0.0.1
02:02 wizzyrea ok, in your apache configuration for the site /etc/apache2/sites-available/<instancename>.conf
02:02 you will see two virtualhost entries
02:02 the first one is labeled OPAC
02:03 the next one is labeled Intranet
02:03 sunny let me see
02:03 hold on
02:03 wizzyrea what you probably want to do is to put the intranet site on a different port
02:04 so then you'd access it with 127.0.0.1:8080 (just as an example)
02:05 or, you can paste what is in that config file to http://paste.koha-community.org
02:05 and let us look at what you've got in there :)
02:06 sunny ok .i just open <instancename>.conf
02:08 wizzyrea well <instancename> is what you called your instance when you created your instance
02:08 you did something like koha-create --create-db NAME
02:08 "NAME" is your instance name
02:08 sunny library is my instance name
02:09 wizzyrea so it would be /etc/apache2/sites-available/library.conf
02:09 sunny yes
02:09 wizzyrea :D
02:11 sunny "labeled OPAC" means servername:library-intra.mydnsname.org?
02:11 wizzyrea right, that will be the one you are seeing when you go to 127.0.0.1
02:12 sunny then i should visit "library-intra.mydnsname.org"?
02:13 wizzyrea that will work if you have dns set up for that
02:13 the other option is to change the top from 127.0.0.1:80 to 127.0.0.1:8080 for that intranet virtualhost
02:14 sunny it works
02:14 wahanui For now...
02:14 wizzyrea YAY
02:14 sunny thank you so much
02:14 wizzyrea you are welcome
02:14 sunny now i should do web install
02:15 wizzyrea yes!
02:16 sunny if someone in same lan, visit the addr too?
02:16 wizzyrea if they have DNS for it to point to your machine, it should work
02:16 (for linux you could define it in /etc/hosts)
02:20 sunny my koha server is virtual host. if i want visit with ip addr in lan,what should i do?
02:22 wizzyrea you would have to use ports to set the two virtualhosts apart
02:22 or you could configure the local hosts file to map the names without DNS
02:22 https://blog.kowalczyk.info/ar[…]tchosts-equi.html
02:23 ^ very small explanation
02:24 Stompro joined #koha
02:27 sunny thank you . i have a visiter ..wait for second
02:46 i am  so exciting to see "welcome to the koha web installer"  haha
03:01 irma joined #koha
04:04 Francesca joined #koha
05:44 drojf joined #koha
05:44 drojf morning #koha
05:44 irma joined #koha
05:44 * dcook waves
05:50 drojf hi dcook
05:53 dcook heya drojf :)
05:53 I'm working away on the OAI stuff..
05:53 Sooo many unit tests..
05:53 drojf heh
05:54 dcook It's been too long since I've contributed a patch via Bugzilla
05:54 I have no idea what will be accepted anymore
05:54 Oh... and I'll probably want to talk to you at some point
05:55 drojf you will find out :P
05:55 dcook I'm wondering if /var/spool/koha/<instance> has to be owned by root...
05:55 As it would be useful for other bits of Koha
05:55 That need to spool data for later processing
05:55 ie I want to save XML records there temporarily :p
05:55 drojf i think some parts are, others would break
05:56 dcook At a glance, I think the only thing in there are backups?
05:56 Which have root as an owner and a group of the koha-instance user?
05:56 drojf like, the config part of the backups is owned by root and the sql by koha user
05:56 i think
05:56 dcook Right, but the directory itself is owned by root, which prevents a person from changing directories into it
05:56 I was wondering if we could have the koha user own the directory
05:57 But keep the permissions for the files the same
05:57 * dcook emailed the listserv about this a while ago but got no response, but it doesn't quite seem like a Bugzilla issue
05:57 drojf oh, don't remember reading that
05:57 dcook I don't know Debian packaging well enough to craft a patch
05:57 I think it was a while ago.
05:57 Before you took over the packaging I think
05:58 drojf do you need the whole directory? if you want to have tmp xml data there, that coul dhave its own sub dir maybe
05:59 dcook Ideally I'd have a subdirectory
05:59 But I couldn't reach it if spool/<kohainstance> is owned by root
06:00 At least, with whatever the current permissions are
06:00 drojf you could if the sub directory us yours
06:00 is
06:00 dcook Yeah? Sweet
06:00 Yeah, that's all I need
06:00 drojf i don't see why not
06:01 but its 7 am and i did not have coffee :D
06:01 dcook I think you're right
06:01 I've found that to be the case on my phone
06:01 I can't always cd to a directory, but I can get to a subdirectory
06:01 Or maybe I'm thinking of something else
06:01 Let me do a little test..
06:02 Hmm I don't have a Debian system handy..
06:02 Vbox starts fast enough I guess..
06:02 * dcook waits
06:05 dcook Ok let's see..
06:05 We have /var/spool/koha/<instance>
06:05 755 root:root
06:05 Huh..
06:05 Oh... I see what I must've been thinking
06:06 Yeah, if I could get the package to create a subdirectory owned by the koha user that would be great
06:06 drojf: What would I need to give to you for that?
06:06 * dcook is very familiar with building RPMs now but needs to get to Deb packages..
06:07 drojf ok then i want a koha rpm package i return
06:07 lol
06:07 dcook : p
06:07 Not that hard really
06:07 The worst part is the deps
06:07 drojf that's always the worst part
06:07 dcook Which one person has actually put a repository up for..
06:08 * drojf sighs
06:08 dcook We should put that repo up somewhere
06:08 drojf oh nice
06:08 dcook drojf: scripts/koha-create-dirs ?
06:08 I think that's the one
06:08 drojf yes i think that is the thing
06:08 dcook Yiiiiisss
06:08 Ok, cool. I'll add a change to that
06:08 drojf yay
06:09 jois joined #koha
06:09 dcook I like how I solved that problem on my own in the end lol
06:09 jois hi
06:09 dcook The support was good though!
06:09 hey jois
06:09 drojf lol dcook
06:09 jois what is  MARC21?
06:09 wahanui somebody said MARC21 was at http://www.loc.gov/marc/biblio[…]hic/ecbdlist.html , http://www.loc.gov/marc/authority/ecadlist.html
06:14 drojf @wunder sxf
06:14 huginn drojf: The current temperature in Berlin Schoenefeld, Germany is -1.0°C (6:50 AM CET on November 25, 2016). Conditions: Light Freezing Fog. Humidity: 100%. Dew Point: -1.0°C. Pressure: 30.27 in 1025 hPa (Steady).
06:14 drojf oh
06:14 :/
06:17 dcook @wunder syd
06:17 huginn dcook: The current temperature in Sydney, Australia is 22.0°C (5:00 PM AEDT on November 25, 2016). Conditions: Clear. Humidity: 53%. Dew Point: 12.0°C. Pressure: 29.89 in 1012 hPa (Steady).
06:17 dcook Oh that's not too bad..
06:17 irma jois https://www.loc.gov/marc/faq.html MARC21 is a standard for entering bibliographic information into a computer record that can be used by library automation systems to provide a library catalogue.
06:18 dcook drojf: Hmm I think maybe I've screwed up Makefile.PL then if it's supposed to use scripts/koha-create-dirs
06:18 But it's 5:18pm..
06:20 jois is there any demo or video tutorials to learn all the features of koha?
06:20 dcook jois: Bywater Solutions have a bunch of Youtube videos
06:21 Hmm maybe I won't worry about Makefile.PL
06:21 I followed the same pattern as Zebra, and I think that'll be OK
06:21 I'm sure you'll tell me if it's wrong in the end, drojf : )_
06:26 StomproJ joined #koha
06:27 drojf dcook: it's only for debian, so makefile.pl is probably not the right place. but to be honest i never added a folder to koha before
06:36 cait joined #koha
06:46 juan_r joined #koha
07:07 z0k joined #koha
07:09 laurence joined #koha
07:12 LibraryClaire joined #koha
07:13 LibraryClaire hi #koha :)
07:14 drojf guten morgen GuteLauneKlara
07:14 * magnuse waves
07:14 LibraryClaire :D
07:15 laurence joined #koha
07:15 LibraryClaire moin drojf
07:15 hej magnus
07:15 magnuse guten morgen BüchereiKlara und drojf
07:15 LibraryClaire *magnuse
07:15 magnuse heute fahren wir nach hamburg!
07:15 drojf wie schön
07:15 magnuse ja, sehr gut!
07:15 LibraryClaire hihi
07:19 magnuse: how long are you going to be in Hamburg?
07:20 magnuse from this evening until midday wednesday
07:20 so 4 whole days
07:20 LibraryClaire nice :)
07:21 magnuse yup
07:22 went there for swib 3 years ago
07:34 marcelr joined #koha
07:34 marcelr hi #koha
07:34 LibraryClaire hi marcelr
07:34 marcelr hi LibraryClaire
07:35 fridolin joined #koha
07:46 alex_a joined #koha
07:46 alex_a bonjour
07:46 wahanui what's up, alex_a
07:54 Joubu Hi
07:54 wahanui privet, Joubu
07:54 fridolin hie there
07:54 LibraryClaire hi Joubu
07:54 reiveune joined #koha
07:55 reiveune hello
07:55 wahanui hey, reiveune
07:57 LibraryClaire hi reiveune
07:57 reiveune salut LibraryClaire
07:58 sunny joined #koha
07:59 ashimema joined #koha
08:02 wilfrid joined #koha
08:10 josef_moravec joined #koha
08:13 laurence1 joined #koha
08:22 Francesca joined #koha
08:27 AndrewIsh joined #koha
08:30 Francesca joined #koha
08:30 cait joined #koha
08:33 sophie_m joined #koha
08:33 gaetan_B joined #koha
08:34 gaetan_B hello
08:35 cait morning gaetan_B :)
08:35 morning #koha
08:35 gaetan_B morning cait :)
08:36 alex_a joined #koha
08:37 sunny hello. everyone,i got a problem.when i doing web installer step3,click "import", there is a sofeware error
08:38 cait which version?
08:38 wahanui well, which version is recommended?
08:38 cait and what is the error?
08:38 Joubu check logs to know what is the error
08:39 sunny DBIx::Class::Storage::DBI::_dbh-execute(): Date truncated for column 'type ' at......
08:39 koha 16.05
08:39 wahanui koha 16.05 is just 3.24
08:40 sunny stable
08:40 not old stable
08:41 my english is not well
08:41 drojf technically, it is oldstable now
08:41 but the repository is not changed yet
08:42 * drojf adds some confusion, leaves for tea
08:43 sunny should i re-install ?
08:47 Stompro joined #koha
09:02 Joubu sunny: nope, it seems that you are using MySQL > 5.6 or 5.7
09:03 sunny: try to remove the STRICT_TRANS_TABLES sql_mode from your mysql config file
09:19 alex_a joined #koha
09:45 eythian hi
09:45 wahanui salut, eythian
09:51 marcelr hi eythian
09:52 Francesca joined #koha
09:53 marcelr Joubu: bug 17676 why not do a CONVERT TO and only change tagsubfield afterwards in the old db rev 3.19 instead of going through all fields ? You did a convert for all other tables
09:53 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=17676 critical, P5 - low, ---, jonathan.druart, Signed Off , Default COLLATE for marc_subfield_structure is not set
09:54 Joubu marcelr: the convert will fail if there are lower and upercase
09:54 marcelr sure?
09:54 wahanui sure is :)
09:55 Joubu marcelr: I think I have tried yesterday yes
09:55 marcelr will do some testing too, thx
10:00 alex_a joined #koha
10:09 ashimema joubu.. do you understand the crazy syntax being used in paths.json for the swagger routing?
10:09 the ~1 cruft that's in there..
10:10 Joubu ashimema: no idea
10:10 ashimema It got dismissed with a sweeping statement of 'it's best practice' at the hackfest.. but I've never seen it anywhere before and googling turns up nothing.. and all it appears to do to me is make it much harder to read
10:10 :(
10:11 Joubu Is not a swagger separator?
10:22 ashimema it's nothing I've ever come across working with swagger for the past 2 years
10:22 in either swagger or mojo
10:23 to me.. it's adding crap for adding craps sake ;)
10:24 we've split up out spec way too much too.. I'm pretty sure I said not to split it the way it's ended up :(
10:24 you loose huge amounts of context
10:24 oh well
10:24 I'm coming back on the scene and intend on fixing lots of this..
10:24 but I'd really like to know the reasons behind some of e decisions in the first place..
10:25 * cait waves
10:26 Joubu you should see with Lari
10:26 lari: ^
10:46 marcelr Joubu: i once saw a change to lowercase in my testing, but cannot reproduce it anymore ;) no fails btw in 5.5
10:59 magnuse lunchtime!
10:59 wahanui lunchtime is a terrible time for a meeting
10:59 magnuse so true
11:47 petter joined #koha
11:53 magnuse kia ora petter!
11:53 have fun #koha!
12:00 petter hei magnus!
12:25 lari ashimema: hi :) ! the crazy ~1 is an escaped slash in JSON pointer, as defined in https://tools.ietf.org/html/rfc6901#section-3
12:28 ashimema hmm.. it's nice to have a reference for it
12:29 I think we loose too much context with the way we split up our spec
12:41 marcelr bug 17681
12:41 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=17681 trivial, P5 - low, ---, m.de.rooy, Needs Signoff , Exiisting typos might thow some feees when recieved
12:41 marcelr i like the title
12:48 cait hm no kidclamp
12:50 marcelr hi cait
12:51 you don't have a branch yet ?
12:52 lari ashimema: can you explain your thoughts bit more? what would you prefer instead? maybe e-mail me
12:53 rsantellan joined #koha
12:53 rsantellan good morning #koha
12:56 alex_a joined #koha
13:15 ashimema lari.. when i get a moment I'll submit a patchset to tidy them into a more manageable standards based set of splits..
13:16 things like moving parameters out of the path definition make very little sense.. you need that context in the path definition to understand what the route is meant to do
13:20 Dyrcona joined #koha
13:29 cait @later tell marcelr I don't think so - the plan is to start on monday, but no bug fixes pushed so far
13:29 huginn cait: The operation succeeded.
13:39 drojf joined #koha
13:49 alex_a joined #koha
14:41 fridolin whaaouuuu Bug 15111
14:41 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=15111 critical, P5 - low, ---, kyle, RESOLVED FIXED, Koha is vulnerable to Cross-Frame Scripting (XFS) attacks
14:41 fridolin it means Koha staff interface can to be used without JS anymore
14:41 0%
14:41 its a choc
14:41 i was running with JS off via Firebug for tests
14:43 ashimema_ joined #koha
14:45 laurence joined #koha
15:17 rsantellan joined #koha
15:36 LibraryClaire laters #koha
15:37 LibraryClaire left #koha
15:45 liw I sent a mail to koha-devel a little while ago, but it's not gone through. I the list moderated for non-subscribers? I've since subscribed, but that' be too late
15:45 drojf liw: i bet it is, the main list is too. for spam reasons
15:46 liw: resend? or poke someone at biblibre, but i forgot who does the mailing lists
15:46 liw I fully understand
15:46 drojf If you are having trouble using the lists, please contact mailman@lists.koha-community.org.
15:46 liw I could resend but it might result in duplicates if the moderator approvaes the first one  later
15:47 but that might be an acceptable risk
15:47 drojf just resend
15:47 we will survive a duplicate
15:47 liw ok, thanks
15:51 drojf tl;dr
15:51 :P
15:52 liw heh
15:52 drojf liw: i think rangi brought up qvarn at an irc meeting but we postponed it (or i forgot what it was about). i did not know you are involved
15:54 ah. http://irc.koha-community.org/[…]6-11-09#i_1876711
15:54 don't remember that at all, i guess i missed it
15:55 cait liw++ :)
15:55 ashimema_ didn't realise you had anything to do with qvarn liw
15:56 liw we do have dbix::class and koha::objects..
15:57 cait just the transition time is a little odd
15:57 ashimema_ and the codebase is generally being refactored to use them.. it just takes times
15:57 cait 2014?
15:57 wahanui 2014 is probably gonna be great
15:58 drojf rangi changed it to end of next year in the meeting
15:58 according to the log
15:59 "The regulation was adopted on 27 April 2016. It enters into application 25 May 2018 after a two-year transition period"
15:59 https://en.wikipedia.org/wiki/[…]ection_Regulation
16:00 reiveune bye
16:00 reiveune left #koha
16:01 ashimema_ Qvarn is interesting.. and you've identified my biggest issue with koha.. that controller and model are not well separated yet.. but I don't tihnk we're in any position to switch to 'yet another data store' any time soon.. we need to actualyl abstract out the model first.. be that koha::objects, dbic whatever
16:02 that's my thoughts anyways
16:04 liw ah, I didn't notice there was already  movement towards the abstraction I was suggesting
16:05 ashimema_ yeah.. it's slow and painful ;)
16:05 liw I don't expect Qvarn adoption by Koha, if it ever happens, to happen soon. big old code bases move slowly
16:05 ashimema_ yeah..
16:05 I am interesting in Qvarn though.. I don't entirely understand it's use case though yet ;)
16:06 to me it feels like another datastore (elastic search, mongdb, postgres, mysql even) with a secure web facing api
16:06 I'm likely missing somthing
16:09 with an IdP built in
16:10 I really want to built OAuth2 Authorization into koha's rest api and adopt OpenID Connect for authentication.. so perhaps Qbarn can give us some of that 'for free' as such?
16:11 liw ashimema_, qvarn uses openid connect (which is built on top of oauth2) and the idp (gluu) is installed with it, yes
16:12 ashimema_, also I think you understand qvarn fairly well, in fact; it doesn't do much (no application logic, for example), but tries to do what it does well
16:14 ashimema_ :)
16:18 ashimema is it meant as a central location for just the personal data.. so is one meant to use it alongside an application level datastore?
16:18 * ashimema is still digging into the use case ;)
16:22 liw it's meant to be the storage backend for a web application, the way a relational database is (butt with better privacty)
16:22 ashimema I don't understand how it provides better privacy I suppose
16:22 that's the missing link in my head I think
16:23 I'm spamming the main chat.. sorry everyone..
16:23 drojf ashimema: please go on
16:24 not much to contribute but interested and reading
16:24 rsantellan same here
16:24 ashimema I feel I'm asking the right questions.. though I might be appearing a bit ignorant/dim ;)
16:24 liw ashimema, all access goes via a single point that provides much more detailed access control than sql does
16:26 I'm not sure I'm good at explaining this either
16:27 ashimema So.. in my head
16:27 fridolin left #koha
16:27 ashimema one accesses a datastore as a 'user', and that user has certian rights to take certain actions on various bits of that datastore
16:28 in the SQL world, said user can be limited down to the table level as to what they can do with that data (select, update, insert, delete etc, etc)
16:28 the 'user' in 99% of cases is actually the 'application' and thus is usually given lots of rights all over the place..
16:29 and then the application is responsible for the 'person' whose accessing the application to only be able to retrieve the data they have rights upon
16:29 am I right in thinking that qvarn in effect brings this layer 'in house'
16:30 i.e. your always looking at data from an individual 'persons' stance as a posed to the 'application'
16:30 liw with qvarn the actual user and the application can authenticate separately (though this isn't fully done yet), and access control can be decided (once qvarn is written to support it) based also on things like strength of authn
16:30 ashimema ahh.. strength of authn
16:30 ok.. now that sounds like a fairly nice addition
16:30 liw (or time of day or whatever one can implement)
16:31 ashimema interesting
16:31 wahanui interesting is, like, sometimes good and sometimes bad
16:31 liw ashimema, and yes, bringing it "in house" is a good way to describe it
16:33 ashimema so is the application developer responsible for saying what authorization level different data's are restricted to?
16:34 so it sort of feels like just trying to standardise a description of access
16:34 liw yeah
16:35 ashimema cool.. I understand.. it's a strong encouragement.. practically enforcement once you've made the choice to use qvarn.. to follow privacy best practices.. that many of us overlook with current systems
16:35 I see..
16:35 is there anything to prevent the developer from just say.. sod this i'll attach with the highest access user to make my life easier when developing
16:35 which is in effect what people do now ;)
16:36 So koha as an example
16:36 we connect to mysql/postgres with an all powerful db user
16:36 liw one aspect koha would need to deal with is the modelling of the data into json objects, which is potentially a lot of work but can be good in the long run; also, qvarn support versioning of resource types and handsles most of the schema changes automatically, in case that's of interest
16:37 ashimema it's then upto the application logic to prevent leaks.. which we're mostly good at catching during qa
16:37 liw ashimema, the app doesn't get to choose, the "sysadmin" configures that in Gluu
16:37 ashimema in the qvarn sense.. because your connecting to the datastore with a reduced privilege the code wuoldn't be able to continue unless it's written well enough to deal with the restricted privilege
16:38 coolios.. yes.. i do undertsand then now
16:39 liw sounds like you do, yes
16:40 ashimema so.. Gluu, the IdP authenticates the 'person' and the 'application'..  (as that's what an IdP does).. the rights of what the application can do on the persons behalf with their data are defined in Gluu.
16:40 liw qvarn isn't the ultimate solution to every problem in computing. give me time :)
16:40 rsantellan liw: I understand in a sense the borrowers information becuase acording to qvarn is dealing with sensitive nature data, but I don't see the benefit of moving all the data from a relational DB to qvarn
16:41 liw rsantellan, that's a good point
16:41 ashimema so Gluu is the abstraction of where the levels of permissions go.. Qvarn is the thing that understands those permissions relations to actual data
16:41 liw ashimema, yep
16:41 ashimema yeah.. what rsantellan said ;)
16:42 I do like the idea of a nice centralised place to do permissions.. it's axactly what I've been working on in one of my projects
16:42 only I've not yet extracted it into the IdP layer
16:42 perhaps Qvarn is where I should be going with that
16:42 (with Gluu)
16:43 I think you could say.. all data is sensitive once context is gained
16:43 so keeping all the data in the same place, then having an overall abstraction for the permissions for each piece of it makes sense to me.. I think
16:43 liw I would keep all data in qvarn, but a) I'm clearly biased and b) I don't like sql :)
16:44 ashimema one of the biggest anoyances koha side liw is our reports system.. it's fantastically flexible as it's just 'plain sql' based..
16:44 which is great for customers.. but a nightmare if you want to change schema at all.. because all the public 'copy/paste' sql reports break
16:45 haha
16:45 * ashimema has to go feed hungry kids
16:45 ashimema thanks for the chat.. been really enlightening
16:45 liw no worries
16:47 rsantellan liw: how you deal with queries on qvarn?
16:48 liw rsantellan, the qvarn api has searches, https://github.com/qvarn/qvarn[…]verview.yarn#L695 describes them
16:56 rsantellan liw: after reading the docs is hard for me to think why migrate all data, I think that only the borrowers is worth saving there. But thats just my humble opinion, I'm no expert
16:58 liw rsantellan, I have to leave that decision to Koha developers, since I know so little of Koha
17:14 laurence left #koha
17:30 lisettelatah joined #koha
17:31 cait left #koha
18:02 cait joined #koha
18:15 laurence1 joined #koha
18:16 laurence1 left #koha
19:04 cait joined #koha
19:57 JoshB joined #koha
22:38 Francesca joined #koha
23:07 Francesca joined #koha
23:10 Francesca joined #koha
23:30 Francesca joined #koha
23:51 Francesca joined #koha

← Previous day | Today | Next day → | Search | Index

koha1