← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:17 | aleisha joined #koha | |
| 00:28 | stozza joined #koha | |
| 01:07 | Francesca joined #koha | |
| 01:22 | stozza joined #koha | |
| 01:23 | drab joined #koha | |
| 01:23 | drab | hi there |
| 01:23 | I need to move an installation of koha from one domain to another, so it's currently running at host.domain.tld and needs to move to host.domain2.tld | |
| 01:24 | there are refernces to the domain in the apache config and the koha-sites.conf, is it sufficient to alter those? | |
| 01:24 | or is there a better way to do the migration? thanks | |
| 02:14 | Francesca joined #koha | |
| 02:16 | stozza joined #koha | |
| 02:25 | Francesca joined #koha | |
| 02:29 | StomproJ joined #koha | |
| 02:32 | Francesca joined #koha | |
| 03:09 | z0k_ joined #koha | |
| 03:10 | stozza joined #koha | |
| 03:32 | a_goforth joined #koha | |
| 04:04 | stozza joined #koha | |
| 04:55 | alexbuckley joined #koha | |
| 04:59 | stozza joined #koha | |
| 05:04 | cdickinson joined #koha | |
| 05:53 | stozza joined #koha | |
| 06:47 | stozza joined #koha | |
| 06:48 | * magnuse | waves |
| 06:49 | magnuse | stozza: did you see my comment about circulation without barcodes? |
| 06:53 | ashimema | @later tell tcohen That's not really Mojo::JWT's fault.. it's in the JWT Spec. https://tools.ietf.org/html/rfc7519#page-9 and more specifically https://tools.ietf.org/html/rfc7519#page-4 'NumericDate' |
| 06:53 | huginn | ashimema: The operation succeeded. |
| 06:58 | stozza joined #koha | |
| 07:00 | LibraryClaire joined #koha | |
| 07:01 | LibraryClaire | morning #koha |
| 07:05 | cait joined #koha | |
| 07:18 | laurence joined #koha | |
| 07:28 | petter joined #koha | |
| 07:29 | magnuse | kia ora LibraryClaire |
| 07:29 | hei petter! | |
| 07:29 | LibraryClaire | morgen magnuse |
| 07:31 | petter | hei magnus! |
| 07:33 | reiveune joined #koha | |
| 07:33 | reiveune | hello |
| 07:33 | LibraryClaire | salut reiveune |
| 07:45 | stozza joined #koha | |
| 08:03 | petter joined #koha | |
| 08:12 | AndrewIsh joined #koha | |
| 08:22 | gaetan_B joined #koha | |
| 08:22 | gaetan_B | hello |
| 08:22 | LibraryClaire | bonjour gaetan_B |
| 08:33 | fridolin joined #koha | |
| 08:34 | fridolin | hie there |
| 08:36 | LibraryClaire | salut fridolin |
| 08:37 | magnuse | petter: how are things at opl? |
| 08:38 | petter | @magnuse: pretty good1 |
| 08:38 | huginn | petter: I'll give you the answer just as soon as RDA is ready |
| 08:38 | magnuse | yay |
| 08:39 | petter | and you? busy as a bee? |
| 08:39 | magnuse | oh yes, too many things to finish... |
| 08:39 | anyone from opl going to marseille this year? | |
| 08:40 | petter | we're hoping @oha can go, me and benjamin can't |
| 08:40 | are you going? | |
| 08:41 | magnuse | nope, too much other stuff going on |
| 08:42 | trying to get even with All The Things | |
| 08:42 | petter | well good luck with that! |
| 08:45 | paul_p joined #koha | |
| 08:47 | magnuse | petter: thanks :-) |
| 09:09 | benjamin joined #koha | |
| 09:12 | magnuse | kia ora benjamin! |
| 09:20 | benjamin | que @magnuse? |
| 09:20 | cait joined #koha | |
| 09:27 | Francesca joined #koha | |
| 09:28 | eythian | hi |
| 09:28 | @wunder ams | |
| 09:28 | huginn | eythian: The current temperature in Amsterdam, Netherlands is 9.0°C (10:25 AM CET on February 21, 2017). Conditions: Partly Cloudy. Humidity: 82%. Dew Point: 6.0°C. Pressure: 29.98 in 1015 hPa (Steady). |
| 09:28 | LibraryClaire | hi eythian |
| 09:30 | deb-CSPL joined #koha | |
| 09:49 | irma joined #koha | |
| 10:13 | nlegrand | Bonjour #koha! |
| 11:09 | gaetan_B joined #koha | |
| 11:19 | drab joined #koha | |
| 11:21 | z0k_ joined #koha | |
| 11:31 | cait joined #koha | |
| 11:36 | rsantellan joined #koha | |
| 11:37 | rsantellan | good morning #koha |
| 11:45 | cait | hi rsantellan |
| 11:56 | * magnuse | waves |
| 12:12 | cait1 joined #koha | |
| 12:27 | jzairo joined #koha | |
| 12:29 | Dyrcona joined #koha | |
| 12:32 | meliss joined #koha | |
| 12:35 | francharb | Morning! |
| 12:36 | druthb | Good morning, francharb! |
| 12:36 | stozza | I am about to do some test with importing stuff into catalog in batches, what is the best way to backup current status and restore it if I break something? |
| 12:37 | do I need to backup the mysqldb or there is a better/faster way? | |
| 12:37 | francharb | o/ druthb |
| 12:37 | * francharb | hugs druthb |
| 12:38 | druthb | :D |
| 12:39 | eythian | stozza: see koha-dump, and copy the files it makes off the machine so you don't accidentally lose them |
| 12:39 | magnuse | stozza: backing up the database sounds like a good idea |
| 12:39 | stozza: did you see my comment about circulation without barcodes? https://koha-community.org/man[…]odeFallbackSearch | |
| 12:40 | stozza | lovely |
| 12:42 | I have to say it took some hours to dig into koha and understanding how it works from scratch but after the first fight now I love it, it's a very fine piece of software | |
| 12:42 | oleonard joined #koha | |
| 12:42 | cait1 | :) |
| 12:43 | * druthb | waves to cait1 and magnuse |
| 12:43 | oleonard | And me! |
| 12:43 | * cait1 | waves to oleopard |
| 12:43 | stozza | then, me too! |
| 12:44 | * druthb | waves to oleonard and stozza, as well |
| 12:44 | cait1 | hehe |
| 12:45 | * magnuse | waves to all the people |
| 12:45 | magnuse | and the bots |
| 12:51 | * francharb | too |
| 12:53 | nengard joined #koha | |
| 12:55 | eythian | http://i.imgur.com/qUtu9ha.jpg (sorry) |
| 12:56 | stozza | can I create custom matching rules for marc batch imports? |
| 12:56 | druthb | eythian, that's brilliant. Also, terrible. |
| 12:57 | stozza | yes, I can. thanks :) |
| 13:00 | cait1 | yep |
| 13:00 | heh | |
| 13:01 | stozza: you will need to know the zebra index names if you want to do something totally different than is already set up | |
| 13:02 | stozza | I just want to match same ISBN |
| 13:02 | cait1 | ah :) |
| 13:02 | did you install the sample matching rules? | |
| 13:02 | there should be one for isbn then i think | |
| 13:02 | stozza | nope doing one from scratch, is there one already done? |
| 13:03 | cait1 | are you unimarc or marc21 now? |
| 13:03 | stozza | I staid on unimarc |
| 13:03 | now I understood how to map fields and use authorized values, I think I have done almost everything I was looking for | |
| 13:03 | cait1 | hm only have the one for marc21 |
| 13:04 | stozza | I am trying to do the rule let's see what happens |
| 13:05 | cait1 | ok |
| 13:05 | search index on mine is isbn | |
| 13:05 | :) | |
| 13:07 | stozza | same here I think looking at ccl.properties |
| 13:09 | edveal1 left #koha | |
| 13:09 | stozza | the only doubt I have is, I want to check if a record I am importing is a duplicate of an existing one, but also want to check if two records in the same import are overlapping |
| 13:10 | does the matching rule apply also in that case? | |
| 13:24 | nlegrand | I think I found a bug in C4::Reserves::CanItemBeReserved from 6.11 to master: by the middle of the function, Koha::Items->find( $itemnumber ) is affected to $item and and crush the preceding value of GetItem($itemnumber) |
| 13:25 | biblibre_ joined #koha | |
| 13:25 | nlegrand | but at the end of the function there is a $item->{homebranch} that should be $item->homebranch. If you have independant branches and ! canreservefromotherbranches you'll always get a return of cannotReserveFromOtherBranches |
| 13:26 | the fix is simple, I was wondering if someone was on it? | |
| 13:28 | magnuse | nlegrand: have you checked bugzilla? |
| 13:31 | NateC joined #koha | |
| 13:32 | nlegrand | magnuse: yep, didn't find something relevant, that's why I'm checking here :) |
| 13:32 | magnuse | good! :-) |
| 13:44 | cait1 | nlegrand: please report with test plan :) |
| 13:44 | nlegrand | cait1: ok :) |
| 13:44 | cait1 | stozza: the matching uses zebra - but if the record is not indexed yet, it won't catch the duplicate |
| 13:45 | stozza | ok then I need to clean the file before importing |
| 13:45 | cait1 | so only import when your indexes are current and duplicates within an import are a problem |
| 13:46 | stozza | I guess I'll need to brush up some scripting capabilities.. |
| 13:48 | or I need to tell yaz to only take the first entry of each isbn lookup | |
| 13:52 | cait1 | another trick... import basic records created from your isbn list first and match against those with overlay |
| 13:52 | then the would all overlay the same record and this way create no duplicates | |
| 13:52 | hm well need a deduplicated list for that... might be more work | |
| 13:55 | stozza | marcedit may have some duplicate-removal functionality, let's see |
| 14:11 | JoshB joined #koha | |
| 14:14 | paul_p joined #koha | |
| 14:25 | talljoy joined #koha | |
| 14:25 | magnuse | kia ora talljoy |
| 14:25 | talljoy | hiya magnuse |
| 14:26 | * LibraryClaire | waves |
| 14:26 | edveal1 joined #koha | |
| 14:26 | * kidclamp | waves back |
| 14:28 | LibraryClaire | hi kidclamp |
| 14:29 | edveal1 left #koha | |
| 14:29 | kidclamp | good morning |
| 14:29 | francharb joined #koha | |
| 14:29 | edveal1 joined #koha | |
| 14:30 | tcohen joined #koha | |
| 14:30 | tcohen | hi |
| 14:31 | edveal1 | I am feeling a bit repeditive today... LOL Apparently I am logged in at work and a home. |
| 14:31 | Whish I could get two peoples worth of work done today. | |
| 14:33 | kmlussier joined #koha | |
| 14:35 | mtompset_testing joined #koha | |
| 14:35 | mtompset | Greetings. |
| 14:35 | Greeitngs, koha. | |
| 14:36 | Greetings, #koha. | |
| 14:36 | Third time's a charm. :) | |
| 14:38 | fridolin left #koha | |
| 14:40 | oha | Joubu, ashimema, all: a quick update. I managed to move all the code of reserver/request.pl into a function. this function is now called by a script that provide all the environment used by it without changing it. which means that I reimplemented one of the possible authentication and session handling outside C4::Auth |
| 14:40 | it's far from being finished, but it should be easy from there to have a pluggable system for authentication | |
| 14:40 | fridolin joined #koha | |
| 14:40 | oha | permissions works as well, i believe, but the code was quite complicate and it will take time to check it properly |
| 14:43 | mtompset | oha: Why would you reimplement authentication and session handling outside of C4::Auth? |
| 14:44 | Sorry for cutting in on the conversation. :) | |
| 14:44 | oha | I want to see how hard is to go away from CGI |
| 14:45 | also, i would like to separate authentication, permissions and session handling | |
| 14:45 | it sprouted from bug 17427 | |
| 14:45 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=17427 normal, P5 - low, ---, jonathan.druart, Failed QA , Replace CGI::Session with Data::Session |
| 14:47 | mtompset | Interesting. |
| 14:47 | I was testing authentication with OpenID the other day, and discovered it was broken. | |
| 14:47 | Bug 18144 | |
| 14:47 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18144 normal, P5 - low, ---, mtompset, Needs Signoff , Removal of persona broke openidconnect |
| 14:48 | ashimema | poop |
| 14:48 | I mussed have missed that when QA'ing.. oops | |
| 14:48 | would be lovely to have proper separation on concerns there oha.. so happy your looking into this.. | |
| 14:49 | my brain is currently melting over OAuth2 in another project of mine at the moment.. I hope to come back to koha very soon | |
| 14:51 | mtompset | ashimema: Check if bug 18144 fixes it for you. :) |
| 14:52 | ashimema | looks sensible |
| 14:53 | oha | mtompset: if I'm right, will be way easier to deal with different auth systems... but... it will be just for plack |
| 14:54 | at least for now, it might be possible to use mod_perl in apache2... although i really can't see the point | |
| 14:54 | mtompset | BTW, should we not be modifying kohastructure.sql (or whatever it is) if we are adding a system preference? |
| 14:56 | oha | mtompset: I believe they are unrelated? |
| 14:57 | mtompset | the system preference inquiry is a new unrelated thread. :) |
| 14:58 | Broken Oauth2 in Koha master is vaguely related on authentication methods. :) | |
| 15:00 | magnuse | mtompset: not kohastructure.sql but installer/data/mysql/sysprefs.sql |
| 15:01 | oha | oh yeah, sorry... i'm a bit tired after refactoring get_template_and_user and co. |
| 15:01 | mtompset | magnuse: Oh right... brain needs more caffeine, it seems. |
| 15:01 | magnuse | this might be current: https://wiki.koha-community.or[…]system_preference |
| 15:01 | mtompset | I'm confusing adding a table and system preference in my brain. |
| 15:02 | someone pass an extra dose of caffeine. :) | |
| 15:02 | Greetings, ashimema magnuse oha :) | |
| 15:02 | You refactored get_template_and_user and company?! | |
| 15:03 | where? where? I so want to test partially. :) | |
| 15:03 | oha | yes, that's what i was trying to explain |
| 15:03 | oh, ain't finished yet | |
| 15:03 | will take a while | |
| 15:03 | that is sort of part of it | |
| 15:03 | since it entangles cgi and sesssion and stuff | |
| 15:04 | mtompset | Actually...the mess that is C4::Auth... I'd like to be able to have a screen... |
| 15:04 | listing all possible authentication methods. | |
| 15:04 | check the active ones. | |
| 15:14 | alohalog` joined #koha | |
| 15:14 | Topic for #koha is now Welcome to the #koha IRC chat | Code of conduct - https://koha-community.org/abo[…]/code-of-conduct/ | Please use http://paste.koha-community.org for pastes | Installation guide for Koha is https://wiki.koha-community.org/wiki/Debian | |
| 15:14 | ashimema | lol |
| 15:14 | right.. | |
| 15:14 | school pickup time.. laters people | |
| 15:14 | mtompset | take care. |
| 15:18 | tcohen | @seen Joubu |
| 15:18 | huginn | tcohen: Joubu was last seen in #koha 23 hours, 32 minutes, and 21 seconds ago: <Joubu> rewrite-config is used from makefile actually.. |
| 15:20 | mtompset | Greetings, tcohen |
| 15:21 | CrispyBran joined #koha | |
| 15:21 | mtompset | Greetings, alohalog` CrispyBran |
| 15:22 | CrispyBran | hello :) |
| 15:24 | AdamB joined #koha | |
| 15:31 | cait joined #koha | |
| 15:41 | jac joined #koha | |
| 15:49 | jbeno joined #koha | |
| 15:54 | CrispyBran | Just added this: https://wiki.koha-community.or[…]_permissions_page |
| 15:55 | kellym joined #koha | |
| 16:02 | oleonard | jajm: Regarding Bug 15219, how many checkouts should appear on a page with server-side pagination enabled? |
| 16:02 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=15219 enhancement, P5 - low, ---, julian.maurice, Needs Signoff , Server-side processing and pagination on checkouts tables |
| 16:02 | eythian | @later tell rangi y'know, I bet having a little upvote thing for the jquery library would be a great source of academy projects for moving the popular+appropriate ones into koha proper. |
| 16:02 | huginn | eythian: The operation succeeded. |
| 16:03 | oleonard | @later tell rangi I heard eythian wants to upgrade MediaWiki for us. You should ask him about it. |
| 16:03 | huginn | oleonard: The operation succeeded. |
| 16:04 | jajm | oleonard, same as when server-side pagination is disabled, it's controlled by the select in the datatables header |
| 16:04 | oleonard | Thanks |
| 16:06 | eythian | @later tell rangi also, I think something's wrong with oleopard. He's saying strange things. |
| 16:06 | huginn | eythian: The operation succeeded. |
| 16:09 | druthb | lol |
| 16:13 | drab | hi everybody, is there anything special that needs to be done to move a koha intallation from debs (on ubuntu) to another domain? besides changing the apache config and koha-sites.conf |
| 16:13 | is there something in the db that needs to be adjusted too? | |
| 16:16 | ombutsman joined #koha | |
| 16:16 | eythian | drab: not particularly, but you might have one or two sysprefs that need updating. |
| 16:17 | drab | mmmh, ok, I'll check for those, thank you |
| 16:17 | LibraryClaire left #koha | |
| 16:17 | ombutsman | hi, we got a request from another department to let them manage their library with our koha instance. So i created a new library and a staff user under that library. But the staff in the second library can view and modify items in the first library. How do I limit staff to libraries? |
| 16:20 | oleonard | ombutsman: Take a look at the IndependentBranches system preference |
| 16:20 | ombutsman: Although I don't think that prevents viewing between libraries. | |
| 16:21 | ombutsman: Is your goal for Library A to be able to see Library B but not the reverse? | |
| 16:22 | ombutsman | staff in library A should not modify items or circulate books in library B and vice versa |
| 16:22 | oleonard | What about seeing items in the collection? |
| 16:22 | ombutsman | That's ok. |
| 16:23 | oleonard | Okay so I think IndependentBranches is what you want |
| 16:24 | fridolin left #koha | |
| 16:25 | Scott-CSPL joined #koha | |
| 16:31 | ombutsman | oleonard: One more thing, the patrons in library B (the new library) is a subset of the patrons in library A. So how do I allow the subset of patrons to issue X number of books from library B? |
| 16:32 | X number of extra books | |
| 16:32 | oleonard | ombutsman: Circulation and fine rules settings may do what you want but I'm not sure. |
| 16:36 | baptiste joined #koha | |
| 16:38 | ombutsman | one hurdle is that the subset is identified by a authorized value in sort1. I want to know how to specify this subset using sort1 authorized value in circulation rules. |
| 16:41 | laurence left #koha | |
| 16:42 | oleonard | ombutsman: I think you can't do what you want using IndependentBranches, because it doesn't allow you to have overlapping sets like that |
| 16:46 | ombutsman | So i'll have to duplicate patrons, where the only field with difference is the "Library" field. :9 |
| 16:47 | mtompset | khall is supposedly working on fixing that, but it could be a while off. :) |
| 17:00 | LibraryClaire joined #koha | |
| 17:01 | oleonard | Welcome back LibraryClaire how was the outside world I hear it's terrible |
| 17:02 | LibraryClaire | confusing |
| 17:02 | and wet | |
| 17:02 | ombutsman | So currently, if I want to do it, I'll have to duplicate patrons. In that case, I want patrons in Library A to not be listed when searching for patrons in library B. Any idea how? |
| 17:07 | oleonard | ombutsman: I don't know. |
| 17:07 | ombutsman | thanks, anyway! |
| 17:08 | oleonard | I was trying to test jajm's Bug 15219 but I keep running into a DataTables error which is in master too. |
| 17:09 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=15219 enhancement, P5 - low, ---, julian.maurice, Needs Signoff , Server-side processing and pagination on checkouts tables |
| 17:09 | oleonard | "TypeError: invalid 'in' operand a" |
| 17:10 | I assume it's related to the checkout data but I'm not sure how to diagnose. | |
| 17:10 | rocio_afk joined #koha | |
| 17:12 | rocio_afk joined #koha | |
| 17:13 | drab left #koha | |
| 17:25 | Shane-S joined #koha | |
| 17:26 | Shane-S | so.. koha-restore...from 3.20 to 6.11 and usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 713, says DBD::mysql::st execute failed: Unknown column 'me.new_status' in 'field list' |
| 17:26 | I am screwed from a nice easy migration aren't I | |
| 17:27 | I am hoping it is because I am using Ubuntu and install MariaDB...and I need a step before koha-restore | |
| 17:29 | tcohen joined #koha | |
| 17:29 | tcohen | @wunder cordoba, argentina |
| 17:29 | huginn | tcohen: The current temperature in Cordoba, Argentina is 33.0°C (2:00 PM ART on February 21, 2017). Conditions: Partly Cloudy. Humidity: 59%. Dew Point: 24.0°C. Pressure: 29.95 in 1014 hPa (Falling). |
| 17:32 | * cait | waves |
| 17:34 | Shane-S | If I installed MariaDB instead of MySQL would Koha even know/care (as in a need to change a config), or should it just work? |
| 17:50 | are there any commands I can issue to koha / package to test MariaDB connection to see if I am missing a step there? | |
| 17:52 | cait | have you looked at the wiki for mariadb? |
| 17:53 | it hink ther emight be some hints there | |
| 17:54 | Shane-S | I haven't I will head over there I guess |
| 17:55 | cait | i haven't done it so far, but i had the impression it should basically just work |
| 18:01 | mtompset | ARG! I wish system preferences were case sensitive. |
| 18:02 | * mtompset | grumbles about ReplytoDefault and ReplyToDefault |
| 18:02 | cait | * |
| 18:02 | ? | |
| 18:10 | Shane-S | well I will try the import again, apparently I had done a "sudo" when I should not have, and I couldn't login to mysql at all, it require sudo mysql, vs mysql |
| 18:19 | Well I had to edit the script SQL credentials file...but still same error...so it is connecting to SQL..http://paste.koha-community.org/322 | |
| 18:21 | Wonder if I can just drop the me.status column from the SQL file | |
| 18:45 | cait | what are you trying to do? |
| 18:45 | and is your database empty? or did you run the web installer on it? | |
| 18:45 | mtj | Shane-S: hmm, are you sure your db's schema is upgraded to your new koha version? |
| 18:45 | cait | which version of Koha is that? |
| 18:46 | new_status is either 16.05 or 16.11, but it should be on items | |
| 18:47 | Shane-S | cait: mtj I am trying to move from 3.20 to 6.11 by doing koha-dump (on 3.20) and importing using koha-restore on 6.11 server |
| 18:47 | mtj | $ sudo koha-restore mylib |
| 18:47 | $ sudo koha-upgrade-schema mylib | |
| 18:48 | cait | khall: still around? |
| 18:48 | 16.11 :) | |
| 18:48 | Shane-S | yeah that one ;) |
| 18:49 | cait | ok, so you installed koha fresh and want to use your old db? |
| 18:49 | khall | what's up? |
| 18:49 | cait | Joubu wanted one bug fixed in the release |
| 18:49 | * mtj | isnt sure koha-restore upgrades the db - (afaik it expects the restore is happening on the same koha version, as the dump) |
| 18:49 | Shane-S | Yeah totally seperate Vms |
| 18:49 | cait | and i was hoping to do the release tomorrow morning |
| 18:49 | do you have time to look at bug 18111 maybe? | |
| 18:49 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18111 major, P5 - low, ---, jonathan.druart, Passed QA , Import default framework is broken |
| 18:49 | Shane-S | 3.20 is on a 14.xx LTS ubuntu, 16.11 is on 16.04LTS |
| 18:49 | cait | and 7143 should be super fast - one letter change |
| 18:50 | Shane-S | let me try schema |
| 18:50 | cait | did the web installer kick in? |
| 18:50 | after you restroed the database? | |
| 18:51 | Shane-S | That pastebin error is from the koha-restore |
| 18:51 | it never gets through the SQL | |
| 18:51 | from 3.20 | |
| 18:51 | mtj | Shane-S: seems like rebuild.pl might be barfing on an old 3.20 db |
| 18:51 | Shane-S | which was upgraded a bunch of time (like first version you guys had packages...old) |
| 18:52 | can I upgrade 3.20 schema without breaking it? | |
| 18:53 | 3.20 is live production site, I am trying to do this behind the scenes without downtime firs the library | |
| 18:53 | cait | i have never used koha-restore |
| 18:53 | so not sure how it works exactly | |
| 18:53 | i usually have a database dump that i load into an empty db | |
| 18:53 | mtj | never test on a prod db |
| 18:53 | cait | yep |
| 18:53 | edveal1 left #koha | |
| 18:54 | cait | mtj: do you know koha-restore? |
| 18:54 | would it barf on a db where the web installer has bene run? | |
| 18:54 | mtj | cait: ive never used it either |
| 18:55 | cait | hm wiki says: Before restoring an instance you should koha-remove it first. |
| 18:55 | Shane-S: how did you create your file that you use for restoring? | |
| 18:55 | Shane-S | with koha-dump |
| 18:55 | cait | ok |
| 18:55 | Shane-S | the I SSH'ed it onto the new server |
| 18:55 | jbeno joined #koha | |
| 18:56 | mtj | koha-restore does not upgrade the schema |
| 18:56 | cait | and how do you run the restore? |
| 18:56 | Shane-S | then I ran koha-restore on the 16.11 server |
| 18:56 | it had no instances installed | |
| 18:56 | cait | what's your command? |
| 18:56 | Shane-S | sudo koha-restore ./koha-2017-02-21.sql.gz ./koha-2017-02-21.tar.gz |
| 18:56 | mtj | Shane-S: your db is still at version 3.20 |
| 18:57 | cait | yeah |
| 18:57 | it might be koha-restore is not made for updates? | |
| 18:57 | but more for desaster recovery? | |
| 18:57 | same version to same version? | |
| 18:57 | mtj | cait: yes ^ |
| 18:58 | Shane-S | what I am thinking too...but how can I schema fix it without another 3.20 server |
| 18:58 | cait | Shane-S: there might be another way of doing this, but what i would try is doing a mysqldump on your prod server |
| 18:58 | and then load this sql file into the db | |
| 18:58 | instance created, web installer not run | |
| 18:58 | what do you think mtj? | |
| 18:59 | I think then the web installer should kick in and update your db to the version that matches the code | |
| 18:59 | Shane-S | So basically: https://wiki.koha-community.or[…]e_a_Koha_instance then stop...and try https://wiki.koha-community.or[…]ha-upgrade-schema |
| 19:01 | cait | you might be able to use the --defaultsql even of koha-create |
| 19:01 | https://wiki.koha-community.or[…]kages#koha-create | |
| 19:03 | the manula page might have more information than the wiki | |
| 19:03 | mtj | cait: what i think is .. Shane-S should test the upgrade procedure on a non-prod koha first :) |
| 19:04 | Shane-S | mtj: 16.11 is a non-production, I am trying this form now since I need the upgrade for summer :) |
| 19:04 | cait | i thought he was testing on a new server? |
| 19:04 | ah :) | |
| 19:05 | mtj | its safe to re-run koha-upgrade-schema on a db |
| 19:06 | cait | mtj: i tihnk the db didn't load - given the error during koha-restore |
| 19:06 | paste | |
| 19:06 | wrong window | |
| 19:07 | Shane-S | mtj / cait : I have a database w/ tables, I am checking for data |
| 19:07 | cait | ah hm maybe it did |
| 19:07 | then mtj's suggestion is good | |
| 19:07 | mtj | $ sudo koha-upgrade-schema mylib |
| 19:09 | ah whew, sorry - i though you were attempting to upgrade the prod koha | |
| 19:10 | Shane-S | mtj: oh gosh know I am an idiot at time and edit live production websites, but I wouldn't kill my entire library database |
| 19:10 | now...that executed...but...now I need to get the web-interface up | |
| 19:11 | apparently apache isn't responding to Koha domains..getting default apache page. I guess I have to check a sites file | |
| 19:11 | I left them at the default and changed my host file | |
| 19:11 | should be koha-intra.myDNSname.org | |
| 19:12 | mtj | i often copy /etckoha and /etc/apache dirs btw servers |
| 19:14 | Shane-S | if 000-default.conf is still in site-enabled...would that stop the koha.conf in there? |
| 19:14 | i know ##apache | |
| 19:15 | mtj | its not needed.. so can be removed |
| 19:18 | Shane-S | yeah now the catalog loads...but I want the install |
| 19:18 | mtj | koha-rebuild-zebra should now work ok, after db upgrade |
| 19:18 | Shane-S | yeah I want to get to the admin side...I have more apache stuff to fix |
| 19:20 | mtj | remember... you have a working prod server to crib from :) |
| 19:23 | Shane-S | according to the koha-site.conf (which I left untouched) it should be koha-intra.myDNSname.org to access the non OPAC...but both that and koha.myDNSname.org load OPAC |
| 19:23 | so I definite have to fix something in apache | |
| 19:23 | and yes...koha is my instance/library name | |
| 19:23 | I didn't know to call it something else the first time I made the production server :P | |
| 19:24 | I was trying out Koha and Evergreen...and Koha won ;) | |
| 19:27 | Oh Apache...we are old friends who have been apart for so long you are like a total stranger with a familiar face | |
| 19:28 | oleonard | Bye all |
| 19:29 | Shane-S | I think my old O'Reilly books was like 2nd edition...probably on like 10th by now |
| 19:31 | * Shane-S | oh okay you imported the domains too! |
| 19:31 | modifies his host file YET again | |
| 19:33 | edveal1 joined #koha | |
| 19:36 | cait | khall |
| 19:36 | hm, seems i lost you after what's up :) | |
| 19:36 | khall | indeed, sorry |
| 19:38 | cait: what did you need? | |
| 19:42 | Shane-S | cait: Thank you! |
| 19:42 | mtj: Thank you! | |
| 19:42 | For now...I have to play around...but currently...Koha version:16.11.03.000 | |
| 19:43 | kathryn joined #koha | |
| 19:43 | Shane-S | I just had to get my Host file set and Apache listening on 8080 |
| 19:43 | Hopefully the data is there, but I logged in with my username on the intranet | |
| 19:46 | running a zebra rebuild now...and then a catalog search *crosses fingers* | |
| 19:52 | hmm is there a way to check the status of zebraindex? like query the zebraqueue table or something? | |
| 19:54 | cait | zebraqueue will only have entries if you do something now |
| 19:54 | a full reindex won't add anything there | |
| 19:54 | did you do one with -f? | |
| 19:55 | Shane-S | I just did the package command |
| 19:55 | koha-rebuild-zebra <instancename> | |
| 19:55 | I have nothing in my catalog atm, but I know from a past install that was because Zebra hadn't run | |
| 19:55 | and a query of items showed results | |
| 19:56 | so there should at least be 5 items (I did a select * from item limit 5) | |
| 19:56 | cait | i think you need to do a -f for a full reindex |
| 19:56 | Shane-S | okay thanks |
| 19:56 | cait | which is what you want after moving things around usually |
| 19:56 | Shane-S | P.S...funny...but not...https://wiki.koha-community.or[…]our_zebra_running.3F |
| 19:57 | I was looking for a real answer ;) | |
| 19:57 | cait | heh |
| 19:57 | I think you should be able to see it in the processes | |
| 19:57 | zebrasrv | |
| 20:00 | Shane-S | yeah, I needed the full thing, I just wanted to know what to look for in something like top |
| 20:02 | huginn | New commit(s) kohagit: Bug 16034 - DBRev 16.12.00.010 <http://git.koha-community.org/[…]25f20a57737a76512> / Bug 16034 follow-up: added WebService::ILS to PerlDependencies <http://git.koha-community.org/[…]806b04832f402833f> / bug_16034 Add overdrive info to the users page in the public interface <http://git.koha-community.org/gitweb/?p=koh |
| 20:08 | Shane-S | *sigh* ran zebra twice...catalog is blank, search is null |
| 20:09 | well I am tired for the day, thank you again guys....I will see if I can tackle this more tomorrow... | |
| 20:21 | mtompset | Shane-S: Make sure you stop zebra before a full reindex and then restart it after. That's frequently been my problem. :) |
| 20:21 | wizzyrea | I have not once ever had to do that. |
| 20:21 | mtompset | I have to all the time. |
| 20:22 | cait | hm same here wizzyrea - never do that |
| 20:22 | * mtompset | shrugs. |
| 20:22 | mtompset | Whatever works. :) |
| 20:22 | Have a good day, #koha wizzyrea Shane-S cait | |
| 20:52 | cait | time to prepare a release :) |
| 20:52 | wizzyrea | \o/ |
| 20:52 | I am excited about this one. | |
| 20:52 | cait | me too |
| 20:52 | should be the biggest one so far int erm of bug fixes | |
| 20:52 | wizzyrea | it fixes some baddies. |
| 20:53 | cait | khall++ all stuff pushed :) |
| 20:53 | yep | |
| 20:53 | hope i didn#t miss something | |
| 20:54 | or will miss | |
| 20:55 | will try to push last things now and release tomorrow with hopefully green jenkins | |
| 21:35 | jenkins | Project Koha_Master_D8 build #116: STILL UNSTABLE in 1 hr 37 min: https://jenkins.koha-community[…]ha_Master_D8/116/ |
| 21:35 | * kyle: Bug 18111: Fix import of default framework | |
| 21:35 | * kyle: Bug 18111: Swap framework_name and frameworkcode | |
| 21:35 | * kyle: Bug 18026: Correct URL to database columns from .pref files | |
| 21:35 | * kyle: Bug 17865 'If a subscription has no history end date, it shows as | |
| 21:35 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18111 major, P5 - low, ---, jonathan.druart, Pushed to Stable , Import default framework is broken |
| 21:35 | jenkins | * kyle: Bug 17852; Multiple URLs (856) in list email are broken. |
| 21:35 | * kyle: Bug 17852 Follow up.Multiple URLs (856) in list email are broken | |
| 21:35 | * kyle: Bug 18109: Adding font awesome icon to uncertain prices button | |
| 21:35 | * kyle: Bug 18077: Batch item modification link is bold when batch item deletion | |
| 21:35 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18026 normal, P4, ---, jonathan.druart, Pushed to Master , URL to database columns link in system preferences is incorrect |
| 21:35 | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=17865 normal, P5 - low, ---, luke.honiss, Pushed to Stable , If a subscription has no history end date, it shows as expired today in OPAC | |
| 21:35 | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=17852 enhancement, P5 - low, ---, caitlingoodger.student, Pushed to Stable , Multiple URLs (856) in list email are broken | |
| 21:35 | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18109 enhancement, P5 - low, ---, aleishaamohia, RESOLVED FIXED, Uncertain prices has no font awesome icon in acquisitions toolbar | |
| 21:35 | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18077 enhancement, P5 - low, ---, aleishaamohia, RESOLVED FIXED, Batch item modification link is bold when batch item deletion is active in tools menu | |
| 21:41 | cait | 44 bug |
| 21:41 | s | |
| 21:43 | jenkins | Yippee, build fixed! |
| 21:43 | Project Koha_Master_D8 build #117: FIXED in 7 min 37 sec: https://jenkins.koha-community[…]ha_Master_D8/117/ | |
| 21:43 | * kyle: bug_16034 Koha::ExternalContent::OverDrive - a wrapper around | |
| 21:43 | * kyle: bug_16034 Adding a new syspref - OverDriveCirculation | |
| 21:43 | * kyle: bug_16034 Add overdrive info to the users page in the public interface | |
| 21:43 | * kyle: Bug 16034 follow-up: added WebService::ILS to PerlDependencies | |
| 21:43 | * kyle: Bug 16034 - DBRev 16.12.00.010 | |
| 21:43 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=16034 enhancement, P5 - low, ---, srdjan, RESOLVED FIXED, Integration with OverDrive Patron API |
| 21:54 | wizzyrea | cool about the overdrive thing |
| 22:00 | JoshB left #koha | |
| 22:05 | irma joined #koha | |
| 22:14 | Francesca joined #koha | |
| 22:15 | kathryn joined #koha | |
| 22:36 | khall joined #koha | |
| 23:02 | Francesca joined #koha | |
| 23:09 | reiveune | bye |
| 23:09 | reiveune left #koha | |
| 23:10 | dilan joined #koha | |
| 23:17 | kathryn joined #koha | |
| 23:27 | papa joined #koha | |
| 23:48 | NateC joined #koha | |
| 23:55 | irmab joined #koha |
← Previous day | Today | Next day → | Search | Index