Roundcube / MariaDB problems
Hi there
I just tried to install Roundcube on Jessie.
I did install apache, php, mariadb and they work fine. After that I
wanted to install Roundcube and it seems there's problems with
authentication for MariaDB:
apt-get install roundcube
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
php-net-sieve php-patchwork-utf8 roundcube-core roundcube-mysql
Suggested packages:
php-crypt-gpg roundcube-plugins php-net-ldap2 php-net-ldap3
The following NEW packages will be installed:
php-net-sieve php-patchwork-utf8 roundcube roundcube-core roundcube-mysql
0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded.
Need to get 2,174 kB of archives.
After this operation, 13.6 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://ftp.ch.debian.org/debian/ jessie-backports/main
roundcube-mysql all 1.1.5+dfsg.1-1~bpo8+2 [67.2 kB]
Get:2 http://ftp.ch.debian.org/debian/ jessie/main php-net-sieve all
1.3.2-4 [19.3 kB]
Get:3 http://ftp.ch.debian.org/debian/ jessie/main php-patchwork-utf8
all 1.1.25-1 [157 kB]
Get:4 http://ftp.ch.debian.org/debian/ jessie-backports/main
roundcube-core all 1.1.5+dfsg.1-1~bpo8+2 [1,929 kB]
Get:5 http://ftp.ch.debian.org/debian/ jessie-backports/main roundcube
all 1.1.5+dfsg.1-1~bpo8+2 [1,462 B]
Fetched 2,174 kB in 0s (2,915 kB/s)
Preconfiguring packages ...
Selecting previously unselected package roundcube-mysql.
(Reading database ... 59925 files and directories currently installed.)
Preparing to unpack .../roundcube-mysql_1.1.5+dfsg.1-1~bpo8+2_all.deb ...
Unpacking roundcube-mysql (1.1.5+dfsg.1-1~bpo8+2) ...
Selecting previously unselected package php-net-sieve.
Preparing to unpack .../php-net-sieve_1.3.2-4_all.deb ...
Unpacking php-net-sieve (1.3.2-4) ...
Selecting previously unselected package php-patchwork-utf8.
Preparing to unpack .../php-patchwork-utf8_1.1.25-1_all.deb ...
Unpacking php-patchwork-utf8 (1.1.25-1) ...
Selecting previously unselected package roundcube-core.
Preparing to unpack .../roundcube-core_1.1.5+dfsg.1-1~bpo8+2_all.deb ...
Unpacking roundcube-core (1.1.5+dfsg.1-1~bpo8+2) ...
Selecting previously unselected package roundcube.
Preparing to unpack .../roundcube_1.1.5+dfsg.1-1~bpo8+2_all.deb ...
Unpacking roundcube (1.1.5+dfsg.1-1~bpo8+2) ...
Setting up roundcube-mysql (1.1.5+dfsg.1-1~bpo8+2) ...
Setting up php-net-sieve (1.3.2-4) ...
Setting up php-patchwork-utf8 (1.1.25-1) ...
Setting up roundcube-core (1.1.5+dfsg.1-1~bpo8+2) ...
dbconfig-common: writing config to /etc/dbconfig-common/roundcube.conf
Creating config file /etc/dbconfig-common/roundcube.conf with new version
Creating config file /etc/roundcube/debian-db.php with new version
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO).
unable to connect to mysql server.
error encountered creating user:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
dbconfig-common: roundcube configure: aborted.
dbconfig-common: flushing administrative password
dpkg: error processing package roundcube-core (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of roundcube:
roundcube depends on roundcube-core (= 1.1.5+dfsg.1-1~bpo8+2); however:
Package roundcube-core is not configured yet.
dpkg: error processing package roundcube (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
roundcube-core
roundcube
E: Sub-process /usr/bin/dpkg returned an error code (1)
Because of that, the next thing I tried (after resetting the VM) was to
stop MariaDB, start it with --skip-grant-tables and then try to install
the roundcube packages. Thinking when it has problems authenticating, I
just skip that step. However that was also unsuccessfull:
mysql said: ERROR 1290 (HY000) at line 1: The MariaDB server is running
with the --skip-grant-tables option so it cannot execute this statement
Plus more errors.
So basically, there's a problem with the debian package not asking for
root password to add MariaDB dbs, tables, users.
Reply to: