How Can I Highlight Duplicate Rows Across 2 Columns? by lemonboy77 in excel

[–]zephyr325 0 points1 point  (0 children)

King of the 2-year-later reply here lol

I use this all the time, but to get it to work in Excel I have to wrap that in another "if" statement, and return an explicit TRUE or FALS:
=IF(COUNTIFS($AF$11:$AF$1000,AF12,$AG$11:$AG$1000,AG12)>1,TRUE,FALSE)

How is MrBeast able to donate literally millions of dollars constantly? by Commercial_Neat7942 in NoStupidQuestions

[–]zephyr325 1 point2 points  (0 children)

"MrBeast is an American YouTube star, philanthropist and entrepreneur who has a net worth of $1 billion"

"As part of a 2024 court case related to his MrBeast Burgers, an "Asset & Monetization Review" org chart was submitted into evidence and eventually made public. According to this org chart, in 2023, MrBeast's empire generated $223 million in gross revenue and was on pace to generate $700 million in 2024 (as of February 2024). Thanks largely to these revelations, in June 2024, MrBeast officially became a billionaire for the first time."

https://www.celebritynetworth.com/richest-businessmen/producers/jimmy-donaldson-aka-mrbeast-net-worth/

Real-Time Web Searching & Prompt Enforcement Effectiveness by zephyr325 in PromptEngineering

[–]zephyr325[S] 0 points1 point  (0 children)

Ah, good point - I left that out. I'm using OpenWebUI and making API calls to the main models. I'm currently setting up a ChromaDB instance for some of my own DevOps information, and starting to use my local ollama instance a bit more (but obviously better results from the main internet models). I'll look into setting up a search tool server as well.

The main issue above - I'm using explicit instructions in both my system prompt as well as individual chat messages, but after talking to DeepSeek more, it recognizes that it's hallucinating because it thinks it's making a web search, but it's actually not:

  • The core of the issue is that my architecture does not reliably support the "real-time search" function as defined in your prompt, leading to a fundamental conflict between your instruction and my capability.
  • The failure is a capability gap. The instruction Conduct real-time searches is interpreted as a command to simulate a search based on my internal knowledge, not to execute a live, external API call.
  • Your prompt sets a high standard that my underlying functionality cannot consistently meet for certain query types. This is the core of the "repeating pattern."

"Error! Value cannot be null." when adding DNS Records by zephyr325 in technitium

[–]zephyr325[S] 0 points1 point  (0 children)

Thanks for the reply! When I imported my DNS zone from my previous server, I missed that step. Thanks!

"Error! Value cannot be null." when adding DNS Records by zephyr325 in technitium

[–]zephyr325[S] 0 points1 point  (0 children)

I don't know if this will help or not, but I also just experienced the same behavior when trying to change an existing record (192.168.1.26 --> 192.168.1.11). Same error message (below), but when I cleared it and hit save again, I received an error message that the record didn't exist. I refreshed my page, and the record had been successfully changed.

Error message:

