PC connects to local wifi network, but no internet

My wifi network works on all other devices connected to it, but my PC seems to be having a lot of issues with it.

Solutions I've tried:

- Router and modem restart

- Full network reset

- ipconfig command line prompts

- Uninstalling and reinstalling network adapters/drivers

When I use my phone as a hotspot internet connectivity is just fine, so I know that something happens when I try to connect to the internet via my own wifi network.

If anyone needs more information to help narrow this down, please let me know and I'll be happy to provide it.

Specs:

Windows 11 Build 26200.9457

XFinity Gateway modem set in bridge mode for Linksys MX4000 wifi mesh system (WPA2 Personal)

PiHole running on a TrueNAS server connected via ethernet (set up correctly as far as I'm aware)

Running Tailscale on the TrueNAS server as well as the PC, but I’ve had the Tailscale VPN disabled on the PC for some time as it created issues connecting via SMB to the server for some reason

reddit.com
u/thepunnman — 4 days ago
▲ 7 r/excel

Trying to create a new column with values from 2 other columns as plain text

Column 1 Column 2 Column 3
oh oh ah ah blah blah oh oh - ah ah
ding ding dong dong blah blah ding ding - dong dong

Given the values in columns 1 and 2, how would you create column 3 so that I can just drag down? Spreadsheet has 200+ rows so manually copy/pasting everything is very inefficient

reddit.com
u/thepunnman — 3 months ago

Cannot for the life of me get Music Assistant set up

I have Home Assistant set up on a VM within my TrueNAS server.

I have Navidrome set up as an app on my TrueNAS server.

When I try to set up a subsonic music source on the Music Assistant app in HA, I keep getting an error that says "Cannot connect to host 192.168.1.174:30043 ssl:default [Connect call failed ('192.168.1.174', 30043)]"

I know for a fact my url is correct because when I throw that same URL and port into my browser it opens up Navidrome just fine. And I know my username and password are correct as I have logged out and logged back into Navidrome using the same name and password. There has to be something I'm missing, and I cannot figure out what it is.

reddit.com
u/thepunnman — 3 months ago

I want to switch from iOS, but I have a few reservations

Earlier this year, I kicked out all of our Alexas in favor of Homepods because my wife and I are both on iOS devices. The Alexas never liked me, and I wanted the Homepods because

  1. It would be easier to stream music to. I really like the simplicity of being able to just AirPlay my music to any combination of speakers.

  2. More importantly, we have a shared grocery list on the stock iOS reminders app that syncs between us. The homepods allow us to add things to the grocery list with voice commands, and we've both come to really love that particular use case.

Recently, I've been strongly considering switching to GrapheneOS for the privacy benefits as well as a few other things. Me switching to GOS would break those two things pretty badly as far as I'm aware. I have a bunch of services self-hosted already so if there's a solution out there that is completely self-hosted that would be preferred.

From some short research, I think there's apps out there that allow me to AirPlay from an Android device, would those same apps work on GrapheneOS? More importantly, how would a shared grocery list work between us that still maintains that same voice command functionality? I was looking into KitchenOwl briefly, but it doesn't have any voice command support as far as I was able to tell.

What other solutions are out there besides creating a fully self-hosted LLM/STT/TTS model, switching my wife to GrapheneOS (a very tough transition), and switching out my homepods for something like Sonos speakers?

reddit.com
u/thepunnman — 3 months ago

Can someone please point me to a braindead easy guide on setting up Gluetun, PIA, and Qbit on a TrueNAS server?

No option to add flair for some reason so I'm on TrueNAS ElectricEel-24.10.2.4

I've read and watched at least a dozen guides (most recently this one) but there's always at least one step where I feel like there were a few steps omitted in between steps that would help me understand what's going on.

Currently I have Qbit and PIA working on my desktop computer to get Linux ISOs which qbit downloads directly to my TrueNAS server via SMB share. Obviously, not ideal in terms of power consumption or any measure of efficiency.

I just need someone to point me in the direction of setting up the three services I mentioned in the title directly on my server. I don't even need an *arr stack. I would prefer to avoid creating a VM but if that's what I need to do then that's what I need to do.

reddit.com
u/thepunnman — 5 months ago

Need help creating an automation

I work as a mail carrier and I want to set up an automation that will notify my wife when I’m leaving work to come home.

I already have the zones set up properly, and I already made one for when my wife leaves work. I get a notification with the travel time for her work to our home when she leaves her work zone.

The problem is that I am sometimes leaving my work zone several times per day as I can leave the office to deliver mail, come back and then leave again to deliver more mail. The only way I can think to weed out the false positives is by having a condition where the automation would only go off when my phone is connected via bluetooth to my car; even a specific time window could potentially create false positives.

As I’m on iOS I don’t think there’s a bluetooth sensor I can tap into, unless there’s something I’ve missed entirely. Or maybe there’s an automation I can run in the iOS shortcuts app that can piggyback off a bluetooth sensor that would then trigger the home assistant automation? This one has been especially tricky for me.

reddit.com
u/thepunnman — 5 months ago