Hey. See below... went actually much faster than I'd have expected.
I think it already shows the possible problem that happens:
>populating database via sql... warning: ident method specified but local
>account doesn't exist.
>warning: ident method specified but local account doesn't exist.
It thinks the account doesn't exist (which is correct, but doesn't
really matter) and I'd blindly assume now it falls back to TCP for this
reason?
One further thing I've just notied, there is no way to configure the
socket dir and "port", i.g.:
/var/run/postgresql/.s.PGSQL.5432
per default.
But this may be different and for postgresql there may be even multiple
daemons running all with their own "ports" e.g. .s.PGSQL.5433 ... this
is all perfectly supported out of the box by the debian packages with
the pg_* tools.
I'll open separate tickets for these in a minute.
Cheers,
Chris.
On Sat, 2016-08-13 at 22:56 +0200, Paul Gevers wrote:
> but having
> the output of dbc_debug=true will be extremely valuable and making my
> life in debugging a lot easier
# dpkg-reconfigure icinga2-ido-pgsql
(prerm) dbc_go() icinga2-ido-pgsql upgrade 2.4.10-1~bpo8+1.
dbc_config() icinga2-ido-pgsql upgrade 2.4.10-1~bpo8+1.
dbc_set_dbtype_defaults() .
dbc_read_package_config() .
dbc_set_dbtype_defaults() pgsql.
(config) dbc_go() icinga2-ido-pgsql reconfigure 2.4.10-1~bpo8+1.
dbc_config() icinga2-ido-pgsql reconfigure 2.4.10-1~bpo8+1.
dbc_set_dbtype_defaults() .
dbc_register_debconf() .
dbc_read_package_config() .
dbc_preseed_package_debconf() .
dbc_forget_app_password() .
dbc_get_app_pass() .
(postinst) dbc_go() icinga2-ido-pgsql configure 2.4.10-1~bpo8+1.
dbc_config() icinga2-ido-pgsql configure 2.4.10-1~bpo8+1.
dbc_set_dbtype_defaults() .
dbc_read_package_debconf() .
dbc_set_dbtype_defaults() pgsql.
settings determined from dbc_read_package_debconf:.
dbc_install=true.
dbc_upgrade=true.
dbc_remove=true.
dbc_dbtype=pgsql.
dbc_dbuser=icinga.
dbc_dbpass=t3QJ3BzYp2om.
dbc_dballow=.
dbc_dbadmin=postgres.
dbc_dbadmpass=.
dbc_dbserver=localhost.
dbc_dbport=.
dbc_dbname=icinga.
dbc_authmethod_admin=ident.
dbc_authmethod_user=ident.
dbc_ssl=.
dbc_write_package_config() .
dbconfig-common: writing config to /etc/dbconfig-common/icinga2-ido-pgsql.conf
dbc_read_package_config() .
dbc_detect_installed_dbtype() pgsql.
_dbc_detect_installed_dbtype() pgsql.
su -s /bin/sh postgres -c "env HOME='/tmp/dbconfig-common.psql_home.0wG8JU'
PGPASSFILE='/tmp/dbconfig-common.psql_home.0wG8JU/.pgpass' PGSSLMODE='prefer'
psql --set \"ON_ERROR_STOP=1\" -q -U 'postgres' template1" 2>&1.
creating postgres user icinga: su -s /bin/sh postgres -c "env
HOME='/tmp/dbconfig-common.psql_home.sCUNV3'
PGPASSFILE='/tmp/dbconfig-common.psql_home.sCUNV3/.pgpass' PGSSLMODE='prefer'
psql --set \"ON_ERROR_STOP=1\" -q -U 'postgres' template1" 2>&1.
su -s /bin/sh postgres -c "env HOME='/tmp/dbconfig-common.psql_home.7D4bvy'
PGPASSFILE='/tmp/dbconfig-common.psql_home.7D4bvy/.pgpass' PGSSLMODE='prefer'
psql --set \"ON_ERROR_STOP=1\" -q -U 'postgres' -U 'postgres' template1" 2>&1.
success.
verifying creation of user: su -s /bin/sh postgres -c "env
HOME='/tmp/dbconfig-common.psql_home.xFZUCY'
PGPASSFILE='/tmp/dbconfig-common.psql_home.xFZUCY/.pgpass' PGSSLMODE='prefer'
psql --set \"ON_ERROR_STOP=1\" -q -U 'postgres' template1" 2>&1.
success.
dbconfig-common: dumping pgsql database icinga to
/var/tmp/icinga2-ido-pgsql.icinga.2016-08-13-23.09.pgsql.4IRwbV.
su -s /bin/sh postgres -c "env HOME='/tmp/dbconfig-common.psql_home.NU1oJg'
PGPASSFILE='/tmp/dbconfig-common.psql_home.NU1oJg/.pgpass' PGSSLMODE='prefer'
psql --set \"ON_ERROR_STOP=1\" -q -U 'postgres' template1" 2>&1.
database does not exist.
dbconfig-common: dropping old pgsql database icinga.
su -s /bin/sh postgres -c "env HOME='/tmp/dbconfig-common.psql_home.UsQZjg'
PGPASSFILE='/tmp/dbconfig-common.psql_home.UsQZjg/.pgpass' PGSSLMODE='prefer'
psql --set \"ON_ERROR_STOP=1\" -q -U 'postgres' template1" 2>&1.
dropping database icinga: database does not exist.
_dbc_detect_installed_dbtype() psql.
su -s /bin/sh postgres -c "env HOME='/tmp/dbconfig-common.psql_home.FOmBye'
PGPASSFILE='/tmp/dbconfig-common.psql_home.FOmBye/.pgpass' PGSSLMODE='prefer'
psql --set \"ON_ERROR_STOP=1\" -q -U 'postgres' template1" 2>&1.
creating database icinga: su -s /bin/sh postgres -c "env
HOME='/tmp/dbconfig-common.psql_home.Ln487E'
PGPASSFILE='/tmp/dbconfig-common.psql_home.Ln487E/.pgpass' PGSSLMODE='prefer'
psql --set \"ON_ERROR_STOP=1\" -q -U 'postgres' -U 'postgres'" 2>&1.
success.
verifying database icinga exists: success.
populating database via sql... warning: ident method specified but local
account doesn't exist.
warning: ident method specified but local account doesn't exist.
su -s /bin/sh root -c "env HOME='/tmp/dbconfig-common.psql_home.RIlqrF'
PGPASSFILE='/tmp/dbconfig-common.psql_home.RIlqrF/.pgpass' PGSSLMODE='prefer'
psql --set \"ON_ERROR_STOP=1\" -q -h 'localhost' -U 'icinga' icinga" 2>&1.
error encountered populating database:
psql: could not connect to server: Connection refused Is the server running on
host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not
connect to server: Connection refused Is the server running on host "localhost"
(127.0.0.1) and accepting TCP/IP connections on port 5432?
dbconfig-common: icinga2-ido-pgsql configure: aborted.
dbc_postinst_cleanup() .
dbc_forget_dbadmin_password() .
dbconfig-common: flushing administrative password
dbc_forget_app_password() .
smime.p7s
Description: S/MIME cryptographic signature
