Unable to install a rpm on Rocky 8

Since those messages aren’t complaining about specific versions, it suggests that various packages are simply not installed. Try installing with “dnf install /path/to/my-package.rpm” and let it try to work out the dependencies. I do note that libwrap.so appears to be provided by tcp-wrapper-libs, and you would need to have the “epel” repo enabled in order to find that package.