I used logrotate for Apache as well, but if you're running an SSL web-site and your certs have a passphrase you can't restart Apache automatically from logrotate. If you don't restart, the log gets rotated but your output can end up going in the old log and the new one doesn't get the log data.
In this case I use the following:
Code:
CustomLog "|/usr/local/apache2/bin/rotatelogs /var/log/httpd/access.log 604800" combined