Grading: The prohibition of every intoxicant, as marfu', is "sahih li-ghayrihi", while the rest of the report is authentic as the saying of 'Umar (may Allah be pleased with him), "mawquf" on him.
Technical note / Defect ('illah): There is disagreement over this chain from 'Amir al-Sha'bi; a group of weak and matruk (abandoned) narrators narrated it from al-Sha'bi from al-Nu'man bin Bashir, whereas a group of the narrators of the Sahih contradicted them and narrated it as "al-Sha'bi from Ibn 'Umar from 'Umar", mawquf, as will come; Imam al-Tirmidhi said that this (its being mawquf) is more correct. In this chain of the author (al-Hakim) there is "al-Sari bin Isma'il", who is a matruk narrator, and on this basis Imam al-Dhahabi declared it defective.

Reference / Source: Imam Ahmad recorded it 30/ (18407) from Yunus bin Muhammad, and Ibn Majah (3379) from Muhammad bin Rumh; both of them from al-Layth bin Sa'd, with this chain.

Reference / Source: Imam Ahmad recorded it (18350), Abu Dawud (3676), al-Tirmidhi (1872, 1873) and al-Nasa'i (6756) by way of Ibrahim bin al-Muhajir, from al-Sha'bi.
Technical note / Defect ('illah): Ibrahim bin al-Muhajir is "layyin" (soft, i.e. somewhat weak).

Reference / Source: Imam Abu Dawud recorded it (3677) and Ibn Hibban (5398) by way of Abu Hariz 'Abdullah bin Husayn al-Azdi, from al-Sha'bi.
Technical note / Defect ('illah): Abu Hariz is also "layyin" (weak).

Reference / Source: Imam al-Tabarani recorded this narration in "al-Mu'jam al-Awsat" (1103) and Imam al-Daraqutni in his "Sunan" (4646) by way of al-Sayyid bin 'Isa, from Mujalid bin Sa'id, from 'Amir bin Sharahil al-Sha'bi.
Technical note / Defect ('illah): Imam al-Tabarani said that no one narrated this hadith from Mujalid except al-Sayyid bin 'Isa.
Grading: We say: this chain is weak, because al-Sayyid bin 'Isa and Mujalid bin Sa'id al-Hamdani are both weak narrators.

Reference / Source: Imam al-Bazzar recorded it in his "Musnad" (3253) and Imam al-Daraqutni (4647) by way of Salamah bin Kuhayl, from al-Sha'bi.
Grading: This chain is "talif" (ruined, extremely weak), and nothing is to be gained by it.

Important point: As for the narration of al-Sha'bi from 'Abdullah bin 'Umar from 'Umar al-Faruq (may Allah be pleased with him) as "mawquf", it has been recorded by several imams.
Reference / Source: Al-Bukhari (5581), Muslim (3032), al-Tirmidhi (1874) and al-Nasa'i (5068), (5069), (6751) and (6752) recorded it by way of Abu Hayyan Yahya bin Sa'id al-Taymi; and al-Bukhari (5589) and al-Nasa'i (6753) by way of 'Abdullah bin Abi al-Safar; and al-Nasa'i (6754) by way of Muhammad bin Qays al-Asadi. All three of them (Abu Hayyan, 'Abdullah and Muhammad bin Qays) narrate it from al-Sha'bi.

Details of the narration: Abu Husayn ('Uthman bin 'Asim al-Asadi) also narrated it from al-Sha'bi, from Ibn 'Umar (may Allah be pleased with him).
Reference / Source: In al-Nasa'i (5070) and (6755) this narration stops at Ibn 'Umar and does not go beyond him (i.e. 'Umar is not mentioned in it).

Reference / Source: Imam al-Bukhari (4616) recorded by way of Nafi' from Ibn 'Umar (may Allah be pleased with him) that he said: When the prohibition of wine was revealed, there were at that time in Madinah five kinds of drinks, among which there was no grape wine.

Reference / Source: Imam Ahmad recorded it 10/ (5992) by way of 'Abdullah bin Lahi'ah, from Abu al-Nadr, from Salim bin 'Abdullah bin 'Umar, from his father (Ibn 'Umar), as "marfu'" (as a saying of the Prophet (peace and blessings be upon him)).

Technical note / Defect ('illah): 'Abdullah bin Lahi'ah is a weak narrator, so how can his narration be accepted when he contradicts the trustworthy narrators?! (i.e. the other trustworthy narrators reported it as mawquf).

Corroborating chains and supporting reports: This same saying is also narrated from Anas (may Allah be pleased with him) with an authentic chain, recorded by Imam Ahmad 19/ (12099).

General principle: On this topic there is also a marfu' narration from Abu Hurayrah (may Allah be pleased with him): "Wine comes from these two trees: the date-palm and the grapevine."
Reference / Source: It is in Musnad Ahmad 13/ (7753) and Sahih Muslim (1985).