Symptoms of the issue: I have a WordPress installation but if I change my apache VirtualHost IP from {x.x.x.x}:80 to *:80 only the homepage works and all the other pages (pretty permalinks) stop working.
Background of my goal: I’m want to use *:80 because I want to make Apache listen on both the public and private IP in digital ocean VPS. I’m looking to setup load balancing over private IPs.
That may have security implications. Probably better to specify which overrides are allowed and just make sure to include all the ones you want domain owners to be able to change. But, even better, get the base configuration (in Server Templates) right for most of your users so you only use .htaccess for domain-specific stuff that the domain owner should be able to change.