GateIn & MySQL - other issues

[adnanqureshi]

I am trying to setup GateIn with MySQL and can't get it running, I followed the instructions provided on http://community.jboss.org/wiki/ConfigureGateIntouseMySQL provided by  Ranganathan Barathan with no luck.

When I try to access http://localhost:8080/potal nothing happens,

When I try to access http://localhost:8080/sample-portal I can see the page but the css on this app is screwed, I can't do anything.

On the Old JBoss Portal, I could access the administration area, whats the url on GateIn to access the portal administration?

I can't get the portal app running, am running GateIn 310 final jbossas.

I would really appreciate if someone can help me setup the GateIn with MySQL.

Following are the errors I am seeing on console,

14:29:37,051 INFO  [SearchIndex] path=C:\GateIn\server\default\data/gatein/jcr/lucene/system_sample-portal_system

14:29:37,058 ERROR [SearchManager] null

14:29:37,062 ERROR [RepositoryServiceImpl] Error start repository service

org.exoplatform.services.jcr.config.RepositoryConfigurationException: Repository conatainer repository was not started.

14:29:37,282 ERROR [STDERR] javax.jcr.RepositoryException: Repository 'repository' not found.

14:29:51,501 ERROR [STDERR] java.lang.RuntimeException: Failed start Organization Service org.exoplatform.services.organization.idm.PicketLinkIDMOrganizationServiceImpl, probably because of configurat

ion error. Error occurs when initialize org.exoplatform.services.organization.OrganizationDatabaseInitializer

14:29:51,807 ERROR [Portal:UserPortalConfigService] Could not import initial data

org.chromattic.api.UndeclaredRepositoryException: javax.jcr.RepositoryException: Repository 'repository' not found.

        at org.chromattic.core.api.ChromatticImpl.openSession(ChromatticImpl.java:59)

14:29:52,023 ERROR [RootContainer] Cannot create the portal container 'portal' . ServletContext: org.apache.catalina.core.ApplicationContextFacade@856566

org.picocontainer.PicoIntrospectionException: Failed when calling start on org.gatein.portal.wsrp.WSRPServiceIntegration@1c2a76a

[kien_nguyen]

It looks like your driver configuration is incorrect, so repository is not initial.

Now, Gatein has some changes for configuration, simply you change content of /gatein/conf/configuration.properties

Examples:

- Change lines:
gatein.jcr.datasource.driver=org.hsqldb.jdbcDriver
gatein.jcr.datasource.url=jdbc:hsqldb:file:${gatein.db.data.dir}/data/jdbcjcr_${name}
gatein.jcr.datasource.username=sa
gatein.jcr.datasource.password=

to

gatein.jcr.datasource.driver=com.mysql.jdbc.Driver
gatein.jcr.datasource.url=jdbc:mysql://localhost:3306/yourgateindb
gatein.jcr.datasource.username=db_username
gatein.jcr.datasource.password=db_password

- And lines:

gatein.idm.datasource.name=jdbcidm
gatein.idm.datasource.driver=org.hsqldb.jdbcDriver
gatein.idm.datasource.url=jdbc:hsqldb:file:${gatein.db.data.dir}/data/jdbcidm_${name}
gatein.idm.datasource.username=sa
gatein.idm.datasource.password=

to

gatein.idm.datasource.driver=com.mysql.jdbc.Driver
gatein.idm.datasource.url=jdbc:mysql://localhost:3306/yourgateindb
gatein.idm.datasource.username=db_username
gatein.idm.datasource.password=db_password

[adnanqureshi]

I'll give this one more try today, but why do I feel like the documentation is not enough or am taking wrong aproach?

I have been looking to build a portal with following capabilities,

- web content management

- document management

- any blog app

- wiki

- search

- deploying existing portlets (build on JBoss Portal) on Gate In

- Portlet to Portlet communication (each portlet with different .war file)

and am struggling with all of them,

I can't find the WCM that I can deploy on GateIn. My assumption was I could download some ear from eXo and deploy it on GateIn - can't find it.

Same is the case with Document Management, blog and wiki.

