lancache

2020-09-12Posted by xaminmo

TLDR: I now only have to download microsoft and steam updates once for all 13 systems in the house.

I finally set up a LAN Cache. I got tired of windows update sneaking in and eating all of my bandwidth, killing movies, etc. We have 4 regular Steam clients, plus 3 that don’t run very often; and we have 13 Windows 10 systems. It seems like settings always revert, and they update whenever they want, or at 100% bandwidth a few months after setting the throttles low.

https://lancache.net/ caches steam, windows updates, and several others. It was much easier to set up than a squid webproxy on my router. This should make it so anything that is downloaded only downloads once. only have 200GB to throw at it right now, but that should help a bunch. I need to set it to auto-start on boot, and to give it more space eventually, but I’m just really happy it’s working now. And apache, SSLH, and DNSMASQ on the same host still working.

My router already pointed to my server for DNS Masquerading, so I could manually override things. I added a second IP address, and modified lancache.yml to put all services only on the new IP address. I updated dnsmasq.conf to forward to lancache only, because it was not obeying the fallback rules.

This means if lancache dies, I have to edit dnsmasq to keep the home network functional. So many layers.

Excel resizes small fonts and zoom into proportional MS Sans

2018-09-24Posted by xaminmo

Fix by adding this DWORD32

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options\FontSub=0

Change 16.0 to whatever version you are using that has Options.

Outlook and huge internet calendars

2014-11-10Posted by xaminmo

The PST for Internet Calendars does not automatically compact.
Every sync is an entire, new copy saved into the PST.
I found my file is 42GB (I have about 10 calendars).

To see if you have the issue, check
C:\Users\(username)\AppData\Local\Microsoft\Outlook

If you have nothing gargantuan, then all’s well.

If your Internet Calendar Subscriptions.pst is huge:
1) you can compact it for now:
* Outlook
* File
* Account Settings
* Data Files
* Click on Internet Calendar Subs
* Click on Settings
* Compact now
* It takes 4-5 seconds per meg on SSD…

2) You can change how often this downloads.
* Outlook
* File
* Options
* Advanced
* Scroll down to Send and Receive
* Click Send/Receive button
* Edit your send/receive groups to sync Internet Calendars less frequently

3) You can set Outlook to automatically compact on close.
The drawback is that if you left it running a long time,
close might take hours. It’s also a registry change.
Because of this, I’m not listing steps for it,
but Uncle Google can help.