Cannot login as root@localhost

Hi, I was a bit lazy when I set up a otrs for some colleages. Worked fine for a while but now I need some new user accounts. Unfortunally, I forgot the password of root@localhost.;-) What I did, is changing the password in the database: update system_user set pw=password('foobar') where id=1; The database has been flushed, reloaded, restarted several times since the change but I still can't login as root@localhost. I tried rcotrs restart-force as well. No effect. Any hint? Thanks! cu, Norbert

Hi Norbert, First of all I am not sure whether the way you are storing the password in the database is correct. You need to check the OTRS code (Kernel/System/User.pm) on how the system stores passwords (encrypted!) Secondly check whether the user is still valid (valid_id == 1 in table system_user). If this does not solve the problem you may need to assign an existing user to the a group that is allowed to add users (tables groups and group_user) Good luck, Tom -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]On Behalf Of norbert@munkel.net Sent: woensdag 7 januari 2004 14:47 To: otrs@otrs.org Subject: [otrs] Cannot login as root@localhost Hi, I was a bit lazy when I set up a otrs for some colleages. Worked fine for a while but now I need some new user accounts. Unfortunally, I forgot the password of root@localhost.;-) What I did, is changing the password in the database: update system_user set pw=password('foobar') where id=1; The database has been flushed, reloaded, restarted several times since the change but I still can't login as root@localhost. I tried rcotrs restart-force as well. No effect. Any hint? Thanks! cu, Norbert _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
participants (2)
-
norbert@munkel.net
-
Tom Hesp