@loopback0 said in Process Markdown files: @dangeRuss said in Process Markdown files: @loopback0 said in Process Markdown files: @dangeRuss which is perfect for sed and/or awk. Doesn't even need to be complex as you could just pipe the output back into sed or awk again if needed. If it's a one-off, it doesn't need to be pretty. As mentioned already renaming the actual file is just the output of those into mv. As good as I am with bash, sed and awk are still blackboxes for me. Do you have some sample code of how this would look? It's nearly 11pm here so not if you're in a rush. Google (or someone else here) can help if you are. I think I will just do it in python, but still interested in seeing awk/sed solution if/when you have time.

@PleegWat said in Resources to learn about database schema design and optimization?: I'm pretty sure you get them in definition order in both mysql and oracle. Yes you do, at least in Oracle. Unless you redefine the order, which is possible since 12c. The real takeaway from this is: never rely on undocumented behaviour. If you do, things will break in a next release. I remember some ancient Oracle upgrade (from 8i to 9i maybe, not sure), when suddenly records were not sorted anymore by a group by without an explicit order by. It was never documented that it would, but was widely used. And then it broke.

@PJH said in Fast CSV processor: @dangeRuss said in Fast CSV processor: Getting the clients to change over, especially when the contracts all say CSV is another matter. Have you tried rules-lawyering? "It clearly states 'Character Separated Values', and the separating character is a tab..." (Unless of course, someone else got there first and specifically mentioned the phrase 'comma separated values' in the bumph.) That's above my paygrade, but yea I would claim that tab separated CSV is just a CSV with tab delimiters (which it really is). In any case this burntsushi thing seems really great and it cut down my processing time in half.

@Zerosquare apparently Microsoft noticed that acronym has become totally ungooglable and has since renamed it SSDT.

@Applied-Mediocrity no idea. I remember watching videos on there previously but noticed over the weekend that it didn't work any more. This morning I opened up the debugging tools and noticed a bunch of errors. On firefox it linked to a (blank) page titled "Enable HLS playback": Oh, wait...now Firefox is working. It also updated this morning in between my attempts. When I clicked on that before it just went to a blank page. Fuckin' web. Still, would like to have it work in chrome.

@izzion said in Verizon BGP routing issue: @dangeRuss said in Verizon BGP routing issue: WTF is it terminating right after my router? Pretty sure GP doesn't have a server sitting at my local verizon office. It's probable that the Global Protect service is using "anycast" IPs -- they probably have access points at many different major peering points (e.g. Chicago, Denver, Dallas, Fairfax VA, etc) and then use geographic based DNS to direct you to the address closest to you, similar to what Google does with their DNS and other major services, or what Akamai does with services on their Content Delivery Network (CDN). So you probably live right on top of one of the major peering points such that your FIOS router's gateway is in that colocation point. Interesting... never heard of anycast before, but either way seems it's implemented with BGP, so those bits need to be fixed.

@Benjamin-Hall said in Handling when invalid data sneaks past into the db: Ran a quick scan of the database for this one particular rule. Looks like manual munging isn't going to be a sane option--there are ~350 values that are bad. And these are login ids (which for various other reasons are also emails we have to send emails to occasionally). So just "fixing" them will be a big problem when people can't log in anymore. The ultimate fix might be a multi-step thing, assuming this requires some user input for each case. A temporary login id, then pick a permanent one next time you login, etc. Difficult to say without knowing more details.

@Gąska said in Any way to avoid double NAT with two routers?: And it cannot be set to bridge mode itself - if it could it would solve all problems. Yeah the closest to that nowadays is to set the DMZ zone ip to the second router. If you can't configure your repeater as a client bridge, then might look into alternative firmware for it (what is its model?). As others have said, configuring your secondary router as an AP (with DHCP disabled) is the simplest way to reduce the NAT hops. This is easiest to accomplish by setting its LAN IP to something that doesn't conflict with the ISP router's IP, disable DHCP, then (and only then!) connect it in via the LAN ports and not the WAN port (unless your firmware can configure that port to also be a LAN port, natch). The goal here is effectively turning all the actual "routing" features off on all but your main router.

@Zecc Thanks! That's an out-of-the box answer I wouldn't be able to come up with myself, and they seem to support all the platforms I care about and then some. I'll definitely consider this. @Jaloopa Well, maybe not, if there's such a service that doesn't base the security on a phone number, doesn't Facebook the private keys, and has a real™ PC client (and not just an Electron app -- that would be exchanging one set of UX problems for a new, different set of UX problems). I've been looking for services like that. Do you have experience with Matrix, or Element, or however they call themselves now? Wire's desktop client was a real turn-off for me last time I tried it. In a way, being transport-agnostic means that we can jump ship from one service as it becomes too shitty to use to a different one that's still good enough. We used to exchange encrypted 7-Zip archives, sending one-time passwords via text messages, until most e-mail services blocked encrypted archives for "safety" reasons. For the most part, I don't blame them -- they made it easy to escape AV scanning -- but banning them all the way is also terrible for privacy. @pcooper Thanks! I'll see if there's any downsides to exchanging encrypted text files. I foresee newline-related problems (I should be careful to always send them with CR-LF newlines) and encoding-related problems (will Windows notepad auto-detect UTF-8, or should I use the ANSI code page of the recipient?), but those are all solvable on my side. I'm also a bit afraid of PGP in the browser, with it constantly being exposed to websites we visit and the telemetry added with the updates.

