The Hadith of The Drought

أصاب الناس قحط في زمن عمر فجاء رجل إلى قبر النبي صلى الله عليه وسلم فقال: يا رسول الله، استسق لأمتك فإنهم قد هلكوا، فأتي الرجل في المنام فقيل له: ائت عمر فأقرئه السلام وأخبره أنكم مسقيون، وقل له: عليك الكيس عليك الكيس، فأتى عمر فأخبره، فبكى عمر ثم قال: يا رب لا آلوا إلا ما عجزت عنه

A man came to the grave of the Prophet (peace be upon him) and said, “O Messenger of Allah, ask for help for your nation, for they have perished.” The man was told in a dream: “Come to Umar, give him peace, tell him that you will be watered, and tell him, ‘You must be careful, you must be careful,’” so he came to Umar and told him, and Umar wept and then said, “Lord, I will only do what I am unable to do.

From those who authenticated it:

• Ibn Ḥajar al-Haytamī

• Ibn Ḥajar al-ʿAsqalānī

• Ibn al-Ramlī

• Ibn Kathīr

• Ibn ʿAbd al-Barr (d. 463)

• Muḥibb al-Dīn al-Ṭabarī (d. 694)

• al-Qasṭallānī (d. 923)

• Ibn ʿAsākir (d. 571)

• al-Suyūṭī (d. 911)

• al-Bayhaqī (d. 458)

• al-Dhahabī (d. 748)

• al-Samhūdī (d. 911)

• al-Zarqānī (d. 1122)

• Abū Yaʿlā al-Khalīlī (d. 446)

• Ibn Mandhūr (d. 711)

• Ibn ʿAllān (d. 1057)

https://www.islamweb.net/ar/fatwa/58311/تهافت-قصة-الرجل-الذي-أتى-قبر-النبي-وقال-استسق-لأمتك