Barry Keenan

Develop mobile stylesheets - handheld.css

2009-02-07T01:19:00.007Z

Designing for mobiles can be IS a pain. First of all I'd recommend developing a 'handheld.css' stylesheet using these two browsers:

Firefox & Web Developer Toolbar. (CSS -> display CSS by media type -> handheld)
Opera. (View -> Small Screen)

Force mobiles to read the handheld stylesheet

Once you have the handheld stylesheet looking how you want it. Add it to your pages using this php script. We all know browser detection is evil and bad, but mobile support for standards isn't here yet and this is the most pain free way. In my case I did something like this:

if( mobile_device_detect()==true ) {
//I am a mobile
<link rel="stylesheet" type="text/css" media="screen, handheld" href="handheld.css">
}
else {
//I am a browser
<link rel="stylesheet" type="text/css" media="screen" href="main_layout.css">
<link rel="stylesheet" type="text/css" media="handheld" href="handheld.css">
}

Test on an emulator

Installing a mobile phone emulator can be a bit of a lengthy process as well:

Install ActiveSync
Unzip and install V1Emulator standalone_emulator_V1.exe
Install the Virtual Network Driver (part of Virtual PC)
Install the Emulator Images & Device manager for Windows Mobile 6.1

The tricky part is enabling internet connectivity. Start ActiceSync and set "Allow connections to one of the following" to "DMA" in the File, Connection Settings menu of ActiveSync.

Choose an emulator to launch, e.g. Start -> SDK -> Smartphone QVGA - Coldboot. Once it's running, open Start -> SDK -> Tools -> Device Emulator Manager. Right click on the device and select 'cradle'. This will place the emulated smartphone in the virtual "cradle" so it can access the network through ActiveSync.

Test on a phone

The only sure fire way to test if everything is working properly is to use an actual smart phone.

Good luck

Refs:

http://www.alistapart.com/comments/returnofthemobilestylesheet/

http://detectmobilebrowsers.mobi/

http://www.codinghorror.com/blog/archives/000782.html

Adding a subsite in Silverstripe

2008-11-13T07:06:00.005Z

Assuming you've got the subsites module installed and created your first subsite 'Template' manually, you can now go about adding subsites!

Click on the Sub-sites tab at the top of the Silverstripe CMS to add a new subsite.

You will see this panel on the left hand side. Just enter a name and subdomain and click add.

You can see I've already added two domains here which point to http://sub1.localhost and http://sub2.localhost

Each new subsite is based on a 'Template', so in this case will have the domain 'mysite.com' appended.

I first tried setting this up in my home directory but Silverstripe could not resolve addresses of the form http://sub1.localhost/~username/

Once I installed Silverstripe to the main apache Documents folder it worked no problem, i.e. Silverstripe will resolve http://whatever.localhost/

In my case, because I'm developing locally I added the following entries to my /etc/hosts file:

127.0.0.1    sub1.localhost
127.0.0.1    sub2.localhost

Happy subsiting...

Install Silverstripe 'Subsites' module

2008-11-10T12:22:00.023Z

The following steps worked for me when installing the Silverstripe Subsites module:

1. Create a directory in your root silverstripe installation. '~/Sites/silverstripe/subsites'

Download, and unzip the code into this directory. I deleted the 'trunk' directory to keep things tidy.

2. Ensure every folder in your silverstripe hierarchy has the user '_www' read/write access

3. There is a problem linking the Group table in the database, so for now comment it out in 'silverstripe/subsites/_config.php' so it looks like this:

<?php

/**
* The subsites module modifies the behaviour of the CMS - in the SiteTree and Group databases - to store information
* about a number of sub-sites, rather than a single site.
*/

Object::add_extension('SiteTree', 'SiteTreeSubsites');
// Hack - this ensures that the SiteTree defineMethods gets called before any of its subclasses...
new SiteTree();
Object::add_extension('ContentController', 'ControllerSubsites');
Object::add_extension('LeftAndMain', 'LeftAndMainSubsites');
Object::add_extension('LeftAndMain', 'ControllerSubsites');
//Object::add_extension('Group', 'GroupSubsites');
Object::add_extension('File', 'FileSubsites');

?>

Then visit http://localhost/silverstripe/db/build?flush=1 This will set up the initial database tables for the subsites module.

