Time Nick Message 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 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 http://wiki.koha-community.org/wiki/Setting_Up_Koha_in_Virtual_Environment_%2B_Using_That_as_a_Development_Environment#Step:_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... http://192.168.0.33/ 02:45 mtj yep... cool... 02:45 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: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 '192.168.0.33 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 maintenance.pl 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 booklibrary.chpcs.org ServerName booklibrary-intra.chpcs.org 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 'booklibrary-intra.chpcs.org' 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: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 04:12 rangi well that sux 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/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: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 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: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: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: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 http://wiki.koha-community.org/wiki/Git_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 bz-tracker.bugs.koha-community.org.bz-user U 06:54 rangi 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:55 kmkale aahh. Tried to be clever didn't I? used auth-user from the man page 06:56 rangi http://wiki.koha-community.org/wiki/Git_bz_configuration#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:10 Oak kia ora #koha 07:10 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: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: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 59.181.126.113 pasted "git bz apply error" (5 lines) at http://paste.koha-community.org/201 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 http://bugs.koha-community.org/bugzilla3/attachment.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 59.181.126.113 pasted "content type problem?" (4 lines) at http://paste.koha-community.org/202 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---Interface-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 http://wiki.koha-community.org/wiki/Git_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 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: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: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 goes..do 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 http://wiki.koha-community.org/wiki/Git_bz_configuration#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 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 kmkale ok here goes 08:51 cait now 08:51 cait do it again with one less ^ and without -e 08:51 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: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 04Bug http://bugs.koha-community.org/bugzilla3/show_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 03Attachment http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=7153&action=edit patch, Bug 1633 - [SIGNED-OFF]Â Interface revisions for the staff client, Bug-1633---SIGNED-OFFInterface-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:30 Culiforge :~/kohaclone$ sudo ln -s /usr/share/koha/bin/koha-zebra-ctl.sh /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//koha-zebra-ctl.sh 09:40 kmkale $/usr/... ?? 09:41 Culiforge I don't understand? 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/koha-zebra-ctl.sh /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 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 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 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: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: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 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 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 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 pastebot "kmkale" at 59.181.126.113 pasted "/etc/init.d/koha-zebra-daemon" (17 lines) at http://paste.koha-community.org/203 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: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: http://pastebin.com/ttnHbxXt 10:18 Culiforge zebrasrv is owned by root and read/write by owner read only by group and others 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: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: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: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 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 kmkale and show us the output of ls -l /var/log|grep 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 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 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: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: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 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 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: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 http://manual.koha-community.org/3.6/en/ 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:32 kmkale bye all 14:18 jcamins_away kmkale: I fixed the patch. 14:19 jcamins kmkale: I didn't change the code at all, just reuploaded it. 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:02 * jcamins waves to cait. 15:03 cait hi jcamins :) 15:03 cait and hi #koha 16:48 cait hi #koha 17:50 slef hi all... how did that Audio NP spam get onto koha.lists.katipo.co.nz? 17:50 cait hi slef 18:17 slef updated http://wiki.koha-community.org/wiki/Install-instructions_on_the_wiki_RFC#Proposal_2 - I'm really worried that we may get koha-community.org 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 http://www.mobicity.co.nz/nokia-n9-16gb.html <--- 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 http://n9.indigoblack.de/ 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 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: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 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: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 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 cait jcamins_baking_compulsively: perhaps marcel? 21:38 magnus_away or Jonathan Druart 21:38 magnus_away http://wiki.koha-community.org/wiki/Roles_for_3.8 21:42 magnus_away g'night #koha 21:42 cait good night magnus_away 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 :(