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 -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
