Thursday, January 30, 2020

Add shared Google calendar to iPhone/iPad


  1. Have someone share their Google calendar with you
  2. https://calendar.google.com/calendar/iphoneselect
  3. Select calendar(s) to sync
  4. Maybe wait a minute if you don't see the new shared calendar
  5. Select the shared calendar on your iPhone/iPad calendar application

Sunday, April 30, 2017

Javascript project development with Pow and deployment to Heroku

Serve your project with Pow
Chrome may throw a bunch of errors if you try to run a local JavaScript project just by opening the file(s) in your browser. Third-party library libraries may be blocked due to cross-origin protocol scheme filtering which does not like file://.

One way to get around this is to use Pow to serve the project.

After installing Pow, substitute your project's location following this example:

cd ~/.pow
mkdir soundpound
ln -s /Users/username/projects/soundpound soundpound/public

Deploy to Heroku
When your project's ready to share, deploy it to Heroku!
  1. Create a nodejs project in Heroku
  2. Add heroku/nodejs buildback in Personal apps -> Settings in the Heroku console
  3. Add a package.json file to your application
  4. Push from your git repository to deploy the project to Heroku
Example package.json:

{
  "name": "soundpound",
  "version": "0.1.0",
  "description": "keyboard-driven sound and light show",
  "scripts": {
    "start": "harp server --port $PORT"
  },
  "dependencies": {
    "harp": "*"
  }
}

See https://soundpound.herokuapp.com/

Thursday, March 23, 2017

Maven things

Install library

mvn install:install-file -DgroupId=com.humegatech -DartifactId=car2go-connector -Dversion=1.2.0-SNAPSHOT -Durl=file:./target/ -DupdateReleaseInfo=true -Dfile=./target/car2go-connector-1.2.0-SNAPSHOT.jar

Deploy to local repository
Add repo to pom.xml

...
  <repository>
    <id>local-maven-repo</id>
    <url>file:///${project.basedir}/lib</url>
  </repository>
</repositories>

Deploy
mvn deploy:deploy-file -DgroupId=com.humegatech -DartifactId=car2go-connector -Dversion=1.2.0-SNAPSHOT -Durl=file:./lib/ -DrepositoryId=local-maven-repo -DupdateReleaseInfo=true -Dfile=./lib/car2go-connector-1.2.0-SNAPSHOT.jar

Release Deployment
http://central.sonatype.org/pages/apache-maven.html#performing-a-release-deployment

Thursday, February 4, 2016

Free(ish) tee shirts from tech companies

