[Pkg-nagios-devel] Bug#677844: icinga-web: postinst fails to set root passwd - MYSQL_PWD env var not working

[Thomas Debost]

Package: icinga-web
Version: 1.7.0-2
Severity: important

Dear Maintainer,

icinga-web fails to install on my server. 

After investigation, it appeared that the command that fails is the following:

        echo "UPDATE nsm_user SET user_password='""$pwhash_e""', user_salt = '""$salt_e""' WHERE user_name = 'root';" \
                     | mysql -h "${dbc_dbhost:=localhost}" -u "$dbc_dbuser" "$dbc_dbname"

The password previously stored in $MYSQL_PWD is not working.

Install was successful after a quick change to postinst to the following.

        echo "UPDATE nsm_user SET user_password='""$pwhash_e""', user_salt = '""$salt_e""' WHERE user_name = 'root';" \
                     | mysql -h "${dbc_dbhost:=localhost}" -u "$dbc_dbuser" -p$dbc_dbpass "$dbc_dbname"

I hope this helps

Tom

-- System Information:
Debian Release: wheezy/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'testing-proposed-updates'), (500, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.2.0-2-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages icinga-web depends on:
ii  dbconfig-common        1.8.47+nmu1
ii  debconf [debconf-2.0]  1.5.43
ii  icinga-core            1.7.0-3
ii  icinga-idoutils        1.7.0-3
ii  php5                   5.4.4~rc2-1
ii  php5-cli               5.4.4~rc2-1
ii  php5-gd                5.4.4~rc2-1
ii  php5-mysql             5.4.4~rc2-1
ii  php5-xsl               5.4.4~rc2-1
ii  ucf                    3.0025+nmu3

Versions of packages icinga-web recommends:
ii  apache2                          2.2.22-6
ii  apache2-mpm-prefork [httpd]      2.2.22-6
ii  lighttpd [httpd]                 1.4.31-1
ii  mysql-client-5.5 [mysql-client]  5.5.24+dfsg-3

icinga-web suggests no packages.

-- debconf information:
* icinga-web/install-error: ignore
  icinga-web/missing-db-package-error: abort
  icinga-web/upgrade-error: abort
* icinga-web/db/dbname: local_icingaweb
  icinga-web/dbconfig-reinstall: false
  icinga-web/pgsql/method: unix socket
  icinga-web/remote/port:
* icinga-web/mysql/method: unix socket
* icinga-web/mysql/admin-user: root
  icinga-web/pgsql/manualconf:
* icinga-web/httpd: apache2
  icinga-web/internal/reconfiguring: false
  icinga-web/pgsql/admin-user: postgres
* icinga-web/database-type: mysql
  icinga-web/remote/host:
  icinga-web/pgsql/changeconf: false
  icinga-web/dbconfig-upgrade: true
  icinga-web/db/basepath:
  icinga-web/remote/newhost:
  icinga-web/upgrade-backup: true
  icinga-web/remove-error: abort
  icinga-web/internal/skip-preseed: false
  icinga-web/purge: false
  icinga-web/pgsql/authmethod-user: password
* icinga-web/db/app-user: icingaweb
  icinga-web/pgsql/no-empty-passwords:
* icinga-web/rootpassword-mismatch:
  icinga-web/dbconfig-remove:
* icinga-web/dbconfig-install: true
  icinga-web/pgsql/authmethod-admin: ident
  icinga-web/passwords-do-not-match: