Archive for the ‘technology’ Category

Google API’s and Mac

July 7, 2008

I have an old iMac that I’ve been using as a server. Because I like Linux, and because it was easier to configure LAMP (Linux, Apache, MySql, PHP) than the similar components in OS X, I installed Kubuntu 6.06 on it (I’ve always liked the KDE desktop better than the Gnome desktop, which is the default for Ubuntu). Everything was fine until I decided I wanted to try out a Google API.

Google APIs require PHP 5.1.4 or higher (actually it was needed for the Zend engine, which is required for the Google API). But Ubuntu 6.06 (and Kubuntu 6.06) didn’t have upgrades to PHP 5.1.4. After a lot of trials and failures, I decided to fall back on Apple’s OS X and install MAMP (Mac, Apache, MySql, PHP). This particular machine could only take OS 10.3.* on it, which limited the MAMP I could use. But it included PHP 5.1.6, so I was happy. For a while.

I got everything up and running again, and even figured out how to get local network access working. Then I got back to the Google API. The first step, with MAMP, however, was to secure it, since the default install is with user “root” and password “root.” So far, that wasn’t a problem since MAMP on this computer was only accessible on the local network, firewalled from the Internet. But using a Google API requires access to and from the web.

The MAMP application has a FAQ page, accessible from the start page, that looks really helpful, but isn’t. You can get there by clicking in the FAQ button at the start page:

MAMP start page

Of course, the part about which versions of the included programs are installed is helpful. But I had already checked that before I downloaded MAMP. It’s the part right below that, under the “How can I change the password for the MySQL database?” that is unhelpful.


First of all, mysqladmin is not in that location (/Applications/MAMP/bin/mysql4/bin/mysqladmin). It’s in /Applications/MAMP/Library/bin. The php config file location is closer to what’s listed: /Applications/MAMP/bin/phpMyAdmin/

Second, trying to run the suggested command in tcsh got me nowhere. It turns out the default shell was changed to bash in OS 10.3, but upgrades (which this is) keep tcsh as the default. Fortunately, bash is available, but the default has to be changed in the terminal preferences.

So, just to make sure bash is really there, go to the /bin directory in the terminal (using the Finder will just show the documentation):

bash in the Finder

Change the directory to root level by typing “cd /.” Then type “cd /bin” to get to the /bin directory. Then type “ls” to list everything in that directory (see bash listed in the screenshot):

While the terminal is open, go to the Terminal preferences:


Notice the path listed is for tcsh:

tcsh set

Change it to /bin/bash:

bash path

Close the Preferences window, quit the Terminal application, and relaunch it. bash will be at the top of the Terminal window instead of tcsh now.

Now running the command listed in the FAQ page (with the path modification) will change the password in MySQL.  But before you actually press the Enter key to run the command, highlight the new password and copy it using the edit menu at the top of the screen.

/Applications/MAMP/Library/bin/mysqladmin -u root -p password NEWPASSWORD

(where NEWPASSWORD is the password it is to be changed to). The php config file will also need to be edited. I have eMacs on this machine, which worked nicely.  Don’t try to do it in Text Edit.  That will not work nicely at all.  Open the file (in MAMP’s phpmyadmin folder) in a code editor like bbedit or emacs. Find the lines

$cfg['Servers'][$i]['user']           =   'root';          //MySQL user
$cfg['Servers'][$i]['password']       =   'root';         //MySQL password

Replace ‘root’ in the password line with the one you copied. Save the file and close it.

Now, according to the MAMP faq page, it’s finished. Not.

