Time Nick Message 21:21 caroline_catlady good night everyone! 21:00 cait not as far as I know at least 21:00 cait not a thing in our data I am afraid 21:00 cait :( 20:56 caroline_catlady and I don't know how to use them 20:56 caroline_catlady I never learned that in school 20:56 caroline_catlady http://www.loc.gov/marc/authority/examples.html (see subdivision record) 20:55 caroline_catlady I'm wondering if anyone has used authorities for subdivisions 20:54 cait not a crack... but maybe we can make do with the hive mind? 20:53 caroline_catlady is there a cataloging crack around? 20:19 Freddy_Enrique rangi++ 20:19 Freddy_Enrique rangi: really thanks :) 20:19 Freddy_Enrique koha support company? like.... ByWater Solution? 20:17 rangi sorry I couldn't be more help 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: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:12 Freddy_Enrique I understand. One last thing. If you were to choose a VPS to host Koha.... what would it be? 20:12 rangi because otherwise we are just guessing 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: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 it's hard to know 20:11 rangi ie, it could be that ip is requesting traffic, not being attacked 20:11 rangi no idea, sorry. It could be that digital oceans monitoring is doing false positives 20:10 Freddy_Enrique is this temporary? 20:10 Freddy_Enrique does this happen too often in other VPS providers? 20:10 Freddy_Enrique But, I recreated droplet for the third time and is still happenimg. So weird 20:09 rangi most likely somoene has compromised it 20:09 Freddy_Enrique Like I said, I used SSH-Key, created firewall 20:09 rangi lots of ways, none of which would be to do with Koha 20:09 Freddy_Enrique But, how could this be? 20:08 rangi ahh so it isn't someone attacking you, its someone using your box to attack others 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 Freddy_Enrique this is what I get 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:07 rangi it would take very little to overwhelm a droplet 20:07 rangi it could be, like wizzyrea, mentioned just search engines crawling your catalogue. 20:06 Freddy_Enrique yep yep.... is concerning the traffic 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 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:05 rangi DDOS don't exploit vulnerabilities, they just overwhelm a server with traffic 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:04 Freddy_Enrique rangi: People can't access to my catalog 20:04 rangi because so far, I'm lost 20:04 rangi also maybe tell us what the actual thing you are experiencing is 20:03 Freddy_Enrique forgive my ignorance 20:03 Freddy_Enrique wizzyrea: What logs should I look into? 20:03 Freddy_Enrique What I could read is that my network traffic from your Droplet matches a pattern of malicious traffic 20:02 * rangi is waiting for the Koha bit 20:01 wizzyrea what do your logs say? 20:00 Freddy_Enrique Public facing software that contains a vulnerability, being exploited by a remote party. 20:00 wizzyrea they can be pretty aggressive sometimes 20:00 wizzyrea ah maybe you are being hit by search engines 20:00 Freddy_Enrique but of the community member pointed the following: 20:00 Freddy_Enrique SSH Keys 20:00 Freddy_Enrique At first I thought it was my lack of experience with security 19:59 Freddy_Enrique due to Ddos attack 19:59 Freddy_Enrique And, my droplet (virtual server) has been disconnected from the network three times 19:58 Freddy_Enrique I'm using Digital Ocean to host my Koha 18.11 19:58 rangi hi Freddy_Enrique, as in a server? 19:58 Freddy_Enrique This is what's happening 19:58 Freddy_Enrique Hi caroline_catlady :) 19:56 caroline_catlady I'm around (hi!) but I don't know anything about VPS 19:51 Freddy_Enrique I'd like to ask something concerning VPS, anyone around? 19:50 Freddy_Enrique Greetings everyone 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:29 wizzyrea so if someone with selenium could check that quickly (bug 22781) I'd be really grateful 19:29 wizzyrea but I did test the rest of the things 19:29 wizzyrea joubu: on 22781 I couldn't sign off the selenium tests because currently selenium isn;t working for me :( 18:59 oleonard Bye all 18:50 wizzyrea irc client 18:49 wizzyrea my client is being strange 18:49 oleonard hi again again 18:49 wizzyrea hi 18:46 wizzyrea hi again 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:08 oleonard Okay, revised patch attached to Bug 22844 17:12 wizzyrea and/or the dependencies 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 agmoyano, i wasn't able to get the patches to apply for bug 22284 but it's probably me 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 15:48 wizzyrea well you've got the db table names in there as it is 15:47 oleonard It is better than nothing 15:47 oleonard I mean.... yeah could do that 15:47 cait and solve that next 15:47 wizzyrea how frustrating for you 15:47 cait i mean... not super nice, but nicer than now and doesn't neet to be tanslatable 15:47 cait keep the database coumn names? 15:47 wizzyrea oh grr 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:43 oleonard wizzyrea: I reworked my idea for Bug 22844, sent a patch, and then realized my solution was un-translatable :( 15:43 wizzyrea heh 15:43 wizzyrea the first question? 15:39 cait usually using the export might work, but for SQL yes, that are the teables :) 15:39 cait what are you trying to do? 15:35 dersmon nevermind ;) 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:31 dersmon something else? 15:31 dersmon for exporting all my marc framework settings, i dump tables marc_subfield_structure, marc_tag_structure and biblio_framework 15:21 reiveune bye 15:00 magnuse \o/ 13:42 dersmon carolone_catlady: ok 13:39 cait wizzyrea: i sent an email to slef now too, maybe I'll get a reply 13:39 caroline_catlady does that make sense? 13:39 caroline_catlady dersmon: dump only the relevant tables 13:39 wizzyrea cait thanks for keeping up with that demo page 13:38 wahanui what's up, wizzyrea 13:38 wizzyrea hi 13:36 dersmon i was wondering: what is the smartest way to backup configuration only (basically only the admin-panel related stuff) 13:33 dersmon hi everyone 13:25 cait sleepy and grey? 13:20 caroline_catlady hey all, how's monday so far? 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? 12:36 * oleonard too 12:34 cait khall is sleepy 12:26 cait actually that was: Unusable Display of report results with large number of columns and rows 12:25 cait i don't hate the idea :) 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:21 oleonard The suggested solution for Bug 3310 is interesting 12:21 oleonard It's nice to get a chance to have another look at stuff sometimes. 12:15 cait and I#ve tried to change the enhance/improve/extend x into something more easy to understand 12:14 cait trying to merge duplicates and close things mostly, but end up fixing unlikely assignees and such too 12:14 cait .) 12:08 oleonard Even if I don't read all the changes, it conveys hard work, which I always appreciate 12:07 cait oleonard: hopefully not just noise heh 11:57 oleonard cait++ # Powerful bug-wrangling going on over the weekend 11:38 * magnuse didn't know about it 11:38 magnuse wow! $Data::Dumper::Sortkeys just changed my life for the better! 11:33 wahanui hi oleopard 11:33 magnuse hi oleonard 11:30 oleonard Hi all 11:26 paxed super quick fix for me would be to add the Dumper sortkey code and push it to our production environment ;) 11:23 ashimema That would mean they're ordered the same all the time, but not a nice pretty sort 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:21 ashimema Ta 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:20 paxed ashimema: bug 22855 11:19 josef_moravec ashimema: thanks 11:15 ashimema Pretty please 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:14 ashimema Read out or dB into perl struct, dump back into dB sorted 11:14 ashimema Wouldn Lt be hard to script a fix for the in dB stuff though 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 paxed ashimema: eh, i could do it myself, but it won't help for data already in action_logs 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:13 ashimema I'm just trying to remember a cheeky quick, no code needed, fix for you paxed 11:13 ashimema Data::Dumper actually has some pretty advanced options there 11:13 paxed hm. was there a way to get number-of-books-borrowered printed on a receipt? 11:12 ashimema Dumping even 11:12 ashimema But you can explicitly sort the keys for looping through or dumoing 11:12 paxed ... but they should be sorted when they're saved into the db as text 11:12 ashimema Hashes are indeed unordered cait 11:12 ashimema I like that bug though.. been on my list to look at for ages 11:12 cait enjoy your day off :) 11:11 ashimema Maybe tomorrow.. bank holiday here today and I have BBQ guests about to arrive. 11:11 cait ? 11:11 cait aren't hashes always kind of unordered 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:09 josef_moravec ashimema: hi, have you time for bug 15516? ;) 11:09 ashimema Mwah 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:08 paxed yup 11:08 ashimema Are they data::dumper dumped ones.? 11:08 ashimema Not me then.. phew 11:08 paxed ashimema: all the HOLDS ones 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:07 ashimema Which logs paxed? 09:01 * paxed grumbles something about hashes being dumped in random order into action_logs 08:33 magnuse cait++ 08:30 huginn` cait: The operation succeeded. 08:30 cait @later tell wizzyrea updated the demo page again, biblibre on 18.11 now, commented out software coop - still maintenance 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 07:42 magnuse \o/ 07:01 alex_a bonjour 06:35 wahanui hello, reiveune 06:35 reiveune hello 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 05:29 marcelr hi #koha 05:24 biji pls help me out 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 while entring localhost:8080 it shows this error 05:23 biji i am having a problem 04:59 josef_moravec morning #koha