"Role required to enter this resource"

8 views
Skip to first unread message

George

unread,
Jul 6, 2007, 1:53:14 PM7/6/07
to duroty
Hi everyone,

I'm having problems with initially logging in to my duroty install. I
don't understand how duroty/duroty was supposed to initially work,
because DUROTY.sql has NO insert clauses for postgresql - so there's
no data to start with.
Luckily, I found this thread: http://groups.google.com/group/duroty/msg/9a5e9642defe766d?
where you said to insert the lines into the sql database manually.
I did the following:

insert into users values (7, 'duroty', 'duroty', 'Duroty System',
'duroty@localhost', 'en', true, '2006-12-30 21:00:00', 0, null, 0,
null);
insert into users values (10, 'guest', 'guest', 'Guest System',
'guest@localhost', 'en', true, '2006-12-30 21:00:00', 0, null, 0,
null);
insert into roles values('1','Guest');
insert into roles values('2','Member');
insert into roles values('3','Mail');
insert into roles values('4','Bookmark');
insert into roles values('5','Chat');
insert into roles values('6','Admin');
insert into user_role values('7','2');
insert into user_role values('7','4');
insert into user_role values('7','5');
insert into user_role values('7','6');
insert into user_role values('10','1');
insert into mail_preferences values (9, 7, 20, null, true, false,
null, null, 1048576, 0);
insert into mail_preferences values (11, 10, 20, null, true, false,
null, null, 1048576, 0);
insert into identity values (8, 7, 'Duroty System',
'duroty@localhost', 'duroty@localhost', 'AAAA', true, true);

It all went smoothly - but mind you, this is THE ONLY DATA in the
entire database. How was the data supposed to initially get there?
Anyhow, now when I log in with duroty/duroty, it comes to the next
screen and says:
"Role required to enter this resource"
And the only option is to go back to the login screen.
Any help?
Thanks

George

unread,
Jul 11, 2007, 12:26:22 PM7/11/07
to duroty
I'd also like to add, when I try to register, it says:

???SecurityException; nested exception is: n
java.lang.SecurityException: Insufficient method permissions,
principal=null, ejbName=Open, method=create, interface=HOME,
requiredRoles=[guest], principalRoles=[Guest]???

Anybody got any ideas? I don't even know where to begin. I'm
thinking I've got to be missing stuff in the database.

Reply all
Reply to author
Forward
0 new messages