The database gods are laughing at me. This time, the mysql database for my blog fell over. Died. Unresponsive. It was an ex-database. Pining, as it were, for the fjords.
The blog dropped offline for an hour or so, and when it eventually came back, there were all kinds of scary database error messages being spewed into the log. I took a closer look, and the Drupal “cache” table was wedged and corrupted. Thankfully, it’s just a cache, so I nuked the table and recreated it fresh. Easy peasy. I’ve got lots of backup snapshots, so it would have been almost as easy to restore any other table, but with the potential of lost content (posts and/or comments).
I’ve been following the activities of educators and ed-tech folks in Second Life. It seems like it could be a really compelling virtual environment to help enhance online learning, by providing a shared quasi-physical face to face venue for distributed groups that wouldn’t otherwise have one.
The amount of effort and care being put into these virtual places is stunning. The architecture is impressive, and the potential to create your own regions is compelling.
I’ve been struggling with this for what feels like months. On a project, we’re using a third party hosting provider, who offers us space on a managed server, complete with everything we need to run Drupal in a shared hosting environment. We’re running a copy of Provisionator on the server to help us deploy lots of Drupal sites easily.
Here’s where it gets messy. We can create new databases just fine, but importing a .sql file takes for freaking ever. Imports that take 3 seconds on my Powerbook can take 90 - 300 seconds on this server. Running the import on a dual G5 XServe with the same version of MySQL finishes the job in about a second.
Last month, while on vacation at a lakeside cabin in BC, I received an email asking permission to use one of my photos on Flickr for a magazine cover. “uh, sure? it’s creative commons, so have at ’er. Can I have a copy?”
I got my copy today. Is that ever cool. It’s for a petroleum industry magazine “The Negotiator” (sounds like a movie starring Clive Owen or the like), and lo and behold, right on the front cover, is my photograph:
populate database with selected mysqldump template file
copy template site directory (with settings.php, files, modules, themes)
modify settings.php as needed
create symlink to expose Drupal via Apache for the new site (as a subdirectory of a server, currently)
add a new record to the database, describing the site
list all records in the Provisionator database table
It’s got a lot of room for improvement, and more than likely needs some tightening down for security and Doing It The Right Way, but it works. It also currently assumes MySQL, and a very specific shared hosting pattern where Drupal isn’t in wwwroot itself, but is exposed by adding multiple symlinks within the wwwroot directory.
I bought my Canon Digital Rebel XT back in June, with the timing of the purchase a direct result of Canon Canada’s $100 rebate offer. I bought the camera at that time specifically because of the additional rebate. Otherwise, I would have likely held off a month or two, probably waiting for the release of the XTi. (an aside on the timing - I actually jumped the gun, buying the camera 2 weeks too early to be eligible for $400 back from work, so actually lost $500 in rebates and benefits because of the timing - that’s almost half the price of the camera)
Since we switched to Drupal to power the department website recently, we’re able to have RSS feeds to keep up to date on stuff as it gets added to the site. It hadn’t been exposed previously, but I just took a few minutes to expose 3 of the “main” feeds for the site.
I also used my blog within the site to describe what I’d done. My first non-hello-world blog post on our site (although only marginally non-hello-world, but still, it counts).
I’ve been involved with a shared Drupal hosting project with BCIT and BCCampus. Part of it is based on an easy way to create new Drupal sites via a web interface, complete with database creation and population, Drupal site directory creation and settings modification, symlink creation to make the site visible to Apache, and management of a Drupal Sites Manifest table to keep track of sites.
At first blush, it seems rather similar to both sympal_scripts and the Drupal 5 installer, except for the management of a sites manifest table, and creation of the symlink to expose the site to Apache in a shared setting.
I just finished the first pass at “fixing” the TLC website. Now, it’s not nearly as slick or effective, but is chock full of compliance. mmmm…. compliance… please, sir? may I have another?
<img src="/files/images/tlc_ucalgary_b.preview.png" title=“TLC Website - with UCalgary " class=“image preview” data-b”="" data-template"="" width=“500” height=“341” alt=“TLC Website - with UCalgary " />TLC Website - with UCalgary “B” template
During this latest sustained spam attack, this blog has been a little less responsive than I’d like. I’m thinking it’s related to Akismet’s need to talk to the mothership to verify each comment. As an experiment, I’ve switched back to Spam.module, disabling Bad Behavior and Akismet. It’s a bit of a risk, switching spam blocking strategies in mid-attack, but whatever. That’s what backups and phpMyAdmin are for.
Already, the site feels slightly less unresponsive. I’ve never been really happy relying on an active network connection to the Akismet Mothership to check each and every comment, and Spam.module is a completely self contained solution. It’s closer to Spam Karma 2 - the best spam blocking plugin for WordPress. Bayesian voodoo checking the content. Link counting, IP checking, etc…
The Life: A Journey Through Time project resulted in a book, a website (with slideshow and timeline), and much more. The website is one of the most compelling things I’ve seen online (or off). 86 photographs presented in a slideshow intended to give a feel for the power of life on earth. Evan and I just watched the whole thing again. Amazing stuff. The composition and lighting are simply breathtaking. The narrative is interesting, although somewhat inaccurate at times (jaws and teeth didn’t form on land first, etc…) but the message is powerful and compelling.