In my experience, this is usually caused by an incorrect (or completely missing) exception and event handling in a code that creates Promises. Especially working with streams is very tricky, because the adapter code needs to register all listeners and properly handle them by resolving or rejecting the Promise. If the stream fails and closes for some unexpected reason (connection broken? tcp reset?), the Promise is never resolved nor rejected - it just hangs. And there is absolutely no exception, no stacktrace, no log.

Let's keep in mind this is a help topic...

@JBert said in OAuth2, me, and some questions: But likely that was not a requirement here. The only requirements in this case are mine; it’s my sites, my users etc. Therefore I can do whatever best practice dictates but that’s not clear in my use case.

@dkf We use a utility to generate function declarations automatically. It has been suggested to run this utility automatically during the build phase. I've always been opposed to that because I have no idea how that could work without always rebuilding all object files.

@JBert said in See Facebook pages without being logged in: Personally I would stop visiting those pages (because Facebook) I do leave the login screen without logging in usually. (Basically the page needs to have "Age restrictions" turned off, and the page might have recently switched it on.) ... do you use Private Browsing to rule out any persistent things? I am getting this behaviour on every page including my own musical projects' pages which I didn't recently alter in any way.

@Benjamin-Hall said in Looking for software to keep track of students/classes for dog trainers: adapt a LMS (the educational version of a CRM), When I first read that, I thought you said LIMS. Those are more than enough of a shitshow for the rest of the description to work very well. It's like it is difficult to manage information for some reason...

@Gąska said in Graphics card upgrade: Wait a month or two, and you'll save at least $100. Anniversary update:

@loopback0

@Rhywden said in Foward all traffic from one NIC to another IP: seem to have had an older version of it from somewhere else on Proxmox's site. Oh, yeah, that is an issue you have to watch out for. Usually when I am looking for a solution to some problem I will Google some search term. You know, like how we all do our jobs. It is 99% Googling and/or copying and pasting from StackOverflow. For some reason the Proxmox wiki has higher rank for older versions of the software. So whenever you pull up anything you have to be careful that you are looking at current information for the version you are on and not partial instructions for 1-3 version numbers back. That has also bitten me once or twice.

@boomzilla Use a dumb card.

Hello @all, happy pi-hole on a RasPi <something 3> here. Since my google-fu refuses to deliver and CBA to <register yadda yadda etc> allow me to drop this question to the trusty people: Is it posible to display <some> stats from the admin-panel without authentication? e.g. "Top Blocked Domains" from <your_pi_hole>/admin/index (a.k.a. 'Dashboard') should be visible when one opens <your_pi_hole>/admin or somesuch. To clarify: Without logging in: is there some way to also display <this> somewhere below / insteadOf / whatever ...? /whatever the fuck wants to chat with deepl.com, IknowItsLame-junior of course declines any knowledge about this but ,,, (cue haha,,,) Any ideas & a big THANKYOU in advance!

@loopback0 said in Non-shitty smart TV: LG a good option?: Which is an advert but it's for an app inside an app store, which is exactly what I'd expect in an app store. It's probably not going to ruin the experience of using the TV even if you spend all of your time in the app store. True, but I did find a guy complaining about a real, auto-playing with sound video advertisement. (Still in the app store, but not a good sign) https://twitter.com/chriswelch/status/1369733357756686349 Ugh. So I guess I'll have to check if I can black-hole that stuff at the router level (without installing a piehole).

@GuyWhoKilledBear said in TOTALLY OUT OF CONTROL: How do you guys control your TVs? Once upon a time I used a Universal Remote Control MX-500. Had it all set up nicely with proper controls and punch-throughs for TV, Receiver, Cable Box, Game Machines, and such so it was just one button to turn on and switch to whatever you wanted to watch. It eventually broke and by that time they'd decided to not sell directly to consumers. :( After that I had a Harmony hub with the very basic remote and the phone app. Never quite happy with it, too much inertia to get something better (even a better Harmony remote). Now I have a very simple setup based around a TV with built-in Roku. No receiver, just a Blu-ray player and a Raspberry Pi-based emulation box on the extra HDMI inputs. It's mostly used for Netflix. The other TVs in the house are just used for cable with the cable remotes.

You bastards! Now you've got me going through WinAPI docs, reminding myself how it used to be done. I hate you all!

@remi True, the bigger problem that caused the big spike here last summer was relaxing the rules too quickly and the 'Dancing with Johnson' campaign, where people were encouraged to get a single-dose Johnson vaccine which allowed them to go partying without tests or other restrictions that same night.

@sloosecannon no

@boomzilla Thanks. Took about 5 tries to enable it, but finally it worked.

@e4tmyl33t I guess that's it, then. Time to order the LTE version, and hope the module inside is pin-compatible. Because if it's not, then our first delivery is going to be either very late or built on wire spaghetti.

