| 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/clarisselou/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_Illustrated_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/wiki/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.php?theme=2&music=6&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 |