It turns out there’s also a couple scripts to change in MAMP, documented over on network0.  There’s also a handy section on securing MAMP itself by password protecting the htaccess folder using an online .htaccess password tool (  So now that I’ve got it locked down it’s time to figure out how to open it up for Gdata on that Google API.  🙂

Libraries and Web 2.0

May 17, 2008

The Public Library of Charlotte and Mecklenburg County started a learning program for its employees a few years ago called 23 Things. It was intended to help people learn about new Web technologies that have changed the way we interact with the Web. It was evidently successful, and other libraries followed suit, using the formula and exercises set out by the Charlotte and Mecklenburg County Library.

Their site says that (as of May, 2006) there are over 200 libraries who are using their Web 2.0 (23 things) learning tool. It’s a pretty neat set of exercises. But I have some suggestions for anyone in a library thinking of implementing this program.

  1. Don’t have all your employees sign up for Gmail to be able to use Blogger (which is now owned by Google). They can get a Blogger account with any active e-mail address. When Google sees 300+ or 100+ or even 50+ e-mail accounts being generated, and accessed, from the same IP address, and Blogger accounts instantly created with those accounts they’re going to think one thing: Spammers! Actually they aren’t doing the thinking, they set up bots to capture just those types of events, so they don’t have to think about it. Once you’re flagged as a spammer, forget trying to get the e-mail account unblocked.
  2. Unblock the content you want staff to be able to access. This would be a good time to take a closer look at just what your filter is blocking and whitelist those inocuous sites you want the staff to be able to play with.
  3. A lot has happened since 23 Things first appeared. If you are going to encourage learning technology, don’t limit the discussion and exercises to old technology. Do a little research, hang out at technology conferences, follow technology feeds, talk to a tech-savvy person, and find out what is current and what is coming down the pike. Then change or add to the discussion to make the exercise current and relevant.  Seriously.  Others have already made changes.  You can, too.
  4. If you haven’t already, read The Cluetrain Manifesto, available online or in print.  This really is an absolute must for administrators, whether you’re doing the 23 Things or not.

And, of course, you deserve great commendations for taking this step into Web 2.0.  Welcome!

Too much marketing and not enough meat

May 8, 2008

A message to the SeniorServ list from Allan Kleiman alerted me to BigScreenLive. Since I’m always interested in what’s available for older adults, especially the ones with limited computer experience, I had to instantly check it out. Now, the upfront disclaimer here is that I haven’t actually tried it out yet, but I do see a few problems right off the bat.

The first problem, which instantly affects their credibility with me, is when they state, right on the front page:

Our goal is to make computing effortless and enjoyable. While our software runs on any PC, we also recommend hardware to make it easier.

but on the Software and Hardware page, they state,

To get started, you will need:

  • Access to a computer with Microsoft Windows XP or Vista. [emphasis mine]
  • A monitor resolution of at least 1280 x 800. The experience is optimized for a resolution of 1280 x 1024, which is most 17 inch or larger monitors.
  • A high-speed internet connection.

People are aware today (yes, even the Seniors) that PC does not necessarily mean a Windows machine. Let’s have a little truth in advertising here, please.

But even larger problems loom. Who, exactly, is the site for? Children of older adults? Retirement communities? Older adults themselves? Older adults themselves range from very computer savvy to totally clueless (and generally content to stay that way). The computer savvy ones, of course, wouldn’t even look at the site; neither would the totally clueless. That still leaves a wide range of computer users, some who are already doing the things BigScreenLive wants to introduce them to, some that are struggling to learn even the basics just to be able to do the things on BigScreenLive, and some who are frustrated by the very things BigScreenLive offers to help with.

I suspect the target audience is children of older adults: the ones who call me about signing up their parent(s) for computer classes. For this group, the site looks the most inviting and promising, because this is a group that is already fairly comfortable on computers, and that wants their parents online also, but without the frustrating computer problems older novices face. The marketing makes it look like the perfect solution. Will its marketing be successful? Probably so, with enough money. I keep thinking of how many people continue to use AOL.

Whether it is a good product is another question, however. From looking through the site, and watching its tutorial, it is evident that older novices would need training just to use the program (for example, they have to know how to enlarge the text themselves). The e-mail program, while fairly basic, will definitely be confusing to novices. It boasts “Easily upload digital photos to the Family Album” (emphasis theirs). Easy, maybe, for the adult children, but not for the older novice, without some training (which is the whole problem to begin with). I think the product would be really useful for about 2% of Seniors wanting to use the computer. But I think far more will be “given” a subscription, with little hope of actually using it.

Code4Lib conference

February 23, 2008

I am heading off to another conference, this time to learn instead of teach. Code4Lib 2008 is in Portland, Oregon, next week. I’ll be posting here from the sessions.

If anyone is interested in stacking the deck for next year, I’m not above a shameless plug for a vote for South Florida for next year’s conference. If you have a login account at, go here to vote (note, some firewalls block the port in this url – leave a comment here if you are having problems). If you don’t have a login account at the code4lib site, you can get one here.

Connecting the Disconnected: Tip #9

February 22, 2008

My dad’s advice: It’s hell getting old. Don’t do it.

Two very significant things are happening this century. First, Americans are living longer than any previous generation, so we are all discovering, directly or indirectly, the handicaps that come with old age. Second, computer technology has become truly mainstream, catching a whole generation off guard. Consequently, computer illiteracy has become one of those old age handicaps, and it is acutely felt by those who are otherwise functioning extremely well in society.

The older generation sees their grandchildren interacting with all kinds of computers with ease, yet they have difficulty just getting their heads around some of the most basic concepts like menus and scrollbars. I haven’t kept track of how many older adults I have talked to about computers, but I’m sure if I had a dollar for every time I heard the phrase “I feel so stupid” I’d be as rich as Bill Gates.

I repeatedly tell members of the older generation they are not stupid, they are inexperienced. They wouldn’t think of themselves as being stupid because they can’t play a piccolo or speak Swahili. Neither should they feel stupid because they can’t use a computer…yet. Did they learn to read in a day or a week? How long were they taught penmanship? ( “Oh! Years!”) And that was when they were young, like their grandchildren.

Learning to use a computer is doable, no matter how complicated it looks to them. But a big factor in their success is their attitude. In addition to making it easier for them to learn, it is important to counteract the self image they come in with by reminding them that they are learning, that it is not as hard as they imagined, and that they can do it. It is a wonderful thing to see their faces brighten as they realize they have learned something, and therefore are not stupid after all. As their attitude and self image changes, barriers start coming down and they pick up more determination.

Tip #9: Encourage them. Not just with positive reinforcement, but with active encouragement that reminds them what they have accomplished.