Visualização combinada Visão plana Exibição em árvore
Tópicos [ Anterior | Próximo ]
toggle
Nikhil Sood
Liferay 6.1 - MySQL - Database connection could not be established.
19 de Setembro de 2012 00:58
Resposta

Nikhil Sood

Ranking: Junior Member

Mensagens: 41

Data de entrada: 12 de Agosto de 2009

Mensagens recentes

Hello,

I am trying to install Liferay 6.1 with MySQL 5.5.
1. I installed MySQL and set the root user with a valid password.
2. I checked my connection using the same password in the MySQL Workbench, and it is successful.
3. I successfully installed liferay 6.1.
4. In the basic configuration wizard, I selected MySQL and it defaulted the JDBC URL and JDBC Driver Class Name.
5. I entered the UserName and Password for MySQL.

No when I clicked on Finish Configuration button, I get the following error:

Database connection could not be established. Please check your connection settings.

Sceenshot is attached for reference. Appreciate any responses.

Thanks,
Nikhil
Anexo

Anexos: Database connection Error.jpg (167,7k)
Oliver Bayer
RE: Liferay 6.1 - MySQL - Database connection could not be established.
19 de Setembro de 2012 01:14
Resposta

Oliver Bayer

Ranking: Liferay Master

Mensagens: 883

Data de entrada: 18 de Fevereiro de 2009

Mensagens recentes

Hi Nikhil,

I'm not sure but shouldn't the jdbc url contains the port of your mysql instance? Otherwise check the tomcat console logs for a jdbc exception.

Greets Oli
Nikhil Sood
RE: Liferay 6.1 - MySQL - Database connection could not be established.
19 de Setembro de 2012 01:34
Resposta

Nikhil Sood

Ranking: Junior Member

Mensagens: 41

Data de entrada: 12 de Agosto de 2009

Mensagens recentes

Hi Oli,

Thanks for your response. I found my mistake. Basically you need to create a database schema in MySQL and then replace it with IPortal in the JDBC URL.

Cheers,
Nikhil
serafino sorleti
RE: Liferay 6.1 - MySQL - Database connection could not be established.
25 de Setembro de 2012 05:20
Resposta

serafino sorleti

Ranking: New Member

Mensagens: 1

Data de entrada: 25 de Setembro de 2012

Mensagens recentes

Nikhil Sood:
Hi Oli,

Thanks for your response. I found my mistake. Basically you need to create a database schema in MySQL and then replace it with IPortal in the JDBC URL.

Cheers,
Nikhil


Thanks a lot!!!
Jiechao Wu
RE: Liferay 6.1 - MySQL - Database connection could not be established.
12 de Setembro de 2013 01:47
Resposta

Jiechao Wu

Ranking: New Member

Mensagens: 1

Data de entrada: 12 de Setembro de 2013

Mensagens recentes

Hello,
I want to ask a question: after creating a database schema in MySQL, how to replace it with IPortal in the JDBC URL?
Thanks!

Cheers,
xiaodanding
Priyanka M
RE: Liferay 6.1 - MySQL - Database connection could not be established.
6 de Janeiro de 2014 23:46
Resposta

Priyanka M

Ranking: New Member

Mensagens: 7

Data de entrada: 26 de Setembro de 2011

Mensagens recentes

Hello Jiechu,

Am sure you already have an answer by now - but for the sake of others who might stumble on this post.
You need to replace the "lportal" in JDBC URL that appears in the box by default with the Schema name you just created.

Other option for ease is you could use the name lportal for the schema you create and then you dont need to make any changes. (Not a good thing though for production instances using default values)

Cheers,
Priyanka.