It certainly appears to be made up by him. I haven't found any evidence it relates to the Civil War, as the dates and military references seem to allude.

Most information I've found write that Mother Rackett's was probably a bar in Hong Kong around 1875; though it could be possible Brand simply combined two songs with similar themes/rhythms, the complete lack of any evidence makes it hard to accept as genuine.