2 Replies Latest reply on Feb 22, 2014 3:11 PM by bhathiya

Jpp 6.1(gatein 3.6) Mysql configuration

bhathiya Feb 19, 2014 1:57 AM

Edit:- I still need help...hit "assumed answer" by mistake and don't know how to undo it
I tried to configure jboss portal 6.1 for about 2 days now. I tried editing configure.properties,standalone.xml , creating module.xml . This runs and server starts @localhost(without any error logs) and redirect me to localhost:8080/portal/mobile.But database is not populated with schema.what could have gone wrong? thanks in advance for any suugetions.

Here is my standalone.xml

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

</extensions>

<system-properties>

</system-properties>

<security-realms>

<security-realm name="ManagementRealm">

</authentication>

</security-realm>

<security-realm name="ApplicationRealm">

</authentication>

</authorization>

</security-realm>

</security-realms>

<management-interfaces>

<native-interface security-realm="ManagementRealm">

<socket-binding native="management-native"/>

</native-interface>

<http-interface security-realm="ManagementRealm">

<socket-binding http="management-http"/>

</http-interface>

</management-interfaces>

</management>

<console-handler name="CONSOLE">

<pattern-formatter pattern="%K{level}%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%E%n"/>

</formatter>

</console-handler>

<periodic-rotating-file-handler name="FILE" autoflush="true">

<pattern-formatter pattern="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%E%n"/>

</formatter>

</periodic-rotating-file-handler>

</logger>

</logger>

</logger>

</logger>

</logger>

</logger>

</logger>

<root-logger>

</handlers>

</root-logger>

</subsystem>

<connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>

<user-name>sa</user-name>

</security>

</datasource>

<connection-url>jdbc:h2:file:${jboss.server.data.dir}/gatein/portal/jdbcidm_portal;DB_CLOSE_DELAY=-1</connection-url>

<user-name>sa</user-name>

</security>

</datasource>

<connection-url>jdbc:h2:file:${jboss.server.data.dir}/gatein/portal/jdbcjcr_portal;DB_CLOSE_DELAY=-1</connection-url>

<user-name>sa</user-name>

</security>

</datasource>

<datasource

jndi-name="java:/mygateindb_portal" pool-name="my_pool"

enabled="true" jta="true"

use-java-context="true" use-ccm="true">

<connection-url>

jdbc:mysql://localhost:3306/mygateindb_portal

</connection-url>

mysql

</driver>

<user-name>

root

</user-name>

</password>

</security>

<prepared-statement-cache-size>

100

</prepared-statement-cache-size>

<share-prepared-statements/>

</statement>

</datasource>

<!--

<connection-url>jdbc:h2:file:${jboss.server.data.dir}/gatein/sample-portal/jdbcidm_sample_portal;DB_CLOSE_DELAY=-1</connection-url>

<user-name>sa</user-name>

</security>

</datasource>

-->

<!--

<connection-url>jdbc:h2:file:${jboss.server.data.dir}/gatein/sample-portal/jdbcjcr_sample_portal;DB_CLOSE_DELAY=-1</connection-url>

<user-name>sa</user-name>

</security>

</datasource>

-->

<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

</driver>

</drivers>

</datasources>

</subsystem>

<deployment-scanner deployment-timeout="300" path="deployments" relative-to="jboss.server.base.dir" scan-interval="5000"/>

</subsystem>

<spec-descriptor-property-replacement>false</spec-descriptor-property-replacement>

<jboss-descriptor-property-replacement>true</jboss-descriptor-property-replacement>

</subsystem>

<session-bean>

<bean-instance-pool-ref pool-name="slsb-strict-max-pool"/>

</stateless>

</session-bean>

<pools>

<bean-instance-pools>

<strict-max-pool name="slsb-strict-max-pool" max-pool-size="20" instance-acquisition-timeout="5" instance-acquisition-timeout-unit="MINUTES"/>

<strict-max-pool name="mdb-strict-max-pool" max-pool-size="20" instance-acquisition-timeout="5" instance-acquisition-timeout-unit="MINUTES"/>

</bean-instance-pools>

</pools>

</caches>

<passivation-stores>

<file-passivation-store name="file"/>

</passivation-stores>

<timer-service thread-pool-name="default">

<data-store path="timer-service-data" relative-to="jboss.server.data.dir"/>

</timer-service>

<thread-pools>

<thread-pool name="default">

<max-threads count="10"/>

<keepalive-time time="100" unit="milliseconds"/>

</thread-pool>

