Author Topic: MySQL not avaible in Roundcube yet its installed  (Read 3001 times)

Offline violetdragon92

  • Newbie
  • *
  • Posts: 6
MySQL not avaible in Roundcube yet its installed
« 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.


Online SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: MySQL not avaible in Roundcube yet its installed
« Reply #1 on: July 01, 2018, 09:42:09 AM »
What php packages do you have installed?

Offline violetdragon92

  • Newbie
  • *
  • Posts: 6
Re: MySQL not avaible in Roundcube yet its installed
« Reply #2 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.

Online SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: MySQL not avaible in Roundcube yet its installed
« Reply #3 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.

Offline violetdragon92

  • Newbie
  • *
  • Posts: 6
Re: MySQL not avaible in Roundcube yet its installed
« Reply #4 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#

Online SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: MySQL not avaible in Roundcube yet its installed
« Reply #5 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.

Offline violetdragon92

  • Newbie
  • *
  • Posts: 6
Re: MySQL not avaible in Roundcube yet its installed
« Reply #6 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.

Offline violetdragon92

  • Newbie
  • *
  • Posts: 6
Re: MySQL not avaible in Roundcube yet its installed
« Reply #7 on: July 02, 2018, 04:59:59 PM »
Hi just a update. I managed to fix it :). MySQL is now available :)

Thanks.


Offline violetdragon92

  • Newbie
  • *
  • Posts: 6
Re: MySQL not avaible in Roundcube yet its installed
« Reply #8 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