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

[10年前 に Praveen P によって更新されました。]

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

[10年前 に Manish Yadav によって更新されました。]

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

[10年前 に 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?

[10年前 に Manish Yadav によって更新されました。]

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.

[10年前 に Praveen P によって更新されました。]

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

[10年前 に Praveen P によって更新されました。]

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?????

[10年前 に Manish Yadav によって更新されました。]

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

[10年前 に Praveen P によって更新されました。]

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??

[10年前 に David H Nebinger によって更新されました。]

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...

[10年前 に 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????

[10年前 に Manish Yadav によって更新されました。]

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

[10年前 に Praveen P によって更新されました。]

Thank you Manish.

[9年前 に Ketan Savaliya によって更新されました。]

Hi Manish/Praveen,

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