greg.harvey's blog

Piping A File In To MySQL

Our use case here is if you have a lot of data you want to insert in the MySQL - data that you might usually use the Drupal UI for, but there's so much of it you'd rather not if you can help it!

The example here is for a client of ours. For this particular client we have to launch a few new sites a month, each one comes with a new access list of email addresses to add to the Drupal "Access rules" page. There's no bulk upload, and doing these one by one with the UI is laborious, to say the least!

Skype Call Recording In Linux

I was looking for a Skype recorder that works in Linux and I came across this application:
http://atdot.ch/scr

I went to downloads and tried out their RPM version, and it (almost) worked right away. There were a few awkward steps for my distro (Fedora 14) and I can't say how it performs in other distros, but it seems by and large this works well, once you've fixed any dependency problems.

For my reference, and for the good of others, here are the steps required to make this work in Fedora 14:

Look, Drupal 7!

This is now my first Drupal 6 to Drupal 7 upgrade. Not without hitches, but all in all not too painful. Hope you like the new look. As dedicated readers may know, I never stick with the same theme between major Drupal releases, more often than not because my previous theme was never ported and I can't be bothered to port it myself. The new theme is the rather pretty Corolla, which you can find here:
http://drupal.org/project/corolla

Here are some Drupal 7 upgrade notes and links others may find useful.

Updating From Fedora 12 To Fedora 13

Free tagging: 

Fedora 12 "end of life" just came around, so I decided to update to Fedora 13 while things were quiet over Christmas. Fedora ships with a preupgrade app which manages the update process, so in theory this should do it:

su -c "preupgrade"

Security Releases Don't Work

Wow, long lapse in posts there. Sorry folks. On with the show:

Here's the problem. The Drupal security team do a fine job, following up on reports, auditing contributed modules with a point release to check for security weaknesses, working on core. It's all good, except for one thing:

Contrib release process.

Setting Up Git And Gitosis On CentOS 5.2

This article is a tweaked version of several tutorials around. Many of the original links courtesy of Adrian Simmons. Thanks to all the others who gave me loads of help in IRC and thanks to Jerad at Lullabot for inspiring me to dive in to Git with this article.

For my own sanity I'm blogging this, since every time I have to do it I end up jumping through the same hoops and cursing myself for not blogging it!

I have a USB external drive on one of my machines. I want it shared across the network. It's an old Windows drive formatted as NTFS. Here are the steps:

1. On the "server" install required services and applications. As root:

$ yum install nfs-utils ntfs-3g ntfs-config fuse

FUSE should be there already, but just in case. The GUI for ntfs-3g is optional.

2. Make sure the NFS services is enabled and loads on boot:

Panels 3 And The 960 Grid System

This post was going to be longer, but I just lost the entire completed document because the worst (and probably most expensive at $15/day, yes DAY) mobile Internet provider in the world, EVER, just dropped my connection mid-submission and for the zillionth time today. So you'll have to make do with an angry and hurried synopsis of what I would've written.

Installing 3G USB Modems On Linux

So, last night I lost not inconsiderable amounts of time and sleep to a Vodafone Italy 3G USB key. Trying to get these things set up is supposed to be fairly straightforward, however the end-to-end process is not really documented anywhere, as far as I can tell. Maybe for individual devices, but not in any generic way.

Since this is the second time I've done this now, and in both cases it was a pain in the ass, I am documenting some generic steps so I don't forget what I need to do all over again!

Free SSL With VPS.NET

Free tagging: 

Ok, so this is *purely* for my memory, a kind of bookmark. But VPS.NET, the hosting company I often use for virtual machines, does free SSL certificates for all customers:
http://www.vps.net/forum/public-forums/announcements/233-free-and-unlimi...

Here's how you get one and configure it. (Using the VPS.NET Centos 5.4 64 bit LAMP image, and with ISPmanager Pro - also free from VPS.NET - as the server control panel. This is my usual set-up.)

  • Set up your VM in the usual way

Pages

Subscribe to RSS - greg.harvey's blog
© 2010 Greg Harvey. Drupal theme by Kiwi Themes.