[Pkg-roundcube-maintainers] Bug#963875: roundcube: SQL Error

[Nigel Horne]

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 at localhost: user creation needed.
granting access to database roundcube for roundcube at 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 at localhost: user creation needed.
granting access to database roundcube for roundcube at 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 at 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