構造的に表示 平面上に表示 ツリー上に表示
スレッド [ 前へ | 次へ ]
toggle
Aikido Guy
Help setting up Liferay (from a beginner)
2012/10/30 12:59
答え

Aikido Guy

ランク: New Member

投稿: 1

参加年月日: 2012/10/30

最近の投稿

Hello,

I am following Richard Sezov's book "Liferay in Action" and trying to set it up to use a MySQL database.
I have created a database in MySQL:
create database mydb character set utf8;

I do get a page open in my web browser.

However, I get the following message from Tomcat:
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Data source reje
cted establishment of connection, message from server: "Too many connections"

Any tips/suggestions for how to fix this? I am also learning about MySQL.

Thanks!
Hitoshi Ozawa
RE: Help setting up Liferay (from a beginner)
2012/10/30 18:28
答え

Hitoshi Ozawa

ランク: Liferay Legend

投稿: 7949

参加年月日: 2010/03/23

最近の投稿

Did you give admin privileges to the user connecting to the database?
Gaurav Jain
RE: Help setting up Liferay (from a beginner)
2012/10/30 23:38
答え

Gaurav Jain

ランク: Regular Member

投稿: 146

参加年月日: 2011/01/31

最近の投稿

Aikido Guy:
message from server: "Too many connections"


Seems like your mysql server is throwing connection exceeded exception here.
So either close unused connections. Or update your mysql configuration to allow it for more number of connections.
Ketan Patel
RE: Help setting up Liferay (from a beginner)
2012/10/31 0:32
答え

Ketan Patel

ランク: Junior Member

投稿: 72

参加年月日: 2012/05/04

最近の投稿

Hi,

If you want to setup liferay with tomcat bundle from scratch, you can follow the below mentioned blog.

http://ketanpatel88.blogspot.in/2012/10/liferay-configuration-in-windows-with.html


Let me know if you wants any more information.

Thanks,
Ketan Patel
Hitoshi Ozawa
RE: Help setting up Liferay (from a beginner)
2012/10/31 6:29
答え

Hitoshi Ozawa

ランク: Liferay Legend

投稿: 7949

参加年月日: 2010/03/23

最近の投稿

After re-reading the initial post, I think you're right. Check if mysql is also being used by other programs. This happens when a program isn't closing the connection.

One way to prevent this from happening is to set thead_cache and wait_time to a lower value than those of the mysql default in my.cnf.
Example:
thread_cache=150
wait_time=10