I assume you have checked that it isn't coming from kidneys as the result of a urinary tract infection? (cloudy or smelly urine, or raised temperature).

I get really awful pain over hip bones and that is what keeps me from being comfortable during the night.