5. We need to manually modify the Group table using the following SQL. Note that 'Group' is a reserved keyword in mysql so make sure you wrap it in backquotes:

alter table `Group` add SubsiteID int(11) not null default 0;

6. We also need to manually insert the first 'Template' into the Subsite table:

insert into Subsite (ID, ClassName, Created, LastEdited, Subdomain, Title, Domain)
values ("", "Subsite_Template", NOW(), NOW(), "newsubdomain", "newtitle", "mysite.com");

7. Now you can uncomment your 'silverstripe/subsites/_config.php' file and add the following two lines so that it looks like this:

<?php

Object::add_extension('SiteTree', 'SiteTreeSubsites');
// Hack - this ensures that the SiteTree defineMethods gets called before any of its subclasses...
new SiteTree();
Object::add_extension('ContentController', 'ControllerSubsites');
Object::add_extension('LeftAndMain', 'LeftAndMainSubsites');
Object::add_extension('LeftAndMain', 'ControllerSubsites');
Object::add_extension('Group', 'GroupSubsites');
Object::add_extension('File', 'FileSubsites');

Director::addRules(100, array(
'admin/subsites/$Action/$ID/$OtherID' => 'SubsiteAdmin',
));
Object::addStaticVars( 'LeftAndMain', array( 'extra_menu_items' => array(
'Sub-sites' => array("intranets", "admin/subsites/", 'SubsiteAdmin')
)));

?>

For good measure, visit http://localhost/silverstripe/?flush=1 to make sure any database changes have been picked up.

8. Then visit http://localhost/silverstripe/admin?flush=1 to reload your CMS. You should now have the 'Sub-Sites' tab in the Silverstripe admin CMS along with a dropdown in the top right hand corner that allows you to select which subsite you are currently working on.

Documentation for this module is in alpha ;-) , so if anyone has any tips on refining these installation instructions please let me know.

iconv will not link when compiling PHP on OSX

2008-11-06T12:17:00.007Z

When trying to compile PHP on OSX Leopard, the ./configure command completed successfully but iconv would not link....

Undefined symbols:
"_iconv_close", referenced from:
_php_iconv_string in iconv.o
_php_iconv_string in iconv.o
__php_iconv_strlen in iconv.o
__php_iconv_strpos in iconv.o
__php_iconv_mime_decode in iconv.o
__php_iconv_mime_decode in iconv.o
__php_iconv_mime_decode in iconv.o
_zif_iconv_substr in iconv.o
_zif_iconv_substr in iconv.o
_php_iconv_stream_filter_dtor in iconv.o
_zif_iconv_mime_encode in iconv.o
_zif_iconv_mime_encode in iconv.o
"_iconv_open", referenced from:
_php_iconv_string in iconv.o
__php_iconv_strlen in iconv.o
__php_iconv_strpos in iconv.o
__php_iconv_mime_decode in iconv.o
__php_iconv_mime_decode in iconv.o
_zif_iconv_substr in iconv.o
_zif_iconv_substr in iconv.o
_zif_iconv_mime_encode in iconv.o
_zif_iconv_mime_encode in iconv.o
_php_iconv_stream_filter_factory_create in iconv.o
ld: symbol(s) not found
collect2: ld returned 1 exit status
make: *** [sapi/cli/php] Error 1

I believe this is a problem with the default /usr/include/iconv.h header file in Leopard.

I have a different version of iconv.h installed with Fink which puts all it's software in /sw
I added the following to the ./configure command's options, as suggested here.

--with-iconv=shared,/sw

This would not work unless 'shared' is specified. Perhaps this is because Fink compile iconv as a shared library.

Broken Web Sharing / Apache on OSX Leopard

2008-11-05T03:23:00.003Z

I recently installed Leopard on my macbook and wanted to enable Web Sharing but when I visited http://localhost, Firefox gave me the following error:

Failed to Connect
Firefox can't establish a connection to the server at io.

I tried to uncheck/check Web Sharing in System Preferences. I also tried stopping/starting Apache on the command line with no luck.

Finally I used this resource on DIYMacServer to reinstall Apache on my machine. It now works like a charm, thanks Richard!

(This all came about because I want to install SilverStripe which suggests using MAMP, but I did not want multiple versions of Apache installed on my machine.)

Association Callbacks

2007-08-08T15:34:00.000Z

Similiar to the normal callbacks that hook into the lifecycle of an Active Record object, you can also define callbacks that get trigged when you add an object to or removing an object from a association collection. Example:

