[Pkg-nagios-devel] Bug#758180: icinga-web: basic auth + auth_create does not work with Postgresql

Arto Jantunen viiru at debian.org
Fri Aug 15 07:16:29 UTC 2014

Package: icinga-web
Severity: important
Version: 1.7.1+dfsg2-6
Tags: wheezy, upstream

Using basic auth with auth_create on a Postgresql database does not
work. Icinga generates a db insert statement that doesn't include
user_email, which is defined as not null. The insert fails, causing
login fail with a message like this:

Uncaught AppKitPHPError thrown: PHP Error Undefined property:

The Postgresql log has the smoking gun:

EEST ERROR:  null value in column "user_email" violates not-null constraint
EEST STATEMENT:  INSERT INTO nsm_user (user_account, user_authsrc, user_disabled, user_firstname, user_lastname, user_name, user_salt, user_password, user_created, user_modified) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)

This has been reported upstream as ticket 6582 ( 
https://dev.icinga.org/issues/6582 ) but has not been fixed.

As a workaround the db schema can be modified to have a default value
for user_email.

Arto Jantunen

More information about the Pkg-nagios-devel mailing list