Sorry I didn't have time to follow up on this yesterday, but here is a little
background and what is happening:
I am using a non default configuration 'je-default' in a shared installation of
JBoss.
I am installing from jboss-portal-2.0-beta1-src.
I have unzipped cms-content.zip to the data directory in my configuration.
I have copied jboss-cache.jar, jgroups-all.jar, and jboss-remoting.jar to the
lib directory of my configuration.
I am using Oracle as the database. I changed the NOW() function to sysdate and
the MD5() functions to hardcoded strings representing the output of md5sum.
Here is the SQL script I ran:
insert into jbp_user_pref_set (jbp_id, jbp_parent_id, name) values
(1,null,'AdminPrefs');
insert into jbp_user_pref_set (jbp_id, jbp_parent_id, name) values
(2,null,'UserPrefs');
insert into jbp_users (jbp_uid, jbp_root_pref_set_id, jbp_uname, jbp_password,
jbp_realemail, jbp_regdate, jbp_viewrealemail, jbp_enabled) values ('1', 1,
'admin', '456b7016a916a4b178dd72b947c152b7', '[EMAIL PROTECTED]', sysdate, '1',
'1');
insert into jbp_users (jbp_uid, jbp_root_pref_set_id, jbp_uname, jbp_password,
jbp_realemail, jbp_regdate, jbp_viewrealemail, jbp_enabled) values ('2', 2,
'user', 'a81be4e9b20632860d20a64c054c4150', '[EMAIL PROTECTED]', sysdate, '1',
'1');
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');
Note that the first two lines are completely new, but were necessary to avoid
foreign key constraint violations.
Now, when I attempt to login with admin/admin, the CMS Portlet displays:
404 - Page Not Found
Oops! We can't find the resource you're looking for.
There are no stacktraces in the log. Here is the section of the log dealing
with the password lookup:
2005-04-13 10:41:41,399 DEBUG [net.sf.hibernate.impl.SessionImpl] find: SELECT
u.password FROM UserImpl AS u WHERE u.userName=:username
2005-04-13 10:41:41,399 DEBUG [net.sf.hibernate.engine.QueryParameters] named
parameters: {username=admin}
2005-04-13 10:41:41,399 DEBUG [net.sf.hibernate.hql.QueryTranslator] compiling
query
2005-04-13 10:41:41,401 DEBUG [net.sf.hibernate.impl.SessionImpl] flushing
session
2005-04-13 10:41:41,401 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushing
entities and processing referenced collections
2005-04-13 10:41:41,401 DEBUG [net.sf.hibernate.impl.SessionImpl] Processing
unreferenced collections
2005-04-13 10:41:41,401 DEBUG [net.sf.hibernate.impl.SessionImpl] Scheduling
collection removes/(re)creates/updates
2005-04-13 10:41:41,401 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushed: 0
insertions, 0 updates, 0 deletions to 0 objects
2005-04-13 10:41:41,401 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushed: 0
(re)creations, 0 updates, 0 removals to 0 collections
2005-04-13 10:41:41,401 DEBUG [net.sf.hibernate.impl.SessionImpl] Dont need to
execute flush
2005-04-13 10:41:41,401 DEBUG [net.sf.hibernate.hql.QueryTranslator] HQL:
SELECT u.password FROM org.jboss.portal.core.impl.user.UserImpl AS u WHERE
u.userName=:username
2005-04-13 10:41:41,401 DEBUG [net.sf.hibernate.hql.QueryTranslator] SQL:
select userimpl0_.jbp_password as x0_0_ from jbp_users userimpl0_ where
(userimpl0_.jbp_uname=? )
2005-04-13 10:41:41,401 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to
open: 0 open PreparedStatements, 0 open ResultSets
2005-04-13 10:41:41,402 DEBUG [net.sf.hibernate.SQL] select
userimpl0_.jbp_password as x0_0_ from jbp_users userimpl0_ where
(userimpl0_.jbp_uname=? )
2005-04-13 10:41:41,402 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing
statement
2005-04-13 10:41:41,403 DEBUG [net.sf.hibernate.type.StringType] binding
'admin' to parameter: 1
2005-04-13 10:41:41,407 DEBUG [net.sf.hibernate.loader.Loader] processing
result set
2005-04-13 10:41:41,407 DEBUG [net.sf.hibernate.loader.Loader] result row:
2005-04-13 10:41:41,407 DEBUG [net.sf.hibernate.type.StringType] returning
'456b7016a916a4b178dd72b947c152b7' as column: x0_0_
2005-04-13 10:41:41,408 DEBUG [net.sf.hibernate.loader.Loader] done processing
result set (1 rows)
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3873808#3873808
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3873808
-------------------------------------------------------
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
