I do not think there is a system wide method of turning on cddb lookup. In the programs I use that have cddb capability (e.g. Grip, Kover, K3B), I had to activate them in each program's preferences.