If you're reading this you've already missed the January 2016 sweatshirt Salesforce offered for earning five badges on Trailhead (https://developer.salesforce.com/trailhead/en), but there are still plenty of folks willing to turn you into a mobile advertising platform.

You will be asked for personal information, a social media connection and maybe even some of your time.

NewRelic http://newrelic.com/lp/datanerd
Just sign up

MuleSoft http://champions.mulesoft.com/
Complete an hour or two's worth tasks: reading, commenting, LinkedIn connection, Twitter following, etc. After a week you'll get a link to redeem your t-shirt: I had to turn of Ghostery and uBlock Origin to complete the redemption process.

CircleCI http://blog.circleci.com/new-stickers-and-circleci-tee-shirts/
Just sign up

SmartBear http://www2.smartbear.com/Yovia-Social-TShirt-Campaign_Yovia-Social-LP.html
Download LoadComplete

5nerdssoftware: http://5nerdssoftware.com/so-you-want-a-free-shirt/
Facebook like

Mixpanel https://mixpanel.com/tshirt
Sign up, be inactive for a week (not sure if this is necessary, but I didn't get an email about the shirt until being inactive after signup), then instrument your application with Mixpanel.  Or just go to your console:

m = Mixpanel::Tracker.new '<your_product_token>'
m.people.set('1', {'email':'first.last@gmail.com'})
m.track('1', 'first event')

Amazon https://developer.amazon.com/public/solutions/alexa/alexa-skills-kit/content/alexa-developer-skill-promotionPublish an Alexa skill before March 31, 2016

Rollout https://blog.rollout.io/2015/12/try-rollout-get-a-free-tshirt/
contact information

Wistia http://wistia.com/shirts
contact information

JIRA Service Desk https://www.atlassian.com/software/jira/service-desk
You have to set up an account and do some things in said account

Rollbar https://rollbar.com
Create a free account and then wait a while (2+ months?) before you instrument an application.  I got an email saying that if I instrumented an application with Rollbar they'd send me a shirt for free.

DataDog https://www.datadoghq.com/ts/nagios/
I started a free trial and continue to have free monitoring on a non-production PostgreSQL instance.


On hold
These free shirt offers seem to be over/on hold:

WhenIWork http://wheniwork.com/free-shirt

Codeship https://codeship.com/swag

Friday, May 10, 2013

jMock custom actions, doAll expectation and onConsecutiveCalls

I had an issue with a class that I've not encountered before with projects on which I use jMock: I have a mocked class whose method modifies an object it takes as a parameter.  I suspect this is due to poor coupling in the application, but I'll refactor at a later date -- for now I welcome the challenge as an opportunity to explore three aspects of jMock with which I'm unfamiliar: custom actions, doAll and onConsecutiveCalls.

Problem

public class WillBeMocked {
    public Object processBusinessObject businessObject) {
        ReturnObject returnObject = new ReturnObject(businessObject);

        // change state of input parameter
        businessObject.incrementCounter();

        return returnObject;
    }
}

Solution


create custom jmock.org.api.Action in my test class

private static class BusinessObjectIncrementCounterAction<T> implements org.jmock.api.Action
{
    private final BusinessObject businessObjectInstance;

    public BusinessObjectIncrementCounterAction(final BusinessObject businessObjectInstance)
    {
        this. businessObjectInstance = businessObjectInstance;
    }

    @Override
    public void describeTo(final Description description)
    {
        description.appendText("calls incrementCounter() on the businessObjectInstance");
    }

    @Override
    public Object invoke(final Invocation invocation) throws Throwable
    {
        businessObjectInstance.incrementCounter();
        return null;
    }
}


create static call to construct custom Action in my test class

private static <T> org.jmock.api.Action incrementCounter(final BusinessObject businessObjectInstance)
{
    return new BusinessObjectIncrementCounterAction <T>(businessObjectInstance);
}


use doAll to execute custom Action and mocked class's method call

                
context.checking(new Expectations() {
    {
        oneOf(willBeMockedInstance).process(businessObjectInstance);

        will(doAll(incrementCounter(businessObjectInstance), 
             returnValue(new ReturnObject("A"))));
    }
});



use onConsecutiveCall to 

context.checking(new Expectations() {
    {
        exactly(2).of(willBeMockedInstance).process(businessObjectInstance);

        will(onConsecutiveCalls(doAll(incrementCounter(businessObjectInstance), 
             returnValue(new ReturnObject("A")))),
             doAll(incrementCounter(businessObjectInstance), 
             returnValue(new ReturnObject("B")))));
    }
});

Wednesday, May 8, 2013

Return code is: 401, ReasonPhrase:Unauthorized. -> [Help 1]: Nexus error via Maven via Jenkins when using a slave node: Solved


[ERROR] Failed to execute goal org.apache.maven.plugins:maven-deploy-plugin:2.7:deploy (default-deploy) on project project: Failed to deploy artifacts: Could not transfer artifact com.company:project:jar:build_id from/to dirname (http://server:port/nexus/content/repositories/snapshots): Failed to transfer file: http://server:port/nexus/content/repositories/snapshots/com/company/product/build_id/product-build_id.jar. Return code is: 401, ReasonPhrase:Unauthorized. -> [Help 1]

(Output modified to protect the innocent.)

I have Maven builds running on a Jenkins master with slave nodes.  The deploy goal attempts to push artifacts from the build out to our Nexus instance.

To address this issue I had to add settings.xml to the Jenkins slave owner's .m2 directory as this is used during the upload to Nexus, not the settings.xml in the .m2 directory on the Jenkins master box.

Monday, April 15, 2013

How to move a repo from GitHub to Bitbucket

Just collating two existing resources.  As with the first poster I like to store tutorial code, etc. in a private repo so that it doesn't clutter up my GitHub presence when I put something out there.

Import GitHub repo into Bitbucket

http://somatose.com/2011/10/from-github-to-bitbucket-in-60-seconds.html

Delete GitHub repo

https://help.github.com/articles/deleting-a-repository

Saturday, February 23, 2013

How to create an iso of an existing Windows system using Ubuntu: what worked and what didn't

I have a Windows XP Media Center laptop that is dying, but want to keep the image around.  I've created vms before but not from existing systems, just as fresh installs.  Searching around I stumbled upon Clonezilla which allowed me to create just such an image without purchasing software.  Unfortunately Clonezilla only almost worked (probably because of something I didn't do correctly).   disk2vhd (a Microsoft product) ended up getting the job done in the end.