</thread-pools>

<default-security-domain value="other"/>

<default-missing-method-permissions-deny-access value="true"/>

</subsystem>

<!--

<cache-container name="web" aliases="standard-session-cache" default-cache="local-web" module="org.jboss.as.clustering.web.infinispan">

<local-cache name="local-web" batching="true">

<file-store passivation="false" purge="false"/>

</local-cache>

</cache-container>

-->

<cache-container name="hibernate" default-cache="local-query" module="org.jboss.as.jpa.hibernate:4">

<local-cache name="entity">

</local-cache>

<local-cache name="local-query">

</local-cache>

<local-cache name="timestamps">

</local-cache>

</cache-container>

</subsystem>

<archive-validation enabled="true" fail-on-error="true" fail-on-warn="false"/>

<bean-validation enabled="true"/>

<default-workmanager>

<short-running-threads>

<core-threads count="50"/>

<queue-length count="50"/>

<max-threads count="50"/>

<keepalive-time time="10" unit="seconds"/>

</short-running-threads>

<long-running-threads>

<core-threads count="50"/>

<queue-length count="50"/>

<max-threads count="50"/>

<keepalive-time time="10" unit="seconds"/>

</long-running-threads>

</default-workmanager>

<cached-connection-manager/>

</subsystem>

<expose-resolved-model/>

<expose-expression-model/>

<remoting-connector/>

</subsystem>

</subsystem>

<mail-session jndi-name="java:jboss/mail/Default">

<smtp-server outbound-socket-binding-ref="mail-smtp"/>

</mail-session>

</subsystem>

<remote-naming/>

</subsystem>

</subsystem>

<security-domains>

<security-domain name="other" cache-type="default">

<login-module code="Remoting" flag="optional">

<module-option name="password-stacking" value="useFirstPass"/>

</login-module>

<login-module code="RealmDirect" flag="required">

<module-option name="password-stacking" value="useFirstPass"/>

</login-module>

</authentication>

</security-domain>

<security-domain name="jboss-web-policy" cache-type="default">

<policy-module code="Delegating" flag="required"/>

</authorization>

</security-domain>

<security-domain name="jboss-ejb-policy" cache-type="default">

<policy-module code="Delegating" flag="required"/>

</authorization>

</security-domain>

<security-domain name="gatein-domain" cache-type="default">

<login-module code="org.gatein.security.oauth.jaas.OAuthLoginModule" flag="required">

<module-option name="portalContainerName" value="portal"/>

<module-option name="realmName" value="gatein-domain"/>

</login-module>

<login-module code="org.gatein.sso.integration.SSODelegateLoginModule" flag="required">

<module-option name="enabled" value="#{gatein.sso.login.module.enabled}"/>

<module-option name="delegateClassName" value="#{gatein.sso.login.module.class}"/>

<module-option name="portalContainerName" value="portal"/>

<module-option name="realmName" value="gatein-domain"/>

<module-option name="password-stacking" value="useFirstPass"/>

</login-module>

<login-module code="org.exoplatform.services.security.j2ee.JBossAS7LoginModule" flag="required">

<module-option name="portalContainerName" value="portal"/>

<module-option name="realmName" value="gatein-domain"/>

</login-module>

</authentication>

</security-domain>

<!--

<security-domain name="gatein-domain-sample-portal" cache-type="default">

<login-module code="org.gatein.security.oauth.jaas.OAuthLoginModule" flag="required">

<module-option name="portalContainerName" value="sample-portal"/>

<module-option name="realmName" value="gatein-domain-sample-portal"/>

</login-module>

<login-module code="org.gatein.sso.integration.SSODelegateLoginModule" flag="required">

<module-option name="enabled" value="#{gatein.sso.login.module.enabled}" />

<module-option name="delegateClassName" value="#{gatein.sso.login.module.class}" />

<module-option name="portalContainerName" value="sample-portal" />

<module-option name="realmName" value="gatein-domain-sample-portal" />

<module-option name="password-stacking" value="useFirstPass" />

</login-module>

<login-module code="org.exoplatform.services.security.j2ee.JBossAS7LoginModule" flag="required">

<module-option name="portalContainerName" value="sample-portal"/>

<module-option name="realmName" value="gatein-domain-sample-portal"/>

</login-module>

</authentication>

</security-domain>

-->

</security-domains>

</subsystem>

<core-environment>

<process-id>

<uuid/>

</process-id>

</core-environment>

<recovery-environment socket-binding="txn-recovery-environment" status-socket-binding="txn-status-manager"/>

