Vista combinada Visión Plana Vista de árbol
Discusiones [ Anterior | Siguiente ]
toggle
Nikhil Sood
Liferay 6.1 - MySQL - Database connection could not be established.
19 de septiembre de 2012 0:58
Respuesta

Nikhil Sood

Ranking: Junior Member

Mensajes: 41

Fecha de incorporación: 12 de agosto de 2009

Mensajes recientes

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
Adjunto

archivos adjuntos: Database connection Error.jpg (167,7k)
Oliver Bayer
RE: Liferay 6.1 - MySQL - Database connection could not be established.
19 de septiembre de 2012 1:14
Respuesta

Oliver Bayer

Ranking: Liferay Master

Mensajes: 887

Fecha de incorporación: 18 de febrero de 2009

Mensajes recientes

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 septiembre de 2012 1:34
Respuesta

Nikhil Sood

Ranking: Junior Member

Mensajes: 41

Fecha de incorporación: 12 de agosto de 2009

Mensajes recientes

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 septiembre de 2012 5:20
Respuesta

serafino sorleti

Ranking: New Member

Mensajes: 1

Fecha de incorporación: 25 de septiembre de 2012

Mensajes recientes

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 septiembre de 2013 1:47
Respuesta

Jiechao Wu

Ranking: New Member

Mensajes: 1

Fecha de incorporación: 12 de septiembre de 2013

Mensajes recientes

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 enero de 2014 23:46
Respuesta

Priyanka M

Ranking: New Member

Mensajes: 7

Fecha de incorporación: 26 de septiembre de 2011

Mensajes recientes

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.