Login not working

[der Jerg]

Hello Oliver, Hello Folks,
I have the problem, that I cannot log in to the backend of my customer anymore. It just sais "Fehler beim Anmelden!" / "Error trying to log in".
The curiosity of this is, that there is one computer which still does the login. The password is typed in manually so there is no chance it is misspelled or wrong. What could be happening here?
The userlog table only shows succeeded login-attempts, right?
I thought about creating a new user over the DB, but i don't know which hash-algorithm is used to hash the password, so i could enter it there.
Any ideas?

Have a good time a nice people around you

[Oliver Georgi]

Just use md5 when creating the password. Yeah, it is outdated but anyway.

It might help to delete all cookies of the domain where phpwcms is installed if the login might be rejected.

[der Jerg]

Unfortunately I still didn't manage to get inside.
Deleting the Browser cache won't work since I tried logging in on two "fresh" Systems.

I didn't manage to insert in new user in the db because I'm not allowed to insert an entry without providing a value for usr_var_structure but I'm pretty sure it won't help anyway.

Could it be a problem that SSL isn't enabled?

I'm totally lost, what can I do?

Jerg



P.S. What is the user account information in con.inc.php about?

[Oliver Georgi]

Sadly it can be anything and nothing. Sure it can be SSL if the system want to force this. Be sure the domain is what is configured and no redirect happens on login.

You can just duplicate an existing admin account, change the user name and set a new password. The usr_var_structure can be empty.

Here is an example INSERT:

Code: Select all

INSERT INTO `phpwcms_user` (`usr_login`, `usr_pass`, `usr_email`, `usr_tstamp`, `usr_rechte`, `usr_admin`, `usr_avatar`, `usr_aktiv`, `usr_name`, `usr_var_structure`, `usr_var_publicfile`, `usr_var_privatefile`, `usr_lang`, `usr_wysiwyg`, `usr_fe`)
VALUES
	('webmaster', MD5('mynewpassword'), 'test@example.com', '2025-10-21 00:00:00', '0', '1', '', '1', 'Webmaster', X'', X'', X'', 'en', '2', '2');