Amazon Pipe lamp parts kit
Or, try a Leviton weatherproof lamp holder from Home Depot and a 1-1/4" to 3/4" black pipe reducer
Vintage Wire and Supply
It looks like they have all the parts for the lamp you're building.