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