I'm using Ubuntu 12.10 as my main machine.   Taking an image of a Windows XP Home Media edition with an 80G hard drive. 

The disk2vhd approach

disk2vhd didn't turn up as one of the many options that were presented as I started down this path, but it   ended up being the easiest and quickest of those I tried. I followed these instructions to create the vhd.  Then I used VirtualBox to open the image.  The only thing I had to modify in VirtualBox was this: in System -> Motherboard check the Enable IO APIC box in the Extended Features setting.


The Clonezilla approach

I had space on my system's hard drive that is sufficient but not any flash drives so I backed up using Clonezilla's ssh option to my main box.  This was convenient since I'd be creating the image of the system on the main box anyway.

Before you reference the steps below, understand that I was only able to get to the point where the vm could boot to the safe mode prompt screen, but then hung on any attempt to move forward.  I've got a hunch that trying this with cloning a Linux box would have gone better.

There are several distinct units of work: 
  • prep the source machine
  • create media
  • prepare a repository location for the backup
  • create the clone
  • create a VM from the clone

Prep the source machine

Issues with the source machine

I loaded Clonezilla on a USB drive and ran fine for two partitions (boot and D:/), but not for the main partition where the OS files were installed.  After experiencing issues with booting SpinRite6 from a USB drive that cleared up when using a DVD, I burned the Clonezilla ISO to a physical DVD.  

I then decided to try and make the source image as 'clean' as possible by doing the following:
  • Removing unused files/dirs manually, running disk clean and emptying the recycle bin on the source machine
  • Defragging the source machine
  • Updating BIOS to the latest version provided for my source machine by the manufacturer
  • Running SpinRite on the source machine

Create media

Create Clonezilla disk

Create bootable Clonezilla ISO using Tuxboot.

Create Windows boot disk

I relied upon http://support.microsoft.com/kb/305595 for instructions.  My machine didn't come with any physical media so I needed to harvest the files from C:\.  ntldr and ntdetect.com were in C:/WINDOWS/ServicePackFiles/i386.  boot.ini.backup was in C:\Windows\pss which was good since I used it to confirm the boot.ini name of my operating system.

Tried boot-repair first since screen was blank when I restarted.  After boot-repair I got Windows boot screen, but it just hung part way through the process no matter which option.

Prepare a repository location for the backup

For me the repository location is an Ubuntu 12.10 machine.  It has more space than any external drives I have and it is where I'll be creating and hosting the VM.
  • Install/confirm openssh
  • Create directory /home/partimag on the destination machine and give said directory the appropriate permissions

Create the clone

  • Boot source machine with Clonezilla media
  • When prompted, enter connect info for your destination box
  • Give yourself a few hours if you have an old 80G box you're attempting to clone :)

Create a VM from the clone

  • Create a vm with the same amount (or more) of space
  • Start the vm with the Clonezilla ISO.  Follow the prompts and select restoredisk



Tuesday, February 19, 2013

Solved: Amazon Instant Video won't play on Firefox on Ubuntu 12.10

http://helpx.adobe.com/x-productkb/multi/flash-player-11-problems-playing.html

To summarize:
  1. Install hal
  2. Remove directories from ~/.adobe/Flash_Player
  3. Restart Firefox and watch a video

Wednesday, November 28, 2012

Working with Postgres on OS X Mountain Lion


Installation

Macs come with Postgres installed (9.1.4 for mine purchased in November 2012) (/usr/bin/psql), but I also installed the Postgres app, which appears to have installed 9.1.4 (downloaded in early November 2012).

  1. Install the Postgres app
  2. Start the Postgres app.  When I start the app, I get the Postgres elephant in my menu bar -- clicking it shows the port Postgres is running on.
  3. Use ps -ef | grep postgres to figure out where the path to the Postgres bin directory and the path to the Postgres data directory are.  The output will look something like this: 501 22332     1   0  9:28PM ??         0:00.25 /Applications/Postgres.app/Contents/MacOS/bin/postgres -D /Users/hm1/Library/Application Support/Postgres/var -p5432 where /Applications/Postgres.app/Contents/MacOS/bin/postgres shows the bin directory plus the executable, -D /Users/hm1/Library/Application Support/Postgres/var shows the data directory and -p5432 shows the port Postgres is running on.  Sadly, you can see that there are spaces in the path which means you'll have to enclose this in quotes where you use it.
  4. Add the Postgres bin to your path in the current session or to your .bash_profile.  e.g., export PATH=/Applications/Postgres.app/Contents/MacOS/bin:$PATH

Troubleshooting

Even with the Postgres bin directory appearing first in my PATH, unless I run the Postgres commands (psql, postgres, etc.) from , I need to specify the data files or host location.  If this doesn't work for you, you can alias the commands, uninstall the base installation or use the base installation,  Sarting a new terminal session seems to get around this issue where just sourcing the updated .bash_profile doesn't.

If you get the following error when issuing postgres, your path is not correct and/or Postgres is not running:

postgres does not know where to find the server configuration file.
You must specify the --config-file or -D invocation option or set the PGDATA environment variable.
If you modified the PATH variable via .bash_profile don't forget to source it or start a new terminal session
Using ps above you can see what the -D argument needs to be, or or add the Postgres path section prior to the existing PATH elements.

If you get the following error when issuing psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
then you need to start with psql -h localhost, or add the Postgres path section prior to the existing PATH elements.


Resources

http://postgresapp.com/documentation
http://www.postgresql.org/docs/9.1/interactive/tutorial.html


Monday, October 1, 2012

JS Console

JS Console is a tool I enjoy for messing around with JavaScript without having to create a bunch of HTML (although you can work with the DOM in JS Console). This is proving very handy as I go through JavaScript books/tutorials and want to try code out quickly.  JS Console allows you to do remote JavaScript debugging as well.


How do I use JS Console?

Type or paste JavaScript into the text bar at the top.  You can also load JavaScript libraries (like JQuery) or DOM.

JS Console remote debugging

I don't do mobile development, but it looks like there's a neat way to use your computer's browser to debug JavaScript on your phone(!) or on another machine/session.  And there's a native iOS app.  I have not experimented with the remote debugging.


What can I access in JS Console?

DOM

Looks like you can get to everything in your browser.  If you type document in the text field, for example, you'll get the HTMLDocument object represented as a String.  


localStorage and sessionStorage

You can also view and manipulate localStorage and sessionStorage if supported by your browser (when I did this in IE7 I got undefined as these aren't supported until IE8).  

I added items to localStorage and remoteStorage, opened another Chrome window and verified that in Chrome and  Firefox separate tabs represent new sessions.  I also learned that JS Console uses sessionStorage to store your history.  And I saw that localStorage is browser-specific.  All Chrome windows and tabs saw what I'd added to localStorage in Chrome even after closing and reopening browsers.  Same thing with Firefox, but Chrome didn't see Firefox's localStorage and vice versa.

Sunday, September 30, 2012

JavaScript

I've been looking at JavaScript a bit over the past six months.  

Books
The most helpful titles I've read are:
Eloquent JavaScript
Intro to programming using JavaScript as the vehicle.  Covers programming fundamentals quite a bit.

JavaScript: The Good Parts
Less of a beginning programming guide and

Learning JavaScript (currently reading now)
Intro to JavaScript that assumes an understanding of programming fundamentals.

Tools
QUnit is what I've used to unit test my JavaScript (even if I'm not using JQuery's features in my JavaScript).  I find that unit tests are a great tool for helping me figure out how a language/framework works since they let me submit different scenarios easily, as well as helping me persist the questions I've asked and answered about a language/framework.
QUnit gave me some trouble around the setup, but it was worth the effort, especially once I got into writing more complex functions.

JSConsole is a tremendous tool that I just discovered (today!).  Those of you familiar with consoles for Ruby, Groovy, IO, etc. understand how helpful they can be for quickly answering implementation questions. For example, I wanted to know what would happen if I executed slice(-10) on an array with three members.  Instead of having to build the HTML, the JavaScript, connect the two and figure out how to view the results (alert, innerHTML, etc.) I used the console and it took me about a minute to create the array and try a bunch of slice overrides.

W3Schools Tryit Editor for JavaScript is a helpful tool if you want an easy way to experiment with DOM modification in JavaSript.  On the left side you have HTML and embedded JavaScript -- on the right side you have the output.  You can also use this to experiment with embedded CSS.

Browser debuggers/consoles are handy for debugging (using breakpoints) or monitoring DOM manipulation.  F12 on a PC keyboard (Windows or Ubuntu) will toggle the console for Chrome and Firefox (if you have Firebug installed for the latter).

Monday, September 10, 2012

dd-wrt for Linksys WRT54G v8

http://dd-wrt.com/wiki/index.php/Linksys_WRT54G_v8.0_%26_v8.2

My sister's WRTG54 v8 with stock firmware started hanging when distributing IPs so I decided to put dd-wrt on it.  I had done the same with my WRTG54 v1.1 with no problems so I assumed it would be a snap.  I was going to use it for a client bridge (see Andy Frank's post).

