Cant login to Rainloop

Hello,

I am using CyberPanel Official installed in GCP .
I cant login to rainloop email accounts resulting in “Authentication Failed”.
I checked email logs and the problem is:

localhost dovecot: auth: Fatal: sql: Unknown database driver ‘mysql’

On some forums they said to install dovecot-mysql, but I can’t because it returns:

dovecot-mysql : Depends: libmysqlclient20 (>= 5.7.11) but it is not installable
E: Unable to correct problems, you have held broken packages.

Please let me know hot to fix this,

Thank you for your response.

I installed Cyberpanel on Ubuntu 20.4 minimal on GCP but the problem remained.

Followed the next steps found on another discussion to solve:

apt remove dovecot-core dovecot-mysql dovecot-pop3d dovecot-imapd
sed -e ‘/deb/ s/^#*/#/’ -i /etc/apt/sources.list.d/dovecot.list
apt clean all
apt install dovecot-core dovecot-mysql dovecot-pop3d dovecot-imapd
apt-get install -y libmysqlclient-dev

Then check devecot status with:

systemctl status dovecot -l

Then you go to YourIP:8090/manageSSL/sslForMailServer and install a SSL certificate for your Domain.

Then it will work

I had the same issue on Ubuntu-20 after performing apt-get dist-upgrade.

  1. Modified /etc/apt/sources.list.d/dovecot.list as

deb [arch=amd64] Index of /ce-2.3-latest/ubuntu/bionic/ bionic main

  1. Manually installed the DEB package http://archive.ubuntu.com/ubuntu/pool/main/m/mysql-5.7/libmysqlclient20_5.7.21-1ubuntu1_amd64.deb

  2. Installed dovecot-mysql via APT.

Type your comment> @svenms said:

Thank you for your response.

I installed Cyberpanel on Ubuntu 20.4 minimal on GCP but the problem remained.

Followed the next steps found on another discussion to solve:

apt remove dovecot-core dovecot-mysql dovecot-pop3d dovecot-imapd
sed -e ‘/deb/ s/^#*/#/’ -i /etc/apt/sources.list.d/dovecot.list
apt clean all
apt install dovecot-core dovecot-mysql dovecot-pop3d dovecot-imapd
apt-get install -y libmysqlclient-dev

Then check devecot status with:

systemctl status dovecot -l

Then you go to YourIP:8090/manageSSL/sslForMailServer and install a SSL certificate for your Domain.

Then it will work

Thanks. you solution worked. actually on default installations these two issues need to be solved. At first, devecot needs to be resintalled and then ssl should be reissued.