| Time |
S |
Nick |
Message |
| 00:19 |
|
|
lukeg joined #koha |
| 00:53 |
|
|
lukeg joined #koha |
| 01:26 |
|
|
kathryn joined #koha |
| 03:38 |
|
|
lukeg joined #koha |
| 04:56 |
|
|
josef_moravec joined #koha |
| 04:59 |
|
josef_moravec |
morning #koha |
| 05:06 |
|
|
chris joined #koha |
| 05:21 |
|
|
cait joined #koha |
| 05:23 |
|
|
biji joined #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 joined #koha |
| 05:29 |
|
marcelr |
hi #koha |
| 05:29 |
|
|
Oak joined #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 |
| 05:33 |
|
|
calire joined #koha |
| 05:35 |
|
|
biji left #koha |
| 06:12 |
|
|
sophie_m joined #koha |
| 06:35 |
|
|
reiveune joined #koha |
| 06:35 |
|
reiveune |
hello |
| 06:35 |
|
wahanui |
hello, reiveune |
| 06:59 |
|
|
fridolin joined #koha |
| 07:00 |
|
|
alex_a joined #koha |
| 07:01 |
|
alex_a |
bonjour |
| 07:06 |
|
|
laurence joined #koha |
| 07:08 |
|
|
cait joined #koha |
| 07:09 |
|
|
sophie_m joined #koha |
| 07:12 |
|
|
andreashm joined #koha |
| 07:27 |
|
|
magnuse joined #koha |
| 07:41 |
|
|
hiro67 joined #koha |
| 07:42 |
|
magnuse |
\o/ |
| 07:43 |
|
|
akilsdonk joined #koha |
| 07:52 |
|
|
andreashm joined #koha |
| 08:23 |
|
|
laurence joined #koha |
| 08:27 |
|
|
paul_p joined #koha |
| 08:27 |
|
|
kohaputti joined #koha |
| 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 |
| 09:35 |
|
|
janPasi joined #koha |
| 10:12 |
|
|
khall joined #koha |
| 10:14 |
|
|
fridolin1 joined #koha |
| 10:27 |
|
|
vfernandes joined #koha |
| 10:29 |
|
|
andreashm joined #koha |
| 11:00 |
|
|
agmoyano joined #koha |
| 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[…]_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[…]_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:29 |
|
|
oleonard joined #koha |
| 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:45 |
|
|
alex_a joined #koha |
| 11:51 |
|
|
kohaputti joined #koha |
| 11:51 |
|
|
agmoyano joined #koha |
| 11:56 |
|
|
agmoyano joined #koha |
| 11:57 |
|
oleonard |
cait++ # Powerful bug-wrangling going on over the weekend |
| 11:59 |
|
|
khall joined #koha |
| 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:19 |
|
|
m23 joined #koha |
| 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[…]w_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:27 |
|
|
khall joined #koha |
| 12:32 |
|
|
agmoyano joined #koha |
| 12:34 |
|
cait |
khall is sleepy |
| 12:36 |
|
* oleonard |
too |
| 12:37 |
|
|
khall joined #koha |
| 12:45 |
|
|
andreashm joined #koha |
| 12:51 |
|
|
andreashm joined #koha |
| 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:19 |
|
|
caroline_catlady joined #koha |
| 13:19 |
|
|
janPasi joined #koha |
| 13:20 |
|
caroline_catlady |
hey all, how's monday so far? |
| 13:25 |
|
cait |
sleepy and grey? |
| 13:26 |
|
|
khall joined #koha |
| 13:32 |
|
|
dersmon joined #koha |
| 13:32 |
|
|
lukeg joined #koha |
| 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 joined #koha |
| 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 |
|
|
calire left #koha |
| 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 |
| 13:44 |
|
|
janPasi joined #koha |
| 13:50 |
|
|
kohaputti joined #koha |
| 14:01 |
|
|
janPasi joined #koha |
| 14:40 |
|
|
lukeg joined #koha |
| 14:40 |
|
|
lukeg joined #koha |
| 14:41 |
|
|
lukeg joined #koha |
| 14:42 |
|
|
lukeg joined #koha |
| 14:43 |
|
|
lukeg joined #koha |
| 14:43 |
|
|
lukeg joined #koha |
| 14:44 |
|
|
lukeg joined #koha |
| 14:46 |
|
|
m23 joined #koha |
| 14:52 |
|
|
agmoyano joined #koha |
| 14:56 |
|
|
lukeG joined #koha |
| 14:59 |
|
|
agmoyano joined #koha |
| 15:00 |
|
magnuse |
\o/ |
| 15:19 |
|
|
khall joined #koha |
| 15:21 |
|
reiveune |
bye |
| 15:22 |
|
|
reiveune left #koha |
| 15:22 |
|
|
khall joined #koha |
| 15:25 |
|
|
agmoyano joined #koha |
| 15:30 |
|
|
wizzyrea joined #koha |
| 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-Commun[…]ib_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[…]_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 |
| 15:51 |
|
|
wizzyrea joined #koha |
| 15:54 |
|
|
agmoyano joined #koha |
| 16:01 |
|
|
agmoyano joined #koha |
| 16:01 |
|
|
janPasi joined #koha |
| 16:05 |
|
|
khall joined #koha |
| 16:07 |
|
|
laurence left #koha |
| 16:09 |
|
|
fridolin1 left #koha |
| 16:12 |
|
|
agmoyano joined #koha |
| 16:19 |
|
|
m23 joined #koha |
| 16:21 |
|
|
wizzyrea joined #koha |
| 16:34 |
|
|
agmoyano joined #koha |
| 16:48 |
|
|
khall joined #koha |
| 16:52 |
|
|
khall joined #koha |
| 16:54 |
|
|
agmoyano joined #koha |
| 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[…]_bug.cgi?id=22284 new feature, P5 - low, ---, agustinmoyano, Needs Signoff , Groups of pickup locations for holds |
| 17:12 |
|
wizzyrea |
and/or the dependencies |
| 17:23 |
|
|
cait left #koha |
| 17:44 |
|
|
agmoyano joined #koha |
| 17:48 |
|
|
agmoyano joined #koha |
| 17:52 |
|
|
agmoyano joined #koha |
| 18:02 |
|
|
cait joined #koha |
| 18:08 |
|
oleonard |
Okay, revised patch attached to Bug 22844 |
| 18:08 |
|
huginn` |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=22844 enhancement, P5 - low, ---, koha-bugs, Needs Signoff , Simplify the process of selecting database columns for system preferences |
| 18:18 |
|
|
agmoyano joined #koha |
| 18:32 |
|
|
khall joined #koha |
| 18:34 |
|
|
agmoyano joined #koha |
| 18:43 |
|
|
wizzyrea joined #koha |
| 18:46 |
|
wizzyrea |
hi again |
| 18:48 |
|
|
khall joined #koha |
| 18:49 |
|
|
wizzyrea joined #koha |
| 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:20 |
|
|
eythian joined #koha |
| 19:24 |
|
|
khall joined #koha |
| 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[…]_bug.cgi?id=22781 normal, P5 - low, ---, jonathan.druart, Needs Signoff , Fields on patron search results should be html/json filtered |
| 19:32 |
|
|
sonOfRa_ joined #koha |
| 19:33 |
|
|
agmoyano joined #koha |
| 19:36 |
|
|
kivilahtio_ joined #koha |
| 19:36 |
|
|
agmoyano joined #koha |
| 19:36 |
|
|
fredericdem joined #koha |
| 19:36 |
|
|
z-b joined #koha |
| 19:37 |
|
|
jajm_ joined #koha |
| 19:37 |
|
|
jo joined #koha |
| 19:37 |
|
|
lukeg joined #koha |
| 19:39 |
|
|
GiuseppeP joined #koha |
| 19:39 |
|
|
magnuse joined #koha |
| 19:39 |
|
|
kohaputti joined #koha |
| 19:40 |
|
|
matts joined #koha |
| 19:41 |
|
|
clrh_ joined #koha |
| 19:41 |
|
|
mirkh_ joined #koha |
| 19:41 |
|
|
Joubu joined #koha |
| 19:41 |
|
|
SlackIntegration[m] joined #koha |
| 19:41 |
|
|
killer_bee[m] joined #koha |
| 19:41 |
|
|
slef joined #koha |
| 19:43 |
|
|
janPasi joined #koha |
| 19:43 |
|
|
rkrimme1 joined #koha |
| 19:48 |
|
|
agmoyano joined #koha |
| 19:50 |
|
|
Freddy_Enrique joined #koha |
| 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 |
|
|
andreashm joined #koha |
| 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:05 |
|
|
kathryn joined #koha |
| 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:53 |
|
|
khall joined #koha |
| 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:14 |
|
|
khall joined #koha |
| 21:21 |
|
caroline_catlady |
good night everyone! |
| 21:42 |
|
|
agmoyano joined #koha |
| 21:43 |
|
|
mwr joined #koha |
| 21:55 |
|
|
AndyBoze joined #koha |
| 22:34 |
|
|
agmoyano joined #koha |
| 22:38 |
|
|
agmoyano joined #koha |
| 23:11 |
|
|
amoyano joined #koha |
