Mysql remote db problem for local set up of liferay 6.0 with linux OS ubunt

[Praveen P, modificado 10 Anos atrás.]

HI friends,
I am trying to set up local machine with Liferay 6.0 version using REMOTE MySQL DB, on linux OS, ubuntu. I am not able to trace out problem here, previously I worked with Windows. I am trying to connect with the DB which contains liferay tables and some other data, I am getting fallowing error, can anybody Help me????

05:34:57,434 ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: DELETE command denied to user 'root'@'db_ip_address' for table 'image'
com.liferay.portal.kernel.events.ActionException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: DELETE command denied to user 'root'@'db_ip_address' for table 'image'
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: DELETE command denied to user 'root'@'db_ip_address' for table 'image'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1355)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1270)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:231)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:198)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:185)
at com.liferay.portal.tools.DBUpgrader._deleteTempImages(DBUpgrader.java:186)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:128)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
... 29 more
Stopping the server due to unexpected startup errors

[Manish Yadav, modificado 10 Anos atrás.]

You are getting above error because you don't have delete permission from remote host.
Login as a root in mysql console and exucute below command

mysql&gt; GRANT ALL PRIVILEGES ON *.* TO '<username>'@'%'  WITH GRANT OPTION;
</username>

Thanks & Regards
Manish Banwari lal Yadav

[Praveen P, modificado 10 Anos atrás.]

Hi manish,
Thanks for your quick reply, My concern is if i grant all permission, then it deletes all data in IMAGE table, is it negative affect? How can i get back original data of Image table?

[Manish Yadav, modificado 10 Anos atrás.]

Praveen P:

Hi manish,
Thanks for your quick reply, My concern is if i grant all permission, then it deletes all data in IMAGE table, is it negative affect? How can i get back original data of Image table?

Sorry praveen i couldn't get you ,which image data you are trying to delete. Take DB backup before delete as precaution so you can get it back.

[Praveen P, modificado 10 Anos atrás.]

Ok, as per my R&D there is no other way, I have to give all permission for the DB. Let me try with that
Anyway thanks

[Praveen P, modificado 10 Anos atrás.]

I have given all permissions to the user, but now getting different problem as fallows.

ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLException: 'lportal.tablename' is not BASE TABLE
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLException: 'lportal.tablename' is not BASE TABLE
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLException: 'lportal.tablename' is not BASE TABLE
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:101)
at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:66)
at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:79)
at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:44)
at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:158)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:153)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
... 29 more
Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLException: 'lportal.tablename' is not BASE TABLE
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:89)
at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:25)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79)
... 36 more
Caused by: java.sql.SQLException: 'lportal.tablename' is not BASE TABLE
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at com.liferay.portal.verify.VerifyMySQL.alterTableEngine(VerifyMySQL.java:51)
at com.liferay.portal.verify.VerifyMySQL.doVerify(VerifyMySQL.java:83)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79)
... 39 more
Stopping the server due to unexpected startup errors

can anybody help?????

[Manish Yadav, modificado 10 Anos atrás.]

It seems your db has been corrupt.You can check with pointing to new DB

[Praveen P, modificado 10 Anos atrás.]

Sorry I forgot to mention that,

lportal.tablename

is VIEW not a TABLE. But liferay is throwing exception like, Its not a Base table, how to get rid of this??

[David H Nebinger, modificado 10 Anos atrás.]

liferay is not throwing this, mysql is throwing this. Since Liferay itself does not use views, I'm guessing that your DB got corrupted somewhere along the way. I'd start over with a fresh database, making sure you have the privs right before you start Liferay the first time...

[Praveen P, modificado 10 Anos atrás.]

Thanks David.
Can you please tel me how can I connect to remote DB which already contains some data, and tables(But not liferay tables). And one morething, i want to segregate liferay's defualt tables and my own other tables????

[Manish Yadav, modificado 10 Anos atrás.]

Praveen P:

Thanks David.
Can you please tel me how can I connect to remote DB which already contains some data, and tables(But not liferay tables). And one morething, i want to segregate liferay's defualt tables and my own other tables????

Hi Praveen,

1. You have to mention IP,Database schema name, username ,password of remote db in portal-ext.properties[If in your schema already table and data are available you have to take care of existing table names shouldn't not conflict with Liferay table names.Its recommend to create separate schema for LR otherwise if erroneously you delete table or data of LR DB then full db will corrupt ]
2. if you want to separate your custom portlet tables to liferay db schema.
you can achieve via configuration in
ext-spring.xml of portlet.
Check Below Post

http://ktnsavalia.blogspot.in/2012/09/connect-to-another-datasourcedatabase.html

Thanks & Regards
Manish Banwari lal Yadav

[Praveen P, modificado 10 Anos atrás.]

Thank you Manish.

[Ketan Savaliya, modificado 9 Anos atrás.]

Hi Manish/Praveen,

Thank you very much to refer my sharing knowledge from blog.
Hope it's help you and save your time.