IRC log for #koha, 2012-01-14

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
01:57 mib_rednqy joined #koha
01:59 mib_rednqy hi everyone.  quick question.  Using apt-get and the koha-community.org debian repo, I installed koha.  then I installed mysql
01:59 I have a koha database, but no tables
02:03 i ran koha-create --create-db librarydb
02:03 librarydb is created but contains 0 tables
02:04 is there a sql file that I can use to populate the librarydb ?
02:34 anyone?
02:36 mtj mib_rednqy:  those tables are created when you walk-through the Koha web installer
02:36 ... afaik
02:37 http://wiki.koha-community.org[…]tep:_Install_Koha
02:37 kohabox$ sudo koha-create --create-db koha
02:38 '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:42 mib_rednqy i did that with koha-create..    then I connected into mysql and did "show databases".  This listed librarydb
02:42 I then "use librarydb"
02:43 lastly "show tables"     and 0 tables
02:44 then I request the web UI at the base...    http://192.168.0.33/
02:44 mtj yep... cool...
02:44 mib_rednqy my koha install
02:45 mtj try  http://kohaadmin/
02:45 mib_rednqy it loads   http://192.168.0.33/cgi-bin/koha/maintenance.pl
02:45 mtj yep, try  http://kohaadmin/
02:46 using your ip address hits the OPAC, the OPAC is waiting for you to start the web-install...
02:49 mib_rednqy I can't reach http://kohaadmin/   does not resolve
02:50 mtj try adding a kohaadmin hosts entry to your pc
02:51 echo '192.168.0.33 kohaadmin' >>  /etc/hosts
02:51 mib_rednqy ok  and have it resolve to the IP of the the koha install??      yes...ok
02:51 mtj yep ;)
02:54 mib_rednqy same result.  a redirect to maintenance.pl
02:54 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:55 "/etc/apache2/sites-enabled# grep kohaadmin *  "
02:55 has nothing
02:56 mtj hmm
02:56 so whats the ServerName value set to ?
02:57 there should be 2, opac and intranet...
02:57 whats the intranet  'ServerName' set to?
02:57 mib_rednqy " /etc/apache2# grep -i ServerName * "
02:57 hmmm nothing
02:58 mtj wrong dir
02:58 " /etc/apache2/sites-enables# grep -i ServerName * "
02:58 mib_rednqy ServerName booklibrary.chpcs.org    ServerName booklibrary-intra.chpcs.org
02:58 mtj " /etc/apache2/sites-enabled# grep -i ServerName * "
02:59 right so... add those to your hosts file....
02:59 then hit 'booklibrary-intra.chpcs.org'
02:59 ... with your browser
03:00 mib_rednqy hey, it's the web installer
03:00 thank you web headers
03:00 mtj ha, cool :)
03:01 mib_rednqy and thank you mtj
03:04 kohauser is the only '<user>' in the koha conf file
03:05 is there an admin user, or would that be it?     found in /etc/koha/sites/booklibrary/koha-conf.xml
03:06 mtj thats it
03:07 fyi: its what *you* chose too, afaik
03:07 mib_rednqy hmmm      no joy
03:07 mtj its the user that koha attempts to connect to mysql
03:08 mib_rednqy ok.....I created a different userid than what's in that conf.xml file
03:09 no joy with that userid either
03:10 mtj so, you cant log in?
03:10 to the admin interface?
03:11 mib_rednqy right
03:13 mtj ok, so i gave you bad advice
03:13 theres *3* user elements in the config file
03:14 you need to open up the config file and look in the 'config' section
03:14 its the last section
03:14 .
03:15 mib_rednqy I just found that one
03:15 trying
03:15 mtj look at the 'user' and 'pass' values
03:15 those are what you need
03:15 mib_rednqy yea
03:16 web installer step 1
03:16 to infinity and beyond
03:16 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:17 mtj no probs, ive done it hundreds of times :p
03:19 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:19 thanks for being here.... singing off
03:25 quick question or suggestion......unimarc  or marc21?
03:26 mtj if your'e english - marc21,  if euro then unimarc
03:27 mib_rednqy xie xie
03:27 marc21 then  :-)
03:32 mtj ok, gonna scoot now
03:39 mib_rednqy l8r
03:39 i'm very happy
04:11 rangi well that sux
04:12 thd-away` joined #koha
04:15 thd-awa`` joined #koha
04:46 kmkale joined #koha
05:13 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:48 rangi hmm
05:49 and its getting the passwword ok out of the koha-conf.xml
05:49 kmkale how do I verify that?
05:50 rangi in C4/Context.pm
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:50 rangi find the sub _new_dbh
05:50 and before this line
05:50 my $dbh= DBI->connect("DBI:$db_driver:dbname=$​db_name;host=$db_host;port=$db_port",
05:50 $db_user, $db_passwd, {'RaiseError' => $ENV{DEBUG}?1:0 }) or die $DBI::errstr;
05:50 do a warn $db_passwd
05:51 kmkale ok. testing now
05:51 rangi (its causeing an internal server error eh?)
05:51 causing even
05:51 kmkale yep will paste the error in just a moment
05:54 rangi if the passwd is ok in the warn, then it looks like a bug with DBI itself (or dbd::mysql)
05:54 if the passwd isnt, its the code reading the config file
06:00 kmkale yikes!! Can't reproduce the error after changing the password back. Will investigate further and report :(
06:09 pastebot "kmkale" at 59.181.126.113 pasted "Koha barfs on # in mysql password" (7 lines) at http://paste.koha-community.org/199
06:12 rangi you've put the warn in?
06:12 (thats teh DBI connect, so we need to figure out if its getting the right password)
06:14 kmkale i did but the password is not showing up in web or logs
06:19 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:24 rangi because a patch was recently pushed to cache to config file
06:24 its probably that
06:24 kmkale rangi: yes gresh git based install. Whenever you do one yourself next time, please use a password with # in it and test.
06:24 fresh even
06:25 this is the second time I have faced this issue but can't reproduce reliably to pin it down :(
06:35 any idea what could be causing git bz to give error like "NameError: global name 'host' is not defined" ??
06:46 ok. I am working on a cloud hosted server through ssh. So no cookies. Now how do I get git bz to authenticate?
06:49 rangi did you check out git-bz from slefs repo?
06:50 http://wiki.koha-community.org[…]_bz_configuration
06:53 kmkale yep did that.
06:53 rangi and you did the configure username and password bit?
06:53 git config --global bz-tracker.bugs.koha-community.org.bz-user U
06:53 git config --global bz-tracker.bugs.koha-community.org.bz-password PW
06:54 kmkale tried setting auth-user and auth-password too. No go :(
06:54 aahh. Tried to be clever didn't I? used auth-user from the man page
06:55 rangi http://wiki.koha-community.org[…]#Configure_git-bz
06:55 that oughta work
06:56 kmkale got it working now. Teaches me not to follow two pages together ;)
07:09 Oak joined #koha
07:09 Oak kia ora #koha
07:09 pastebot "kmkale" at 59.181.126.113 pasted "git bz patch fail" (14 lines) at http://paste.koha-community.org/200
07:11 kmkale how do I go about resolving this? Do I edit /tmp/Signed-off-patch-MQYbwi.patch ??
07:12 rangi nope
07:12 git bz doesnt try a 3 way merg
07:12 e
07:12 so what you can do now is
07:12 git am --abort
07:13 git am -iu3 /tmp/Signed-off-patch-MQYbwi.patch
07:13 and try a 3 way merge
07:13 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:16 and it will try to merge, and if it gets conflicts you can fix them
07:16 kmkale trying that
07:19 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:19 rangi yep fix up the conflict and mark resolved
07:19 then you can attach the fixed patch
07:22 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:26 cait joined #koha
07:27 cait good morning #koha
07:27 kmkale Namaste cait
07:27 cait hi kmkale
07:29 Oak Good morning cait :)
07:29 pastebot "kmkale" at 59.181.126.113 pasted "git bz apply error" (5 lines) at http://paste.koha-community.org/201
07:29 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:30 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 try without -u
07:31 kmkale "previous rebase directory /home/kk/kohaclone/.git/rebase-apply still exists but mbox given."
07:32 cait git am --abort again :)
07:32 kmkale is it a file encoding type problem?
07:32 cait hm more something about the encoding lines
07:32 probably the file itself is ok
07:33 if you look at it, there are probably 2 lines for encoding at the beginning
07:33 it was like that last time I had the problem
07:33 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:34 I would look at the file next
07:34 which bug is that?
07:35 kmkale 1633
07:35 cait hm first patch?
07:35 wahanui first patch is in
07:36 cait ah
07:36 the last
07:36 right?
07:36 http://bugs.koha-community.org[…]hment.cgi?id=6983
07:36 look at it on bugzilla
07:36 I would delete one of those encoding lines
07:36 pastebot "kmkale" at 59.181.126.113 pasted "content type problem?" (4 lines) at http://paste.koha-community.org/202
07:37 cait I think it has one Content-Type: too many
07:37 kmkale its got the pasted lines extra over and above other patches attached to the bug
07:37 cait is it the patch I showed you the link ti?
07:37 kmkale is it ok if I edit the /tmp/... file directly and delete the lines?
07:38 yes
07:39 cait I think so
07:39 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:39 cait I thinkm so :)
07:39 should be ok
07:40 if it makes it apply
07:40 kmkale oki. Trying that
07:42 ok. That did it.
07:42 Now to test
07:42 cait :)
07:42 kmkale then the daunting task to recreate the changed patches and push :(
07:42 * kmkale is scared of git
07:47 cait it will be all ok
07:47 git is nice
07:47 what do you want to do? what do yo mean by recreating?
07:53 kmkale there are 5 patches attached to that bug
07:53 the first & last ones did not apply. So I had to change by doing a 3 way merge.
07:54 Now I will have to re-generate all the 5 patches and attach to the bug right?
07:55 http://wiki.koha-community.org[…]_bz_configuration tell me to do git rebase 1stcommitid^ --interactive
07:56 but what is the 1stcommitid? the 1st patch or the last patch? is it the topmost commitid shown by git log?
07:56 cait the first
07:56 wahanui i guess the first is the command i ran
07:56 cait you applied all of them now, right?
07:56 git log shows you all patches?
07:57 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:58 Git log shows all 5
07:58 cait ok
07:58 cool
07:58 and do you need to add your sign-off?
07:58 kmkale I had to make changes to 1st and last of the 5
07:58 by doing a 3 way merge
07:59 cait using git am?
07:59 that should be ok
07:59 kmkale yes
08:00 cait ok
08:00 so what do you want to do?
08:00 add your signoff?
08:02 kmkale re submit the patches with the changes
08:02 cait ok
08:03 git bz apply <bugnumber> HEAD^^^^ I think
08:03 might be one ^ more
08:03 or less
08:03 and git bz apply -e if you want to obsolete patches
08:03 from the bug
08:04 kmkale ok. Will try that after I test.
08:04 Thanks cait :)
08:04 cait you are welcome :
08:04 :)
08:04 Guillaume1 joined #koha
08:05 Guillaume1 left #koha
08:15 Oak jokeL
08:15 A suburban father is wondering what his daughter's teacher thinks of him:
08:15 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:15 "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:15 ~ Mildrad S. Fenner in NEA Journal
08:19 Callender joined #koha
08:21 rangi git bz attach (not apply) but otherwise cait is right as usual
08:21 cait oh typo
08:21 heya rangi
08:22 * kmkale is confused as usual ;)
08:23 kmkale about 1stcommitid
08:25 but here goes..do I do a "git rebase 1stcommitid^ --interactive" now?
08:25 or a "git bz apply <bugnumber> HEAD^^^^" as advised by cait?
08:25 cait why do you want to do the rebase?
08:26 kmkale I have already applied the ppatches.
08:26 had to change two of the five.
08:26 cait yes
08:26 but why rebase?
08:26 add comments?
08:26 kmkale so I need to create and attach new set of patches to obsolete the one needing change.
08:27 How do I do that? git bz attach -e ?
08:27 Oak who are you talking to cait? I only see your messages, and rangi's for the past 15 minutes.
08:27 cait kmkale?
08:27 wahanui kmkale may be psychic.
08:27 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 git bz attach -e HEAD^^^1
08:28 meh
08:28 HEAD^^^^
08:28 kmkale http://wiki.koha-community.org[…]ation#Signing_off mentions rebase
08:28 cait that's what I do, I know there are other ways
08:28 yep
08:28 that's when you want to add your signoff
08:28 and it's the first patch commitid
08:29 that you applied
08:29 scrolling down when looking at git log
08:29 kmkale ok trying git bz attach -e HEAD^^^^
08:29 Oak weird
08:29 kmkale ok cait ?
08:29 wahanui That's Ms. Cait to you! or in a very good mood today :)
08:30 cait you need the rebase when you want to add your sign-off to the pathces
08:30 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:32 cait yep
08:42 kmkale "Successfully rebased and updated refs/heads/bug_1633."
08:43 now onto "git bz attach -e  xxxx <commitid of first commit" this being the same commit id i gave to rebase correct?
08:45 cait did you all?
08:45 all 5 patches?
08:46 and yes, should be the same, but you will see in the screen if it's the right one
08:46 thd-away joined #koha
08:46 kmkale ok here goes
08:49 thd-away` joined #koha
08:50 cait now
08:50 do it again with one less ^ and without -e
08:50 thd-away` joined #koha
08:50 cait until you have them all attached
09:00 kmkale had to do them one by one but I think I have all five attached to the bug report now.
09:00 cait: could you please have a look at bug 1633 page and try to spot if I have made a mistake?
09:00 huginn 04Bug http://bugs.koha-community.org[…]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 you can only do them one by one
09:01 and it looks all ok to me :)
09:04 kmkale no
09:04 the patch with syspref file changes which I did by resolving megre markers has come out correctly
09:05 but see attachment 7153 where I edited the file in /tmp and then did a git am
09:05 huginn 03Attachment http://bugs.koha-community.org[…]=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:06 cait hm perhaps you added it back
09:06 accidently
09:07 kmkale nope. It has my comments. But the content-type lines remain
09:07 woonder how to get rid of that
09:07 cait not sure
09:09 Callender joined #koha
09:12 thd-away joined #koha
09:16 thd-awa`` joined #koha
09:29 Culiforge :~/kohaclone$ sudo ln -s /usr/share/koha/bin/koha-zebra-ctl.sh  /etc/init.d/koha-zebra-daemon
09:29 ln: creating symbolic link `/etc/init.d/koha-zebra-daemon': File exists
09:29 gary@gary-desktop:~/kohaclone$ sudo update-rc.d koha-zebra-daemon defaults
09:29 update-rc.d: /etc/init.d/koha-zebra-daemon: file does not exist
09:30 file exists, file does not exist?
09:36 kmkale Culiforge: see a ls -l of /etc/init.d/koha-zebra-daemon
09:36 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//koha-zebra-ctl.sh
09:39 kmkale $/usr/... ??
09:40 Culiforge I don't understand?
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:41 by doing a sudo ln -s /usr/share/koha/bin/koha-zebra-ctl.sh /etc/init.d/koha-zebra-daemon
09:42 then check if you can open the file by doing less /etc/init.d/koha-zebra-daemon
09:42 if its the correct file then sudo update-rc.d koha-zebra-daemon defaults again
09:43 Culiforge all right, that appears to have done it
09:44 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:45 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:46 does that look right?
09:47 no errors at least :)
09:48 kmkale no you need to see a big line telling you how zebra is running
09:48 that does not look right
09:48 Culiforge dang!
09:48 fredericd Culiforge: why do you use koha-zebra-daemon? It's deprecated. Your're supposed to use rebuild_zebra.pl 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-awa`` joined #koha
09:49 Culiforge yes
09:50 kmkale fredericd: zebraqueue is deprecated
09:50 you still need to run zebra server
09:50 Culiforge: then did you do a "/etc/init.d/koha-zebra-daemon start" ??
09:50 fredericd sorry, I've misread...
09:51 Culiforge I did
09:51 kmkale Culiforge: and did it say starting zebra server?
09:51 Culiforge I get back 'starting zebra server'
09:51 kmkale ok then sudo ps aux |grep zebra should return atleast two lines
09:51 if zebra has started.
09:52 if not check the zebra log under /var/log/koha
09:53 Culiforge I have a koha-error_log and koha-opac-error_log and a readme
09:54 afk one min brb
09:55 kmkale should have a koha-zebradaemon.err and a koha-zebradaemon-output.log
09:56 did you choose to install and use zebra during perl Makefile.PL step?
09:58 Culiforge ok, back. yes I did
10:05 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:06 cait hi fredericd :)
10:06 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:07 Do you hava data in your koha instance?
10:07 you need to be able to check Zebra search/indexing
10:07 Culiforge brand new install so I believe not
10:08 if I understand what you're asking
10:08 fredericd So, once you have finished installiong everything, you have to populated your DB and see if Zebra works
10:09 kmkale joined #koha
10:09 Culiforge kmkale was saying I'm not getting correct output from sudo ps aux |grep zebra
10:09 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:11 kmkale Culiforge: have you created a user koha?
10:12 thd-away` joined #koha
10:13 pastebot "kmkale" at 59.181.126.113 pasted "/etc/init.d/koha-zebra-daemon" (17 lines) at http://paste.koha-community.org/203
10:13 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:13 kmkale Culiforge: ^^ is how my /etc/init.d/koha-zebra-daemon file starts
10:14 thd-away` joined #koha
10:14 kmkale your user needs write access to the dirs LOGDIR, RUNDIR and LOCKDIR
10:15 Culiforge: also test if /usr/bin/zebrasrv actually exists and if its executable by all
10:15 Culiforge here is my daemon file: http://pastebin.com/ttnHbxXt
10:16 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`` joined #koha
10:19 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:20 sudo chown gary /var/log/koha
10:21 sudo chown gary /var/lock/koha
10:21 sudo chown gary /var/run/koha
10:22 Culiforge /usr/bin/zebrasrv permissions did not change...
10:23 kmkale here is how my perms look : lrwxrwxrwx   1 root     root           26 Jan 27  2009 /usr/bin/zebrasrv -> /etc/alternatives/zebrasrv
10:24 Culiforge how do I get that output? ie.. what command?
10:25 kmkale ls -l /usr/bin/zebrasrv
10:25 Culiforge ls -l /usr/bin/zebrasrv
10:25 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:26 Culiforge ls -l /etc/alternatives/zebrasrv
10:26 lrwxrwxrwx 1 root root 21 2012-01-12 06:34 /etc/alternatives/zebrasrv -> /usr/bin/zebrasrv-2.0
10:26 kmkale ls -l /usr/bin/zebrasrv-2.0
10:27 Culiforge ls -l /usr/bin/zebrasrv-2.0
10:27 -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 and /var/run/koha
10:28 and /var/lock/koha
10:28 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:30 kmkale do a sudo chown -R gary /var/log/koha
10:30 do a sudo chown -R gary /var/lock/koha
10:30 do a sudo chown -R gary /var/run/koha
10:31 as per yor daemon file the group needs to be koha
10:32 so create a group koha, add user gary to group koha and the  do sudo chown -R gary:koha /var/log/koha
10:32 sudo chown -R gary:koha /var/lock/koha
10:32 sudo chown -R gary:koha /var/run/koha
10:33 Culiforge I have gary in group koha but i'm not sure koha group exists.... how do I check
10:33 thd-away joined #koha
10:34 kmkale Culiforge: how do you know then that gary is in group koha?
10:34 groupadd koha
10:34 sudo groupadd koha
10:35 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 ok, group is there
10:36 kmkale hey don't worry we all learnt the same way :)
10:36 so run the above chown commands
10:36 thd-awa`` joined #koha
10:37 kmkale and show us the output of ls -l /var/log|grep koha
10:37 Culiforge yeah my biggest kudo is that I learned the middle button copy/paste thing... pretty proud of myself
10:37 ls -l /var/log|grep koha
10:37 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:38 and ls -l /var/run|grep koha
10:38 Culiforge ls -l /var/lock|grep koha
10:38 drwxr-xr-x 3 gary     koha 60 2012-01-13 16:43 koha
10:39 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:39 kmkale cool so try running zebra again then :)
10:40 sudo /etc/init.d/koha-zebra-daemon start
10:40 Culiforge starting zebra server
10:40 thd-away` joined #koha
10:41 kmkale ps aux |grep zebra
10:41 Culiforge ps aux |grep zebra
10:41 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:41 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:41 gary      2246  0.0  0.1   3376   804 pts/2    S+   05:41   0:00 grep --color=auto zebra
10:41 kmkale cool
10:41 Culiforge is that what we were looking for?
10:41 woot!
10:41 kmkale there u go
10:42 Culiforge so I should be good to move on to the web setup now?
10:42 kmkale yup
10:42 Culiforge sweet, thanks so much... I'll be back when I mess up something else :)
10:43 kmkale u r welcome :)
10:47 Culiforge Hey, guess what... I'm back. http://pastebin.com/JJbUGv4N
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:49 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:49 yes. did grant all
10:50 Callender joined #koha
10:50 kmkale check if you can access ur db via comandline mysql tool
10:51 using the same credentials
10:51 Culiforge mmm, denied
10:57 kmkale so thats the pproblem
10:58 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:58 thd-away joined #koha
10:59 kmkale match your gary user mysql passwoord to that in koha-conf.xml
10:59 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 and reset it in mysql to same value
11:00 Culiforge I could look back, I just hope it's not more than 20000 lines
11:00 ok, where is the xml file located..
11:01 kmkale its at /etc/koha/
11:04 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 I'm in mysql -uroot
11:05 kmkale SET PASSWORD FOR 'gary'@'localhost' = PASSWORD( '******' )
11:08 Culiforge single quotes yes, parentheses no?
11:08 kmkale replace *'s wiith your password from the xml file thats it
11:09 Culiforge ok, no output at a -> prompt
11:09 kmkale thats fine
11:10 try web installer again
11:10 Culiforge any flushing or updating? or back to web... OK
11:10 hmm, same
11:10 kmkale try mysql -ugary -p
11:11 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:13 brb
11:15 Culiforge hmmm... everything seems in order. reran the grant cmd  still won't allow access
11:21 apache is running otherwise I wouldn't get the web error msg right?
11:29 kmkale right
11:30 do you have any # or other such odd character in the password?
11:30 are u able to login wiith mysql -ugary i command line using the same password?
11:32 Culiforge just i or -i
11:32 kmkale that was a in
11:32 mysql -ugary -p <databasename>
11:32 Culiforge no
11:33 denied
11:33 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:34 Culiforge what's the drop command
11:35 kmkale drop database databasename;
11:36 Culiforge then create database databasename;
11:36 kmkale yup
11:38 Culiforge aha! figured it out... when i pasted the grant command I didn't remove the <>'s
11:38 <==== dope
11:38 kmkale heh :)
11:41 Culiforge getting unknown database error on webpage now
11:42 do I need to do the flush privileges in mysql
11:42 kmkale yes
11:43 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:46 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:48 kmkale :-D
11:48 Culiforge so the login for the koha web setup is my 'gary' and pwd?
11:48 kmkale yup
11:48 Culiforge hehe, it's like xmas morning!
11:49 so out of curiosity... without any marc info... how much space does a koha install take up?
11:50 kmkale haven't counted ;)
11:51 Culiforge rough estimate?
11:51 kmkale try urself use du -chs command on
11:52 dirs /usr/share/koha
11:52 + /var/log/koha
11:52 + /var/lock/koha
11:52 + /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 not that I know of
11:56 tried it works if you just string up the dirs with space inbetweeen
11:56 mine says 1.6gb total
11:56 Culiforge mine shows a hare over 334M but that's without any book data
11:57 roughly how much book data do you have i.e. #of records
11:57 kmkale heh and on a real server with about 1 mil books its 18gb
11:58 add /var/lib/koha to that list
11:59 and /etc/koha
12:00 thats 32g for a 1mil record koha server
12:00 Culiforge that's not bad.. has anyone worked out portability for a koha installation?
12:01 kmkale meaning?
12:01 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:03 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:04 Culiforge so I just centrally install koha and web access it from each school.. right?
12:04 kmkale yes
12:05 Culiforge no brainer.. that's the way to go... it just gets easier from here on out
12:06 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:07 cait don't use the 'root' admin from installation to play with it
12:07 it's not a real user and weird things can happen
12:07 Culiforge so gary login is essentially the root and has too many permissions
12:07 kmkale have a look at http://manual.koha-community.org/3.6/en/
12:08 cait it has no real borrowernumber - that can cause problems
12:08 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 :)
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:38 cul_away left #koha
13:39 Callender joined #koha
13:40 Guillaume1 joined #koha
14:17 kmkale joined #koha
14:18 jcamins_away kmkale: I fixed the patch.
14:18 jcamins kmkale: I didn't change the code at all, just reuploaded it.
14:26 kmkale yes I was just reading your comment
14:26 so you just changed the cubject line?
14:26 *subject
14:27 jcamins Right.
14:27 Though it took me a half hour to figure that out.
14:27 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:27 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:28 jcamins Though, it seems to me that magnuse is on the QA team.
14:28 Perhaps he can mark it Passed QA.
14:28 kmkale yes and he seems to have signed it off
14:29 jcamins: :) you took the words off my mouth / keyboard
14:29 jcamins :)
14:29 kmkale jcamins: so how's life in the big apple?
14:29 jcamins Next time I see him online, I'll nudge him.
14:30 kmkale: things are going pretty well, except our apartment purchase has hit a snag.
14:30 kmkale jcamins: that co-op thing?
14:30 jcamins Yup.
14:30 kmkale ?
14:30 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:31 kmkale so current residence is a rented one is it?
14:31 jcamins Right.
14:32 And our current landlord is terrible.
14:33 kmkale heh
14:33 no late night parties allowed?
14:33 jcamins lol
14:33 I wish.
14:33 Our downstairs neighbors scream all night every night.
14:34 kmkale :) spread the fudge around
14:34 jcamins :)
14:35 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:36 So I spent about an hour on the phone yesterday shouting at people.
14:36 Other than that, things are going very well.
14:36 How about for you?
14:36 :)
14:37 kmkale sorry was on the phone
14:37 jcamins No problem.
14:37 kmkale things are pretty bad for me right now. Great workwise bad otherwise..
14:38 jcamins Oh no!
14:38 I'm very sorry to hear that.
14:42 Housing problems for you, too?
14:43 kmkale let it be
14:44 jcamins Okay.
14:44 kmkale i did a koha install on rackspace today and one on amazon last week
14:45 must say rackspace is better in performance and price
14:45 jcamins Oh?
14:45 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:46 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 Wow.
14:47 ByWater used Rackspace, and either a server was down or the control panel was down nearly all the time.
14:48 At least, that's what it felt like to me.
14:48 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:50 kmkale yeah thats true and the cloud files stuff cant be attached as a volume
14:51 but 80gb is ok for koha n RT
14:51 most of the time that is
14:52 my amazon instances always feel like there is a cpu heavyweight running on the same server
14:52 jcamins Hm. Mostly I find myself running out of disk space.
14:52 Well, not on EC2.
14:53 But I work with very unusual collections.
14:53 If the OPACs get 1 search per day that isn't me, that's unusual.
14:53 kmkale that isent me?
14:55 gotta go dinner time bbl
14:55 jcamins Most of the collections I host are ones that I am cataloging, too.
14:55 Enjoy.
15:00 cait joined #koha
15:02 * jcamins waves to cait.
15:02 cait hi jcamins :)
15:02 and hi #koha
16:27 cait joined #koha
16:48 cait hi #koha
17:09 Callender joined #koha
17:39 Callender joined #koha
17:42 wizzyrea1 joined #koha
17:49 slef hi all... how did that Audio NP spam get onto koha.lists.katipo.co.nz?
17:50 cait hi slef
18:13 Johnindy_ joined #koha
18:17 slef updated http://wiki.koha-community.org[…]ki_RFC#Proposal_2 - I'm really worried that we may get koha-community.org banned from search engines :-/
18:17 cait hm
18:17 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:20 http://www.mobicity.co.nz/nokia-n9-16gb.html   <--- now im thinking about this for my next phone
18:21 cait yep
18:21 and morning rangi :)
18:21 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 http://n9.indigoblack.de/
18:21 cait it's nice
18:21 rangi oh cool
18:21 cait he let me test type on it :)
18:21 he seems quite happy too
18:22 rangi cool
18:30 jcamins rangi: meego is better than android?
18:31 cait it's not google
18:31 jcamins cait: yeah, but isn't android open source?
18:32 Oh, looks like MeeGo is too.
18:32 rangi sorta
18:32 jcamins I thought that was the Nokia OS.
18:32 rangi nope, its linux
18:32 jcamins Nifty.
18:32 rangi i actually had meego running on my netbook for a while
18:32 jcamins A shame that Verizon will never offer that as an option.
18:34 slef meego was nokia wasn't it?
18:34 rangi the main thing i like is it comes with a real terminal
18:34 yep
18:34 its .deb based
18:34 slef as was symbian... and that was FOSS before it died too
18:35 rangi yup
18:35 so on the n9, you can open a terminal, and dpkg -i
18:35 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:36 slef IIRC in the US, the market won't provide unlocked phones at sane prices, the regulators won't intervene to protect customers.
18:38 jcamins slef: yes, that's true.
18:39 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:39 (yes, Europeans can buy unlocked phones in the US)
18:39 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:40 cait hehe
18:40 I like it because when I get one
18:40 I can ask rangi for help
18:40 rangi its pretty much debian under the hood, afaict
18:40 so in theory
18:40 i can run koha on it
18:40 lol
18:40 slef jcamins: we have UMTS too. Is Verizon that C... one?
18:41 jcamins: we also have some tri- and quad-band phones but not so many since 3G I think.
18:41 Soupermanito joined #koha
18:42 jcamins CDMA.
18:42 That's the one.
18:42 Incredibly backwards.
18:43 *backward
18:44 slef Will it die?
18:45 jcamins Doesn't look like it.
18:45 There are some GSM providers, but the US doesn't really have the infrastructure for GSM yet.
18:46 If you're in a rural area, Verizon is really the only game in town.
18:47 (and my mother-in-law lives in a rural area)
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 will bbl
19:31 cait :(
19:31 chrisdothall joined #koha
19:31 cait hi chrisdothall
19:32 chrisdothall cait: morning :)
19:32 cait :)
19:39 slef rangi: it was painless filing a lost property report in Auckland!
19:58 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:58 huginn jcamins_baking_compulsively: The operation succeeded.
20:08 cait jcamins_baking_compulsively: doesn't it have 3 sign-offs now?
20:08 and I think magnuse is 'only' a bug wrangler?
21:13 druthb joined #koha
21:13 druthb o/
21:14 cait Hi :)
21:35 magnus_zzz cait is right, i'm only a bug wrangler, not a qa'er, and i sgined off
21:35 druthb hi, magnus_zzz!  :)
21:35 cait now talking in your sleep? :)
21:35 magnus_zzz yup
21:35 jcamins_baking_compulsively magnus_zzz: alas.
21:35 magnus_zzz or not far from it at least
21:36 * jcamins_baking_compulsively will nudge sekjal more then.
21:36 magnus_zzz good plan :-)
21:37 cait jcamins_baking_compulsively: perhaps marcel?
21:37 magnus_away or Jonathan Druart
21:37 http://wiki.koha-community.org/wiki/Roles_for_3.8
21:41 g'night #koha
21:42 cait good night magnus_away
22:43 rangi right, claim lodged with insurance company
22:44 chrisdothall rangi: what happened?
22:45 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:46 b
22:46 rangi because it had been turned off when i called it 30 mins
22:46 chrisdothall backlog*, what was it*
22:46 rangi ahh
22:46 my cellphone
22:46 chrisdothall and my typing is failing... sorry all
22:46 rangi so had to go to vodafone and block the account
22:47 then race home and revoke access to all apps on the phone, and change passwords just in case
22:47 and switched on prey to missing mode
22:47 chrisdothall rangi: ouch badluck,
22:47 rangi so i should get notified if someone connects it to the network
22:47 but yeah, filed lost property report, and lodged an insurance claim
22:48 annoying more than anything
22:48 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:16 stuartyeates joined #koha

← Previous day | Today | Next day → | Search | Index

koha1