package drupal6 6.16-1ubuntu0.1 failed to install/upgrade: subprocess installed pre-removal script returned error exit status 1

[Nick Seth-Smith]

Drupal6 failed to install since dbconfig was unable to confirm that the appropriate grants had been made in the mysql database.

The bug exists in /usr/share/dbconfig-common/internal/mysql line 146 in the specific version I have installed. The script is checking for the wrong type of quote marks so fails to match the assigned grants. I corrected to '"' and the script performs correctly. I suspect this to be specific to certain versions of mysql and may, further, vary by specific locale / configuration etc.

Here is the corrected line for my system:
     if ! _dbc_nodb="yes" dbc_mysql_exec_command "SHOW GRANTS FOR '$dbc_dbuser'@'$l_dballow'" | grep -qi "GRANT .* ON \"$dbc_dbname\""; then
147 return 1

Note the double quotes around $dbc_dbname

Thanks

Nick SS

ProblemType: Package
DistroRelease: Ubuntu 10.04
Package: drupal6 6.16-1ubuntu0.1
ProcVersionSignature: Ubuntu 2.6.32-31.61-generic 2.6.32.32+drm33.14
Uname: Linux 2.6.32-31-generic x86_64
NonfreeKernelModules: fglrx
AptOrdering: drupal6: Purge
Architecture: amd64
Date: Tue May 24 12:26:03 2011
ErrorMessage: subprocess installed pre-removal script returned error exit status 1
PackageArchitecture: all
SourcePackage: drupal6
Title: package drupal6 6.16-1ubuntu0.1 failed to install/upgrade: subprocess installed pre-removal script returned error exit status 1

[dino99 (9d9)]

Closing that outdated report as EOL has been reached long time ago