← 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---Interface-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-OFFInterface-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 | garygary-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