I note that general elements of a module do not have a multiplication, so $a \cdot b$ need not make sense there.
What you have actually asked is whether two elements of the ring $R$ can have a product which is zero. Yes. In the ring $\mathbb{Z}/6\mathbb{Z}$, $2 \neq 0$, $3 \neq 0$, and $2 \cdot 3 \cong 6 \cong 0$. We say that $\mathbb{Z}/6\mathbb{Z}$ has zero divisors. We can treat $\mathbb{Z}/6\mathbb{Z}$ as a module over itself, yielding a module which does what you are describing.
Normally, the definition of module does not exclude rings with zero divisors. If we wished to exclude zero divisors, one way is to say "module over an integral domain". (This is a restriction of "module" = "module over a ring", in that an integral domain is a commutative ring and it has no zero divisors.)
Note that in any ring with zero divisor, $z$, and (at least) a unit, $u$, there is a $z'$ such that $z z' = 0$. But then $(z+u)z' = zz'+uz' = uz'$, so right cancellation doesn't hold. Be a little careful when there are zero divisors around.