構造的に表示 平面上に表示 ツリー上に表示
スレッド [ 前へ | 次へ ]
toggle
A B
Liferay 6.0.6 bundled with glassfish v3 ()mysql
2013/04/28 15:40
答え

A B

ランク: New Member

投稿: 8

参加年月日: 2013/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
Juan Gonzalez
RE: Liferay 6.0.6 bundled with glassfish v3 ()mysql
2013/04/28 23:37
答え

Juan Gonzalez

LIFERAY STAFF

ランク: Liferay Legend

投稿: 1865

参加年月日: 2008/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".
A B
RE: Liferay 6.0.6 bundled with glassfish v3 ()mysql
2013/04/29 2:40
答え

A B

ランク: New Member

投稿: 8

参加年月日: 2013/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)