Help setting up Liferay (from a beginner)

[11年前 に Aikido Guy によって更新されました。]

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!

[11年前 に Hitoshi Ozawa によって更新されました。]

Did you give admin privileges to the user connecting to the database?

[11年前 に Gaurav Jain によって更新されました。]

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.

[11年前 に Hitoshi Ozawa によって更新されました。]

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

[11年前 に Ketan Patel によって更新されました。]

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