Evergreen ILS Website

IRC log for #evergreen, 2021-04-29

| 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
00:01 sandbergja joined #evergreen
00:13 sandbergja joined #evergreen
00:51 sandbergja joined #evergreen
06:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
07:17 rjackson_isl_hom joined #evergreen
08:04 Dyrcona joined #evergreen
08:09 collum joined #evergreen
08:22 rfrasur joined #evergreen
08:25 mantis joined #evergreen
08:34 mmorgan joined #evergreen
08:46 rjackson_isl_hom joined #evergreen
09:10 alynn26 joined #evergreen
09:20 jvwoolf1 joined #evergreen
09:26 dbwells joined #evergreen
09:38 Dyrcona I don't type so much as I typo. :)
10:28 csharp @quote add <Dyrcona> I don't type so much as I typo. :)
10:28 pinesol csharp: The operation succeeded.  Quote #215 added.
10:29 Dyrcona :)
10:29 Dyrcona automation++
10:31 Dyrcona I made  a commit this morning that I cherry-picked to several other branches, then I decided to amend that commit and add a second. I made the changes in one of the branches, then wrote a bash function to fix the others.
10:36 csharp Bmagic: I want to you have this trick mastered by the next in-person EG event: https://twitter.com/clarissel​ou/status/1387523627277553670
10:36 Dyrcona Whee! Thirty-three branches.....
10:37 csharp 33 branches all cried out at once, and were silenced
10:39 Dyrcona That's not how many I modified, just how many i have in my local repo. That's after some cleanup yesterday.
10:39 Dyrcona Also, that trick is incredible.
10:45 csharp yes, and my reaction would be the same as Harrison Ford's :-)
10:47 Dyrcona :)
11:17 rjackson_isl_hom joined #evergreen
11:28 Dyrcona Wish that I knew of an easy way to tell if a table or view is used by another view.
12:01 sandbergja joined #evergreen
12:08 rhamby Dyrcona search for it as a part of the view_definition in information_schema.views
12:10 rhamby something like select table_schema, table_name from information_schema.views where view_definition ~* 'money.billing';
12:16 jihpringle joined #evergreen
12:21 Dyrcona rhamby: I'll give that one a shot.
12:24 Dyrcona rhamby++
12:24 Dyrcona That's easier than what I was thinking to do.
12:25 rhamby yeah,  I can't remember what I was doing but I remember being very happy when I found out the view definitions were stored in plain text
12:27 Dyrcona I previoulsy had used pg_get_viewdef to dump some views for editing, so I was just going to make a hash table with viewname => viewdef for the 392 views in the database using pg_class and pg_namespace.
12:35 jihpringle joined #evergreen
12:44 Bmagic csharp++ # classic. I saw that video when it came out. Hilarious to think that he pulled one of the oldest tricks in the book on Harrison Ford. I LOLed
12:45 Bmagic The old card in the fruit trick. I read that trick in a book of magic tricks (from the library) when I was 10 years old. And the book that I got from the library was probably from the 1940's, lol
12:56 csharp Bmagic: my working theory of how it's done is currently devilry
12:56 Bmagic We magicians like to keep it that way :)
12:57 csharp Bmagic++
12:57 Bmagic I'm reading this book https://www.google.com/books/edition/The_Ill​ustrated_History_of_Magic/gsvLtLFKFvgC?hl=en
12:59 Bmagic and I was informed of something I'd never heard of: "The automated Chess Player" - Invented in the 1700's and befuddled the public for almost 100 years! After reading about it, I thought, wow, that would fool people today! I was thinking of creating one (the original perished in a fire in the 1800's)
13:00 Bmagic It was called "The Turk"
13:00 Bmagic https://www.history.com/news/how-a-phony-​18th-century-chess-robot-fooled-the-world
13:00 csharp oh - I remember reading about that when I was a kid
13:01 Bmagic https://en.wikipedia.org/wi​ki/Maelzel%27s_Chess_Player
13:02 Bmagic Edgar Allan Poe reflected on it in some of his works
13:05 Bmagic I think it would be amazing to bring that trick back and take it to shows. I would be that it would kick butt even today in 2021
13:06 Bmagic be/bet
13:14 jvwoolf joined #evergreen
13:47 rjackson_isl_hom joined #evergreen
14:10 rfrasur bmagic++
14:58 mmorgan I'm unable to load records through vandelay on some local test/training systems, the only error I can find is this:
14:58 mmorgan [2021-04-29 11:50:04] open-ils.vandelay [ERR :33994:Vandelay.pm:272:16197113152449916] unable to read MARC file /tmp/f6dc92e68315c37f04c9882c887239d8.mrc
14:59 mmorgan The file loads on 3.6.2 with perl 5.24.1, but not on 3.6.1 with perl 5.28.1 or 3.6.3 with perl 5.28.1.
15:00 mmorgan I'm wondering if this is bug 1923076
15:00 pinesol Launchpad bug 1923076 in Evergreen 3.6 "Incorrect typing when encoding some values as JSON" [Medium,Confirmed] https://launchpad.net/bugs/1923076
15:01 mmorgan I also have a master concerto server with perl 5.26.1, and the file will NOT load there either.
15:01 jihpringle joined #evergreen
15:13 Dyrcona mmorgan: Nope.
15:14 Dyrcona mmorgan: I suggest making a directory called /openils/var/tmp, and then change the /tmp directory in opensrf.xml to use that new directory. Make sure that opensrf owns the directory.
15:16 Dyrcona It's likely more to do with the O/S release than Perl and Evergreen versions.
15:17 mmorgan Dyrcona: What's the purpose of making the new tmp directory?
15:18 Dyrcona mmorgan: So Apache can actually read the files. It can't read /tmp when running as opensrf on Ubuntu 18.04+ and likely Debian Buster or newer.
15:18 Dyrcona @blame systemd
15:18 pinesol Dyrcona: systemd HAXORED Dyrcona's SERVERZ!!!!
15:18 Dyrcona pinesol: You sure got that right!
15:18 pinesol Dyrcona: http://wonder-tonic.com/geocitiesizer/content.ph​p?theme=2&amp;music=6&amp;url=evergreen-ils.org
15:18 Dyrcona We should probably document that in the installation instructions.
15:19 Dyrcona Or, change opensrf.xml and create the tmp directory during installation.
15:22 mmorgan Hmm, ok. Will give that a try.
15:23 Dyrcona Oh, and it might not be apache that can't read the files. I suppose it's the opensrf services that can't read them. # For the pedants out there.
15:26 Dyrcona mmorgan: It's the <importer> element in opensrf.xml that needs changing, btw.
15:26 mmorgan Dyrcona: Ok, thanks!
15:28 Dyrcona I think a more generic version of that bash function that I mentioned earlier would be useful.
15:29 Dyrcona Or, maybe a script...
15:31 Dyrcona Part of it might be easier in Python... :)
15:32 JBoyer Recent(-ish) versions of systemd create "private" versions of /tmp for services to prevent other users from snooping around in there. So apache is saving your records in "/tmp" but they end up in /tmp/systemd-private-(noise)/ where opensrf isn't allowed to look.
15:34 Dyrcona Yeah, what JBoyer said.... :)
15:34 Dyrcona @blame systemd
15:34 pinesol Dyrcona: systemd WILL PERISH UNDER MAXIMUM DELETION! DELETE. DELETE. DELETE!
15:34 Dyrcona I wish... :)
15:34 JBoyer mmorgan, I don't know if you run apache as opensrf (in the Eg instructions) or www-data (system default) but that might have a bearing on what user/group you have to give access to that directory.
15:34 JBoyer Well, s/might/will/
15:35 Dyrcona Just it all as root in a chroot....
15:36 Dyrcona A root in a chroot, a cat to a .dat, and a chown to pwn, all your /tmp are belong to us.
15:37 * mmorgan is doing whatever berick's ansible script does :)
15:38 Dyrcona @blame ansible
15:38 pinesol Dyrcona: I come to bury ansible, not to praise them.
15:38 Dyrcona ;)
15:38 Dyrcona automation-- :)
15:40 Dyrcona Sorry, it's almost the end of the day and my brain (inhibition) is shutting down.
15:41 mantis left #evergreen
15:42 Dyrcona @karma automation
15:42 pinesol Dyrcona: Karma for "automation" has been increased 1 time and decreased 1 time for a total karma of 0.
15:51 Dyrcona @karma systemd
15:51 pinesol Dyrcona: Karma for "systemd" has been increased 0 times and decreased 1 time for a total karma of -1.
15:51 Dyrcona systemd--
15:52 mmorgan Dyrcona++
15:52 mmorgan That did the trick, thanks!
15:53 Dyrcona YW!
15:55 * mmorgan is not a sysadmin, but sometimes plays one at work ;-)
15:55 Dyrcona Heh!
15:55 Dyrcona mmorgan++
15:59 Dyrcona rhamby: Thanks again for the suggestion of using information_schema.views earlier. I was able to get a list of 44 views and 4 tables from extend_reporter that are not being used and can be dropped.
15:59 Dyrcona rhamby++
15:59 rhamby woot!
16:05 * Dyrcona calls it a day. Have a good rest of the day/evening, everyone!
16:17 rjackson_isl_hom joined #evergreen
16:25 jvwoolf joined #evergreen
16:54 jamesrf joined #evergreen
17:13 mmorgan left #evergreen
18:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:08 rjackson_isl_hom joined #evergreen
18:13 rjackson_isl_hom joined #evergreen
18:48 JBoyer systemd++
18:48 JBoyer systemd++
18:48 JBoyer Muahaha

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