User root@localhost

[fornazieri]

Hello, I installed version 3.0 with MSSQL, all procresso finalizdo was successful, but the user "root @ localhost" with the initial password does not work.

Is there any way to change this password?

Best regards

Fernando Fornazieri

[crythias]

This is the initial database insert command:

Code: Select all

INSERT INTO users (id, first_name, last_name, login, pw, valid_id, create_by, create_time, change_by, change_time)
    VALUES
    (1, 'Admin', 'OTRS', 'root@localhost', 'roK20XGbWEsSM', 1, 1, current_timestamp, 1, current_timestamp);

so if you figure out:

Code: Select all

UPDATE users set pw='roK20XGbWEsSM' where id='1' LIMIT 1;

It should probably work. YMMV. Don't mess with database directly unless you know what you're doing, backup first, etc. Check capslock, numlock, keyboard mapping and other usual suspects if this doesn't work for you.

[jojo]

bin/Otrs.SetPassword.pl will help

[fornazieri]

Hi crythias.

I solved the problem by commenting out the last line of the connection string file config.pm - # $ self-> {} DatabaseUserTable = 'system_user2';.

Now working properly

Thank you for your support.