掲示板

  1. ホーム
  2. Portal
  3. Configuration Liferay 6.1 GA3 et MysqlServer 5.6

Configuration Liferay 6.1 GA3 et MysqlServer 5.6

10年前 に Emilien Bécu によって更新されました。

Configuration Liferay 6.1 GA3 et MysqlServer 5.6

New Member 投稿: 12 参加年月日: 13/10/14 最新の投稿
Bonjour a tous, je suis bloqué depuis ce midi, j'ai cherché sur les forum anglais francais et tout autre site qui pourrait m'aider je fait les différente manip mais cela ne change rien...

Mon problème c'est que le startup.bat se lance la fenêtre apparaît bien mais se ferme subitement, j'ai aucune idée du pourquoi et je ne comprend pas ce que veut dire les log en dessous...

Voici mes logs de connexion :

15:07:00,002 INFO  [localhost-startStop-1][DialectDetector:71] Determine dialect for MySQL 5
15:07:00,060 INFO  [localhost-startStop-1][DialectDetector:136] Found dialect org.hibernate.dialect.MySQLDialect
15:07:24,689 ERROR [localhost-startStop-1][JDBCExceptionReporter:82] Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
15:07:24,699 WARN  [localhost-startStop-1][PDFProcessorImpl:235] Liferay is not configured to use ImageMagick. For better quality document and image previews, install ImageMagick and enable it in portal-ext.properties or in the Server Administration control panel at: http://<server>/group/control_panel/manage/-/server/external-services
15:07:31,531 INFO  [localhost-startStop-1][BaseDB:481] Database does not support case sensitive queries
15:07:31,555 ERROR [localhost-startStop-1][JDBCExceptionReporter:82] Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
15:07:31,560 ERROR [localhost-startStop-1][CustomSQLUtil:131] java.lang.RuntimeException: Unable to get class name from value com.liferay.portal.model.Group
java.lang.RuntimeException: Unable to get class name from value com.liferay.portal.model.Group
	at com.liferay.portal.service.impl.ClassNameLocalServiceImpl.getClassNameId(ClassNameLocalServiceImpl.java:157)
	at com.liferay.portal.service.impl.ClassNameLocalServiceImpl.getClassNameId(ClassNameLocalServiceImpl.java:145)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:117)
	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:52)
	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:113)
	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:113)
	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:113)
	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:113)
	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:113)
	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:218)
	at com.liferay.portal.security.pacl.PACLInvocationHandler.doInvoke(PACLInvocationHandler.java:62)
	at com.liferay.portal.security.pacl.PACLInvocationHandler.invoke(PACLInvocationHandler.java:51)
	at com.sun.proxy.$Proxy90.getClassNameId(Unknown Source)
	at com.liferay.portal.service.ClassNameLocalServiceUtil.getClassNameId(ClassNameLocalServiceUtil.java:301)
	at com.liferay.portal.util.PortalImpl.getClassNameId(PortalImpl.java:1318)
	at com.liferay.portal.util.PortalImpl.initCustomSQL(PortalImpl.java:5027)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.liferay.portal.security.lang.DoPrivilegedHandler.doInvoke(DoPrivilegedHandler.java:88)
	at com.liferay.portal.security.lang.DoPrivilegedHandler.invoke(DoPrivilegedHandler.java:56)
	at com.sun.proxy.$Proxy393.initCustomSQL(Unknown Source)
	at com.liferay.portal.util.PortalUtil.initCustomSQL(PortalUtil.java:1415)
	at com.liferay.util.dao.orm.CustomSQL.reloadCustomSQL(CustomSQL.java:233)
	at com.liferay.util.dao.orm.CustomSQL.<init>(CustomSQL.java:75)
	at com.liferay.util.dao.orm.CustomSQLUtil.<init>(CustomSQLUtil.java:128)
	at com.liferay.util.dao.orm.CustomSQLUtil.<clinit>(CustomSQLUtil.java:137)
	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:127)
	at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:119)
	at com.liferay.portal.events.StartupAction.run(StartupAction.java:50)
	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1300)
	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
	at javax.servlet.GenericServlet.init(GenericServlet.java:160)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5123)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5407)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1636)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:724)
Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:209)
	at com.liferay.portal.service.persistence.ClassNamePersistenceImpl.updateImpl(ClassNamePersistenceImpl.java:329)
	at com.liferay.portal.service.persistence.ClassNamePersistenceImpl.updateImpl(ClassNamePersistenceImpl.java:1)
	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:289)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.liferay.portal.security.lang.DoPrivilegedHandler.doInvoke(DoPrivilegedHandler.java:88)
	at com.liferay.portal.security.lang.DoPrivilegedHandler.invoke(DoPrivilegedHandler.java:56)
	at com.sun.proxy.$Proxy452.update(Unknown Source)
	at com.liferay.portal.service.impl.ClassNameLocalServiceImpl.addClassName(ClassNameLocalServiceImpl.java:50)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:117)
	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:52)
	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:113)
	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:113)
	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:113)
	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:113)
	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:113)
	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:218)
	at com.liferay.portal.security.pacl.PACLInvocationHandler.doInvoke(PACLInvocationHandler.java:62)
	at com.liferay.portal.security.pacl.PACLInvocationHandler.invoke(PACLInvocationHandler.java:51)
	at com.sun.proxy.$Proxy90.addClassName(Unknown Source)
	at com.liferay.portal.service.impl.ClassNameLocalServiceImpl.getClassName(ClassNameLocalServiceImpl.java:134)
	at com.liferay.portal.service.impl.ClassNameLocalServiceImpl.getClassNameId(ClassNameLocalServiceImpl.java:152)
	... 58 more
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
	at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
	at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:147)
	at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.flush(ClassLoaderSession.java:237)
	at com.liferay.portal.service.persistence.BatchSessionImpl.update(BatchSessionImpl.java:86)
	at com.liferay.portal.service.persistence.BatchSessionUtil.update(BatchSessionUtil.java:50)
	at com.liferay.portal.service.persistence.ClassNamePersistenceImpl.updateImpl(ClassNamePersistenceImpl.java:324)
	... 90 more
Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
	at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:144)
	... 94 more
Caused by: java.sql.BatchUpdateException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
	... 100 more
15:07:31,593 ERROR [localhost-startStop-1][MainServlet:217] java.lang.NullPointerException
java.lang.NullPointerException
	at com.liferay.util.dao.orm.CustomSQLUtil.reloadCustomSQL(CustomSQLUtil.java:79)
	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:127)
	at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:119)
	at com.liferay.portal.events.StartupAction.run(StartupAction.java:50)
	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1300)
	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
	at javax.servlet.GenericServlet.init(GenericServlet.java:160)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5123)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5407)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1636)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:724)
</clinit></init></init></server>


Voila la config j'ai mis ça dans mon fichier portal-ext.properties :

#jdbc.default.jndi.name=jdbc/LiferayPool

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=toto46

#database.mysql.engine=InnoDB

J'ai bien créer ma base lportal dans mysql (j'ai essayé en créant juste la database et en utilisant les script liferay version minimal et normal)

J'ai aussi mis le mysqlconnector comme l'image jointe



Si vous avez besoin de plus d'info demandez moi, et merci a ceux qui pourrons m'aider
thumbnail
10年前 に Ramanjeneyulu Bodepudi によって更新されました。

RE: Configuration Liferay 6.1 GA3 et MysqlServer 5.6

Junior Member 投稿: 42 参加年月日: 12/02/24 最新の投稿
Step 1: Specify below code in context.xml
<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/mydb" password="root" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/mysql?autoReconnect=true" username="root"/>

update with your userName,Password as well as Ip,

Step 2: Create portal-ext.properties urnder tomcat directory
write below content
jdbc.default.jndi.name=jdbc/mydb
Name should be match with your resource jndi name
thumbnail
10年前 に Ramanjeneyulu Bodepudi によって更新されました。

RE: Configuration Liferay 6.1 GA3 et MysqlServer 5.6

Junior Member 投稿: 42 参加年月日: 12/02/24 最新の投稿
Please try with fresh Schema
10年前 に Emilien Bécu によって更新されました。

RE: Configuration Liferay 6.1 GA3 et MysqlServer 5.6

New Member 投稿: 12 参加年月日: 13/10/14 最新の投稿
thanks you for help me

J'ai essayé les manipulation et mon tomcat se lance bien mais maintenant ma page localhost n’apparais plus automatiquement lorsque Liferay démarre... Et si j'affiche ma page localhost, elle est vierge....

Je ne voit plus comment faire. Une autre idée?

ps: Ma base est créé grâce au script fourni par liferay et mon utilisateur a tout les pouvoirs sur la base