--- Log opened Fri Aug 11 00:00:23 2023
05:47 <@Dolemite> mr0ning, be0tches and h0ez!
06:34 < Evilpig> gotta take the door in the ranger apart this weekend
06:35 < Evilpig> noticed on the way to sabrina's school yesterday the speaker wasn't playing, heard a pop and then there was sound again
06:35 < Evilpig> so either i've got a loose wire to the speaker or there's a problem lurking with the head unit
06:36 < Evilpig> I figure the best thing to do is take that panel off and check the easy connections first.  
06:38 <@Dolemite> FORD.  Fix or Replace Daily.
06:39 < Evilpig> I'm almost hoping it isn't a loose wire.  https://www.crutchfield.com/p_110CAR110W/Jensen-CAR110W.html?tp=72381
06:39 < PigBot>  Jensen CAR110W Digital multimedia receiver with backup camera (does not play discs) at Crutchfield  (at www.crutchfield.com) https://tinyurl.com/24am724p
06:39 < Evilpig> be the finest '97 ranger rollin' round town.  lol
06:40 <@Dolemite> I'd put a truthful Chinese head unit in there before anything from Jensen, but that's me.
06:40 <@Dolemite> Definitely wouldn't throw $500 at a replacement head unit.  heh
06:42 < Evilpig> the radio will be worth more than the truck.  but I would like wireless android auto and xm
06:42 <@Dolemite> My ATOTO head units have wireless android auto/carplay and have optional XM modules for about half the price.
06:43 <@Dolemite> But you are right, the head unit would be the highest value part of the vehicle
06:52 <@Dolemite> Evilpig: FYI, fuck your Windows update pushing coworkers with a fuck stick.  Once again, forced update reboot yesterday.  Headset stopped working with Teams.
06:53 <@Dolemite> Everytime I mentioned it in the past they're like, 'we didn't do anything'
06:56 < Evilpig> I got nothin' there
06:57 < Evilpig> there is one thing this jensen has that I can't find in the atoto models, and it's dumb as hell but ... a physical volume knob
06:58 < Evilpig> https://www.crutchfield.com/g_462450/Android-Auto-Compatible-Car-Stereos.html?tp=72381&fa=1&o=p#&avf=Y&nvpair=AG_Android_Control|FFAndroid_Auto_@Wireless@_&nvpair=FFVolume_Knob|[rank1]Yes&nvpair=AG_Radio_Features|FFSiriusXM%20(Tuner%20Required)
06:58 <@Dolemite> yeah they are buttons on the atoto
06:58 < PigBot>  Android Auto Compatible Car Stereos at Crutchfield  (at www.crutchfield.com) https://tinyurl.com/2chlyoq5
06:58 <@Dolemite> though I bought the spinny wheel remote that you attach to the steering wheel and that's what I use 99% of the time
06:58 < Evilpig> gotta run this damn kid to the school.  back in 30
06:58 <@Dolemite> https://www.amazon.com/Improved-Watchband-Wireless-Backlight-AC-44F4/dp/B075NDLTPT/ref=sr_1_3_pp?crid=1I56E81ZYTAL5&keywords=atoto+remote&qid=1691755124&sprefix=atoto+rem%2Caps%2C278&sr=8-3
06:58 < PigBot> Amazon.com: ATOTO AC-44F5 Watchband Style Wireless Remote Control with Luminous Buttons, Plug & Play - Only for ATOTO Car Stereos (SA102, A6Y, A6 KL, F7 & S8), Not Compatible with ATOTO A6 PF/ S8 Lite Version : Electronics (at www.amazon.com) https://tinyurl.com/29y7sbtl
06:59 < Evilpig> neat
07:31 <@Mirage> Dolemite: Agreed on Jensen.  My experience and feedback from anyone I've known who bought one is that they're complete trash.
07:56 <@Dolemite> I will say that surprisingly my ATOTO actually has better sound quality than the Sony that it replaced
09:43 <@Mirage> Weird... FICO dropped to 799 and now have a new "Score Factor" of "
09:43 <@Mirage> Too few accounts currently paid as agreed"
09:44 <@Mirage> Strikes me as a bit odd since EVERY recurring bill I have is setup autopay and anything is paid for when done. 
09:45 <@Mirage> Still, and will always have this 'factor' if I can help it: "Lack of recent installment loan information"
09:47 <@Mirage> I wonder if it's the Corp American Express.  Hadn't used it in ages then had that Colorado work trip.  Company pays the bills on it, but it's technically in my name.   Maybe they didn't cut a check fast enough?
09:50 <@Mirage> Yeah, pretty sure that's it.   Timing of the trip crossed statement cut-offs, so there was an outstanding $96.13 from June showing on the July statement when it got paid
09:55 < Evilpig> pretty sure notlarry wants me to share this with y'all.  https://www.dropbox.com/scl/fi/cvc73apui0nfdemqv8j1d/Screenshot-2023-08-11-at-9.55.14-AM.png?rlkey=l7shh9wtvraagekx3pimgyjd1&dl=0
09:55 < PigBot> Dropbox - Screenshot 2023-08-11 at 9.55.14 AM.png - Simplify your life (at www.dropbox.com) https://tinyurl.com/25g33hq4
10:06 <@Dolemite> LOL
10:06 <@Dolemite> Yeah when my brother had his prostate removed they wouldn't let him leave the hospital until he could take a dump
10:09 < Evilpig> I may be picking him up here in a bit 
10:09 < Evilpig> they were talking about himbeing there til tuesday but with this change in status he may get an early discharge
10:13 < Evilpig> motha-fucker... I just called ford to find out what the status is on my car.  they have none to give me.  told him when I made the appointment it was supposed to be a drop off at 11 and pick up that afternoon and were are now two weeks later and no status update.  I went on to tell him the last time I had it in there they had it for three months so the service department is really just not hitting the mark.  he then tells me the service advisor over my vehicle is out til monday and to call back then and that since it is a fleet vehicle it falls under this other set of people.
10:14 < Evilpig> fleet?  what?  how the fuck do these assholes have me in the computer to think my convertible is part of some organizations fleet?
10:14 < Evilpig> is this how they are justifying repairs taking eons?
10:15 <@Dolemite> jeez
12:08 <@Mirage> I think DHL threw a part I ordered from Rockauto on the wrong truck because it's going in the opposite direction as it needs to be going.
12:22 <@Mirage> I'm sure all the trumpers are creaming their pants over this.   https://www.cnn.com/2023/08/11/politics/hunter-biden-special-counsel-appointment-merrick-garland/index.html
12:22 < PigBot> US attorney leading Hunter Biden probe is now a special counsel, Garland announces | CNN Politics (at www.cnn.com) https://tinyurl.com/25fsjwbs
13:04 < Evilpig> wtf amazon.
13:04 < Evilpig>  Delivered today
13:04 < Evilpig> Your package is ready for pickup. 
13:04 < Evilpig>  Delivery attempted today at 10:39 AM
13:04 < Evilpig> Unfortunately, USPS couldn't complete your delivery and is holding it for you to pick up. We're very sorry for the inconvenience.
13:04 < Evilpig> three usb cables.
13:13 <@Mirage> Shipped them straightened out instead of rolled up and wouldn't fit in the box?   Complex management gone to early lunch?
13:15 < Evilpig> no idea.  I just went to check my mailbox and it wasn't full.  had 5 envelopes in it.  so it wasn't a case of they couldn't deliver.  the time on the tracking said delivery was attempted and failed at 10:30 this morning and that clown doesn't deliver this route til 2:15ish
13:24 <@Dagmar> Can postfix just _not_ use mysql stored procedures or some shit?
13:25 <@Dagmar> I've turned on logging of queries, and it doesn't look like it's even trying
13:25 <@Dagmar> This shit ain't exactly rocket science: query       = CALL sender_dependent_relayhost_maps_with_default('%s')
13:25 < Evilpig> how much mail are you sending that you need sql in the mix?
13:25 <@Dagmar> I've even given the vmail user execute permissions
13:26 <@Dagmar> Part of hte problem is that I'm trying to do something postfix normally doesn't "do"
13:26 <@Dagmar> I want to _exempt_ certain addresses from the smarthost relay
13:26 <@Dagmar> ...and that's backwards from everything postfix does
13:27 <@Dagmar> This works just fine: query       = SELECT relayhost FROM sender_relayhost WHERE account='%s' LIMIT 1
13:27 <@Dagmar> I can find no explanation as to why it gets mad and ragequits about a goddamn stored procedure call
13:28 <@Dagmar> Basically, I don't want the bot-generated mails I'm using out of Nagios to go through all the anti-virus and filtering bullshit and just get sent according to MX records
13:28 <@Dagmar> Everything else should be hitting the smart relay at Zix
13:29 <@Dagmar> ..a.nd the stored procedure definitely works
13:30 <@Dagmar> Normally it's pretty straightforward, but this is baffling as hell
13:34 < Evilpig> you can't just use the regular transport table for that?  
13:35 < Evilpig> just put your nagios address on the line above your smart relay  so nagios@internal-domain.whatever smtp:[not-smart-host]
13:35 <@Dagmar> The transport table only works based on the recipient
13:35 <@Dagmar> ...and Nagios sends mail to a lot of differnent recipients
13:37 < Evilpig> so are you just trying to route based on the from address or the combination of the from and to?
13:37 <@Dagmar> Based on the from address, hence the sender_dependent
13:38 <@Dagmar> I'm literally trying to whitelist a donotreply@ address so it's mail gets delivered according to MX records, and _not_ be given to the smart host
13:38 < Evilpig> https://www.postfix.org/postconf.5.html#sender_dependent_default_transport_maps
13:38 < PigBot> Postfix Configuration Parameters  (at www.postfix.org) https://tinyurl.com/y85heumw
13:38 < Evilpig> same format as the standard transport table,  different directive
13:40 < Evilpig> for vandy we did something similar, but much easier.  they were using the onprem exchange smart relay crap that started demanding valid sender addresses and we werent'a bout to mangle all the mail coming out of every system to be compliant so we made a postfix relay that would take in all mail from our systems and if it was bound for a vumc.org addrss it would deliver direct to o365 else it would forward to the black box
13:41 <@Dagmar> DOn't even talk about Vandy
13:41 <@Dagmar> They're fucking idiots
13:41 <@Dagmar> I went to the trouble of actually deciphering the damn A+B+C+D config that David had written in 1995
13:41 <@Dagmar> THey ignored it
13:43 < Evilpig> no matter, for your case try that directive it should be straight forward
13:43 < Evilpig> probably just need to make sure it gets run before the other transport table
13:43 <@Dagmar> zWait, can the transport table indicate MX-based delivery instead of the smart host?
13:44 < Evilpig> don't think so
13:44 < Evilpig> how many domains are you needing to look up?
13:45 <@Dagmar> Yeah the problem is that you can only indicate DUNNO from these things to terminate the search
13:45 <@Dagmar> ...or a null result, or a new server
13:45 <@Dagmar> A null result lets the search continue and eventually just results in being sent using the default methods
13:46 < Evilpig> You may just need to knuckle under and set up an smtp server that doesn't go through your scanning and lock it down to infra devices
13:46 <@Dagmar> So, in my case I have to leave the server _not_ using a default, but set it up so that everything else not those few addresses goes through a specific servre
13:46 <@Dagmar> It's beginning to look like that
13:46 < Evilpig> probably be easier than this mickey mouse shit you're fighting with
13:46 <@Dagmar> I've already whitelisted some addresses to allow sending without auth
13:47 <@Dagmar> I'm just baffled as to why it reacts to oddly to something as simple as a stored procedure
13:47 <@Dagmar> er so oddly
13:47 <@Dagmar> Shit will get ugly if I have to refactor the stored procedure as a raw stack of IF-THENs
13:50 <@Dagmar> https://manpages.ubuntu.com/manpages/jammy/man5/mysql_table.5.html#using%20mysql%20stored%20procedures
13:50 < PigBot> Ubuntu Manpage: mysql_table - Postfix MySQL client configuration  (at manpages.ubuntu.com) https://tinyurl.com/253v83ox
13:50  * Dagmar prepares to look at what the fuck version he's using
13:51 <@Dagmar> Oh for fucks sake
13:51 <@Dagmar> postfix 3.2 supports using stored procedures, 2.10 apparently does not
13:52 <@Dagmar> What wacky-ass nonsense are they doing that they _can't_ already use a stored procedure
14:00 <@Dagmar> Okay transport maps are definitely the wrong thing
14:00 <@Dagmar> I'm not trying to direct some mail to be delivered via UUCP
14:04 < Evilpig> it also has the sender host dependent relay map
14:06 <@Dagmar> ...which is what I'm trying to use
14:06 <@Dagmar> ...except I have to change the way that is evaluated 
14:07 <@Dagmar> I need it to have no specific relay host for a small number of whitelisted addresses
14:07 <@Dagmar> What normally happens there is you set certain addresses to go to specific relay hosts
14:08 <@Dolemite> so transport maps
14:08 <@Dagmar> No.
14:08 <@Dagmar> It's all SMTP.
14:09 <@Dolemite> Yes
14:10 <@Dagmar> Hmm... relay: and smtp: okay
14:10 <@Dagmar> This might be doable
14:10 <@Dolemite> snowflake.domain     smtp:[special.relayhost]
14:10 <@Dolemite> snowflake.domain     smtp:[special.relayhost]:specialport
14:10 <@Dagmar> Well, hopefully it won't get mad about a destination of "smtp:"
14:11 <@Dolemite> Well if you use the submission port, you have to put :587
14:11 <@Dagmar> It's not
14:12 <@Dolemite> That's how I get all of my mail into my house.  I have a tiny VPS that has port 25 open, then it relays to my house on 587 which isn't blocked by TDS
14:15 <@Dagmar> fuckity fuck fuck
14:16 <@Dagmar> oh wait.  I thought this version didn't even support that because it doesn't show in the man page
14:17 <@Dagmar> Nopw I just have to wedge it into the config directives
14:36 <@Dagmar> fuuuuuuuu-uuuuu
14:38 <@Dagmar> OKay that's definitely in need of better documentation
14:41 <@Dagmar> The way I finally got it to work was to set "* smtp:thefiltering.router.com" and "donotreply@nhccare.com smtp:" in the default transport map
14:41 <@Dagmar> Leaving the whitelisted one to just DUNNO didn't work right at all
15:22 <@Mirage> Finally got tired of finding the opendmarc service not running and wrote a watchdog for it.
15:23 <@Mirage> No clue why it dies.  No logged errors or anything
15:37 <@Dagmar> I was mistaken.  There's no way to do this 
15:37 <@Dagmar> Not without doing the thing I was trying to do
15:37 <@Dagmar> "In order of decreasing precedence, the nexthop destination is taken from 1) $transport_maps, 2) $sender_dependent_default_transport_maps or $default_transport, 3) $sender_dependent_relayhost_maps or $relayhost or the recipient domain."
15:38 <@Dagmar> So, if I set the smart relay in transport maps, it's done and unalterable
15:38 <@Dagmar> I can't set it in default_transport because then smtp: is going to default to the damn smart relay
15:41 <@Dagmar> If there were a sender_dependent_transport_map, that would be great but there isn't
16:07 <@Mirage> Anyone need a t-shirt? https://dallas.craigslist.org/ndf/clo/d/mckinney-l-tank-tops-nwot/7653608919.html
16:07 < PigBot> 2 L Tank tops NWOT - clothing & accessories - by owner - apparel sale (at dallas.craigslist.org) https://tinyurl.com/2832uzpk
16:13 <@Dagmar> Far, far fucking better solution
16:13 <@Dagmar> select relayhost from sender_relayhost where account='%s' OR account='*' ORDER BY id LIMIT 1;
16:18 <@Dagmar> I just shoved in a "default" entry with an id of 999999
16:19 <@Dagmar> I was able to throw all the other stuff right out
16:48 <@Dagmar> ..and because no production SQL is ever complete until it makes you want to run away screaming...
16:48 <@Dagmar> SELECT relayhost FROM sender_relayhost WHERE account='%s' OR account=SUBSTRING('%s', 0 - LOCATE('@', REVERSE('%s')), LOCATE('@', REVERSE('%s'))) OR account='*' ORDER BY id LIMIT 1;
--- Log closed Sat Aug 12 00:00:24 2023