Did you use any unquoted special characters on the CLI when creating the user? This would cause the CLI to pass a mangled password to the user creation script.
There’s not going to be anything wrong with the login system, logically, since it’s used by thousands of people without issues. Thanks, Adam. > On 4 Aug 2025, at 03:57, zack--- via observium > <[email protected]> wrote: > > 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] _______________________________________________ observium mailing list -- [email protected] To unsubscribe send an email to [email protected]
