IRC log for #koha, 2012-01-14

All times shown according to UTC.

Time S Nick Message
01:57 mib_rednqy joined #koha
01:59 mib_rednqy hi everyone.  quick question.  Using apt-get and the debian repo, I installed koha.  then I installed mysql
02:00 mib_rednqy I have a koha database, but no tables
02:04 mib_rednqy i ran koha-create --create-db librarydb
02:04 mib_rednqy librarydb is created but contains 0 tables
02:04 mib_rednqy is there a sql file that I can use to populate the librarydb ?
02:35 mib_rednqy anyone?
02:37 mtj mib_rednqy:  those tables are created when you walk-through the Koha web installer
02:37 mtj ... afaik
02:38 mtj[…]tep:_Install_Koha
02:38 mtj kohabox$ sudo koha-create --create-db koha
02:39 mtj 'Once those are done you should be able to see something at http://kohaadmin/ and http://koha/ from your desktop machine. The admin user will be koha_koha, find the password by looking in /etc/koha/sites/koha/koha-conf.xml'
02:43 mib_rednqy i did that with koha-create..    then I connected into mysql and did "show databases".  This listed librarydb
02:43 mib_rednqy I then "use librarydb"
02:43 mib_rednqy lastly "show tables"     and 0 tables
02:45 mib_rednqy then I request the web UI at the base...
02:45 mtj yep... cool...
02:45 mib_rednqy my koha install
02:45 mtj try  http://kohaadmin/
02:45 mib_rednqy it loads
02:46 mtj yep, try  http://kohaadmin/
02:47 mtj using your ip address hits the OPAC, the OPAC is waiting for you to start the web-install...
02:50 mib_rednqy I can't reach http://kohaadmin/   does not resolve
02:51 mtj try adding a kohaadmin hosts entry to your pc
02:52 mtj echo ' kohaadmin' >>  /etc/hosts
02:52 mib_rednqy ok  and have it resolve to the IP of the the koha install??      yes...ok
02:52 mtj yep ;)
02:54 mib_rednqy same result.  a redirect to
02:54 mib_rednqy System Maintenance  The Koha Online Catalog is offline for system maintenance. We'll be back soon! If you have any questions, please contact the Site Administrator
02:56 mib_rednqy "/etc/apache2/sites-enabled# grep kohaadmin *  "
02:56 mib_rednqy has nothing
02:56 mtj hmm
02:57 mtj so whats the ServerName value set to ?
02:57 mtj there should be 2, opac and intranet...
02:58 mtj whats the intranet  'ServerName' set to?
02:58 mib_rednqy " /etc/apache2# grep -i ServerName * "
02:58 mib_rednqy hmmm nothing
02:58 mtj wrong dir
02:59 mtj " /etc/apache2/sites-enables# grep -i ServerName * "
02:59 mib_rednqy ServerName    ServerName
02:59 mtj " /etc/apache2/sites-enabled# grep -i ServerName * "
02:59 mtj right so... add those to your hosts file....
03:00 mtj then hit ''
03:00 mtj ... with your browser
03:01 mib_rednqy hey, it's the web installer
03:01 mib_rednqy thank you web headers
03:01 mtj ha, cool :)
03:01 mib_rednqy and thank you mtj
03:05 mib_rednqy kohauser is the only '<user>' in the koha conf file
03:06 mib_rednqy is there an admin user, or would that be it?     found in /etc/koha/sites/booklibrary/koha-conf.xml
03:07 mtj thats it
03:07 mtj fyi: its what *you* chose too, afaik
03:08 mib_rednqy hmmm      no joy
03:08 mtj its the user that koha attempts to connect to mysql
03:09 mib_rednqy ok.....I created a different userid than what's in that conf.xml file
03:10 mib_rednqy no joy with that userid either
03:10 mtj so, you cant log in?
03:11 mtj to the admin interface?
03:11 mib_rednqy right
03:13 mtj ok, so i gave you bad advice
03:14 mtj theres *3* user elements in the config file
03:15 mtj you need to open up the config file and look in the 'config' section
03:15 mtj its the last section
03:15 mtj .
03:15 mib_rednqy I just found that one
03:15 mib_rednqy trying
03:15 mtj look at the 'user' and 'pass' values
03:16 mtj those are what you need
03:16 mib_rednqy yea
03:16 mib_rednqy web installer step 1
03:16 mib_rednqy to infinity and beyond
03:17 mtj cool, the first two 'user' defs are for zebra bib and authorities
03:17 mib_rednqy yep, i'm understanding a bit more now
03:17 mtj its the last 'user' def that you want :)
03:17 mib_rednqy thanks for your help and patience
03:18 mtj no probs, ive done it hundreds of times :p
03:20 mib_rednqy I'm probably good to go for a while.  I'll go update my install doc and then continue the web install steps
03:20 mib_rednqy thanks for being here.... singing off
03:23 Soupermanito left #koha
03:26 mib_rednqy quick question or suggestion......unimarc  or marc21?
03:27 mtj if your'e english - marc21,  if euro then unimarc
03:27 mib_rednqy xie xie
03:28 mib_rednqy marc21 then  :-)
03:33 mtj ok, gonna scoot now
03:39 mib_rednqy l8r
03:39 mib_rednqy i'm very happy
03:40 mib_rednqy left #koha
04:12 rangi well that sux
04:12 thd-away` joined #koha
04:15 thd-awa`` joined #koha
04:16 thd-away left #koha
04:21 thd-away` left #koha
04:25 stuartyeates left #koha
04:47 kmkale joined #koha
05:14 kmkale a # character in mysql password causes koha to barf :(
05:15 rangi causes koha, or mysql?
05:48 kmkale phpmyadmin and mysql command line logins work with # char in mysql password. But Koha fails
05:49 rangi hmm
05:49 rangi and its getting the passwword ok out of the koha-conf.xml
05:50 kmkale how do I verify that?
05:50 rangi in C4/
05:50 kmkale the password is typed correctli in the conf file. I tried copy pasting from the conf file into command line mysql and it works
05:51 rangi find the sub _new_dbh
05:51 rangi and before this line
05:51 rangi my $dbh= DBI->connect("DBI:$db_driver:dbname=$​db_name;host=$db_host;port=$db_port",
05:51 rangi $db_user, $db_passwd, {'RaiseError' => $ENV{DEBUG}?1:0 }) or die $DBI::errstr;
05:51 rangi do a warn $db_passwd
05:51 kmkale ok. testing now
05:52 rangi (its causeing an internal server error eh?)
05:52 rangi causing even
05:52 kmkale yep will paste the error in just a moment
05:55 rangi if the passwd is ok in the warn, then it looks like a bug with DBI itself (or dbd::mysql)
05:55 rangi if the passwd isnt, its the code reading the config file
06:01 kmkale yikes!! Can't reproduce the error after changing the password back. Will investigate further and report :(
06:10 pastebot "kmkale" at pasted "Koha barfs on # in mysql password" (7 lines) at
06:12 rangi you've put the warn in?
06:13 rangi (thats teh DBI connect, so we need to figure out if its getting the right password)
06:15 kmkale i did but the password is not showing up in web or logs
06:16 Callender left #koha
06:20 kmkale yikes!! it showed old password in the logs so I restarted apache. No difference. Restarted mysql, no difference. Restarted memcached and voila new password shown in the logs and the error was gone. Completely confused :(
06:20 Callender joined #koha
06:24 rangi oh, running master?
06:24 wahanui well, running master is a lot of work
06:25 rangi because a patch was recently pushed to cache to config file
06:25 rangi its probably that
06:25 kmkale rangi: yes gresh git based install. Whenever you do one yourself next time, please use a password with # in it and test.
06:25 kmkale fresh even
06:26 kmkale this is the second time I have faced this issue but can't reproduce reliably to pin it down :(
06:36 kmkale any idea what could be causing git bz to give error like "NameError: global name 'host' is not defined" ??
06:47 kmkale ok. I am working on a cloud hosted server through ssh. So no cookies. Now how do I get git bz to authenticate?
06:50 rangi did you check out git-bz from slefs repo?
06:50 rangi[…]_bz_configuration
06:53 kmkale yep did that.
06:54 rangi and you did the configure username and password bit?
06:54 rangi git config --global U
06:54 rangi git config --global PW
06:54 kmkale tried setting auth-user and auth-password too. No go :(
06:55 kmkale aahh. Tried to be clever didn't I? used auth-user from the man page
06:56 rangi[…]#Configure_git-bz
06:56 rangi that oughta work
06:57 kmkale got it working now. Teaches me not to follow two pages together ;)
07:09 Oak joined #koha
07:10 Oak kia ora #koha
07:10 pastebot "kmkale" at pasted "git bz patch fail" (14 lines) at
07:11 kmkale how do I go about resolving this? Do I edit /tmp/Signed-off-patch-MQYbwi.patch ??
07:13 rangi nope
07:13 rangi git bz doesnt try a 3 way merg
07:13 rangi e
07:13 rangi so what you can do now is
07:13 rangi git am --abort
07:13 rangi git am -iu3 /tmp/Signed-off-patch-MQYbwi.patch
07:13 rangi and try a 3 way merge
07:14 kmkale ok. Its because sysprefs file has changed after the patch has been signed off. So I need to shift the additions down to the end of the file.
07:16 rangi right
07:16 kmkale its asking Apply? [y]es/[n]o/[e]dit/[v]iew patch/[a]ccept all ?? edit?
07:16 rangi y
07:17 rangi and it will try to merge, and if it gets conflicts you can fix them
07:17 kmkale trying that
07:19 kmkale it has put <<<<<<< HEAD in the file.  and put in the additions. So now I just remove the markers and save the file? then mark as resolved?
07:20 rangi yep fix up the conflict and mark resolved
07:20 rangi then you can attach the fixed patch
07:23 kmkale ok. now can I use git bz to continue applying rest of the patches attached to the bug? whats the command for that? Same as git bz apply 1633 ??
07:27 cait joined #koha
07:28 cait good morning #koha
07:28 kmkale Namaste cait
07:28 cait hi kmkale
07:30 Oak Good morning cait :)
07:30 pastebot "kmkale" at pasted "git bz apply error" (5 lines) at
07:30 cait h Oak :)
07:30 Oak :)
07:30 cait kmkale: do git am --abort
07:30 kmkale did
07:30 cait and then git am -iu3 /tmp/...
07:31 cait the problem is git bz apply doesn't do -3
07:31 kmkale did but git am -iu3 also gives "fatal: cannot convert from UTF-8utf-8 to UTF-8" for this file
07:31 cait hm
07:31 cait try without -u
07:32 kmkale "previous rebase directory /home/kk/kohaclone/.git/rebase-apply still exists but mbox given."
07:32 cait git am --abort again :)
07:33 kmkale is it a file encoding type problem?
07:33 cait hm more something about the encoding lines
07:33 cait probably the file itself is ok
07:33 cait if you look at it, there are probably 2 lines for encoding at the beginning
07:33 cait it was like that last time I had the problem
07:33 cait deleting one or both should fix it
07:34 kmkale did --abort the again git am -i3 /tmp/... but again getting "fatal: cannot convert from UTF-8utf-8 to UTF-8"
07:34 cait ok
07:35 cait I would look at the file next
07:35 cait which bug is that?
07:35 kmkale 1633
07:36 cait hm first patch?
07:36 wahanui first patch is in
07:36 cait ah
07:36 cait the last
07:36 cait right?
07:37 cait[…]hment.cgi?id=6983
07:37 cait look at it on bugzilla
07:37 cait I would delete one of those encoding lines
07:37 pastebot "kmkale" at pasted "content type problem?" (4 lines) at
07:38 cait I think it has one Content-Type: too many
07:38 kmkale its got the pasted lines extra over and above other patches attached to the bug
07:38 cait is it the patch I showed you the link ti?
07:38 kmkale is it ok if I edit the /tmp/... file directly and delete the lines?
07:38 kmkale yes
07:40 cait I think so
07:40 kmkale so is it ok to edit the /tmp/SIGNED-OFF-Bug-1633---Interfa​ce-revisions-for-the--pJmkEv.patch file and remove the extra line?
07:40 cait I thinkm so :)
07:40 cait should be ok
07:40 cait if it makes it apply
07:40 kmkale oki. Trying that
07:42 kmkale ok. That did it.
07:42 kmkale Now to test
07:43 cait :)
07:43 kmkale then the daunting task to recreate the changed patches and push :(
07:43 * kmkale is scared of git
07:48 cait it will be all ok
07:48 cait git is nice
07:48 cait what do you want to do? what do yo mean by recreating?
07:54 kmkale there are 5 patches attached to that bug
07:54 kmkale the first & last ones did not apply. So I had to change by doing a 3 way merge.
07:54 kmkale Now I will have to re-generate all the 5 patches and attach to the bug right?
07:56 kmkale[…]_bz_configuration tell me to do git rebase 1stcommitid^ --interactive
07:56 kmkale but what is the 1stcommitid? the 1st patch or the last patch? is it the topmost commitid shown by git log?
07:57 cait the first
07:57 wahanui i guess the first is the command i ran
07:57 cait you applied all of them now, right?
07:57 cait git log shows you all patches?
07:58 cait kmkale: do you need to change them or just want to reattach them to the bug?
07:58 kmkale cait: I have applied all 5 patches now.
07:59 kmkale Git log shows all 5
07:59 cait ok
07:59 cait cool
07:59 cait and do you need to add your sign-off?
07:59 kmkale I had to make changes to 1st and last of the 5
07:59 kmkale by doing a 3 way merge
07:59 cait using git am?
07:59 cait that should be ok
07:59 kmkale yes
08:01 cait ok
08:01 cait so what do you want to do?
08:01 cait add your signoff?
08:02 kmkale re submit the patches with the changes
08:03 cait ok
08:03 Callender left #koha
08:03 cait git bz apply <bugnumber> HEAD^^^^ I think
08:03 cait might be one ^ more
08:03 cait or less
08:03 cait and git bz apply -e if you want to obsolete patches
08:03 cait from the bug
08:05 kmkale ok. Will try that after I test.
08:05 kmkale Thanks cait :)
08:05 cait you are welcome :
08:05 cait :)
08:05 Guillaume1 joined #koha
08:06 Guillaume1 left #koha
08:15 Oak jokeL
08:15 Oak A suburban father is wondering what his daughter's teacher thinks of him:
08:16 Oak Seems that he had to borrow a dollar from his thrifty and money-conscious first-grader one night to pay the paper boy. The next morning he got to worrying lest he had taken her lunch money; so he hurried to the school, knocked at her classroom door and asked to speak with her. "Do you have any money?" he asked anxiously.
08:16 Oak "Yes," she answered in cool tones clearly audible to the teacher, "but you can't have any more. I gave you all I could spare last night."
08:16 Oak ~ Mildrad S. Fenner in NEA Journal
08:20 Callender joined #koha
08:22 rangi git bz attach (not apply) but otherwise cait is right as usual
08:22 cait oh typo
08:22 cait heya rangi
08:23 * kmkale is confused as usual ;)
08:24 kmkale about 1stcommitid
08:25 kmkale but here I do a "git rebase 1stcommitid^ --interactive" now?
08:26 kmkale or a "git bz apply <bugnumber> HEAD^^^^" as advised by cait?
08:26 cait why do you want to do the rebase?
08:26 kmkale I have already applied the ppatches.
08:26 kmkale had to change two of the five.
08:27 cait yes
08:27 cait but why rebase?
08:27 cait add comments?
08:27 kmkale so I need to create and attach new set of patches to obsolete the one needing change.
08:27 kmkale How do I do that? git bz attach -e ?
08:28 Oak who are you talking to cait? I only see your messages, and rangi's for the past 15 minutes.
08:28 cait kmkale?
08:28 wahanui kmkale may be psychic.
08:28 kmkale hiya Oak
08:28 Oak ah, i don't see his messages on this window.
08:28 kmkale am I wearing the invisibility cloak?
08:28 cait I would do
08:28 cait git bz attach -e HEAD^^^1
08:28 cait meh
08:28 cait HEAD^^^^
08:29 kmkale[…]ation#Signing_off mentions rebase
08:29 cait that's what I do, I know there are other ways
08:29 cait yep
08:29 cait that's when you want to add your signoff
08:29 cait and it's the first patch commitid
08:29 cait that you applied
08:29 cait scrolling down when looking at git log
08:29 kmkale ok trying git bz attach -e HEAD^^^^
08:30 Oak weird
08:30 Oak left #koha
08:30 kmkale ok cait ?
08:30 wahanui That's Ms. Cait to you! or in a very good mood today :)
08:31 cait you need the rebase when you want to add your sign-off to the pathces
08:31 cait before reattaching them
08:32 kmkale ok. so lets try git rebase 1stcommitid^ --interactive with 1stcommitid being commit id of the 1st patch I applied when scrolling don on git log.
08:33 cait yep
08:43 kmkale "Successfully rebased and updated refs/heads/bug_1633."
08:44 kmkale now onto "git bz attach -e  xxxx <commitid of first commit" this being the same commit id i gave to rebase correct?
08:46 cait did you all?
08:46 cait all 5 patches?
08:47 cait and yes, should be the same, but you will see in the screen if it's the right one
08:47 thd-away joined #koha
08:47 kmkale ok here goes
08:49 thd-away` joined #koha
08:51 cait now
08:51 thd-away` left #koha
08:51 thd-awa`` left #koha
08:51 cait do it again with one less ^ and without -e
08:51 thd-away` joined #koha
08:51 cait until you have them all attached
08:55 thd-away left #koha
08:58 Callender left #koha
09:00 kmkale had to do them one by one but I think I have all five attached to the bug report now.
09:01 kmkale cait: could you please have a look at bug 1633 page and try to spot if I have made a mistake?
09:01 huginn Bug[…]w_bug.cgi?id=1633 enhancement, PATCH-Sent, ---, kmkale, ASSIGNED , Add ability to take book cover images from local img db
09:01 cait yep
09:01 cait you can only do them one by one
09:01 cait and it looks all ok to me :)
09:05 kmkale no
09:05 kmkale the patch with syspref file changes which I did by resolving megre markers has come out correctly
09:06 kmkale but see attachment 7153 where I edited the file in /tmp and then did a git am
09:06 huginn Attachment[…]=7153&action=edit patch, Bug 1633 - [SIGNED-OFF] Interface revisions for the staff client, Bug-1633---SIGNED-OFFInterfa​ce-revisions-for-the-s.patch
09:06 kmkale this file has come unchanged with the double content-type lines intact
09:07 cait hm perhaps you added it back
09:07 cait accidently
09:08 kmkale nope. It has my comments. But the content-type lines remain
09:08 kmkale woonder how to get rid of that
09:08 cait not sure
09:10 Callender joined #koha
09:12 thd-away joined #koha
09:16 thd-awa`` joined #koha
09:17 thd-away` left #koha
09:21 cul_away is now known as Culiforge
09:22 thd-away left #koha
09:30 Culiforge :~/kohaclone$ sudo ln -s /usr/share/koha/bin/  /etc/init.d/koha-zebra-daemon
09:30 Culiforge ln: creating symbolic link `/etc/init.d/koha-zebra-daemon': File exists
09:30 Culiforge gary@gary-desktop:~/kohaclone$ sudo update-rc.d koha-zebra-daemon defaults
09:30 Culiforge update-rc.d: /etc/init.d/koha-zebra-daemon: file does not exist
09:30 Culiforge file exists, file does not exist?
09:36 kmkale Culiforge: see a ls -l of /etc/init.d/koha-zebra-daemon
09:37 kmkale check if the link points to a correct file
09:38 Culiforge lrwxrwxrwx 1 root root 39 2012-01-13 17:03 /etc/init.d/koha-zebra-daemon -> $/usr/share/koha/bin//
09:40 kmkale $/usr/... ??
09:41 Culiforge I don't understand?
09:41 chrisdothall left #koha
09:41 thd-away joined #koha
09:41 kmkale Culiforge: just remove the link by doing a rm /etc/init.d/koha-zebra-daemon and then recreate
09:42 kmkale by doing a sudo ln -s /usr/share/koha/bin/ /etc/init.d/koha-zebra-daemon
09:42 kmkale then check if you can open the file by doing less /etc/init.d/koha-zebra-daemon
09:43 thd-awa`` left #koha
09:43 kmkale if its the correct file then sudo update-rc.d koha-zebra-daemon defaults again
09:44 Culiforge all right, that appears to have done it
09:44 Culiforge i've lost my prompt though... after that less command
09:45 thd-away` joined #koha
09:45 Culiforge ahh, dvm.. q did it
09:46 kmkale do a /etc/init.d/koha-zebra-daemon start and check if zebra has started by running ps aux |grep zebra
09:46 Culiforge gary      2036  0.0  0.1   3376   796 pts/2    S+   04:46   0:00 grep --color=auto zebra
09:47 Culiforge does that look right?
09:48 Culiforge no errors at least :)
09:48 kmkale no you need to see a big line telling you how zebra is running
09:48 kmkale that does not look right
09:49 Culiforge dang!
09:49 fredericd Culiforge: why do you use koha-zebra-daemon? It's deprecated. Your're supposed to use and a cronjob...
09:49 Culiforge just following the git install tutorial for lucid...
09:49 kmkale after q in less command did you run "sudo update-rc.d koha-zebra-daemon defaults" command
09:49 thd-away left #koha
09:50 thd-awa`` joined #koha
09:50 thd-awa`` is now known as thd-away
09:50 Culiforge yes
09:50 kmkale fredericd: zebraqueue is deprecated
09:50 kmkale you still need to run zebra server
09:51 kmkale Culiforge: then did you do a "/etc/init.d/koha-zebra-daemon start" ??
09:51 fredericd sorry, I've misread...
09:51 Culiforge I did
09:51 kmkale Culiforge: and did it say starting zebra server?
09:52 Culiforge I get back 'starting zebra server'
09:52 kmkale ok then sudo ps aux |grep zebra should return atleast two lines
09:52 kmkale if zebra has started.
09:52 kmkale if not check the zebra log under /var/log/koha
09:53 thd-away` left #koha
09:54 Culiforge I have a koha-error_log and koha-opac-error_log and a readme
09:55 Culiforge afk one min brb
09:55 kmkale should have a koha-zebradaemon.err and a koha-zebradaemon-output.log
09:56 kmkale did you choose to install and use zebra during perl Makefile.PL step?
09:59 Culiforge ok, back. yes I did
10:06 Irma joined #koha
10:06 fredericd Culiforge: What is exactly your problem?
10:06 Culiforge scrolling back, I see no errors or warnings during the make install
10:07 cait hi fredericd :)
10:07 Culiforge fredericd: just trying to get koha installed and running... making sure I fix any errors as I go
10:07 fredericd cait: hello!
10:08 fredericd Do you hava data in your koha instance?
10:08 fredericd you need to be able to check Zebra search/indexing
10:08 kmkale left #koha
10:08 Culiforge brand new install so I believe not
10:09 Culiforge if I understand what you're asking
10:09 fredericd So, once you have finished installiong everything, you have to populated your DB and see if Zebra works
10:10 kmkale joined #koha
10:10 Culiforge kmkale was saying I'm not getting correct output from sudo ps aux |grep zebra
10:10 kmkale Culiforge: ok then edit the /etc/init.d/koha-zebra-daemon and check your KOHA_CONF=/etc/koha/koha-conf.xml and ZEBRASRV=/usr/bin/zebrasrv lines
10:11 Culiforge yes, they are there as you typed
10:12 kmkale Culiforge: have you created a user koha?
10:13 thd-away` joined #koha
10:13 pastebot "kmkale" at pasted "/etc/init.d/koha-zebra-daemon" (17 lines) at
10:13 thd-away` left #koha
10:14 Culiforge my user at the head of this file is user=gary Do I specifically need the koha user as well.. I don't recall actually creating it if the git tutorial did'nt specifically say to
10:14 kmkale Culiforge: ^^ is how my /etc/init.d/koha-zebra-daemon file starts
10:14 thd-away` joined #koha
10:15 kmkale your user needs write access to the dirs LOGDIR, RUNDIR and LOCKDIR
10:16 kmkale Culiforge: also test if /usr/bin/zebrasrv actually exists and if its executable by all
10:16 Culiforge here is my daemon file:
10:17 thd-awa`` joined #koha
10:18 Culiforge zebrasrv is owned by root and read/write by owner read only by group and  others
10:18 thd-awa`` left #koha
10:19 thd-away left #koha
10:19 thd-awa`` joined #koha
10:19 thd-awa`` is now known as thd-away
10:20 Culiforge how do I check write access to logdir, rundir and lockdir and change perms for zebrasrv
10:20 kmkale sudo chmod a+x /usr/bin/zebrasrv
10:21 kmkale sudo chown gary /var/log/koha
10:21 kmkale sudo chown gary /var/lock/koha
10:21 kmkale sudo chown gary /var/run/koha
10:22 thd-away` left #koha
10:23 Culiforge /usr/bin/zebrasrv permissions did not change...
10:24 kmkale here is how my perms look : lrwxrwxrwx   1 root     root           26 Jan 27  2009 /usr/bin/zebrasrv -> /etc/alternatives/zebrasrv
10:25 Culiforge how do I get that output? ie.. what command?
10:25 kmkale ls -l /usr/bin/zebrasrv
10:26 Culiforge ls -l /usr/bin/zebrasrv
10:26 Culiforge lrwxrwxrwx 1 root root 26 2012-01-12 06:34 /usr/bin/zebrasrv -> /etc/alternatives/zebrasrv
10:26 kmkale ls -l /etc/alternatives/zebrasrv
10:27 Culiforge ls -l /etc/alternatives/zebrasrv
10:27 Culiforge lrwxrwxrwx 1 root root 21 2012-01-12 06:34 /etc/alternatives/zebrasrv -> /usr/bin/zebrasrv-2.0
10:27 kmkale ls -l /usr/bin/zebrasrv-2.0
10:27 Culiforge ls -l /usr/bin/zebrasrv-2.0
10:27 Culiforge -rwxr-xr-x 1 root root 18040 2009-12-14 16:28 /usr/bin/zebrasrv-2.0
10:28 kmkale ok now check perms on /var/log/koha
10:28 kmkale and /var/run/koha
10:28 kmkale and /var/lock/koha
10:29 kmkale these need to be writable to your gary user
10:29 thd-away` joined #koha
10:30 Culiforge var/log is writable but group is root
10:31 kmkale do a sudo chown -R gary /var/log/koha
10:31 kmkale do a sudo chown -R gary /var/lock/koha
10:31 kmkale do a sudo chown -R gary /var/run/koha
10:32 kmkale as per yor daemon file the group needs to be koha
10:32 thd-away left #koha
10:33 kmkale so create a group koha, add user gary to group koha and the  do sudo chown -R gary:koha /var/log/koha
10:33 kmkale sudo chown -R gary:koha /var/lock/koha
10:33 kmkale sudo chown -R gary:koha /var/run/koha
10:34 Culiforge I have gary in group koha but i'm not sure koha group exists.... how do I check
10:34 thd-away joined #koha
10:34 kmkale Culiforge: how do you know then that gary is in group koha?
10:35 kmkale groupadd koha
10:35 kmkale sudo groupadd koha
10:36 Culiforge through the users/group from desktop gui.. (i'm pretty green... using linux about 2 months now please excuse if I say dumb stuff )
10:36 Culiforge ok, group is there
10:36 kmkale hey don't worry we all learnt the same way :)
10:37 kmkale so run the above chown commands
10:37 thd-awa`` joined #koha
10:37 kmkale and show us the output of ls -l /var/log|grep koha
10:38 thd-away` left #koha
10:38 Culiforge yeah my biggest kudo is that I learned the middle button copy/paste thing... pretty proud of myself
10:38 Culiforge ls -l /var/log|grep koha
10:38 Culiforge drwxr-xr-x 2 gary              koha    4096 2012-01-13 16:57 koha
10:38 * kmkale doesn't have a middle button on his laptop
10:38 kmkale and ls -l /var/lock|grep koha
10:39 kmkale and ls -l /var/run|grep koha
10:39 Culiforge ls -l /var/lock|grep koha
10:39 Culiforge drwxr-xr-x 3 gary     koha 60 2012-01-13 16:43 koha
10:39 Culiforge left and right button together should emulate middle click
10:39 kmkale did you run the above sudo chown -R commands?
10:39 Culiforge I did
10:40 kmkale cool so try running zebra again then :)
10:40 kmkale sudo /etc/init.d/koha-zebra-daemon start
10:41 Culiforge starting zebra server
10:41 thd-away` joined #koha
10:41 kmkale ps aux |grep zebra
10:42 Culiforge ps aux |grep zebra
10:42 Culiforge gary      2224  0.0  0.1   3696   532 ?        Ss   05:39   0:00 daemon --name=koha-zebra-ctl.kohadatabase --errlog=/var/log/koha/koha-zebradaemon.err --stdout=/var/log/koha/koha-zebradaemon.log --output=/var/log/koha/koha-zebradaemon-output.log --verbose=1 --respawn --delay=30 -- /usr/bin/zebrasrv -v none,fatal,warn -f /etc/koha/koha-conf.xml
10:42 Culiforge gary      2225  0.0  1.1  29620  5044 ?        S    05:39   0:00 /usr/bin/zebrasrv -v none,fatal,warn -f /etc/koha/koha-conf.xml
10:42 Culiforge gary      2246  0.0  0.1   3376   804 pts/2    S+   05:41   0:00 grep --color=auto zebra
10:42 kmkale cool
10:42 Culiforge is that what we were looking for?
10:42 Culiforge woot!
10:42 kmkale there u go
10:42 thd-away left #koha
10:42 Culiforge so I should be good to move on to the web setup now?
10:42 kmkale yup
10:43 Culiforge sweet, thanks so much... I'll be back when I mess up something else :)
10:43 kmkale u r welcome :)
10:45 thd-awa`` left #koha
10:47 Callender left #koha
10:47 Culiforge Hey, guess what... I'm back.
10:48 fredericd kmkale++
10:49 kmkale Culiforge: check ur mysql password for user gary and if u did a grant all on .... during install
10:50 Culiforge this is where I ended up a month or so ago trying to install koha. I thought I had messed things up irreparably but I was being so careful this time
10:50 Culiforge yes. did grant all
10:51 Callender joined #koha
10:51 kmkale check if you can access ur db via comandline mysql tool
10:51 kmkale using the same credentials
10:52 Culiforge mmm, denied
10:57 kmkale so thats the pproblem
10:59 Culiforge so, as I take baby steps.... I'll need to change the mysql gary pwd and update it in the koha-conf.xml<somethigorother>?
10:59 thd-away joined #koha
10:59 kmkale match your gary user mysql passwoord to that in koha-conf.xml
11:00 Culiforge is there a way to retrieve the pwd from mysql... I was certain of what I used
11:00 kmkale not from mysql but you can read it in ur koha-conf.xml
11:00 kmkale and reset it in mysql to same value
11:01 Culiforge I could look back, I just hope it's not more than 20000 lines
11:01 Culiforge ok, where is the xml file located..
11:01 kmkale its at /etc/koha/
11:04 thd-away` left #koha
11:05 Culiforge ok, found it in the xml... it's what I thought it was... don't know why it isn't the same from the mysql setup.. but how do I go about changing it in mysql
11:05 Culiforge I'm in mysql -uroot
11:06 kmkale SET PASSWORD FOR 'gary'@'localhost' = PASSWORD( '******' )
11:09 Culiforge single quotes yes, parentheses no?
11:09 kmkale replace *'s wiith your password from the xml file thats it
11:10 Culiforge ok, no output at a -> prompt
11:10 kmkale thats fine
11:10 kmkale try web installer again
11:10 Culiforge any flushing or updating? or back to web... OK
11:11 Culiforge hmm, same
11:11 kmkale try mysql -ugary -p
11:12 kmkale also check the database name in the xml file is the same as the database u created in mysql and did a grant all on
11:14 kmkale brb
11:16 Culiforge hmmm... everything seems in order. reran the grant cmd  still won't allow access
11:22 Culiforge apache is running otherwise I wouldn't get the web error msg right?
11:30 kmkale right
11:30 kmkale do you have any # or other such odd character in the password?
11:31 kmkale are u able to login wiith mysql -ugary i command line using the same password?
11:32 Culiforge just i or -i
11:33 kmkale that was a in
11:33 kmkale mysql -ugary -p <databasename>
11:33 Culiforge no
11:34 Culiforge denied
11:34 kmkale u need to solve that problem first. try checking the database name
11:34 Culiforge no odd characters.. all apha numeric
11:34 kmkale try logging in to mysql as root and drop database and re-create it. then do a grant all again
11:35 Culiforge what's the drop command
11:35 kmkale drop database databasename;
11:36 Culiforge then create database databasename;
11:37 kmkale yup
11:39 Culiforge aha! figured it out... when i pasted the grant command I didn't remove the <>'s
11:39 Culiforge <==== dope
11:39 kmkale heh :)
11:42 Culiforge getting unknown database error on webpage now
11:43 Culiforge do I need to do the flush privileges in mysql
11:43 kmkale yes
11:44 Culiforge hmm, still unknown database error
11:44 kmkale check database name in mysql n koha-conf.xml match
11:46 Culiforge database isn't showing up in show databases;
11:47 kmkale then create database and do grant all again then flush privs again
11:48 Culiforge aha... eureka! and 'bon vivant! and pip pip
11:49 kmkale :-D
11:49 Culiforge so the login for the koha web setup is my 'gary' and pwd?
11:49 kmkale yup
11:49 Culiforge hehe, it's like xmas morning!
11:50 Culiforge so out of curiosity... without any marc info... how much space does a koha install take up?
11:51 kmkale haven't counted ;)
11:52 Culiforge rough estimate?
11:52 kmkale try urself use du -chs command on
11:52 kmkale dirs /usr/share/koha
11:53 kmkale + /var/log/koha
11:53 kmkale + /var/lock/koha
11:53 kmkale + /var/run/koha
11:53 Culiforge is it possible to string all those directories under the same command or no?
11:54 kmkale + /var/lib/mysql/
11:54 kmkale not that I know of
11:56 kmkale tried it works if you just string up the dirs with space inbetweeen
11:56 kmkale mine says 1.6gb total
11:57 Culiforge mine shows a hare over 334M but that's without any book data
11:58 Culiforge roughly how much book data do you have i.e. #of records
11:58 kmkale heh and on a real server with about 1 mil books its 18gb
11:59 kmkale add /var/lib/koha to that list
11:59 kmkale and /etc/koha
12:00 kmkale thats 32g for a 1mil record koha server
12:01 Culiforge that's not bad.. has anyone worked out portability for a koha installation?
12:01 kmkale meaning?
12:02 kmkale you just need a backup of ur mysql db. thats it. reinstall koha on a new server, restore mysql db backup and u r good to go
12:04 Culiforge well, I work for my city's school system and I'm looking into cataloging all the libraries... it seems it would be much easier to carry around an external HD with a "portable" koha on it... hmmm... gears turning... I can access all features of a koha install from any computer right?
12:04 kmkale yep
12:05 Culiforge so I just centrally install koha and web access it from each school.. right?
12:05 kmkale yes
12:05 Culiforge no brainer.. that's the way to go... it just gets easier from here on out
12:07 Culiforge so my gary login is the admin through the web interface.. I need to create individual sub logins for smaller admin tasks right...
12:07 kmkale yes
12:07 cait always create another admin login
12:07 Culiforge ie. gary=sysadmin and others =branch librarians
12:08 cait don't use the 'root' admin from installation to play with it
12:08 cait it's not a real user and weird things can happen
12:08 Culiforge so gary login is essentially the root and has too many permissions
12:08 kmkale have a look at
12:08 cait it has no real borrowernumber - that can cause problems
12:08 cait you will need it for updates
12:08 Culiforge yup, I was gonna hunt that down now that web setup is complete
12:08 cait but you should use a superlibrarian (that's a permisson) for everything else
12:08 cait :)
12:09 Culiforge right on, thanks everyone.. you're all so helpful, now to get more coffee and see what's under the hood so to speak.
12:15 cait left #koha
12:32 kmkale bye all
12:32 kmkale left #koha
12:39 Culiforge is now known as cul_away
12:39 cul_away left #koha
13:31 Callender left #koha
13:40 Callender joined #koha
13:41 Guillaume1 joined #koha
14:18 kmkale joined #koha
14:18 jcamins_away kmkale: I fixed the patch.
14:18 jcamins_away is now known as jcamins
14:19 jcamins kmkale: I didn't change the code at all, just reuploaded it.
14:26 Guillaume1 left #koha
14:27 kmkale yes I was just reading your comment
14:27 kmkale so you just changed the cubject line?
14:27 kmkale *subject
14:27 jcamins Right.
14:28 jcamins Though it took me a half hour to figure that out.
14:28 kmkale jcamins: we need to push QA to pass this and RM to push this. Else we will have to keep making new patches every few days :(
14:28 jcamins Agreed.
14:28 * jcamins has been telling sekjal that it's ready for QA every day.
14:28 kmkale as changes to other files like sysprefs fails the patch, like it did for me today
14:29 jcamins Though, it seems to me that magnuse is on the QA team.
14:29 jcamins Perhaps he can mark it Passed QA.
14:29 kmkale yes and he seems to have signed it off
14:29 kmkale jcamins: :) you took the words off my mouth / keyboard
14:30 jcamins :)
14:30 kmkale jcamins: so how's life in the big apple?
14:30 jcamins Next time I see him online, I'll nudge him.
14:31 jcamins kmkale: things are going pretty well, except our apartment purchase has hit a snag.
14:31 kmkale jcamins: that co-op thing?
14:31 jcamins Yup.
14:31 kmkale ?
14:31 jcamins We were approved, but now it sounds like someone doesn't want to close.
14:31 kmkale hell
14:31 jcamins Either the seller, or the lawyer, or someone.
14:32 kmkale so current residence is a rented one is it?
14:32 jcamins Right.
14:33 jcamins And our current landlord is terrible.
14:33 kmkale heh
14:34 kmkale no late night parties allowed?
14:34 jcamins lol
14:34 jcamins I wish.
14:34 jcamins Our downstairs neighbors scream all night every night.
14:34 kmkale :) spread the fudge around
14:34 jcamins :)
14:36 jcamins Between that, the cockroaches (we have hundreds), and the fact that everything in our apartment is falling apart, we don't like living here.
14:37 jcamins So I spent about an hour on the phone yesterday shouting at people.
14:37 jcamins Other than that, things are going very well.
14:37 jcamins How about for you?
14:37 jcamins :)
14:37 kmkale sorry was on the phone
14:38 jcamins No problem.
14:38 kmkale things are pretty bad for me right now. Great workwise bad otherwise..
14:38 jcamins Oh no!
14:39 jcamins I'm very sorry to hear that.
14:43 jcamins Housing problems for you, too?
14:44 kmkale let it be
14:45 jcamins Okay.
14:45 kmkale i did a koha install on rackspace today and one on amazon last week
14:45 kmkale must say rackspace is better in performance and price
14:46 jcamins Oh?
14:46 jcamins My experience with Rackspace is that they went down all the time.
14:46 kmkale rackspace 2gb mem image performs better than amazom m1.small
14:47 kmkale huh? I have a request tracker install on rackspace thats not gone down at all in last 1 year
14:47 jcamins Really?
14:47 jcamins Wow.
14:48 jcamins ByWater used Rackspace, and either a server was down or the control panel was down nearly all the time.
14:48 jcamins At least, that's what it felt like to me.
14:49 kmkale aww. opposit experiences
14:50 jcamins The other problem with Rackspace is that the disk space is linked to the amount of memory, so you can't have a system with extra disk space.
14:51 kmkale yeah thats true and the cloud files stuff cant be attached as a volume
14:51 kmkale but 80gb is ok for koha n RT
14:51 kmkale most of the time that is
14:52 kmkale my amazon instances always feel like there is a cpu heavyweight running on the same server
14:53 jcamins Hm. Mostly I find myself running out of disk space.
14:53 jcamins Well, not on EC2.
14:53 jcamins But I work with very unusual collections.
14:54 jcamins If the OPACs get 1 search per day that isn't me, that's unusual.
14:54 kmkale that isent me?
14:55 kmkale gotta go dinner time bbl
14:55 jcamins Most of the collections I host are ones that I am cataloging, too.
14:55 jcamins Enjoy.
15:01 cait joined #koha
15:02 * jcamins waves to cait.
15:03 cait hi jcamins :)
15:03 cait and hi #koha
15:28 cait left #koha
16:28 cait joined #koha
16:41 kmkale left #koha
16:48 cait hi #koha
16:58 Callender left #koha
17:10 Callender joined #koha
17:28 Callender left #koha
17:40 Callender joined #koha
17:43 wizzyrea1 joined #koha
17:43 wizzyrea is now known as Guest24039
17:43 wizzyrea1 is now known as wizzyrea
17:50 slef hi all... how did that Audio NP spam get onto
17:50 cait hi slef
18:14 Johnindy_ joined #koha
18:14 Johnindy left #koha
18:17 slef updated[…]ki_RFC#Proposal_2 - I'm really worried that we may get banned from search engines :-/
18:18 cait hm
18:18 cait it's only one mail so far
18:19 slef yeah but it's a seductive idea, copying content to manipulate search engine results... until you realise that most engines will delete you for it
18:20 rangi cait: talking about different things I think :)
18:21 rangi   <--- now im thinking about this for my next phone
18:21 cait yep
18:21 cait and morning rangi :)
18:21 cait oh
18:21 rangi mostly because its running meego, and people have already done stuff like this
18:21 cait I think uli has that
18:21 rangi
18:22 cait it's nice
18:22 rangi oh cool
18:22 cait he let me test type on it :)
18:22 cait he seems quite happy too
18:22 rangi cool
18:31 jcamins rangi: meego is better than android?
18:31 cait it's not google
18:32 jcamins cait: yeah, but isn't android open source?
18:32 jcamins Oh, looks like MeeGo is too.
18:32 rangi sorta
18:32 jcamins I thought that was the Nokia OS.
18:33 rangi nope, its linux
18:33 jcamins Nifty.
18:33 rangi i actually had meego running on my netbook for a while
18:33 jcamins A shame that Verizon will never offer that as an option.
18:35 slef meego was nokia wasn't it?
18:35 rangi the main thing i like is it comes with a real terminal
18:35 rangi yep
18:35 rangi its .deb based
18:35 slef as was symbian... and that was FOSS before it died too
18:35 rangi yup
18:36 rangi so on the n9, you can open a terminal, and dpkg -i
18:36 slef heh, Verizon, from the land of the free (as long as you are not a phone customer)
18:36 rangi (i can get it unlocked, so can hook up to any of the 3 providers here by getting a sim card)
18:37 slef IIRC in the US, the market won't provide unlocked phones at sane prices, the regulators won't intervene to protect customers.
18:39 jcamins slef: yes, that's true.
18:40 jcamins slef: for those networks that use GSM you can have a European buy you a phone (or unlock it yourself), but Verizon doesn't use GSM.
18:40 jcamins (yes, Europeans can buy unlocked phones in the US)
18:40 rangi also, with the n9 if you switch on developer mode, you get an ssh server, so you can ssh to your phone, which i like
18:40 * rangi is rapidly talking himself into buying one
18:40 jcamins rangi: I noticed.
18:41 cait hehe
18:41 cait I like it because when I get one
18:41 cait I can ask rangi for help
18:41 rangi its pretty much debian under the hood, afaict
18:41 rangi so in theory
18:41 rangi i can run koha on it
18:41 rangi lol
18:41 slef jcamins: we have UMTS too. Is Verizon that C... one?
18:41 slef jcamins: we also have some tri- and quad-band phones but not so many since 3G I think.
18:42 Soupermanito joined #koha
18:42 jcamins CDMA.
18:43 jcamins That's the one.
18:43 jcamins Incredibly backwards.
18:44 jcamins *backward
18:44 slef Will it die?
18:45 jcamins Doesn't look like it.
18:46 jcamins There are some GSM providers, but the US doesn't really have the infrastructure for GSM yet.
18:47 jcamins If you're in a rural area, Verizon is really the only game in town.
18:47 jcamins (and my mother-in-law lives in a rural area)
19:13 wizzyrea left #koha
19:30 * rangi heads off to file a lost property report at the police station, hopefully my contents insurance will pay out on the phone
19:30 * rangi will bbl
19:32 cait :(
19:32 chrisdothall joined #koha
19:32 cait hi chrisdothall
19:32 chrisdothall cait: morning :)
19:33 cait :)
19:39 slef rangi: it was painless filing a lost property report in Auckland!
19:58 jcamins is now known as jcamins_baking_compulsively
19:59 jcamins_baking_compulsively @later tell magnuse Hey, you're part of the QA team. Wouldn't you like to be official QA-er for bug 1633? :)
19:59 huginn jcamins_baking_compulsively: The operation succeeded.
20:08 cait jcamins_baking_compulsively: doesn't it have 3 sign-offs now?
20:09 cait and I think magnuse is 'only' a bug wrangler?
21:14 druthb joined #koha
21:14 druthb o/
21:15 cait Hi :)
21:36 magnus_zzz cait is right, i'm only a bug wrangler, not a qa'er, and i sgined off
21:36 druthb hi, magnus_zzz!  :)
21:36 cait now talking in your sleep? :)
21:36 magnus_zzz yup
21:36 jcamins_baking_compulsively magnus_zzz: alas.
21:36 magnus_zzz or not far from it at least
21:37 * jcamins_baking_compulsively will nudge sekjal more then.
21:37 magnus_zzz good plan :-)
21:37 magnus_zzz is now known as magnus_away
21:37 cait jcamins_baking_compulsively: perhaps marcel?
21:38 magnus_away or Jonathan Druart
21:38 magnus_away
21:42 magnus_away g'night #koha
21:42 cait good night magnus_away
22:00 Johnindy_ left #koha
22:15 BobB left #koha
22:43 druthb left #koha
22:43 cait left #koha
22:44 rangi right, claim lodged with insurance company
22:45 chrisdothall rangi: what happened?
22:46 rangi i must have put it down somewhere in cuba street yesterday, and it got picked up by someone
22:46 chrisdothall rangi: my irssi session died so I have nob
22:47 chrisdothall b
22:47 rangi because it had been turned off when i called it 30 mins
22:47 chrisdothall backlog*, what was it*
22:47 rangi ahh
22:47 rangi my cellphone
22:47 chrisdothall and my typing is failing... sorry all
22:47 rangi so had to go to vodafone and block the account
22:47 rangi then race home and revoke access to all apps on the phone, and change passwords just in case
22:47 rangi and switched on prey to missing mode
22:48 chrisdothall rangi: ouch badluck,
22:48 rangi so i should get notified if someone connects it to the network
22:48 rangi but yeah, filed lost property report, and lodged an insurance claim
22:48 rangi annoying more than anything
22:49 chrisdothall yeah, even after you get a new phone you have to go through all the setup and w.e, and you will be phoneless for a while >.>
22:50 rangi yeah :(
23:17 stuartyeates joined #koha

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