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,
Comments
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
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.
> 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.