Hi,
Thanks for the suggestion, but my solution was slightly different. I was able to find, that I need to create additional table icingaweb_remember me. Found this here:
So I did it. I granted not full privileges, but only select insert update delete on this new table. And seems that problem was gone after that.
Tried to login with remember me option and got another error:
Failed to let user “admin” stay logged in: PDOException in /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php:402 with message: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘random_iv’ at row 1
Looked at column’s type and saw it set to varchar(24). Set it to varchar(256) and the new error was also gone.
I only did not understand, why did I need to create this new table. Why was it not in my DB already?
And also I see some grants created:
GRANT CREATE TEMPORARY TABLES, EXECUTE ON icinga\_users.* TO ‘icinga_username’@‘localhost’
But I can’t see no such db on my server. Can you look at your side? Do you have the same grant for such DB? Or is this some kind of install error?