Our blog has articles covering how to paint over water stains, both previously-painted surfaces and with odourless products:

• How To Paint Previously Painted Water Stained Surfaces
• How To Paint Over Water Stains (Odourless Method)