Barnettech Blog

This restored my Mac Book to a usable state while using the battery -- battery lasted 3 hours instead of 45 minutes

1. Turn off the computer.
2. Hold down Ctrl+Option+shift
3. While holding down these button, press and hold the power button as well.
4. Hold all buttons for at least ten seconds.
5. power back on the computer.

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

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

drush sa | grep -v @

I will be releasing the DROOGLE module shortly which integrates Drupal with GOOGLE DOCS and it also provides it so you can easily manage your Google account's users, permissions, 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

Here's a linkback for a nice guy who's made a db_query cheat sheet for Drupal 7.

http://www.drupaler.co.uk/blog/drupal-7-cheat-sheet-database/493

Also here is a simple drupal 7 query: