Categories
business computer music personal

The $1K CD/DVD/LightScribe Replicator: The DIY Guide To Manufacturing Your Own Discs For Less Than $1 Each

This do-it-yourself replicator features eight Lite-On CD/DVD burners. By flipping the disc over you can burn images onto the top using the drive lasers.

I’ve slowly updated components of The $1K Home Studio over the last few years, but have never had a low-cost, DIY solution for disc replication. After playing with external CD burners and evaluating various proprietary hardware options such as the Aleratec auto-flip burner , MicroBoard tower replicators amongst many others, I decided that the current commercial solutions are nice, but most definitely overpriced. So I decided to develop my own solution. This custom-built behemoth is built from common off-the-shelf (COTS) hardware from Fry’s Electronics and inexpensive commercial software. It costs less to own than commercially branded replicators, and also functions as a normal desktop computer since it runs Windows 7 and Linux. (I took care to also buy a Gigabyte-brand motherboard that supposedly supports the OSx86 (“hackintosh”) project, but have had little success with the installation.)

Hardware

  • Intel i5 750 64-bit CPU. (Features 4 cores.)
  • 4GB RAM.
  • 8 x (yes, eight) Lite-On CD/DVD 5.25″ SATA burner drives.
  • Gigabyte motherboard with lots of SATA ports.
  • Add-on SATA card. (Most motherboards won’t have enough connectors, especially if you have 8 x burners plus 4 x hard drives. 🙂 )
  • Big-ass power supply. (The first one I bought wouldn’t even boot the thing. I put in a monster and everything started working.)

Software

The point of all these burners is to burn simultaneously to all of them, but Windows 7 and OS X cannot do this out of the box. Only a small subset of CD/DVD burning software on the market supports parallel burning, and some only seems to support multiple burners for specific types of burns. What’s worked best for me so far is…

  • Nero Multimedia Suite 10 for concurrent audio and data burning with multiple burners. You don’t have a lot of easy-to-use alternatives here, and I’ve also noticed a few glitches with Nero. Keep your eye out for sales here and you can pick up a copy dirt cheap.
  • Acoustica CD/DVD Label Maker for concurrent LightScribe replication across multiple burners. Again, not a lot of options here. The free software from LightScribe.com does not support multiple burners, though some vendor-specific bundles seem to. (LaCie’s LightScribe software in particular appears to support simultaneous LightScribe burns, and they also have a Mac version. I would have went with a Mac-based solution, but 8 x USB 2.0 drives probably would not work so well.)
CDs burned with LightScribe technology. Discs come in many different colors.

I decided to create all my replicated discs using LightScribe technology. This allows me to flip LightScribe CD-Rs upside-down in the burner and use the laser to burn custom graphics onto the top of the disc. I also made the command decision to use COTS cd sleeves instead of CD Jewel cases or slimline cases. The plastic ones are more expensive, always crack, and are pretty much useless from the start since most people seem to rip their CDs nowadays anyway. Sleeves protect the disc, come in many colors, are far less expensive, even cheaper in bulk, and perhaps best of all can be printed on directly though ordinary laser and ink jet printer.

The system runs Windows and Ubuntu. Additional drives are interchanged using hot-swap SATA drive modules.

System Pros

  • Inexpensive initial fixed cost of hardware parts and software licenses.
  • Inexpensive variable cost per disc since LightScribe labeling uses the drive laser instead of ink. There are no costly consumables to replace. (Ordinary LightScribe media purchased in bulk works great.)
  • Quick data, audio and LightScribe replication using 8 concurrent burners.
  • Doable by anyone capable of building of PC with a little time can build one.
  • Functions beautifully as a normal desktop computer.

System Cons

  • Not completely automated like some commercial units because disc loading, unloading and flipping (if using LightScribe) is a manual process.
  • Still uses CD-Rs. These are not the same as commercially pressed mass media discs, but a lot cheaper.
  • (This one is only applicable to audio.) I’ve yet to find inexpensive parallel burning software that can handle DDP images. (The standard in “Red Book” audio CD mastering.)
  • Since LightScribe labeling uses the drive laser instead of ink, disc labels are grayscale only. (Note: You have a lot of options in disc color, though, so it’s not a big deal. Just use your creativity.)

Replication Process Overview

Label four empty CD pancakes to manage the assembly line replication process. If you don't you'll get your disc piles confused!

My primary purpose for this buildout is to replicate audio CDs as quickly as possible for Sonic Binge Records: the awesome music production company. In particular, I need to quickly replicate a pancakes worth (usually 25-50) of audio CDs as inexpensively as possible. After much trial and error with the process, this is what I’ve found works best.

  1. Create final CD master image. (For me that’s using WaveBurner on a Mac. For replication purposes it doesn’t really matter as long as the master is good.)
  2. Take four empty CD pancake containers and label them “Blank”, “Burned”, “Labeled”, and “Ready” to create an assembly line process. You can of course save these for future jobs.
  3. Use Nero Burning ROM to replicate batches of 8 at a time. When they’re done, be sure to put them in the “Burned” stack so you don’t get burned discs confused with “Blank” discs.
  4. While they’re burning, create a square grayscale graphic for LightScribe burning. (Free label creator software is available, though anything like Photoshop works too. I usually use a combination of Photoshop and Acoustica.)
  5. Use Acoustica to label batches of 8 at a time. Each batch will take a while. Full-disc burns seems to take around 30 minutes per batch: much longer than the data/audio side of a standard CD-R. Moved discs to the “Ready” pile when they’re done. (Note: The “Labeled” pile is for discs that have been LightScribe labeled but not burned with data or audio. You can end up in this situation when using multiple computers to do burning.)
  6. While they’re burning, use your favorite document application to design your printed CD sleeves. I’ve started buying color variety packs in bulk packs of 300 to keep options high and costs down.
  7. Bulk print the entire order of sleeves in a single run. As long as you can set the size of the feeder tray, your existing feeder should work fine. (CAUTION: remember that the “window” is made of plastic, and can melt if exposed to heat. Think twice before trying your laser printer. 🙂 )
  8. Take discs from your “Ready” pile (as they finish getting labeled) and slip them into sleeves to create the final product, suitable for general distribution. The imaging lasering adds a great, distinctive touch, and of course you can get as creative as you want with the sleeves, too.
  9. Done! (aka beer time.)

Costs

  • Fixed: ~$1K for the machine build, with about $400 of that just for the burners. I reused/reposed parts from old junker machines where I could, and could have saved some money by buying online. I was in a rush and just went to the store.
  • Variable: Roughly $0.40 – $1.00 per disc, depending on the disc quality, packaging, ink etc. you decide to use for each project. (All things considered, the $0.40 version looks pretty decent!)

Closing Thoughts

If you’re a musician without computer skills I would not recommend attempting this project, but if you feel fairly comfortable putting together machines, it’s honestly not that hard. It’s just a PC, after all. (Disclaimer: I do have a degree in Computer Science and Engineering, so my perspective of “not that hard” may be a bit skewed.)

I hope you’ve found this rough how-to guide both inspirational and informative. It’s very useful to have a replication machine handy, and if you’re actively working with people on projects intend for distribution it’s a great investment!

Please use this comments section for all your general comments and questions and I’d be happy to address them. Thanks for reading!

Categories
business computer

Mini-Review: Meltdown: A Free-Market Look at Why the Stock Market Collapsed, the Economy Tanked, and the Government Bailout Will Make Things Worse


Meltdown: A Free-Market Look at Why the Stock Market Collapsed, the Economy Tanked, and Government Bailouts Will Make Things Worse by Thomas E. Woods Jr.

My rating: 5 of 5 stars
Meltdown is a evidence-based, academically credible, and brutally honest analysis of the causes and effects of economic depression faced in the United States since the early 1900’s. Thomas Woods’ almost adversarial opinion of the Federal Reserve is approached via many different approaches and data sources, as is his affinity of Austrian business cycle theory. (As opposed to Keynesian economics primarily seen in the U.S.)

For those with interest in macroeconomic theory or the effects of government intervention on both business and individual finance, this is absolutely required reading. Those with politically libertarian leanings will also find many of the facts presented within outright shocking. I personally finished the electronic version of this book with over 10 pages of highlights, and plan to continue following Woods’ work.

View all my reviews >>

Categories
computer

MacPort MySQL “Can’t find file: ‘./mysql/host.frm'” Error

I recently set up a new Mac OS X Snow Leopard laptop for software development purposes. After going through my usual MacPorts installation and installed MySQL using the following steps

  1. sudo install mysql5-server
  2. sudo cp /opt/local/var/macports/software/mysql5/5.1.44_0/opt/local/share/mysql5/mysql/my-medium.cnf /opt/local/etc/mysql5/my.cnf
  3. sudo -u mysql mysql_install_db5
  4. sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist

A few days past, and one day I notice that launchctl was loading the script, but `nmap localhost` did not show the the process listening on port 3306 as expected. I looked at the log file:

sudo tail -f /opt/local/var/db/mysql5/preston.local.err

..and noticed it was terminating with the following errors:

100331 12:05:30 [ERROR] /opt/local/libexec/mysqld: Can’t find file: ‘./mysql/host.frm’ (errno: 13)
100331 12:05:30 [ERROR] Fatal error: Can’t open and lock privilege tables: Can’t find file: ‘./mysql/host.frm’ (errno: 13)

100331 12:05:30 [ERROR] /opt/local/libexec/mysqld: Can’t find file: ‘./mysql/host.frm’ (errno: 13)100331 12:05:30 [ERROR] Fatal error: Can’t open and lock privilege tables: Can’t find file: ‘./mysql/host.frm’ (errno: 13)

After a considerable amount of grief I evertually discovered that the contents of /opt/local/var/db/mysql5/ need to be owned by the appropriate mysql user (in my case “_mysql”), but some files were being owned by the “root” user. After correcting all file ownership and restarting the service…

  1. sudo chown -R _mysql /opt/local/var/db/mysql5/
  2. sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5.plist
  3. sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist

Everything now seems to work fine again. Hope this helps!

Categories
computer music

Getting iTunes To Convert/Export/Bounce To Other File Formats

You’d think iTunes 9 would have a menu option to convert selected, non-DRM’d files to .MP3, .AAC and such. It doesn’t, but there’s a quick–if not silly–workaround to get iTunes to covert your tracks to a supported format.

Mac instruction for iTunes v9

  1. Open Preferences -> General -> Import Settings. Change the “Import Using option to the format to which you want to convert.
  2. Within iTunes, select the file you want converted.
  3. Under the “Advanced” menu, you should now see a “Create XYX Version”. Click it and your selected file(s) will be converted in the background while retainer your originals.
  4. Remember to change your import preference settings back to normal!

Done. 🙂

Categories
computer

Get Your Kindle’s PID In 10 Seconds

Rather than struggling with a bunch of old command-line scripts to calculate the Personal ID (PID) of your shiny new Amazon Kindle, I’ve released a super-freakin’-easy webapp to do it for you in a matter of seconds. No joke.

Simply visit http://kindletools.prestonlee.com, follow the instructions, and be sure to gift me a short novel to say “thanks”. 🙂

Update: See Jer’s post on the bigger process of converting Kindle books.

Categories
computer personal

Amazon Kindle 2 Review

Kindle 2 with M-Edge Leather Platform Jacket and optional e-Luminator 2 book light.

The Kindle 2 is my first commitment to electronic books and e-ink screen. I silently waited until several generations of eBook readers were on the market–including the Barnes & Noble Nook–before making the decision to commit to Amazon’s Kindle 2.

Physical Interface

The 6″ e-ink display that looks just like the paper of a novel you’d buy at the grocery store. Unlike computer LCD displays, the Kindle’s screen is reflective, making it easier you to read outside in natural sunlight, just like a real book.

The built-in keyboard is extremely useful, though a tad clunky feeling. It is built with physical buttons (as opposed to “soft” or “virtual” buttons used on devices like the iPhone), and takes some getting used to, especially when searching a book and navigating a variety of different screens and dialogs. Despite a bit of awkwardness that is difficult to verbalize, it’s invaluable to have these controls, especially for searching and note taking.

Internet
One of the coolest features is the built-in 3G cellular radio that is tightly integrated with the Kindle Store and works similarly to the “One-Click Checkout” feature offered by Amazon. You can usually download a sample chapter before purchasing, and of course “upgrading” from samples to full copies is very straightforward and easy.

For individual subscription charges you may also subscribe to a gamut of periodicals and blogs. While it may seem strange to offer paid subscriptions to content you can often view for free online, the Kindle versions of the content are repackaged to support the navigational structure and user interface of the physical devices, provided a more fluid experience when bouncing between your regular reading material.

Using the built-in keyboard and 4-way joystick-like device, you can even use a built-in web browser to surf the internet in a bind. Surprisingly, there are no monthly services charges for this ability, though the device clearly is not designed for web surfing. Even with free 3G service you’ll usually use your phone, laptop etc. instead.

Formats

All purchases (including subscriptions) are automatically delivered wireless to your Kindle. I’ve generally found Amazon’s “delivered in less than 60 seconds” claim to be true: even when cruising through a barren Nevada desert.

You have the ability to read your own .PDF, .TXT, .MOBI, .DOC and other documents, and are provided a free service to convert your documents to the Kindle’s native .AZW format. Note, however, that .PDF files, while displayed, cannot be re-layed out to fit the size and orientation of the screen. Constantly having to zoom in and out is annoying, so you’ll often want to convert to .AZW before transferring content to your Kindle.

Synchronization

At time of this writing, Kindle content can be managed and accecssed in four ways, the…

  • Kindle itself.
  • Kindle website.
  • Free iPhone application.
  • Free PC application.

Content purchased using the Kindle Store–via any of these interface–can freely sync amongst them, assuming they are all tied to the same Amazon account. After a piece of content is purchased, it is automatically backed up on Amazon’s servers, allowing you to delete it from the device today and easily restore it (even to a different device) sometime in the future.

Note that documents you load onto the Kindle (via a USB connection to your Mac or PC, or wirelessly for a nominal charge) will not be backed up to Amazon’s systems, nor can they be automatically synced between interfaces. It would be fabulous to have Amazon back up my own Kindle content, though since it wasn’t purchased from Amazon it seems reasonable to not offer this service. (Note to Amazon: I would pay for this feature!)

Audio

Kindle 2 with M-Edge Leather Platform Jacket and optional e-Luminator 2 book light.

The text-to-voice software turns out to be surprisingly useful. Some words, as you would expect, are consistently mispronounced and a tad distracting, but not so much as to detract from its use. Using both the built-in headphone and built-in speakers, you’ll find yourself being read to in the car, walking around campus, the grocery store.. pretty much anyway you’d normally listen to music. Mispronounced words that are a tad annoying:

  • “idea”. It is being pronounced EYE-DEE-AYE.
  • “live” as in “alive“. It is always being pronounced as in “olive“.
  • Some abbreviations that look like Roman numerals. I’m sure this is a hard one to fix, but it’s nevertheless distracting to have the sentence, “I was at the IV [pronounced EYE-VEE] office yesterday.”, but hear “I was at the ONE-FIVE office yesterday.”

There is also an “experimental” MP3 player built in. It is in no way even comparable to the interface or features provided by iPods, but nevertheless a “nice to have” feature. I use it rarely since I already carry around an iPhone and use iTunes for media management.

Additional Software Features

Online access to bookmarks, highlights and notes of purchased books.

Things you won’t be able to live without once you get used to them:

  • Search. One of my biggest issues with traditional, printed texts is the lack of a trivial way to search them. On the Kindle, you just start typing and hit the enter key. What’s even better is that you can easily switch the search index from the current book to sites like Wikipedia.
  • Built-in dictionary. Just position the cursor before a term, and a small footnote will appear on the bottom of the screen. (Anecdote: I just found myself physically poking a word in 10-pound textbook, as if some dialog were to materialize in the air above. As I chuckled to myself I realized that I was now addicted to eBooks, and was unlikely to ever go back.)
  • Bookmarking. The concept of a “bookmark” is only slightly different than in the physical world. Since content in the electronic world is usually defined separately from it’s presentation, layout is based on personal preference (bigger vs. smaller text), screen size (Kindle 2 vs. the larger Kindle DX), font (Helvetica vs. Arial), orientation (portrait vs. landscape), and numerous other factors. This make the concept of a “page” obsolete, because chapter 3 of a new book may appear on page 47 for one person and 32 for another. Instead, we now have “locations”, which assign a sentence or paragraph a number that can be looked up regardless of how the content gets layout out.
  • Notes.  If you like to “write in the margins” of traditional books, you can do effectively the same thing on the Kindle. Just move the cursor to wherever you want your note, click the directional-pad button, type your note, and then click the button again. You’ll now see a handy interactive superscript symbol at the insertion point. These notes also get written to a plain text file that can be read when the Kindle is plugged in via USB, at “documents/My Clippings.txt”
  • Highlighting. I love taking a bright yellow highlighter to a good non-fiction book. You can not only do effectively the same thing on the Kindle, but this metadata also becomes saved in a new file that is synced back to Amazon’s servers, allowing you to easily browse your highlights, notes and bookmarks via the web, even without your Kindle handy.

Cons

Home screen of the Kindle 2. Displayed: several purchased books and a variety of "samples" from the Kindle Store.
  • Purchased are DRM’d, and cannot (yet) be shared. I waited until the release of the Nook to make a purchasing decision because of B&N’s claim that you would be able to “loan” purchased content to friends, but the feature is, in my opinion, way too restrictive to be a prime selling point.
  • Software feels clunky, especially for someone accustomed to lots of intuitive Apple-designed GUIs. 🙂
  • Screen is slow to update, though none of the other readers on the market seem to be noticeably better.
  • Does not come with a case.
  • Keyboard could be much better.

Conclusion

While not without its flaws–most notably slowness of the screen to update–I love the Kindle and keep it with me whenever possible. For me, the Kindle is more than just a gadget. It represents a fundamental change in the way I interact with written knowledge, and resets my expectation accordingly. I fully expect large-scale consumer transition to e-ink-style display to be rocky due to nasty web of vendors, publishers and authors all vying to dominate the market early, but for the avid readers out there, it’s worth it.

Categories
business computer

SEO Is Not A Product

One of my biggest business frustrations in 2009 has centered around Search Engine Optimization (SEO): peoples fundamental misunderstandings of what SEO is, what it theoretically accomplishes, and the large number of shysters scaring businesses into pursuing activities not nearly as important as they are made out to be. Inquires usually go like this..

Preston,

My business–ACME Tires–has a basic website for customers with our logo, contact information and such, and am interested in generating more business out of it. I have asked a few people for recommendations and am now talking to several SEO providers that can provide service ranging from $100-$1,000/month. What do your SEO services cost and what guarantees do you make? (I need to be #1 on Google.) Thanks,

Alice

My initial natural inclination is to leer at my computer monitor and internalize a snide response, however, it’s not the customers fault for having a convoluted understanding of SEO, so I often send a polite, brief response, from a science and engineering standpoint. At this point, the recipient usually dismisses the information and goes about spending 1000% more than they should on services. Here’s the lowdown in plain English..

Legitimate Motivations For SEO

ACME stands to see legitimate value in several key ways from having their web presence tweaked by an “SEO expert”. Notably:

  • Higher rankings in Search Engine Results Pages (SERP). When I search for “tires phoenix, az”, ACME wants to come up as the #1 organic search result. This increases visibility over competitors and thus increases the liklihood that the searcher will click on the ACME page synopsis (and be directed to the ACME website).
  • Low Advertising Costs. When ACME uses Google AdWords to pay for ad placement in search engine results pages, Google must determine an appropriate cost for a click-through event on the ad. (In other words, ACME will pay Google whenever a user click on an advertisement and is directed to the ACME website.) The algorithms for making the cost decision are not public information, but are based partly on relevance of content. If Google thinks ACME Tires is the best thing since sliced bread, costs will be lower than if Google thinks ACME is a bakery or jeweler.

Illigitimate Terminology

The very legitimacy of the term and notion of “Search Engine Optimization” is debatable. The core function of a search engine is to guide people to content in such a way that the “right” resources can be found using brief, relevant terms. The job of the ACME Tires website is to provide information and services to ACME customers regarding tires. It is not ACME’s job to be an expert in the search engine marketplace. It could be argued, then, that the notion of SEO is a moot point, as it should be the job of the search engine vendor to figure out how to best index and present content in an optimized way. This being said, the Developer of the ACME website does have a list of technical tasks that need to be done to assure that content is well indexed and legitimate best practices are used–which I will not go into here–to put the most important site concepts at the forefront of search engine visibility. But we should NOT think:

  1. the ACME website is part of the search engine itself,
  2. the site cannot be “picked up” by search engines without extensive blackhat techniques, or most importantly,
  3. it is ACME’s job to make sure search engines (Google, Bing, Yahoo! etc.) function properly.

The term “optimization” as used by most SEO companies can be better described as “gaming”. Search Engine Gaming (SEG) is a more accurate term than SEO because it reflects that the intent of site tweaking is to gain marketing favor, and improving content from the standpoint of the consumer is of secondary concern, if at all. From this point forward I will refer to activities that both improve marketing value and improve content consumability as “SEO”, and activities that improve marketing value but are indifferent to or negatively impact content as “SEG”.

Blackhat SEG Shysters

An unfortunate number of sleezeballs sell ethically questionable “SEO” services. This is not to say that there isn’t technical work being done nor that they cannot show marketing results, but they choose to do so in ways that make reasonable engineers cringe in disgust. No definitive list of “black hat” activities is completely agreed upon, and as with issues like U.S. health care, it’s a highly subjective topic wherein opinions greatly vary. Unfortunately, those that have the most to gain (vendors) are often leading the debates and giving the seminars, which is skewing public perception of SEO and what is/isn’t necessary. Common activities that I consider black areas (or grey, at best) include:

  • Keyword Stuffing. One of the easier ways to increase SERP placement is to cram as many important keyword and search phrases into your website as possible. I personally define keyword stuffing to be, “Page copy intentionally packed with a set of repetitive phrases to the point of becoming frustratingly redundant, difficult to comprehend, or otherwise awkward to read.”
  • Referrer Parsing. Whenever you click the ACME ad, the server running the ACME website knows the website from whence you came. When you come from a search engines, the site may be able to determine the search terms you used to find the link. This detection can all happen before the ACME website is rendered, which means when you search for “tracktuff tires, az” and click through to the ACME website, the ACME webserver can dynamically generate a headline reading “TrackTuff Tires Now 50% Off In Arizona!”, regardless of how relevant the “tracktuff” name or brand actually is to the ACME website. Now, for some reason, all the SEO consultants I’ve met that are doing this seem to think they invented it. (Seriously, I even know one guy that’s trying to get a patent for it.)
  • Automated Article Submission. Databases of articles are a great place for users to do general research and discovery. If you’re automating “article” submission to hundreds of databases simultaneously, however, you’re submissions will almost certainly be little more than biased PR and marketing content oriented towards getting links to ACME. Actually, there are many “article databases” that fully acknowledge and support this as a way to increase visibility of their own ads.
  • Automated Link Generation. Business adopting social media as a form of customer service and marketing often complain of the time required to pursue the natural creation of inbound links. This makes the business very receptive to vendors claiming to have solved the “social media time commitment problem” by automating responses to social networking and social media comments. To an engineer, doing so obviously misses the whole point of social media/social networking technology and is another form of spam. Additionally, the value of doing this on blogs and forums is next to nothing (due to the rel=”nofollow” attribute). Plus, the best links will generally come from partner websites and large-scale references in protected, reviewed publications such as journals and newspapers, which cannot be automatically generated for obvious reasons. In short: it’s pretty safe to consider automatic link generation a form of spam.
  • Email Spam. This is obviously a Bad Thing to do, but that doesn’t stop tons of vendors from doing it legally. The U.S. CAN-SPAM act does not require people to explicitly opt-in to be put on a mailing list, given they have some form of “relationship” with the company. Also, certain types of organizations–notably religious and political–may be exempt from some of these laws entirely.

Stupid Guarantees

A SEG company making a “#1 on Google in 24 hours!”-type claim is almost certainly using blackhat techniques and/or getting you prime placement for a term so long and specific to the point of being useless. For example, it shouldn’t be surprising that “acme tires phoenix arizona” would turn up the correct page first on a search engine, because:

  1. the intent of the searcher is almost certainly to find this one specific business website, and
  2. there are probably only a handful of resources on the web that match these terms well.

A search engine like Google might even return a map to the store in the first results page. Getting #1 placement for “tires arizona”, however, will be much more difficult since the search phrase will match many more web resources than the first, and, from the perspective of a small business owner, some of the competitors will have the time and money to put magnitudes more content online, and supplementing that content with marketing campaigns and PR.

Closing Thoughts

SEO/SEG is a technologically and ethically grey area, and vendors not defining clear boundaries of what they do for your money should generally be avoided. Do spend some effort making sure copy and syntax of website pages are thoroughly written, well-designed for usability and structured for search engine comprehension. But instead of paying a monthly service contract to an “SEO guy”, put that money into continued development of content that will please existing customers and help attract new ones. Pay attention to your placement in search engine results, sure, but at all times, stay focused on building value and meaningful business relationships over click-through rates and SERP rankings.

Categories
computer music personal

Why Amateur Musicians Use Macs

While discussing tonights U2 concert in Phoenix, I got into a HUGE argument with a Linux user over why amateur musician/producers would have to be mentally challenged for *not* making a Mac their first investment over Linux and Windows. Since the proof is in the ear pudding, I wrote, recorded and mixed this U2-inspired acoustic/vocal jam (aka “rip off”) in 4 hours using only a 2.4GHz MacBook w/4GB RAM, OSX Snow Leopard, GarageBand, *built-in laptop microphone*, iPod earbuds, ghetto-fabulous Fender acoustic guitar and 2 vodka tonics. (In other words no fancy microphones, A/D converters or other hardware.) The noise at the beginning and end is the sound of the MacBooks fan running at full speed, but other than that (and some really sloppy pitch correction patchwork) I’m not aware of any software that ships with Vista, 7, or any modern Linux distribution that can do anything REMOTELY close out of the box in more-or-less the same amount of time. If you think otherwise, prove me wrong!

Download “It’s Alright” MP3.

(Truthiness: I cheated *slightly* by jumping into Logic Pro 9 for the pitch correction part since I was lazy and didn’t want production to take more than 30 minutes, but that wasn’t technically necessary!)

Categories
business computer

Google AdWords Account Access: A Cacophony Of Stupid

If I haven’t blabbed your ear off already, OpenRain has a small business web presence product called the Online Business Platform. It’s a big deal as it’s fairly unique in many different ways.
Anyway, the the upper service level options include consulting and advisement on advertising with Google AdWords, which means we generally need access to the clients AdWords account to monitor progress and such.
The problem is that AdWords accounts have the idiotic restriction of allowing a given email address to be tied to only one AdWords account. In other words, preston.lee@example.com can be granted access to OpenRain’s Adwords account, but not client accounts nor other side-project accounts. Google Analytics, on the other hand, allows for a single email address to manage multiple Analytics accounts in a much saner manner. Considering the amount of revenue Google generates from paid Internet marketing, accessing multiple AdWords accounts is a 7-layer stupidburger with extra retard sauce. I’m sure there’s a wonderful technical rationale that generates rainbows of technical applause, but as a user I couldn’t care less.
To answer the “How do I manage multiple AdWords accounts?” question, Google created My Client Center (MCC): essentially an AdWords account management aggregator. The kicker? To create an MCC account–and yes, it’s a separate account–you can’t use the email address for the account(s) you’re trying to aggregate. We ended creating a silly AdWordsIsStupid@example.com email group and use that email address to create the MCC, which is turn gets granted access to your different AdWords accounts that are, again, all tied to different email addresses.
So when I say AdWords account access is a cacophony of stupid, I mean it. N+1 email addresses required-level stupid.

If I haven’t blabbed your ear off about it already, OpenRain has a small business web presence product called the Online Business Platform. It’s a big deal as it’s fairly unique in many different ways.

Anyway, the upper service-level options include consulting and guidance on advertising with Google AdWords, which means we generally need access to the clients AdWords account to monitor progress and such.

The problem is that AdWords accounts have the idiotic restriction of allowing a given email address to be tied to only one AdWords account. In other words, preston.lee@example.com can be granted access to OpenRain’s Adwords account, but not client accounts nor other personal side-project accounts. (Google Analytics, on the other hand, allows for a single email address to manage multiple Analytics accounts in a much saner manner.) Considering the amount of revenue Google generates from paid Internet marketing, maintaining access to multiple AdWords accounts is a 7-layer stupidburger. I’m sure there’s a wonderful technical rationale that generates rainbows of technical applause, but as a user I couldn’t care less.

To answer the “How do I manage multiple AdWords accounts?” question, Google created My Client Center (MCC): essentially an AdWords account management aggregator part of an optional “Google Advertising Professionals” program. The kicker? To create an MCC account–and yes, it’s a separate account–you can’t use the email address for the account(s) you’re trying to aggregate. We ended creating a silly AdWordsIsStupid@example.com email group, and used that email address to access the MCC dashboard, which is turn gets granted access to your different AdWords accounts that are, again, all tied to different email addresses.

So when I say AdWords account access is a cacophony of stupid, I mean it. N+1 email addresses required-level stupid. Bad Google!

Categories
computer

Recovering A Corrupt OpenLDAP Database On OSX Server

Recovering A Corrupt OpenLDAP Database On OSX Server
Last night we noticed some services provided by an OSX Leopard Server instance were not working correctly. The iChat, AFP and Web services were not authenticating. In Server Admin.app, the “Overview” tab of the Open Directory service reported…
LDAP Server is: Not Running
Password Server is: Running
Kerberos is: Not Running
Looking at the server error logs through Console.app, the following was occuring every 10 seconds..
com.apple.launchd[1] (org.openldap.slapd[27382]) Exited with exit code: 1
com.apple.launchd[1] (org.openldap.slapd) Throttling respawn: Will start in 10 seconds
The slapd daemon appeared not to be starting. Jumping to the command line, I tested the configuration using the `slapd -Tt` command.
core:openldap admin$ sudo /usr/libexec/slapd -Tt
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
bdb(dc=openrain,dc=com): PANIC: fatal region error detected; run recovery
bdb_db_open: Database cannot be opened, err -30978. Restore from backup!
bdb(dc=openrain,dc=com): DB_ENV->lock_id_free interface requires an environment configured for the locking subsystem
backend_startup_one: bi_db_open failed! (-30978)
slap_startup failed (test would succeed using the -u switch)
http://discussions.apple.com/message.jspa?messageID=9548971
With a little research, I concluded that..
The OpenLDAP database had been corrupted, and..
The `slapd_db_recover` tool (as present on some Linux installations) is instead named `db_recover`. Ah!
After carefully backing up the /var/db/openldap folder, I ran the recovery tool and re-tested the configuration..
core:openldap admin$ sudo db_recover -h /var/db/openldap/openldap-data/
core:openldap admin$ sudo /usr/libexec/slapd -Tt
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
config file testing succeeded
The errors in Console.app stopped, and the Server Admin.app panel started reporting..
LDAP Server is: Not Running
Password Server is: Running
Kerberos is: Not Running
I had to restart the AFP, iChat and Web services on the machine to get everything working again, but all seems well now.
Last night we noticed some services provided by an OSX Leopard Server instance were not working correctly. The iChat, AFP and Web services were not authenticating. In Server Admin.app, the “Overview” tab of the Open Directory service reported…
LDAP Server is: Not Running
Password Server is: Running
Kerberos is: Not Running
Looking at the server error logs through Console.app, the following was occuring every 10 seconds..
com.apple.launchd[1] (org.openldap.slapd[27382]) Exited with exit code: 1
com.apple.launchd[1] (org.openldap.slapd) Throttling respawn: Will start in 10 seconds
The slapd daemon appeared not to be starting. Jumping to the command line, I tested the configuration using the `slapd -Tt` command.
core:openldap admin$ sudo /usr/libexec/slapd -Tt
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
bdb(dc=openrain,dc=com): PANIC: fatal region error detected; run recovery
bdb_db_open: Database cannot be opened, err -30978. Restore from backup!
bdb(dc=openrain,dc=com): DB_ENV->lock_id_free interface requires an environment configured for the locking subsystem
backend_startup_one: bi_db_open failed! (-30978)
slap_startup failed (test would succeed using the -u switch)
With a little research, I concluded that..
  1. The OpenLDAP database had been corrupted, and..
  2. The `slapd_db_recover` tool (as present on some Linux installations) is instead named `db_recover`. Ah!
After carefully backing up the /var/db/openldap folder, I ran the recovery tool and re-tested the configuration..
core:openldap admin$ sudo db_recover -h /var/db/openldap/openldap-data/
core:openldap admin$ sudo /usr/libexec/slapd -Tt
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
overlay_config(): warning, overlay “dynid” already in list
config file testing succeeded
The errors in Console.app stopped, and the Server Admin.app panel started reporting..
LDAP Server is: Running
Password Server is: Running
Kerberos is: Running
I had to restart the AFP, iChat and Web services on the machine to get everything working again, but all seems well now.