Honestly, you just need to pick a video on follow along these days. There’s a load of YouTube videos out there that take you step by step.

Lewis rosman recently put out a 14-hour mega video of doing everything, well he might have made some controversial choices, The outcome is quite comprehensive.

Yep, it is ribbed for your protection. :)

Hardly anyone ever says mysql is better. Postgres has a lot of nice features, But they’re still a hell of a lot more people out there with mySQL experience.

If for some reason you really want to go mysql I would urge you to look into percona and percona tools. It’s incredibly fast super optimized. The tools let you do backups that my sequel could only dream of.

That said, if you don’t have any strong needs for mySQL, and you don’t have any experience with it I would probably start picking up postgres.

No, that file is located in the nix store and linked back, If you become root and try to edit /etc/hosts It will complain that you cannot edit the linked file.

If you go and try to edit the store directly you will meet the same kind of dead ends because /nix/store is a ro bind mount

With enough root access, time and persistence you could eventually unwrap its flavor of immutability which is why I said mostly immutable. Compared to most operating systems where you can just slip a quick edit into a cron job it’s leagues ahead.

Then you have NixOS, which is declarative, and fairly immutable.

You don’t have to reboot to make changes, but you can’t just run unlinked binaries either.

You can’t do things like edit your hosts table or modify the FS for cron jobs. The application store is unwritable, but you can sync new apps into it .

You have to make changes to the config file and run a rebuild as root.

Yes! That was the other thing I wanted to include, but I couldn’t remember the name or search for it, so I wrote it off as a fever dream!

I used to love it, it could look a lot like c, or you could do crap like

$_=<<'';y;\r\n;;d;$_=pack'b*',$_;$_=eval;$@&&die$@;$_

Admittedly, they’re trying to obfuscate it, but even unpacking it a bit, it looks alien.

It’s like learning Perl back in the day, then needing to learn use strict;

7th gen intel, 96GB mismatched ram, 4 used 10TB HDD, one 12 with a broken sata connector that only works because it’s sitting just right in a sled. A couple of 14’s one M.2 and two sataSSD. It’s running Unraid with 2 VM’s (plex and Home Assistant), one of which has corrupted itself 3 times. A 1080 and a 2070.

I can get several streams off it at once, but not while it’s running parity check and it can’t handle 4k transcoding.

It’s not horrible, but I couldn’t do what I do now with less :)

Best of luck with it, logging’s always a severe pain in the ass.

No I get what you’re asking for I’m just mentioning that sometimes it’s easier to use an application that can read multiple formats than it is to try to finagle everything back into one format.

I’m not sure about your exact ask, I’d probably head towards setting up logstash and elasticsearch. It might be overkill for your needs though.

yup, fairly normal. I had to jump through some hoops for my old haproxies

If you’re using let’s encrypt, it’s worth automating the cert renewals. Even for systems where the automation is difficult and not supported.

It’s also worth running some kind of monitoring system. You can check certificates with OpenSSL really easily. Fire off a message to NTFY.

Yup, Unifi 8 port POE. I put them in an isolated VLAN where they can’t see other things or get to the web on their own. I download updates for them log into their web interface and push the updates to them when I need it.

Home assistant with door sensors. Doors open and closing after normal hours send alerts to telegram. Likewise for any doors that are left open or sensor batteries that are running low. It also lets me know if any of my camera video feeds go offline.

Eufy doorbell. I don’t love the company but it’s cheap and stores my video encrypted locally. No monthly fees. It’s AI is very good at letting me know that someone came up to my door without pressing the doorbell.

Reolink cameras. I don’t love the company, The cameras are vaguely compatible with what I’m doing, put oh my god are they cheap, video quality is good and the night vision is really good.

Blue Iris for camera server running on an old laptop with an Nvidia card. I’m going to be swapping this out for frigate sometime the next year.

I probably have 300 hours into setting up Blue Iris. I have tweaked it and tweaked it and tweaked it. When any significant changes happen in zones that I’ve hand drawn for more than 4 seconds, Blue Iris will send a telegram message with a copy of the image with a orange rectangle around the change. My main street camera records 24x7, only saving frames that change in between, I’m in a rather dense community and people come to me for footage not infrequently. The rest of my cameras only record significant events.

Right now, my biggest problem is false alarms. What I really want is to be notified if someone is in my driveway even briefly. Likewise on my back porch or my basement steps. But I don’t want to be notified if it’s my dog or a piece of trash or the beams of some headlights.

I’m planning on moving to Frigate with a coral tpu and probably having it notify me with NTFY, has telegram’s pretty bad at actually sending thumbnails to my watch.

Single establishment commercial space may be pretty expensive still but there’s an awful lot of bigger buildings starting to feel the burn from work from home. I wonder how many of the big buildings would have to fall before the commercial real estate industry takes a serious dive and they lose a crap ton of bank?

Yeah I host stuff for my job. And I don’t host all of my data stores. (I do have 150 reddis servers sitting around now)

If $85 fits comfortably in your budget and helps you sleep at night I certainly wouldn’t criticize you for doing it.

That was a nice clean read great job. My first reaction was $85 is a hell of a lot of money (you can stand up and absolute monster server in some places for that) but then I saw your running managed database and that scans.

Never said you couldn’t I was assuming OP was running VMs inside of Nix