class Project
has_and_belongs_to_many :developers, :after_add => :evaluate_velocity

def evaluate_velocity(developer)
...
end
end

It’s possible to stack callbacks by passing them as an array.

Possible callbacks are: before_add, after_add, before_remove and after_remove.

Should any of the before_add callbacks throw an exception, the object does not get added to the collection. Same with the before_remove callbacks, if an exception is thrown the object doesn’t get removed.

ssh segmentation fault osx

2007-07-09T10:01:00.000Z

Argh!! Every time I install an update on my MacBook it breaks ssh. Up until now I'd been using Pacifist to extract & reinstall the Kerberos Framework from the 10.4.8 update, as per these instructions.

I'm now having to do this on a regular basis which is very annoying and I'm getting concerned that replacing Kerberos with an older version is introducing security holes. so I've decided to install Fink and openssh instead of using Apple's ssh.

Deploy Rails on Windows: Part 3

2007-07-05T14:53:00.000Z

This is the last part of a series of posts on deploying Rails on a windows server using Oracle, Mongrel & Pen. My thinking: get it working with a simple app first, to minimise headaches later. The other parts can be found here:

This part heavily references a talk given by Brian Hogan at RailsConf

Part 3: Pen of pesky Mongrels
Before you go any further, make sure your app works in production mode!

Install Mongrel

The easiest way to get started with Mongrel is to install it via RubyGems:

gem install mongrel

Select the highest stable version number marked (mswin32).

Run Mongrel in the background with:

cd myrailsapp
mongrel_rails start -d

and stop it with:

mongrel_rails stop

There’s quite a few options you can set for the start command. Use the mongrel_rails start -h to see them all.

Mongrel as a Service

Install the gem (pick the most recent one):

gem install win32-service
gem install mongrel_service

Install your app as a service:

mongrel_rails service::install –N comics_4001 -c c:\my\path\to\myapp –p 4001 –e production

Your app will then appear under ‘services’ in Computer Management (accessed via Control Panel or by right clicking on My Computer)

You can then set the service to start automagically. Right click on ‘comics_4001’, choose ‘properties’ and change the startup type to ‘automatic’.

This is really all you need for a small application – perhaps an internal company app or something.

Cons:

You don’t get page caching
Doesn’t scale
Rails is single threaded so user requests get queued up.

While rails is serving an action to one user, all the other users need to wait. This is bad if some of your actions take a while, which is why we need Pen...

Load Balancing Mongrels with Pen

Pen requires cygwin1.dll, so make sure it’s in the same directory as pen.exe. Also, make you get the one with the ‘a’ suffix – the other version doesn’t work for some reason.

To run pen as a service you need the Windows Server Resource Kit Tools. Install it somewhere. To keep things simple I'll use c:\reskit

Start a couple of mongrels:

mongrel_rails service::install –N comics_4001 -c c:\my\path\to\myapp –p 4001 –e production
mongrel_rails service::install –N comics_4002 -c c:\my\path\to\myapp –p 4002 –e production

You could write a batch file to start and stop these multiple servers.

The following command will balance your mongrels just fine:

pen 4000 localhost:4001 localhost:4002

But to do things properly, keep reading.

Pen as a Service

Install pen as a service using srvany.exe from the reskit:

c:\reskit\instsrv Pen c:\reskit\srvany.exe
>> The service was successfuly added!

Set some parameters with regedit. Go to 'HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Pen' and add a new key called 'Parameters'. Add the following three String values to the parameters key:

Application = pen.exe
AppParameters = -f 4000 localhost:4001 localhost:4002
AppDirectory = c:\pen

Start the pen service from ‘Services’ or with the command:

net start pen

Remove with:

sc delete pen

Pen will then chug along happily and is suitable for most apps with a few users. You still don’t get page caching, for that you need Apache, but this solution is free, simple and performs moderately well.

Deploy Rails on Windows: Part 2

2007-07-05T14:01:00.000Z

This post is part of a guide to deploying a small Rails application on a windows server using Oracle, Mongrel & Pen. My thinking: get it working with a simple app first, to minimise headaches later. The other posts can be found here:

This part heavily references a tutorial provided by Oracle.

Part 2: My-first-app with Oracle

This guide assumes you are either:

