Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: violetdragon92 on June 30, 2018, 07:21:51 PM

Title: MySQL not avaible in Roundcube yet its installed
Post by: violetdragon92 on June 30, 2018, 07:21:51 PM

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.

Title: Re: MySQL not avaible in Roundcube yet its installed
Post by: SKaero on July 01, 2018, 09:42:09 AM

What php packages do you have installed?

Title: Re: MySQL not avaible in Roundcube yet its installed
Post by: violetdragon92 on July 02, 2018, 03:08:46 PM

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

Thanks.

Title: Re: MySQL not avaible in Roundcube yet its installed
Post by: SKaero on July 02, 2018, 03:15:36 PM

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

Code: [Select]

apt list --installed | grep php

and post the output.

Title: Re: MySQL not avaible in Roundcube yet its installed
Post by: violetdragon92 on July 02, 2018, 03:20:13 PM

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#

Title: Re: MySQL not avaible in Roundcube yet its installed
Post by: SKaero on July 02, 2018, 04:39:41 PM

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]

sudo phpenmod pdo_mysql

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

Title: Re: MySQL not avaible in Roundcube yet its installed
Post by: violetdragon92 on July 02, 2018, 04:45:34 PM

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.

Title: Re: MySQL not avaible in Roundcube yet its installed
Post by: violetdragon92 on July 02, 2018, 04:59:59 PM

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

Thanks.

Title: Re: MySQL not avaible in Roundcube yet its installed
Post by: violetdragon92 on July 02, 2018, 07:13:26 PM

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

Thank you :D