Forums de discussion
Mysql remote db problem for local set up of liferay 6.0 with linux OS ubunt
Praveen P, modifié il y a 10 années.
Mysql remote db problem for local set up of liferay 6.0 with linux OS ubunt
Regular Member Publications: 100 Date d'inscription: 21/02/12 Publications récentes
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????
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, modifié il y a 10 années.
RE: Mysql remote db problem for local set up of liferay 6.0 with linux OS u
Expert Publications: 493 Date d'inscription: 26/05/12 Publications récentes
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
Thanks & Regards
Manish Banwari lal Yadav
Login as a root in mysql console and exucute below command
mysql> GRANT ALL PRIVILEGES ON *.* TO '<username>'@'%' WITH GRANT OPTION;
</username>
Thanks & Regards
Manish Banwari lal Yadav
Praveen P, modifié il y a 10 années.
RE: Mysql remote db problem for local set up of liferay 6.0 with linux OS u
Regular Member Publications: 100 Date d'inscription: 21/02/12 Publications récentes
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?
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, modifié il y a 10 années.
RE: Mysql remote db problem for local set up of liferay 6.0 with linux OS u
Expert Publications: 493 Date d'inscription: 26/05/12 Publications récentesPraveen 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, modifié il y a 10 années.
RE: Mysql remote db problem for local set up of liferay 6.0 with linux OS u
Regular Member Publications: 100 Date d'inscription: 21/02/12 Publications récentes
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
Anyway thanks
Praveen P, modifié il y a 10 années.
RE: Mysql remote db problem for local set up of liferay 6.0 with linux OS u
Regular Member Publications: 100 Date d'inscription: 21/02/12 Publications récentes
I have given all permissions to the user, but now getting different problem as fallows.
can anybody help?????
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, modifié il y a 10 années.
RE: Mysql remote db problem for local set up of liferay 6.0 with linux OS u
Expert Publications: 493 Date d'inscription: 26/05/12 Publications récentes
It seems your db has been corrupt.You can check with pointing to new DB
Praveen P, modifié il y a 10 années.
RE: Mysql remote db problem for local set up of liferay 6.0 with linux OS u
Regular Member Publications: 100 Date d'inscription: 21/02/12 Publications récentes
Sorry I forgot to mention that,
lportal.tablenameis VIEW not a TABLE. But liferay is throwing exception like, Its not a Base table, how to get rid of this??
David H Nebinger, modifié il y a 10 années.
RE: Mysql remote db problem for local set up of liferay 6.0 with linux OS u
Liferay Legend Publications: 14919 Date d'inscription: 02/09/06 Publications récentes
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, modifié il y a 10 années.
RE: Mysql remote db problem for local set up of liferay 6.0 with linux OS u
Regular Member Publications: 100 Date d'inscription: 21/02/12 Publications récentes
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????
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, modifié il y a 10 années.
RE: Mysql remote db problem for local set up of liferay 6.0 with linux OS u
Expert Publications: 493 Date d'inscription: 26/05/12 Publications récentesPraveen 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, modifié il y a 10 années.
RE: Mysql remote db problem for local set up of liferay 6.0 with linux OS u
Regular Member Publications: 100 Date d'inscription: 21/02/12 Publications récentes
Thank you Manish.
Ketan Savaliya, modifié il y a 9 années.
RE: Mysql remote db problem for local set up of liferay 6.0 with linux OS u
Regular Member Publications: 117 Date d'inscription: 03/03/11 Publications récentes
Hi Manish/Praveen,
Thank you very much to refer my sharing knowledge from blog.
Hope it's help you and save your time.
Thank you very much to refer my sharing knowledge from blog.
Hope it's help you and save your time.