Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Jatin Rathod
MSql Installation issue "error in connection setting
April 9, 2013 11:42 PM
Answer

Jatin Rathod

Rank: New Member

Posts: 4

Join Date: April 9, 2013

Recent Posts

Dear Team,

I have downloaded liferay-portal-6.1.1-ce-ga2 and i m trying to install it on my local system which is running on windows xp. I have followed installation steps which are provided on liferay site.

After running startup.bat file the default web page get open but when i am changing the database configuration to mysql it is showing database "Connection Setting Error, Error in connection to database."

I have added file portal-ext.properties in described path "C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27\webapps\ROOT\WEB-INF\classes" along with the JDBC driver setting for Mysql which is described in portal properties.

I have attached my portal-ext.properties file along with post.

Since I am newbie to JAVA and APACHE technology i am not getting what further steps i need to perform to get the mysql database up and running.
Attachments: portal-ext.properties (0.2k)
Abhishak Kumar Mishra
RE: MSql Installation issue "error in connection setting
April 9, 2013 11:51 PM
Answer

Abhishak Kumar Mishra

Rank: Junior Member

Posts: 29

Join Date: February 28, 2012

Recent Posts

Hi,

Please check following:

1) Database username and password is empty/blank. Verify using command "mysql -u -p"
2) You have created schema "lportal".
Manish Yadav
RE: MSql Installation issue "error in connection setting
April 9, 2013 11:57 PM
Answer

Manish Yadav

Rank: Expert

Posts: 449

Join Date: May 26, 2012

Recent Posts

Hi Jatin,
your username and password is missing in portal-ext.properties


if it won't work then check below points

1. First Check your mysql is running and lportal [with correct username and password]
2. check mysql.jar should available in tomcat/lib folder
Jatin Rathod
RE: MSql Installation issue "error in connection setting
April 10, 2013 12:01 AM
Answer

Jatin Rathod

Rank: New Member

Posts: 4

Join Date: April 9, 2013

Recent Posts

Hi Abhi,

I have used password also in portal-ext.properties but still it is showing the same error.

Regarding creation of schema I have not created any schema after unzip and startup.bat running. I have kept the default configuration just added portal-ext.properties file in ROOT along with JDBC driver setting which is mentioned in portal properties.

Will you please help me out in creation of Schema "Iportal"?

Thanks..!!
Jatin Rathod
RE: MSql Installation issue "error in connection setting
April 10, 2013 12:05 AM
Answer

Jatin Rathod

Rank: New Member

Posts: 4

Join Date: April 9, 2013

Recent Posts

Hi Manish,

I have added username and password in portal-ext.properties file but still it is showing the same error.

Since I am new to this Mysql language please help me out How can I check whether mysql is running or not??.

Also mysql.jar file is present at this directory in my local pc "C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27\lib\ext\mysql.jar"

Thanks...!!
Abhishak Kumar Mishra
RE: MSql Installation issue "error in connection setting
April 10, 2013 12:27 AM
Answer

Abhishak Kumar Mishra

Rank: Junior Member

Posts: 29

Join Date: February 28, 2012

Recent Posts

Jatin Rathod:
Hi Abhi,

I have used password also in portal-ext.properties but still it is showing the same error.

Regarding creation of schema I have not created any schema after unzip and startup.bat running. I have kept the default configuration just added portal-ext.properties file in ROOT along with JDBC driver setting which is mentioned in portal properties.

Will you please help me out in creation of Schema "Iportal"?

Thanks..!!



Hi Jatin,

Sorry to mention schema. I mean to say database named :lportal"
To create database:
Login into mysql and run "create database lportal"


Thanks
Vaibhav Rahul Tayde
RE: MSql Installation issue "error in connection setting
April 10, 2013 12:34 AM
Answer

Vaibhav Rahul Tayde

Rank: New Member

Posts: 7

Join Date: February 21, 2011

Recent Posts

Dear Jatin,

I believe you must have read following Official Wiki:-

http://www.liferay.com/community/wiki/-/wiki/Main/Database+Configuration

However, ensure that the steps mentioned in this Article have properly been followed.
Jatin Rathod
RE: MSql Installation issue "error in connection setting
April 10, 2013 2:13 AM
Answer

Jatin Rathod

Rank: New Member

Posts: 4

Join Date: April 9, 2013

Recent Posts

Dear ALL,

I have created database lportal in mysql. kindly find attached copy of screenshot of the same. but still i am getting error while doing final configuration. I am attached screenshot of error also.

Please help me out in further configuration. I have followed entire steps from database-configuration.

Thanks...!!
Attachments: error.bmp (3,075.1k), mysql.bmp (3,075.1k)
Abhishak Kumar Mishra
RE: MSql Installation issue "error in connection setting
April 10, 2013 2:43 AM
Answer

Abhishak Kumar Mishra

Rank: Junior Member

Posts: 29

Join Date: February 28, 2012

Recent Posts

Jatin Rathod:
Dear ALL,

I have created database lportal in mysql. kindly find attached copy of screenshot of the same. but still i am getting error while doing final configuration. I am attached screenshot of error also.

Please help me out in further configuration. I have followed entire steps from database-configuration.

Thanks...!!


Jatin,
In screenshot, you have created user 'lportal'. User 'lportal' has all privileges (admin user) . If not, please run

create user 'lportal'@'localhost' identified by 'password';
grant all privileges on lportal.* to 'password';
flush privileges;

please check username and password in portal-ext.properties.

If everything is correct, please share the error log (error on console).

Thanks
Manish Yadav
RE: MSql Installation issue "error in connection setting
April 10, 2013 11:34 AM
Answer

Manish Yadav

Rank: Expert

Posts: 449

Join Date: May 26, 2012

Recent Posts

could you please attach your server log file