--- Log opened Thu Sep 16 00:00:41 2021 03:59 -!- NotLarry [~NotLarry@066-190-177-036.res.spectrum.com] has quit [Ping timeout: 268 seconds] 03:59 -!- NotLarry [~NotLarry@066-190-177-036.res.spectrum.com] has joined #se2600 04:04 -!- NotLarry [~NotLarry@066-190-177-036.res.spectrum.com] has quit [Ping timeout: 260 seconds] 04:09 -!- NotLarry [~NotLarry@066-190-177-036.res.spectrum.com] has joined #se2600 05:47 <@Dolemite> mr0ning, be0tches and h0ez! 06:28 * aestetix hugs Dolemite 07:44 <@Mirage_> Dolemite: Clark wound up not coming out here last week. 07:44 <@Dolemite> well that sucks 07:44 <@Mirage_> Yeah, something about it being too hot 07:44 <@Dolemite> heh, I can relate to that 07:50 < aestetix> Dolemite: did you ever find out why your friend got COVID? 07:54 <@Mirage_> aestetix: Don't you mean why he didn't get the shot? 07:54 <@Dolemite> Nope. He's been radio silent. His wife posted some pictures the other day and he was in a few... he looks like hell, so I'd say he's still in recovery 07:56 < aestetix> https://store.steampowered.com/app/1149620/Gas_Station_Simulator/ 07:56 < PigBot> Save 10% on Gas Station Simulator on Steam (at store.steampowered.com) https://tinyurl.com/yfjm96ya 07:56 <@Dolemite> Do I have to use my Kroger Fuel Points? 07:56 < aestetix> I wonder if there is an expansion pack to enable doing heroin in the bathroom 07:57 < brimstone> is that a 10% savings if you pay with cash? 07:58 <@Mirage_> Ya know, now that you say that...not having a gas station down here that is tied in with the Kroger points other than going to theirs is annoying. That was certainly a perk in Nashville. 07:59 <@Dolemite> Yeah, we end up going to Costco, mostly, because it's always cheaper and only a half mile past Kroger... but that's just a sign of how little we go anywhere lately 07:59 <@Dolemite> But hey, less than 30 days away from heading South to Miami to get on a cruise ship 08:00 < aestetix> https://store.steampowered.com/app/1190000/Car_Mechanic_Simulator_2021/ this is something I might actually get 08:00 < PigBot> Car Mechanic Simulator 2021 on Steam (at store.steampowered.com) https://tinyurl.com/ydr8hore 08:00 < aestetix> because I do not know much about cars 08:02 <@Dolemite> That's what YouTube is for 08:24 <@Mirage_> Or friends who work for food/beer. =) 08:25 <@Dolemite> Yeah, but you were too damn fast so I never learned anything other than how much beer and steak you liked :) 08:25 <@Dolemite> I can hit pause and back up a YouTube video 08:49 -!- brimstone [~brimstone@sprinkle.cloud] has quit [Remote host closed the connection] 08:49 -!- brimstone [~brimstone@sprinkle.cloud] has joined #se2600 08:51 < Evilpig> Dolemite: did you see that they started using this dashboard again? https://districtinformation.tnedu.gov/covid-information/search/-1/780?selectedDate=09-16-2021 08:51 < PigBot> School Opening Dashboard (at districtinformation.tnedu.gov) https://tinyurl.com/yz7auajk 08:51 <@Dolemite> yeah, the news mentioned it earlier 08:52 <@Dolemite> when it came online everybody was laughing at how easily disproven the Knox County numbers were 08:53 <@Dolemite> Ok, I think the wrong person won this season of Master Chef. The right one won Hell's Kitchen. 08:57 < Evilpig> I was chuckling at the numbers between davidson/shelby counties vs williamson county 08:58 < Evilpig> because davidson and shelby are WAY bigger and the numbers are on par. the difference being davidson and shelby have mask mandates and williamson made national news for their school board brawl 09:25 <@Dolemite> Gotta say, Star Trek Lower Decks is consistently pretty good 09:25 <@Dolemite> In a sophomoric humor kind of way 09:28 < Evilpig> dick and fart jokes are always funny 09:29 <@Dolemite> They pulled in a TNG villian reference at the end of this week's 09:29 <@Dolemite> A rather obscure one that only appeared in a single episode 09:46 < aestetix> is star treck lower decks a new star treck series? 09:46 <@Dolemite> Yeah, it's an animated 30 minute episode series 09:46 <@Dolemite> Season 2 is currently airing 10:13 < Evilpig> my 10a meeting was canceled so i'm about to kick that off 10:20 <@Dolemite> Now I'm watching today's Titans 10:22 < Evilpig> did I just hear katey sagal? 10:30 <@Dolemite> I gotta say, the HBOMax versions of DC series are like the anti-CW. I'm still pissed that they canceled Swamp Thing before it even aired, though. 10:30 <@Dolemite> The few episodes that they did make were very true to the original series 10:37 < Evilpig> Dolemite: that villian was a very memorable one though. lol 10:38 < Evilpig> wasn't that the one that killed tasha yar? 10:38 <@Dolemite> yep 10:38 <@Dolemite> episode was called Skin of Evil 11:25 <@Mirage_> Yeah, not sure what to think about this. Got text regarding that covid study with a link to be able to view my results. In setting up the account/login for that site w/ the lab they asked PI questions which were NOT part of the original study signup, etc...such as "what state did you live in during 1986-87", "what city was located in", did you ever live on any of these 11:26 <@Mirage_> streets ". 11:26 <@Dolemite> They're checking against your credit record, obviously 11:27 <@Mirage_> With my name and a last 4 of SS. I'm not sure I like that too much... 11:48 <@Mirage_> Evilpig: you play with ansible, right? Does it REQUIRE WinRM or can it connect by another method? 11:50 < Evilpig> yes for windows hosts 11:50 < Evilpig> for linux it uses ssh 11:58 <@Mirage_> Evilpig: I knew Puppet Bolt required it, but I was thinking that ansible supported some other method as well for some reason. 12:18 < Evilpig> it needs some way to connect to powershell and that's the gold standard 13:35 <@Mirage_> Got my initial results back from that study. Apparently I'm one of the good statistics and haven't had covid as I didn't have any natural antibodies found in the test. 13:36 <@Dagmar> Evlipig: It's pretty clear that the Dept. of Education give no f**ks about what Lee thinks, because they are publishing more information than the TN Dept. of Health 13:40 <@Mirage_> My IgG number is significantly lower than my wife's (44 vs 256), and hers is significantly lower than some of her coworkers (700-1500). Thinking about how the immune system works, that completely makes sense though as I have very minimal contact w/ anyone and therefore very little exposure to the virus. My wife is exposed more at work, even with the PPE, but then comes home and gets little/no exposure 13:40 <@Mirage_> outside of work. Her workers with the higher numbers either have kids or have had the virus themselves. More exposure == higher antibodies that would be expected in the blood due to your body ramping up production in order to fight off the virus. Any number greater than 0.8 is an indication that you have had a positive reation to the vaccine and your immune system has created the proper antibodies. 13:42 < Evilpig> Mirage_: neat 13:43 <@Mirage_> For anyone who didn't learn it or doesn't remember, the IgG is the normal antibody that your body has to identify whatever it was created to fight. When they identify the invader they contact your immune system kicks into gear to produce the cells that actually fight the infection (IgM or IgA) as well as more identifier cells (IgG). 13:45 < Evilpig> Mirage_: I learned a new ansible feature this morning for setting environment variables on tasks. https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15 13:45 < PigBot> Install the Microsoft ODBC driver for SQL Server (Linux) - ODBC Driver for SQL Server | Microsoft Docs (at docs.microsoft.com) https://tinyurl.com/yc4jejvt 13:45 <@Mirage_> They test for the IgG antibodies vs the others because the IgG is the one that hangs around while the others are really only produced when fighting an infection. 13:45 < Evilpig> someone requested this odbc package, which we have mirrored already. but it needs that variable set. 13:46 < Evilpig> - name: Install odbc 13:46 < Evilpig> package: 13:46 < Evilpig> name: msodbcsql17 13:46 < Evilpig> state: present 13:46 < Evilpig> lock_timeout: 180 # wait up to 3 minutes for a lock ansible/ansible#57189 13:46 < Evilpig> environment: 13:46 < Evilpig> ACCEPT_EULA: 'Y' 13:46 < Evilpig> this worked. 13:46 <@Mirage_> interestingh 14:15 <@Dagmar> Just wait until they start asking about Windows Authentication. hehh 14:30 < Evilpig> we're already having to look at authentication with AD for kerberos and nfsv4 15:39 <@Mirage_> not that hard 15:43 <@eryc> it kinda is 15:43 <@eryc> with odbc i mean 15:44 <@eryc> Evilpig: i didnt have to use that lock_timeout 15:44 <@eryc> do you have concurrent yum operations happening? 15:46 <@Dagmar> Evilpig: no, I mean as a means to authenticating to the MSSQL server that's the reason they want that ODBC library 15:46 <@Dagmar> There is not, as far as I've been able to determine, any way to actually do that 15:47 <@eryc> i gave up 15:47 <@eryc> the problem is the layers of abstraction 15:47 <@eryc> i think it might be possible 15:48 <@Dagmar> There's no code for it that I could see in the ODBC driver 15:49 <@eryc> their might be something in msodbc? 15:49 <@eryc> using env vars or something? 15:49 <@Dagmar> Not in the one he's installing that I was ever able to find 15:49 <@eryc> i didnt think the MS code was open 15:49 <@Mirage_> I had it working on a RHEL 6 host using the php+odbc that was joined to the domain and kerberized. My problem was when they needed me to join to a second MSSQL instance in a different domain. Could do it for one domain, but no more. 15:50 <@eryc> there's pymssql that can do AD auth 15:50 <@eryc> if you need it 15:50 <@eryc> but most ORM stuff will need odbc (to work with tsql) 15:51 <@eryc> Mirage_: would like to see that config :P 15:51 <@Dagmar> I found _no_ way to do it, and I even asked about it in here. 15:51 <@Dagmar> I strongly suspect you misunderstand the Windows Authentication mechanism I was talking about 15:52 <@eryc> is that the same as ntlm? 15:52 <@Dagmar> nope 15:52 <@Mirage_> Dagmar: When you mentioned it before I said I'd had it working, but that you could only do it for one domain. 15:53 <@Dagmar> So you had the _client_ machine performing the authenticaiton challenge of a domain controller 15:55 <@Mirage_> The customer actually had the unix extensions enabled in their domain and the machines was joined to the domain via winbind. 15:55 <@Dagmar> Yeah this isn't that 15:55 <@Dagmar> Binding machines into the domain is a doddle 15:55 <@Dagmar> This is using a separate relationship 15:56 <@Mirage_> So it's not that a rhel 6 host, joined to the domain, was able to join to MSSL using an AD account vs a SQL account?! 15:56 <@Dagmar> Basically, on a _Windows_ machine you wind up storing a separate set of credentials in the windows keystore 15:56 <@Dagmar> You make the connection to the MSSQL server, and then it connects back to the host and validates your connection 15:57 <@Dagmar> Subsequently you don't wind up saying _anything_ about the account to be used when you're setting up your DBI connection on teh code side 15:58 <@Mirage_> Per the documentation the php odbc integration REQUIRED the host to be joined to the domain and would ONLY be able to authenticate to targets on the native domain as you didn't specify the domain for the resource account used to connect to MSSQL, it simply too the one specified in winbind 15:58 <@Dagmar> On a LInux machine running say, perl's DBI.pm, despite teh fact that it uses that same v17 ODBC driver, there's no way to do this type of authentication challenge 15:59 <@eryc> because microsoft is more secure than linux 16:00 <@Dagmar> This is the reason the documentation for MatrixCare (who are the people who designed their stuff around this) say flat out that they don't support Linux 16:02 <@eryc> heh, i mean you just create a local sql account and it works fine 16:02 <@Dagmar> Well, yes, in a _sane_ world that would eb the thing to do 16:03 <@Dagmar> To be clear, I'm absolutely talking about a wholly separate domain being involved, one that ONLY exists for the purposes of this shit 16:04 <@Dagmar> The docs for MatrixCare have one setting up the credenial in Windows with what amounts to a bogus domaine like MX/username 16:04 <@Dagmar> Because apparently just using fuckin' SSL is hard somehow 16:08 <@Dagmar> 16:46 < Evilpig> eryc: that timeout goes back to a bug when they set the timeout that release to 0 and we've just kept it in there ever since 16:47 < Evilpig> Dagmar: that one I can't do jack about. for security they want us to get on nfsv4 with kerberos and the giant clusterfuck that is going to be is painful. not looking forward to it 16:56 <@eryc> thankfully i'm getting rid of mssql.. i mean i kind of like it but i hate odbc 17:40 <@eryc> i tried to implement an ntlm server in python but it didn't work out 17:40 <@eryc> i was just going to validate the username since the first request is supposed to have that 17:40 <@eryc> i couldn't get shit 17:43 <@eryc> anyway mtls 22:40 <@Mirage_> https://www.youtube.com/watch?v=i5DNPW1UvEs 22:40 < PigBot> Last Week in the Republican Party - Sept 14, 2021 - YouTube (at www.youtube.com) https://tinyurl.com/yz687272 22:40 <@Mirage_> lol...BLM was founded by witchcraft founded lesbians! where do these ppl come up with this shit?!\ 22:41 <@Mirage_> er, witchcraft practicing. shouldn't type while laughing --- Log closed Fri Sep 17 00:00:42 2021