Ubuntu needed for tftp
Using tftp to upload dd-wrt.v24_micro_generic.bin didn't work from my Windows XP box, so I gave it a shot from an Ubuntu 12.x box and that worked.

Brick
Then I got myself into a jam since the primary subnet was non-standard.  I tried to change the secondary router (the one I just flashed), but couldn't connect to the web interface at all.  I did the 30-30-30 reset a few times and thought I bricked it.  The Power and WLAN lights no longer glowed, but the light corresponding to the port connected to my computer glowed.  I did the 30-30-30 reset a few times with no luck.

Wait, then unbrick
Then I let the whole thing sit overnight.  Next evening I was able to connect to to the dd-wrt web interface, and then found that it was serving IPs just fine.  

Whew...

Create client bridge
I gave the now-working WRTG54 v8 back to my sister.  I still didn't have what I was looking for: a client bridge for my ancient Pentium IV running CentOS.  I want the box close to me instead of close to the router behind the TV where it gets hot and is hard to reach.

I ran into issues with a primary (Belkin) broadcasting in N and a secondary (Linksys) only capable of B and G.  Also, the primary has different WPA2 options than the secondary.  And the secondary wouldn't let me select a channel in client bridge mode.  This whole thing is probably easier with two identical routers both running dd-wrt.

Success with compromises
Setting the primary to B and G mode, changing channel selection from Auto to a fixed value and moving from WPA-PSK+WPA2-PSK/TKIP+AES to WPA2-PSK/AES did the trick.  Plugged in Ubuntu laptop connected to the internet when I disconnected from the wired connection I'd set up per the dd-wrt instructions and connected using the Auto Ethernet option.

Back out compromises
Then I began backing out the changes I'd made to the primary.  Moving back to B, G and N worked fine.  Setting channel selection back to Auto didn't affect the secondary's ability to connect to the internet either.  Reverted primary to WPA-PSK+WPA2-PSK/TKIP+AES and still was able to connect to the internet through the secondary.  Seems like this is kind of what  Andy Frank did, but he may have found it possible to go back to WPA2 on the secondary.

Monday, June 18, 2012

cygwin windows processes and ps: the W option

http://cygwin.com/cygwin-ug-net/using-utils.html


Hard to believe I haven't been bothered by this before: if one runs ps in cygwin Windows processes are not displayed unless the W option is used.



$ ps -ef | grep post*
-- nothing



$ ps -efW | grep post*
       0    3220       0 ?          Jun 17 D:\PostgreSQL\9.1\bin\postgres.exe
       0    5684       0 ?          Jun 17 D:\PostgreSQL\9.1\bin\postgres.exe
       0    3808       0 ?          Jun 17 D:\PostgreSQL\9.1\bin\postgres.exe
       0    3072       0 ?          Jun 17 D:\PostgreSQL\9.1\bin\postgres.exe
       0    3620       0 ?          Jun 17 D:\PostgreSQL\9.1\bin\postgres.exe
       0     412       0 ?          Jun 17 D:\PostgreSQL\9.1\bin\postgres.exe

Unfortunately I've not found a cygwin way to kill the Windows processes.  I'm stuck with the Windows way:

$ kill -9 1600
-bash: kill: (1600) - No such process



$ taskkill /F /PID  1600

SUCCESS: The process with PID 1600 has been terminated.

Monday, May 28, 2012

Create Ruby on Rails development environment for Windows XP: DOS prompt and pik

This post details a Windows setup for the book Rails 3 in Action.  Having done both an Ubuntu 12.04 and a Windows XP RoR setup, I strongly recommend the former: much quicker and easier.


I was having some issues with my Cygwin/RVM install so I decided to try using the DOS command prompt and pik instead.



http://stackoverflow.com/questions/9189628/install-ruby-on-rails-on-windows
I think the answerer to this post incorrectly uses bundler to try and install gems (at least for me it gave an error, but using pik gem install <gemname> worked).


Note that for the console I'm using the Windows DOS command line instead of cygwin

Installed Ruby via the Ruby installer

    Added Ruby to path as part of the installer option

Installed pik

D:\> gem install pik
D:\> pik_install <directory_in_PATH>

Ran pik

D:\> pik
D:\> pik list ## confirm proper Ruby version



Installed DevKit

Ran installer to %DEVKIT_HOME%

%DEVKIT_HOME%\> ruby dk.rb init
%DEVKIT_HOME%\> ruby dk.rb install

Test the DevKit installation

%DEVKIT_HOME%\> pik gem install rdiscount --platform=ruby
%DEVKIT_HOME%\> ruby -rubygems -e "require 'rdiscount'; puts Discount.new('**Hello there, Eric!**').to_html"
Should output 
<p><strong>Hello there, Eric!</strong></p>

Installed gems using pik

I didn't find a lot of pik usage information, but I decided to install gems with pik.  Using 'gem list' and 'pik gem list' in different consoles leads me to believe that the installation methods acheive the same result.  Pik dosen't appear to have native gemset-like commands, but see this post for a hack.
D:\> pik gem install bundler --pre
D:\> pik gem install rake
D:\> pik gem install activesupport
D:\> pik gem install mysql
D:\> pik gem install libv8
D:\> pik gem install rails
D:\> pik gem install execjs
D:\> pik gem install jquery-rails


Installed locally downloaded gems

D:\> pik gem install linecache19-0.5.13.gem


This one required the source code for my Ruby version
D:\> set RVM_SRC=<path_to_source>
D:\> pik gem install ruby-debug-base19-0.11.26.gem -- --with-ruby-include=%RVM_SRC%




Errors

