Hello, I used MySQL and sql statements to directly import users (originally from an access databases). The users are listed in phone view, but when I choose one of them I get the text "invalid" printed in red next to the textbox. I have to open the customer in admin view, click on change and save them so I don´t get the error. I also filled the table "customerpreferences" with data (password encrypted of course - copied from a testuser), but it still doesn´t work. What do I have to change so that otrs thinks the user has been created by otrs? btw: An automatic import from e.g. textfiles would be a nice feature. Lars
From /opt/otrs/scripts/database/initial_insert.sql:
INSERT INTO system_user
(first_name, last_name, login, pw, valid_id, create_by, create_time,
change_by, change_time)
VALUES
('Admin', 'OTRS', 'root@localhost', 'roK20XGbWEsSM', 1, 1,
current_timestamp, 1, current_timestamp);
-- group_user (add admin to groups)
INSERT INTO group_user
(user_id, permission_read, permission_write, group_id, create_by,
create_time, change_by, change_time)
VALUES
(1, 1, 1, 1, 1, current_timestamp, 1, current_timestamp);
INSERT INTO group_user
(user_id, permission_read, permission_write, group_id, create_by,
create_time, change_by, change_time)
VALUES
(1, 1, 1, 2, 1, current_timestamp, 1, current_timestamp);
INSERT INTO group_user
(user_id, permission_read, permission_write, group_id, create_by,
create_time, change_by, change_time)
VALUES
(1, 1, 1, 3, 1, current_timestamp, 1, current_timestamp);
You don't have to add new users to all groups, of course.
Regards,
Robert Kehl
----- Original Message -----
From: "Lars Monsees"
participants (2)
-
Lars Monsees -
Robert Kehl