mysql -u <username> -p
use otrs
select * from
group_user where user_id = 1 and group_id = 1;
Returns the
following:
Empty set (0.00
sec)
This happened after I renamed
the user groups in OTRS's admin interface...
Looking at the MySQL databases
shows the Admin group as ID 2... dh@syrex.cc is
however a member of this group (admin@syrex.cc seems to have been
removed)...
How do I manually change the
'Admin' group back to '1' and how do I add a user to a
group?
Running MySQL reports on the
tables however reports the following:
group_user:
| user_id |
group_id |
permission_read |
permission_write |
create_time |
create_by |
change_time |
change_by |
| 1 |
2 |
1 |
1 |
2003-10-22 18:48:21 |
1 |
2003-10-22 18:48:21 |
1 |
| 1 |
3 |
1 |
1 |
2003-10-22 18:48:21 |
1 |
2003-10-22 18:48:21 |
1 |
| 2 |
1 |
1 |
1 |
2003-10-22 22:50:54 |
2 |
2003-10-22 22:50:54 |
2 |
| 2 |
2 |
1 |
1 |
2003-10-22 18:48:10 |
1 |
2003-10-22 18:48:10 |
1 |
| 2 |
3 |
1 |
1 |
2003-10-22 18:48:10 |
1 |
2003-10-22 18:48:10 |
1 |
| 3 |
1 |
1 |
1 |
2003-10-22 22:50:54 |
2 |
2003-10-22 22:50:54 |
2 |
| 3 |
3 |
1 |
1 |
2003-10-22 22:33:25 |
2 |
2003-10-22 22:33:25 |
2 |
| 4 |
1 |
1 |
1 |
2003-10-22 22:50:54 |
2 |
2003-10-22 22:50:54 |
2 |
| 4 |
3 |
1 |
1 |
2003-10-22 22:33:55 |
2 |
2003-10-22 22:33:55 |
2 |
| 5 |
1 |
1 |
1 |
2003-10-22 22:50:54 |
2 |
2003-10-22 22:50:54 |
2 |
| 5 |
3 |
1 |
1 |
2003-10-22 22:34:59 |
2 |
2003-10-22 22:34:59 |
2 |
| 6 |
1 |
1 |
1 |
2003-10-22 22:50:54 |
2 |
2003-10-22 22:50:54 |
2 |
| 6 |
3 |
1 |
1 |
2003-10-22 22:35:30 |
2 |
2003-10-22 22:35:30 |
2 |
| 7 |
1 |
1 |
1 |
2003-10-22 22:50:54 |
2 |
2003-10-22 22:50:54 |
2 |
| 7 |
3 |
1 |
1 |
2003-10-22 22:35:59 |
2 |
2003-10-22 22:35:59 |
2 |
groups:
system_user:
Regards
David Herselman (Executive
Proprietor) -=*> Syrex Intranets <*=-