Issues regarding tomcat while running liferay

[kirankumar boyini，修改在12 年前。]

Hi,

I am new to life ray, while i am running life ray on tomcat, it is showing that server is not able to start due to previous. I try to resolve that error.But still it is

giving like that only.I do not know why it is giving like that. Please help me to resolve that error.


Please find the following attachment you can know more about this issue.



Thanks and regards

KiranKumar Boyini

[Pranay R Patadiya，修改在12 年前。]

Hi,
I have checked your logs, it says that you are not able to connect your database.
So, please check your database settings.

Thanks,
Pranay

[Mani kandan，修改在12 年前。]

Try to give something like this in portal-ext.properties,

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/yourdatabaseName?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=
jdbc.default.password=

hibernate.dialect=org.hibernate.dialect.MySQLDialect
custom.sql.function.isnull=IFNULL(?, '1') = '1'
custom.sql.function.isnotnull=IFNULL(?, '1') = '0'

[Ravi Kumar Gupta，修改在12 年前。]

and portal-ext.properties lies in tomcat/webapps/Root/WEB-INF/classes

[Hitoshi Ozawa，修改在12 年前。]

If you've created a portal-ext.properties file, rename it to something else. If you haven't, you're Liferay is probably corrupt.
Check if there was any error during file extraction.

[Julien Bonjean，修改在12 年前。]

Your portal-ext.properties seems to be loaded, check your connection url in the portal-ext.properties or in the context.xml if you use JNDI (and also be sure you mysql server is running ;-) )

[Hitoshi Ozawa，修改在12 年前。]

I just peeked at the error log. It seems like authentication error.

Be sure the user connecting to the database has the right to create tables. It's normal to just give them "all privileges" to liferay database on the iniital
liferay startup so liferay can create tables and then to change permission for security.