Extreme Import

Once in a while, I run across a situation where I need to import data from a spreadsheet into a database.

If the data is to update a single table, this is pretty straight forward. On the other hand, if the data is modeled as a set of tables it gets a bit more messy. Continue reading

How to change printer’s IP address on Mac OS X

Screen Shot 2014-09-27 at 12.18.14 PMI was updating my network to use a different subnet and realized that the last time I did that, my HP printer stopped working because a lot of the network drivers set the IP address into the printer settings.

So I figured that maybe I would need to update the printer’s IP address on my Mac. I looked at the printer settings and didn’t see anything that might work.

Continue reading

Make Chrome Accept a Self-Signed Certificate (on OSX)

If your organization is like most, they will have sites that use a self-signed (or untrusted authority) certificate.

From Wikipedia:

In cryptography and computer security, a self-signed certificate is an identity certificate that is signed by the same entity whose identity it certifies. This term has nothing to do with the identity of the person or organization that actually performed the signing procedure. In technical terms a self-signed certificate is one signed with its own private key.

Continue reading

Migrate JavaEE from Single Tier VM (Step 1)

 

Glassfish_logo.svgI manage a small application that is hosted on a single Linux virtual machine and have noticed some occasional performance and stability issues.

The server runs CentOS, MySQL and a GlassFish server. I chose GlassFish several years ago because at the time it was the only EJB3 container around, as well as being very well integrated with the NetBeans IDE.

Like most JavaEE containers, it also makes clustering and scaling easier. Continue reading

Making sure Stash starts up on Windows

logoStashPNGI was having a problem where Stash (which was installed as a service) wasn’t starting up properly and giving me a page that made it look like there was a problem with the database.

I have a local MySQL on the same machine as the Stash server, and both that service and the Stash server are set to automatically start up. Continue reading

Changing RHEL6 to CentOS packages

CentOS 4.2 Welcome en 3Recently I was using a canned VM that had RedHat EL6 loaded on it, and needed to add a package, only to find that the package had been moved to the RedHat base repository.

 

 

 

 

Continue reading

Loss and Sadness

Today I went to work expecting a great day. My young friend Chris Merris was coming back to TheraDoc, and it’s always a good thing to have sharp people around you.

The mood of the day suddenly shifted as I found out that Jeff Knell, another new friend at work had died over the weekend. I felt extremely sad all day, not so much because I’d lost a close friend (although I thought that Jeff and I were going to be good friends).

Instead I think it has more to do with the loss of that growing friendship, and the reminder of the transience that is life.

Continue reading

Getting the correct timezone in a web application

English: A timezone indicator showing UTC+6 Ру...

I support a web application that is hosted on a virtual private server. The application architecture is JavaEE running under GlassFish on CentOS.

Like most ISP’s, my hosting provider builds vanilla Linux boxes that can be configured with various flavors of the OS.

Out of the box these images have their timezone set to UTC, and since my end users are in California, and I’m not doing anything on the client to handle timezone conversion, the times that come up in the application are off by 7 or 8 hours (depending on whether it’s Daylight Savings time or not. Continue reading

Unintended Consequences

I’m always fascinated by unintended consequences, especially when they are an artifact of trying to do something right.Ice Ramp

In moving to Salt Lake City from California, I’ve been reminded that good intentions and planning do not a perfect world make.

I live close to downtown, so I’ve started walking to work. It’s a nice walk, gives me a bit of exercise, and makes me feel I’m being a bit more “green” by not driving.

The sidewalks have those nice ramps into the crosswalk, which lets a wheelchair roll across. And they keep somebody who’s not quite paying attention from tripping on the curb …

It’s all great until it snows …

Continue reading