Evergreen ILS Website

IRC log for #evergreen, 2019-01-22

| 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
04:31 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
06:51 agoben joined #evergreen
06:55 JBoyer joined #evergreen
07:07 rjackson_isl joined #evergreen
08:48 terran joined #evergreen
08:53 Dyrcona joined #evergreen
09:13 tlittle joined #evergreen
09:25 collum joined #evergreen
09:31 yboston joined #evergreen
09:55 bos20k joined #evergreen
09:56 jvwoolf joined #evergreen
09:57 mmorgan joined #evergreen
10:01 Christineb joined #evergreen
10:03 mmorgan1 joined #evergreen
10:18 nfBurton joined #evergreen
10:43 remingtron berick or others: do you have instructions on the minimum steps to test a new angular branch?
10:44 remingtron I'm testing bug 1749475 and don't want to do the full install process
10:44 berick remingtron: in the eg2 dir:  npm run test
10:44 pinesol Launchpad bug 1749475 in Evergreen "wishlist: Improved email and printing from the OPAC" [Wishlist,New] https://launchpad.net/bugs/1749475
10:45 remingtron sorry, I meant "install" the code into it's production location, not "run the tests"
10:45 berick ah
10:45 berick before 'make install', inside the eg2 directory:  ng build --prod
10:47 remingtron cool. Does configure or make do anything with the eg2 bits?
10:47 * berick notes some day we'll get that step added to the Makefile so 'make' will do it for us -- there's an open bug on that
10:47 berick :)
10:47 berick it does not
10:47 remingtron cool, thanks for the info
10:47 khuckins_ joined #evergreen
10:59 nfburton joined #evergreen
11:07 Dyrcona berick: I've been doing just ng build. Am I wrong in assuming that all --prod does is add minification?
11:07 Dyrcona berick++ # For https://wiki.evergreen-ils.org/doku.p​hp?id=dev:angular_dev_best_practices
11:14 berick Dyrcona: it does quite a bit more than that.
11:14 berick it strips out a lot of unnecessary code
11:15 berick compiles the files into version-stamped chunks (for cache busting)
11:15 Dyrcona OK. I'll look it up.
11:16 berick compiles the templates into JS, so there's one less layer of stuff the browser has to parse through
11:41 rsulejmani joined #evergreen
11:49 rsulejmani Hi everyone last night I was installing evergreen on my system, Before about a few months ago this worked but now all of a suddenI get errors, I am installing evergreen with berick's ansible.
11:50 pastebot "rsulejmani" at 64.57.241.14 pasted "autogen.sh error" (9 lines) at http://paste.evergreen-ils.org/14382
11:50 rsulejmani I have tried to install it with ubuntu serve and ubuntu desktop. the error that I'm getting http://paste.evergreen-ils.org/14382
11:51 aabbee joined #evergreen
11:52 nfburton joined #evergreen
11:53 Dyrcona rsulejmani: A bit of advice, always use 64 bit Ubuntu Server O/S.
11:54 rsulejmani I am, its hosted by OVH and its 64 bit with 4gb ram
11:54 Dyrcona Next, what does osrf_control -l --diagnostic output? You can paste it to paste.evergreen-ils.org, just like your error message.
11:54 berick rsulejmani: i also bet an error occurred earlier in the process that you might have missed, one that gives a better idea of the problem
11:55 Dyrcona There are issues with 32 bit server and some package that can be worked around, so that's why I recommend 64 bit.
11:55 Dyrcona They may be dropping 32 bit in the future. (I hope.) :)
11:56 rsulejmani this is what diagnostic gave me: http://paste.evergreen-ils.org/14383
11:57 csharp looks like it's not connecting to the DB
11:57 Dyrcona So, the services that talk to the database are not starting. That means there's something wrong with the db configuration or postgres is not running.
12:00 rsulejmani Let me try to start postgres and well go from there
12:02 Dyrcona Well, `pgrep -f postgres` can tell you if it is running or not. If it is running, you'll get a list of numbers. If it isn't, you get nothing.
12:03 berick also: systemctl status postgresql
12:03 rsulejmani postgres is running, but when I retried to do autogen.sh the same problem occured
12:04 Dyrcona Right. The services didn't start that talk to the database.
12:04 Dyrcona Do this `osrf_control -l --stop-all`
12:05 rsulejmani Dyrcona: done
12:06 Dyrcona Here's where I get a little lost because I don't know what username or password the ansible installer uses for the database.
12:07 Dyrcona I'd recommend trying to connect to postgres using psql as the evergreen user, something like `psql -U evergreen -h localhost` then typing the correct password.
12:07 berick evergreen / evergreen -- and it should be set in the opensrf.xml files to match
12:07 rsulejmani http://paste.evergreen-ils.org/14384
12:07 rsulejmani this is the settings.yml file from berick's git
12:09 Dyrcona rsulejmani: So, as berick pointed out the password is evergreen. See if you can connect to postgres with psql as I mentioned before.
12:12 rsulejmani It wouldn't let me login as evergreen but I logined as root
12:13 Dyrcona What did the message say when you tried to login as evergreen?
12:15 rsulejmani Password for user evergreen:  psql: FATAL:  Peer authentication failed for user "evergreen"
12:17 Dyrcona Did you type exactly what I put between backticks?
12:17 rsulejmani Yes
12:18 rsulejmani currently I have just reinstalled by VPS and I will be trying to install evergreen all over again.
12:19 rsulejmani berick: If I am going to be installing evergreen 3.2 with Ansible should I use the regular github branch or the 3.0 one
12:19 Dyrcona You usually only get that message when not specifying the host via -h, IIRC.
12:20 berick rsulejmani: use the regular ubuntu-16.04 branch for Evergreen 3.2
12:20 pinesol [evergreen|Cesar Velez] LP#1727345 - fix bibsource when importing or overlaying - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=014b62e>
12:21 rsulejmani berick: ok
12:21 rsulejmani I just did the psql with -h host and it returned that the database evergreen does not exist
12:22 berick rsulejmani: also, FWIW, I always install with -e use_pg_96=true.  it should work either way, but I never install 9.5 so it gets less testing (though I think bshum uses 9.5)
12:22 rsulejmani berick: ok will do the same thanks
12:22 Dyrcona I use Pg 9.5 but don't use the ansible installer.
12:23 Dyrcona rsulejmani: It sounds like the database creation step failed. I can help you with that manually if it fails the second time. I'm sure berick and others can help, too. ;)
12:24 rsulejmani Evergreen 3.2 Ansible installation is in progress, I paste any errors that I get
12:25 sandbergja joined #evergreen
12:26 csharp upgrades--
12:26 * csharp has a case of the Go-Live Tuesdays
12:27 mmorgan1 @dessert csharp
12:27 * pinesol grabs some Red Velvet Cake for csharp
12:27 csharp mmorgan++
12:28 csharp I actually have some red velvet cake here as it happens :-)
12:28 berick @coffee csharp
12:28 * pinesol brews and pours a cup of Ethiopia Sidamo Guji, and sends it sliding down the bar to csharp
12:29 csharp I actually have some Ethopia Sidamo Guji as it happens :-)
12:29 berick @swill csharp
12:29 * pinesol grabs a forty of Mickey's and sends it sliding down the bar to csharp
12:29 csharp ha! I forget about that plugin
12:29 berick hey, i've had Mickey's before
12:29 berick avoid
12:29 Dyrcona @wunder
12:29 pinesol Dyrcona: http://www.firstpersontetris.com/
12:29 csharp haha
12:29 Dyrcona @weather
12:30 pinesol Dyrcona: Methuen, MA :: Clear :: 18F/-8C | Wind Chill: 4F/-16C | Tuesday: Sunshine and a few afternoon clouds. High 27F. Winds WNW at 10 to 20 mph. Tuesday Night: Mainly cloudy. Low 14F. Winds light and variable.
12:30 Dyrcona Heat wave! :)
12:30 csharp @weather 30084
12:30 pinesol csharp: Tucker, GA :: Overcast :: 36F/2C | Wind Chill: 30F/-1C | Tuesday: Generally cloudy. High 43F. Winds ESE at 5 to 10 mph. Tuesday Night: Cloudy. Slight chance of a rain shower. Low 37F. Winds E at 10 to 15 mph.
12:31 mmorgan @weather 01923
12:31 pinesol mmorgan: Danvers, MA :: Clear :: 19F/-7C | Wind Chill: 4F/-15C | Tuesday: Sunny. High 26F. Winds WNW at 10 to 15 mph. Tuesday Night: Partly cloudy skies early will give way to cloudy skies late. Low 14F. Winds SW at 5 to 10 mph. | Updated: 38m ago
12:32 * mmorgan supposes that's better than 4F like last night.
12:35 Dyrcona Yeahp. Heat wave! :)
12:40 rsulejmani Ok I ran the installation file, but before installing I made a few adjustments to the settings.yml file, I removed the load sample data line all together, and not supposedly it created an error
12:40 khuckins joined #evergreen
12:40 rsulejmani http://paste.evergreen-ils.org/14385
12:41 Dyrcona Yeah, looks like it is failing on the build the database step.
12:43 rsulejmani So where do I go from this
12:43 Dyrcona I'll paste something you can use to build the database manually.
12:44 rsulejmani ok
12:44 Dyrcona You might want to open an issue on berick's github repo.
12:44 berick hm
12:46 berick rsulejmani: are you passing any -e overrides?
12:46 berick it's saying a var is undefined, but it's in the settings.yml file (the one you pasted earlier)
12:47 berick rsulejmani: are you following the steps to add ansible as an apt repo?
12:47 berick sudo apt-add-repository ppa:ansible/ansible
12:47 berick etc.
12:47 berick from the 16.04 readme
12:47 rsulejmani Yes
12:48 berick and this is ubuntu 16.04 64-bit server?
12:48 rsulejmani Yes
12:49 jvwoolf joined #evergreen
12:49 pastebot "Dyrcona" at 64.57.241.14 pasted "Run eg_db_config to make the database and load concerto data" (4 lines) at http://paste.evergreen-ils.org/14386
12:49 Dyrcona rsulejmani: See the above.
12:50 rsulejmani So would I paste that in the /OpenILS folder or the evergreen ansible git clone folder
12:50 Dyrcona Should be the Evergreen folder.
12:51 Dyrcona Where the Evergreen source is, not the ansible installer code.
12:51 rsulejmani Also how can I not load the sample content, would i just remove --load-all-sample from the command
12:51 Dyrcona Basically, find Open-ILS/ and go to its parent directory, note the - in the name.
12:51 Dyrcona Yes, remove --load-all-sample and your database should be empty.
12:52 rsulejmani I did that and this is the error I get http://paste.evergreen-ils.org/14387
12:53 berick i ran the ansible installer several times last week without any issue.  so strange.  the only difference I see is I don't run it as root.  I run it as my login account (using sudo)
12:53 Dyrcona rsulejmani: You're in the wrong place. What does the output of `ls` look like?
12:54 Dyrcona Running as root could be a problem.
12:54 rsulejmani the evergreen install path is /openils
12:54 berick Dyrcona: that's what I'm starting to think
12:55 berick i don't get those warning messages either about 'remote_tmp'
12:55 rsulejmani So what Dyrcona and berick are saying is that me installing the system as root is the problem
12:55 berick rsulejmani: a theory
12:55 Dyrcona rsulejmani: You want to be where the source code, not where it is installed.
12:55 rsulejmani If I as to reinstall the VPS and install the system in a user called evergreen do you think that maybe we wouldn't be having these issues
12:56 Dyrcona I'm just speculating. I install by hand or using a shell script, not ansible.
12:56 berick rsulejmani: i think it would be a useful experiment.  it doesn't matter what the login username is as long as it's not 'opensrf' (or root, of course)
12:56 berick as long as they have sudo
12:57 rsulejmani ok, in the meantime I will reinstall the VPS and restart the installation procedure from all over
12:57 Dyrcona I'm curious why installing as user opensrf is a problem with ansible? I always install as opensrf by hand.
12:58 berick Dyrcona: the ansible script creates the opensrf account.  it's not a problem, exactly, it's just not what's expected
12:58 berick so it could cause issues
12:58 Dyrcona Yeah, I guess that would cause issues. :)
12:59 * berick steps away for some food
13:16 tlittle joined #evergreen
13:34 rsulejmani I just installed Evergreen as a user not root and it worked without any errors
13:34 rsulejmani Thanks berick and Dyrcona
13:36 Dyrcona You're welcome!
13:36 berick rsulejmani: great news
13:36 berick i'll add a note to the README in the repo about that
13:36 berick thanks for trying stuff out
13:36 rsulejmani Thanks, also how would I build a custom xul staff client
13:49 berick @isitdown evergreen-ils.org
13:49 pinesol berick: Must be because I had the flu for Christmas.
13:49 berick makes sense pinesol
13:49 berick oh, now it's back
13:52 csharp our lists (bookbags) are broken, resulting in an Internal Server Error page and I'm stumped about how to trace it
13:53 csharp I can see the call in the osrfsys log, but nothing directly corresponds to that threadtrace in the error log
13:54 csharp 2019-01-22 13:53:56 brick04-head osrf_json_gw: [perl:error] [pid 31416] [client 127.0.0.1:50480] egweb: Context Loader error: Exception: OpenSRF::DomainObject::oilsMethodException 2019-01-22T13:53:56 OpenILS::WWW::EGWeb /usr/local/share/perl/5.22.​1/OpenILS/WWW/EGWeb.pm:185 <500>  No active transaction to roll back\n, referer: https://gapines.org/eg/opac/myopac/lists
13:55 rsulejmani joined #evergreen
13:56 csharp that's within the run_context_loader subroutine, and I'm not sure what that does
13:58 khuckins joined #evergreen
14:07 khuckins joined #evergreen
14:12 csharp crazy thing is, test server running the same code is working fine
14:15 Dyrcona csharp: What that code does is look up a Perl module in the directory or other config, use the module, then call it's load method. If that throws an error, it reports it. So, it looks like your context load module is failing.
14:16 Dyrcona That looks like it would be EGCatLoader.
14:17 Dyrcona The tricky part, now, is figuring what part of EGCatLoader.
14:29 jamesrf joined #evergreen
14:30 Dyrcona csharp: Look in EGCatLoader/Account.pm for the load_myopac_bookbags subroutine. It's blowing up somewhere in there. There are 5 rollback statements in that method.
14:37 pinesol [evergreen|Dan Wells] Forward-port 3.1.9 upgrade script - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=356c864>
14:37 pinesol [evergreen|Dan Wells] Forward-port 3.2.3 upgrade script - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=e0b42ed>
14:37 JBoyer cesardv++ # Z39.50 Bib source!
14:38 csharp Dyrcona: thanks - I'll take a look
14:40 rsulejmani joined #evergreen
14:41 rsulejmani berick: So I installed the evergreen server and it was successful, now I'm getting a redirected you too many times error both on the web staff client and xul staff client
14:42 rsulejmani berick: now it doesn't even let me login to the OPAC
14:44 khuckins_ joined #evergreen
14:44 terran joined #evergreen
14:48 csharp weird thing is, it fails when it's attached (to LVS) but works if it's not attached
14:48 JBoyer There are a distressing number of "return Apache2::Const::HTTP_INTERNAL_SERVER_ERROR;" in that function. It also appears to be contributing to the url=param;delimiter=issue that can lead to long text strings being assumed to be metabib ids.
14:49 JBoyer csharp, that is extremely odd. No changes to the load balancing this time? (i.e. websocketd, ldirectord -> haproxy, something else?)
14:49 csharp wondering if this is nginx-related
14:49 csharp no changes to load balancing at all
14:50 JBoyer Oh, if you're using Nginix as a load balancer that could be possible.
14:51 csharp just as a proxy for websockets on each brick
14:51 csharp still using LVS for load balancing
14:51 JBoyer Ah.
14:51 csharp but it's a layer making troubleshooting harder right now
14:51 csharp I'm remembering this kind of trouble over the last couple of upgrades
14:52 JBoyer I've had Nginix throw endless ISE's at times when I forget a step but never just for certain URLs
14:53 csharp yeah - I have no idea what this is
14:53 csharp about to compare before and after nginx and apache configs
14:59 sandbergja remingtron++ #getting everybody excited about 3.2.3 / 3.1.9
15:01 khuckins joined #evergreen
15:03 berick csharp: any errors in nginx log?
15:04 sandbergja_ joined #evergreen
15:07 Dyrcona csharp: Is that happening with a particular user? If so, how many bookbags do they have in the database?
15:10 csharp the part that's driving me crazy about this is how silent *all* the logs are about what could be happening
15:11 csharp nothing in gateway, nothing in nginx, osrfsys shows some of it, but since it's not the parent process that's eliciting the error (just cstore), I don't know what the hell is going on
15:12 csharp we learned of it from multiple feedback emails from patrons saying it was broken
15:12 csharp it happens with lists of 0, 1, and 27
15:12 csharp consistently doesn't work when the brick is attached
15:12 csharp sometimes works with it not attached
15:13 csharp so I don't know if the difference is nginx, or LVS or the hostname begin used in the URL, or just shitloads of activity vs. none
15:14 Dyrcona I've never seen it that consistent. What version of Evergreen?
15:14 csharp I need to walk away from this or I'm going to head up to QTS with a can of gasoline and a lighter
15:14 csharp 3.2.2
15:15 csharp also worth mentioning, even when it works it's super slow
15:15 JBoyer There are 2 things that should help, 1. it is "just" bookbags. That's not helping the [ep[;e tjat
15:15 csharp like 5 seconds
15:15 JBoyer are trying to use it, and 2. I assume you still have some commercial support that are already looking into it?
15:16 JBoyer I did a really bad job with words there, but I hope the point came across. :/
15:17 csharp got it :-)
15:28 JBoyer remingtron++ # just seeing the release email
15:37 jvwoolf joined #evergreen
15:47 jamesrf joined #evergreen
15:54 jamesrf joined #evergreen
16:06 sandbergja_ joined #evergreen
16:10 rsulejmani berick: There is a problem with my evergreen system it now gives me a redirect too many times issue
16:13 berick rsulejmani: certainly sounds like a configuration problem, but I don't recall ever seeing that issue, at least not happening on every interface
16:14 berick rsulejmani: one thing to confirm is that ServerName and ServerAlias values in /etc/apache2/sites-enabled/eg.conf use ports :80 and :443 (e.g. ServerName localhost:80)
16:14 berick the ansible script should do that for you.
16:15 rsulejmani berick: I'm taking a look into if cloudflare is the source of this
16:15 berick ah
16:19 rsulejmani berick: Yes Cloudflare is the reason why it wasn't working
16:19 yboston Hello folks, wondering if you could give me suggestions for how to create a SQL report that I am trying to create. My current approach is not working
16:19 yboston I need to pull all of the 6xx subject tags (600, 610, 650, 655) for a set of bibs that have a certain MARC series values (bib tags '440','490','830').
16:19 yboston By writing SQL that uses the metabib.full_rec view I can grab all the correct bib numbers,
16:20 yboston but I am having issues when pulling all of the 6xx subjects with their respective matching subfields.
16:20 yboston If I only wanted subfield $a, then I could again just use the metabib.full_rec view,
16:20 yboston but I end up with the correct 650 subfield $a for a particular bib, but if there are other subfields like $y in that same bib but for another 650 tag, then $y is incorrectly showing up with all the $a's
16:22 pastebot "yboston" at 64.57.241.14 pasted "SQL to try to pull subjects from certain bibs" (60 lines) at http://paste.evergreen-ils.org/14388
16:31 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
16:31 rsulejmani berick: I'm testing something in the source code of the evergreen system and I was wondering since I updated and saved something how do I refresh the system so the changes can show
16:32 yboston I am wondering if there is another view or table I should try to use to get the correct subject data, since I can trust the list of bibs I have. Alternatively, I can export all those bibs a use a MARC programming library to go through all the bibs and then output the 6xx fields
16:40 berick rsulejmani: depends a lot on what you are changing
16:41 berick you can always copy your files into place then restart the whole system, but there are usually much faster ways
16:46 khuckins_ joined #evergreen
16:59 jvwoolf left #evergreen
17:04 jihpringle joined #evergreen
17:17 jamesrf joined #evergreen
17:46 sandbergja yboston: good to hear from you!
17:48 sandbergja yboston: it looks like I might be answering too late, but I like getting authors, subjects, etc. from metabib.browse_entry
17:48 sandbergja specifically the value field
17:49 sandbergja yboston: I'll also email you, since I'm not sure how often you check the IRC channel these days. :-)
17:56 rsulejmani berick: Is there any way to edit the opac so that it is more bootstrap like
18:02 berick rsulejmani: short answer, no.  you could easily add bootstrap.css as a dependency, but the HTML would also have to be modified to use the bootstrap classes.
18:03 rsulejmani berick: Is there any way to edit the html
18:03 berick rsulejmani: semi-related to your question is bug 1806087
18:03 pinesol Launchpad bug 1806087 in Evergreen "Angular staff catalog continued (cira 3.2)" [Wishlist,New] https://launchpad.net/bugs/1806087
18:03 berick rsulejmani: of course, you can edit the HTML (well, the template toolkit templates) all you want.
18:09 rsulejmani berick: I know that the XUL staff client was deprecated does that also mean that support is no longer given
18:13 berick rsulejmani: we are extending support for Evergreen 3.1 for a bit longer specifically to ease the transition
18:14 berick we will not be doing XUL bug fixes in 3.2 though.  it's fully deprecated in 3.2.
18:15 berick that's not to say that someone in the community can't post a fix to a bug somewhere, but as a general policy, 3.1 is cut-off for xul development.
18:17 berick 3.1 is the cut-off, i meant to say
18:17 rsulejmani ok
18:17 * berick steps away from IRC
19:54 rsulejmani I'm having a problem with evergreen it now says whenever I try to register a patron "Event: 2001: DATABASE_UPDATE_FAILED -> The attempt to write to the DB failed
19:57 jihpringle rsulejmani: it doesn't sound like a permission error but I'd double check the permissions of the account you're using just to be sure
19:57 jihpringle I'd also recommend coming back tomorrow and asking again between 9 and 5 eastern time
19:57 rsulejmani jihpringle: Its the admin account
19:58 jeff your postgresql logs will generally have info on the underlying error in this case.
19:58 rsulejmani Ok
19:58 jeff often a missing required field or a sequence that needs updating.
21:13 sandbergja joined #evergreen
21:33 csharp I think my bookbag issue is cstore timeouts
21:36 csharp https://pastebin.com/sV6DaUhi
21:36 csharp with that, I'm going to call it a night, though :-/

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