If you've upgraded to Leopard and suddenly none of your web sites work, it's because Leopard uses a newer version of Apache and the upgrade process doesn't copy your configuration files over. For an Apache newbie like me, the only thing I needed to do was to copy the contents of my /etc/httpd/users directory into /etc/apache2/users.
SOURCE: Apple Support Forums
SOURCE: Apple Support Forums
