taylor      2004/10/08 22:20:56

  Modified:    src/sql/mysql populate-userinfo-for-default-psml.sql
               src/sql/oracle populate-userinfo-for-default-psml.sql
  Log:
  fix login portlet for MySQL and Oracle
  
  Revision  Changes    Path
  1.4       +6 -6      
jakarta-jetspeed-2/src/sql/mysql/populate-userinfo-for-default-psml.sql
  
  Index: populate-userinfo-for-default-psml.sql
  ===================================================================
  RCS file: 
/home/cvs/jakarta-jetspeed-2/src/sql/mysql/populate-userinfo-for-default-psml.sql,v
  retrieving revision 1.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- populate-userinfo-for-default-psml.sql    23 Sep 2004 19:53:50 -0000      1.3
  +++ populate-userinfo-for-default-psml.sql    9 Oct 2004 05:20:56 -0000       1.4
  @@ -19,12 +19,12 @@
   INSERT INTO SECURITY_PRINCIPAL 
VALUES(11,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/accounting','2004-05-22
 16:27:12.572','2004-05-22 16:27:12.572');
   INSERT INTO SECURITY_PRINCIPAL 
VALUES(12,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/marketing','2004-05-22
 16:27:12.572','2004-05-22 16:27:12.572');
   INSERT INTO SECURITY_PRINCIPAL 
VALUES(13,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/engineering','2004-05-22
 16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_CREDENTIAL VALUES(1,1,'admin',0,null,'2004-05-22 
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_CREDENTIAL VALUES(2,2,'manager',0,null,'2004-05-22 
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_CREDENTIAL VALUES(3,3,'user',0,null,'2004-05-22 
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_CREDENTIAL VALUES(4,4,'tomcat',0,null,'2004-05-22 
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_CREDENTIAL VALUES(5,5,'jetspeed',0,null,'2004-05-22 
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_CREDENTIAL VALUES(9,9,'guest',0,null,'2004-05-22 
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_CREDENTIAL 
VALUES(1,1,'admin',0,'org.apache.jetspeed.security.PasswordCredential','2004-05-22 
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_CREDENTIAL 
VALUES(2,2,'manager',0,'org.apache.jetspeed.security.PasswordCredential','2004-05-22 
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_CREDENTIAL 
VALUES(3,3,'user',0,'org.apache.jetspeed.security.PasswordCredential','2004-05-22 
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_CREDENTIAL 
VALUES(4,4,'tomcat',0,'org.apache.jetspeed.security.PasswordCredential','2004-05-22 
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_CREDENTIAL 
VALUES(5,5,'jetspeed',0,'org.apache.jetspeed.security.PasswordCredential','2004-05-22 
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_CREDENTIAL 
VALUES(9,9,'guest',0,'org.apache.jetspeed.security.PasswordCredential','2004-05-22 
16:27:12.572','2004-05-22 16:27:12.572');
   INSERT INTO SECURITY_USER_ROLE VALUES(1,6);
   INSERT INTO SECURITY_USER_ROLE VALUES(1,7);
   INSERT INTO SECURITY_USER_ROLE VALUES(1,8);
  
  
  
  1.5       +6 -6      
jakarta-jetspeed-2/src/sql/oracle/populate-userinfo-for-default-psml.sql
  
  Index: populate-userinfo-for-default-psml.sql
  ===================================================================
  RCS file: 
/home/cvs/jakarta-jetspeed-2/src/sql/oracle/populate-userinfo-for-default-psml.sql,v
  retrieving revision 1.4
  retrieving revision 1.5
  diff -u -r1.4 -r1.5
  --- populate-userinfo-for-default-psml.sql    23 Sep 2004 19:52:05 -0000      1.4
  +++ populate-userinfo-for-default-psml.sql    9 Oct 2004 05:20:56 -0000       1.5
  @@ -19,12 +19,12 @@
   INSERT INTO SECURITY_PRINCIPAL 
VALUES(11,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/accounting',to_date('2004-05-22
 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
   INSERT INTO SECURITY_PRINCIPAL 
VALUES(12,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/marketing',to_date('2004-05-22
 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
   INSERT INTO SECURITY_PRINCIPAL 
VALUES(13,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/engineering',to_date('2004-05-22
 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
  -INSERT INTO SECURITY_CREDENTIAL VALUES(1,1,'admin',0,null,to_date('2004-05-22 
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
  -INSERT INTO SECURITY_CREDENTIAL VALUES(2,2,'manager',0,null,to_date('2004-05-22 
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
  -INSERT INTO SECURITY_CREDENTIAL VALUES(3,3,'user',0,null,to_date('2004-05-22 
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
  -INSERT INTO SECURITY_CREDENTIAL VALUES(4,4,'tomcat',0,null,to_date('2004-05-22 
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
  -INSERT INTO SECURITY_CREDENTIAL VALUES(5,5,'jetspeed',0,null,to_date('2004-05-22 
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
  -INSERT INTO SECURITY_CREDENTIAL VALUES(9,9,'guest',0,null,to_date('2004-05-22 
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
  +INSERT INTO SECURITY_CREDENTIAL 
VALUES(1,1,'admin',0,'org.apache.jetspeed.security.PasswordCredential',to_date('2004-05-22
 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
  +INSERT INTO SECURITY_CREDENTIAL 
VALUES(2,2,'manager',0,'org.apache.jetspeed.security.PasswordCredential',to_date('2004-05-22
 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
  +INSERT INTO SECURITY_CREDENTIAL 
VALUES(3,3,'user',0,'org.apache.jetspeed.security.PasswordCredential',to_date('2004-05-22
 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
  +INSERT INTO SECURITY_CREDENTIAL 
VALUES(4,4,'tomcat',0,'org.apache.jetspeed.security.PasswordCredential',to_date('2004-05-22
 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
  +INSERT INTO SECURITY_CREDENTIAL 
VALUES(5,5,'jetspeed',0,'org.apache.jetspeed.security.PasswordCredential',to_date('2004-05-22
 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
  +INSERT INTO SECURITY_CREDENTIAL 
VALUES(9,9,'guest',0,'org.apache.jetspeed.security.PasswordCredential',to_date('2004-05-22
 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD 
HH24:MI:SS'));
   INSERT INTO SECURITY_USER_ROLE VALUES(1,6);
   INSERT INTO SECURITY_USER_ROLE VALUES(1,7);
   INSERT INTO SECURITY_USER_ROLE VALUES(1,8);
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to