Aha! Thank you -- now we are making progress. I wondered whether I had used md5sum correctly. Obviously, I didn't. Now I can login, but the CMS Admin Portlet is still empty, and I see the following in the log:
2005-04-13 19:05:26,852 DEBUG [org.jboss.portal.core.impl.preferences.MappedPreferenceStore] Preference set not found for instance.portal.CMSPortlet.CMSPortletInstance 2005-04-13 19:05:26,852 DEBUG [org.jboss.portal.core.impl.preferences.MappedPreferenceSet] Using for 1/AdminPrefs name (0,instance) 2005-04-13 19:05:26,853 DEBUG [org.jboss.portal.core.impl.preferences.MappedPreferenceSet] Found for 1/AdminPrefs child instance 2005-04-13 19:05:26,853 DEBUG [org.jboss.portal.core.impl.preferences.MappedPreferenceSet] Using for 1/AdminPrefs name (1,portal) 2005-04-13 19:05:26,853 DEBUG [org.jboss.portal.core.impl.preferences.MappedPreferenceSet] Found for 1/AdminPrefs child portal 2005-04-13 19:05:26,853 DEBUG [org.jboss.portal.core.impl.preferences.MappedPreferenceSet] Using for 1/AdminPrefs name (2,CMSPortlet) 2005-04-13 19:05:26,853 DEBUG [org.jboss.portal.core.impl.preferences.MappedPreferenceSet] Found for 1/AdminPrefs child CMSPortlet 2005-04-13 19:05:26,853 DEBUG [org.jboss.portal.core.impl.preferences.MappedPreferenceSet] Using for 1/AdminPrefs name (3,CMSPortletInstance) 2005-04-13 19:05:26,853 DEBUG [org.jboss.portal.core.impl.preferences.MappedPreferenceSet] Found for 1/AdminPrefs child CMSPortletInstance 2005-04-13 19:05:26,894 DEBUG [net.sf.hibernate.impl.SessionImpl] flushing session 2005-04-13 19:05:26,898 DEBUG [net.sf.hibernate.engine.Cascades] processing cascades for: org.jboss.portal.core.impl.user.UserImpl 2005-04-13 19:05:26,909 DEBUG [net.sf.hibernate.engine.Cascades] cascading to saveOrUpdate() 2005-04-13 19:05:26,909 DEBUG [net.sf.hibernate.impl.SessionImpl] saveOrUpdate() persistent instance 2005-04-13 19:05:26,910 DEBUG [net.sf.hibernate.engine.Cascades] done processing cascades for: org.jboss.portal.core.impl.user.UserImpl 2005-04-13 19:05:26,910 DEBUG [net.sf.hibernate.engine.Cascades] processing cascades for: org.jboss.portal.core.impl.user.UserPrefSet 2005-04-13 19:05:26,910 DEBUG [net.sf.hibernate.engine.Cascades] cascading to collection: org.jboss.portal.core.impl.user.UserPrefSet.children 2005-04-13 19:05:26,910 DEBUG [net.sf.hibernate.engine.Cascades] cascading to saveOrUpdate() 2005-04-13 19:05:26,910 DEBUG [net.sf.hibernate.impl.SessionImpl] saveOrUpdate() unsaved instance 2005-04-13 19:05:26,951 ERROR [net.sf.hibernate.id.TableGenerator] could not read a hi value java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) .... Here are the ddl and sql scripts as generated by the build: alter table jbp_users drop constraint FKF606014114931AFE; alter table jbp_role_membership drop constraint FKF410173894E6A686; alter table jbp_role_membership drop constraint FKF410173894E6B1C9; alter table jbp_user_pref drop constraint FK93CC44D0C691B5FF; alter table jbp_user_pref_set drop constraint FK97AA4873FAF7DF89; alter table jbp_user_pref_prop_value drop constraint FKC496306482E27870; alter table jbp_user_prop drop constraint FK93CC461094E6B1C9; drop table jbp_users cascade constraints; drop table jbp_role_membership cascade constraints; drop table jbp_user_pref cascade constraints; drop table jbp_user_pref_set cascade constraints; drop table jbp_user_pref_prop_value cascade constraints; drop table jbp_roles cascade constraints; drop table jbp_user_prop cascade constraints; drop sequence hibernate_sequence; create table jbp_users ( jbp_uid NUMBER(10,0) not null, jbp_root_pref_set_id NUMBER(10,0) unique, jbp_uname VARCHAR2(255) unique, jbp_givenname VARCHAR2(255), jbp_familyname VARCHAR2(255), jbp_password VARCHAR2(255), jbp_realemail VARCHAR2(255), jbp_fakeemail VARCHAR2(255), jbp_regdate DATE, jbp_viewrealemail NUMBER(1,0), jbp_enabled NUMBER(1,0), primary key (jbp_uid) ); create table jbp_role_membership ( jbp_rid NUMBER(10,0) not null, jbp_uid NUMBER(10,0) not null, primary key (jbp_uid, jbp_rid) ); create table jbp_user_pref ( jbp_id NUMBER(10,0) not null, jbp_name VARCHAR2(255) not null, jbp_type NUMBER(10,0), jbp_set_id NUMBER(10,0), primary key (jbp_id) ); create table jbp_user_pref_set ( jbp_id NUMBER(10,0) not null, jbp_parent_id NUMBER(10,0), name VARCHAR2(255) not null, primary key (jbp_id) ); create table jbp_user_pref_prop_value ( jbp_prop_id NUMBER(10,0) not null, jbp_value VARCHAR2(255), jbp_idx NUMBER(10,0) not null, primary key (jbp_prop_id, jbp_idx) ); create table jbp_roles ( jbp_rid NUMBER(10,0) not null, jbp_name VARCHAR2(255) unique, jbp_displayname VARCHAR2(255) unique, primary key (jbp_rid) ); create table jbp_user_prop ( jbp_uid NUMBER(10,0) not null, jbp_value VARCHAR2(255), jbp_name VARCHAR2(255) not null, primary key (jbp_uid, jbp_name) ); alter table jbp_users add constraint FKF606014114931AFE foreign key (jbp_root_pref_set_id) references jbp_user_pref_set; alter table jbp_role_membership add constraint FKF410173894E6A686 foreign key (jbp_rid) references jbp_roles; alter table jbp_role_membership add constraint FKF410173894E6B1C9 foreign key (jbp_uid) references jbp_users; alter table jbp_user_pref add constraint FK93CC44D0C691B5FF foreign key (jbp_set_id) references jbp_user_pref_set; alter table jbp_user_pref_set add constraint FK97AA4873FAF7DF89 foreign key (jbp_parent_id) references jbp_user_pref_set; alter table jbp_user_pref_prop_value add constraint FKC496306482E27870 foreign key (jbp_prop_id) references jbp_user_pref; alter table jbp_user_prop add constraint FK93CC461094E6B1C9 foreign key (jbp_uid) references jbp_users; create sequence hibernate_sequence; insert into jbp_users (jbp_uid, jbp_uname, jbp_password, jbp_realemail, jbp_regdate, jbp_viewrealemail, jbp_enabled) values ('1', 'admin', MD5('admin'), '[EMAIL PROTECTED]', NOW(), '1', '1'); insert into jbp_users (jbp_uid, jbp_uname, jbp_password, jbp_realemail, jbp_regdate, jbp_viewrealemail, jbp_enabled) values ('2', 'user', MD5('user'), '[EMAIL PROTECTED]', NOW(), '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'); View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3873853#3873853 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3873853 ------------------------------------------------------- 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