<coordinator-environment default-timeout="300"/>

</subsystem>

<virtual-server name="default-host" enable-welcome-root="true">

</virtual-server>

</subsystem>

<modify-wsdl-address>true</modify-wsdl-address>

<wsdl-host>${jboss.bind.address:127.0.0.1}</wsdl-host>

<endpoint-config name="Standard-Endpoint-Config"/>

<endpoint-config name="Recording-Endpoint-Config">

<pre-handler-chain name="recording-handlers" protocol-bindings="##SOAP11_HTTP ##SOAP11_HTTP_MTOM ##SOAP12_HTTP ##SOAP12_HTTP_MTOM">

</pre-handler-chain>

</endpoint-config>

<client-config name="Standard-Client-Config"/>

</subsystem>

<portlet-war-dependencies>

</portlet-war-dependencies>

</subsystem>

</profile>

<inet-address value="${jboss.bind.address.management:127.0.0.1}"/>

</interface>

<inet-address value="${jboss.bind.address:127.0.0.1}"/>

</interface>

<!--

~ Used for IIOP sockets in the standard configuration.

~ To secure JacORB you need to setup SSL

-->

<inet-address value="${jboss.bind.address.unsecure:127.0.0.1}"/>

</interface>

</interfaces>

<socket-binding-group name="standard-sockets" default-interface="public" port-offset="${jboss.socket.binding.port-offset:0}">

<socket-binding name="management-native" interface="management" port="${jboss.management.native.port:9999}"/>

<socket-binding name="management-http" interface="management" port="${jboss.management.http.port:9990}"/>

<socket-binding name="management-https" interface="management" port="${jboss.management.https.port:9443}"/>

<socket-binding name="ajp" port="8009"/>

<socket-binding name="http" port="8080"/>

<socket-binding name="https" port="8443"/>

<socket-binding name="remoting" port="4447"/>

<socket-binding name="txn-recovery-environment" port="4712"/>

<socket-binding name="txn-status-manager" port="4713"/>

<outbound-socket-binding name="mail-smtp">

<remote-destination host="localhost" port="25"/>

</outbound-socket-binding>

</socket-binding-group>

</server>

This is C:\Users\Bhathiya\Documents\jpp\jboss-jpp-6.1\standalone\configuration\gatein\configuration.properties

gatein.conf.dir=${jboss.server.config.dir}/gatein

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

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

###########################

# Single node configuration

# or

# Default cluster configuration using local indexes (see standalone-ha.xml for more settings)

# JCR

gatein.jcr.data.dir=${gatein.data.dir}/jcr

##########################

# Cluster configuration with shared filesystem (NFS)

# JCR

# All gatein nodes have to point to the same shared filesystem directory

#gatein.clustered.data.dir=${jboss.home.dir}/../gatein-cluster

#gatein.jcr.index.changefilterclass=org.exoplatform.services.jcr.impl.core.query.jbosscache.JBossCacheIndexChangesFilter

# DB

gatein.jcr.data.dir=${gatein.clustered.data.dir}/jcr

gatein.jcr.datasource.driver=com.mysql.jdbc.Driver

gatein.jcr.datasource.url=jdbc:mysql://localhost:3306/mygateindb${container.name.suffix}

gatein.jcr.datasource.username=root

gatein.jcr.datasource.password=

# Turn on JCR value storage that is disabled for default cluster configuration in standalone-ha.xml

#gatein.jcr.storage.enabled=true

###########################

# Common configuration for all profiles

# JCR

gatein.jcr.datasource.name=java:/jdbcjcr

gatein.jcr.datasource.dialect=auto

gatein.jcr.storage.data.dir=${gatein.jcr.data.dir}/values

gatein.jcr.cache.config=war:/conf/jcr/jbosscache/${gatein.jcr.config.type}/config.xml

gatein.jcr.cache.config.workspace.portal-system=war:/conf/jcr/jbosscache/${gatein.jcr.config.type}/config_portal-system.xml

gatein.jcr.lock.cache.config=war:/conf/jcr/jbosscache/${gatein.jcr.config.type}/lock-config.xml

gatein.jcr.index.data.dir=${gatein.jcr.data.dir}/lucene

gatein.jcr.index.cache.config=war:/conf/jcr/jbosscache/cluster/indexer-config.xml

gatein.jcr.jgroups.config=classpath:/jgroups/gatein-${gatein.default.jgroups.stack:udp}.xml

gatein.jcr.db-structure-type=isolated

