IRC log for #koha, 2018-04-05

All times shown according to UTC.

Time S Nick Message
00:00 andrew joined #koha
00:10 dcook_ joined #koha
00:13 magnuse joined #koha
01:35 mtompset @seen jobou
01:35 huginn mtompset: I have not seen jobou.
01:35 mtompset @seen joubu
01:35 huginn mtompset: joubu was last seen in #koha 5 hours, 46 minutes, and 19 seconds ago: <Joubu> @later tell tcohen: please please please put bug 20191 on top of your todo list (or I am going to remove these OAI tests once and for all)
01:38 mtompset @later tell Joubu How about my counter patch on bug 20191?
01:38 huginn mtompset: The operation succeeded.
01:38 mtompset @later tell tcohen How about my counter patch on bug 20191?
01:38 huginn mtompset: The operation succeeded.
02:24 emucla joined #koha
02:39 Kafilini joined #koha
02:43 mtompset The master build is failing related to bug 20191.
02:43 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=20191 normal, P5 - low, ---, tomascohen, ASSIGNED , OAI/Server.t still fails on slow servers
02:43 mtompset Anyone care to look at my counter patch?
03:13 mtompset Have a good day (24 hour period), #koha
03:22 indradg joined #koha
03:25 Kafilini joined #koha
04:16 Kafilini joined #koha
05:00 cait joined #koha
05:08 paxed Joubu: re bug 19817 - really should have an option to use the UI language as the manual language. (think about multiple official languages, user definitely wants manual in his own language)
05:08 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=19817 new feature, P5 - low, ---, jonathan.druart, Needs Signoff , Merge local and online documentations
05:09 cait paxed: i tihnk the problem is how to know which manual languages exist
05:10 cait give a list of languages to use in the pref?
05:10 paxed cait: see my comment on that bug
05:10 cait will take a look - thx!
05:12 paxed we've got library consortiums with libraries that have both "only" finnish and "only" swedish speakers. so a single setting for the language would mess that up.
05:13 paxed on the coast, the library workers might only use swedish, but inland, only finnish.
05:13 paxed and still belong to the same consortium
05:17 cait no need to explain, i want it to work properly too :)
05:17 cait we always offer at least english and german and many more lanugages for the libraries of the goethe institutes
06:13 calire joined #koha
06:31 alex_a joined #koha
06:31 alex_a bonjour
06:40 laurence joined #koha
06:59 fridolin joined #koha
07:08 ashimema joined #koha
07:14 reiveune joined #koha
07:14 reiveune hello
07:32 gaetan_B joined #koha
07:32 gaetan_B hello
07:32 wahanui privet, gaetan_B
07:35 tuxayo hi #koha o/
07:36 calire hi tuxayo
07:40 indradg joined #koha
07:48 cait joined #koha
07:49 chris_n joined #koha
07:54 janPasi joined #koha
07:56 paul_p joined #koha
08:00 janPasi joined #koha
08:02 janPasi joined #koha
08:07 chris_n joined #koha
08:08 janPasi joined #koha
08:09 tuxayo @later tell Joubu Thanks for making the translators happy <3 https://bugs.koha-community.or[…].cgi?id=19910#c23
08:09 huginn tuxayo: The operation succeeded.
08:09 huginn Bug 19910: normal, P5 - low, ---, nick, Pushed to Master , Download report as 'Comma separated' is misleading
08:10 paxed i've always been wondering ... in search results and detail view, why are the labels black, but the actual data is light gray? the data should be more important to see clearly!
08:10 sen joined #koha
08:12 indradg_ joined #koha
08:13 jcamins_ joined #koha
08:18 magnuse huh, trying to update my devbox, all css and js links have the version number in them, but come up as 404 not found?
08:23 paxed magnuse: apache config didn't get updated?
08:24 magnuse ah, possibly
08:26 magnuse should the actual apache site config have been updated?
08:27 cait i think you have to do it manually maybe
08:27 magnuse there were updates to /etc/koha/apache-shared-intranet.conf and the corresponding one for opac, but apache restart does not change anything
08:27 cait do you have the rewrite rules?
08:28 magnuse nope
08:28 cait let me find the email
08:28 janPasi joined #koha
08:35 cait it's in the bug that I can't find now... the one that added the versioning
08:36 josef_moravec joined #koha
08:37 alexbuckley joined #koha
08:40 cait https://bugs.koha-community.or[…]_bug.cgi?id=12904 found it (finally)
08:40 huginn Bug 12904: enhancement, P5 - low, ---, kyle, RESOLVED FIXED, Force browser to load new JavaScript and CSS files after upgrade
08:59 andreashm joined #koha
08:59 * andreashm waves
09:09 alex_a @seen bag
09:09 huginn alex_a: bag was last seen in #koha 5 days, 12 hours, 43 minutes, and 18 seconds ago: <bag> :D
09:14 eythian @seen eythian
09:14 huginn eythian: eythian was last seen in #koha 21 hours, 7 minutes, and 16 seconds ago: <eythian> etc.
09:14 eythian @seen eythian
09:14 huginn eythian: eythian was last seen in #koha 7 seconds ago: <eythian> @seen eythian
09:38 Kafilini joined #koha
09:49 indradg_ joined #koha
10:12 magnuse joined #koha
10:37 Kafilini joined #koha
10:58 kellym joined #koha
10:59 wilfrid joined #koha
11:00 kellym left #koha
11:06 marcelr joined #koha
11:06 marcelr hi #koha
11:25 meliss joined #koha
11:32 kidclamp joined #koha
11:34 magnuse hiya marcelr
11:34 oleonard joined #koha
11:35 oleonard Hi all
11:55 calire hi oleonard
11:55 wahanui hi olé onard
11:55 oleonard Hi calire
11:55 oleonard I am slowly getting used to your new nick
11:56 eythian beware, she'll just change it again!
11:56 calire :D
11:56 calire many an email have been signed off this way
12:02 oleonard Many a browser form field tries to autocomplete 'oleonrad' because ONCE I misspelled it. Okay maybe more than once.
12:03 calire haha
12:04 Dyrcona joined #koha
12:04 kidclamp you are rad oleon
12:04 oleonard And you are camp, kidl
12:07 kidclamp yaaas queen!
12:08 ncbaratta joined #koha
12:19 DonnaB joined #koha
12:30 DonnaB_ joined #koha
12:32 marcelr left #koha
12:32 marcelr joined #koha
12:37 cait khall_away: do you remember which of many restrictions the patron import will overwrite if you send a date?
12:40 oleonard Did a patch recently get pushed fixing a problem with logging in to the OPAC? Or is it still pending? Or am I making that up?
12:41 tuxayo hi kidclamp , got few minutes?
12:42 kidclamp sure!
12:43 tuxayo kidclamp: does bug 19953 looks eligible for backport?
12:43 tuxayo https://bugs.koha-community.or[…]73593&action=diff
12:43 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=19953 enhancement, P5 - low, ---, victor.grousset, Pushed to Master , Add column for invoice in acquisition details tab
12:45 cait tuxayo: it's an enh
12:45 kidclamp it is a very small enhancment
12:45 cait sorry, only one eye here
12:45 cait up to rmaint ;) j
12:46 kidclamp I could be convinced - anything that makes acq easier
12:46 tuxayo cait: it's indeed an enh
12:49 cait usually rule of thumb is that enh are not backported, up to the RMaint to grant exceptions
12:50 oleonard I get an error when I try to log in to the OPAC using a cardnumber for a patron who has no userid
12:51 oleonard Use of uninitialized value $userid in string eq at /home/vagrant/kohaclone/C4/Auth.pm line 2078.
12:51 oleonard Can't call method "unblessed" on an undefined value at /home/vagrant/kohaclone/opac/opac-user.pl line 97.
12:51 cait ouch
12:51 cait but how can the patron have no userid?
12:52 cait beause of the recent bug with broken userid generation?
12:52 oleonard Perhaps old data with patrons who never logged in to Koha
12:53 cait if you leave empty int hte gui koha fills the field on saving and i think patron import does too
12:53 * oleonard checks the production db
12:54 andrew joined #koha
12:54 oleonard Okay yeah our production db has no patrons with null userid, so my test data must include some really old records.
12:57 janPasi joined #koha
12:58 tcohen mtompset: why 0.17?
13:00 nlegrand Good day #koha
13:03 oleonard Hi nlegrand, tcohen
13:03 nlegrand hiya oleonard
13:04 tuxayo hi nlegrand
13:04 tcohen hi oleonard nlegrand kidclamp
13:04 nlegrand o/ tuxayo kidclamp tcohen
13:04 kidclamp hi tcohen
13:05 kidclamp hi nlegrand
13:08 kmlussier joined #koha
13:09 tuxayo kidclamp: «I could be convinced - anything that makes acq easier» I could also sign off bug 18947 ;) #sign_off_black_market
13:09 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=18947 major, P5 - low, ---, nick, Needs Signoff , Unexpected Active Directory LDAP authentication failure mode
13:09 tuxayo (like planned for the hackfest) I just need to make a dev env with a local LDAP which turns out to be seems  easier than I though
13:09 Margaret_ joined #koha
13:10 misilot_ joined #koha
13:11 * kidclamp feels bribed
13:11 kidclamp I am gonna push some stuffs today or tomorrow, if it works nice I will backport it
13:13 * oleonard extolls the wonders of http://www.generatedata.com/
13:17 pastebot "andrew" at 127.0.0.1 pasted "jquery from SWITCH" (7 lines) at http://paste.koha-community.org/170
13:17 tuxayo cat /dev/urandom | nc my-koha-server 80
13:18 tuxayo garantied to test everythings!
13:18 tcohen Joubu: Mogwai is playing in Argentina soon
13:18 oleonard Is there a good way to view the contents of an object in order to see how to get data to the template?
13:21 Joubu tcohen: international bands come in Argentina and play in posh areas, with expensive entradas and you have to sit (!)
13:22 Joubu oleonard: contents of an object?
13:23 tcohen oleonard: it is basically the fields in the base schema file
13:23 tcohen Joubu: I agree
13:23 Joubu oleonard: try use Data::Printer colored => 1; warn p $your_object;
13:24 tcohen 110 U$S the cheapest ticket????? WTF
13:24 Joubu (well this will not work with the attributes (from the DB) as they are AUTOLOADed)
13:25 oleonard Thanks Joubu, that helps
13:28 * kidclamp listens to happy songs for happy people
13:32 nlegrand If some people here like postrock, here is an awesome french postrock blog: https://totoromoon.wordpress.com/ (made by a librarian)
13:33 Dyrcona joined #koha
13:33 deb-CSPL joined #koha
13:36 gaetan_B hi nlegrand, i've been trying to reproduce your bug with 中國翻譯 on a sandbox, and it works fine, i've imported the record you sent to the list and can find it
13:36 gaetan_B i've tested it here :  http://pro.es11-koha.sandbox.biblibre.eu
13:36 nlegrand Joubu: with people who can't stand for long, venues where you can't sit are much more trouble than venues where you have to sit :).
13:36 nlegrand gaetan_B: how annoying
13:37 * oleonard had never heard the term 'postrock' before
13:37 gaetan_B i know! B is for Boring though, but maybe i can't change to gaetan_A for today :D
13:37 kidclamp gaetan_Awesomesauce? I approve
13:38 tuxayo +1
13:38 roch joined #koha
13:38 tuxayo what is Awesomesauce anyway?
13:38 nlegrand oleonard: sorry, is spells post-rock.
13:39 oleonard nlegrand: I understand, I mean I've never heard of that music genre before
13:39 nlegrand oleonard: you can have all sort of music genre and add a "post" before it at some time
13:39 alex_a Is there a special trick to install a language on KohaDevBox?
13:39 eythian oleonard: neopostrock will blow your mind!
13:39 tuxayo https://www.urbandictionary.co[…]m=awesome%20sauce
13:39 tuxayo I feared it was something more saucy, but it's all right
13:40 oleonard alex_a: From kshell, using the translate script directly
13:40 alex_a i did koha-translate --install fr-FR but nothing more in prog/ directory and same in language syspref
13:40 oleonard alex_a: Not using the package command
13:40 alex_a oleonard: it is unable to create the directory
13:40 alex_a via kshell
13:41 talljoy joined #koha
13:41 alex_a "Koha directories hierarchy for fr-FR must be created first"
13:41 alex_a really?
13:41 wahanui hmmm... really is more trouble than she's worth.
13:42 talljoy joined #koha
13:43 Joubu --create
13:44 nlegrand gaetan_B: the machine runs Zebra. Trying again to convince me Zebra is good enough, aren't thou?
13:44 gaetan_B damn
13:45 nlegrand :)
13:45 gaetan_B i thought those were dedicated to elastic!
13:45 alex_a Joubu: ?
13:45 alex_a ./translate create ?
13:46 Joubu if you use koha-translate you certainly need to provide --dev
13:46 Joubu personally I kept my old habits and use cd misc/translate; perl translate create|update|install LANG
13:47 alex_a Ok, i have to remove all fr po files first... >_<
13:47 * oleonard suspects he knew once of the --dev flag and forgot about it
13:47 kellym joined #koha
13:48 Joubu alex_a: you do not need to remove them
13:48 Joubu alex_a: just use update then install
13:49 alex_a create doesn't work with these po here
13:49 Joubu I guess you just need --dev actually
13:50 alex_a ./translate install fr-FR => Unsupported language: fr-FR
13:52 Joubu so, create?
13:54 alex_a Preferences .po file already exists. Delete it if you want to recreate it.
13:54 alex_a update: msgattrib: cannot create output file "/home/vagrant/kohaclone/mis​c/translator/po/fr-FR-*.po": Permission denied
13:54 huginn News from kohagit: Bug 20191: (QA follow-up) Require Jessie's Test::MockTime <http://git.koha-community.org/[…]82f1d869faeb2e2d8>
13:54 huginn News from kohagit: Bug 20191: Use Test::MockTime to hold time still <http://git.koha-community.org/[…]7a9376e810c1b2d1e>
13:54 Joubu ha
13:54 alex_a using koha-shell
13:54 Joubu koha-shell
13:54 wahanui somebody said koha-shell was happier (well its 90% happy anyway)
13:56 alex_a and, if I do it with vagrant user: Try running this again as the koha instance user (or use the koha-shell command in debian)
13:58 Joubu I do not understand why you do not have the po files for fr-FR, they are in the git repo
13:58 Joubu or you have them and the "unsupported language" error is wrong
13:59 cait alex_a: did you sudo and give the --dev instance?
13:59 cait alex_a: what are you trying to do?
13:59 alex_a cait: at what moment?
14:00 cait ah i thought you were still struggling with translation scripts
14:00 alex_a trying to install a language on KohaDevBox
14:02 cait if koha-translate doesn't work
14:02 cait kshell
14:02 cait cd kohaclone/misc/translator
14:02 cait perl translate install fr-FR
14:02 Joubu it is what he did
14:02 alex_a yep
14:03 alex_a what is the trick with --dev ?
14:03 alex_a where? when?
14:04 Joubu sounds like everybody reads too fast here :)
14:05 alex_a Did i read something too fast?
14:06 Joubu " if you use koha-translate you certainly need to provide --dev "
14:07 tuxayo Joubu: also happened to me T_T, missed the --dev the first time
14:10 alex_a Ok, this give me the available action but what's next?
14:12 alex_a no, did a mistake
14:12 misilot_ joined #koha
14:13 alex_a It works!
14:13 wahanui But now the Universe has disappeared
14:13 alex_a thx Joubu cait
14:14 Joubu what was wrong?
14:15 eythian the Universe was in the way.
14:16 rocio joined #koha
14:17 JoshB joined #koha
14:22 cait sorry, phone call in between
14:23 alex_a Joubu: using koha-translate with --dev is best :)
14:23 alex_a But doesn't work with ./translate create|update|install
14:24 alex_a Joubu: i'm not reading too fast, you write too fast ok?
14:24 alex_a :p
14:24 Joubu --dev with koha-translate it was my first answer ;)
14:25 Joubu you need to understand what does the koha-* script and how they behave
14:26 Joubu it's a pkg-based install, gitified, so the script need to know if they should use the "installed version" of the script/files (/usr/bin/*) or the ones in your git repo
14:26 Joubu script*s*
14:27 alex_a Joubu: got it!
14:27 alex_a thx for explanations
14:28 alex_a bag: around?
14:30 jenkins Project Koha_Master_D8 build #420: ABORTED in 32 min: https://jenkins.koha-community[…]ha_Master_D8/420/
14:30 jenkins * mtompset: Bug 20191: Use Test::MockTime to hold time still
14:30 jenkins * Tomás Cohen Arazi: Bug 20191: (QA follow-up) Require Jessie's Test::MockTime
14:30 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=20191 normal, P5 - low, ---, mtompset, Passed QA , OAI/Server.t still fails on slow servers
14:31 Joubu (^ deps missing, starting a new run)
14:41 calire left #koha
15:02 jbeno joined #koha
15:02 mtompset joined #koha
15:02 mtompset Greetings, #koha.
15:02 mtompset @seen Joubu
15:02 huginn mtompset: Joubu was last seen in #koha 31 minutes and 7 seconds ago: <Joubu> (^ deps missing, starting a new run)
15:03 mtompset @seen tcohen
15:03 huginn mtompset: tcohen was last seen in #koha 1 hour, 38 minutes, and 58 seconds ago: <tcohen> 110 U$S the cheapest ticket????? WTF
15:04 tcohen hi mtompset
15:04 tcohen tz talk?
15:06 Joubu should your '@seen' considered as a ping?
15:09 jenkins Yippee, build fixed!
15:09 wahanui o/ '`'`'`'`'`'`'`'`'`
15:09 jenkins Project Koha_Master_D8 build #421: FIXED in 38 min: https://jenkins.koha-community[…]ha_Master_D8/421/
15:11 barton joined #koha
15:18 mtompset Yes, it was tz talk. Thanks for signing off / pushing  promptly.
15:19 mtompset Also, what updates the counts in 18.05 portion of the dashboard?
15:20 mtompset I thought that push would have tweaked those numbers.
15:20 mtompset And $110 for a ticket to where, tcohen?
15:21 tcohen concert
15:21 tcohen but I was wrong, I landed a site that was charging three times the real cost
15:21 tcohen (which is still high)
15:24 Joubu mtompset: it retrieves a json from the server. I guess it is not generated on the fly but every x hours
15:25 Joubu Why are you caring that much about these numbers? :)
15:25 mtompset Because I want to maintain top 10 status. :P
15:26 tcohen mtompset: because he knows he commit quite a few patches for 18.05
15:26 Joubu signoffs or patches?
15:26 mtompset combination of both.
15:27 mtompset Signoffs at least, patches if possible. :)
15:27 Joubu it's easy, when you write a patch try to split it as much as possible
15:28 tcohen pleae don't :-D
15:28 mtompset Joubu, that is horrible.
15:28 magnuse in academia they call it salami publishing :-)
15:29 Joubu it is what I have been doing for the last 5 years!
15:29 mtompset And now they made you RM. :P
15:29 tcohen divide and conquer
15:29 tcohen LOL
15:29 mtompset I only split if there are lots of files.
15:30 Joubu mtompset: Being RM is awsome, I have 1 SO per patch I push!
15:30 mtompset Yes, and you also get all the blame when the next release has flaw X.
15:31 mtompset I'm happy with underling status. :)
15:32 Joubu Koha is bug free!
15:32 mtompset With this many lines of code, I think you are tripping on something if you think so. :P
15:33 fridolin left #koha
15:33 Margaret joined #koha
15:40 tuxayo bye #koha o/
15:41 jbeno joined #koha
15:45 cait left #koha
15:53 reiveune bye
15:53 reiveune left #koha
15:56 Joubu oleonard: did you get my later about SCSS?
15:57 laurence left #koha
15:58 oleonard Yes, but I'm not sure what you're saying. Are you asking for some justification for converting to scss?
15:58 Joubu yes
15:58 oleonard Are you referring to this page? https://wiki.koha-community.or[…]staff_client_SCSS
15:58 Joubu yes
15:59 oleonard It's not an RFC, so I don't think it needs to provide justification. Do you feel that you need some justification as RM?
15:59 Joubu Can you convince me we need this move? And also give us the advantages
16:00 Joubu I need to know why we need it (for 18.05? later?)
16:00 Joubu and also explain in the release notes why we did this move
16:00 oleonard Shall I add a comment to the bug report?
16:01 Joubu It would make sense to me to have it on the wik
16:01 Joubu did not you do a presentation about it during the hackfest in Marseille?
16:02 oleonard Yes
16:04 Joubu Are there slides on it somewhere?
16:04 Joubu of*
16:04 oleonard No it was an impromptu talk
16:04 oleonard I can write something up though
16:08 Shane-S joined #koha
16:14 Shane-S So I am working on upgrading 3.20.02 from packages to a new server where I installed  17.11 ( I did apt-get install koha-common MariaDB). Will the schema transfer or do I need to do some DB work first? I know about auto_increment issue
16:17 Shane-S I guess I can do koha-dump then migrate files, koha-restore, koha-upgrade-schema, check for data corrupt per DBMS_auto_increment_fix article
16:18 Shane-S Just checking if there is anything else I might need to complete
16:18 tcohen I would rather koha-create, then load the DB dump there
16:20 Shane-S tcohen: I have 2 instances running would the be an issue, or just name them the same. Would that be done via the SQL command line or package command to load the dump into a created instance(s)
16:21 tcohen The SQL dump doesn't know about instance names
16:21 tcohen You use the cli to manually load the de db dump
16:22 tcohen zcat dump.gz | koha-mysql instance ;-)
16:24 Shane-S should there be a database for each instance? I am on the old server in MySQL and I only see a information_schema db. Asking as I might need a higher level user
16:25 Shane-S tcohen ty for help so far, seems not so bad, now I just need to get the instances names correct.
16:27 Joubu Shane-S: and add sql-modes to your DBMS config
16:27 Joubu search for "sql-modes" on the wiki
16:27 wahanui joined #koha
16:33 JesseM @later tell alex_a Testing mana and will have update for you soon.
16:33 huginn JesseM: The operation succeeded.
16:38 mtompset @seen khall
16:38 huginn mtompset: khall was last seen in #koha 6 days, 1 hour, 29 minutes, and 52 seconds ago: <khall> Good plan joubu!
16:44 oleonard Joubu: https://wiki.koha-community.org/wiki/SCSS_RFC
16:44 Shane-S Joubu: I only get one result https://wiki.koha-community.or[…]ubuntu_-_packages and I don't see much explaination
16:44 Joubu Shane-S: https://wiki.koha-community.or[…]ackages#Ubuntu_16.04_and_MySQL_5.7
16:45 Shane-S Joubu: I am using MariaDB on new server
16:46 Shane-S sql-mode is under the MySQL segment, do I need to add to the old server cnf?
16:46 Joubu thanks oleonard
16:55 Shane-S tcohen: so there are 2 files from koha-dump date.sql.gz and date.tar.gz do I only need the SQL?
16:56 tcohen yes, sql.gz
16:56 tcohen but you need to keep in mind that the apache files might need some tweaking to match previous configuration
16:57 tcohen so keep that dump too
16:57 tcohen and maybe some other changes in the old koha-conf.xml file
16:57 tcohen i'm just saying: start fresh, and migrate some changes you could've made, but start fresh :-D
16:57 Shane-S I kept everything stock, I didn't have to change much I use a reverse proxy to handle the domain translations
16:58 Shane-S tch
16:58 Shane-S tcohen: Thanks
16:58 Shane-S fingers hit enter before o and tab ;) sorry
17:01 mtompset @later tell khall bug 18821 Sorry had to Failed QA it due to lack of tests, and my brain isn't up to writing them right now.
17:01 huginn mtompset: The operation succeeded.
17:09 Joubu Shane-S: the section ends with "If using > MariaDB 10.2.3 you will need to look into disabling the strict mode."
17:29 Shane-S Joubu: MariaDB-Server package is reporting 10.0.xx
17:29 Shane-S I have to troubleshoot a bit I can't access it with my admin account...so I am assuming it isn't setup right
17:31 vfernandes joined #koha
17:31 vfernandes hi #koha
17:32 vfernandes which is the best configuration for Koha with plack? by default it uses 2 workers and 50 requests but I'm having some memory usage problems (starts to use swap)
17:32 vfernandes *50 max-requests
17:33 magnuse joined #koha
17:34 tcohen vfernandes: it depends on many factors, can you du --si -s /var/lib/mysql/* and paste the output for the koha db?
17:34 cait joined #koha
17:34 tcohen I'd say 4GB RAM and 2 cores
17:34 tcohen and raise 2 to 4 workers
17:35 tcohen I always lower the request count for the workers to 10 or so
17:37 vfernandes 6.7G/var/lib/mysql/koha
17:37 vfernandes 8GB RAM
17:37 vfernandes 4 cores
17:38 vfernandes maybe I can raise fto 4 workers and reduce to 10 requests
17:38 tcohen each worker will eat a fixed amount of RAM only for running
17:40 misilot_ joined #koha
17:40 vfernandes yes I know... but some operations (like merge.pl) are consuming so much memory
17:41 vfernandes I don't know if is a memory leak or something else
17:42 tcohen If you think so, you should file a bug and provide steps to reproduce the issue
17:42 tcohen you might be right...
17:43 vfernandes every time that someone tries to use that catalogue merge operation the system starts to use swap memory and one worker of starmam is using most of it
17:43 tcohen how many biblios are merged?
17:47 vfernandes the client manager told me that was only 2 records... I tried the same operation in my computer and it works fine
17:49 vfernandes I have to wait to the end of the week to do some more testing (when the library is closed)
17:50 vfernandes tcohen: with 4 cores, 4GB RAM, 8GB database which plack/starmam configuration should I use? and with 8GB RAM?
17:51 vfernandes 4 workers, 10 max-requests?
17:51 tcohen do you regularly run cleanup_database.pl to clean sessions, etc?
17:51 vfernandes yes
17:51 indradg_ joined #koha
17:52 vfernandes the database size is 6.7GB because of local covers
17:53 huginn News from kohagit: Bug 20530: Remove trailing ':' in columns_settings.yml <http://git.koha-community.org/[…]3008ebcb412b711bc>
17:53 huginn News from kohagit: Bug 20325: Remove warning, it is no longer true <http://git.koha-community.org/[…]a7ab27f07b585f1a4>
17:53 huginn News from kohagit: Bug 20325: Do not remove accountlines between tests <http://git.koha-community.org/[…]79eee910e8ae41d9a>
17:53 huginn News from kohagit: Bug 20325: Move tests to a subtest <http://git.koha-community.org/[…]6567b8b593a39d9e9>
17:53 huginn News from kohagit: Bug 20516: Show patron's library in pending discharges table <http://git.koha-community.org/[…]eec9a649e72d3d58b>
17:53 huginn News from kohagit: Bug 20510: Remove unused sub TotalPaid from C4::Stats <http://git.koha-community.org/[…]01984ea759ac4fa52>
17:53 huginn News from kohagit: Bug 20261: Fix pagination of the results in authority search <http://git.koha-community.org/[…]d00f72b5508c4895d>
17:53 huginn News from kohagit: Bug 20325: C4::Accounts::purge_zero_balance_fees does not check account_offsets <http://git.koha-community.org/[…]7256fa116ee15dc28>
17:53 huginn News from kohagit: Bug 17373: Add mappings for unimarc authorities - Match index <http://git.koha-community.org/[…]6abdeb334fd988faf>
17:53 huginn News from kohagit: Bug 20350: Add column configuration to table of saved reports <http://git.koha-community.org/[…]c065080dd10a53bbd>
17:53 huginn News from kohagit: Bug 18825: Elasticsearch - Update heading main-heading and see fields <http://git.koha-community.org/[…]ad8933c0ba674ca8a>
17:53 huginn News from kohagit: Bug 17373: Elasticsearch - Authority mappings for UNIMARC - patch1 <http://git.koha-community.org/[…]784d1632d626b14be>
17:58 ashimema_laptop joined #koha
18:01 vfernandes tcohen: I have to leave... thanks for the help
18:01 vfernandes cya #koha
18:01 tcohen vfernandes: I missed your question on the flood
18:01 tcohen we can talk tomorrow
18:07 andrew joined #koha
18:11 misilot_ joined #koha
18:13 Joubu @later tell Kyle: sounds like you should update your git config: Author: Kyle M Hall <kyle@bywatetsolutions.com>
18:13 huginn Joubu: The operation succeeded.
18:18 tcohen ^^^ khall
18:19 Joubu @later tell khall: sounds like you should update your git config: Author: Kyle M Hall <kyle@bywatetsolutions.com>
18:19 huginn Joubu: The operation succeeded.
18:19 Joubu indeed :)
18:30 jenkins Project Koha_Master_D8 build #422: UNSTABLE in 37 min: https://jenkins.koha-community[…]ha_Master_D8/422/
18:30 jenkins * kyle: Bug 20325: C4::Accounts::purge_zero_balance_fees does not check
18:30 jenkins * Jonathan Druart: Bug 20325: Move tests to a subtest
18:30 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=20325 critical, P5 - low, ---, kyle, Pushed to Master , C4::Accounts::purge_zero_balance_fees does not check account_offsets
18:30 jenkins * Jonathan Druart: Bug 20325: Do not remove accountlines between tests
18:30 jenkins * kyle: Bug 20325: Remove warning, it is no longer true
18:30 jenkins * fridolin.somers: Bug 17373: Elasticsearch - Authority mappings for UNIMARC - patch1
18:30 jenkins * alex.arnaud: Bug 17373: Add mappings for unimarc authorities - Match index
18:30 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=17373 normal, P5 - low, ---, claire.hernandez, Pushed to Master , Elasticsearch - Authority mappings for UNIMARC
18:30 jenkins * alex.arnaud: Bug 20261: Fix pagination of the results in authority search
18:30 jenkins * Nick Clemens: Bug 18825: Elasticsearch - Update heading main-heading and see fields
18:30 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=20261 major, P5 - low, ---, alex.arnaud, Pushed to Master , No result in some page in authority search opac and pro (ES)
18:30 jenkins * josef.moravec: Bug 20510: Remove unused sub TotalPaid from C4::Stats
18:30 jenkins * julian.maurice: Bug 20516: Show patron's library in pending discharges table
18:30 jenkins * oleonard: Bug 20350: Add column configuration to table of saved reports
18:30 jenkins * Jonathan Druart: Bug 20530: Remove trailing ':' in columns_settings.yml
18:30 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=18825 enhancement, P5 - low, ---, nick, Pushed to Master , Elasticsearch - Update default authority mappings
18:30 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=20510 minor, P5 - low, ---, josef.moravec, Pushed to Master , Remove unused sub TotalPaid from C4::Stats
18:30 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=20516 enhancement, P5 - low, ---, julian.maurice, Pushed to Master , Show patron's library in pending discharges table
18:30 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=20350 enhancement, P5 - low, ---, oleonard, Pushed to Master , Add column configuration to table of saved reports
18:30 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=20530 trivial, P5 - low, ---, jonathan.druart, Pushed to Master , trailing ':' in columns_settings.yml
18:56 ashimema_laptop joined #koha
19:05 khall_away !nick khall_away
19:05 AnnaBoten Error: You don't have the admin capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
19:10 andrew joined #koha
19:12 tcohen how do I make a tooltip translatable?
19:25 tcohen opinions?
19:25 wahanui opinions are slightly divded :)
19:25 * tcohen uploaded an image: image.png (38KB) <https://matrix.org/_matrix/med[…]BGHdkoMDvnVLMecQy>
19:25 tcohen @seen mtompset
19:25 huginn tcohen: mtompset was last seen in #koha 2 hours, 23 minutes, and 44 seconds ago: <mtompset> @later tell khall bug 18821 Sorry had to Failed QA it due to lack of tests, and my brain isn't up to writing them right now.
19:25 Joubu tcohen: git grep tooltip **/*.tt ?
19:31 tcohen the qa rule about line breaks inside TT tags...
19:31 tcohen just highlights problems we don't solve...
19:33 Joubu what do you mean?
19:34 tcohen why doesn't our translation tool consider a TT block an atomic entity?
19:34 Joubu Jenkins is asking a question: how do we want to sort the checkout slip (IssueSlip?). For now it is: desc timestamp, desc issuedate, desc issue_id
19:34 tcohen why does is matter if it is multiline?
19:35 tcohen this construct is invalid in Koha, but correct for any TT example
19:35 tcohen [% variable_1 = value
19:35 tcohen variable_2 = other_value %]
19:35 tcohen [% variable_1 = value
19:35 tcohen variable_2 = other_value %]
19:36 Joubu it makes the po files dirty IIRC
19:39 tcohen Joubu: followup added to 18674
19:47 tcohen bye #koha
19:51 andreashm joined #koha
19:51 huginn News from kohagit: Bug 20531: Prevent IssueSlip.t to fail randomly <http://git.koha-community.org/[…]9cac352b8a0c6ab40>
19:51 * andreashm waves
20:01 kmlussier joined #koha
20:14 kathryn joined #koha
20:15 misilot_ joined #koha
20:31 jenkins Yippee, build fixed!
20:31 wahanui o/ '`'`'`'`'`'`'`'`'`
20:31 jenkins Project Koha_Master_D8 build #423: FIXED in 38 min: https://jenkins.koha-community[…]ha_Master_D8/423/
20:31 jenkins Jonathan Druart: Bug 20531: Prevent IssueSlip.t to fail randomly
20:31 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=20531 minor, P5 - low, ---, jonathan.druart, Pushed to Master , IssueSlip is failing randomly
20:39 alexbuckley joined #koha
20:43 rangi morning
20:45 pastebot joined #koha
20:46 * andreashm waves
20:47 misilot_ joined #koha
20:50 andrew joined #koha
20:57 andrew joined #koha
21:02 wizzyrea hi
21:02 wahanui bonjour, wizzyrea
21:09 andrew joined #koha
21:10 paul_p joined #koha
21:19 misilot_ joined #koha
21:27 Shane-S for /etc/koha/koha-sites.conf it says to add prefix and suffix, what if I don't use that but instead I use libstaff and library and for other instances I use whesstaff and whes should I even modify this file aside from the 8080 for intranet?
21:46 wizzyrea you could ignore that, and just change it in the /etc/apache2/sites-available/<instance>.conf
21:47 wizzyrea (then reload apache)
21:47 wizzyrea Shane-S ^
21:47 wizzyrea i.e. just let it create the instance with the default values, and change it after.
21:48 wizzyrea unless you are going to be making a gazillion instances on the same server, where you want them all to follow a pattern
21:48 wizzyrea it doesn't make a huge amount of sense to worry much about the servernames of the instances from a koha-sites.conf perspective
21:48 wizzyrea because you can always change them later.
21:49 wizzyrea what it *does* make some sense to worry about, is the memcached settings, if you're gonna use that.
21:52 Shane-S someone linked me chart showing it makes heck of a difference with memcached
21:52 wizzyrea it does make things faster.
21:52 Shane-S so I going to try and use that
21:58 Shane-S wizzyrea: ty, for memcached prefix, does that matter domain wise or is it strictly for the servers and their setup. I am not familiar with it, I assume it is enabled by default?
21:58 Shane-S well not enabled but installed, and I have to change use to yes
22:00 Shane-S wizzyrea: nm...wiki says "This may need to be installed first with: sudo apt-get install memcached"
22:06 wizzyrea just leave it, unless you have a good reason why to change it
22:06 wizzyrea if you can't think of one, you don't need to change it :)
22:07 wizzyrea following the wiki is good advice
22:21 Shane-S So I found I have data errors in my old SQL...should I do this on the data before a dump, or after I import it? https://wiki.koha-community.or[…]uto_increment_fix
22:23 misilot_ joined #koha
22:24 paul_p joined #koha
22:26 Shane-S I should note that I will be moving from MySQL to MariaDB on the new server, so would i need worry about it anyway?
22:34 Ladybird joined #koha
22:43 Shane-S tcohen: are you here...if so...when I do zcat...koha-mysql I get Permission denied: /etc/koha/sites/nps/koha-conf.xml
22:44 deb-CSPL joined #koha
22:44 tcohen sudo koha-mysql
22:45 Shane-S here is what I ran "sudo zcat ./koha-2018-04-05.sql.gz | koha-mysql nps"
22:46 Shane-S add sudo after the pipe?
22:46 Shane-S guess I should try vs asking :)
22:47 Shane-S okay thanks now I have to work on an SQL user permission issue
22:49 Shane-S tcohen: anyway to pass a username and password with koha-mysql, man page doesn't mention. and I get this..
22:49 Shane-S ERROR 1044 (42000) at line 22: Access denied for user 'koha_nps'@'localhost' to database 'koha_koha'
22:50 tcohen Does the empty DB exist?
22:54 misilot_ joined #koha
22:56 wizzyrea does the new db match the name of the db you are importing?
23:00 Shane-S koha_koha is from the old server, that is the DB name from old server, I thought I make a new instance name so I did "nps" instead of "koha" what it was named
23:01 Shane-S sorry I took so long..might be taking daughter to ER..she just fell...so I am putting this upgrade on hold.
23:02 wizzyrea um, yes take care of sproggen
23:02 wizzyrea Shane-S: that'll be why your db won't import tho
23:02 wizzyrea because the dump has a different db name in it than the one you are importing into
23:07 Shane-S wizzyrea: can I rename an instance? not a big deal...but when I did this on the original server I didn't know how the instance name was used ;). No ER visit just nice bump on the noggin and an upset child
23:08 wizzyrea just remove the instance and create a new one
23:08 wizzyrea koha-remove koha_nps
23:08 wizzyrea koha-create --create-db koha_koha
23:09 wizzyrea and then reimport the db
23:09 wizzyrea which should work now, since the names are teh same :)
23:09 Shane-S yeah, I just was hoping to use a more "meaningful" name, since I have 2 instances :)
23:09 Shane-S the second one I did right, I named for the location :)
23:11 emucla joined #koha
23:14 Shane-S so I am curious does anyone or any company do remote support for custom install or even migration to a hosted service? Wife and I have a 2yr plan to move, and I don't know if they will get someone as willing as I am to get community support for self-installed servers.
23:14 Shane-S Figure I can provide my school with solution providers when I leave ;)
23:16 dcook_ joined #koha
23:20 Shane-S wizzyrea tcohen ty db imported, I assume I just follow the install steps. Do i have to re-do all the record types, item types, fines, etc stuff?
23:22 wizzyrea you should get the db imported
23:22 wizzyrea and then look. :)
23:23 emucla joined #koha
23:28 misilot_ joined #koha
23:29 Shane-S I had a bunch of error...but I will continue seems to be on an item type..likely the one I made for laptops
23:29 Shane-S https://pastebin.com/bLM2NEK8
23:31 Shane-S hmm...guess I need to run zebra index for search
23:42 Shane-S lols now to do apache stuff
23:42 Shane-S getting there

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary