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

[Arto Jantunen]

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:
Doctrine_Connection_Pgsql_Exception::$getMessage
(/usr/share/icinga-web/app/modules/AppKit/models/Auth/DispatchModel.class.php:363)

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