if designing something for fun and casual, then log in.

if something technical and security-ish, then sign in.

think of logging in like stamping a time card at machine and signing in like filling out a line on a log book at the guard house. one is more involved than the other.