gatein 3.6 portal about Mysql configuaration

[wanggn]

我的配置 ：

#

# Copyright (C) 2009 eXo Platform SAS.

#

# This is free software; you can redistribute it and/or modify it

# under the terms of the GNU Lesser General Public License as

# published by the Free Software Foundation; either version 2.1 of

# the License, or (at your option) any later version.

#

# This software is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU

# Lesser General Public License for more details.

#

# You should have received a copy of the GNU Lesser General Public

# License along with this software; if not, write to the Free

# Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA

# 02110-1301 USA, or see the FSF site: http://www.fsf.org.

#

#

gatein.conf.dir=../gatein/conf

gatein.data.dir=../gatein/data

# DB

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

# JCR

#gatein.jcr.config.type=local

#gatein.jcr.datasource.name=jdbcjcr

#gatein.jcr.datasource.dialect=auto

#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=

gatein.jcr.config.type=local

gatein.jcr.datasource.name=jdbcjcr

gatein.jcr.datasource.dialect=auto

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=root

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

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.changefilterclass=org.exoplatform.services.jcr.impl.core.query.DefaultChangesFilter

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.repository.default=repository

gatein.jcr.workspace.default=portal-system

gatein.jcr.workspace.system=system

# IDM

#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=

gatein.idm.datasource.name=jdbcidm

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

gatein.idm.datasource.url=jdbc:mysql://localhost:3306/ilnuidm

gatein.idm.datasource.username=root

gatein.idm.datasource.password=root

# Arjuna configuration

com.arjuna.ats.arjuna.objectstore.objectStoreDir=${gatein.data.dir}/jta

# 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

# Remember me defaults commented out

# gatein.codec.builderclass=org.exoplatform.web.security.codec.JCASymmetricCodecBuilder

# gatein.codec.config=${gatein.conf.dir}/codec/jca-symmetric-codec.properties

# 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=6MSyXIj3kkQ=

发生如下错误：

119919 [Catalina-startStop-1] ERROR exo.kernel.container.RootContainer - Cannot

create the portal container 'portal' . ServletContext: org.apache.catalina.core.

ApplicationContextFacade@5b2a9a

java.lang.RuntimeException: Cannot instantiate component key=org.exoplatform.por

tal.config.UserPortalConfigService type=org.exoplatform.portal.config.UserPortal

ConfigService found at jndi:/localhost/portal/WEB-INF/conf/portal/portal-configu

ration.xml

希望得到帮助 告诉我解决方法

Want help tell me the solution

[wanggn]

Want to develop friends experience or solution

[rutlucas]

Hi,

Did you take a look into this

Database Configuration - GateIn Portal 3.6 - Project Documentation Editor

Hope this helps,

Lucas

[wanggn]

Hello teacher

I have made reference to these documents, but my main problem is that Mysql does not automatically built tables, please provide Mysql create database jdbccjr and jdbcidm below after I downloaded the SQL statement, see if I can run, I installed Mysql UFT8 characters do you need to modify the Latin character set, which modify the settings.

My   mail:[e-mail]

[rutlucas]

It's weird, GateIn should create tables if everything is configured ok.

Please, give a try to JPP version

http://www.jboss.org/gatein/download.html?dir=01%3DLatestFinalRelease%3B

I tested this one with MySQL and PostgreSQL and if you have a proper environment it should write your tables of the box.

Regards,

Lucas

[wanggn]

Mysql supports gatein installation environments, how to set up the support the Chinese, not garbled

[wanggn]

character_set_client	latin1
character_set_connection	latin1
character_set_database	latin1
character_set_filesystem	binary
character_set_results	latin1
character_set_server	latin1
character_set_system	utf8

Properly configured this should be done？

My current setup is as follows, a database query is garbage, what sets can reboot and same as above, but do not change.I use set name=latin1;Database is garbled

character_set_client	utf8
character_set_connection	utf8
character_set_database	latin1
character_set_filesystem	binary
character_set_results	utf8
character_set_server	latin1
character_set_system	utf8

I input Chinese

[rutlucas]

I don't have experience with chinese input.

I suggest one strategy, that can helps to debug where it can be your issue.

If your are running linux, please, set up a new virtual machine with Fedora, try to set up english languate, and repeat installation of mysql packages, java packages and gatein.

I'm sure that you will have a running instance.

Once, you can start to do small changes (language change in database, in operating system layer, etc), and you will see in what step something is broken, helping us to indentify if it's something related to the GateIn code, or just a problem of configuration layers where we can't modify.

This approach helped us with some weird scenarios where we don't have a clear clue about where the issue can be.

Hope this helps,

Lucas