← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
Time | Nick | Message |
---|---|---|
00:10 | jenkins_koha | Project Koha_master build #259: SUCCESS in 41 mn: http://jenkins.koha-community.[…]/Koha_master/259/ |
00:10 | Liz Rea: Bug 6258 - Guided reports wizard 'Build new' brings up empty page | |
00:10 | huginn` | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6258 major, PATCH-Sent, ---, wizzyrea, ASSIGNED , Guided reports wizard 'Build new' brings up empty page |
00:12 | glernil joined #koha | |
00:16 | pianohacker left #koha | |
00:21 | JesseM left #koha | |
00:39 | glernil | good day! |
00:40 | Soupermanito | :) good |
00:40 | glernil | i would like to upgrade my installation of koha 3.2 to 3.4. Do i have to upgrade first 3.2 to 3.2.9 or could i upgrade it to 3.4 directly? |
00:47 | eythian | glernil: you're on the debian packages, right? |
00:47 | glernil | yup! |
00:48 | eythian | which means you're probably running 3.2.9 already |
00:48 | there's is no "official" 3.4 packages, but there are some for people to test available | |
00:49 | to get to them, you change "squeeze" in your sources.list to "squeeze-dev" | |
00:49 | glernil | so it means that i shouldnt upgrade my installation for the mean time and wait for the official release? |
00:50 | eythian | it's up to you. I'd like more people to be testing it for me :) |
00:59 | skushner left #koha | |
01:21 | Ahmuck left #koha | |
01:35 | glernil | eythian: when i rebuild the index using "/usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r" an error occurs saying "BEGIN failed--compilation aborted at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r line 6" |
01:35 | eythian | don't do that |
01:35 | :) | |
01:35 | is that the exact command you're using? | |
01:36 | glernil | yup |
01:36 | eythian | and is that all of the error message? |
01:36 | oh, the error message is correct because that's not how you're supposed to run it | |
01:36 | glernil | i have to rebuild my index because there's no record being shown in my search... exactly the same command |
01:37 | eythian | sudo koha-rebuild-zebra --full <name of library> |
01:37 | glernil | so how should I run that? |
01:37 | got to try | |
01:37 | eythian | (where <name of library> is the name of the koha instance |
01:37 | although, before that, try: sudo /etc/init.d/koha-common restart | |
01:39 | glernil | when i try to restart using the last command you gave and error occured failed to stop the collegelib-koha-zebra daemon: no such process |
01:39 | is it just ok | |
01:39 | ? | |
01:40 | eythian | try it one more time, if it says nothing, then it's OK |
01:40 | but that very much looks like that it would be the cause of your search not working problem | |
01:44 | glernil | eythian: it worked! |
01:44 | eythian | coolness |
01:44 | glernil | do i have to do that everytime i update or add records and items? |
01:45 | eythian | no, the daemon is running all the time (normally), and every 5 minutes a cron job runs to reindex the things that have been changed/added. |
01:45 | It's the daemon that responds to search requests though, so it needs to be running. | |
01:45 | glernil | i see |
01:45 | eythian | I wonder if something's happened in 3.4 that stops it starting on installation... |
01:45 | glernil | so it is already running right? |
01:45 | eythian | oh, I know what it is |
01:46 | it doesn't get started when you create a library maybe... | |
01:46 | I should check that | |
01:46 | yep, if search is working, then it's running | |
01:48 | glernil | got it! and the default settings in crontab example is included? |
01:50 | eythian | yes, it should have been installed into /etc/cron.d/koha-common |
01:52 | glernil | one more thing.. is there any docu/ wiki where the complete list of commands in the koha-common debian package can be seen? |
02:01 | wizzyrea | rangi++ for finding git bz |
02:03 | eythian | hey, I found git-bz, he just fixed it :) |
02:03 | glernil: not really. There's a bit of a list on the wiki page, but it doesn't cover all of them | |
02:03 | you can always do ls /usr/sbin/koha-* to see all of them :) | |
02:06 | I need to convince Nicole that she wants to write man pages for all of them one of these days :) | |
02:08 | rangi | hehe |
02:11 | glernil | that's great.. looking forward on that... I'm impressed on the easiness of the debian installation process using koha-common package |
02:12 | eythian | :) |
02:12 | glernil: oh, did you end up bringing it up to 3.4? | |
02:13 | glernil | eythian: not yet... i'll test first 3.2... working on notice sending |
02:13 | eythian | sure thing. I'd be interested to know if you find any issues related to the packaging or OS integration if you do upgrade. |
02:16 | Irma left #koha | |
02:16 | Brooke joined #koha | |
02:16 | wizzyrea | hi irma, brooke :) |
02:16 | Brooke | 0/ |
02:17 | Irma joined #koha | |
02:20 | Space_Librarian | afternoon Irma |
02:28 | Ahmuck joined #koha | |
02:28 | Brooke | 0/ |
02:29 | rangi | hey Brooke and Irma |
02:29 | hi Ahmuck | |
02:29 | Brooke | :) |
02:29 | Ahmuck | hi Brooke |
02:29 | er, hi rangi | |
02:33 | Space_Librarian | hey Brooke |
02:36 | Brooke | howdy |
02:36 | wahanui | hi, Brooke |
03:14 | wizzyrea is now known as wizzyrea_away | |
03:15 | pauln joined #koha | |
03:16 | Brooke | 0/ |
03:16 | rangi | heya pauln |
03:19 | Soupermanito | :) it took me like 4 hours but now i have a virtualmachine in which im installing koha :D |
03:20 | pauln | g'day |
03:21 | still got no word back form conf committee about their suggestions for how they are thinking demo session would work | |
03:21 | rangi | ahh, thats less than optimal :) |
03:26 | pauln | in the meantime i had a brainwave that we could instead be an exhibitor ;) |
03:26 | that way we've got 3 days to do plenty of demos to different groups | |
03:27 | rangi | ahh yeah catalyst has a booth |
03:27 | we can use some of it for Koha librarians to use to demo :) | |
03:27 | http://www.conference.co.nz/lianza11/exhibition <-- we are 29 | |
03:28 | so actually running rolling demos there would work just fine :) | |
03:28 | glernil left #koha | |
03:28 | pauln | right on |
03:30 | ill work on the abstract over the weekend anyway and let you have a look Monday | |
03:30 | rangi | awesome |
03:31 | pauln | bit late on it i know, but we will give the committee very possible chance to feedback! |
03:31 | rangi | :) |
03:34 | pauln | easy enough to sort out a demo schedule at the time depending on who is there you reckon? |
03:35 | and that acquisitions thing is still at the bottom | |
03:35 | rangi | dangit |
03:36 | pauln: yeah i reckon easy enough to do that | |
03:37 | huginn` | New commit(s) kohagit: Bug 6340: Pagination bar on guided reports result page broken <http://git.koha-community.org/[…]8ac168b0c6b08d5db> |
03:40 | Ahmuck left #koha | |
03:43 | jenkins_koha | Starting build 260 for job Koha_master (previous build: SUCCESS) |
03:50 | pauln left #koha | |
03:50 | Soupermanito | question, i am installing koha on ubuntu, and im being asked something about "nullmailer" what should i answer to it? |
03:51 | something about "system mail" i think | |
03:51 | eythian | I hate how it always tries to install that on Ubuntu |
03:51 | I'd say just don't do anything, and when it's done, replace it with postfix, which is a much better thing to use | |
03:51 | Soupermanito | so i say 'cancel' then? |
03:51 | eythian | I don't know what it's asking |
03:52 | Soupermanito | want a screenshot? |
03:52 | eythian | but perhaps |
03:52 | No | |
03:52 | you could just tell me | |
03:52 | either way, it probably won't hurt whatever you do, if the next thing is to remove it | |
03:52 | Soupermanito | okay |
03:52 | :) | |
03:53 | i just cancelled it | |
04:12 | after runing misc/sax_parser_print.pl I get: http://paste.ubuntu.com/613053 | |
04:13 | oh nevermind | |
04:13 | i had to keep reading | |
04:19 | cait joined #koha | |
04:19 | Space_Librarian | hey cait |
04:20 | cait | hi Space_Librarian :) |
04:23 | Brooke | 0/ |
04:25 | cait | hi Brooke - go to bed |
04:25 | Brooke | nu :P |
04:25 | cait | or go to work for me... so I can sleep longer :P |
04:26 | pauln joined #koha | |
04:26 | jenkins_koha | Project Koha_master build #260: SUCCESS in 42 mn: http://jenkins.koha-community.[…]/Koha_master/260/ |
04:26 | Katrin Fischer: Bug 6340: Pagination bar on guided reports result page broken | |
04:26 | * Brooke | will work for food. |
04:26 | huginn` | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6340 major, PATCH-Sent, ---, katrin.fischer, ASSIGNED , Pagination bar on guided reports result page broken |
04:28 | Soupermanito left #koha | |
04:29 | cait | I think we have still some ice cream in the fridge at work.. |
04:34 | pauln left #koha | |
04:55 | cait | rangi: around? |
04:55 | Space_Librarian | he may be roaming on his phone... |
04:57 | * Brooke | sings a few bars of home on the range. |
04:57 | cait | ah |
04:57 | only a git bz question | |
04:57 | trying it out... will see if bug explodes :) | |
04:57 | * Space_Librarian | sings where the kiwi and kakapo play... |
04:58 | Space_Librarian | cait: sounds like fun! |
04:58 | cait | hm didn't work |
04:59 | eythian | rangi is at beer |
04:59 | ibeardslee | beer? |
04:59 | wahanui | beer is proof that god loves us and wants us to be happy. |
04:59 | Space_Librarian | preach it bot! |
04:59 | eythian | ibeardslee: you have an alert for that word, huh? |
04:59 | * cait | is very tempted to write a forget command |
04:59 | ibeardslee | I just happened to glance in the screen .. honest |
05:00 | eythian | cait: it would never last |
05:00 | cait | well... for my day it would |
05:00 | Space_Librarian | ibeardslee: why don't I believe you? |
05:00 | Brooke | ibeardslee? |
05:01 | ibeardslee | Space_Librarian: you are a doubting thomas .. doubting shelley |
05:01 | Space_Librarian | Nah, just cynical. |
05:01 | ibeardslee | Brooke? |
05:01 | wahanui | Brooke is, like, deprecated |
05:01 | Brooke | hehe |
05:02 | ibeardslee | oh things happen when you do that |
05:02 | cait | aha |
05:03 | * eythian | proceeds to beer |
05:03 | Brooke | drink one to twelve for me, mate. |
05:03 | cait | already beer o clock ? |
05:03 | Space_Librarian | that's tomorrow |
05:04 | Brooke | not if I'm having a rough night tonight :P |
05:04 | Space_Librarian | true |
05:04 | * Brooke | laments that Hendricks' and nummahs do not mix well. |
05:05 | cait | ah, confusing times again |
05:11 | Space_Librarian left #koha | |
05:19 | glernil joined #koha | |
05:19 | Brooke | 0/ |
05:30 | cait | hm |
05:30 | has someone tested printing barcodes recently? | |
05:30 | * Brooke | shudders. |
05:39 | Brooke | http://tinyurl.com/3nyf97s |
05:39 | rawr | |
05:50 | Ropuch | Morning #koha |
05:52 | cait | hi Ropuch |
05:53 | :) | |
05:54 | Ropuch | Hi cait :) |
05:59 | Brooke | morning |
06:00 | cait | git-bz++ |
06:00 | @karma git-bz | |
06:00 | huginn` | cait: Karma for "git-bz" has been increased 2 times and decreased 0 times for a total karma of 2. |
06:09 | cait | @wunder Konstanz |
06:09 | huginn` | cait: The current temperature in Konstanz, Germany is 14.0�C (8:00 AM CEST on May 26, 2011). Conditions: Partly Cloudy. Humidity: 79%. Dew Point: 12.0�C. Pressure: 30.03 in 1017 hPa (Falling). |
06:10 | Ropuch | @wunder Wrocław |
06:10 | huginn` | Ropuch: The current temperature in Wroclaw, Poland is 13.0�C (8:00 AM CEST on May 26, 2011). Conditions: Clear. Humidity: 67%. Dew Point: 7.0�C. Pressure: 30.18 in 1022 hPa (Falling). |
06:11 | cait | I win ;) |
06:12 | Ropuch | hehe |
06:29 | Brooke | bid! |
06:30 | Brooke left #koha | |
06:34 | alex_a | hi #koha |
06:35 | @wunder marseille | |
06:35 | huginn` | alex_a: The current temperature in Marseille, France is 23.0�C (8:30 AM CEST on May 26, 2011). Conditions: Clear. Humidity: 57%. Dew Point: 14.0�C. Pressure: 30.04 in 1017 hPa (Steady). |
06:35 | alex_a | cait: *I* win |
06:35 | :p | |
06:35 | cait | oh, the game was already over... |
06:35 | :P | |
06:36 | @wunder Konstanz | |
06:36 | huginn` | cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 15.9�C (8:35 AM CEST on May 26, 2011). Conditions: Clear. Humidity: 79%. Dew Point: 12.0�C. Pressure: 29.99 in 1015.5 hPa (Steady). |
06:36 | cait | ok, you win |
06:36 | alex_a | ;) |
06:38 | francharb joined #koha | |
06:39 | francharb | hello #koha |
06:40 | cait | hi francharb :) |
06:41 | cait left #koha | |
06:45 | julian joined #koha | |
06:46 | marcelr joined #koha | |
06:47 | pianohacker joined #koha | |
06:52 | clrh joined #koha | |
06:53 | hdl joined #koha | |
06:56 | matts_away is now known as matts | |
07:02 | miguelxercode left #koha | |
07:05 | kf joined #koha | |
07:05 | kf | good morning #koha |
07:08 | sophie_m joined #koha | |
07:09 | Ropuch | Hello kf [; |
07:11 | miguelxercode joined #koha | |
07:14 | kf | hi again Ropuch :) |
07:20 | magnus_away is now known as magnuse | |
07:30 | magnuse | kia ora #koha |
07:34 | kf1 joined #koha | |
07:36 | miguelxercode left #koha | |
07:36 | kf left #koha | |
07:36 | marcelr left #koha | |
07:36 | jenkins_koha left #koha | |
07:36 | eythian left #koha | |
07:36 | jenkins_koha joined #koha | |
07:36 | eythian joined #koha | |
07:41 | miguelxercode joined #koha | |
07:42 | huginn` | New commit(s) needsignoff: [Bug 6410] Returns use wrong borrower number var name <http://bugs.koha-community.org[…]w_bug.cgi?id=6410> |
07:48 | marcelr joined #koha | |
07:50 | jransom joined #koha | |
07:50 | jransom | Got permission tonight to come to KohaCon11 - yay :) |
07:56 | pianohacker | beeeeed |
07:56 | pianohacker left #koha | |
07:57 | magnuse | cool - difinitely ;-) |
07:57 | jransom | I know - so excited. |
07:58 | magnuse | hey - i have been promoting koha here: http://www.flickr.com/photos/e[…]11/in/photostream for three days now, proudly wearing my Horowhenua pin ;-) |
08:00 | jransom | oh wow |
08:00 | that screenis amazing - is that northern lights? | |
08:03 | magnuse | yup |
08:04 | i could have taken them down to put up my big koha logo, but i thought it was better to let them hang | |
08:04 | jransom | maybe kohacon in norway sometime ... |
08:04 | magnuse | difinitely! ;-) |
08:04 | but give us 3-4 years to get some actual libraries using koha... ;-) | |
08:05 | and be prepared for an expensive trip... | |
08:05 | jransom | and us time to save up! |
08:05 | magnuse | i'd love to show y'all the midnight sun! |
08:05 | jransom | i would love to see it... your photos are truly wonderful |
08:06 | * magnuse | blushes |
08:06 | magnuse | northern norway IS wonderful |
08:07 | jransom | OK - well I am off to cuddle the bambini for a while |
08:08 | nice 'chatting' | |
08:08 | magnuse | have a nice cuddle! |
08:08 | jransom | :) |
08:08 | jransom left #koha | |
08:08 | slef | sure, I'd do a kohacon presentation on Makefile.PL, maybe a double-header with hdl on the web installer? Now, who wants to pay for me to go to India? ;-) |
08:09 | morning all | |
08:09 | hdl | hi |
08:09 | wahanui | hey, hdl |
08:13 | kf1 | ah now I missed jo |
08:13 | hi magnuse and hdl, slef :) | |
08:14 | reiveune1 joined #koha | |
08:14 | slef | kf1: is that a bad attempt at concealing your nickname? |
08:14 | reiveune1 | hello |
08:14 | slef | I don't think adding a 1 will confuse many people. |
08:14 | reiveune1: salut | |
08:14 | wahanui | what's up, slef |
08:15 | slef | wahanui: who asked you? |
08:15 | wahanui | bugger all, i dunno, slef |
08:15 | sunil joined #koha | |
08:18 | sunil | hi |
08:18 | wahanui | privet, sunil |
08:19 | sunil | i have one problem in koha |
08:20 | hi chis | |
08:21 | hi rangi | |
08:21 | anyone ther | |
08:22 | hdl | hi sunil |
08:23 | hi all | |
08:26 | magnuse is now known as magnus_away | |
08:29 | sunil left #koha | |
08:41 | magnus_away is now known as magnuse | |
08:54 | glernil left #koha | |
08:55 | Irma left #koha | |
09:03 | chris_n` joined #koha | |
09:03 | chris_n is now known as Guest2287 | |
09:03 | chris_n` is now known as chris_n | |
09:08 | Guest2287 left #koha | |
09:13 | kf1 | slef: sorry, we had a staff meeting |
09:13 | kf1 is now known as kf | |
09:13 | kf | now it shoudl be better :) |
09:18 | magnuse is now known as magnus_away | |
09:59 | kf is now known as kf_lunch | |
10:02 | clrh left #koha | |
10:03 | clrh joined #koha | |
10:18 | druthb joined #koha | |
10:18 | druthb | o/ |
10:20 | matts is now known as matts_away | |
10:45 | matts_away left #koha | |
10:47 | matts_away joined #koha | |
10:54 | kf_lunch is now known as kf | |
10:55 | bigbrovar joined #koha | |
10:56 | bigbrovar | Hi guys |
11:01 | has anyone upgraded from koha 3.2 to 3.4 is it recommended? | |
11:07 | kf | i would go to 3.4.1 |
11:07 | if you want to update | |
11:08 | and test it on a demo database first | |
11:09 | or wait a little longer for 3.4.2 | |
11:09 | there are still some smaller issues with TT that will be solved in that release | |
11:10 | druthb | bigbrovar: we've got a number of sites testing out 3.4.1; seems to be mostly okay--few little things here and there, mostly templating issues. |
11:11 | ...and the upgrade is not hard. Run updatedatabase.pl, and you need to run the script in misc/maintenance to remove the item records from marc/marcxml, and reindex. | |
11:12 | bigbrovar | kf: ok, I will wait then, our koha instance even though not online yet is almost complete in terms of functionality . just waiting for management to approve, I was pulled off my work on koha for our library (which is mostly done as a personal project and non paid work) to other school IT needs, came back and BOOM there is a 3.4 release. lol |
11:14 | druthb: would give it a go, reading the releae note for 3.4, its massive! like I wanna give it a go on a test machine asap, and it I can get it to the point I have 3.2 I would just do a clean install and start from scratch. | |
11:15 | druthb | There are a *lot* of patches in a 3.2-3.4 upgrade, too true. But we've run it clean a number of times here, no major worries. |
11:16 | bigbrovar | Ok then, I will give it a go, if things gets jammed up, I always have u guys anyways ;p |
11:17 | druthb | yup. :D |
11:29 | jwagner joined #koha | |
11:36 | conan joined #koha | |
11:37 | conan | hello everysoul |
11:37 | kf: thanks for your explanation about 6328 | |
11:37 | danmc | once installed, will koha read most of its configuration from a single file or small set of files, or do I really need to set all the options like WEBMASTER_EMAIL, WEBSERVER_DOMAIN, etc at build time? |
11:38 | kf | conan: you are welcome |
11:38 | hope it was understandable :) | |
11:38 | druthb left #koha | |
11:41 | conan | kf: yes, pretty clear. I didn't understand why someone would use 'XXX', so my first tought was that someone screwed |
11:41 | maybe I haven't read all the necesary documentation in the wiki | |
11:42 | kf | I think there was a text somewhere about db updates |
11:42 | let me find it | |
11:42 | there is someinformation here: http://wiki.koha-community.org[…]ystem_Preferences | |
11:43 | and here: http://wiki.koha-community.org[…]ng_Database_Files | |
11:47 | conan | how do you find in git from what version have you branched? |
11:48 | kf | hm |
11:48 | I am not sure | |
11:48 | conan | I know which version was, but I wonder how would I do if I forget or if I find somebody else's branch |
11:48 | kf | you could check git log for the commitid |
11:48 | conan | hum... that hash doesn't tell me much |
11:49 | let me explain with an example | |
11:49 | I do 'git checkout -b mybranch v3.04.00' | |
11:49 | then I only get 'mybranch' for all clue | |
11:50 | how do I ask git from wich tag/branch did that came? | |
11:50 | magnus_away is now known as magnuse | |
11:51 | conan | google is my friend: git show-branch |
11:52 | kf | :) |
11:52 | see, now I learned something new too :) | |
11:53 | kf is now known as kf_mgt | |
11:53 | NateC joined #koha | |
11:54 | clrh left #koha | |
11:55 | julian left #koha | |
11:57 | julian joined #koha | |
11:58 | clrh joined #koha | |
12:00 | JesseM joined #koha | |
12:04 | matts_away is now known as matts | |
12:15 | oleonard joined #koha | |
12:22 | magnuse is now known as magnus_away | |
12:24 | matts is now known as matts_away | |
12:32 | conan | kf_mgt: one more thing, if I apply 6328 updating versions appropriately on a production system, then I will have to fix kohaversion.pl on every update? |
12:33 | cause I'll probably choose the next number following '3.04.01.000', but then a change from master will have that number, but for another set of changes | |
12:33 | what's the proper way of handling this? | |
12:34 | oleonard | conan: You could to the db update manually instead of applying the update to kohaversion.pl |
12:35 | matts_away is now known as matts | |
12:37 | jwagner is now known as Guest2308 | |
12:37 | jwagner joined #koha | |
12:39 | matts is now known as matts_away | |
12:42 | Guest2308 left #koha | |
12:44 | matts_away is now known as matts | |
12:52 | wizzyrea_away is now known as wizzyrea | |
12:56 | matts is now known as matts_away | |
13:02 | matts_away is now known as matts | |
13:20 | bigbrovar_ joined #koha | |
13:21 | sekjal joined #koha | |
13:24 | bigbrovar left #koha | |
13:33 | marcelr left #koha | |
13:35 | schuster joined #koha | |
13:36 | matts left #koha | |
13:37 | conan | kf_mgt: you around? |
13:42 | the debarrement one sets in tools>Overdue notice/status triggers is applied by a cronjob? | |
13:43 | sekjal | conan: correct |
13:43 | misc/cronjobs/overdue_notices.pl | |
13:48 | Ahmuck joined #koha | |
14:07 | kf_mgt is now known as kf | |
14:07 | kf | conan: now :) |
14:07 | hi sekjal | |
14:08 | sekjal | hi, kf! |
14:08 | kf | :) |
14:11 | wizzyrea | sekjal: re 5579 for things like that "further enhancement" would it be better to have a separate bug (for my info -- I just followed what was on the bug on that one |
14:12 | sekjal | wizzyrea: I think so. once the bug the initial patch is committed and working |
14:13 | wizzyrea | k that's what I thought |
14:13 | * wizzyrea | idly wonders if git bz can create bugs too |
14:15 | oleonard | wizzyrea: I assume you can use it to attach patches to bugs? |
14:15 | wizzyrea | yes, oleonard -- it's GLORIOUS. |
14:15 | :) | |
14:15 | instructions are coming right now to the wiki near you | |
14:15 | oleonard | Excellent. |
14:16 | wizzyrea | just waiting for my dropbox to sync :) |
14:16 | oleonard | I got through the setup and tried using to apply a patch from a bug, and that was glorious |
14:17 | wizzyrea | there's one catch about attaching patches to bugs |
14:17 | you have to get a firefox cookie with your login creds on your dev box | |
14:17 | (that's how git bz knows it's you | |
14:17 | ) | |
14:17 | oleonard | That's different from getting patches from bugs? |
14:18 | wizzyrea | I don't think you have to authenticate to get things |
14:18 | (I could be wrong) | |
14:18 | oleonard | I've already had git-bz tell me to log in |
14:18 | wizzyrea | aha, well then there you go |
14:18 | you should be cool | |
14:18 | to attach | |
14:18 | kf | wizzyrea: yes it can |
14:18 | oleonard | And it works with Chrome too! |
14:18 | kf | wizzyrea: create bugs, git bz file |
14:19 | wizzyrea | kf++ nice! |
14:19 | kf | have not tried it, but the command is there |
14:19 | I tried attachting patch to bug and mark the other obsolete - that worked! | |
14:19 | wizzyrea | me too! |
14:19 | kf | look at my sign-offs from today :) |
14:19 | wizzyrea | I was ecstatic. |
14:19 | kf | hehe |
14:19 | me too | |
14:19 | wizzyrea++ | |
14:19 | thx for helpign me figure it out yesterday | |
14:20 | wizzyrea | oleonard: for example, git bz attach 6397 HEAD |
14:20 | will attach the last commit to bug 6397 | |
14:20 | huginn` | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6397 minor, P5, ---, ruth, ASSIGNED , Mis-named variable in .TT causes table cell shift |
14:20 | kf | and if you do -e |
14:20 | oleonard | So you don't even have to have generated a patch? |
14:20 | kf | you can edit the comment and mark things obsolete .) |
14:20 | nope | |
14:21 | wizzyrea | doing it this way basically eliminates the need for the patches email list |
14:22 | it's <insert your favorite exclamatory swear word here> brilliant | |
14:22 | matts_away joined #koha | |
14:23 | oleonard | I'm going to go with... frelling. |
14:23 | wizzyrea | :D |
14:23 | kf - git bz -e attach xxxx or git bz attach xxxx -e | |
14:24 | where does the -e go? | |
14:25 | matts_away is now known as matts | |
14:25 | sekjal | hmmm, going to have to figure out how to get a cookie on my GUI-less (and browserless) server... |
14:26 | wizzyrea | sekjal: sometimes you can do it with a remote x server |
14:26 | (that's how I did it) | |
14:26 | afaik it doesn't work with lynx cookies :( | |
14:28 | sekjal | hmmm |
14:28 | if I'm going to make use of this, I'll either need to install some new software on my dev box, or start doing my testing on my home machine | |
14:29 | wizzyrea | i think that if I can work it out on my headless, browserless server then you can :) |
14:33 | sekjal | wizzyrea: I'll give it a go |
14:33 | matts_ joined #koha | |
14:33 | sekjal | git-bz looks like too good a tool to miss out on |
14:33 | wizzyrea | it really really is |
14:37 | matts left #koha | |
14:41 | matts_away joined #koha | |
14:41 | matts_away is now known as matts | |
14:47 | matts_ left #koha | |
14:50 | matts_ joined #koha | |
14:51 | Soup joined #koha | |
14:52 | conan | kf: sorry, I was filling my report to bug 6328 |
14:52 | huginn` | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6328 major, PATCH-Sent, ---, paul.poulain, ASSIGNED , Fine in days does not work |
14:53 | conan | kf: I've found a couple of things that smell bad for me. Sorry, I know it has 3 sign-off and such, but maybe we're not pursuing the same behaviour |
14:54 | kf: can you read and comment about? | |
14:54 | fredericd: are you frederic demians? | |
14:55 | maybe you would want to check 6328 too | |
14:55 | matts- joined #koha | |
14:55 | matts left #koha | |
15:01 | matts_ left #koha | |
15:02 | kf | conan: i did a few follow ups - possible we missed something |
15:03 | bigbrovar_ | hi guys, am in the process of upgrading our koha instance from 3.2 to 3.4.1, installed the missing deps and following the upgrade guide however when I went to the webinstaller to continue with the installation I got this error http://paste.ubuntu.com/613290 what gives? |
15:04 | wizzyrea | http://wiki.koha-community.org[…]_bz_configuration |
15:06 | kf | conan: sounds like serious testing to me :) |
15:06 | conan++ | |
15:07 | conan: we don't use the fine days here in Germany, my testing concentrated mostly on the existing features now in Koha and that the new development does not break things (manually debarring from patron record, debar flag set by overdue notices) | |
15:08 | conan | kf: major problem, I think, is you cannot circulate new items to a patron if you manually un-debar him/er |
15:08 | there is no way, except updating manually in DB | |
15:10 | wizzyrea | git-bz is at http://wiki.koha-community.org[…]_bz_configuration |
15:10 | git-bz? | |
15:10 | wahanui | i heard git-bz was at http://wiki.koha-community.org[…]_bz_configuration |
15:10 | wizzyrea | yayee |
15:10 | oleonard | wizzyrea++ |
15:11 | bigbrovar_: Those errors can probably be ignored | |
15:12 | bigbrovar_: It looks to me like it's just overlap in the database upgrades | |
15:12 | kf | conan: I hope Paul will comment |
15:12 | bigbrovar_ | oleonard: thanks it seems to worked fine anyways , hope it wont come bite me later on (In life :p ) |
15:13 | * bigbrovar_ | time to have a cup of tea |
15:15 | conan | kf: my partner here is giving me new stuff to concerns about with this implementation, now we're designing a whole new table, this is getting too big |
15:19 | reiveune1 | à demain |
15:19 | reiveune1 left #koha | |
15:19 | kf | conan: hm yes, perhaps adding a date to patron is not the right way to do it - not sure |
15:19 | conan: switching it back to boolean and have a different interface for fines in days could be better | |
15:21 | Brooke joined #koha | |
15:21 | Brooke | kia ora |
15:21 | julian left #koha | |
15:25 | Brooke | slef! |
15:25 | this cannot stand! | |
15:25 | how, oh how, did they fall to Juve? | |
15:25 | Odio Juve! | |
15:26 | rhcl | I am so glad for google translate, I'd be lost on chat without it |
15:27 | kf | google can speak Brookish? :) |
15:27 | * Brooke | highfives kf. |
15:28 | rhcl | partly. It can translate the words, but not make sense out of them. Like it doesn't know who Juve is. |
15:28 | or what? | |
15:29 | Brooke | http://www.antijuve.com/ |
15:29 | rhcl | of course |
15:30 | a French language site | |
15:30 | * Brooke | rolls on the floor laughing |
15:31 | Brooke | how's homie g. laws doin' this fine morning? |
15:32 | rhcl | Ah, well, uh, OK. Thank you for asking. |
15:34 | Ahmuck left #koha | |
15:42 | slef | hrm? |
15:43 | matts- is now known as matts_away | |
15:43 | slef | Juventus 2 - 2 Napoli? |
15:45 | kf left #koha | |
15:46 | Brooke | http://www.hotsportchannel.com/ |
15:47 | JesseM is now known as JesseM_Lunch | |
15:47 | Brooke | clearly shoddy Yank management. |
15:50 | rhcl | Scottish yanks? |
15:50 | http://www.goal.com/en-gb/news[…]not-a-young-boss- | |
15:52 | rhcl left #koha | |
15:54 | Brooke left #koha | |
16:00 | rhcl joined #koha | |
16:04 | bigbrovar_ left #koha | |
16:16 | cait joined #koha | |
16:19 | Soup | so i finally installed koha, and i get this at 127.0.1.1:8080 > http://paste.ubuntu.com/613333 |
16:21 | moodaepo | Soup: Seems to me that the MySQL account info is incorrect so the db connection is not happening, I'd check the config entries. |
16:22 | Soup | okay |
16:22 | sophie_m left #koha | |
16:23 | * Soup | goes to figure out what are and how to check config entries on mysql |
16:24 | wizzyrea | standard or dev install? |
16:24 | druthb joined #koha | |
16:25 | moodaepo | Soup: ^^ |
16:25 | Soup | standard ubuntu install following the wiki steps |
16:25 | wizzyrea | k :) |
16:25 | Soup | http://wiki.koha-community.org[…]ki/Koha_on_Ubuntu |
16:26 | everything seems to work till that last step | |
16:27 | nhusd joined #koha | |
16:28 | magnus_away is now known as magnuse | |
16:28 | wizzyrea | it's definitely a mismatch between what sql thinks your password is and what's in the config |
16:29 | you did the "GRANT ALL ON kohadata.* TO 'root'@'localhost' IDENTIFIED BY 'password';" bit | |
16:29 | ? | |
16:29 | and it matches what you put in as your database password when you ran the makefile? | |
16:29 | Soup | oh... the make file |
16:30 | i think i changed the password on it | |
16:30 | wizzyrea | aha |
16:30 | they have to match :) | |
16:30 | do note, you can log into mysql again | |
16:30 | and make the password match there | |
16:30 | rather than mucking with the koha configs | |
16:30 | Soup | oh thats better |
16:30 | wizzyrea | so where that GRANT says 'password' you'd put in your password |
16:31 | that you put in the makefile | |
16:32 | the password goes inside the single quotes | |
16:32 | if that's not clear | |
16:32 | Soup | the problem is that 1) i think i've changed the mysql password to the one im using, and 2) the backlogs doesnt let me go as back as to see what i sayd the make builder to be |
16:32 | wizzyrea | oops |
16:33 | in that case | |
16:33 | Soup | uninstall and try again :D |
16:33 | wizzyrea | nope |
16:33 | :) | |
16:33 | not necessry | |
16:33 | try nano /etc/koha/koha-conf.xml | |
16:33 | one second, gonna find you the exact line you need to change | |
16:34 | or look at to find what you typed in | |
16:34 | Soup | okay :) |
16:35 | hdl | wizzyrea: ? Or any user using accounts for users oleonard ? |
16:35 | wizzyrea | hdl: i'm missing context |
16:35 | ka-admin left #koha | |
16:35 | * oleonard | is here, doesn't understand the question |
16:35 | mtj left #koha | |
16:36 | hdl | ok. |
16:36 | Sorry. | |
16:36 | There are some hardcoded codes for fees for Patrons | |
16:36 | Soup | wizzyrea, :( the password is the one i said it to be, to be clare, im learning so im using weak easy to remember stuff so i gave it 1234 as the password, and its there |
16:37 | hdl | But the documentation for those codes is... kind of missing. |
16:37 | wizzyrea | right, now you need to set that in mysql too |
16:37 | Soup | it is... |
16:37 | wizzyrea | so ctrl-x out of nano |
16:37 | can't be, sorry, not according to your error | |
16:37 | you are looking at <pass>?? | |
16:37 | Soup | ok |
16:38 | wizzyrea | in the koha-conf.xml? |
16:38 | Soup | yes; <pass>1234</pass> |
16:38 | wizzyrea | ok great |
16:38 | hdl | Even the way they happen is quite cryptic... So I was wondering... If you ever happened to know what to display or know that... in a user way and usage. |
16:39 | In fact, we would like to document that. | |
16:39 | wizzyrea | so now, soup |
16:39 | Soup | :) |
16:39 | hdl | And we have patches for bug fixing... But we want to know what some codes are there for. |
16:39 | Soup | yes |
16:39 | wizzyrea | you'll want to do mysql -uroot -p |
16:40 | enter your mysql password | |
16:40 | Soup | done |
16:40 | wizzyrea | and do another grant |
16:40 | > GRANT ALL ON kohadata.* TO 'root'@'localhost' IDENTIFIED BY '1234'; | |
16:41 | then FLUSH PRIVILEGES; | |
16:41 | and exit | |
16:41 | now try it again | |
16:42 | druthb | wizzyrea++ |
16:42 | oleonard | hdl: I don't run across any hard-coded patron fees in my Koha use |
16:42 | hdl | oleonard: does that make sense ? |
16:43 | in account_types in the accounts table ? | |
16:44 | oleonard | Oh, you mean the fee categories found in accountlines? |
16:44 | hdl | yes. |
16:45 | oleonard | I have no real knowledge of what those are or where they come from. Sorry hdl. |
16:46 | Soup | wizzyrea, :( no luck |
16:46 | hdl | seriously needs documenting... I know catalyst worked on a refactoring... Hope they thought about documentation :D |
16:46 | wizzyrea | same error? |
16:46 | Soup | same error yes |
16:46 | hdl | (I am sure they did ) |
16:47 | bg | hdl documentation++ :) |
16:47 | Soup | i tried rebooting the vbox to see if it changed things but nope |
16:48 | JesseM_Lunch is now known as JesseM | |
16:48 | hdl | bg: often... it is not that something doesnot work... It doesnotwork.... the way you would like it to ! And if we have some document, it is much easier to share views. |
16:48 | bg | :) |
16:49 | wizzyrea | soup: what is the User right above pass in your koha-conf.xml |
16:50 | do note, if you're looking at anything that says <password> it's not the right area | |
16:50 | (those are for zebra | |
16:50 | ) | |
16:50 | cait | hdl: I think robin send a mail to the list with the pod for the new module |
16:50 | so there is documentation already :) | |
16:51 | Soup | http://paste.ubuntu.com/613351 |
16:51 | wizzyrea | aha |
16:51 | see in the above grant statement | |
16:52 | it says user root? | |
16:52 | you need to grant privileges for user koha ;) | |
16:52 | with password 1234 | |
16:52 | do you need me to paste exact steps? | |
16:52 | Soup | if you can yes :) |
16:53 | sorry if im being a bother | |
16:53 | wizzyrea | nope, not at all |
16:53 | so log into mysql -uroot -p | |
16:53 | Soup | :) thank you very much |
16:53 | wizzyrea | GRANT ALL ON kohadata.* TO 'koha'@'localhost' IDENTIFIED BY '1234'; |
16:53 | FLUSH PRIVILEGES; | |
16:53 | exit | |
16:54 | basically that means "let user koha do anything to my koha db when they log in with password 1234" | |
16:54 | Soup | :D |
16:54 | ok that makes sense | |
16:55 | so now i restart mysql? | |
16:55 | wizzyrea | you shouldn't need to |
16:55 | does it work? | |
16:55 | Soup | :( |
16:55 | no | |
16:55 | wizzyrea | what's the path to your config file? |
16:56 | Soup | /etc/koha/koha-conf.xml |
16:56 | wizzyrea | and that's the one with user koha and pass 1234 in it? |
16:56 | Soup | yes |
16:56 | wizzyrea | oh |
16:56 | I know | |
16:56 | GRANT ALL ON koha.* TO 'root'@'localhost' IDENTIFIED BY '1234'; | |
16:56 | try that one | |
16:56 | your db is called koha, not kohadata | |
16:57 | so, see where in the config file it says <database> | |
16:57 | koha </database> | |
16:57 | that's the bit right after ON | |
16:57 | Soup | same |
16:58 | wizzyrea | lol arg, GRANT ALL ON koha.* TO 'koha'@'localhost' IDENTIFIED BY '1234'; |
16:58 | Soup | tried that too |
16:58 | XD | |
16:58 | wizzyrea | basiclaly, the database, user, and pass need to be consistent with your config file |
16:58 | did you flush privileges after? | |
16:58 | Soup | yes |
16:58 | Oak joined #koha | |
16:59 | wizzyrea | and it's still giving that error? |
16:59 | Soup | yes |
16:59 | ok food time | |
16:59 | Oak | \o |
16:59 | Soup | o/ |
16:59 | thanks wizzyrea for your troubles and time | |
16:59 | wizzyrea | hmm I shall think on this |
16:59 | * oleonard | will brb |
16:59 | oleonard left #koha | |
17:01 | magnuse is now known as magnus_away | |
17:01 | Oak | hello Soup :) |
17:01 | Hello wizzyrea :] | |
17:02 | * wizzyrea | waves at oak |
17:02 | wizzyrea | o/ |
17:02 | cait | hi Oak :) |
17:02 | Oak | oh Hi cait ! :) |
17:03 | hi druthb | |
17:05 | druthb | hi, oak. :) |
17:05 | Oak | how are you today druthb ? cool as usual... |
17:06 | druthb | I am awesome all the way through, Oak! :D |
17:07 | Oak | hmm :) |
17:11 | oleonard joined #koha | |
17:12 | oleonard | That was weird, it was looking like I wasn't going to get back in. |
17:12 | * oleonard | looks around to see who would've locked the door |
17:13 | * cait | would never lock owen out |
17:13 | Oak | you were supposed to pull it not push it... |
17:14 | oleonard | :P |
17:14 | http://www.ma.utexas.edu/howto[…]lForTheGifted.jpg | |
17:14 | cait | hehe |
17:15 | * druthb | hides the keys. |
17:15 | Oak | :D |
17:15 | larryb joined #koha | |
17:25 | Soup | wizzyrea, look this: http://paste.ubuntu.com/613375 |
17:25 | wizzyrea | ooo |
17:26 | Soup | thats relevant correct? |
17:26 | wizzyrea | well yes |
17:26 | but a different problem | |
17:26 | bigbrovar joined #koha | |
17:28 | Soup | http://paste.ubuntu.com/613378 is my /etc/apache2/ports.conf |
17:29 | oh well i should not be doing this now, i actually have to end a paper on encyclopedias | |
17:29 | wizzyrea | the macro problem is that apache doesn't think you have a virtual host defined for 8080 |
17:29 | Soup | i see |
17:29 | wizzyrea | how it got that way, if you followed the directions, I have no idea |
17:30 | Soup | i did exactly what says there |
17:30 | library_systems_guy | so I have a random question...when a user logs in through LDAP in koha, how is their password stored in the db? |
17:31 | bg | it's hashed |
17:32 | library_systems_guy | by mysql? |
17:32 | or perl? | |
17:32 | wahanui | perl is probably an abomination upon us all |
17:32 | bg | perl |
17:32 | f3ew | Perl++ |
17:32 | wizzyrea | did you edit /etc/koha/koha-httpd.conf as noted? |
17:32 | * library_systems_guy | grumbles |
17:32 | wizzyrea | forget perl |
17:32 | wahanui | wizzyrea: I forgot perl |
17:32 | bg | md64 or something like that |
17:33 | druthb is now known as druthb_away | |
17:33 | wizzyrea | sorry to be slow i'm 1h typing w my 3 yo on my lap |
17:34 | sekjal | md5_base64, to be precise |
17:34 | bg | thanks sekjal++ |
17:34 | library_systems_guy | I was considering doing a single sign-n setup for our library since we use ezproxy for off campus access...how feasible do you think that is |
17:36 | hdl | library_systems_guy: it is hashed md5_base64 |
17:37 | library_systems_guy | thanks bg, sekjal, and hdl |
17:37 | sekjal | library_systems_guy: Koha does CAS now... other SSO options would need to be developed (but would be welcome) |
17:37 | hdl | we implemented CAS |
17:37 | sekjal | I'd be interested in looking at Shibboleth |
17:37 | hdl | sekjal: we could have to do that by the end of the year. |
17:37 | cait | sekjal: Shibboleth would be interesting here too I think |
17:37 | library_systems_guy | i have basically not experience with sso so im just kinda poking around |
17:39 | hdl | Altough I think that we would certainly rather use Plack::Middleware::Auth::Basic |
17:39 | and rework the authentication | |
17:40 | Would necessarily use Plack then though. | |
17:41 | See you | |
17:46 | sekjal | can MARC::Record tell me with one subfield immediately follows another? |
17:49 | hdl left #koha | |
17:51 | druthb_away is now known as druthb | |
17:52 | JesseM left #koha | |
17:58 | conan | laterz |
17:58 | conan left #koha | |
18:11 | skushner joined #koha | |
18:13 | jwagner | hi, skushner |
18:13 | sekjal | MARC. Must. Die! |
18:14 | bg | heh - MARC must DIE :) |
18:14 | * library_systems_guy | thinks that is an excellent idea |
18:14 | wizzyrea | @quote add <sekjal> MARC. Must. Die! |
18:14 | huginn` | wizzyrea: The operation succeeded. Quote #136 added. |
18:14 | sekjal | for (horrific) example: the field definitions for 853 |
18:15 | wizzyrea | @marc 853 |
18:15 | huginn` | wizzyrea: [Described in full under field 853 in the MARC 21 Concise Format for Holdings Data.] (Repeatable) [] |
18:15 | bg | heh concise :) |
18:15 | skushner | hi jane, hello all |
18:15 | sekjal | subfields u and v are repeatable, and depending which field they're after (b-f usually), they mean different things |
18:15 | bg | heya skushner |
18:16 | sekjal | howdy, skushner. just in time for my rant against MFHD |
18:19 | francharb left #koha | |
18:19 | sekjal | I think I may just ignore the whole 853a-f, u-v mess, and work off subfield w |
18:24 | cait | what are you trying to do? |
18:28 | sekjal | trying to migrate over the prediction patterns with the serials issues |
18:29 | the data's in there... it's just MARC | |
18:32 | bg | @wunder chicago, IL |
18:32 | huginn` | bg: The current temperature in Chicago, Illinois is 5.3�C (1:35 PM CDT on May 26, 2011). Conditions: Drizzle. Humidity: 93%. Dew Point: 4.0�C. Windchill: 5.0�C. Pressure: 29.22 in 989.4 hPa (Steady). |
18:32 | bg | @wunder 93109 |
18:32 | huginn` | bg: The current temperature in K6LCM - Westside / Mesa, Santa Barbara, California is 19.5�C (11:36 AM PDT on May 26, 2011). Conditions: Clear. Humidity: 65%. Dew Point: 13.0�C. Pressure: 30.00 in 1015.8 hPa (Steady). Wind Advisory in effect from 7 PM this evening to 8 am PDT Friday... |
18:33 | oleonard | bg: Who's in Chicago? |
18:33 | bg | I was seeing if the mets game was going to be delayed :) |
18:33 | oleonard | It's going to be chilly anyway! |
18:33 | bg | yeah that's cold |
18:34 | @wunder wellington, nz | |
18:34 | huginn` | bg: The current temperature in Wellington, New Zealand is 15.0�C (6:00 AM NZST on May 27, 2011). Conditions: Mostly Cloudy. Humidity: 77%. Dew Point: 11.0�C. Pressure: 29.39 in 995 hPa (Steady). |
18:35 | oleonard | @wunder 45701 |
18:35 | huginn` | oleonard: The current temperature in Ohio University, Athens, Ohio is 23.3�C (2:30 PM EDT on May 26, 2011). Conditions: Clear. Humidity: 53%. Dew Point: 13.0�C. Pressure: 29.65 in 1003.9 hPa (Rising). |
18:35 | aogle joined #koha | |
18:35 | druthb | @wunder Potomac_Swamps, MD... |
18:35 | huginn` | druthb: Error: No such location could be found. |
18:35 | druthb | pity. |
18:35 | @wunder 20852 | |
18:35 | huginn` | druthb: The current temperature in Potomac Woods, Rockville, Maryland is 31.3�C (2:39 PM EDT on May 26, 2011). Conditions: Clear. Humidity: 50%. Dew Point: 20.0�C. Pressure: 29.85 in 1010.7 hPa (Steady). |
18:35 | cait | @quote add sekjal: the data's in there... it's just MARC |
18:35 | huginn` | cait: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command). |
18:36 | cait | @quote add sekjal: the data's in there... it's just MARC |
18:36 | huginn` | cait: The operation succeeded. Quote #137 added. |
18:46 | Oak | time to sleep ... night dear ones |
18:46 | Oak left #koha | |
18:49 | sekjal | gmcharlt: about? |
18:49 | gmcharlt | sekjal: pong |
18:50 | sekjal | I need to go through each subfield in a MARC field, in order. best way to do that? $field->subfields(), then a foreach? |
18:50 | gmcharlt | yes |
18:51 | sekjal | and since subfields() returns a list of lists, I assume there are references I'll need to deal with in there... |
18:54 | jwagner is now known as jwagner_away | |
18:55 | sekjal | gmcharlt: okay, think I got it... |
19:02 | rhcl | @wunder 33040 |
19:02 | huginn` | rhcl: Error: timed out |
19:04 | rhcl | @wunder 33040 |
19:04 | huginn` | rhcl: The current temperature in Key West NAF, Florida is 31.0�C (2:53 PM EDT on May 26, 2011). Conditions: Scattered Clouds. Humidity: 61%. Dew Point: 23.0�C. Pressure: 29.96 in 1014 hPa (Falling). |
19:14 | bigbrovar | time to call it night, good $time-zone-appropriate greetings to you guys |
19:19 | wizzyrea | hmm how would i go about getting a report of bibs that have only one item |
19:20 | bigbrovar left #koha | |
19:20 | wizzyrea | with info about those bibs such as title |
19:20 | I tried SELECT items.barcode, biblio.title, items.itemcallnumber, items.ccode, items.itype, items.homebranch from items join biblio using(biblionumber) WHERE HAVING COUNT(items.itemnumber) =1; | |
19:20 | but that doesn't give anything, and I know there are some | |
19:21 | cait | hm |
19:21 | you need a group for the having I thinkg | |
19:21 | wizzyrea | hmm |
19:21 | cait | let me try something :) |
19:22 | wizzyrea | cait++ |
19:25 | cait | SELECT items.barcode, biblio.title, items.itemcallnumber, items.ccode, items.itype, items.homebranch from items join biblio using(biblionumber) WHERE (select count(itemnumber) from items i where i.biblionumber = biblio.biblionumber) = 1 |
19:25 | I have almost no items in my database - you should check if it really works as it should | |
19:25 | Soup left #koha | |
19:25 | wizzyrea | trying... |
19:25 | cait++ | |
19:25 | results! | |
19:25 | wahanui | results are not limited to the year I'm searching |
19:26 | wizzyrea | lol |
19:26 | forget results | |
19:26 | wahanui | wizzyrea: I forgot results |
19:26 | cait | hehe |
19:26 | druthb | cait++ |
19:26 | cait | check if it works first ! :) |
19:28 | wizzyrea | yes, I think it does! |
19:28 | cait | select count(biblionumber), biblionumber from items group by biblionumber having count(biblionumber) = 1 |
19:28 | should give the same biblionumbers | |
19:28 | cool :) | |
19:32 | wizzyrea | hmm the 1st gives 4500, 2nd over 10k |
19:32 | let me try that again | |
19:32 | cait | hmpf |
19:33 | wizzyrea | 1s trying again |
19:33 | I had put an items.homebranch limit on both | |
19:33 | so going to try them straight | |
19:34 | cait | ok |
19:34 | wizzyrea | see if they match |
19:43 | cait | do they? |
19:43 | wizzyrea | hmm no |
19:45 | cait | ok |
19:45 | hmpf | |
19:45 | I am quite sure the second is right.. what we can do | |
19:45 | wizzyrea | hmmm |
19:46 | cait | what about this? |
19:46 | select items.barcode, biblio.title, items.itemcallnumber, items.ccode, items.itype, items.homebranch from items join biblio using(biblionumber) WHERE biblionumber in (select biblionumber from items group by biblionumber having count(*) = 1) | |
19:47 | wizzyrea | oh sneaky.. i see what you did there |
19:47 | it's chewing on that | |
19:48 | cait | hm |
19:49 | hope chewing is good | |
19:49 | wizzyrea | it's fine, i've got a reporting mirror so if it goes out of control it's no biggie. |
19:49 | just takes a bit | |
19:55 | * oleonard | wonders why git branch tab-completion has become so slow for him |
19:55 | cait | hm |
19:55 | wizzyrea | lots of branches? |
19:56 | cait | I notice the same here |
19:56 | wizzyrea | same, it used to be speedier it seems. |
19:56 | but I have a lot more branches than I used to | |
19:57 | oleonard | I don't have more local branches, maybe because of more remote branches? |
19:59 | * oleonard | has been so busy today he hasn't even had time to look at wizzyrea's git-bz wiki page :( |
20:00 | wizzyrea | hmm could be that |
20:00 | it's ok, it'll be there when you're ready ;) | |
20:00 | hdl joined #koha | |
20:00 | wizzyrea | maybe better even ^.^ |
20:02 | cait | wizzyrea: so it did work? |
20:03 | wizzyrea | lol, it's very mad about that query I guess it's still going |
20:05 | cait | ouch :( |
20:08 | perhaps we shoud have replaced that star with biblionumber | |
20:08 | wizzyrea | hmm |
20:12 | hdl | @later tell nengard Could you reproduce bugs 6412 and 6413 on our master ? It looks as though we already worked on that... Will assign that to stephane.delaune who worked on that. |
20:12 | huginn` | hdl: The operation succeeded. |
20:17 | oleonard left #koha | |
20:23 | talljoy joined #koha | |
20:33 | yhager joined #koha | |
20:34 | yhager | Can I delete the default kohaadmin user? or just lock it so login is impossible? |
20:37 | nhusd left #koha | |
20:37 | wizzyrea | i haven't tried |
20:39 | sekjal | yhager: can't delete it, but you could alter Auth.pm not to allow you to login with it |
20:39 | though, you do need it to do upgrades | |
20:39 | wizzyrea | oo yea that could get ugly |
20:39 | could you take away all of it's permissions? | |
20:39 | i.e. untick "superlibrarian" | |
20:39 | sekjal | since it's not an entry in borrowers, no |
20:40 | you'd have to alter the code | |
20:40 | best thing to do is make the password VERY secure | |
20:40 | yhager | sekjal: ok, so how do I change the password? |
20:40 | sekjal | you'd change it in MySQL |
20:40 | wizzyrea | and your koha-conf.xml |
20:40 | sekjal | it's the password for the user that accesses the koha database |
20:41 | wizzyrea | aside: i wonder if we really ought to change that :/ |
20:41 | where that = how that works | |
20:41 | and have the user create a superlibrarian in the web installer | |
20:41 | gmcharlt | wizzyrea: yep, we should |
20:41 | yhager | wait, so the kohaadmin OPAC user password is the same as the database password? |
20:42 | wizzyrea | yes |
20:42 | sekjal | yhager: unless you created a borrower with userid = 'kohaadmin' |
20:42 | yhager | no, I didn't. |
20:42 | sekjal | yeah, then it's the username/password for the DB |
20:42 | yhager | so I *can* change the username too to something else.. |
20:42 | sekjal | yes |
20:43 | yhager | ok, that can reduce some attack potential I guess |
20:44 | what is the limit on password length? | |
20:45 | sekjal | yhager: not aware of one... would need to read MySQL manual for the version you're running |
20:46 | yhager | sekjal: ok, thanks |
20:51 | sekjal | okay, need to rest for a bit. goodnight, #koha |
20:51 | sekjal left #koha | |
20:53 | schuster left #koha | |
20:53 | druthb left #koha | |
20:53 | NateC left #koha | |
20:56 | pianohacker joined #koha | |
20:56 | pianohacker | hi |
20:57 | talljoy left #koha | |
20:58 | yhager | mysql keeps password as 16 chars encrypted, so anything larger than that does not add any security |
21:00 | pianohacker | yhager: But that's a hash, correct? The 16-char hash will continue to change as you add more characters, afaik |
21:01 | yhager | pianohacker: right, but other passwords will still generate the same hash |
21:07 | I must add it feels a bit awkward that the db user is the same as the admin account of the web app. | |
21:08 | gmcharlt | yhager: well, more like *an* admin account |
21:09 | at present, the only other time you need it after installation is during upgrades (that is, if you use the web installer for upgrades; you can also run them from the command-line) | |
21:10 | yhager | gmcharlt: and if I don't use SSL, it means I send my DB user password clear text. I'd like to avoid that (so I guess I'll use the command line..) |
21:10 | gmcharlt | yhager: installer/misc/mysql/updatedatabase.pl to do it from the command line |
21:22 | cait left #koha | |
21:28 | skushner | Anyone ever pxe booted (umm..excuse me, openbooted) a SUN server via Debian Squeeze..?? |
21:40 | bg | nope |
21:52 | hdl | Good night koha |
22:00 | larryb left #koha | |
22:05 | skushner | what a nightmare |
22:05 | wahanui | a nightmare is compounded for me today; not only do I have to deal with MFHD, but I've got to do all kinds of crazy stuff to even GET the data in the first place |
22:05 | wizzyrea | forget nightmare |
22:05 | wahanui | wizzyrea: I forgot nightmare |
22:06 | bg | oh boo wizzyrea that was pretty goodone to remember |
22:06 | gmcharlt | I'm not so sure it is easy to forget that kind of nightmare |
22:06 | wizzyrea | pf |
22:06 | hdl left #koha | |
22:06 | wizzyrea | exactly why it's better for wahanui to forget it |
22:07 | pianohacker | fieldmapping table, relied upon for subtitle display and empty after an upgrade? |
22:07 | * gmcharlt | doesn't think it is sufficient ;) |
22:08 | wizzyrea | hehe |
22:12 | moodaepo left #koha | |
22:13 | skushner left #koha | |
22:14 | rhcl | I want so say something. Should I, or should I just let it drop? |
22:15 | pianohacker | rhcl: about what? the libwebcats situation? |
22:16 | rhcl | yea |
22:18 | pianohacker | what were you thinking of saying? |
22:25 | rhcl | well, if I say it, then what would be the point of asking if I should say it? <humor> :) |
22:26 | ping wizzyrea | |
22:26 | wizzyrea | sup |
22:26 | rhcl | what's the name of a couple of your libraries running Koha? |
22:26 | wizzyrea | atchison, leavenworth |
22:26 | hiawatha | |
22:28 | rhcl | thats enough. Hey, you going to the flea market this weekend at Sparks? |
22:34 | pianohacker | rhcl: in that case, you should probably just say it! :) |
22:37 | rhcl | well, just in case. You're probably right. I'm drafting it now... |
22:48 | * gmcharlt | has weighed in, fwiw |
22:52 | pianohacker | gmcharlt: You are one of the most reliably calm people I know |
22:58 | gmcharlt | pianohacker: thanks |
22:59 | pianohacker | which helps when bombs like social engineering and privacy are dropped |
23:00 | Johnindy left #koha | |
23:01 | Johnindy joined #koha | |
23:08 | rhcl | ballgame's up. time to run. |
23:08 | rhcl is now known as rhcl_baseball | |
23:12 | jransom joined #koha | |
23:12 | jransom | hiya all |
23:18 | Brooke joined #koha | |
23:26 | pianohacker | hi, jransom |
23:34 | aogle left #koha | |
23:35 | aogle joined #koha | |
23:48 | Brooke left #koha |
← Previous day | Today | Next day → | Search | Index