An Afghan soldier has opened fire on American troops, wounding at least seven of them, before being shot dead in a military base in northern Afghanistan, officials said, in the second so-called "insider attack" in the past week.