← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:00 | jcamins | The markup is just staggering. As far as I can tell, every li has its own ul, and they're all nested. |
| 00:00 | Okay... | |
| 00:00 | holidays. | |
| 00:01 | Where are they configured? | |
| 00:01 | Tools->Calendar? | |
| 00:03 | wizzyrea | ummm one sec |
| 00:03 | jcamins | I think that's right. |
| 00:03 | I'm trying it. | |
| 00:03 | If it doesn't work, we'll know that I got it wrong. | |
| 00:03 | wizzyrea | yep, that's it |
| 00:04 | nice work in a month by the way, koha looks really nice :) | |
| 00:04 | jcamins | Well... |
| 00:04 | oh dear.' | |
| 00:04 | wizzyrea | that's not a good sign |
| 00:04 | jcamins | Nooo. |
| 00:04 | I think circ is broken. | |
| 00:05 | Check-in. | |
| 00:05 | wizzyrea | OY!\ |
| 00:05 | let me check 1s | |
| 00:06 | jcamins | I'm getting an "unknown column in field list" error now that I made all SQL errors fatal. |
| 00:06 | maximep left #koha | |
| 00:06 | jcamins | Oh, wait. |
| 00:06 | It's in Stats. | |
| 00:06 | Not quite as bad. | |
| 00:06 | wizzyrea | well, I was just able to circ a book |
| 00:06 | on master | |
| 00:06 | are you testing a bug? | |
| 00:07 | jcamins | I was going to test bug 8800. |
| 00:07 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8800 blocker, P5 - low, ---, tomascohen, Passed QA , SpecifyDueDate && useDaysMode=Datedue wrong behaviour |
| 00:07 | jcamins | However, that's not what I was doing at the moment. |
| 00:07 | wizzyrea | ohh are you on mariadb now? |
| 00:08 | jcamins | I was just trying to check in a book. |
| 00:08 | Yes I am. | |
| 00:08 | But the fact that a field is missing isn't MariaDB-specific. | |
| 00:09 | ccode in stats... | |
| 00:09 | This rings a bell. | |
| 00:09 | A distant bell. | |
| 00:09 | I don't think I touched that patch. | |
| 00:10 | Nope. Not one I pushed. | |
| 00:12 | Oh good lord. | |
| 00:54 | wizzyrea left #koha | |
| 01:09 | huginn | New commit(s) kohagit: Merge branch 'bug_9039' into 3.12-master <http://git.koha-community.org/[…]9c6e96ee48c753918> / Bug 9039 - Tests in the basic test suite should only test code based on required... <http://git.koha-community.org/[…]e1aa2711e73a10e85> / Merge branch 'bug_9050' into 3.12-master <http://git.koha-community.org/gitweb/?p=ko |
| 01:12 | jenkins_koha | Starting build #941 for job Koha_master (previous build: FIXED) |
| 01:39 | jdattetakere joined #koha | |
| 01:45 | druthb | Hi, magnuse. :) |
| 01:46 | * jcamins | pokes jenkins impatiently. |
| 01:46 | * druthb | pokes jcamins, since jenkins cannot defend itself. |
| 01:51 | wizzyrea joined #koha | |
| 02:23 | jenkins_koha | Project Koha_master build #941: SUCCESS in 1 hr 10 min: http://jenkins.koha-community.[…]/Koha_master/941/ |
| 02:23 | * cnighswonger: Bug 7119 - tidy t/00-load.t | |
| 02:23 | * cnighswonger: Bug 9036 - 00-load.t checks Koha::Cache::Memcached when it should not this patch adds code to skip this module during this test | |
| 02:23 | * jcamins: Bug 9054: 00-load should not try to load modules with optional dependencies | |
| 02:23 | * Paul Poulain: Bug 8892 fix Plack scoping in acquisition | |
| 02:23 | * nengard: Bug 8945: Add missing acq help file | |
| 02:23 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7119 critical, P5 - low, ---, paul.poulain, Pushed to Master , general code-cleaning, tidy/whitespace omnibus |
| 02:23 | jenkins_koha | * jcamins: Bug 9050: Use safer adelete when deleting records from Zebra index |
| 02:23 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9036 critical, P5 - low, ---, cnighswonger, Pushed to Master , 00-load.t checks Koha::Cache::Memcached when it should not |
| 02:23 | jenkins_koha | * cnighswonger: Bug 9039 - Tests in the basic test suite should only test code based on required dependencies/modules |
| 02:23 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9054 critical, P5 - low, ---, jcamins, Pushed to Master , 00-load should not try to load modules with optional dependencies |
| 02:23 | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8892 major, P1 - high, ---, paul.poulain, Pushed to Master , Plack variable scoping in basket.pl | |
| 02:23 | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8945 major, P5 - low, ---, nengard, Pushed to Master , Koha 3.10 Help Files Update | |
| 02:23 | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9050 major, P5 - low, ---, gmcharlt, Pushed to Master , rebuild_zebra should use the adelete action so it doesn't fail when deleting a record not in the index | |
| 02:23 | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9039 major, P5 - low, ---, cnighswonger, Pushed to Master , Tests in the basic test suite should only test code based on required dependencies/modules | |
| 02:23 | jcamins | Woohoo! |
| 02:24 | wizzyrea | \o/ |
| 03:11 | eythian | http://tranquillpoet.com/ <-- an IDE for poets |
| 03:22 | I think from now, every script that produces something e.g. an SQL file will put the invocation of the command into comments at the top of the file. Getting tired of re-creating command lines I should have documented in the first place, when all I have is the output. | |
| 04:02 | mtj | RT @eythian++ #kohails #niceidea |
| 04:03 | eythian | mtj: my nickname is not a domain name ... ? |
| 04:04 | mtj | @ denotes a user, on twitter |
| 04:04 | huginn | mtj: I suck |
| 04:05 | mtj | so, i was sorta joking that it was a twitter retweet, with the 'rt' prefix and stuff |
| 04:06 | and the #hashtag thingies, and stuff | |
| 04:06 | eythian | but # indicates an IRC channel name... |
| 04:07 | mtj | ahh yep - i can see how that might have caused confusion for you |
| 04:08 | so, imagine that its a tweet… and that its sposed to be a joke :) | |
| 04:09 | eythian | but tweeting is a thing birds do ..? |
| 04:09 | mtj | ... then smile at teh lam3ness |
| 04:09 | rangi | eythian isn't good at jokes |
| 04:09 | :) | |
| 04:10 | eythian | no wahanui, eythian is great at jokes. That everyone else misses them isn't his problem. |
| 04:10 | wahanui | okay, eythian. |
| 04:11 | mtj | c'mon, its not *that* obscure… is it? |
| 04:24 | heres a random bugzilla idea… how about a 'needs a test plan' status? | |
| 04:26 | … like bug 9033, should i flick this back to 'in discussion'? | |
| 04:26 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9033 normal, P5 - low, ---, kyle, Needs Signoff , Wide character error in runreport.pl |
| 04:56 | Callender joined #koha | |
| 05:03 | Oak joined #koha | |
| 05:03 | * Oak | waves |
| 05:12 | trea left #koha | |
| 05:18 | wizzyrea1 joined #koha | |
| 05:19 | trea joined #koha | |
| 05:40 | TISLibrarian joined #koha | |
| 05:40 | TISLibrarian | hello everyone |
| 05:40 | plzzzzzzzzzzzzzzzzzzzzzzzzzzz help me, koha 3.4.0 is driven me crazy | |
| 05:46 | cait joined #koha | |
| 06:04 | rangi | 3.4.0 is really old, and we will need a lot more information and a lot less z before we could help |
| 06:05 | But now I'm going to eat | |
| 06:12 | francharb joined #koha | |
| 06:13 | francharb | good morning #koha |
| 06:28 | rangi | hi francharb |
| 06:40 | francharb | 0/ rangi |
| 07:10 | laurence joined #koha | |
| 07:21 | magnuse | kia ora #koha! |
| 07:25 | rangi | hi magnuse |
| 07:26 | magnuse | hiya rangi |
| 07:27 | i forget: should "Stage MARC records for import" be able to handle marcxml records, or just iso2709? | |
| 07:28 | rangi | im pretty sure jsut iso2709 |
| 07:28 | magnuse | ah, that would explain it :-/ |
| 07:41 | paul_p joined #koha | |
| 07:41 | magnuse | @arewethereyet |
| 07:41 | huginn | magnuse: Not yet - wait 9 days |
| 07:41 | magnuse | :-) |
| 07:42 | paul_p | good morning everybody |
| 07:42 | magnuse | kia ora paul_p! |
| 07:45 | alex_a | bonjour |
| 07:48 | julian_m joined #koha | |
| 07:59 | lds joined #koha | |
| 07:59 | reiveune joined #koha | |
| 08:00 | reiveune | hello |
| 08:00 | wahanui | hola, reiveune |
| 08:01 | lds | hello |
| 08:03 | sophie_m joined #koha | |
| 08:05 | trea joined #koha | |
| 08:07 | kf joined #koha | |
| 08:17 | matts | hi ! |
| 08:22 | kf | hi matts :) |
| 08:46 | magnuse | hm, "Stage MARC for import" seems to be confused by authority records... |
| 08:46 | kf | magnuse: oh? |
| 08:46 | rangi | are you supposed to be able to import authority records through it? |
| 08:46 | i always use bulkmarcimport -a | |
| 08:47 | magnuse | yeah, after the upload you can choose bibliographic or authority |
| 08:48 | but then it gets confused on the next screen | |
| 08:48 | rangi | that must have come in 3.8 ? or master? |
| 08:48 | kf | rangi: it's a new feature jared did |
| 08:48 | rangi | ah right |
| 08:49 | kf | I didn't test it, only know some screenshots |
| 08:49 | magnuse: maybe it's something with normarc? | |
| 08:49 | magnuse | http://div.libriotech.no/kohamisc/stage_auth.png |
| 08:50 | kf | aah |
| 08:50 | and the pull down is bibliographic frameworks? | |
| 08:50 | magnuse | kf: nope, i'm testing with a marc21 setup |
| 08:50 | kf: yes | |
| 08:50 | kf | maybe needs some refining |
| 08:50 | magnuse | looks like it |
| 08:50 | wahanui | somebody said looks like it was a replicate of /usr/share/koha/misc |
| 08:50 | kf | forget looks like it |
| 08:50 | wahanui | kf: I forgot looks like it |
| 08:50 | kf | @wunder Konstanz |
| 08:50 | huginn | kf: The current temperature in Taegerwilen, Taegerwilen, Germany is 6.0°C (9:50 AM CET on November 13, 2012). Conditions: Overcast. Humidity: 94%. Dew Point: 5.0°C. Windchill: 6.0°C. Pressure: 30.45 in 1031 hPa (Steady). |
| 08:50 | magnuse | @wunder boo |
| 08:50 | huginn | magnuse: The current temperature in Bodo, Norway is 2.0°C (9:20 AM CET on November 13, 2012). Conditions: Mostly Cloudy. Humidity: 70%. Dew Point: -3.0°C. Windchill: -2.0°C. Pressure: 29.95 in 1014 hPa (Steady). |
| 08:51 | kf | we had 2 days of grey with rain |
| 08:51 | today no rain... | |
| 08:53 | * magnuse | had a sprinkling of snow over night |
| 08:53 | kf | nice, I would like some white in the current color scheme |
| 08:54 | magnuse | :-) |
| 08:55 | i managed to import a file that jcamins provided as an example on another bug, so the problem might be purely cosmetic | |
| 08:55 | kf | magnuse: I would still file a bug - I think hiding the fields would make it less confusing |
| 08:55 | and should not be too hard to do | |
| 08:55 | and you already got a pretty screenshot :) | |
| 08:56 | magnuse | hehe |
| 08:56 | will do | |
| 08:57 | also, i tried downloading an authority in xml format from viaf, then converting it to iso2709 with yaz-marcdump, but i can't seem to be able to import that | |
| 08:58 | kf | hm any error? |
| 08:58 | magnuse | not that i have seen, but i'm still investigating |
| 09:17 | Ammarah joined #koha | |
| 09:31 | lds joined #koha | |
| 09:55 | lms1 joined #koha | |
| 10:21 | sophie_m left #koha | |
| 10:21 | sophie_m joined #koha | |
| 10:37 | Oak_ joined #koha | |
| 11:46 | libsysguy joined #koha | |
| 12:17 | libsysguy | blargh fines are a pain in the arse |
| 12:25 | jwagner joined #koha | |
| 12:47 | tcohen joined #koha | |
| 12:49 | libsysguy joined #koha | |
| 13:02 | kf | libsysguy: yep. |
| 13:03 | libsysguy | heh |
| 13:03 | kf have you seen any weirdness with fines in 3.8.5? | |
| 13:11 | kf | nope |
| 13:11 | we don't have that in production | |
| 13:11 | NateC joined #koha | |
| 13:19 | oleonard joined #koha | |
| 13:20 | ericar joined #koha | |
| 13:23 | oleonard | Hi #koha |
| 13:25 | tcohen | hi libsysguy, d u have a minute? |
| 13:25 | libsysguy | one sec tcohen |
| 13:35 | oleonard | mtj awake? |
| 13:35 | libsysguy | okay tcohen whats up |
| 13:37 | talljoy joined #koha | |
| 13:37 | edveal joined #koha | |
| 13:37 | tcohen | do u think the Calendar API should should use duration objects for addDate? |
| 13:38 | it bothers me that we create a duration on calcdatedue, to just extract the amount of days to iterate over it | |
| 13:38 | when used in addDate | |
| 13:39 | we actually convert it into a duration object if we detect it is not a duration object... | |
| 13:45 | khall | quick question, does koha have any scripts that will update the MARC blob from the database values? That is, we change something in the database, and run a script that updates marcxml with the new value from the db. |
| 13:45 | jcamins | magnuse: did you get the weird import display with NORMARC or MARC21? |
| 13:45 | khall: I'm pretty sure it does. If you give me a few minutes, I'll try and figure out what that script is. | |
| 13:47 | Hm. | |
| 13:47 | Maybe not. | |
| 13:49 | kf | jcamins: when I asked he said he was testing with marc21 :) |
| 13:49 | jcamins | Thanks. |
| 13:50 | I just imported authorities and the controls were hidden appropriately. | |
| 13:51 | So there must be two different ways to get there. | |
| 13:53 | Wait a minute. | |
| 13:56 | kf | jcamins: I only talked briefly to him in the morning - it's all in the logs |
| 13:56 | jcamins | Yep. |
| 13:57 | The "Wait a minute" was about bug 9066. | |
| 13:57 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9066 critical, P5 - low, ---, jcamins, NEW , VirtualShelves database access not Plack + MariaDB compatible |
| 14:01 | edveal left #koha | |
| 14:03 | drojf joined #koha | |
| 14:03 | drojf | hi #koha |
| 14:06 | kf | hi drojf |
| 14:07 | drojf | hi kf :) |
| 14:15 | edveal joined #koha | |
| 14:33 | magnuse | jcamins: it was a marc21 setup |
| 14:33 | jcamins: this one, in fact: http://marc21.testing.bibkat.no:8080/ login with demo / demo if you feel like testing | |
| 14:34 | jcamins | Thanks. |
| 14:34 | I'll take a look. | |
| 14:34 | magnuse | yay |
| 14:37 | A85 joined #koha | |
| 14:40 | paul_p | jcamins / chris_n = 4 more patches pushed to release-tools |
| 14:42 | jcamins | paul_p: cool! |
| 14:48 | wizzyrea joined #koha | |
| 14:49 | * magnuse | waves to wizzyrea |
| 14:49 | * oleonard | hopes wizzyrea isn't really awake |
| 14:49 | * magnuse | too, after taking a look at the clock |
| 14:51 | maximep joined #koha | |
| 14:56 | huginn | New commit(s) kohagit: Bug 7500 [Lists follow-up] Use CSS Sprites for faster page loading <http://git.koha-community.org/[…]b9e3e4cd1aeb9fece> / Merge branch 'bug_6428' into 3.12-master <http://git.koha-community.org/[…]2200ed6de337a7ed9> / Bug 6428 follow-up: Increment version number <http://git.koha-community.org/[…]p=koha.git;a=comm |
| 14:57 | * kf | waves too |
| 14:57 | * magnuse | waves to kf |
| 14:58 | kf | ok, someone here an idea about the best way to merge 2 records? each have an order attached to it and that is the complicated part I think |
| 14:58 | jenkins_koha | Starting build #942 for job Koha_master (previous build: SUCCESS) |
| 14:58 | kf | so I could move the item... but not sure it will update acq |
| 14:58 | and I could merge the records... but again not sure about acq | |
| 14:58 | or I could be evil and do it on database level.. I guess | |
| 14:58 | hm, better not. | |
| 14:59 | jcamins | I think if you move the item it will update acquisitions. |
| 14:59 | I'm not sure, though. | |
| 14:59 | Try it on your test server first? | |
| 15:03 | Okay, master is up-to-date. | |
| 15:06 | huginn | New commit(s) kohagit: Bug 8968 "Add to cart" translatable on OPAC result page <http://git.koha-community.org/[…]568f466e878923b67> |
| 15:06 | libsysguy joined #koha | |
| 15:13 | * chris_n | is pleasently surprised to find zebra reindexing screams on 8 cores as compared to 2 |
| 15:14 | chris_n | paul_p++ |
| 15:15 | libsysguy | guess that means we can set up that mega box on AWS for indexing |
| 15:16 | then just move the files over via fiber ;) | |
| 15:16 | chris_n | lol |
| 15:17 | I recently picked up a dell precision dual-quad core xeon for <$300 to use for dev projects | |
| 15:17 | pretty cheap horse-power | |
| 15:17 | libsysguy | that is cheap, what did you drop it in? |
| 15:18 | just an old server laying around? | |
| 15:18 | chris_n | actually its a complete precision 490 |
| 15:19 | currently has 4GB ram, but will handle 32 iirc | |
| 15:19 | now if I could just convince FF not to hog up all the memory.... | |
| 15:19 | * libsysguy | thinks you should up it to at least 16GB |
| 15:19 | chris_n | indeed |
| 15:19 | libsysguy | chrome ftw |
| 15:19 | * jcamins | likes the "dual-quad..." part of the description. |
| 15:19 | libsysguy | heh |
| 15:20 | I always thought that was an interesting description | |
| 15:20 | * chris_n | tends to run a zillion tabs which plays havoc with chrome as well |
| 15:20 | libsysguy | heh yeah thats the tradeoff |
| 15:20 | jcamins | I find I have to restart Chrome every few weeks. |
| 15:20 | libsysguy | bbiab carpet installers are here |
| 15:21 | jcamins | Carpet installers... |
| 15:21 | chris_n | red carpet? |
| 15:21 | * jcamins | sighs mightily at the reminder that he hates his carpet. |
| 15:21 | chris_n | ok, fixing updatedatabase.pl |
| 15:21 | tcohen | WTF does 'isexception' stand for? (holidays/calendar context) |
| 15:21 | jcamins | Uh-oh. Did something happen to it? |
| 15:21 | tcohen: libsysguy would be able to tell you, but he just left. | |
| 15:22 | chris_n | jcamins: our conversation yesterday :) |
| 15:22 | libsysguy | tcohen, real quick |
| 15:22 | chris_n | INSERT IGNORE |
| 15:22 | jcamins | Right. |
| 15:22 | libsysguy | isexception is in the db |
| 15:22 | its an exception to a holiday | |
| 15:22 | jcamins | We decided no INSERT IGNORE. |
| 15:22 | tcohen | yes, but what is it used for? |
| 15:22 | jcamins | Better to use add_syspref. |
| 15:22 | * chris_n | will look at it |
| 15:22 | tcohen | for setting exceptions to repeteable holidays? |
| 15:22 | chris_n | I seem to be recalling some discussion of this in the past |
| 15:22 | * chris_n | needs to upgrade to 16G himself |
| 15:23 | jcamins | chris_n: yeah, we did. |
| 15:24 | chris_n: I was thinking maybe we could make use of the installer utility functions in bug 7167. | |
| 15:24 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7167 enhancement, P1 - high, ---, jonathan.druart, Needs Signoff , updatedatabase improvements |
| 15:25 | libsysguy | tcohen yes |
| 15:26 | tcohen | so, is_holiday is kind of broken (or _init) |
| 15:26 | i'll dig a bit more | |
| 15:27 | libsysguy | what is it that you are trying to do |
| 15:27 | tcohen | is_holiday returns 0 where it shouldnt |
| 15:27 | libsysguy | and yes the way Calendar.pm _init works is kind of foobar |
| 15:27 | oh well yes that is a problem | |
| 15:28 | tcohen | i was doing some testing for bug 8800 |
| 15:28 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8800 blocker, P5 - low, ---, tomascohen, Failed QA , SpecifyDueDate && useDaysMode=Datedue wrong behaviour |
| 15:28 | tcohen | and found that setting a single day as holiday was broken |
| 15:28 | libsysguy | i think the calendar issue is almost comical at this point |
| 15:29 | kf | not sure the libraries would agree:( |
| 15:29 | libsysguy | I know they don't |
| 15:29 | :( | |
| 15:29 | tcohen | we'll figure it out |
| 15:29 | libsysguy | its like slap happy comical |
| 15:29 | tcohen | :-D |
| 15:30 | libsysguy | first we should kill the way that Calendar.pm runs the init function |
| 15:30 | it loads every holiday in the system into the object | |
| 15:30 | which in some cases could cause a crash | |
| 15:30 | for large date ranges | |
| 15:39 | jcamins | Oy. A whole lot has been pushed since I released 3.6.10. |
| 15:40 | magnuse | hm searching for autorities in "Home › Authorities" works fine but doing the same search in the tag editor for the 650 field (marc21) gives this error: Can't use string ("HASH(0xbc6c{30)") as a HASH ref while "strict refs" in use at /usr/share/koha/lib/C4/AuthoritiesMarc.pm line 363. |
| 15:40 | anyone else seen that? | |
| 15:41 | jcamins | I haven't. |
| 15:41 | magnuse | the typeahead in the tag edit suggests "common cold", but when i do a search for it i get the error |
| 15:41 | jcamins | I'll try, though. |
| 15:41 | francharb joined #koha | |
| 15:41 | jcamins | Yes. |
| 15:42 | I see it. | |
| 15:42 | If you report a bug, I'll fix it. | |
| 15:43 | magnuse | cool |
| 15:43 | will do | |
| 15:45 | jcamins: bug 9070 | |
| 15:45 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9070 normal, P5 - low, ---, gmcharlt, NEW , Searching for authority from tag editor for field 650 gives error |
| 15:45 | jcamins | Thanks. |
| 15:52 | magnuse | that's the least i could do :-) |
| 15:53 | jcamins | Okay, I see what the problem is. |
| 15:53 | Sort of. | |
| 15:53 | magnuse | w00t, sort of |
| 15:54 | jcamins | It turns out it's to do with GetAuthType not actually working anymore. |
| 15:55 | I don't see why, though. | |
| 15:59 | kf | about my earlier question: merging both records will take care of attached orders too :) |
| 16:05 | jcamins | magnuse: patch attached. |
| 16:06 | * magnuse | is impressed :-) |
| 16:06 | jenkins_koha | Project Koha_master build #942: SUCCESS in 1 hr 8 min: http://jenkins.koha-community.[…]/Koha_master/942/ |
| 16:06 | * nunyo: Bug 6428 [Follow-up] refered column 'items.coded_location_qualifier' does not exist | |
| 16:06 | * jcamins: Bug 6428 follow-up: Increment version number | |
| 16:06 | * oleonard: Bug 7500 [Lists follow-up] Use CSS Sprites for faster page loading | |
| 16:06 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6428 blocker, P2, ---, nunyo, Pushed to Master , refered column 'items.coded_location_qualifier' does not exist |
| 16:06 | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7500 minor, P5 - low, ---, oleonard, Pushed to Master , Use CSS Sprites for faster page loading | |
| 16:07 | magnuse | success! \o/ |
| 16:08 | jenkins_koha | Starting build #943 for job Koha_master (previous build: SUCCESS) |
| 16:19 | magnuse | jcamins: signed off |
| 16:19 | wahanui | well, signed off is the queue the QA team should watch |
| 16:19 | magnuse | it sure is :-) |
| 16:20 | JesseM joined #koha | |
| 16:21 | jcamins | magnuse: thanks! |
| 16:21 | magnuse | jcamins: my pleasure! |
| 16:26 | juan-sieira joined #koha | |
| 16:28 | kf left #koha | |
| 16:41 | reiveune | bye |
| 16:41 | reiveune left #koha | |
| 16:43 | sophie_m left #koha | |
| 16:43 | drojf joined #koha | |
| 16:51 | drojf left #koha | |
| 16:51 | drojf joined #koha | |
| 16:53 | * jcamins | throws drojf the duct tape. |
| 16:53 | drojf | :) |
| 16:54 | i hope that helps | |
| 16:59 | cait joined #koha | |
| 17:00 | melia joined #koha | |
| 17:03 | drojf | hola cait |
| 17:05 | cait | hola drojf |
| 17:05 | BigRig joined #koha | |
| 17:06 | drojf1 joined #koha | |
| 17:06 | drojf | meh |
| 17:06 | jcamins | Doesn't look like it did. |
| 17:13 | tcohen joined #koha | |
| 17:16 | jenkins_koha | Project Koha_master build #943: SUCCESS in 1 hr 8 min: http://jenkins.koha-community.[…]/Koha_master/943/ |
| 17:16 | f.demians: Bug 8968 "Add to cart" translatable on OPAC result page | |
| 17:16 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8968 enhancement, P5 - low, ---, frederic, Pushed to Master , JavaScript String not translatable |
| 17:27 | trea joined #koha | |
| 17:48 | senator joined #koha | |
| 18:06 | laurence left #koha | |
| 18:07 | francharb joined #koha | |
| 18:31 | talljoy1 joined #koha | |
| 18:31 | rangi | Morning |
| 18:31 | wahanui | Morning is a state of mind. or whenever the cat wants breakfast. |
| 18:31 | jcamins | Morning. |
| 18:31 | wahanui | somebody said morning was a state of mind. or whenever the cat wants breakfast. |
| 18:31 | cait | morning |
| 18:34 | francharb joined #koha | |
| 18:43 | * rangi | comments on a bug to try to prevent losing yet another feature |
| 18:45 | libsysguy joined #koha | |
| 18:49 | nengard joined #koha | |
| 19:01 | rangi | Right wellylibfast bbl |
| 19:08 | lms1 | Hello, when a search for some item my zebra log returns this error: |
| 19:08 | Search biblios ERROR 109 1 1+0 RPN @attrset Bib-1 @attr 1=1016 @attr 4=6 @attr 5=1 | |
| 19:08 | anyone know this error? | |
| 19:11 | jcamins | lms1: what is the rest of the message? |
| 19:12 | lms1 | 19:04:07-13/11 zebrasrv(10) [debug] rpn_search_APT |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [request] Search biblios ERROR 109 1 1+0 RPN @attrset Bib-1 @attr 1=1016 @attr 4=6 @attr 5=1 vida | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] result immediately available | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] ir_session (output) | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] Wrote PDU, 42 bytes | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] ir_session (input) | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [session] Connection closed by client | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] ir_session (input) | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] zebra_close zh=0xc3e070 | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] zebra_register_close p=0xc36ab0 | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] mf_close(dict) | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] isamb_close returned 0 values, skipped 0 | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] mf_close(isambA) | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] mf_close(isambB) | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] mf_close(isambC) | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] mf_close(isambD) | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] mf_close(reci) | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] mf_close(recdA) | |
| 19:12 | 19:04:07-13/11 zebrasrv(10) [debug] mf_close(recdB) | |
| 19:12 | jcamins | You can use paste.koha-community.org in the future. |
| 19:12 | * chris_n | wonders if zebra really does reverse-polish-notation or if that some sort of query language |
| 19:12 | lms1 | ok |
| 19:12 | jcamins | However, thanks, that's what I needed. |
| 19:13 | chris_n: RPN = Zebra's internal representation of PQF. | |
| 19:13 | lms1: did you reindex? | |
| 19:14 | Error 109 means "no such database." | |
| 19:14 | lms1 | I used this command: ./rebuild_zebra.pl -b -v |
| 19:14 | jcamins | You need to use -r |
| 19:14 | rebuild_zebra.pl -b -v -r | |
| 19:15 | lms1 | Exporting biblio returns 1 but REINDEXING zebra is empty |
| 19:16 | pastebot | "lms1" at 10.10.20.57 pasted "rebuild_zebra.pl" (28 lines) at http://paste.koha-community.org/270 |
| 19:16 | jcamins | That all looks correct to me. |
| 19:17 | You're using UNIMARC, right? | |
| 19:17 | lms1 | yes |
| 19:17 | I'm Portuguese, I have to use UNIMARC | |
| 19:17 | jcamins | Just wanted to check. |
| 19:19 | After rebuilding Zebra and trying the search again, do you still get error 109? | |
| 19:21 | lms1 | Yes, the same error |
| 19:21 | jcamins | What version of Koha is this? |
| 19:21 | lms1 | koha: 3.08.06.000 |
| 19:22 | fredy joined #koha | |
| 19:23 | jcamins | Error code 109 is definitely database unavailable. |
| 19:23 | Did you change something before it stopped working? | |
| 19:25 | And most importantly, how are you searching? | |
| 19:26 | lms1 | It's a new instalation |
| 19:26 | jcamins | On Fedora? |
| 19:26 | lms1 | I just insert one record, and when I search for this record I got this error |
| 19:26 | CentOS | |
| 19:26 | jcamins | I was close. |
| 19:26 | lms1 | yes :) |
| 19:26 | jcamins | How do you search for the record? |
| 19:27 | CentOS 6? | |
| 19:27 | lms1 | in the intranet, I use the Cataloging search bar |
| 19:27 | jcamins | Okay. |
| 19:27 | lms1 | yes, CentOS 6 |
| 19:28 | jcamins | Did you change the paths in all the Zebra configuration files? |
| 19:31 | lms1 | Well, it's a very good question... let me see |
| 19:31 | All my configuration files: /srv/koha/etc | |
| 19:32 | jcamins | The path to Zebra is hardcoded in all the config files too. |
| 19:32 | lms1 | and I have this directory: /srv/koha/etc/zebradb |
| 19:32 | jcamins | You'll need to look at the files in /srv/koha/etc/zebradb, and make sure that wherever they say Zebra is is, in fact, where Zebra is. |
| 19:33 | (it'll be something like /usr/share/zebra, I think) | |
| 19:34 | lms1 | Ok, thanks, I'm gonna check |
| 19:38 | Manderson joined #koha | |
| 19:40 | Manderson | Hi all |
| 19:41 | jcamins | Manderson: we're just troubleshooting a Zebra problem on CentOS. Do you recall which Zebra configuration files you had to edit? |
| 19:41 | Manderson | On Redhat, rebuild_zebra.pl couldn't find zebraidx as a cron job - /usr/local/bin isn't in the default PATH |
| 19:42 | I edited rebuild_zebra.pl to give a full path and it works like a charm | |
| 19:42 | jcamins: the configuration files were untouched for zebra on my end. | |
| 19:43 | Just used what the koha installer put together. | |
| 19:43 | jcamins | Ohhh, you installed Zebra in the standard location, didn't you? |
| 19:43 | Manderson | Yes |
| 19:43 | No | |
| 19:43 | jcamins | (hence the need to change rebuild_zebra) |
| 19:43 | Manderson | sorry, Koha in the standard location |
| 19:43 | I compiled Yaz and Zebra and installed them to /data0/koha/support/ | |
| 19:44 | jcamins | Oh. |
| 19:44 | Hm. | |
| 19:44 | Manderson | the symlinked everything to /usr/local/bin and /usr/local/lib respectively |
| 19:44 | jcamins | The plot thickens! |
| 19:44 | lms1 | The configuration files are correct in my case |
| 19:45 | Manderson | What's CentOS doing/not doing? |
| 19:45 | jcamins | Manderson: indexing isn't happening. |
| 19:45 | lms1: run rebuild_zebra.pl -b -r -v -v -v | |
| 19:45 | (notice the three -v arguments) | |
| 19:45 | lms1 | ok |
| 19:45 | Manderson | Even when rebuild_zebra.pl is run from teh command line (not cron) |
| 19:47 | pastebot | "lms1" at 10.10.20.57 pasted "./rebuild_zebra.pl -b -r -v -v -v" (21 lines) at http://paste.koha-community.org/271 |
| 19:47 | jcamins | Ummm... |
| 19:47 | Manderson | It sounds like the same problem I had |
| 19:47 | rebuild_zebra.pl can't find zebraidx | |
| 19:48 | jcamins | Yeah, I think so. |
| 19:48 | lms1: try editing the rebuild_zebra script to have the full path to zebraidx. | |
| 19:48 | Manderson | Perhaps, if zebraidx is installed at /usr/local/bin, run it as so: |
| 19:49 | PATH=${PATH}:/usr/local/bin; ./rebuild_zebra.pl -b -r -v -v -v | |
| 19:49 | chobbs joined #koha | |
| 19:49 | lms1 | Ok, thanks, I'm gonna try |
| 19:51 | chobbs | Hi all. I restarted my koha server today, and am now getting "Bad arg length for Socket::pack_sockaddr_in" for, it seems, any page that involves patrons. Straight cataloging and searching doesn't seem to be affected. any ideas? |
| 19:51 | running ubuntu packaged koha on up-to-date 12.04, if that helps. | |
| 19:52 | jcamins | chobbs: ouch. I have no idea what that could be. |
| 19:52 | I have two thoughts. | |
| 19:52 | lms1 | Problem solve |
| 19:52 | :) | |
| 19:52 | jcamins | 1) a sessions problem. |
| 19:52 | If that's the issue, truncate the sessions table. | |
| 19:53 | Manderson | lms1: Hooray! |
| 19:53 | jcamins | 2) you have half your data coming off the IPv6 interface, the other half coming off IPv4? |
| 19:53 | If that's the issue, I have no clue what to do. | |
| 19:53 | lms1 | Thanks to all |
| 19:54 | chobbs | well, it wasn't sessions (too bad, that was the easy one) :) |
| 19:54 | Manderson | chobbs: what changed on your system? |
| 19:55 | kathryn joined #koha | |
| 19:55 | chobbs | Manderson: shouldn't have been any changes. we shut down for a planned power outage in our data canter. fired it back up this morning. |
| 19:57 | Manderson | Upgrades? Other perl development happening on the system? |
| 19:58 | chobbs | I did an upgrade after the problem appeared, just to make sure it wasn't anything out of date. The system is a fresh build that I brought up 4 weeks ago, using a copy of our database from an older version. It's been working brilliantly since we stood it up. |
| 19:59 | jcamins | chobbs: DNS. |
| 20:00 | chobbs: I'm not sure exactly what the problem is, but Google suggests that it's probably DNS-related. | |
| 20:00 | chobbs | jcamins: checking now, looks like I had the temp name still in /etc/hosts - rebooting now to see if it goes away |
| 20:01 | BigRig_ joined #koha | |
| 20:03 | chobbs | ugh, no joy. I'll do some more snooping aorund name resolution |
| 20:03 | bshum_ joined #koha | |
| 20:03 | Jurgens joined #koha | |
| 20:06 | rebazkoya joined #koha | |
| 20:06 | Jurgens | hi. I moved from the tarball 3.8 to packages 3.8. Worked fantastic. However, i had a LAN network, followed the packages installation to recreate a LAN but now seem only able to access the OPAC through firefox on the other PC but not the staff client. Can anyone point me in the right direction please. |
| 20:07 | Manderson | jcamins: for chobbs' issue, calls to Socket::pack_sockaddr_in require two parameters, $port and $ip_address. Could it be that it's binding to the wrong IP address (127.0.0.1) and cannot open that port on that IP address? Might not be running with the required privilieges to get IP address information. |
| 20:07 | jcamins | Jurgens: you'll need to set up DNS. |
| 20:07 | Manderson: possibly. I'm not really a networking expert. | |
| 20:10 | Jurgens: if you want to use different ports, you just have to tell Apache to listen on the other port. | |
| 20:11 | Jurgens | so during installation i did set up the DNS stuff through edit /etc/koha/koha-sites.conf |
| 20:11 | rebazkoya | hi , I want to place hold a book in koha but i have a trouble that it say " Too Many Holds: User has too many holds. No copies are available to be placed on hold ... please how to solve ? |
| 20:11 | jcamins | Jurgens: in that case you'll need to set it up so that both DNS entries resolve to the same server. |
| 20:12 | Jurgens | and I have ports set to listen to both 80 and 8080 |
| 20:12 | oleonard | rebazkoya: have you set up a default circulation rule for all patrons and all branches? |
| 20:13 | rebazkoya | where can I do it , please? |
| 20:13 | oleonard | Koha administration -> Circulation and fine rules |
| 20:13 | jcamins | Jurgens: you might need to edit /etc/apache2/sites-enabled/[libraryname] |
| 20:13 | oleonard | manual? |
| 20:13 | wahanui | somebody said manual was at http://www.koha-community.org/documentation |
| 20:13 | oleonard | rebazkoya: Follow that link to the manual if you need to |
| 20:14 | Jurgens | i found that if i use the address library.apqgi.org on the koha machine, it works fine for OPAC and library-intra.apqgi.co.nz is fine for Staff Client on koha machine. |
| 20:14 | jcamins | Jurgens: still sounds like DNS to me. |
| 20:15 | Jurgens | these addresses do no work on the other pc. I've got a local IP set up 10.1.1.4. however i see that it uses the domain name of koha:80 for staff client, this is fine on the other pc, but koha:8080 doesnt give me staff client.. so am a little confused I thought it should just use library-intra.apqgi.org for staff and library.apqgi.org for opac. |
| 20:16 | jcamins | Jurgens: of course not. You can't mix and match DNS and ports differently on different computers. |
| 20:16 | Jurgens | so why is it effectivley using 10.1.1.4:80 for opac on the other machine? |
| 20:16 | jcamins | Jurgens: because you have it configured to use DNS. |
| 20:16 | *host names | |
| 20:16 | Since you are using host names and not ports, you must configure your local DNS to resolve library.apqgi.org and library-intra.apqgi.org to your Koha server. | |
| 20:17 | Jurgens | how do i do that? |
| 20:17 | jcamins | If you want to just use ports, you can edit /etc/apache2/sites-enabled/library and change the port the staff client is listening on to 8080 |
| 20:17 | Talk to your network administrator. | |
| 20:17 | That's how I do it. | |
| 20:18 | If you say exactly what I said "you must configure your local DNS..." s/he should be able to take care of it for you. | |
| 20:53 | trea joined #koha | |
| 20:53 | cait left #koha | |
| 20:56 | Jurgens | so i just reinstalled koha from packages and what i did differently was during the DNS configuration the wiki page used port 80 for both intraport and opac port. now i changed this to 8080 and 80 respectivley. I did try and change this post installation, but did not seem to take effect even with restart. But setting this right during installation seemed fine. |
| 20:57 | now off to watch the rest of the eclipse :) | |
| 20:57 | jcamins | Jurgens: in order to change it post-installation you must edit the file in /etc/apache2/sites-enabled/library |
| 20:57 | Jurgens | i did try that too... |
| 20:58 | jcamins | Well, as long as it works. |
| 20:58 | :) | |
| 21:00 | Jurgens | I really expected the sites-enabled/library to work.. i suspect the reason could be that I mistakenly did not save.. i am just guessing here.. regardless thanks for the help jcamins. hi 5 |
| 21:15 | oleonard | Later #koha |
| 21:18 | chobbs | Manderson: When you said "Could it be that it's binding to the wrong IP address", which 'it' did you mean? What is potentially binding to the loopback? |
| 21:29 | jcamins: any idea where pack_sockaddr_in is getting called in Koha's code? It didn't turn up in a grep, so I assume it's actually being called by another function from the Socket module that Koha is actually using. | |
| 21:29 | jcamins | chobbs: not a clue. |
| 21:29 | chobbs | bummer :0 |
| 21:29 | :) | |
| 21:30 | jcamins | Koha doesn't use Socket directly either, most likely. |
| 21:30 | chobbs | nested dependencies/libraries are so much fun :) |
| 21:30 | jcamins | pack_sockaddr_in is used to translate IP addresses for use by stdc. |
| 21:31 | Almost certainly if you are having problems with it you have a much bigger problem than Koha. | |
| 21:31 | chobbs | strange that other parts of Koha are working just fine. |
| 21:33 | mib_zom5b5 joined #koha | |
| 21:34 | jcamins | Very. |
| 21:34 | mib_zom5b5 | Hi, just a quick question with the koha packages install - i am used to the tarbal.. will overdues be run automatically. I checked under cron.d cron.daily etc. it seems its set to run automatically. is this correct? |
| 21:34 | jcamins | Yes. |
| 21:35 | I believe you have to enable e-mail with koha-enable-email instance | |
| 21:35 | mib_zom5b5 | Thanks. |
| 21:35 | I have never used koha email - could never get it to work with nullmailer .. but will look into it now. | |
| 21:35 | jcamins | Oh, if you aren't using e-mail then you don't need to do that. |
| 21:36 | I recommend postfix. | |
| 21:36 | (but I don't support it) | |
| 21:36 | mib_zom5b5 | I do wish to use email actually.. so postfix you say. |
| 21:39 | chobbs | Bizarre. This problem seems isolated to anything involving patrons look-ups. Cataloging, SQL reports, everything else works just fine. But if I try to find a patron, or pull one up for circulation, it fails. |
| 21:39 | jcamins | That is weird. |
| 21:40 | chobbs | I would assume parton lookups would e just dealing with mysql and apache; zebra doesn't even come into the mix here, right? |
| 21:40 | jcamins | That is correct. |
| 21:42 | chobbs | hello, memcached :/ |
| 21:42 | just shut down memcached and my search works. | |
| 21:44 | Started it back up and it still works. I love technology... | |
| 21:44 | jcamins | chobbs: you must've had an IP address cached. |
| 21:45 | latex-- | |
| 21:45 | texlive-- | |
| 21:46 | chobbs | bizarre. It's working now, and I'm keeping an eye on memcached now? it's magic, as far as I'm concerened. black magic. |
| 21:48 | ericar joined #koha | |
| 21:48 | francharb | see ya all |
| 21:49 | rangi | http://f.dollyfish.net.nz/6fda33 |
| 21:49 | this just happened | |
| 21:49 | 15 mins ago | |
| 21:49 | jcamins | Cool! |
| 21:49 | * jcamins | hurls imprecations at LaTeX. |
| 21:55 | jcamins | It's a good thing I don't have a sword. |
| 21:55 | If I had a sword, I would've stabbed my laptop by now. | |
| 21:56 | magnuse | woo, cool eclipse! |
| 21:57 | nengard left #koha | |
| 21:57 | * magnuse | knows a library that lends swords |
| 22:03 | jcamins | Freaking LaTeX. That is the only package I know which is centered around language which doesn't support UTF-8 or fonts in any usable way. |
| 22:06 | mib_zom5b5 | Hi, can anyone help me set up postfix for koha? I've not succesfully done email capabilities before. |
| 22:06 | jcamins | postfix? |
| 22:06 | wahanui | postfix is, like, found at https://help.ubuntu.com/community/Postfix (but you probably can skip the SASL stuff) or at http://www.postfix.org/documentation.html |
| 22:07 | Manderson | chobbs: Is your machine multihimed? |
| 22:07 | *multi-homed* | |
| 22:07 | * jcamins | curses |
| 22:08 | jcamins | mib_zom5b5: in case you didn't realize, those links were for you. |
| 22:08 | Pretty easy to set up. | |
| 22:09 | There's no Koha-specific configuration. | |
| 22:12 | jenkins_koha | Starting build #227 for job Koha_3.8.x (previous build: SUCCESS) |
| 22:19 | stefan-l left #koha | |
| 22:22 | mib_zom5b5 joined #koha | |
| 22:26 | jcamins | pdflatex-- |
| 22:27 | xelatex-- | |
| 22:27 | @query enhanced | |
| 22:27 | huginn | jcamins: 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=4800 enhancement, P5 - low, ---, chris, NEW , Disable book cover image in the title view if the feature is on in the OPAC. |
| 22:27 | jcamins: 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=4171 enhancement, P5 - low, ---, cnighswonger, NEW , overduerules.pl needs an overhaul | |
| 22:27 | jcamins: 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=4960 normal, P5 - low, ---, henridamien, NEW , No way to enter custom purchase order number | |
| 22:27 | jcamins: 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5539 enhancement, P5 - low, ---, henridamien, NEW , Options for Suggestion Emails | |
| 22:27 | jcamins: 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7602 normal, P5 - low, ---, katrin.fischer, NEW , Spent and Ordered pages require full acquisition permissions | |
| 22:29 | rambutan joined #koha | |
| 22:33 | chobbs | Manderson: Negative. localhost and eth0 is all. |
| 22:35 | jcamins | chobbs: if it's working now it was just memcached and there's no point in trying to troubleshoot it. |
| 22:35 | * chobbs | wishes X-Chat Aqua put timestamps on chats... |
| 22:36 | chobbs | jcamins: Yeah, I agree. I'll have it in my mind the next time I reboot the box, if it goes wonky again. |
| 22:36 | * jcamins | wishes that LaTeX weren't a disaster. |
| 22:43 | Irma joined #koha | |
| 22:43 | Manderson | chobbes - is there any output in your koha-error_log or koha-opac-error_log files relating to the issue? |
| 22:44 | aside from what you mentioned before? | |
| 22:44 | chobbs | Manderson: Nope, there wasn't anything useful in any of hte logs. The error logs mirrored what was reported in the browser. |
| 22:46 | Manderson | Any use of SIP services? |
| 22:51 | jenkins_koha | Project Koha_3.8.x build #227: SUCCESS in 39 min: http://jenkins.koha-community.[…]b/Koha_3.8.x/227/ |
| 22:51 | f.demians: Bug 8968 "Add to cart" translatable on OPAC result page | |
| 22:51 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8968 enhancement, P5 - low, ---, frederic, Pushed to Master , JavaScript String not translatable |
| 23:08 | jcamins | latex-- |
| 23:09 | @karma latex | |
| 23:09 | huginn | jcamins: Karma for "latex" has been increased 0 times and decreased 2 times for a total karma of -2. |
| 23:09 | jcamins | @karma C4::Search |
| 23:09 | huginn | jcamins: Karma for "C4::Search" has been increased 0 times and decreased 31 times for a total karma of -31. |
| 23:09 | jcamins | Hm. |
| 23:16 | openoffice++ | |
| 23:16 | gaetan_B joined #koha | |
| 23:16 | maximep | pfffff |
| 23:16 | libreoffice++ | |
| 23:17 | druthb | libreoffice++ |
| 23:19 | jcamins | Actually, I'm using libreoffice. |
| 23:19 | Good point. | |
| 23:19 | libreoffice++ | |
| 23:20 | I actually don't know if OpenOffice would even meet my needs. | |
| 23:23 | maximep left #koha | |
| 23:24 | rambutan left #koha | |
| 23:25 | edveal left #koha | |
| 23:33 | mtj | hi folks, a random Q… has anyone experimented with using databases running fom SSD cards? |
| 23:36 | … are they any good? much faster that disks? or not really worth the effort/cost? | |
| 23:38 | trea | not sure. i would guess your write endurance on flash wouldn't tolerate any long term db fitness |
| 23:39 | mtj | at this stage, i just want a cheap/small one for koha testing |
| 23:39 | trea | well in that case |
| 23:40 | mtj | to speed up the tedium of database loads when testing, etc…. |
| 23:41 | but yeah, ive heard they dont last too long | |
| 23:46 | and ive heard there are some SSDs to avoid completely | |
| 23:49 | jcamins | mtj: my understanding is that it's generally a bad idea because it writes so much data to disk. |
| 23:50 | mtj: if you want faster performance, add more RAM, and use an in-memory file system. | |
| 23:50 | mtj | running DBs on SSDs is a bad thing, coz they are too write-heavy? |
| 23:51 | jcamins | mtj: depending on your application, obviously. |
| 23:52 | mtj: know what I'd do, if you're running ephemeral tests? | |
| 23:53 | Initialize MySQL with the users and databases that you want (but not the data). | |
| 23:53 | Stop MySQL. | |
| 23:54 | Rename /var/lib/mysql to /var/lib/mysql.perm | |
| 23:54 | Mount a tmpfs on /var/lib/mysql. | |
| 23:54 | Copy the files from /var/lib/mysql.perm onto said tmpfs. | |
| 23:54 | Start up MySQL. | |
| 23:54 | Bonus points for an init script that takes care of that copying whenever your system starts up. | |
| 23:55 | mtj | hmm, that would work fine |
| 23:55 | jcamins | Oh, and tune your MySQL cache way down. |
| 23:55 | mtj | yeah, its a better solution for me that an ssd card |
← Previous day | Today | Next day → | Search | Index