After a basic install of the CE edition, I am unable to log into the system. I
added a user via CLI and can see that user as valid within the database. When I
enable debug, I can see that the system is attempting the login but when it
tries to pull the userlevel from the database, it does not appear to be passing
the username into the query, so it is attempting to get the userlevel of
username = '' and failing. The authentication failure is correctly populating
into the auth_log insertion query. See below for the output of the debug info
on the login page. Is this a bug in the system or is something configured
incorrectly? I can see the user with level 10 in the database.
SELECT * FROM `observium_attribs`
SELECT @@SESSION.sql_mode;
SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
SELECT * FROM `config`
SELECT `username`, `password` FROM `users` WHERE `username` = 'lima3' AND
`type` = 'mysql'
SELECT `level` FROM `users` WHERE `username` = '' AND `type` = 'mysql'
INSERT INTO `authlog` (`user`,`address`,`user_agent`,`result`) VALUES
('lima3','10.0.0.190','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0)
Gecko/20100101 Firefox/141.0','Authentication Failure')
_______________________________________________
observium mailing list -- [email protected]
To unsubscribe send an email to [email protected]