@izzion Okay, missing the proper subnet and gateway then.

I started using soverin.net recently. No complaints so far.

@Zenith The Pixel 4a can take decent photos, although it's probably more expensive than you were looking for. Google Pixel 4a Camera review: Excellent single-camera smartphone However as @cvi said, it's probably a better "investment" in the long run.

I've just bought U2720Q and it's quite nice. A little over your budget, but I suppose there are cheaper variants of the same.

@Gribnit it's cheaper to add on another couple of roof trusses than to get longer spans, so yeah, it was a common building style.

I thought that this is an interesting approach to 3D printing: A DIY 3D Printer That’s Upside-Down, On Purpose? The Positron Introduction – 12:46— K R A L Y N 3D

@Bulb you're well convinced it does something useful in there, I assume?

@dkf said in Best, or at least non-wtf, practice for working with Visual Studio SQL project: @Gribnit said in Best, or at least non-wtf, practice for working with Visual Studio SQL project: And so what if a submarine sinks? Kursk submarine disaster - Wikipedia Thanks, but I doubt I can get the DBAs to read it.

@LaoC said in Improvised Celebratosive Devices: Depends on whether 20% hydrogen peroxide counts as a common household item. A while™ ago they used to sell it to teenagers no questions asked. AmeriClaus visited with starshells. Turns out the lad is a bit of a pyro.

No progress whatsoever. Since this is fair warning that I'd occur it'd be useful from time to time, it somehow being helpful that people can be reminded of some of the things that can it turns out just happen, but, eh, will update.

I never really did see any consensus on what my next job should be. I'm leaning towards retail if my house is paid off and commercial truck driving if it's not. Or, paradigm shift, should I attempt to exploit wokeness somehow? I think it would be too much effort to pull a Rachel Dolezal. I still don't understand why she was fired. Was it because there was a real black person that didn't get the job? Would a "transtrender" be punished similarly for depriving a real woman of a job?

For those who deserve immediate pain: speaker mode, keypad, and spamming * and # DTMF at the operator with both thumbs - think level 100+ of Robotron 64. Got a very gratifying "Your line has been connected to-oo-ugh" then disconnect with same.

@Gribnit said in High NFS client wait time: @dangeRuss said in High NFS client wait time: @dkf said in High NFS client wait time: By way of trying to help, is there anything you can see on the server side? At the very least, is there any noticeable resource utilization there too, or is this a client-only issue? (Right now, it could be doing something silly like busywaiting on network while the network's decided to send things in minimum-sized packets.) Hopefully it's client-only; if the server or the network between are intimately involved in the problem, it'll be hell to track down the fault. The server seems fine. There is winbind involved, I'm willing to bet its doing something stupid like checking the permissions for every single file with the AD server. Can you has, network level trace? Like a tcp dump? Yea I can do one of it helps. I tried turning on nfs client debugging, but didn't see anything funny.

It works okay with a different model of Roku. I guess I will upgrade the lame one for Christmas.

@HardwareGeek if you figure out what you need to do for the company to not lose a lot of money and make that your goal, at least you can take them down with you.

@Tsaukpaetra I gave you a vote up over there.

everyone knows to buy apple and enjoy privacy.

@Gribnit said in I think i might be producing WTF code: modules in 9+ Ah, we're using 8 as our target language profile as that's easy to deploy even in the weirder scenarios we use. So no modules for me!

@Luck-Man said in Strange behaviour from new hard drive: @Choonster said in Strange behaviour from new hard drive: @Luck-Man The post you quoted was the closest I came to a solution. I've never tried enabling compression before. Did it take a long time? I'm going to move about 3.4 TB into it. I don't remember it that much, but I think it did take quite a while.

@Rhywden said in Mounting a samba share: @loopback0 said in Mounting a samba share: @Rhywden said in Mounting a samba share: Don't know where to look for SMB encryption Some Powershell incantation, natch. Iä, Iä, Fhtagn? wgahnagl Ftahgn.

@Deadfast said in Aquiring an automobile: @Carnage said in Aquiring an automobile: But test drive before you make up your mind. Be sure to plan a route ahead of time. Try it at higher speeds to see what the engine and road noise levels are. Find a bumpy road to test the suspension. Take it around a roundabout a bit faster than you normally would. Try accelerating and braking (where safe). Bring along someone to review the passenger experience as well. Copy the car image and fuzz 99 of them with alternate decision extrapolations in accelerated time while you drive. Be sure to vary the physical laws. Don't be a sucker.

@JBert said in GE fridge defrost cycle not terminating soon enough: @dangeRuss Well, I don't own a GE fridge nor any other brand with a defroster (then again, I only have a tiny freezer with just 3-4 trays). I do know Big Clive made a video about the workings, but not sure how to troubleshoot one should it happen: Defrost control timer. More complex than you might think – 15:20— bigclivedotcom Have not looked, but I imagine that my fridge does the defrost control using the control board, not a timer. I know I can kick it off using Konami code, while I saw some videos saying to find the timer which was mechanical and to advance it using a screwdriver.

Thanks, everybody. It's given me some ideas and insights. It's a daunting task, but I now have a clearer picture of what I should be focussing on.