First time login trouble

RT Users
1

Hello all,

I’m having trouble logging in for the first time.

I have unfortunately modified the root user password in the DB, however, when I try to login using root and the password I defined, I am still getting incorrect user/password.

The standard logs (/var/log/httpd and /var/log/messages) only provide me with [503478] FAILED LOGIN for root from XXX.XXX.XXX.XXX

I have set #$WebSecureCookies to unsecure as I am logging through HTTP instead of HTTPS.

Can anyone help me with this?

2

You manually changed it in SQL? How did you do that?

3

UPDATE Users SET Password = ‘[YourNewPasswordHere]’ WHERE Name = ‘root’;

4

The password is hashed when its saved to the database, so “YourNewPasswordHere” should be the hashed value. You can use sbin/rt-passwd to set a users password

5

Do I just run it as a executable “./rt-passwd root” ?

6 
sbin/rt-passwd --help
        rt-passwd username
        rt-passwd user_id

    rt-passwd will set the password of an RT user to the value the user
    enters at the prompt.

  Options:
    --help
        Print this documentation and exit.