[Webapps-common-packages] Bug#426701: Fails to create DB user; nobody cared to set dbc_dbadmpass

[Loïc Minier]

Package: bugzilla
Version: 2.22.1-2
Severity: important

        Hi,

 (I fail to understand the responsabilities of the bugzilla and
 dbconfig-common packages for prompting my MySQL root password, please
 reassign if necessary.)

 I'm not including reportbug information as I can't run reportbug from
 the production env but this is with etch's bugzilla and mysql and I
 tried with dbconfig-common from stable, testing, and now sid.

 When I turned on debugging of dbconfig-common, I saw:
vm-24# dpkg-reconfigure bugzilla
(config)dbc_config()dbc_set_dbtype_defaults().
dbc_register_debconf().
dbc_read_package_config().
dbc_preseed_package_debconf().
dbc_get_app_pass().
(postinst)dbc_config()dbc_set_dbtype_defaults().
dbc_read_package_debconf().
dbc_set_dbtype_defaults()settings       dbc_install=true.
        dbc_upgrade=true.
        dbc_remove=.
        dbc_dbtype=mysql.
        dbc_dbuser=bugzilla.
        dbc_dbpass=5ztDpYrzapy6E.
        dbc_dbadmin=root.
        dbc_dbadmpass=.
        dbc_dbserver=.
        dbc_dbport=.
        dbc_dbname=bugzilla.
        dbc_authmethod_admin=.
        dbc_authmethod_user=.
        dbc_ssl=.
dbc_write_package_config().
dbconfig-common: writing config to /etc/dbconfig-common/bugzilla.conf
dbc_read_package_config().
error encountered creating user:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
dbconfig-common: bugzilla configure: aborted.
dbc_postinst_cleanup().
dbc_forget_dbadmin_password().
dbconfig-common: flushing administrative password
dbc_forget_app_password().

 I decided to add dbc_dbadmpass='3nugKnzQlWMDQ' to
 /etc/dbconfig-common/bugzilla.conf manually, and it continued until:
        dbc_authmethod_admin=.
        dbc_authmethod_user=.
        dbc_ssl=.
dbc_write_package_config().
dbconfig-common: writing config to /etc/dbconfig-common/bugzilla.conf
dbc_read_package_config().
dbc_postinst_cleanup().
dbc_forget_app_password().

Can't connect to the database.
Error: Access denied for user 'bugzilla'@'localhost' (using password: YES)
  Is your database installed and up and running?
  Do you have the correct username and password selected in localconfig?

 Running dpkg-reconfigure one more time got to the point where:
dbc_write_package_config().
dbconfig-common: writing config to /etc/dbconfig-common/bugzilla.conf
dbc_read_package_config().
granting access to database bugzilla for bugzilla at localhost: success.
verifying access for bugzilla at localhost: success.
creating database bugzilla: success.
verifying database bugzilla exists: success.
dbc_postinst_cleanup().
dbc_forget_app_password().

 => the bugzilla user and databases have been created.

 I can connect just fine with "mysql -u bugzilla -p bugzilla" and the
 bugzilla password, but the maintainer scripts for some reason can't.

 I decided to run checksetup.pl manually, which failed as well, and it
 turned out that /etc/bugzilla/localconfig had "secret" as password
 instead of the bugzilla user's password.  Fixed this and entered a
 couple of values in checksetup, and it worked.

 The only odd thing that happened on this naked etch system is that when
 installing bugzilla (which pulled mysql), mysql did not start; I had to
 start it manually and set its root password by dpkg-reconfigure.

 I also had to do a weird merge between two bugzilla configuration
 files, but this was my first install.

   Bye,
-- 
Loïc Minier