Mailcow Admin Login Issue Resolution

I am seeking an experienced freelancer with expertise in Mailcow to help resolve an admin login issue on our Dockerized Mailcow installation on an Ubuntu VPS. Despite resetting the admin password manually via MariaDB with a valid bcrypt hash and taking several troubleshooting steps, we continue to receive an "Invalid password" error.

Key Requirements:
- Diagnose and fix the admin login issue, either by restoring access to the existing admin account or creating an emergency user.
- Provide a detailed explanation of what went wrong during the password reset process.
- Offer clear instructions to prevent similar issues in the future.

Environment Details:
- Ubuntu VPS with Mailcow (latest, Dockerized)
- Root SSH access is available for troubleshooting
- Authentication error messages have been observed

Ideal Skills and Experience:
- Proven experience with Mailcow installations and troubleshooting
- Strong understanding of Dockerized environments and MariaDB
- Ability to interpret and resolve authentication errors
- Excellent communication skills to explain the issue and preventive measures

Please only respond if you have relevant Mailcow experience, as we need this issue resolved promptly.