-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Control: tags -1 + wontfix
Hi Arto, this can be fixed by using a combination of auth providers. See here: https://dev.icinga.org/issues/6582#note-5 I can't fix this any other way. Cheers Markus Frosch On 15.08.2014 09:16, Arto Jantunen wrote: > 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. > - -- mar...@lazyfrosch.de / lazyfro...@debian.org http://www.lazyfrosch.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJVAE2vAAoJEJo1i6sEpO0nBXwP/2PfU/64P/PIEfdfW0xvgax/ uG8cbauVOoFipuwaRIwINJYrupKYMOnKms2zacSJKrvPNeUWYKf5G2fQ+qZ8WvQA CYCDh766JSV9etWSpLhuvvP8pwsVcGLSGetpO11IvbOocU/v7mEnvYHuxukWUU8x 1QKjtCh17I/3s21MGi8tMJka7TfQm2C+mZlNZwyCFiO5dING6VO2khC09go0EcG6 +MKrC63le0Ye/uaNkfToh7Y9v4hSA6+n4YjiGyvy3FZtvgyyWIBNYEg/9Zjae26l mHcD/a3qGobPHM0zn7F1haUz5zQ2F5g/WPBTKv9G9RznQ+peyoGz0f4kDoNCyYU+ cstyiIjsQTW5RwJlfIVUGUAscc0QJUiaX0lxXrWny8RvJOuIi+1XpJRuBWdwwVQY NPvPhFsC7vsVRBBOGmRF2tHrSC7O1NcI3FZ4Sri98/GT5hvD4hLgCGuiyGSOc8PU BRl1rAI++Sa+qXq4IUglKQaOzx/pVtGrXqfI/YabsKb1PQ2he+yOzjGMKn/14JpO K5VEEdOcXJMkz4j6GqcENDrsA6CdkgO6cXYqQWDWxlWt6TbDZH85rIvMwpgY6Fq9 enoAvyPP1+o+fFVZHWU9wKi11K0RPM9slWa++Tw9HtqXtsHGHL8r0O9yEgj+exIY uXYUI8m6gq3ORXLKLeUJ =ebJ7 -----END PGP SIGNATURE----- -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org