Yes, you aren't getting authenticated. Same thing that happened to me. A quick
look at your sql brings up something odd. When I look at the md5 hash on mysql,
it is not what you are entering. Did you change the passwords? This is what I
have for my inserts for both default users:
| insert into jbp_users (jbp_uid, jbp_uname, jbp_password, jbp_realemail,
jbp_regdate, jbp_viewrealemail, jbp_enabled) values ('1', 'admin',
'21232f297a57a5a743894a0e4a801fc3', '[EMAIL PROTECTED]', NOW(), '1', TRUE);
| insert into jbp_users (jbp_uid, jbp_uname, jbp_password, jbp_realemail,
jbp_regdate, jbp_viewrealemail, jbp_enabled) values ('2', 'user',
'ee11cbb19052e40b07aac0ca060c23ee', '[EMAIL PROTECTED]', NOW(), '1', TRUE);
| insert into jbp_roles (jbp_rid, jbp_name, jbp_displayname) values ('1',
'Admins', 'Administrators');
| insert into jbp_roles (jbp_rid, jbp_name, jbp_displayname) values ('2',
'Users', 'Users');
| insert into jbp_role_membership (jbp_uid, jbp_rid) values ('1', '1');
| insert into jbp_role_membership (jbp_uid, jbp_rid) values ('2', '2');
|
Obviously, replace my NOW() with your sysdate function. Let me know if this
helps, I'd like to have your complete Oracle SQL, when you get it to work, so
we can share it. Hopefully, it doesn't become antiquated too fast.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3873851#3873851
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3873851
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