Gem::RemoteFetcher::FetchError: SSL_connect returned=1 errno=0 state=SSLv3 read
server certificate B: certificate verify failed (https://rubygems.org/gems/<gem_name>)

I got this above error when running bundle install.  See this post for several fixes.  This one worked for me, but I had to create the destination directory before running the script.

Sunday, May 27, 2012

Working on an existing Rails application in Ubuntu 12.04

My previous post described environment setup.  This post will focus on getting an existing application up and running.


Getting the application

I'm using Aptana and the existing project is on a bitbucket Mercurial repo.  Using the IDE I checked out the application.


The following commands are run from inside the project directory structure.

Bundler

Use bundler to get the appropriate gems for the project (see the file Gemfile).  I initially got errors due to missing packages on the Ubuntu side (postgresql-server-dev-all was not installed).


$ bundle


Database setup

Create databases

Looking at database.yml I see which databases I need to create.  Mine are postgresql (see the adapter fields) and two different databases.  Using psql's CREATE DATABASE <database_name> command I set both the test and  development databases up.


Create role

I needed to create a role for my Linux user using CREATE ROLE <role_name>


Populate databases

I needed to add execjs and therubyracer to my Gemfile.  I also needed to add `, :require => false` after my shoulda and shoulda-context gems in Gemfile per https://gist.github.com/1549790.  Per the link it seems that the load worked fine without the require => false.


$ rake db:schema:load


Run the application

$ rails server


http://localhost:3000 will display the RoR welcome screen.  You'll have to modify the URL based on your application.


Dude, where's my gemset?

If the .rvmc file for the project on which your working specifies a gemset that you don't have and/or that you didn't use to install the proper gems you can copy the one you did have setup to match the one specified in the file.  This is especially helpful if you want to use the Terminal in Aptana.
I needed to manually rerun the ruby debug installation because that failed during the copy.

$ rvm gemset list
$ rvm gemset copy 1.9.3-p194@<existing_gemset> 1.9.3-p194@<.rvms_gemset>
$ export RVM_SRC=$HOME/.rvm/src/ruby-1.9.3-p194
$ gem install ruby-debug-base19-0.11.26.gem -- --with-ruby-include=$RVM_SRC

Install Ruby on Rails development tools on Ubuntu 12.04

I ran into a number of issues installing this entire stack and then running a 1.9.3 / 3.2.0 application.  I won't detail the errors here.  The order here is somewhat important as the postgresql-server-dev-all was required during bundling.
Please see my next post for information regarding setup for a specific application.

Install postgreSQL

https://help.ubuntu.com/community/PostgreSQL

$ sudo apt-get install postgresql
$ sudo apt-get install postgresql-server-dev-all

Looks like database was initialized and started for me and user postgres was created.  I used ps -ef | grep postgres to figure out where the relavent directories used by my installation where.  The installation created the install in /usr/lib/postgresql/9.1 and the data directory as /var/lib/postgresql/9.1/main.  Configuration files in /etc/postgresql/9.1/main.


User postgres didn't have the postgresql bin directory on the path so I had to create a new .bashrc file for postgres so I don't have to reinitialize variables every time I open a console.  
export PATH=/usr/lib/postgresql/9.1/bin:$PATH
export PGDATA=/var/lib/postgresql/9.1/main

I modified pg_hba.conf to use the trust method so I wouldn't have to supply a password to the database.  This was done since the database.yml file that is part of the project assumes no password needed for db access.

Install adminpack to assist pgAdminIII

$ sudo apt-get install postgresql-contrib-9.1
$ sudo -u postgres psql < /usr/share/postgresql/9.1/extension/adminpack--1.0.sql
$ psql
postgres=# CREATE EXTENSION adminpack;


Install pgAdminIII

$ sudo apt-get install pgadmin3

Install Mercurial

$ sudo apt-get install mercurial

Install Aptana IDE

http://www.aptana.com/products/radrails


Install the Eclipse/Aptana MercurialEclipse plugin

Here's the update site:
http://cbes.javaforge.com/update

Install RVM

$ sudo apt-get update
$ sudo bash -s stable < <(curl -s https://raw.github.com/wayneeseguin/rvm/master/binscripts/rvm-installer)
$ source ~/.rvm/scripts/rvm
$ rvm get head && rvm-smile
$ sudo apt-get install libtool
$ rvm pkg install libyaml
$ rvm install ruby-1.9.3-p194

$ rvm --default use 1.9.3

Install Rails

$ gem install rails -v 3.2.0
$ gem install execjs
$ gem install therubyracer

Install bundler


http://stackoverflow.com/questions/6438116/rails-with-ruby-debugger-throw-symbol-not-found-ruby-current-thread-loaderro



$ rvm get stable
$ rvm use ruby-1.9.3-p194@<gemset_name> --create
$ wget http://rubyforge.org/frs/download.php/75415/ruby-debug-base19-0.11.26.gem
$ wget http://rubyforge.org/frs/download.php/75414/linecache19-0.5.13.gem
$ gem install linecache19-0.5.13.gem
$ export RVM_SRC=$HOME/.rvm/src/ruby-1.9.3-p194
$ gem install ruby-debug-base19-0.11.26.gem -- --with-ruby-include=$RVM_SRC
$ gem install bundler --pre


Dude, where's my gemset?

If the .rvmc file for the project on which your working specifies a gemset that you don't have and/or that you didn't use to install the proper gems you can copy the one you did have setup to match the one specified in the file.  This is especially helpful if you want to use the Terminal in Aptana.
I needed to manually rerun the ruby debug installation because that failed during the copy.

$ rvm gemset list
$ rvm gemset copy 1.9.3-p194@<existing_gemset> 1.9.3-p194@<.rvms_gemset>
$ export RVM_SRC=$HOME/.rvm/src/ruby-1.9.3-p194
$ gem install ruby-debug-base19-0.11.26.gem -- --with-ruby-include=$RVM_SRC




Wednesday, April 11, 2012

Oracle SQL dynamic order by clause

I never had a dire need for this before today, but it is something I could have used many times in the past to simplify queries and/or use a query instead of a function.


SELECT *
  FROM table alias

ORDER BY DECODE(:bindVariable, 'option1', alias.column0, 'option2', (alias.column1 * alias.column2)) DESC NULLS LAST,
         alias.column3 ASC);

It has been around for at least a decade so, although I don't write a ton of SQL or PL/SQL, I'm surprised I haven't seen it before today.