Rockets have crashed into a US base and a house in northern Afghanistan along the Pakistan border, killing two Nato soldiers and three civilians, officials say.