connecting to an Oracle Database installed on your local machine.
connecting to a remote database using Oracle Instant Client installed on your local machine.

If you do not have at least the client software installed, the Ruby-Oracle driver will complain that it can’t find files such as ‘oci.dll’.

Install Oracle Database Driver

Download the driver and install with:

ruby ruby-oci8-1.0.0-rc3-mswin32.rb

You can test your connection to the database with the following one-liner:

ruby -r oci8 -e "OCI8.new('username', 'password', '127.0.0.1:1521/orcl').exec('SELECT * FROM test_table') do |r| puts r.join('|'); end"

Of course, make sure the schema & table that you are testing exists!

Create a User

Using SQL*Plus, create a user with DBA privileges that you can use for this application.

GRANT dba TO ruby IDENTIFIED BY ruby;
ALTER USER ruby DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
EXIT

Create a Table

CREATE TABLE comics (
id NUMBER(10) NOT NULL,
title VARCHAR2(60),
issue NUMBER(4),
publisher VARCHAR2(60),
PRIMARY KEY (id)
);
CREATE SEQUENCE comics_seq;

Alternatively use this SQL file to create the application table, COMICS.

sqlplus ruby/ruby@rails @comics.sql

Note, in this case the database SID is ‘rails’. The default SID for Oracle Enterprise Edition 10g is ‘orcl’, for Express Edition it’s ‘XE’

Create a dinky Application

Your application skeleton:

rails comics_catalog
cd comics_catalog

Edit ‘comics_catalog/config/databases.yml’ – rails needs to know your login & password info.

Within your project directory, there is a directory called config and in it is a file named database.yml. You need to edit database.yml using your favorite text editor. Initially, the file will look like this:

development:
  adapter: mysql
database: rails_development
host: localhost
username: root
password:

# Warning: The database defined as 'test' will be erased and
# re-generated from your development database when you run 'rake'.
# Do not set this db to the same as development or production.
test:
  adapter: mysql
database: rails_test
host: localhost
username: root
password:

production:
  adapter: mysql
database: rails_production
host: localhost
username: root
password:

Change the development properties as follows:

development:
  adapter: oci
username: ruby
password: ruby
host: 127.0.0.1:1234/orcl

host: takes a connect string of the form <ip_address>:<port>/<database> for the machine that your Oracle instance resides on.

Use the magical scaffold command to build a web based CRUD interface to the table we created above...

ruby script/generate scaffold Comic

Now you can access your Rails Comic Catalog application on your own development machine, using your favorite Web browser. Just access the following URL: http://localhost:3000/comics/list

Phew! Done. Last step is Part 3: Pen of pesky Mongrels...

Deploy Rails on Windows: Part 1

2007-07-05T13:45:00.001Z

An application I'm developing is due to go public around Christmas. I thought the best way to get to grips with deployment would be to set up a little test application, before trying to move all my code onto the server. This guide will consist of 3 parts:

I'll be using Windows Server, Oracle 10g, Mongrel & Pen. Many thanks to Brian Hogan for his informative talk at RailsConf which made the whole process very easy. See Deployment Strategies for Rails on Windows Servers for more detailed information.

Part 1: Installing Rails

Install Ruby

Download the one click windows installer. When installing, uncheck 'SciTE' – there are better editors available. Also, make sure ‘Enable RubyGems’ is checked. This is the package manager for Ruby, used to install Rails itself and myriad of other stuff.

Install to 'c:\program files\ruby' (or your installation path), then add ‘c:\program files\ruby\bin’ to your PATH for command line stuff.

Goto ‘Control Panel\System’, select the ‘Advanced’ tab and click ‘Environment Variables’. Look under user variables. If PATH isn’t already defined, click ‘New’.

Variable name = ‘PATH’
Variable value = ‘%PATH%;c:\program files\ruby\bin’

Note the ‘;’ separator in the value string. If PATH is already defined just add ‘;c:\program files\ruby\bin’ to the end of it.

Install Rails

Now that we have ruby installed, we can use RubyGems to install rails.

gem install rails --include-dependencies

Yes, it is that easy.

My-first-app

Create your application skeleton and start the server:

rails path/to/your/new/application
cd path/to/your/new/application
ruby script/server

Congratulations! You’re now on Rails. Onto Part 2: My-first-app with Oracle...

Improve Default Rails Database Performance

2007-05-23T15:40:00.000Z

