Finding duplicates in a MYSQL table

select name, count(name) as cnt
from term_data
group by name
having cnt > 1
order by cnt;

Did you get a nasty error from your Drupal 7 sitemap module that looked like this:

If your mac terminal application takes a long time to open you need to trim some log files:

cd /private/var/log/asl/

sudo rm *.asl

linkback: http://www.karan.org/blog/index.php/2009/08/25/multiple-ssh-private-keys

ssh-keygen -t rsa -f ~/.ssh/id_rsa.acquia -C "Key for my Acquia accounts"
touch ~/.ssh/config
chmod 600 ~/.ssh/config

~/.ssh/config looks like this :

Host *acquia*
  IdentityFile ~/.ssh/id_dsa.home
  User jbarnett

Host *babson*
  IdentityFile ~/.ssh/id_rsa.work
  User jbarnett
  Port 44787

Drush is of course the best way to manage your site, and here at Babson College we are utilizing multi-sites on the Acquia Cloud. These commands greatly simplify our account management across these many sites:

To run a drush command on all of your sites in a multisite

go to your drupal root directory ie: /var/www/html/babsondev/docroot

and then run

drush @sites user-create testuser
drush @sites user-password someuser --password="gr3@tP@$s"

this will create a user on all of your sites. To get a site list you can do

This screenshot reflects the versions of Droogle pre version 7.x-4x.  I will aim to post new screenshots of the 7.x-4x + versions.

Droogle has been promoted on drupal.org as a full project. It is being supported by myself and Babson College. We'd love your feedback, feel free to post to Droogle's issue que with any suggestions, bugs, etc.

I have this working, SSL is setup for Drupal 7

1.) At the bottom of apache2.conf file in /etc/apache2

#setup name based virtual hosting instead of IP based (JLB)
NameVirtualHost *:443
NameVirtualHost *:80

2.) In /etc/apache2/sites-available/default-ssl

find . -name .svn -print0 | xargs -0 rm -rf