2010-11-25T01:22:34 *** agJohn has joined #evergreen 2010-11-25T05:40:49 *** mrpeters-isl has quit IRC 2010-11-25T07:58:18 *** granitize has joined #evergreen 2010-11-25T08:20:19 *** dbs has quit IRC 2010-11-25T08:34:52 *** alxp has joined #evergreen 2010-11-25T08:37:14 Good mornin… Building a Library Appliance on a Mac Mini… Drupal, Fedora and Evergreen. :-) 2010-11-25T08:37:29 Can Evergreen run with MySQL? 2010-11-25T08:37:45 granitize: nice 2010-11-25T08:38:04 granitize: I think it uses a lot of hierarchical tables which mysql doesn't do so I wouldn't expect it to 2010-11-25T08:38:25 and I don't think any real development effort has been put to anything like that, but of course I could be wrong 2010-11-25T09:17:44 *** dbs has joined #evergreen 2010-11-25T09:21:18 *** dbs has quit IRC 2010-11-25T09:24:35 *** dbs has joined #evergreen 2010-11-25T09:24:35 *** dbs has joined #evergreen 2010-11-25T09:54:44 no chance of using mysql 2010-11-25T09:55:11 between inherited tables, triggers and other psql-isms. 2010-11-25T10:14:00 believe drupal supports psql though 2010-11-25T10:16:11 fedora lists psql as supported too 2010-11-25T10:16:33 so prob could do solely post 2010-11-25T10:35:51 granitize: so - you're going to be installing Evergreen server on OS X? 2010-11-25T10:38:11 dbs: heh… That's Gervais' issue. But I guess that's the current secret direction… Any idea's other than "good luck" 2010-11-25T10:38:43 eby: yes postgres 2010-11-25T10:39:50 granitize: Cool. Would love to have patches to Makefile.install, configure.ac, and various Makefile.am's to make installing on OS X work for OpenSRF and Evergreen! 2010-11-25T10:40:54 Drupal core supports PostgreSQL (although for a while support in Drupal 7 was looking dicey), but modules are free to tie themselves tightly to MySQL, so... beware 2010-11-25T10:41:17 Maybe we'll just use virtual box headless and make it LOOK like MacOSX 2010-11-25T10:41:53 someone expecting osx interface 2010-11-25T10:43:02 eby: no… That's be a bit bigger bite than we're willing to take... 2010-11-25T10:45:43 granitize: build an entire web interface in Cappucino for that OS X look'n'feel? :) http://cappuccino.org/ 2010-11-25T11:50:26 dbs: That's be great. Thanks for offering. ;-) 2010-11-25T11:53:29 One of the libraries I was working with tried to do an install on OS X w/o success. The fellow who was heading up that effort was a savvy administrator; I don't know how much experience he had w/ programming, but he eventually went w/ a VBox install (w/ Ubuntu as the guest OS that EV actually ran on). But, I don't think they were entirely committed to OS X--that just happened to be the box... 2010-11-25T11:53:31 ...they had available for use for a demo system. 2010-11-25T12:02:40 agjohn: Do you remember who that was? Would they be willing to share their frustration? 2010-11-25T12:18:20 I do remember it well. I'm not sure if he'd be willing to share or not, but I can ask. You can contact me through alphagconsulting.com and I'll see if he's got any info that would be of use. I'm starting to wonder if he ever actually tried to do the install on OS X itself. I'll find out for you. 2010-11-25T13:11:44 *** parsr has joined #evergreen 2010-11-25T13:15:50 upgrade to 1614 from 1612 (on dev environment) --> make: *** No rule to make target `ubuntu-lucid'. Stop. Ok -- so looks like I have to use "ubuntu-karmic" for .. 2010-11-25T13:27:25 *** parsr has quit IRC 2010-11-25T14:40:19 should I be concerned about dozens of "ap_get_client_block(): returned error, exiting POST reader" messages in our gateway logs? 2010-11-25T14:42:03 that's sort of a vague question maybe. it's an osrf gateway error related to our added content whatsit, but I dunno if that error would cause problems for anything besides the added content stuff. 2010-11-25T14:55:30 ap_get ? is that like apt_get ? 2010-11-25T14:56:46 no, it's a low level apache routine 2010-11-25T14:57:29 gateway/apachetools.c:37 in the opensrf source 2010-11-25T14:59:19 interestingly the conditions that produce that error msg in apachetools.c were reported as a major security vulnerability in apache back in march 2010-11-25T14:59:46 (assuming I am reading the C correctly, which is not necessarily the case) 2010-11-25T15:03:41 non-local pg server -> starting all services for debian* … but none start. 2010-11-25T15:06:06 granitize: can you elaborate? I'm not quite sure what you're trying to do... 2010-11-25T15:08:41 i.e. pg doesn't start on the db server? EG doesn't start locally? 2010-11-25T15:12:02 jeffdavis: pg starts and I can connect with other tools. 2010-11-25T15:12:36 what command are you using to start the EG services? 2010-11-25T15:12:54 :) /openils/bin/osrf_ctl.sh -c /openils/conf/opensrf_core.xml -a start_all 2010-11-25T15:13:13 ok so you're not incorrectly using the -l flag which was my first guess :) 2010-11-25T15:13:14 All services start if I use -l 2010-11-25T15:13:25 *** dbs has quit IRC 2010-11-25T15:13:31 but of course nothing works as I'm using a non-local db. 2010-11-25T15:14:07 so the usual steps are to go through this http://open-ils.org/dokuwiki/doku.php?id=troubleshooting:checking_for_errors 2010-11-25T15:14:32 Updated host and passwd in opensrf.xml, offline-config.pl and live-db-setup.pl 2010-11-25T15:14:48 right… started those this AM and got side tracked 2010-11-25T15:15:06 *** alxp has quit IRC 2010-11-25T15:15:16 there's also a perl script Open-ILS/src/support-scripts/settings-tester.pl 2010-11-25T15:19:00 Thanks 2010-11-25T15:31:23 jeffdavis: no errors in settings-tester 2010-11-25T15:31:45 still going thru trblsht doc 2010-11-25T15:46:27 perl still not starting 2010-11-25T15:46:57 any error msgs in the logs? 2010-11-25T15:47:11 Error: router@private.localhost/opensrf.settings IS NOT CONNECTED TO THE NETWORK 2010-11-25T15:48:07 lots and lots… 2010-11-25T15:49:29 Top router socket is active: 3 2010-11-25T15:49:43 socket_wait returned error code -1 2010-11-25T15:50:19 *** mitsukai has joined #evergreen 2010-11-25T15:50:28 hi all 2010-11-25T15:50:50 just a coupla questions. interested in using evergreen for a ngo i am working with 2010-11-25T15:51:04 is evergreen available in spanish? 2010-11-25T15:51:13 i couldnt find anything about it on the main website 2010-11-25T15:51:30 does it need postgresql or is mysql ok? 2010-11-25T15:51:56 mitsukai: postgres 2010-11-25T15:52:02 ok thanks 2010-11-25T15:52:28 do u know if its possible to run instances of mysql and postgresql on one machine? 2010-11-25T15:52:31 you can create your own lang file if there isn't a spanish alraedy. 2010-11-25T15:53:05 mitsukai: you can definitely run both mysql and postgres side by side 2010-11-25T15:53:08 ok but i dont actually speak spanish, i am just working for an organisation in guatemala. so i cant translate, and they dont have time or incvlination to do it either 2010-11-25T15:53:13 needs to be built in 2010-11-25T15:53:27 thanks jeffdavis 2010-11-25T15:54:17 also, does evergreen have to run on a linux server? cant i just install the necessary environment on a mac/win machine? 2010-11-25T15:56:22 it seems it would b a lot easier to have an installer that did everything on wither mac/win for most users. organisations like the one i am working with have no tech expertise to setup a postgres enviro etc by themselves. this is not available, right? 2010-11-25T15:57:21 g2g pick up children! Cheers 2010-11-25T15:59:58 mitsukai: I think there is an incomplete spanish translation 2010-11-25T16:00:38 And Linux is a requirement AFAIK, I don't know of anyone running it in production on Windows or OS X 2010-11-25T16:00:49 but you might get more authoritative answers on the open-ils-general mailing list 2010-11-25T16:01:04 a lot of the knowledgeable folks who are normally in this channel are on holiday 2010-11-25T16:02:16 ah ok that pretty much kills it then. the org doesnt have a machine spare to be used as a linux server. and it would b deployed to lots of unconnected little libraries in tiny communities here... so if it can't b runn on a win machine, basically its a no-go. the spanish is important too, but a partial trans is better than nothing 2010-11-25T16:02:41 most of the libraries we were thinking to use it in have no net access 2010-11-25T16:02:47 ok so step back a sec 2010-11-25T16:02:54 only the server itself needs to run on linux 2010-11-25T16:02:57 *** jamesrf has joined #evergreen 2010-11-25T16:03:08 the client interface will work fine on windows, os x, or linyux 2010-11-25T16:03:43 if you can scare up a linux machine it would fit your needs ... but yeah if that's not possible, probably no go. :( 2010-11-25T16:03:49 sure. but if theres no net access, the clients cant connect to a central server. each library would have its own "instance" of evergreen server & client on one machine. 2010-11-25T16:04:06 ah missed that 2010-11-25T16:04:35 *** kbeswick_ has quit IRC 2010-11-25T16:05:04 so if that machine has to b linux, it wont work. because they org uses windows, and is not gonna make all its barely-educated "employee" librarians learn linux 2010-11-25T16:05:10 * jeffdavis nods 2010-11-25T16:05:16 bummer 2010-11-25T16:05:38 not having any luck at all finding an open-source (ie. free) solution for this org :( 2010-11-25T16:06:03 *** granitize has quit IRC 2010-11-25T16:06:14 evergreen looked really good but their documentation on the website is pretty thin, so i needed to ask more q's. thanks heaps for your help! 2010-11-25T16:06:25 good luck! 2010-11-25T16:06:46 i guess my next step is to see if i can make it work on a win machine... hmmm 2010-11-25T16:08:20 is the holiday just today? will people be here tomorrow too? do u think anyone might know how i can make this work on a win machine server-side? 2010-11-25T16:08:43 my experience with small isolated libraries here in BC is that the staff don't have the tech knowledge to maintain a standalone EG server 2010-11-25T16:09:32 no. and def not here. i can do it for now but i'm onlky here a little while longer. so i really need to be setting it up so that its a no-brainer for the locals to maintain after i'm gone 2010-11-25T16:11:14 honestly not sure about the holiday, I'm Canadian ;) 2010-11-25T16:11:53 ok anyways, thanks again heaps for your help. will pop back in tomorrow and see if anyone has any ideas about hacking the server side of EG to work on a win machine. me neither on the hols, i'm aussie. :D 2010-11-25T16:12:11 cheers 2010-11-25T16:13:45 um sorry dumb question. how do i log out of this chat? 2010-11-25T16:13:55 /quit :) 2010-11-25T16:14:13 cheers mate. have a great day! 2010-11-25T16:14:17 *** mitsukai has quit IRC 2010-11-25T16:34:21 *** kbeswick has joined #evergreen 2010-11-25T18:04:05 *** Granitize has joined #evergreen 2010-11-25T18:28:07 *** pmplett has joined #evergreen 2010-11-25T19:42:32 *** Granitize has left #evergreen 2010-11-25T20:02:25 *** Granitize has joined #evergreen 2010-11-25T20:03:07 Anyone still poking around? 2010-11-25T20:04:02 non-local db is connecting fine… no errors.. I can go directly to a record but searching "hangs" 2010-11-25T20:04:15 Memory issue? 2010-11-25T20:12:40 granitize pasted "untitled" at http://paste.lisp.org/display/117033 2010-11-25T20:30:59 *** Granitize has quit IRC 2010-11-25T20:38:32 *** jamesrf has quit IRC 2010-11-25T20:57:24 *** dbs has joined #evergreen 2010-11-25T21:26:25 *** pmplett has quit IRC 2010-11-25T22:17:12 @later tell granitize Does you non-local database have the various prereqs installed, like MARC::Record, JSON::XS, and MARC::File::XML? 2010-11-25T22:17:12 dbs: The operation succeeded.