Active Record (AR) is slow. All that nice reflection comes at a price. You should use AR to prototype your app, then take a look at the logs.

1. Sort your development log.

If a database query is only run a few times, let AR handle it. If one is being run a 1000 times then we should pull it out and tweak it.

2. Pull the SQL from the log

Rails has already done the hard work for us, right?

3. Tweak the SQL

Stick the tweaked DB queries in your models and things should move along nicely...

RailsConf 2007

2007-05-23T08:58:00.000Z

Ok, I've just got back from RailsConf 2007, so the next few posts will be about stuff I picked up while I was there. I found the conference a bit light on technical content so don't expect anything ground breaking, just some general advice. For now, here's where you can find most of the slides from the conference.

Named Callbacks

2007-03-22T10:11:00.000Z

Coming from a Java background I often find myself wanting to override constructors and other hooks. I should really pay more attention to the documentation.

Instead of:

class MyClass
def after_initialize
    #Do Something...
  end
end

Do:

class MyClass
after_initialize :do_something

def do_something
    #Do Something...
  end
end

Update 13/06/07:

Using named callbacks better conveys your intention, making your code more readable.
Similar article on The Rails Way

Active Record Constructors

2007-03-21T16:30:00.000Z

Do not write your own initialiser to instantiate the object. e.g:

class MyClass < ActiveRecord::Base
  def initialize(params)
    @params = params
  end
end

Instead do this:

my_object = MyClass.new(:params => params)
my_object.save

Or this:

MyClass.create :params => params

The above will automatically save the record to the DB.

Environment Variables in Mac OS X

2007-03-21T14:36:00.000Z

I've been recently having trouble starting certain java applets on my MacBook. For some reason , once downloaded, the Jar file would not extract or run. After much tinkering I found that the applets would work if I started my browser from the command line rather than the dock.

Similarly I couldn't get certain scripts to work from textmate, but they would work if I started textmate from the command line.

The problem was that the $PATH variable I had set in my .bash_profile was not the same as that set in my ~/.MacOS/environment.plist file.

Certain applications depend on being able to read your PATH and other environment variables. However those set in .bash_profile have absolutely no effect on apps started from the Dock. Instead make sure that the PATH variable in your environment.plist file is in sync with that in your .bash_login by doing 'echo $PATH' in a terminal and copying the result into said file.

Syntax Highlighting in blogger

2007-03-21T14:07:00.000Z

Eventually (in the far distint future) I want to set up my own server to host rails apps on and perhaps a blog driven by Mephisto - particularly cause you can get good syntax highlighting plugins for it.

In the meantime, I discovered that you can export your current highlighting theme from textmate as CSS, using the bundle command 'Create CSS From Current Theme' (vaguely enough ;) ). Then any time I want to post code snippets here, I use the similarly vague command 'Create HTML From Document'

All you need to do is copy and paste the CSS into your Blogger template.

Beautiful.

Selection List syntax

2007-03-21T13:02:00.000Z

I dont think the explanation of 'selection lists' in Agile Web Development with Rails(1st ed) is very clear. It mentions:

select(:variable, :attribute, choices, options, html_options)

Where you can then set the default selection with:

@variable.attribute

However this variable is not available automatically, you need to create it yourself. The def in the api is more intuitively described as:

select(:my_object, :method, choices, options, html_options)

You must then create your own class with the accessor methods you need so that in the controller you can do something like:

def action
 @my_object = MyClass.new
 @my_object.method = params[:my_object][:method]
end

session variable not available

2007-03-21T13:01:00.000Z

You CANNOT access the session hash from within a controllers initialize() method.

Rails Fixtures with Legacy Database

2007-03-21T13:00:00.000Z

My setup was:

MySQL Table name: TABLENAME
Rails Model name: TableName

The fixture file has to be TABLENAME.yml (not case sensitive)
fixtures() takes the symbol name of the Model, in this case :tableName (note the first lowercase letter) This is the bit that drove me mad - i was writing fixtures :TableName which appeared to work, but then the test failed if I tried TableName(:foo)
Now you can write tableName(:foo)

Hello and Welcome!

2007-03-21T12:56:00.000Z

This humble blog serves mainly as an aide-memoire for the Ruby on Rails mistakes I've made, so that the head-against-brick-wall process is less painful next time. Who knows, perhaps as I get better, some of these posts will be useful to others too.