掲示板

Liferay 6.0.6 bundled with glassfish v3 ()mysql

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

Liferay 6.0.6 bundled with glassfish v3 ()mysql

New Member 投稿: 8 参加年月日: 13/04/26 最新の投稿
Hi,
I downloaded liferay bundled with glassfish (Liferay 6.0.6 bundled with glassfish v3) from liferay official website, I am trying to integrate it with the mysql database but failing. I am done with all the necessary steps, like creating DB in mysql and granting access to the user, executing the mysql.script for creating the schema but glassfish/liferay fails to connect with mysql when I start the service. It tries but connections goes in the Time_wait states. I have checked the databasename, privileges, password/username, everything is right in the portal-ext.properties but it doesn't connect. when staring the service I have seen the logs, it read the portal-ext.properties file and then start making connections to mysql with time_wait states (I came to know about it through netstat command). Then exceptions start coming in the logs saying that didn't read any response from server (mysql), could it be the JDBC driver, however I downloaded one from oracle.com but .... emoticon
thumbnail
10年前 に Juan Gonzalez によって更新されました。

RE: Liferay 6.0.6 bundled with glassfish v3 ()mysql

Liferay Legend 投稿: 3089 参加年月日: 08/10/28 最新の投稿
Can you share your jdbc config in portal-ext.properties?

Are you accessing from the same mysql host or from a remote host? If it's the latter, then you have to enable MySQL to accept connections from outside "localhost".
10年前 に A B によって更新されました。

RE: Liferay 6.0.6 bundled with glassfish v3 ()mysql

New Member 投稿: 8 参加年月日: 13/04/26 最新の投稿
Hi, thanks for your reply !
I don't think if I have some issue with my mysql settings, I have both services on localhost. Following is the settings and logs

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://127.0.0.1:3306/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=mypassword
####################################
#############LOGS###################
[#|2013-04-29T09:37:12.041+0000|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=11;_ThreadName=FelixStartLevel;|Loading file:/usr/liferay/liferay-zip-file/liferay-portal-6.0.6/glassfish-3.0.1/domains/domain1/generated/jsp/liferay-portal/loader_725684484/portal.properties|#]

[#|2013-04-29T09:37:12.042+0000|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=11;_ThreadName=FelixStartLevel;|Loading file:/usr/liferay/liferay-zip-file/liferay-portal-6.0.6/glassfish-3.0.1/domains/domain1/applications/liferay-portal/WEB-INF/classes/portal-ext.properties|#]

[#|2013-04-29T09:37:39.028+0000|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=19;_ThreadName=Timer-0;|09:37:39,010 WARN [ThreadPoolAsynchronousRunner:608] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@28e4da4b -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
|#]

[#|2013-04-29T09:37:39.033+0000|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=19;_ThreadName=Timer-0;|09:37:39,033 WARN [ThreadPoolAsynchronousRunner:624] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@28e4da4b -- APPARENT DEADLOCK!!! Complete Status:
Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@62b1e16 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@78c43983 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1a9c0566 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7926792f
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@4cde3acc
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@11e64e81
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@272c0055
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@39c9e08a
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@74b4a1a9
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7ee19a1a
Pool thread stack traces:
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)