MySQL not avaible in Roundcube yet its installed

[violetdragon92]

Hi,

Ive spent the last 24 hours without sleep trying to sort Roundcube out. I want to have my emails in a web ui however ive had nothing but hassle with MySQL keeps saying Not Avaible. Ive uninstalled it and reinstalled it so many times now but no joy. Im running Ubuntu 16.04. Id rather use a web UI for emails as i have so many devices and itll make it easier.

Thanks.

[SKaero]

What php packages do you have installed?

[violetdragon92]

Hi. Thanks for your reply. I believe the pnp package gets installed with the Limp Server?

Thanks.

[SKaero]

I would assume so but I'm guessing your missing some packages. Try running:

Code Select Expand


apt list --installed | grep php


and post the output.

[violetdragon92]

Heres the output of that,

libapache2-mod-php7.0/xenial,now 7.0.30-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed]
libapache2-mod-php7.1/xenial,now 7.1.18-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed]
libapache2-mod-php7.2/xenial,now 7.2.7-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed]
php-common/xenial,xenial,now 1:60+ubuntu16.04.1+deb.sury.org+1 all [installed,automatic]
php-mysql/xenial,xenial,now 1:7.2+60+ubuntu16.04.1+deb.sury.org+1 all [installed]
php-xml/xenial,xenial,now 1:7.2+60+ubuntu16.04.1+deb.sury.org+1 all [installed]
php7.0-cli/xenial,now 7.0.30-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.0-common/xenial,now 7.0.30-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.0-json/xenial,now 7.0.30-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.0-mbstring/xenial,now 7.0.30-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed]
php7.0-opcache/xenial,now 7.0.30-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.0-readline/xenial,now 7.0.30-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.0-xml/xenial,now 7.0.30-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed]
php7.1-cli/xenial,now 7.1.18-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.1-common/xenial,now 7.1.18-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.1-json/xenial,now 7.1.18-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.1-opcache/xenial,now 7.1.18-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.1-readline/xenial,now 7.1.18-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.2-cli/xenial,now 7.2.7-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.2-common/xenial,now 7.2.7-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.2-json/xenial,now 7.2.7-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.2-mysql/xenial,now 7.2.7-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.2-opcache/xenial,now 7.2.7-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.2-readline/xenial,now 7.2.7-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.2-xml/xenial,now 7.2.7-1+ubuntu16.04.1+deb.sury.org+1 amd64 [installed,automatic]
root@Velvet:/home/jackbamford#

[SKaero]

I think that should be the correct packages, can you try to run the following to make sure the pdo driver is enabled:

Code Select Expand


sudo phpenmod pdo_mysql


Make sure to restart your web server after you make the change.

[violetdragon92]

Hi,

Just ran the Terminal Command i believe i have a module missing. Heres the Output.

WARNING: Module pdo_mysql ini file doesn't exist under /etc/php/7.1/mods-available
WARNING: Module pdo_mysql ini file doesn't exist under /etc/php/7.1/mods-available
WARNING: Module pdo_mysql ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module pdo_mysql ini file doesn't exist under /etc/php/7.0/mods-available

Thanks.

[violetdragon92]

Hi just a update. I managed to fix it . MySQL is now available

Thanks.

[violetdragon92]

I Would like to Thank you for your help. One happy chap. This can be marked as (Solved)

Thank you