Monday, September 10, 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 worse, the result of this issue caused the checkout process to error preventing our customers from finishing their orders.

So after doing a little research on my end I ended up calling the UPS technical support phone number for the United States:

Over the phone we went over the following steps:

You must add and authenticate your account using Account Summary to view Negotiated Rates in UPS Internet Shipping, Time and Cost Calculator on, and the UPS Developer Kit - Shipping and Rating APIs.

To add and authenticate an account:

1. Login to using your My UPS ID and password.
2. Select the My UPS tab at the top of the page.
3. Select Account Summary from the navigation menu or the tab rollover.
4. From there select Add an Existing UPS Account.
5. Follow the steps to authenticate the account. To authenticate your account you will need the following information from your most recent UPS invoice: invoice date, amount due, invoice number, and control number.

Normally this should work but for us it did not because we already did those steps. My case was escalated and I am waiting for a call back.

I disabled UPS on the website so our customers could still place an order.  Now I can breath a little easier.

I will update this post with the resolution as it becomes available.

*UPDATE at 1:57pm*
UPS called me back and told me there is a global outage for negotiated rates.  They estimate a minimum of 2 hours to restore access.

Thursday, August 23, 2012

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

I chose to just stop and restart Jetty because I was on a dev box.  The instructions seem to be straight forward.

My question is though.  If I disable the memory mapped files will there a performance degradation?

Monday, August 6, 2012

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.

Tuesday, July 31, 2012

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

Thursday, June 7, 2012

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 the link:

Railo Admin Password Reset

Monday, May 7, 2012

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 server.

This command does the trick.

yum list installed | grep "postgres"

Monday, April 9, 2012

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.

Here is the SPF record to use:

v=spf1 ~all

Wednesday, March 28, 2012

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 configuration files for syntax errors without starting the server by using apachectl configtest or the -t command line option.

Source: Apache Docs

Friday, March 23, 2012

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 ipaddress

iptables -A RH-Firewall-1-INPUT -p tcp -s --dport 5432 -j ACCEPT

This rule inserts the rule at the start of the chain.  

iptables -I RH-Firewall-INPUT -s -p tcp -m tcp --dport 5432 -j ACCEPT

After adding rules you need to issue this command to save the rules.

service iptables save

After saving you need to issue the restart command
service iptables restart

If you want to see the available chains in your firewall use this command:
iptables -L

Thursday, March 22, 2012

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, showUDFs);

My Example:

WriteDump (var=results,output=true,format="html",abort=true);

Adobe Help

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 difference on query response times. I highly recommend using it.

To vacuum one database from the command line.

vacuumdb -d MyDB -v  -z -U postgres 

To vacuum one database from the command line.

vacuumdb -a -v  -z -U postgres 

-d = database name
-v = verbose output
-z = analyze
-U = username
-a = vacuum all databases

Tuesday, March 20, 2012

How to create a database in PostgreSQL

Today I needed to create a database with SQL_ASCII encoding.

Here is the command I used:

I had to use template0 because template1 was set to UTF8.

I still need to dig in on the templates and what they are all about.

Monday, March 19, 2012

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 came to my rescue.

It is as simple as this:


Read the post for other options, but the above is what I needed.  Worked like a charm

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 the package:

rpm -e <package name>

If you need to uninstall more than one package at a time

rpm -e <package name> <package name> <package name>

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 Guide To Install PostgreSQL 9.0 With YUM

Saturday, March 17, 2012

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 on another server
  • pg_dump -o mydb -U postgres -W > mydb.sql
  • -o has to do with oids (Not sure if I need this yet)
  • -U is for user
  • -W is for password.  It prompts when you run the command

Friday, March 16, 2012

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 500 error.  I then remembered it was a 64bit machine but it was Coldfusion was 32bit.  I had to go into the advance settings for the application pool and set Enable 32-bit Applications to true.