GateIn on Oracle DataBase 10 g xe : page managment down

[pascal_dev]

Hello,

i am working on GateIn 3.0 final,

                        JBoss 5.1.0 (jdk 6),

                        Oracle Database 10 g Express Edition.

i can launch the portal gatein with the classic site. We can create a new site, user, group, role. We can import portlet.

But the page management is empty and we can not add a new page.

this is the server/default/con/gatein/ configuration.properties file :

gatein.data.dir=${jboss.server.data.dir}/gatein

# DB
gatein.db.data.dir=${gatein.data.dir}/db

# JCR
gatein.jcr.config.type=local
gatein.jcr.datasource.name=java:jdbcjcr
gatein.jcr.datasource.dialect=auto
gatein.jcr.datasource.driver=oracle.jdbc.OracleDriver
gatein.jcr.datasource.url=jdbc:oracle:thin:@localhost:1521:xe
gatein.jcr.datasource.username=jdbcjcr_portal
gatein.jcr.datasource.password=jdbcjcr_portal

gatein.jcr.data.dir=${gatein.data.dir}/jcr
gatein.jcr.storage.data.dir=${gatein.jcr.data.dir}/values
gatein.jcr.index.data.dir=${gatein.jcr.data.dir}/lucene
gatein.jcr.index.changefilterclass=org.exoplatform.services.jcr.impl.core.query.DefaultChangesFilter

# IDM
gatein.idm.datasource.name=java:jdbcidm
gatein.idm.datasource.driver=oracle.jdbc.OracleDriver
gatein.idm.datasource.url=jdbc:oracle:thin:@localhost:1521:xe
gatein.idm.datasource.username=jdbcidm_portal
gatein.idm.datasource.password=jdbcidm_portal

# EMail
gatein.email.smtp.username=
gatein.email.smtp.password=
gatein.email.smtp.host=smtp.gmail.com
gatein.email.smtp.port=465
gatein.email.smtp.starttls.enable=true
gatein.email.smtp.auth=true
gatein.email.smtp.socketFactory.port=465
gatein.email.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory

thank for your help.

[theute]

Any stacktrace ?

I know we test against Oracle 10 and 11 (full versions though)

[pascal_dev]

Hello Thomas,

there are no exception in the trace.

I can not use the page management to create a page. The page managment is still empty after the creation process of page. The search of page does not working. But if i try to create an other page with the same id, a message say a page with the same id already exist.

To create a page i use the button on the node edition. After, i use the page editor, and we can view this page. But the page managment is again empty.

I give you the server log.

[pascal_dev]

Hello,

I have installed a Oracle 9i database full version. I can do a connection to gateIn. The portal is working, but hte page managment is still empty. Where are the page data in tables of the database, in the jcr or idm database ?

In the gateIn reference Guide, it is said we have to modify the $JBOSS_HOME/server/default/conf/gatein/configuration.properties file. But with the MySQL example, we modify directly gatein.ear/02portal.war/WEB-INF/conf/jcr/jcr-configuration file, why ?

Thank for your help.

[antoine_h]

Hello,

Where are the page data in tables of the database, in the jcr or idm database ?

In the gateIn reference Guide, it is said we have to modify the $JBOSS_HOME/server/default/conf/gatein/configuration.properties file.

But with the MySQL example, we modify directly gatein.ear/02portal.war/WEB-INF/conf/jcr/jcr-configuration file, why ?

I am also intersted in the anwers of these two question...

anyone has an explaination ?

thanks,

Antoine

[ajsushil]

HI,

Even I am facing same issue with mysql. If you resolve the issue. Please let me know the solution.

[antoine_h]

globally : the problem usually comes from some trouble when trying to connect to the database and run with it.

the reading of data, and the storage of new data does not work, so the page management cannot run properly.

for this, some few tracks :