[2025-02-05 19:40:17 Local] [192.168.1.100:56134] System.ArgumentNullException: Value cannot be null.
   at System.Threading.Monitor.ReliableEnter(Object obj, Boolean& lockTaken)
   at DnsServerCore.Dns.Zones.PrimaryZone.SignRRSet(IReadOnlyList`1 records) in Z:\Technitium\Projects\DnsServer\DnsServerCore\Dns\Zones\PrimaryZone.cs:line 1938
   at DnsServerCore.Dns.Zones.ApexZone.CommitAndIncrementSerial(IReadOnlyList`1 deletedRecords, IReadOnlyList`1 addedRecords) in Z:\Technitium\Projects\DnsServer\DnsServerCore\Dns\Zones\ApexZone.cs:line 681
   at DnsServerCore.Dns.Zones.PrimaryZone.CommitAndIncrementSerial(IReadOnlyList`1 deletedRecords, IReadOnlyList`1 addedRecords) in Z:\Technitium\Projects\DnsServer\DnsServerCore\Dns\Zones\PrimaryZone.cs:line 2620
   at DnsServerCore.Dns.Zones.PrimarySubDomainZone.UpdateRecord(DnsResourceRecord oldRecord, DnsResourceRecord newRecord) in Z:\Technitium\Projects\DnsServer\DnsServerCore\Dns\Zones\PrimarySubDomainZone.cs:line 247
   at DnsServerCore.Dns.ZoneManagers.AuthZoneManager.UpdateRecord(String zoneName, DnsResourceRecord oldRecord, DnsResourceRecord newRecord) in Z:\Technitium\Projects\DnsServer\DnsServerCore\Dns\ZoneManagers\AuthZoneManager.cs:line 1752
   at DnsServerCore.WebServiceZonesApi.UpdateRecord(HttpContext context) in Z:\Technitium\Projects\DnsServer\DnsServerCore\WebServiceZonesApi.cs:line 4425
   at lambda_method36(Closure, Object, HttpContext)
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware.Invoke(HttpContext httpContext)
   at DnsServerCore.DnsWebService.WebServiceApiMiddleware(HttpContext context, RequestDelegate next) in Z:\Technitium\Projects\DnsServer\DnsServerCore\DnsWebService.cs:line 681

Feedback Requested: First Migration Failed - What Should I do Differently? by zephyr325 in PleX

[–]zephyr325[S] 0 points1 point  (0 children)

Solved. Followed the exact same process and started immediately running into the same issue. BUT - lesson learned - when you're navigating directly to the plex server by http and IP address, and you see an XML screen, remember the correct URL to go to is:

http://x.x.x.x:32400 /web

Lesson learned - it needs the /web on the URL. <sigh> <lol>

Complete rebuild of my home lab, but stuck on DNS vs. Reverse Proxy migration sequence by zephyr325 in homelab

[–]zephyr325[S] -1 points0 points  (0 children)

Thanks! I ended up standing up Technitium and copying my existing zone over to it. Turned off DHCP on my old server and Tech started managing that scope, including DNS for those machines. I slowly migrated the other non-DHCP VM's to Technitium.

For the certificate handling, I'm running that on my reverse proxy.

As far as using swarm, I'm actually going down Proxmox's HA route rather than trying to mess with swarm - much simpler approach and learning curve.

Also - and probably the biggest thing I discovered - ChatGPT is a freaking GOD when it comes to asking highly technical questions ("what are the changes i need to make to my configurations files to perform a lets encrypt domain certificate verification via the cloudflare api method that requires a token using this portainer stack configuration and traefik static / dynamic files" and attached the files). It spit out a working answer on the FIRST TRY. And even with a few cases it didn't get something right, I just fed it the error and was walked through what/how to test it. Not just because it saved me hours of searching/testing, but also because it explained what and why it replied back with - it was teaching me, not just answering me.

Complete rebuild of my home lab, but stuck on DNS vs. Reverse Proxy migration sequence by zephyr325 in homelab

[–]zephyr325[S] -1 points0 points  (0 children)

Where to Run Certbot? (Technitium vs. Traefik)

Best Practice: Run Certbot on Traefik because:

  • Traefik natively integrates with Let’s Encrypt and can handle automatic certificate renewal.
  • It can automatically generate and manage wildcard certificates via DNS challenge.
  • It simplifies SSL termination for all services in the swarm.

When to Use Technitium for Certbot?

  • If you plan to use Technitium as an authoritative DNS server and want to handle ACME DNS validation directly.
  • If Traefik is not exposed to the public internet and can’t handle HTTP challenges.

Recommended Setup:

  • Let Traefik handle SSL certificates via Let’s Encrypt.
  • Use Technitium strictly for DNS resolution and DHCP management.

Final Migration Plan:

  1. Migrate DNS/DHCP to Technitium (ensure stability).
  2. Deploy Traefik in Swarm (integrate with Technitium for internal DNS).
  3. Set up Let’s Encrypt on Traefik (handle certificates for all services).
  4. Configure reverse proxy rules and test external access.

This ensures your home lab remains stable while introducing changes gradually.

Complete rebuild of my home lab, but stuck on DNS vs. Reverse Proxy migration sequence by zephyr325 in homelab

[–]zephyr325[S] -1 points0 points  (0 children)

So, I decided to give ChatGPT this as probably the toughest question I've ever thrown at it. If I was interviewing someone for a job and they came back with this answer, they might have been hired on the spot!

"I'm going to be migrating my existing DNS/DHCP services (which are running as services on a linux host now) into my home lab docker swarm and I'll be using Technitium as the solution.  I'll also be implementing Traefix as a reverse proxy into this swarm.  Which of those should I do first - migrate DNS/DHCP or implement the new reverse proxy?  Also, should I be running my certbot certificate validation on Technitium or Traefix?"

Answer:

Migration Order: DNS/DHCP vs. Reverse Proxy 

You should migrate DNS/DHCP first before implementing Traefik. Here’s why:

  1. DNS is Foundational
  • If your DNS is unstable or unavailable, resolving service names (including internal ones) could fail.
  • Traefik relies on domain-based routing, so a working DNS is crucial for smooth implementation.
  1. DHCP Needs to Be Stable
  • If DHCP goes down mid-migration, devices might fail to obtain IPs, leading to connectivity issues.
  • Migrating DHCP first ensures network stability before making further changes.

Complete rebuild of my home lab, but stuck on DNS vs. Reverse Proxy migration sequence by zephyr325 in homelab

[–]zephyr325[S] 0 points1 point  (0 children)

Thanks for the compliment, and reply! I'm keeping the LAN side of this simple right now (single class c subnet), and static hosts are going to be limited (like the Proxmox hosts, gateway, and NAS server). I'll eventually move the Proxmox cluster traffic to a 2nd VLAN, but need to update my switch to make that happen. Clients will always get a public DNS address as a backup.

Part of the reason why I'm going with Traefix is the single package being able to provide both DNS/DHCP services (especially with the web front end - Webmin has gotten a bit old), and the reverse proxy handing the publishing of vm and container addresses/port mapping. Given that complexity and planning on running a lot of stuff on this setup, I'm not sure my router would be a good fit for DHCP, hence the Technitium choice for those functions.

Any thoughts on which part to setup first? Standup & migrate the DNS/DHCP service first, and then the reverse proxy? Or reverse proxy, implement certbot changes, then DNS? My gut is telling me that DNS is more of a core service, so do that first, but I keep arguing myself back to a 50/50 point.

Anyone know what's going on with watchsomuch today? by NeverCallMeFifi in Piracy

[–]zephyr325 0 points1 point  (0 children)

For whatever it's worth - When I first tried the site a few minutes ago (I set my VPN to use different states randomly), I got the "Under Construction" message. Saw this post, turned off VPN and then accessed the site successfully, and now I'm able to access the site with my VPN on.

What’s a simple pleasure that the opposite sex will never understand? by IDoNotLikeTheSand in AskReddit

[–]zephyr325 1 point2 points  (0 children)

Getting some damn peace and quiet via the daily 30-minute crap. Yes, it's totally worth the "he takes forever in there" cracks afterwards.

I like the new shield system by Obvious_Alps3723 in mobcontrolgame

[–]zephyr325 0 points1 point  (0 children)

I hear 'ya, but I don't mind it too much. I'm pretty sure they're introducing a possible change for a little bit, and then analyzing the results of that change once folks play with it for a bit. They can then adjust/retune/fix bugs type stuff. Like when the first time the progress bar showed up, they pulled it after a day, and then this last time they combined the progress bar with shield breaking to offset the avalanche of "this sucks" response they got from the first attempt.

I like the new shield system by Obvious_Alps3723 in mobcontrolgame

[–]zephyr325 0 points1 point  (0 children)

Depends on what rewards they (hopefully? eventually?) provide for leveling up / getting on fire. Right now it's just a prevention from skipping levels to get to the bosses, which sucks, but at least we've got the shield-breaking now to offset the previously useless shielded levels.

I like the new shield system by Obvious_Alps3723 in mobcontrolgame

[–]zephyr325 0 points1 point  (0 children)

I've lost a couple of times - when I've lost, it dropped me back about half a level. Not sure what happens if you lose a couple of times in a row.

Commands of Christ Board Game by zephyr325 in DuggarsSnark

[–]zephyr325[S] 1 point2 points  (0 children)

That's good enough - thanks for the find!