Time |
Nick |
Message |
01:01 |
|
sleary joined #evergreen |
01:26 |
|
sandbergja joined #evergreen |
01:26 |
sandbergja |
rickyrnt: this is a good place! What errors are you seeing in apache and postgres? |
01:28 |
sandbergja |
also, this channel tends to be much more active during business hours in the Eastern US, so you may wish to check the logs at irc.evergreen-ils.org at that time for further responses |
01:29 |
sandbergja |
If you have a longer question and don't mind joining an email list, the general email list could be good too: https://evergreen-ils.org/communicate/mailing-lists/ |
01:33 |
rickyrnt |
sandbergja: I'll look into that, thanks! For now, I literally just got postgres working (the issue was I misread the documentation and did not set it up before running the config script). For apache, after following the install instructions and trying to restart the service, I get the following errors- DocumentRoot [/openils/var/web] does not |
01:33 |
rickyrnt |
exist, Syntax error on line 630 of /etc/apache2/eg_vhost.conf, and RewriteMap: file for map openurl not found:/openils/bin/openurl_map.pl |
02:11 |
|
berick joined #evergreen |
02:13 |
|
book` joined #evergreen |
07:18 |
|
kworstell-isl joined #evergreen |
07:29 |
|
BDorsey joined #evergreen |
08:32 |
|
mmorgan joined #evergreen |
08:43 |
|
redavis joined #evergreen |
08:56 |
|
mantis joined #evergreen |
09:01 |
|
Dyrcona joined #evergreen |
09:04 |
|
dguarrac joined #evergreen |
09:10 |
|
stephengwills joined #evergreen |
09:28 |
|
jvwoolf joined #evergreen |
09:38 |
stephengwills |
is there an place to store a state registry id for an org_unit? i.e. 4426 = Thompson Free Library in Dover-Foxcroft. |
09:42 |
csharp_ |
stephengwills: we added custom columns to actor.org_unit to accommodate Georgia-assigned IDs |
09:44 |
stephengwills |
ah. ok. thanks. |
09:44 |
csharp_ |
correction: Federally assigned IDs (FSCS) |
09:47 |
csharp_ |
stephengwills: specifically, we have a column named fscskey (text) for the library system FSCS ID and fscs_seq (text) for the branch numbers (as "seq" implies, it's just 1, 2, 3... for each system) |
09:48 |
csharp_ |
not sure why I chose text for both - seq could have been integer, but they work fine :-) |
10:04 |
|
smayo joined #evergreen |
10:50 |
|
jvwoolf joined #evergreen |
11:02 |
|
sandbergja joined #evergreen |
11:10 |
Bmagic |
csharp_: just curious, when you added a column to a production table, did you need to mirror that change in the IDL? |
11:11 |
Bmagic |
(I've been bitten by having an IDL that is out of sync with reality, and Evergreen does some pretty weird stuff, poisoning the data in the tables) |
11:14 |
berick |
adding to the IDL is required to use the column within the application. it should not be requried for data integrity, though.. that's concerning. |
11:37 |
jeff |
I suspect that Bmagic's woes had more to do with array positions being off, resulting in IDL objects being passed between a client that considered position 7 to be one thing, while the server side IDL was treating that position as some other field, with an unfortunately semi-compatible datatype. |
11:37 |
jeff |
But I'd be curious to hear more detail, or may try and break things later. |
11:38 |
jeff |
(and to be clear, I mean two different copies of the IDL in use, not an IDL that defined fewer fields than were present in the backing tables) |
11:39 |
jeff |
Bmagic: does that mesh with your memory/understanding of the situation at the time? |
11:58 |
csharp_ |
Bmagic: yes, I updated the fieldmapper as well |
11:59 |
csharp_ |
Bmagic: haven't seen trouble |
12:00 |
|
jihpringle joined #evergreen |
12:02 |
csharp_ |
our commit: https://git.evergreen-ils.org/?p=evergreen/pines.git;a=commit;h=f607a48ef5197a6e0f4d45e223fd356166886073 - actually terranm was the author of that - I was misremembering |
12:04 |
|
jvwoolf joined #evergreen |
12:14 |
sandbergja |
@later tell rickyrnt: If you do `ls /openils/bin/openurl_map.pl`, is there a file there? If not, I would double check that you have done the `make` and `make install` steps in the installation steps. |
12:14 |
pinesol |
sandbergja: The operation succeeded. |
12:17 |
|
jihpringle joined #evergreen |
12:38 |
|
sandbergja joined #evergreen |
12:48 |
Bmagic |
jeff: IIRC it was action.circulation, and the old IDL was left in place between upgrades. That table received some column adds/subtracts, but the IDL was still setup for the previous version of the table. The result in production were circulations with bad due dates, and other weird stuff |
12:49 |
Bmagic |
updating rows that weren't suppose to be updated, because of ID numbers getting mixed, was another thing IIRC |
12:49 |
berick |
Bmagic: gotcha. that's a little different than just having a column in a table that the IDL does not know about |
12:50 |
Bmagic |
That was a fun week. Forever in my memory |
12:50 |
berick |
that sounds like field positions were shuffled in the IDL which can cause problems |
12:51 |
Bmagic |
you should try it sometime, the results are fun when on acid |
12:52 |
berick |
haha |
12:53 |
|
jvwoolf joined #evergreen |
12:55 |
|
mmorgan1 joined #evergreen |
13:33 |
Dyrcona |
Bmagic: Forgetting to run autogen.sh can do that. Clients will, I think, get an old copy of the IDL and the back end sees the new one. |
13:33 |
Bmagic |
annoying to say the least |
13:35 |
|
smayo joined #evergreen |
13:45 |
|
kworstell-isl joined #evergreen |
13:55 |
|
kworstell_isl joined #evergreen |
13:56 |
|
kworstell_isl_ joined #evergreen |
13:57 |
pinesol |
News from commits: LP#2034617: improve how AngularJS handles logout BroadcastChannel messages <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=471c404990a74fdb195afadf6be9d93a79577659> |
13:58 |
jeffdavis |
I committed something! |
13:58 |
sandbergja |
jeffdavis++ |
13:58 |
jvwoolf |
jeffdavis++ |
13:58 |
Dyrcona |
jeffdavis++ |
13:59 |
sleary |
jeffdavis++ |
14:08 |
|
kworstell-isl joined #evergreen |
14:19 |
mmorgan |
jeffdavis++ |
14:26 |
jeff |
jeffdavis++ |
14:27 |
pinesol |
News from commits: LP2057432 Add shadows to dropdowns and active tabs <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=1f891060c05f737b43c2f39fea4f78260d29aeb2> |
14:34 |
|
kworstell_isl joined #evergreen |
14:35 |
|
kworstell_isl_ joined #evergreen |
15:06 |
|
jvwoolf joined #evergreen |
15:11 |
|
rickyrnt joined #evergreen |
15:28 |
|
rickyrnt joined #evergreen |
15:29 |
|
mantis left #evergreen |
15:30 |
rickyrnt |
@later tell sandbergja: I spent so much time looking at the wrong make file that I didn't try the other one. Thanks, it worked! Now I'm working through other errors but it's likely because everything's been done all out of order, i'll get back if i need more help. Thanks! |
15:30 |
pinesol |
rickyrnt: The operation succeeded. |
15:34 |
Dyrcona |
rickyrnt: If you need any help right now, feel free to ask. |
15:34 |
rickyrnt |
thanks! just rebooting the server currently |
15:48 |
Dyrcona |
Just two hours on a test system running "standard" cron jobs with OpenSRF loglevel set to 4, and the syslog files is 12GB. |
15:49 |
Dyrcona |
I hope the 500GB that I gave the image today is enough. :) |
15:51 |
|
rickyrnt joined #evergreen |
15:51 |
jeffdavis |
When I need to do that kind of debugging I pretty much always manually modify how the relevant Perl modules log things, rather than messing with log levels. |
15:52 |
Dyrcona |
We have autorenew events that just fail/get stuck/don't get created (sometimes). I'm trying to recreate the production utility server environment with maximum logging to see if I can make it happen here. |
15:52 |
Dyrcona |
We haven't even gotten to the autorenew events, yet. They come up after midnight. |
15:54 |
Dyrcona |
jeffdavis: I do suspect that you are right, though. I'll bet that whatever is happening won't get logged at all. |
15:54 |
rickyrnt |
alright, so running `autogen.sh` gives `routerprivate.localhost/open-ils.cstore IS NOT CONNECTED TO THE NETWORK!!!`, and restarting apache2 gives `could not bind to address [::]:80`. Does anyone know what I may be doing wrong here? |
15:55 |
Dyrcona |
`routerprivate.localhost/open-ils.cstore IS NOT CONNECTED TO THE NETWORK!!!` That means that services are not running. Have you run `osrf_control -l --start-all` ? |
15:56 |
Dyrcona |
restarting apache2 gives `could not bind to address [::]:80 Usually means that something else is using port 80, or that possibly IPv6 is not configured and Apache wants to use IPv6. |
15:57 |
rickyrnt |
Have you run `osrf_control -l --start-all` ? I have, and it does start a few services, though notable not open-ils.cstore |
15:57 |
rickyrnt |
I don't think it's in the the opensrf.xml |
15:58 |
Dyrcona |
OK! You need to reconfigure opensrf.xml again. |
15:58 |
Dyrcona |
Evergreen installs a second opensrf.xml.example and you need to configure that one after installing Evergreen. |
15:58 |
rickyrnt |
Got it! Was the script supposed to do that or should I be doing it manually? |
15:58 |
Dyrcona |
It's easy to miss in the instructions. You also need to do opensrf_core.xml again. |
15:59 |
Dyrcona |
It needs to be done manually. |
15:59 |
rickyrnt |
Ok, I'll get on that. Thanks! |
16:00 |
|
jihpringle joined #evergreen |
16:00 |
Dyrcona |
For opensrf.xml, you can do the copy again ` cp -b opensrf.xml.example opensrf.xml` and then eg_db_config can be used to update it. opensrf_core.xml needs to have the passwords edited manually, if I remember correctly. |
16:07 |
|
jvwoolf joined #evergreen |
16:09 |
Dyrcona |
@blame database defaults |
16:09 |
pinesol |
Dyrcona: database defaults was monkeying around too much on the prod servers! |
16:12 |
|
rickyrnt joined #evergreen |
16:18 |
rickyrnt |
Alright, configuration is fixed, and now I'm working on getting apache to play nice with nginx. Instructions say to modify the 'sample apache configuration file opensrf.conf' for RemoteIP, where can I find this file? |
16:20 |
|
kworstell-isl joined #evergreen |
16:22 |
Dyrcona |
rickyrnt: There are some things missing in the instructions for a proxy, I think. You need to edit /etc/apache2/ports.conf for the ports that Apache will listen on. These need to match the ports from osrf-ws-http-proxy that nginx will send requests to. |
16:23 |
Dyrcona |
You also need to set those ports in the <VirtualHost ...> lines in /etc/apache2/sites-available/eg.conf. |
16:25 |
Dyrcona |
To enable RemoteIP, uncomment the lines beginning with '#RemoteIPInternalProxy` (there are 2 of these) and ' |
16:25 |
|
kworstell_isl joined #evergreen |
16:25 |
Dyrcona |
'#RemoteIPHeader' in /etc/apache2/eg_vhost.conf. |
16:29 |
rickyrnt |
It's working! Thanks so much for all your help! |
16:30 |
Dyrcona |
You're most welcome! Happy hacking! |
16:31 |
rickyrnt |
Most certainly |
16:33 |
|
jvwoolf left #evergreen |
16:36 |
Dyrcona |
Hm. I'm trying to cherry-pick code for Lp 2040514 into a branch based on main, and it looks like RemoteAccount.pm has been edited in the mean time? |
16:36 |
pinesol |
Launchpad bug 2040514 in Evergreen "EDI SFTP doesn't work" [High,In progress] https://launchpad.net/bugs/2040514 - Assigned to Jason Stephenson (jstephenson) |
16:38 |
* Dyrcona |
tries picking from csharp_'s branch. |
16:39 |
Dyrcona |
hmm. That worked, so now to figure out if I'm missing something. |
16:41 |
Dyrcona |
History looks no different. |
16:43 |
* Dyrcona |
musta done something wrong. |
16:45 |
|
stephengwills left #evergreen |
16:56 |
* Dyrcona |
calls it a day. |
17:21 |
|
mmorgan left #evergreen |
21:08 |
|
sandbergja joined #evergreen |