Bug#848137: tango-db: fails to upgrade from 'jessie': mysqldump: tango has insufficent privileges to SHOW CREATE PROCEDURE `class_att_prop`!

[PICCA Frederic-Emmanuel]

Hello Andreas,

> In jessie, tango-db used mysql-server-5.5 (via mysql-server).
> The upgrade of tango-db was performed after mysql-server had been upgraded
> to mariadb-server-10.0 (via default-mysql-server) and was started again.

do you know if the mariadb-server was running during the upgrade of tango-db.
Because tango-db need a running server in order to work.

My problem is that tango-db provide a daemon which require a running 
mysql/mariadb running server in order to be installed.

BUT.

I do not know how to express via Dependencies, how to have a running 
mysql/mariadb server.
Especially if this running server is running on another computer than the one 
where I install the tango-db package.

I need to support both scenarios

tango-db + mysql on the same server (Maybe a Pre-Depends)
tango-db and mysql/mariad server on different computers.
 
cheers

Fred

Bug#848137: tango-db: fails to upgrade from 'jessie': mysqldump: tango has insufficent privileges to SHOW CREATE PROCEDURE `class_att_prop`!

[Andreas Beckmann]

Package: tango-db
Version: 9.2.5~rc1+dfsg1-2
Severity: serious
User: debian...@lists.debian.org
Usertags: piuparts

Hi,

during a test with piuparts I noticed your package fails to upgrade from
'jessie'.
It installed fine in 'jessie', then the upgrade to 'stretch' fails.

>From the attached log (scroll to the bottom...):

  Setting up tango-db (9.2.5~rc1+dfsg1-2) ...
  Installing new version of config file /etc/init.d/tango-db ...
  Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
  dbconfig-common: writing config to /etc/dbconfig-common/tango-db.conf
  Replacing config file /etc/dbconfig-common/tango-db.conf with new version
  creating database backup in 
/var/cache/dbconfig-common/backups/tango-db_8.1.2c+dfsg-5.2016-12-14-10.08.39.
  error encountered backing up the old database:
  mysqldump: tango has insufficent privileges to SHOW CREATE PROCEDURE 
`class_att_prop`!
  dbconfig-common: tango-db configure: aborted.
  dbconfig-common: flushing administrative password
  dpkg: error processing package tango-db (--configure):
   subprocess installed post-installation script returned error exit status 1

In jessie, tango-db used mysql-server-5.5 (via mysql-server).
The upgrade of tango-db was performed after mysql-server had been upgraded
to mariadb-server-10.0 (via default-mysql-server) and was started again.


cheers,

Andreas


tango-db_9.2.5~rc1+dfsg1-2.log.gz
Description: application/gzip