Family and friends have farewelled the man who died of stab wounds on a quiet street north of Brisbane.