9 Replies Latest reply on Jan 31, 2011 10:42 AM by Tim Starwarskiy

    GateIn & MySQL - other issues

    Ahmad Adeel Newbie

      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

        • 1. Re: GateIn & MySQL
          kien nguyen Newbie

          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

          • 2. Re: GateIn & MySQL
            Ahmad Adeel Newbie

            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

            • 3. Re: GateIn & MySQL - other issues
              Khoi Nguyen Novice
              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

              • 4. Re: GateIn & MySQL
                Ahmad Adeel Newbie

                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

                • 5. Re: GateIn & MySQL
                  Ahmad Adeel Newbie

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

                   

                  Adnan

                  • 6. Re: GateIn & MySQL
                    Ahmad Adeel Newbie

                    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

                    • 7. Re: GateIn & MySQL
                      Khoi Nguyen Novice

                      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

                      • 8. Re: GateIn & MySQL
                        Khoi Nguyen Novice

                        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

                        • 9. GateIn & MySQL - other issues
                          Tim Starwarskiy Newbie

                          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?