gatein.jcr.workspace.default=portal-system

gatein.jcr.workspace.system=system

# IDM

gatein.idm.datasource.name=java:/jdbcidm

gatein.idm.datasource.driver=com.mysql.jdbc.Driver

gatein.idm.datasource.url=jdbc:mysql://localhost:3306/mygateinidm${container.name.suffix}

gatein.idm.datasource.username=root

gatein.idm.datasource.password=

# 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

# Portlet container configuration

gatein.portlet.validation=true

gatein.portlet.config=${gatein.conf.dir}/portlet.xml

# Portal configuration

gatein.portal.idm.createuserportal=false

gatein.portal.idm.destroyuserportal=true

gatein.portal.controller.config=${gatein.conf.dir}/controller.xml

# key files for gadget

gatein.gadgets.securitytokenkeyfile=${gatein.conf.dir}/gadgets/key.txt

gatein.gadgets.signingkeyfile=${gatein.conf.dir}/gadgets/oauthkey.pem

# SSO

gatein.sso.enabled=false

# OAuth

gatein.oauth.portal.url=http://localhost:8080

## Facebook

gatein.oauth.facebook.enabled=false

gatein.oauth.facebook.clientId=to be replaced

gatein.oauth.facebook.clientSecret=to be replaced

gatein.oauth.facebook.redirectURL=${gatein.oauth.portal.url}/@@portal.container.name@@/facebookAuth

gatein.oauth.facebook.scope=email

## Google

gatein.oauth.google.enabled=false

gatein.oauth.google.clientId=to be replaced

gatein.oauth.google.clientSecret=to be replaced

gatein.oauth.google.redirectURL=${gatein.oauth.portal.url}/@@portal.container.name@@/googleAuth

gatein.oauth.google.scope=https://www.googleapis.com/auth/userinfo.email https://www.googleapis.com/auth/userinfo.profile

gatein.oauth.google.accessType=offline

## Twitter

gatein.oauth.twitter.enabled=false

gatein.oauth.twitter.clientId=to be replaced

gatein.oauth.twitter.clientSecret=to be replaced

gatein.oauth.twitter.redirectURL=${gatein.oauth.portal.url}/@@portal.container.name@@/twitterAuth

# Resource browser caching configuration

#gatein.assets.version=PORTAL-VERSION

#gatein.assets.script.max-age=604800

#gatein.assets.css.max-age=604800

# Root password

#gatein.portal.setup.initialpassword.root=

I also created C:\Users\Bhathiya\Documents\jpp\jboss-jpp-6.1\modules\com\mysql\main\module.xml

<resource-root path="mysql-connector-java-5.1.29-bin.jar"/>

</resources>

</dependencies>

</module>

1. Re: Jpp 6.1(gatein 3.6) Mysql configuration

rutlucas Feb 19, 2014 3:35 AM (in response to bhathiya)

It's probably your config is messed up at some point.

If you are using JBoss Portal distribution, try this:

https://access.redhat.com/site/documentation/en-US/Red_Hat_JBoss_Portal/6.1/html-single/Installation_Guide/index.html->
chapter 8.3

https://access.redhat.com/site/documentation/en-US/JBoss_Enterprise_Application_Platform/6.2/html-single/Administration_and_Configuration_Guide/index.html#chap-Datasource_Management->
chapter 6
1 of 1 people found this helpful
Actions
2. Re: Jpp 6.1(gatein 3.6) Mysql configuration

bhathiya Feb 22, 2014 3:11 PM (in response to rutlucas)

Thanks for the help... I could configure tomcat distribution which was my first choice.Answer toUnable to launch GateIn 3.6.0 Tomcat distro with Oracle helped me.I think it would work for Jpp 6.1 as well.(I didn't try it though)
Here I quote the anwer
"I edited the file gatein-3.6.0.final-tomcat7/webapps/portal/WEB-INF/conf/organization/idm-configuration.xml and changed the value of hibernate.hbm2ddl.autofrom ‘update’ to ‘create’ (line 46)
I started the tomcat instance it populated the tables and the portal came up.
I shut it down and again edited the file gatein-3.6.0.final-tomcat7/webapps/portal/WEB-INF/conf/organization/idm-configuration.xml . This time changing the value of hibernate.hbm2ddl.auto from ‘create’ to ‘none’ ( if you don’t do this it will re-create the schema every time the portal launches, changing ti back to update was also an option, but I didn’t want it messing with the schema).
I started the tomcat instance the portal came back up."
Actions

Go to original post