- look in the logs, if the DataSources are properly set. (search for ""ds", you should find the lines where they is some info about them).

- check in the logs that there was no problem, when connecting to the data source, and using it. no exception "cannot connect to..." or "cannot ... datasource... etc..." ?

- if none of this kind of datasource problems, then look at the logs to see what exception are thrown.

hope it helps,

Antoine

JBoss Portal and GateIn (JSR-286), JSF, Richfaces, J2EE, Drools, BRMS.

http://www.sysemo.com/Sysemo-expertise-portails-jboss-portal.php

[antoine_h]

Where are the page data in tables of the database, in the jcr or idm database ?

In the gateIn reference Guide, it is said we have to modify the $JBOSS_HOME/server/default/conf/gatein/configuration.properties file.

But with the MySQL example, we modify directly gatein.ear      file, why ?

along with miscellaneous installations in various environments, these questions have found answers :

****************

the page data are in the jcr... no doubt about that...

the idm database is only for the identity management (users, organisations, groups, etc...).

****************

the .../02portal.war/WEB-INF/conf/jcr/jcr-configuration file is where the configuration is done, for the jcr and datasource access to store the data.

this place is where to make the most flexible configuration.

the $JBOSS_HOME/server/default/conf/gatein/configuration.properties is an upper layer, simplified, configuration.

it allows to defines some simple configuration of the datasources.

** flexible config

if you need some flexible configuration, to make a special customized setup of the datasources, then use the first one.

with this, you can also make some usual datasources files (xxxx-ds.xml file, in the deploy folder), to define the datasources, then set the configuration so the jcr uses these DS.

to do so, you only need to keep a few properties in the configuration.properties file :

gatein.jcr.config.type=local

gatein.jcr.datasource.name=java:jdbcjcr

gatein.jcr.datasource.dialect=auto

the other properties, that defines the datasource, are no longer needed.

you need also to remove the BindReferencePlugin in the configuration :

- in the file "...l/02portal.war/WEB-INF/conf/jcr/jcr-configuration.xml"

- remove the component plugin with name "bind.datasource"

you can comment the definition that starts with :

<external-component-plugins>
    <target-component>org.exoplatform.services.naming.InitialContextInitializer</target-component>
          <component-plugin>
                <name>bind.datasource</name>
                <set-method>addPlugin</set-method>
                <type>org.exoplatform.services.naming.BindReferencePlugin</type>
...

as you can see in the definition of that component, this is where are used the properties that are defined in the configuration.properties file.

(portal.container.gatein.jcr.datasource.driver, portal.container.gatein.jcr.datasource.url, etc...)

** simple config

if you only need simple config, then only modify the properties in the configuration.properties file.

hope it helps,...

Antoine Herzog

Consultant JBoss Portal and GateIn (JSR-286), JSF, Richfaces, J2EE, Drools, BRMS.

[ajsushil]

Hi Antoine Herzog,

Thanks for the reply. I tried these options still the issue persists.

But issue is resolved by following steps

1. delete the gatein-sample-portal.ear

2. Create jdbcjcr_portal and jdbcidm_pportal schema in mysql server.

3. modify configuration.properties with mysql server details as mentioned below

gatein.jcr.datasource.driver=com.mysql.jdbc.Driver
gatein.jcr.datasource.url=jdbc:mysql://localhost:3306/jdbcjcr_${name}
gatein.jcr.datasource.username=userid
gatein.jcr.datasource.password=password

gatein.idm.datasource.driver=com.mysql.jdbc.Driver
gatein.idm.datasource.url=jdbc:mysql://localhost:3306/jdbcidm_${name}
gatein.idm.datasource.username=userid
gatein.idm.datasource.password=password

Copy the mysql connector driver in the deploy/lib folder. The databases created in my sql. Page management is coming up properly.

Earlier I had issue with Gadets also. By this new stup the Gadget are coming up properly. All the issues related to migration of the portal db to my sql is resolved.

Once again thanks for your response.