Fórum
liferay ee and ce on Sql server 2008
Thas M, modificado 12 Anos atrás.
liferay ee and ce on Sql server 2008
New Member Postagens: 3 Data de Entrada: 22/03/12 Postagens Recentes
Hi All,
I am not able to get liferay working with sql server 2008. I was able to change the db to mysql part of the wizard and it's working.
But when I set up the db to be sql server , it connects to sql server and error out.
and I am getting the error msg: 'This instance is inactive. Please contact the administrator.'
here is the log:
93 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_46EEF3C8 on WikiPage (nodeId, parentTitle);
18:02:08,493 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_1ECC7656 on WikiPage (nodeId, redirectTitle);
18:02:08,509 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_546F2D5C on WikiPage (nodeId, status);
18:02:08,524 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_997EEDD2 on WikiPage (nodeId, title);
18:02:08,524 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_E745EA26 on WikiPage (nodeId, title, head);
18:02:08,540 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_BEA33AB8 on WikiPage (nodeId, title, status);
18:02:08,555 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create unique index IX_3D4AF476 on WikiPage (nodeId, title, version);
18:02:08,555 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_B771D67 on WikiPage (resourcePrimKey, nodeId);
18:02:08,571 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_94D1054D on WikiPage (resourcePrimKey, nodeId, status);
18:02:08,587 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create unique index IX_2CD67C81 on WikiPage (resourcePrimKey, nodeId, version);
18:02:08,587 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_FBBE7C96 on WikiPage (userId, nodeId, status);
18:02:08,602 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_9C0E478F on WikiPage (uuid_);
18:02:08,618 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create unique index IX_899D3DFB on WikiPage (uuid_, groupId);
18:02:08,618 WARN [BaseDB:382] Cannot find the object "WikiPageResource" because it does not exist or you do not have permissions.: create unique index IX_21277664 on WikiPageResource (nodeId, title);
18:02:08,634 WARN [BaseDB:382] Cannot find the object "WikiPageResource" because it does not exist or you do not have permissions.: create index IX_BE898221 on WikiPageResource (uuid_);
18:02:08,649 WARN [BaseDB:382] Cannot find the object "WorkflowDefinitionLink" because it does not exist or you do not have permissions.: create index IX_A8B0D276 on WorkflowDefinitionLink (companyId);
18:02:08,665 WARN [BaseDB:382] Cannot find the object "WorkflowDefinitionLink" because it does not exist or you do not have permissions.: create index IX_A4DB1F0F on WorkflowDefinitionLink (companyId, workflowDefinitionName, workflowDefinitionVersion);
18:02:08,665 WARN [BaseDB:382] Cannot find the object "WorkflowDefinitionLink" because it does not exist or you do not have permissions.: create index IX_B6EE8C9E on WorkflowDefinitionLink (groupId, companyId, classNameId);
18:02:08,680 WARN [BaseDB:382] Cannot find the object "WorkflowDefinitionLink" because it does not exist or you do not have permissions.: create index IX_1E5B9905 on WorkflowDefinitionLink (groupId, companyId, classNameId, classPK);
18:02:08,696 WARN [BaseDB:382] Cannot find the object "WorkflowDefinitionLink" because it does not exist or you do not have permissions.: create index IX_705B40EE on WorkflowDefinitionLink (groupId, companyId, classNameId, classPK, typePK);
18:02:08,696 WARN [BaseDB:382] Cannot find the object "WorkflowInstanceLink" because it does not exist or you do not have permissions.: create index IX_415A7007 on WorkflowInstanceLink (groupId, companyId, classNameId, classPK);
18:02:08,712 WARN [ReleaseLocalServiceImpl:281] Invalid object name 'Release_'.
18:02:08,727 WARN [ReleaseLocalServiceImpl:281] Invalid object name 'Release_'.
18:02:08,727 ERROR [MainServlet:201] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: Release_ table was not initialized properly
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: Release_ table was not initialized properly
at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1284)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:198)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:897)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:873)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1581)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.liferay.portal.kernel.exception.SystemException: Release_ table was not initialized properly
at com.liferay.portal.service.impl.ReleaseLocalServiceImpl.testSupportsStringCaseSensitiveQuery(ReleaseLocalServiceImpl.java:243)
at com.liferay.portal.service.impl.ReleaseLocalServiceImpl.getBuildNumberOrCreate(ReleaseLocalServiceImpl.java:154)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
at $Proxy73.getBuildNumberOrCreate(Unknown Source)
at com.liferay.portal.service.ReleaseLocalServiceUtil.getBuildNumberOrCreate(ReleaseLocalServiceUtil.java:273)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:86)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
... 20 more
I am not able to get liferay working with sql server 2008. I was able to change the db to mysql part of the wizard and it's working.
But when I set up the db to be sql server , it connects to sql server and error out.
and I am getting the error msg: 'This instance is inactive. Please contact the administrator.'
here is the log:
93 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_46EEF3C8 on WikiPage (nodeId, parentTitle);
18:02:08,493 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_1ECC7656 on WikiPage (nodeId, redirectTitle);
18:02:08,509 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_546F2D5C on WikiPage (nodeId, status);
18:02:08,524 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_997EEDD2 on WikiPage (nodeId, title);
18:02:08,524 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_E745EA26 on WikiPage (nodeId, title, head);
18:02:08,540 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_BEA33AB8 on WikiPage (nodeId, title, status);
18:02:08,555 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create unique index IX_3D4AF476 on WikiPage (nodeId, title, version);
18:02:08,555 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_B771D67 on WikiPage (resourcePrimKey, nodeId);
18:02:08,571 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_94D1054D on WikiPage (resourcePrimKey, nodeId, status);
18:02:08,587 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create unique index IX_2CD67C81 on WikiPage (resourcePrimKey, nodeId, version);
18:02:08,587 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_FBBE7C96 on WikiPage (userId, nodeId, status);
18:02:08,602 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create index IX_9C0E478F on WikiPage (uuid_);
18:02:08,618 WARN [BaseDB:382] Cannot find the object "WikiPage" because it does not exist or you do not have permissions.: create unique index IX_899D3DFB on WikiPage (uuid_, groupId);
18:02:08,618 WARN [BaseDB:382] Cannot find the object "WikiPageResource" because it does not exist or you do not have permissions.: create unique index IX_21277664 on WikiPageResource (nodeId, title);
18:02:08,634 WARN [BaseDB:382] Cannot find the object "WikiPageResource" because it does not exist or you do not have permissions.: create index IX_BE898221 on WikiPageResource (uuid_);
18:02:08,649 WARN [BaseDB:382] Cannot find the object "WorkflowDefinitionLink" because it does not exist or you do not have permissions.: create index IX_A8B0D276 on WorkflowDefinitionLink (companyId);
18:02:08,665 WARN [BaseDB:382] Cannot find the object "WorkflowDefinitionLink" because it does not exist or you do not have permissions.: create index IX_A4DB1F0F on WorkflowDefinitionLink (companyId, workflowDefinitionName, workflowDefinitionVersion);
18:02:08,665 WARN [BaseDB:382] Cannot find the object "WorkflowDefinitionLink" because it does not exist or you do not have permissions.: create index IX_B6EE8C9E on WorkflowDefinitionLink (groupId, companyId, classNameId);
18:02:08,680 WARN [BaseDB:382] Cannot find the object "WorkflowDefinitionLink" because it does not exist or you do not have permissions.: create index IX_1E5B9905 on WorkflowDefinitionLink (groupId, companyId, classNameId, classPK);
18:02:08,696 WARN [BaseDB:382] Cannot find the object "WorkflowDefinitionLink" because it does not exist or you do not have permissions.: create index IX_705B40EE on WorkflowDefinitionLink (groupId, companyId, classNameId, classPK, typePK);
18:02:08,696 WARN [BaseDB:382] Cannot find the object "WorkflowInstanceLink" because it does not exist or you do not have permissions.: create index IX_415A7007 on WorkflowInstanceLink (groupId, companyId, classNameId, classPK);
18:02:08,712 WARN [ReleaseLocalServiceImpl:281] Invalid object name 'Release_'.
18:02:08,727 WARN [ReleaseLocalServiceImpl:281] Invalid object name 'Release_'.
18:02:08,727 ERROR [MainServlet:201] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: Release_ table was not initialized properly
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: Release_ table was not initialized properly
at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1284)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:198)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:897)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:873)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1581)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.liferay.portal.kernel.exception.SystemException: Release_ table was not initialized properly
at com.liferay.portal.service.impl.ReleaseLocalServiceImpl.testSupportsStringCaseSensitiveQuery(ReleaseLocalServiceImpl.java:243)
at com.liferay.portal.service.impl.ReleaseLocalServiceImpl.getBuildNumberOrCreate(ReleaseLocalServiceImpl.java:154)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
at $Proxy73.getBuildNumberOrCreate(Unknown Source)
at com.liferay.portal.service.ReleaseLocalServiceUtil.getBuildNumberOrCreate(ReleaseLocalServiceUtil.java:273)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:86)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
... 20 more
David H Nebinger, modificado 12 Anos atrás.
RE: liferay ee and ce on Sql server 2008
Liferay Legend Postagens: 14916 Data de Entrada: 02/09/06 Postagens Recentes
Which driver are you using? I've had success w/ the jtds driver...
Can you also provide the URL info?
Can you also provide the URL info?
David H Nebinger, modificado 12 Anos atrás.
RE: liferay ee and ce on Sql server 2008
Liferay Legend Postagens: 14916 Data de Entrada: 02/09/06 Postagens Recentes
Just saw the other post where you're using jtds and the url..
Anyways I'd guess that the 'user' credentials you're using do not have DBA access to the database. Liferay will create tables, indices, etc. when it starts and therefore needs a lot more privileges than just the select/insert/update/delete of a normal user.
Give the user the elevated credentials and you should be fine.
Anyways I'd guess that the 'user' credentials you're using do not have DBA access to the database. Liferay will create tables, indices, etc. when it starts and therefore needs a lot more privileges than just the select/insert/update/delete of a normal user.
Give the user the elevated credentials and you should be fine.