Got this error:
configuration error: couldn't check access. No groups file?: /awstats/awstats.pl
Many things cause this error, but in my case, mod_auth was not enabled. Duh.
We've switched to Prefork MPM for stability and resource management. Since this server is also a high volume email server and stability is the most important aspect to its operations, we are scaling back on performance issues to increase stability. The other services also affect the values we use to setup preform mpm:
StartServers 5 - not starting and stopping the daemon too often, so this is somewhat moot.
MinSpareServers 5 - ready for more action
MaxSpareServers 25 - keeping this smaller so that unused Apache resources can be lent to email services when needed.
MaxClients 256 - I don't want to run out of RAM!
MaxRequestsPerChild - 250 - we have awesome processors so I don't mind restarting processes.
I also turned off KeepAlive.
The site is static so I'm mostly concerned with reliability, robustness, and uptime, rather than worrying about performance flexibility.
I run a high volume server, 1,000,000 hits / day. Thats hits, not unique visitors. Approximately 10,000 visitors / day. Our site is mostly static. First off we have a huge server with 2GB of ram, then a RAID array with a good controller card, then these settings for Apache2:
# worker MPM [DEFAULT IF USE=threads]# StartServers: initial number of server processes to start# MaxClients: maximum number of simultaneous client connections# MinSpareThreads: minimum number of worker threads which are kept spare# MaxSpareThreads: maximum number of worker threads which are kept spare# ThreadsPerChild: constant number of worker threads in each server process# MaxRequestsPerChild: maximum number of requests a server process serves<IfModule worker.c> StartServers 25 MaxClients 400 MinSpareThreads 50 MaxSpareThreads 75 ThreadsPerChild 25 MaxRequestsPerChild 0</IfModule>
Mostly thanks to this post, and some trial and error:
Invalid command 'AuthMySQLEnable', perhaps mis-spelled or defined by a module not included in the server configuration
Setting up OpenSSL on Debian for Apache2
External Related Links:
Setting up mod_dav over SSL with MySQL authentication
Mod_dav provides file sharing not unlike Samba or AFP.
Mod_auth_mysql is an Apache module which provides for authentication via MySQL.
The combination of Apache, mod_dav, and ssl is an incredible alternative and in my humble opinion improvement to a setup with a VPN (openVPN, PPTP, or L2TP/IPSec) with a Samba or AFP share.