IRC Logs

Time Nick Message
00:04 wizzyrea excellent
00:35 JStall Hello! Does anyone have experience with running a single Koha instance through AWS? I have a trial installation running for a small school, but am unsure which tier is appropriate for our needs.
00:43 dcook Mmm, I've run Koha on AWS, but only for backup sites
00:43 dcook This sort of falls into a question which never seems to really have an answer, and that's "what specs does Koha need" :/
00:45 dcook We tend to run on beefy servers, so I don't know how little Koha needs
00:45 JStall Ok. Haha, that is precisely my question. We attempted to begin cataloging this week, but (I believe) the limited memory of the old t1.micro instance threw a wrench into the plan.
00:45 dcook Let's see. The micro is 1GB, which is pretty small.
00:46 dcook By any standard I think.
00:46 dcook There's lots of components with Koha. You have Apache, MySQL, Perl, Zebra...
00:46 dcook I'm not sure how memory hungry Zebra is
00:47 dcook JStall: When you say threw a wrench in the plan, what happened?
00:47 dcook Difficulty loading the web page or with records showing up?
00:48 JStall Full mysql crash. DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' etc...
00:49 dcook Hmm any MySQL logs to explain what happened exactly?
00:49 JStall Had to relaunch the instance. To be fair, I had six people cataloging at one time, which is probably a heavy strain on the database, but I would have thought it could handle it.
00:50 dcook Yeah, I wouldn't think that would be too bad
00:50 dcook Heavier if they're using Z39.50 I guess
00:50 JStall Sure! Should I paste it here, or...
00:50 JStall They were. And authority records, as well.
00:50 dcook http://paste.koha-community.org/
00:51 dcook Yeah, all the Z39.50 records found are stored in the database, so I suppose that could be a bit heavy
00:51 dcook Or at least the 20 or so fetched each time are stored in the database
00:51 pastebot "JStall" at 127.0.0.1 pasted "MySQLerror" (28 lines) at http://paste.koha-community.org/92
00:52 dcook Based on this: https://aws.amazon.com/ec2/instance-types/ it sounds like the t2 machines are meant more for temporary work or really low traffic web apps
00:52 dcook Ah, nothing before that?
00:53 JStall Let me pull a more recent log.
00:53 dcook I was hoping to see an error messag before it crashed
00:55 dcook fwiw, we tend to use servers in the upper-middle M4 range by AWS standards, but that's for more than a single Koha... and that's not including the database server which we have separate
00:57 JStall We are not opposed to a local server, but wanted to explore all options. I'm not in IT, so any local hiccup would be a major issue.
00:59 pastebot "JStall" at 127.0.0.1 pasted "MySQLlog2" (255 lines) at http://paste.koha-community.org/94
01:00 dcook Yeah, it looks like there's not enough memory
01:00 dcook It might be worth looking into how much memory MySQl needs specifically I suppose
01:01 dcook And maybe look at what else is using up the memory at the same time. Like I said before, 1GB isnt' much
01:01 dcook My mobile phone has 1GB of RAM, and it's sluggish :p
01:01 dcook And that's with a single user
01:03 JStall Okay. I'm glad to know I'm reading this correctly. Haha that's about right.
01:04 dcook Just took a casual look at our servers
01:05 dcook For regular middday activity, Apache and Zebra don't seem to be consuming much memory (at least relatively)
01:05 dcook But MySQL does seem to have quite a bit
01:06 dcook Not sure how the numbers would track for a small install though
01:06 dcook Since we're a vendor supporting multiple databases
01:07 dcook Looks like our MySQL is configured to have a very large buffer pool as well
01:07 dcook Yours appers to be 128MB while ours is about 10GB
01:07 JStall Okay. One option I've seen is reducing the innodb buffer pool size to something tiny, like 16M. That would slow the process down considerably, but might reduce the crashing?
01:08 JStall Ha! Very good.
01:08 dcook Yeah, although you probably want something bigger than a t2.micro in any case
01:08 dcook Trying to think of what I have on my desktop at home..
01:09 dcook I think my desktop at home has 2 CPUs and 4GB of RAM, and it seemed to handle me using a single Koha on it just fine
01:09 dcook Obviously a bit tougher with 6 people rather than 1 but...
01:09 dcook I should add that I'm not much of a sysadmin :p
01:10 dcook Well, sysadmin is easy enough. I don't spec our servers though :p
01:10 JStall Okay. So my best option would be to go with a large AWS instance @ 8GB, then reduce if necessary.
01:11 JStall Fair enough! I'm learning all of this as I go, so it is good to hear from someone who has more experience.
01:14 JStall Or, I could do a local install to get a good sense of our numbers and then move to remote servers better informed.
01:17 dcook Oh, I don't know if I have more experience :p
01:18 dcook If you can afford a large instance, that's probably not a bad way to go
01:18 dcook I let our server people take care of all the hardware
01:18 dcook I just deal with software
01:23 JStall Either way, I appreciate it!
04:51 dcook liw: Read http://liw.fi/swimming-upstream/ last night. Very informative!
06:50 marcelr hi #koha
07:00 liw dcook, :)
07:07 morgane hi #koha
07:41 cait morning #koha
07:42 LibraryClaire morning #koha
07:43 LibraryClaire @wunder LCY
07:43 huginn LibraryClaire: The current temperature in London City, United Kingdom is 20.0Â°C (8:20 AM BST on August 26, 2016). Conditions: Partly Cloudy. Humidity: 68%. Dew Point: 14.0Â°C. Pressure: 30.04 in 1017 hPa (Steady).
07:43 drojf morning #koha
07:44 LibraryClaire hi drojf :)
07:46 drojf guten morgen LibraryClaire :)
07:48 sophie_m1 hello #koha
07:52 LibraryClaire hi sophie_m
07:52 sophie_m hi LibraryClaire :)
07:59 * cait waves
07:59 LibraryClaire hi cait :)
08:01 cait :)
08:10 marcelr hi cait LibraryClaire drojf and sophie_m
08:11 marcelr Joubu: still in the first patch..
08:11 drojf hi marcelr
08:11 LibraryClaire hi marcelr :)
08:11 Joubu marcelr: the second one is the funny one
08:12 marcelr i would have liked to go faster :)
08:33 eythian @wunder ams
08:33 huginn eythian: The current temperature in Schiphol, Badhoevedorp, Netherlands is 23.6Â°C (10:32 AM CEST on August 26, 2016). Conditions: Scattered Clouds. Humidity: 76%. Dew Point: 19.0Â°C. Pressure: 29.98 in 1015 hPa (Steady).
08:34 eythian that more nicer
08:34 LibraryClaire hi eythian
08:34 eythian hi there LibraryClaire
08:34 eythian (because it rhymes)
08:35 LibraryClaire :P
08:36 drojf @wunder berlin, germany
08:36 huginn drojf: The current temperature in Berlin Tegel, Germany is 25.0Â°C (10:20 AM CEST on August 26, 2016). Conditions: Clear. Humidity: 44%. Dew Point: 12.0Â°C. Pressure: 30.04 in 1017 hPa (Steady).
08:36 drojf @wunder txl
08:36 huginn drojf: The current temperature in Rue du Capitaine Jean Maridor, Berlin, Germany is 26.1Â°C (10:36 AM CEST on August 26, 2016). Conditions: Clear. Humidity: 51%. Dew Point: 15.0Â°C. Pressure: 30.04 in 1017 hPa (Steady).
08:36 drojf @wunder sfx
08:36 huginn drojf: Error: HTTP Error 404: Not Found
08:36 drojf @wunder sxf
08:36 huginn drojf: The current temperature in Berlin Schoenefeld, Germany is 25.0Â°C (10:20 AM CEST on August 26, 2016). Conditions: Clear. Humidity: 47%. Dew Point: 13.0Â°C. Pressure: 30.06 in 1018 hPa (Steady).
08:36 marcelr drojf: to Texel again?
08:37 drojf :D
08:37 marcelr @wunder Texel
08:37 huginn marcelr: The current temperature in Roggeslootweg, De Cocksdorp, Netherlands is 19.8Â°C (10:31 AM CEST on August 26, 2016). Conditions: Mostly Cloudy. Humidity: 94%. Dew Point: 19.0Â°C. Pressure: 29.98 in 1015 hPa (Steady).
08:37 drojf i would like to have the temperature i get with "berlin, germany" without typing all that
08:37 marcelr sure just @wunder should be enough; he knows you
08:38 LibraryClaire @wunder LCY
08:38 huginn LibraryClaire: The current temperature in London City, United Kingdom is 21.0Â°C (9:20 AM BST on August 26, 2016). Conditions: Partly Cloudy. Humidity: 64%. Dew Point: 14.0Â°C. Pressure: 30.04 in 1017 hPa (Steady).
08:38 eythian @wunder berlin, de
08:38 huginn eythian: Error: No such location could be found.
08:38 marcelr @wunder me
08:38 huginn marcelr: Error: No such location could be found.
08:38 marcelr @wunder home
08:38 huginn marcelr: Error: No such location could be found.
08:38 marcelr sorry
08:39 cait @Konstanz
08:39 huginn cait: I suck
08:39 cait @wunder Konstanz
08:39 huginn cait: The current temperature in LuisenstraÃƒ&#376;e, Konstanz, Germany is 20.4Â°C (10:37 AM CEST on August 26, 2016). Conditions: Partly Cloudy. Humidity: 88%. Dew Point: 18.0Â°C. Pressure: 30.12 in 1020 hPa (Steady).
09:21 drojf created twitter account, got blocked for being a bot after 10 minutes. awesome network
09:24 cait lol
09:24 cait what wa the twitter account for?
09:27 eythian testing bots
09:31 drojf this
09:31 drojf don't know yet. see if i want to use one for koha and tech stuff or not
09:31 drojf after my user experience so far, it's "not"
09:33 drojf i wonder what automated stuff i did. by not following anyone or tweeting anything
09:33 drojf they probably banned me for turning off a lot of bad settings
09:34 drojf and not following any of the shit accounts they promoted
09:34 chrisse linkeidn is even worse. can't even remember why I took that route
09:36 drojf not going there :)
09:36 chrisse now all kinds of acquaintances are promoting my skills. I guess the system forces them to do that
09:37 drojf i bet there is some free software decentralized selfhosted network that lacks standard functionality and has a two digit number of users that i would like
09:37 eythian drojf: indenti.ca
09:37 drojf isn't that dead?
09:38 eythian no
09:38 drojf yes
09:38 drojf pump was never really alive
09:38 drojf unless something magical happened in the last year
09:38 drojf i have actually set up instances of gnusocial and pump to try
09:38 eythian I'm sure I've seen people using it
09:39 drojf ok. but the software is not evolving, and it lacks basic functionality
09:39 eythian <drojf> i bet there is some free software decentralized selfhosted network that lacks standard functionality and has a two digit number of users that i would like
09:39 eythian I don't see how this doesn't fit your requirements
09:39 drojf true
09:39 drojf it was what i had in mind when i said that :P
09:40 drojf CHANGELOG.md Finalize 1.0.0 changelog a day ago
09:40 drojf wow
09:40 eythian sounds like it's exactly what you want then
09:40 drojf maybe there is actually something happening
09:40 eythian heh
09:40 drojf 1.0.0 - 2016-08-26 [unreleased]
09:40 drojf great timing
09:41 drojf it did not look bad really. but it could not do a lot of things.
09:41 drojf not sure if there is more now
09:41 drojf or just the number ^^
09:41 eythian which is a pity, the original identi.ca was relatively featureful when compared to things like twitter
09:42 drojf what was it called? before it was gnusocial? was the software identica too?
09:42 eythian yeah
09:42 drojf or was it something else. i get confused
09:42 eythian it was identi.ca
09:42 eythian that was the software and the (most commonly used) service
09:43 drojf statusnet is what i mean
09:43 eythian ah that's right
09:44 eythian I think identi.ca software became statusnet, or something
09:44 eythian my memories are hazy
09:44 eythian I also haven't seen MauvePornoRod (who was the author of it all) around IRC in the past few years.
09:44 drojf and then they gave it away to be gnusocial, switched to pump but that was pretty basic
09:45 eythian (* it's an anagram of his name.)
09:45 drojf lol
09:45 drojf that you came up with on the spot while typing?
09:46 eythian nono, that was his IRC nick sometimes
09:46 LibraryClaire lol
09:47 drojf does not look like they added features, looks more like security
09:47 Joubu @later tell tcohen it seems there is something wrong on master_D8: "Makefile:21750: recipe for target 'pm_to_blib' failed"
09:47 huginn Joubu: The operation succeeded.
09:47 drojf going from 0.3 to 1.0 after two years of no visible action, i gues they are just abandoning it finally
09:48 drojf guess
10:09 eythian @wunder ams
10:09 huginn eythian: The current temperature in Schiphol, Badhoevedorp, Netherlands is 23.8Â°C (12:02 PM CEST on August 26, 2016). Conditions: Partly Cloudy. Humidity: 73%. Dew Point: 19.0Â°C. Pressure: 30.01 in 1016 hPa (Steady).
10:09 eythian I think it'll be a lunch on the roof sort of day
10:10 LibraryClaire @wunder LCY
10:10 huginn LibraryClaire: The current temperature in London City Airport, London, United Kingdom is 24.4Â°C (11:03 AM BST on August 26, 2016). Conditions: Partly Cloudy. Humidity: 60%. Dew Point: 16.0Â°C. Pressure: 30.06 in 1018 hPa (Steady).
10:10 LibraryClaire feels like a nap in the shade sort of day
10:11 drojf @wunder berlin, germany
10:11 huginn drojf: The current temperature in Berlin Tegel, Germany is 28.0Â°C (11:50 AM CEST on August 26, 2016). Conditions: Clear. Humidity: 35%. Dew Point: 11.0Â°C. Pressure: 30.04 in 1017 hPa (Steady).
10:11 drojf meh
10:45 Joubu kidclamp: Are you working on bug 17201?
10:45 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17201 normal, P5 - low, ---, gmcharlt, NEW , Remaining calls to C4::Context->marcfromkohafield
10:45 Joubu otherwise I take it
10:46 kidclamp you can take it :-)
11:54 LibraryClaire @wunder LCY
11:54 huginn LibraryClaire: The current temperature in London City Airport, London, United Kingdom is 25.9Â°C (12:48 PM BST on August 26, 2016). Conditions: Partly Cloudy. Humidity: 54%. Dew Point: 16.0Â°C. Pressure: 30.09 in 1019 hPa (Steady).
12:04 cait LibraryClaire: nap sounds good....
12:05 LibraryClaire in desperate need of a nap
12:09 marcelr bye #koha, no qa anymore this week
12:16 oleonard cait: Regarding Bug 11019, I wonder if it's actually a bug that you find it necessary to add an empty authorized value
12:16 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11019 normal, P5 - low, ---, oleonard, In Discussion , Require some fields when adding authorized value category
12:17 oleonard Although I find the example you gave doesn't appear valid because the patron entry form automatically provides an empty choice.
12:17 cait oleonard: probably - but it's not the only spot
12:17 oleonard Also, Hi!
12:17 cait hm
12:17 cait maybe it's a version problem
12:18 cait would need a bit more testing
12:19 cait hm same for bsort?
12:20 oleonard I'd have to test that. I don't have any values for bsort1 in my test system.
12:20 * oleonard doesn't really understand how it's used in real life
12:23 tcohen bonjour
12:23 wahanui niihau, tcohen
12:24 LibraryClaire hi tcohen :)
12:24 cait it provides you with a pull down in statistic 1 and statistics 2 if you want that
12:24 cait we have libraries using it to indicate the faculty, or a class
12:24 cait it's handy because easy to update and import - easier than the extended attributes
12:25 cait oleonard: another example might be a pull down list linked to a marc field
12:31 cait oleonard: if you leave a ocmment, i'll retest
12:34 oleonard Allowing a blank entry is certainly easier than updating all the templates to make sure they provide a blank option, but somehow feels less clean to me.
12:35 cait i agree
12:35 cait i could still do it with sql...but it's tedious
13:11 tcohen bonjour (bis)
13:11 huginn New commit(s) kohagit: Bug 16699: (QA followup) Move minified swagger file into the swagger/ dir <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=53631f9ffdc86c1afbcc3108ac3ddf1f73fef40e> / Bug 16699: Remove requirement from borrowernumberQueryParam <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=eeab7d0666677e3bb7ec4e56bcb5a7164aeab48e> / Bug 16699: Move Swagger-related files to api/v1/swagger <http://git.koha-co
13:21 oleonard Hi tcohen and other waking-up people
13:22 nengard hi oleonard
13:22 wahanui hi olÃ© onard
13:23 oleonard hi wah! anui
13:23 LibraryClaire hi oleonard
13:23 wahanui hi olÃ© onard
13:23 * LibraryClaire doesn't feel woken up
14:07 oleonard Maybe cait has strong feelings about dates in vendor contracts? Bug 16754
14:07 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16754 enhancement, P5 - low, ---, oleonard, Failed QA , Use validation plugin in budgets, planning, and contracts
14:17 oleonard I mean, who /doesn't/ have strong feelings about dates in vendor contracts, amirite?
14:19 Joubu me! :d
14:33 drojf can we find a consistent way of labelling releases/ fixes "security"? all new releases contain xss patches, 3.20 and 3.22 are labelled security release in the emails, 16.05 is not. 16.05 lists the fixes under the headline "Critical bugs/ Koha", 3.22 as "Security bugs fixed" on top of the list, 3.20 as "Critical bugs/ Koha" like 16.05. 3.22 features "security" in the release notes headline (and so in the URL in wordpress), the others don't
14:33 drojf if i would have known i'd write that much i would have made it an email. lol
14:33 drojf sorry
14:34 drojf anyway, if people got thoughts about it â€¦ :)
14:42 eythian drojf: come up with a solution, write it up in an email, and say "unless there are objections, we should do it this way", then everyone will be all "oh, that makes sense."
14:42 eythian otherwise no one will change anything.
14:42 drojf eythian: that is kind of what i am doing
14:42 drojf :)
14:43 drojf yes you are right
15:02 Joubu drojf: that makes sense
15:08 tcohen tig
15:08 tcohen oops
15:09 drojf tcohen: that's a short password
15:10 tcohen he, nah
15:10 tcohen that's my favourie tool for git repo browsing
15:10 * oleonard thought maybe tcohen set up his computer so that he has to type everything backwards
15:12 tcohen haha
15:12 tcohen try tig, is awesome ;)
15:14 oleonard Neat
15:15 morgane bye #koha
15:15 tcohen bye!
15:22 LibraryClaire laters #koha
15:22 Joubu good week-end #koha
15:26 cait drojf++
16:29 oleonard Anyone else get an error when trying to view the contents of a list in the staff client?
16:30 oleonard Oh never mind I was on an unrebased branch
16:36 drojf @wunder berlin, germany
16:36 huginn drojf: An error has occurred and has been logged. Please contact this bot's administrator for more information.
16:36 drojf huh
16:36 drojf @wunder txl
16:36 huginn drojf: The current temperature in Rue du Capitaine Jean Maridor, Berlin, Germany is 36.0Â°C (6:31 PM CEST on August 26, 2016). Conditions: Clear. Humidity: 20%. Dew Point: 10.0Â°C. Pressure: 30.01 in 1016 hPa (Steady).
16:36 oleonard @wunder 45701
16:36 huginn oleonard: An error has occurred and has been logged. Please contact this bot's administrator for more information.
16:36 oleonard @wunder 45764
16:36 drojf @wunder berlin, germany
16:36 huginn oleonard: The current temperature in kimberly ohio, Nelsonville, Ohio is 31.2Â°C (12:29 PM EDT on August 26, 2016). Conditions: Clear. Humidity: 66%. Dew Point: 24.0Â°C. Pressure: 30.15 in 1021 hPa (Steady).
16:36 huginn drojf: An error has occurred and has been logged. Please contact this bot's administrator for more information.
16:37 drojf hm
16:40 drojf i guess the weather station has melted
17:26 drojf @wunder txl
17:26 huginn drojf: The current temperature in Rue du Capitaine Jean Maridor, Berlin, Germany is 34.5Â°C (7:21 PM CEST on August 26, 2016). Conditions: Clear. Humidity: 23%. Dew Point: 11.0Â°C. Pressure: 30.01 in 1016 hPa (Steady).
17:33 cait :)
18:19 montes hello i am a newbie in every sense
18:19 montes i am trying to work on a project and need assistance
18:20 kidclamp welcome montes
18:20 kidclamp ask away
18:21 montes I am trying to see if it is possible to create alerts for holds withing the day.. where it doesn't take 24 hours to receive notification
18:21 montes the alerts would go to designated staff
18:22 montes I need to find out where I can populate the staff who whould receive the alert (email)
18:23 montes and then figure out how I can retrieve hold alerts during the day.
18:25 montes somehow I feel I don't have the permissions.. but if you can point me in the direction of where I can fiddle with this...I can find out if I lack permission and then try to find out how I can get permission.
18:25 kidclamp montes - I believe the message is sent to the library's address in the library information page of administration
18:26 montes let me see
18:26 kidclamp the emails should be entered into the message_queue - the timing of them being sent relies on the frequency of the process_message_queue.pl cronjob
18:26 kidclamp your server administrator will need to adjust that
18:31 montes kid- in which section can I find the message queue
18:31 montes i have looked everywhere
18:32 kidclamp it's a database table
18:33 montes does the server admin only have access
18:33 kidclamp you can view it in the reports module
18:33 kidclamp SELECT * FROM message_queue WHERE lettercode='HOLDPLACED' and status != 'SENT'
18:33 kidclamp should give you pending messages of this type
18:34 kidclamp http://manual.koha-community.org/3.22/en/administration.html#emailLibrarianWhenHoldIsPlaced
18:34 montes great..
20:29 drojf @wunder berlin, germany
20:29 huginn drojf: The current temperature in Berlin Tegel, Germany is 25.0Â°C (10:20 PM CEST on August 26, 2016). Conditions: Clear. Humidity: 39%. Dew Point: 10.0Â°C. Pressure: 30.04 in 1017 hPa (Steady).
22:42 eythian @wunder ams
22:42 huginn eythian: The current temperature in Schiphol, Badhoevedorp, Netherlands is 18.4Â°C (12:29 AM CEST on August 27, 2016). Conditions: Clear. Humidity: 82%. Dew Point: 16.0Â°C. Pressure: 30.12 in 1020 hPa (Steady).
22:42 eythian Pleasantly cool