GateIn 備忘録 - tokobayashi’s blog

MOP import

curl -u root:gtn -X PUT -H 'Content-type: application/zip' --upload-file portal_classic_2013-06-10_15-16-53.zip http://localhost:8080/rest/private/managed-components/mop?importMode=overwrite

MOP export

wget http://localhost:8080/rest/private/managed-components/mop/usersites.zip --http-user=root --http-password=gtn
wget http://localhost:8080/rest/private/managed-components/mop/usersites/john/pages.xml --http-user=root --http-password=gtn

root のパスワード

configuration.properties に

gatein.portal.setup.enable=true
gatein.portal.setup.initialpassword.root=6MSyXIj3kkQ=

を書いておけば、パスワード gtn になる（DBクリーンアップすると次回アクセス時にパスワード設定するのが面倒なとき）

Oracle

drop user epp522jcr cascade;
create user epp522jcr identified by oracle default tablespace users;
grant dba to epp522jcr;

drop user epp522idm cascade;
create user epp522idm identified by oracle default tablespace users;
grant dba to epp522idm;

drop user epp522samplejcr cascade;
create user epp522samplejcr identified by oracle default tablespace users;
grant dba to epp522samplejcr;

drop user epp522sampleidm cascade;
create user epp522sampleidm identified by oracle default tablespace users;
grant dba to epp522sampleidm;

https://access.redhat.com/solutions/85813
(sample-portal では repository-configuration.xml の修正だけでうまくいく)

WSRP

Start JPP
cd jboss-portal-6.1.1-quickstarts/jboss-jpp-6.1.1-quickstarts/simplest-hello-world-portlet
Edit src/main/webapp/WEB-INF/portlet.xml

...
      <container-runtime-option>
         <name>org.gatein.pc.remotable</name>
         <value>true</value>
      </container-runtime-option>
    </portlet>

mvn clean install
cp target/simplest-hello-world-portlet.war ~/jboss/standalone/deployments/
Login as root
[Group]->[WSRP]
- activate selfv2
[Group]->[Administration]->[Application Registry]
- "Import Applications"
  - 'Simplest Hello World Portlet (remote)' shows up under "Remote" and "Selfv2 Producer"
[Site]->[Classic]->[Home]
- Create a page and drop 'Simplest Hello World Portlet (remote)'
  - Done!

Or...

/home/tkobayas/usr/local/JPP/611/jboss-portal-6.1.1-quickstarts/jboss-jpp-6.1.1-quickstarts/jsf2-hello-world-portlet is already remotable=true !

LoginModule

JCR

Look up Binary data.

select * from JCR_SITEM where P_TYPE = '2';
select * from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where P_TYPE = '2');
select * from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where P_TYPE = '2'));
select * from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where P_TYPE = '2')));
select * from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where P_TYPE = '2'))));
select * from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where P_TYPE = '2')))));
select * from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where P_TYPE = '2'))))));
select * from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where ID in (select PARENT_ID from JCR_SITEM where P_TYPE = '2')))))));

copy&paste

select * from JCR_SITEM where PARENT_ID = '

select * from JCR_SITEM where ID = '

select * from JCR_SVALUE where PROPERTY_ID = '

nodetypes

select v.DATA, i4.NAME, i3.NAME from JCR_SVALUE v, JCR_SITEM i1, JCR_SITEM i2, JCR_SITEM i3, JCR_SITEM i4 where v.PROPERTY_ID = i1.ID and i1.NAME like '%requiredType%' and i1.PARENT_ID = i2.ID and i2.PARENT_ID = i3.ID and i3.PARENT_ID = i4.ID;


select v.DATA, i4.NAME, i3.NAME, i4.ID, i3.ID from JCR_SVALUE v, JCR_SITEM i1, JCR_SITEM i2, JCR_SITEM i3, JCR_SITEM i4 where v.PROPERTY_ID = i1.ID and i1.NAME like '%requiredType%' and i1.PARENT_ID = i2.ID and i2.PARENT_ID = i3.ID and i3.PARENT_ID = i4.ID;


select v.DATA, i4.NAME, i3.NAME, i4.ID, i3.ID from JCR_SVALUE v, JCR_SITEM i1, JCR_SITEM i2, JCR_SITEM i3, JCR_SITEM i4 where v.PROPERTY_ID = i1.ID and i1.NAME like '%requiredType%' and i1.PARENT_ID = i2.ID and i2.PARENT_ID = i3.ID and i3.PARENT_ID = i4.ID and v.DATA = 'Binary';

select i1.NAME, i2.NAME, i2.ID, v.DATA from JCR_SITEM i1, JCR_SITEM i2, JCR_SVALUE v where i1.PARENT_ID = 'system00exo0jcr0node0types0root0uuid00' and i2.PARENT_ID = i1.ID and v.PROPERTY_ID = i2.ID;

その他

-Dexo.product.developing=true