Cant login to Rainloop

svenms

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,

svenms

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

seff

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] https://repo.dovecot.org/ce-2.3-latest/ubuntu/bionic bionic main
---

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

3. Installed dovecot-mysql via APT.

abdulsamad544

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.