Time Nick Message
04:59 josef_moravec morning #koha
05:23 biji i am having a problem
05:24 biji while entring localhost:8080 it shows this error
05:24 biji 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 1492. at /usr/share/koha/lib/Koha/Database.pm line 107
05:24 biji pls help me out
05:29 marcelr hi #koha
05:30 biji 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 1492. at /usr/share/koha/lib/Koha/Database.pm line 107
06:35 reiveune hello
06:35 wahanui hello, reiveune
07:01 alex_a bonjour
07:42 magnuse \o/
08:29 cait for the record: I commented out Software Coop's demo on the website because it has been in maintenance mode for several months and I tried to get in touch using their contact form but no feedback
08:30 cait @later tell wizzyrea updated the demo page again, biblibre on 18.11 now, commented out software coop - still maintenance
08:30 huginn` cait: The operation succeeded.
08:33 magnuse cait++
09:01 * paxed grumbles something about hashes being dumped in random order into action_logs
11:07 ashimema Which logs paxed?
11:08 ashimema Not the new patron change details one.. I though I'd set them to ordered when I wrote it.. perhaps I forgot
11:08 paxed ashimema: all the HOLDS ones
11:08 ashimema Not me then.. phew
11:08 ashimema Are they data::dumper dumped ones.?
11:08 paxed yup
11:09 paxed (although i haven't tried it on master, so maybe it's been changed ... but i didn't notice a code change for it)
11:09 ashimema Mwah
11:09 josef_moravec ashimema: hi, have you time for bug 15516? ;)
11:09 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15516 new feature, P5 - low, ---, julian.maurice, Signed Off , Allow to place a hold on first available item from a group of titles
11:11 cait aren't hashes always kind of unordered
11:11 cait ?
11:11 ashimema Maybe tomorrow.. bank holiday here today and I have BBQ guests about to arrive.
11:12 cait enjoy your day off :)
11:12 ashimema I like that bug though.. been on my list to look at for ages
11:12 ashimema Hashes are indeed unordered cait
11:12 paxed ... but they should be sorted when they're saved into the db as text
11:12 ashimema But you can explicitly sort the keys for looping through or dumoing
11:12 ashimema Dumping even
11:13 paxed hm. was there a way to get number-of-books-borrowered printed on a receipt?
11:13 ashimema Data::Dumper actually has some pretty advanced options there
11:13 ashimema I'm just trying to remember a cheeky quick, no code needed, fix for you paxed
11:14 cait paxed: shoudl be possible with TT and before TT bywater had some javascript to sum up the price of the books
11:14 paxed ashimema: eh, i could do it myself, but it won't help for data already in action_logs
11:14 ashimema I think you could be able to pass an environment variable or something in you Apache config to get them sorted
11:14 ashimema Wouldn Lt be hard to script a fix for the in dB stuff though
11:14 ashimema Read out or dB into perl struct, dump back into dB sorted
11:15 ashimema Please submit a but and add the academy keyword to it.. it's a great little one to get an academy student to fix up
11:15 ashimema Pretty please
11:19 josef_moravec ashimema: thanks
11:20 paxed ashimema: bug 22855
11:20 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22855 trivial, P5 - low, ---, koha-bugs, NEW , Hold information hashes should be dumped to action_logs in sorted key order
11:21 ashimema Ta
11:23 ashimema The super quick fix env variable approach btw is setting PERL_HASH_SEED to a fixed value within your Apache vhost
11:23 ashimema That would mean they're ordered the same all the time, but not a nice pretty sort
11:26 paxed super quick fix for me would be to add the Dumper sortkey code and push it to our production environment ;)
11:30 oleonard Hi all
11:33 magnuse hi oleonard
11:33 wahanui hi oleopard
11:38 magnuse wow! $Data::Dumper::Sortkeys just changed my life for the better!
11:38 * magnuse didn't know about it
11:57 oleonard cait++ # Powerful bug-wrangling going on over the weekend
12:07 cait oleonard: hopefully not just noise heh
12:08 oleonard Even if I don't read all the changes, it conveys hard work, which I always appreciate
12:14 cait .)
12:14 cait trying to merge duplicates and close things mostly, but end up fixing unlikely assignees and such too
12:15 cait and I#ve tried to change the enhance/improve/extend x into something more easy to understand
12:21 oleonard It's nice to get a chance to have another look at stuff sometimes.
12:21 oleonard The suggested solution for Bug 3310 is interesting
12:21 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3310 enhancement, P5 - low, ---, gmcharlt, NEW , Add mouse-over with column heading to table cells
12:25 cait i don't hate the idea :)
12:26 cait actually that was: Unusable Display of report results with large number of columns and rows
12:34 cait khall is sleepy
12:36 * oleonard too
12:58 magnuse https://www.interleaf.ie/kohacon19/ links to https://www.dbs.ie/about-dbs/location to explain where the 'con is, but that map has three locations. anyone know which one we are going to?
13:20 caroline_catlady hey all, how's monday so far?
13:25 cait sleepy and grey?
13:33 dersmon hi everyone
13:36 dersmon i was wondering: what is the smartest way to backup configuration only (basically only the admin-panel related stuff)
13:38 wizzyrea hi
13:38 wahanui what's up, wizzyrea
13:39 wizzyrea cait thanks for keeping up with that demo page
13:39 caroline_catlady dersmon: dump only the relevant tables
13:39 caroline_catlady does that make sense?
13:39 cait wizzyrea: i sent an email to slef now too, maybe I'll get a reply
13:42 dersmon carolone_catlady: ok
15:00 magnuse \o/
15:21 reiveune bye
15:31 dersmon for exporting all my marc framework settings, i dump tables marc_subfield_structure, marc_tag_structure and biblio_framework
15:31 dersmon something else?
15:35 dersmon seems to be it https://github.com/Koha-Community/Koha/blob/master/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql
15:35 dersmon nevermind ;)
15:39 cait what are you trying to do?
15:39 cait usually using the export might work, but for SQL yes, that are the teables :)
15:43 wizzyrea the first question?
15:43 wizzyrea heh
15:43 oleonard wizzyrea: I reworked my idea for Bug 22844, sent a patch, and then realized my solution was un-translatable :(
15:43 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22844 enhancement, P5 - low, ---, koha-bugs, ASSIGNED , Simplify the process of selecting database columns for system preferences
15:47 wizzyrea oh grr
15:47 cait keep the database coumn names?
15:47 cait i mean... not super nice, but nicer than now and doesn't neet to be tanslatable
15:47 wizzyrea how frustrating for you
15:47 cait and solve that next
15:47 oleonard I mean.... yeah could do that
15:47 oleonard It is better than nothing
15:48 wizzyrea well you've got the db table names in there as it is
15:51 caroline_catlady It's a step forward, but it would be nice if we could have the column names in words people understand
17:12 wizzyrea agmoyano, i wasn't able to get the patches to apply for bug 22284 but it's probably me
17:12 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22284 new feature, P5 - low, ---, agustinmoyano, Needs Signoff , Groups of pickup locations for holds
17:12 wizzyrea and/or the dependencies
18:08 oleonard Okay, revised patch attached to Bug 22844
18:08 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22844 enhancement, P5 - low, ---, koha-bugs, Needs Signoff , Simplify the process of selecting database columns for system preferences
18:46 wizzyrea hi again
18:49 wizzyrea hi
18:49 oleonard hi again again
18:49 wizzyrea my client is being strange
18:50 wizzyrea irc client
18:59 oleonard Bye all
19:29 wizzyrea joubu: on 22781 I couldn't sign off the selenium tests because currently selenium isn;t working for me :(
19:29 wizzyrea but I did test the rest of the things
19:29 wizzyrea so if someone with selenium could check that quickly (bug 22781) I'd be really grateful
19:29 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22781 normal, P5 - low, ---, jonathan.druart, Needs Signoff , Fields on patron search results should be html/json filtered
19:50 Freddy_Enrique Greetings everyone
19:51 Freddy_Enrique I'd like to ask something concerning VPS, anyone around?
19:56 caroline_catlady I'm around (hi!) but I don't know anything about VPS
19:58 Freddy_Enrique Hi caroline_catlady :)
19:58 Freddy_Enrique This is what's happening
19:58 rangi hi Freddy_Enrique, as in a server?
19:58 Freddy_Enrique I'm using Digital Ocean to host my Koha 18.11
19:59 Freddy_Enrique And, my droplet (virtual server) has been disconnected from the network three times
19:59 Freddy_Enrique due to Ddos attack
20:00 Freddy_Enrique At first I thought it was my lack of experience with security
20:00 Freddy_Enrique SSH Keys
20:00 Freddy_Enrique but of the community member pointed the following:
20:00 wizzyrea ah maybe you are being hit by search engines
20:00 wizzyrea they can be pretty aggressive sometimes
20:00 Freddy_Enrique Public facing software that contains a vulnerability, being exploited by a remote party.
20:01 wizzyrea what do your logs say?
20:02 * rangi is waiting for the Koha bit
20:03 Freddy_Enrique What I could read is that my network traffic from your Droplet matches a pattern of malicious traffic
20:03 Freddy_Enrique wizzyrea: What logs should I look into?
20:03 Freddy_Enrique forgive my ignorance
20:04 rangi also maybe tell us what the actual thing you are experiencing is
20:04 rangi because so far, I'm lost
20:04 Freddy_Enrique rangi: People can't access to my catalog
20:04 rangi is someone trying to ssh into your box? Is there a DDOS on ssh (those would be 2 different things) ... I'm just wondering why you mentioned ssh keys
20:05 rangi DDOS don't exploit vulnerabilities, they just overwhelm a server with traffic
20:06 Freddy_Enrique Oh... I mentioned the ssh keys because is one of the measures I took in order to prevent a Ddos. However, it didnt stop the problem
20:06 rangi right, well you would have to find what they are actually doing first before you can stop it
20:06 Freddy_Enrique yep yep.... is concerning the traffic
20:07 rangi it could be, like wizzyrea, mentioned just search engines crawling your catalogue.
20:07 rangi it would take very little to overwhelm a droplet
20:07 rangi so the mission is, find what the traffic is, is it ssh traffic, is it dns, is it udp, is http traffic
20:08 Freddy_Enrique this is what I get
20:08 Freddy_Enrique We are writing to let you know that your Droplet Celats-18.11 at 68.183.100.152 has been disconnected from the network after it contributed 125.7 Mbps to a 12.6 Gbps Distributed Denial of Service attack. The network traffic from your Droplet matches a pattern of malicious traffic originating from other Droplets targeted at a specific victim. We understand how disruptive this may be to your work; however, it was critical for us to disconnect your Drop
20:08 rangi ahh so it isn't someone attacking you, its someone using your box to attack others
20:09 Freddy_Enrique But, how could this be?
20:09 rangi lots of ways, none of which would be to do with Koha
20:09 Freddy_Enrique Like I said, I used SSH-Key, created firewall
20:09 rangi most likely somoene has compromised it
20:10 Freddy_Enrique But, I recreated droplet for the third time and is still happenimg. So weird
20:10 Freddy_Enrique does this happen too often in other VPS providers?
20:10 Freddy_Enrique is this temporary?
20:11 rangi no idea, sorry. It could be that digital oceans monitoring is doing false positives
20:11 rangi ie, it could be that ip is requesting traffic, not being attacked
20:11 rangi it's hard to know
20:11 Freddy_Enrique I'm really sorry to ask this kind of questions here. But I still don't get response from there
20:11 rangi I would open a support ticket with digital ocean and ask them if they can tell you what the traffic is
20:12 rangi because otherwise we are just guessing
20:12 Freddy_Enrique I understand. One last thing. If you were to choose a VPS to host Koha.... what would it be?
20:14 rangi It depends, I would probably choose a koha support company to host it for me, unless I wanted to look after a server. But if I did want a server, I would probably use linode
20:16 rangi I hope digital ocean can tell you what the traffic is, then you might be able to figure out what is going on, and stop it
20:17 rangi sorry I couldn't be more help
20:19 Freddy_Enrique koha support company? like.... ByWater Solution?
20:19 Freddy_Enrique rangi: really thanks :)
20:19 Freddy_Enrique rangi++
20:53 caroline_catlady is there a cataloging crack around?
20:54 cait not a crack... but maybe we can make do with the hive mind?
20:55 caroline_catlady I'm wondering if anyone has used authorities for subdivisions
20:56 caroline_catlady http://www.loc.gov/marc/authority/examples.html (see subdivision record)
20:56 caroline_catlady I never learned that in school
20:56 caroline_catlady and I don't know how to use them
21:00 cait :(
21:00 cait not a thing in our data I am afraid
21:00 cait not as far as I know at least
21:21 caroline_catlady good night everyone!