Package: roundcube Version: 1.4.6+dfsg.1-2 Severity: normal Fails to install properly with 'apt install roundcube':
Creating config file /etc/roundcube/debian-db.php with new version checking privileges on database roundcube for roundcube@localhost: user creation needed. granting access to database roundcube for roundcube@localhost: failed. error encountered creating user: mysql said: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS 'roundcube'@'localhost'' at line 1 dbconfig-common: roundcube configure: trying again. Determining localhost credentials from /etc/mysql/debian.cnf: succeeded. dbconfig-common: writing config to /etc/dbconfig-common/roundcube.conf checking privileges on database roundcube for roundcube@localhost: user creation needed. granting access to database roundcube for roundcube@localhost: failed. error encountered creating user: mysql said: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS 'roundcube'@'localhost'' at line 1 dbconfig-common: roundcube configure: ignoring errors from here forwards -- System Information: Debian Release: bullseye/sid APT prefers testing APT policy: (500, 'testing'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 5.4.0-4-amd64 (SMP w/8 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8), LANGUAGE=en_GB:en (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages roundcube depends on: ii dpkg 1.19.7 ii roundcube-core 1.4.6+dfsg.1-2 roundcube recommends no packages. roundcube suggests no packages. Versions of packages roundcube-core depends on: ii dbconfig-common 2.0.13 ii debconf [debconf-2.0] 1.5.74 ii dpkg 1.19.7 ii libapache2-mod-php 2:7.4+76 ii libapache2-mod-php7.4 [libapache2-mod-php] 7.4.5-1+b1 ii libjs-bootstrap4 4.4.1+dfsg1-2 ii libjs-codemirror 5.54.0-1 ii libjs-jquery 3.5.1+dfsg-4 ii libjs-jquery-minicolors 2.2.6+dfsg-3 ii libjs-jquery-ui 1.12.1+dfsg-5 ii libjs-jstimezonedetect 1.0.6-4 ii libmagic1 1:5.38-5 ii php-auth-sasl 1.0.6-3 ii php-cli 2:7.4+76 ii php-common 2:76 ii php-intl 2:7.4+76 ii php-mail-mime 1.10.7-1 ii php-masterminds-html5 2.7.0+dfsg-3 ii php-mbstring 2:7.4+76 ii php-net-sieve 1.4.1-1 ii php-net-smtp 1.9.0-1 ii php-net-socket 1.0.14-2 ii php-pear 1:1.10.9+submodules+notgz-1 ii php7.4-cli [php-cli] 7.4.5-1+b1 ii php7.4-intl [php-intl] 7.4.5-1+b1 ii php7.4-json [php-json] 7.4.5-1+b1 ii php7.4-mbstring [php-mbstring] 7.4.5-1+b1 ii roundcube-mysql 1.4.6+dfsg.1-2 ii ucf 3.0043 Versions of packages roundcube-core recommends: ii apache2 [httpd-cgi] 2.4.43-1 ii php-gd 2:7.4+76 ii php-pspell 2:7.4+76 ii php7.4-gd [php-gd] 7.4.5-1+b1 ii php7.4-pspell [php-pspell] 7.4.5-1+b1 Versions of packages roundcube-core suggests: pn php-crypt-gpg <none> pn php-mkopinsky-zxcvbn-php <none> pn php-net-ldap3 <none> pn roundcube-plugins <none> -- debconf information: * roundcube/mysql/admin-user: debian-sys-maint roundcube/language: en_GB roundcube/pgsql/admin-user: postgres roundcube/dbconfig-upgrade: true roundcube/internal/reconfiguring: false * roundcube/install-error: ignore roundcube/pgsql/authmethod-user: password roundcube/dbconfig-remove: true roundcube/restart-webserver: true roundcube/reconfigure-webserver: apache2, lighttpd roundcube/remote/host: localhost roundcube/remote/port: roundcube/pgsql/no-empty-passwords: roundcube/pgsql/authmethod-admin: ident roundcube/pgsql/manualconf: roundcube/remove-error: abort roundcube/internal/skip-preseed: false * roundcube/mysql/method: Unix socket roundcube/passwords-do-not-match: roundcube/db/basepath: * roundcube/db/app-user: roundcube@localhost roundcube/purge: false roundcube/dbconfig-reinstall: false * roundcube/db/dbname: roundcube roundcube/remote/newhost: roundcube/pgsql/method: TCP/IP roundcube/upgrade-error: abort * roundcube/mysql/authplugin: default roundcube/database-type: mysql roundcube/upgrade-backup: true * roundcube/dbconfig-install: true roundcube/hosts: roundcube/pgsql/changeconf: false roundcube/missing-db-package-error: abort
