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

[Markus Frosch]

-----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.
> 

- -- 
markus at lazyfrosch.de / lazyfrosch at 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-----