I heard that now GateIn is integrated with Lucene search, don't know how to get it going.

As soon as I deploy my old portlets (deployed on JBoss Portal), I get Outofmemory error. GateIn is running on xmx1024

Any suggestion on portlet communication deployed with different ear files?

We are considering GateIn for our company, but am struggling with it.

I would really appreciate if someone can provide me the respective documentation or any insights on how I can get the above going.

Regards,

Adnan

[ndkhoiits]

I can't find the WCM that I can deploy on GateIn. My assumption was I could download some ear from eXo and deploy it on GateIn - can't find it.

You can find more information at here:  http://exoplatform.com/company/public/website/platform/exo-core-services/exo-content

and some WCM demo:  http://wcm.demo.exoplatform.org/ecmdemo/public/acme

[adnanqureshi]

Hi Khoi,

I did downloaded it earlier, looks like this is bundled up with the tomcat, no signs of JBoss at all, why is it like that?

We already have a server running with JBoss GateIn. we want wcm to be deployed on it, getting my point?

Regards,

Adnan

[adnanqureshi]

moved the other issues at https://community.jboss.org/thread/156485

Adnan

[adnanqureshi]

Hi Kien,

I downloaded the the latest version of GateIn 3.1, made the changes as per your recomendations, and getting the same error.

I am running MySql 5, mysql driver is in server/default/lib folder. I can see that as soon as I start the server, it first creates the table in the provided database information. So I think we can rule out the mysql/driver issues rite?

11:08:56,365 ERROR [RepositoryServiceImpl] Error start repository service

org.exoplatform.services.jcr.config.RepositoryConfigurationException: Repository conatainer repository was not started.

Java Settings:

===============================================================================

  JBoss Bootstrap Environment

  JBOSS_HOME: C:\GateIn-mysql

  JAVA: C:\Program Files (x86)\Java\jdk1.6.0_21\bin\java

  JAVA_OPTS: -Dprogram.name=run.bat -Xms512M -Xmx1024M -XX:MaxPermSize=256M -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Dorg.jboss.resolver.warning=true -Dexo.conf

.dir.name=gatein -server

  CLASSPATH: C:\GateIn-mysql\bin\run.jar

===============================================================================

Error on Console:

11:08:56,360 INFO  [SearchIndex] path=C:\GateIn-mysql\server\default\data/gatein/jcr/lucene/system_sample-portal_system

11:08:56,364 ERROR [SearchManager] null

11:08:56,365 ERROR [RepositoryServiceImpl] Error start repository service

org.exoplatform.services.jcr.config.RepositoryConfigurationException: Repository conatainer repository was not started.

        at org.exoplatform.services.jcr.impl.RepositoryServiceImpl.createRepository(RepositoryServiceImpl.java:168)

        at org.exoplatform.services.jcr.impl.RepositoryServiceImpl.init(RepositoryServiceImpl.java:360)

Regards,

Adnan

[ndkhoiits]

FYI, you must remove $JBOSS_HOME/server/default/deploy/gatein-sample-portal.ear in your server for running gatein jboss

$JBOSS_HOME/server/default/deploy/gatein-

sample-portal.ear

[ndkhoiits]

Bydefault, gatein will need a database named yourdatebase_${name} with name is portal container name. So if you want to run sample portal in gatein, you must create a database named yourdatabse_sample-portal.

Good luck for you

[timmmm]

Hi. I have same error.

2011-01-31 18:23:18,133 DEBUG [exo.jcr.component.core.RepositoryServiceImpl] RepositoryServiceimpl() getRepository repository

2011-01-31 18:23:18,133 ERROR [Portal:UserPortalConfigService] Could not import initial data

org.chromattic.api.UndeclaredRepositoryException: javax.jcr.RepositoryException: Repository 'repository' not found.

    at org.chromattic.core.api.ChromatticImpl.openSession(ChromatticImpl.java:59)

I changed config file $JBOSS_HOME/server/default/conf/gatein/configuration.properties

After portal start i see new tables in my data bases (gate_in_portal, gate_in_sample-portal), but 'repository' still not start.

What i must do else to start?