Would you be willing to share you you got the bulb socket connected to the pipe? I have a chandelier almost complete, except that everyone just seems to shove the socket into a piece of pipe and let tight wires do the work. I just don't want to go that route. Any guidance would be greatly appreciated. Thanks!