Evergreen ILS Website

IRC log for #evergreen, 2024-03-13

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat

All times shown according to the server's local time.

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=ev​ergreen/pines.git;a=commit;h=f607a4​8ef5197a6e0f4d45e223fd356166886073 - 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=E​vergreen.git;a=commitdiff;h=471c40​4990a74fdb195afadf6be9d93a79577659>
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=E​vergreen.git;a=commitdiff;h=1f8910​60c05f737b43c2f39fea4f78260d29aeb2>
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 `router@private.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 `router@private.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

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat