2011-05-08T05:37:07 *** granitize has joined #evergreen 2011-05-08T06:06:20 *** granitize has quit IRC 2011-05-08T08:38:37 *** bjwebb has quit IRC 2011-05-08T08:40:37 *** granitize has joined #evergreen 2011-05-08T08:53:52 *** granitize has left #evergreen 2011-05-08T09:03:52 *** granitize has joined #evergreen 2011-05-08T09:19:55 *** granitize has quit IRC 2011-05-08T10:22:34 @eightball 2011-05-08T10:22:34 csharp: The outlook is poor. 2011-05-08T11:20:06 *** granitize has joined #evergreen 2011-05-08T12:27:20 *** natschil has joined #evergreen 2011-05-08T13:09:37 *** granitize has quit IRC 2011-05-08T13:10:25 *** granitize has joined #evergreen 2011-05-08T13:15:34 *** granitize has quit IRC 2011-05-08T13:26:04 *** natschil has quit IRC 2011-05-08T13:26:25 *** natschil has joined #evergreen 2011-05-08T13:27:12 *** natschil has joined #evergreen 2011-05-08T13:28:23 *** natschil has quit IRC 2011-05-08T13:29:01 *** natschil has joined #evergreen 2011-05-08T13:29:42 *** natschil has joined #evergreen 2011-05-08T13:36:22 *** natschil has quit IRC 2011-05-08T13:37:02 *** natschil has joined #evergreen 2011-05-08T13:38:35 *** natschil has joined #evergreen 2011-05-08T13:40:36 *** natschil has joined #evergreen 2011-05-08T13:41:55 *** natschil has joined #evergreen 2011-05-08T13:47:56 *** granitize has joined #evergreen 2011-05-08T13:53:14 sylvar++ #that's cool putting on those blocks in the wiki. 2011-05-08T14:21:34 *** dbs has joined #evergreen 2011-05-08T14:22:15 moodaepo: I'm supposed to be able to log onto lupin as denials, right? 2011-05-08T14:23:17 I guess for now I'll post the OpenSRF 2.0.0 final tarball / md5sum to legacy.evergreen-ils.org 2011-05-08T14:24:41 dbs: I should be able to hook you up 2011-05-08T14:24:56 http://legacy.evergreen-ils.org/~denials/opensrf-2.0.0.tar.gz and http://legacy.evergreen-ils.org/~denials/opensrf-2.0.0.tar.gz.md5 2011-05-08T14:25:23 phasefx: ah, that would be great. I'm at the airport atm 2011-05-08T14:25:39 dbs: denials 2011-05-08T14:28:58 Many thanks, phasefx 2011-05-08T14:30:51 * dbs remembers IP addresses not working in the staff client, once upon a time 2011-05-08T14:33:48 *** natschil has quit IRC 2011-05-08T14:35:10 Oh, and I'm not in the sudoers file and not in the www-data group, so I can't copy the files into /var/www/open-ils.org/downloads anyway 2011-05-08T14:35:56 People with the power can grab them from the links I posted earlier, I'm just going to post a message to the -dev list to announce that they're there and go for a walk 2011-05-08T14:36:04 *** dbs has quit IRC 2011-05-08T14:37:41 *** natschil has joined #evergreen 2011-05-08T14:38:02 *** natschil has joined #evergreen 2011-05-08T14:38:45 *** natschil has quit IRC 2011-05-08T14:38:55 @later tell dbs you were in sudoers, but I think maybe a bum entry above yours may have broken it 2011-05-08T14:38:55 phasefx: The operation succeeded. 2011-05-08T14:39:20 *** natschil has joined #evergreen 2011-05-08T14:39:20 phasefx: Oops, I actually *just* added denials to the sudoers 2011-05-08T14:39:36 ah :) I removed the dbs entry, left denials 2011-05-08T14:40:36 bshum: I'll leave file copying to you if you're so inclined, munching on a calzone :D 2011-05-08T14:40:39 I'll start updating the website pages and wiki instructions. 2011-05-08T14:40:52 phasefx: And I'll also do that. 2011-05-08T14:41:07 bshum++ dbs++ 2011-05-08T14:41:42 *** natschil has quit IRC 2011-05-08T14:42:38 *** natschil has joined #evergreen 2011-05-08T14:43:26 I'm going to flip the OpenSRF downloads page so that the 2.0 appears before the 1.6 version now (like how it is on the Evergreen downloads page) 2011-05-08T14:43:29 *** natschil has quit IRC 2011-05-08T14:43:33 And change the color to green for stable release 2011-05-08T14:44:00 *** natschil has joined #evergreen 2011-05-08T14:45:58 *** natschil has quit IRC 2011-05-08T14:46:19 *** natschil has joined #evergreen 2011-05-08T15:09:17 *** natschil has quit IRC 2011-05-08T15:09:53 *** natschil has joined #evergreen 2011-05-08T15:11:15 *** natschil has quit IRC 2011-05-08T15:11:45 *** natschil has joined #evergreen 2011-05-08T15:13:51 *** natschil has quit IRC 2011-05-08T15:15:03 *** natschil has joined #evergreen 2011-05-08T15:54:49 *** natschil has quit IRC 2011-05-08T15:58:40 *** natschil has joined #evergreen 2011-05-08T15:59:47 *** natschil has joined #evergreen 2011-05-08T16:01:28 *** natschil has joined #evergreen 2011-05-08T16:03:36 *** natschil has joined #evergreen 2011-05-08T16:04:55 *** natschil has joined #evergreen 2011-05-08T16:06:12 *** natschil has joined #evergreen 2011-05-08T16:08:11 *** natschil has quit IRC 2011-05-08T16:08:32 *** natschil has joined #evergreen 2011-05-08T16:09:11 *** natschil has quit IRC 2011-05-08T16:12:49 *** natschil has joined #evergreen 2011-05-08T16:15:10 *** natschil has quit IRC 2011-05-08T16:16:09 *** natschil has joined #evergreen 2011-05-08T16:38:57 *** granitize has left #evergreen 2011-05-08T17:20:57 *** granitize1 has joined #evergreen 2011-05-08T17:51:29 *** bjwebb has joined #evergreen 2011-05-08T17:51:29 *** bjwebb has quit IRC 2011-05-08T17:51:29 *** bjwebb has joined #evergreen 2011-05-08T18:03:43 *** granitize1 has quit IRC 2011-05-08T19:58:18 *** Dyrcona has joined #evergreen 2011-05-08T19:58:51 Not that I expect anyone to be around, but I just did an update and when I search I get the following in the open-ils.search.std_err.log: 2011-05-08T19:58:54 DBD::Pg::st execute failed: ERROR: function array_accum(integer) does not exist 2011-05-08T19:58:54 LINE 1: SELECT array_accum(distinct id) FROM ac... 2011-05-08T19:58:54 ^ 2011-05-08T20:01:00 Dyrcona: try \df array_accum in psql, see what schema it's in (if it exists) 2011-05-08T20:02:02 doesn't exist. 2011-05-08T20:02:12 0 rows 2011-05-08T20:02:14 fun 2011-05-08T20:04:05 it gets created in 002.functions.aggregate.sql 2011-05-08T20:04:20 yeah. i see that. 2011-05-08T20:04:54 I wonder what happened, because I didn't get any errors when I loaded the schema, and we log the output. 2011-05-08T20:05:13 i'll try just creating that and seeing what happens. 2011-05-08T20:05:16 multiple databases? 2011-05-08T20:06:17 yes. 2011-05-08T20:06:44 i load the schema in one, then create the other two using the first as a template. 2011-05-08T20:07:06 * phasefx has no experience with such 2011-05-08T20:07:20 searching works now. 2011-05-08T20:07:36 i'll have to check the logs again and see if anything else is missing. 2011-05-08T20:08:39 it usually works. 2011-05-08T20:08:47 dunno what happened here. 2011-05-08T20:10:11 i checked the other functions from 002.functions.aggregate.sql and they're all there. 2011-05-08T20:10:30 "Curouser and curiouser," said Alic. 2011-05-08T20:10:37 ^Alice 2011-05-08T20:12:39 Something to investigate tomorrow. The logs look good on my last couple of searches. 2011-05-08T20:13:42 Dyrcona: I suspect public vs evergreen schema, and search path troubles ... yes, let's look tomorrow 2011-05-08T20:16:15 well, if it helps, it exists in the "template" database, but not the other two. 2011-05-08T20:16:26 Dyrcona: including in the evergreen schema? 2011-05-08T20:16:47 as in, \df evergreen.array_accum 2011-05-08T20:16:59 Dyrcona: Did you remove the target databases before recreating them via templating? 2011-05-08T20:17:20 yes. 2011-05-08T20:17:28 pg said I had to. 2011-05-08T20:17:32 ok 2011-05-08T20:17:34 wouldn't make them otherwise. 2011-05-08T20:17:39 *** granitize has joined #evergreen 2011-05-08T20:17:52 array_accum looks like the only thing missing. 2011-05-08T20:18:02 eeevil: For note, we don't even use "evergreen" as the DB username anymore, just to avoid some of those headaches. 2011-05-08T20:18:34 tsbere: right, however, search_path may not propagate as a setting from a template 2011-05-08T20:19:14 meaning, in the base, it's in evergreen, which is in the search_path, and therefore found. in the others, it's there and in the schema, but used unqualifed and there's no evergreen in the search path 2011-05-08T20:19:18 so it's /not/ found 2011-05-08T20:19:21 or, that's a theory 2011-05-08T20:19:34 eeevil++ 2011-05-08T20:19:49 that's what happened. I've got two array_accum in those databases. 2011-05-08T20:19:57 1 in evergreen and 1 in public 2011-05-08T20:20:37 Dyrcona: right, so after using an existing one as a template you'll just need to set the search path using the function in (IIRC) 000.functions.general.sql 2011-05-08T20:20:51 * eeevil out ... glad that was simple-ish ;) 2011-05-08T20:21:00 yep. thanks 2011-05-08T20:31:39 stupid me.... deleted the patches that I used to update our config files on the demo server, so now I have to recreate them on the development server. 2011-05-08T20:33:52 oh, tsbere: I discovered that I should merge sipdemo after sip_pay_fee. the latter stomps on the accounts in the former.... 2011-05-08T20:36:24 *** bjwebb has quit IRC 2011-05-08T20:51:42 *** Dyrcona has quit IRC 2011-05-08T21:06:25 *** granitize has quit IRC 2011-05-08T23:47:57 *** drdata_esi_ has joined #evergreen 2011-05-08T23:50:38 *** drdata_esi has quit IRC 2011-05-08T23:50:51 *** drdata_esi_ is now known as drdata_esi