Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Aikido Guy
Help setting up Liferay (from a beginner)
October 30, 2012 12:59 PM
Answer

Aikido Guy

Rank: New Member

Posts: 1

Join Date: October 30, 2012

Recent Posts

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)
October 30, 2012 6:28 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7990

Join Date: March 23, 2010

Recent Posts

Did you give admin privileges to the user connecting to the database?
Gaurav Jain
RE: Help setting up Liferay (from a beginner)
October 30, 2012 11:38 PM
Answer

Gaurav Jain

Rank: Regular Member

Posts: 141

Join Date: January 31, 2011

Recent Posts

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)
October 31, 2012 12:32 AM
Answer

Ketan Patel

Rank: Junior Member

Posts: 70

Join Date: May 4, 2012

Recent Posts

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)
October 31, 2012 6:29 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7990

Join Date: March 23, 2010

Recent Posts

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