Site down right now? Call or text, and I'll start the same day. (910) 338-4964
Randy Johnson

Blog

Root cause.

Field notes from fixing production: Linux, NGINX and OpenResty, the JVM, Lucee, PHP, Node and MySQL. RSS feed

2026

2025

2024

2023

2020

2013

  • Git GUI for Windows

    This past weekend I needed to upload code to github. I chose to use the GitHub for Windows which made it painless. Today I decided to research and see what other GUI clients I…

  • Handy JS Functions

    Converting a string to an integer http://www.w3schools.com/jsref/jsref_parseint.asp Javascript For Loop http://www.w3schools.com/js/js_loop_for.asp

2012

  • UPS - User Id and Shipper Number combination is not qualified to receive negotiated rates.

    Today I started to receive the following message from the UPS API: User Id and Shipper Number combination is not qualified to receive negotiated rates. and to make matters…

  • Jetty Locking Files on Windows

    I went to edit a css file today on a server an OpenBD Jetty install and the file was locked. After doing some research I found this…

  • PostgreSQL 9.1 installation guide

    I found this wiki article today about on how to install PostgreSQL 9.1 on CentOS. It was very easy to do.

  • How to determine which version of PostgreSQL you are running

    Run this SQL command to see which version of PostgreSQL you are running: select version(); Reference: PostgreSQL Wiki

  • How did I manage to forget my railo admin password?

    I have no idea how it happened but I forgot and apparently failed to document my railo admin password. Luckily a quick Google search pointed me in the right direction. Here is…

  • How to see what packages are installed using YUM

    I am getting ready to do a database migration. While putting my project plan and documentation together I needed a way to find out what postgres packages were installed on the…

  • SPF Record for Google Apps and Sendgrid

    Today I needed to update the SPF record for two domains that the email is hosted on Google Apps for Domains. The websites are hosted on the Rackspace Cloud and use Sendgrid.…

  • Test your apache config file

    Test your apache config file This is a quick note to remind you about the command to test your apache config file before actually restarting apache: You can check your…

  • Basic iptables rules: open a port to one IP address

    **Here is some basic iptable rules. Thanks goes to the cloud support team at Rackspace. This rule appends the rule. This particular rule opens inbound port 5432 to the…

  • How to do a cfdump in cfscript

    Today I needed to do a cfdump in cfscript. Turns out this is easy in Coldfusion 9: WriteDump (var, output, format, abort, label, metainfo, top, show, hide, keys, expand,…

  • Using Vacuumdb in PostgreSQL

    I read in the PostgreSQL docs that vacuumdb or vacuum should be used on the databases every day. I have been running it manually the last couple of days and it has made a…

  • How to create a database in PostgreSQL

    Today I needed to create a database with SQL_ASCII encoding. Here is the command I used: CREATE DATABASE MyDB ENCODING 'SQL_ASCII' TEMPLATE template0; I had to use template0…

  • How to exit a psql command prompt

    I had trouble figuring out how to exit the psql command prompt today in PostgreSQL. After reviewing the docs I found it rather easy. \q (back slash q)

  • How to Find and Uninstall a Package Using RPM

    Today I needed to be able to find a package and uninstall the package. HowToForge saved the day with a great forum post To find packages: rpm -qa | grep -i webmin To unistall…

  • How to resume a ctrl-z stopped job

    Today before I knew how to exit a psql command prompt in PostgreSQL I used ctrl-z to exit. I wanted to get back into psql so I went to Google to find out how. This time…

  • Installing PostgreSQL Server

    I found this article today when looking for an install guide of PostgreSQL Server on CentOS 5. I had to switch the install commands to 91 but it went smoothly. An Almost Idiots…

  • PostgreSQL on the command line

    I am just getting back into PostgreSQL. Here are the things I had to learn today: 1. Command line usage: su - postgres psql select version(); 2. Dumping data for import…

  • IIS 7 Coldfusion 500 error

    This is a reminder to people that might be getting a 500 error when creating a site in IIS7 with coldfusion support. I used the Coldfusion web config tool but was still getting a…