Who were the holy man who was allowed to see the messiah before he died and who prophesied sorrow for Mary?

Simeon.

25And, behold, there was a man in Jerusalem, whose name was Simeon; and the same man was just and devout, waiting for the consolation of Israel: and the Holy Ghost was upon him. 26 And it was revealed unto him by the Holy Ghost, that he should not see death, before he had seen the Lord's Christ by the Spirit into the temple: and when the parents brought in the child Jesus, to do for him after the custom of the law, 28 Then took he him up in his arms, and blessed God, and said, 29 Lord, now lettest thou thy servant depart in peace, according to thy Word: 30 For mine eyes have seen thy salvation,and before the face of all people; 32 A light to lighten the Gentiles, and the glory of thy people Israel. 33 And Joseph and his mother marvelled at those things which were spoken of him. 34 And Simeon blessed them, and said unto Mary his mother, Behold, this child is set for the fall and rising again of many in Israel; and for a sign which shall be spoken against; 35 (Yea, a sWord shall pierce through thy own soul also,) that the thoughts of many hearts may be revealed.