cancel
Showing results for 
Search instead for 
Did you mean: 

Trouble with Nuxeo 5.5 and MSSQL

WesLowe_
Champ on-the-rise
Champ on-the-rise

I've installed nuxeo 5.5 and it works fine with it's own database. I've reinstalled it but pointed to an MS SQL Express database on a named instance. I've reference the named instance by doing nuxeo.db.name=nuxeo;instance=SQLEXPRESS and this seems to have worked because it's populated the database with data.

When I come to log in I get redirected to this url:

http://localhost:8080/nuxeo/nxstartup.faces?conversationId=0 NXMAIN19

Which then seems to go in to an infinite loop and I get this error:

The page isn't redirecting properly

Firefox has detected that the server is redirecting the request for this address in a way that will never complete.

  • This problem can sometimes be caused by disabling or refusing to accept cookies.

Any ideas would be greatly appreciated. Below is the server log file.

*Server log content.

2012-02-17 15:14:55,014 WARN [org.nuxeo.runtime.deployment.preprocessor.DeploymentPreproc essor] Entering compatibility mode - Please update the deployment-fragment.xml in nuxeo-platform-login-digest-5.5.jar to use new dependency management
2012-02-17 15:14:55,092 WARN [org.nuxeo.runtime.deployment.preprocessor.DeploymentPreproc essor] Entering compatibility mode - Please update the deployment-fragment.xml in nuxeo-platform-wi-backend-5.5.jar to use new dependency management
2012-02-17 15:14:55,123 WARN [org.nuxeo.runtime.deployment.preprocessor.DeploymentPreproc essor] Entering compatibility mode - Please update the deployment-fragment.xml in nuxeo-webdav-5.5.jar to use new dependency management
2012-02-17 15:15:02,967 INFO [org.nuxeo.osgi.application.loader.FrameworkLoader]
    ============================================================ ==========
    = Starting Nuxeo Framework
    ============================================================ ==========
    * Server home = C:\Program Files\Nuxeo
    * Runtime home = C:\Program Files\Nuxeo\nxserver
    * Data Directory = C:\Documents and Settings\All Users\Application Data\Nuxeo\data
    * Log Directory = C:\Documents and Settings\All Users\Application Data\Nuxeo\logs
    * Configuration Directory = C:\Program Files\Nuxeo\nxserver\config
    * Temp Directory = C:\Documents and Settings\All Users\Application Data\Nuxeo\tmp
    ============================================================ ==========
2012-02-17 15:15:03,139 INFO [org.nuxeo.runtime.osgi.OSGiRuntimeService] Configuration: host application: Tomcat
2012-02-17 15:15:05,467 WARN [org.nuxeo.ecm.platform.commandline.executor.service.Command LineExecutorComponent] Command not available: wpd2text (command wpd2text not found in system path. You need to install wpd2text (deb: libwpd-tools) http://libwpd.sourceforge.net/download.html)
2012-02-17 15:15:06,061 WARN [org.nuxeo.ecm.platform.commandline.executor.service.Command LineExecutorComponent] Command not available: identify (command identify not found in system path. You need to install ImageMagic.)
2012-02-17 15:15:06,061 WARN [org.nuxeo.ecm.platform.commandline.executor.service.Command LineExecutorComponent] Command not available: crop (command stream not found in system path. You need to install ImageMagic.)
2012-02-17 15:15:06,061 WARN [org.nuxeo.ecm.platform.commandline.executor.service.Command LineExecutorComponent] Command not available: cropAndResize (command stream not found in system path. You need to install ImageMagic.)
2012-02-17 15:15:06,936 INFO [org.quartz.simpl.SimpleThreadPool] Job execution threads will use class loader of thread: main
2012-02-17 15:15:06,967 INFO [org.quartz.core.SchedulerSignalerImpl] Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
2012-02-17 15:15:06,967 INFO [org.quartz.core.QuartzScheduler] Quartz Scheduler v.1.6.3 created.
2012-02-17 15:15:07,186 INFO [org.quartz.simpl.RAMJobStore] RAMJobStore initialized.
2012-02-17 15:15:07,186 INFO [org.quartz.impl.StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
2012-02-17 15:15:07,186 INFO [org.quartz.impl.StdSchedulerFactory] Quartz scheduler version: 1.6.3
2012-02-17 15:15:07,186 INFO [org.quartz.core.QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
2012-02-17 15:15:07,233 WARN [org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelS ervice] Query models are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the query model 'DEFAULT_CREATION_CONTAINER_LIST_PROVIDER' should be upgraded to use content views
2012-02-17 15:15:07,233 WARN [org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelS ervice] Query models are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the query model 'CURRENT_PICTUREBOOK_CHILDREN' should be upgraded to use content views
2012-02-17 15:15:07,279 WARN [org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelS ervice] Query models are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the query model 'SIMPLE_SEARCH_PATH' should be upgraded to use content views
2012-02-17 15:15:07,279 WARN [org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelS ervice] Query models are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the query model 'RELEVANT_DOCUMENTS' should be upgraded to use content views
2012-02-17 15:15:07,608 INFO [org.nuxeo.ecm.platform.ui.web.auth.plugins.WebServicesAuthe nticator] WebServices Authentication filter configured - webservices/
2012-02-17 15:15:07,686 WARN [org.nuxeo.ecm.webapp.pagination.ResultsProviderService] Result providers are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the result provider 'CURRENT_PICTUREBOOK_CHILDREN' should be upgraded to use content views
2012-02-17 15:15:07,779 WARN [org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelS ervice] Query models are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the query model 'CURRENT_DOC_CHILDREN' should be upgraded to use content views
2012-02-17 15:15:07,779 WARN [org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelS ervice] Query models are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the query model 'CURRENT_DOC_DELETED_CHILDREN' should be upgraded to use content views
2012-02-17 15:15:07,779 WARN [org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelS ervice] Query models are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the query model 'CURRENT_DOC_ORDERED_CHILDREN' should be upgraded to use content views
2012-02-17 15:15:07,779 WARN [org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelS ervice] Query models are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the query model 'TREE_CHILDREN' should be upgraded to use content views
2012-02-17 15:15:07,779 WARN [org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelS ervice] Query models are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the query model 'TREE_ORDERED_CHILDREN' should be upgraded to use content views
2012-02-17 15:15:07,779 WARN [org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelS ervice] Query models are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the query model 'SIMPLE_SEARCH' should be upgraded to use content views
2012-02-17 15:15:07,779 WARN [org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelS ervice] Query models are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the query model 'ADVANCED_SEARCH' should be upgraded to use content views
2012-02-17 15:15:07,795 WARN [org.nuxeo.ecm.webapp.pagination.ResultsProviderService] Result providers are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the result provider 'SIMPLE_SEARCH' should be upgraded to use content views
2012-02-17 15:15:07,795 WARN [org.nuxeo.ecm.webapp.pagination.ResultsProviderService] Result providers are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the result provider 'ADVANCED_SEARCH' should be upgraded to use content views
2012-02-17 15:15:07,795 WARN [org.nuxeo.ecm.webapp.pagination.ResultsProviderService] Result providers are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the result provider 'CURRENT_DOC_CHILDREN' should be upgraded to use content views
2012-02-17 15:15:07,795 WARN [org.nuxeo.ecm.webapp.pagination.ResultsProviderService] Result providers are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the result provider 'CURRENT_DOC_ORDERED_CHILDREN' should be upgraded to use content views
2012-02-17 15:15:07,795 WARN [org.nuxeo.ecm.webapp.pagination.ResultsProviderService] Result providers are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the result provider 'CURRENT_DOC_DELETED_CHILDREN' should be upgraded to use content views
2012-02-17 15:15:07,795 WARN [org.nuxeo.ecm.webapp.pagination.ResultsProviderService] Result providers are deprecated as of Nuxeo 5.4 and will be removed for Nuxeo 5.6: the result provider 'SEARCH_BEAN_NXQL_PROVIDER' should be upgraded to use content views
2012-02-17 15:15:11,326 INFO [org.jbpm.persistence.db.StaleObjectLogConfigurer] stale object exceptions will be hidden from logging
2012-02-17 15:15:11,326 INFO [org.jbpm.JbpmConfiguration] using jbpm configuration resource 'jbpm.cfg.xml'
2012-02-17 15:15:17,311 ERROR [org.apache.geronimo.connector.outbound.MCFConnectionInterce ptor] Error occurred creating ManagedConnection for org.apache.geronimo.connector.outbound.ConnectionInfo@989cab
    org.nuxeo.ecm.core.storage.StorageException: java.sql.SQLException: Network error IOException: Connection refused: connect
    at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCBackend.initializeMo delSetup(JDBCBackend.java:130)
    at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.getConnection( RepositoryImpl.java:342)
    at org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionFactoryIm pl.getConnection(ManagedConnectionFactoryImpl.java:313)
    at org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionImpl.<init >(ManagedConnectionImpl.java:104)
    at org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionFactoryIm pl.createManagedConnection(ManagedConnectionFactoryImpl.java :191)
    at org.apache.geronimo.connector.outbound.MCFConnectionIntercep tor.getConnection(MCFConnectionInterceptor.java:49)
    at org.apache.geronimo.connector.outbound.XAResourceInsertionIn terceptor.getConnection(XAResourceInsertionInterceptor.java: 41)
    at org.apache.geronimo.connector.outbound.SinglePoolMatchAllCon nectionInterceptor.internalGetConnection(SinglePoolMatchAllC onnectionInterceptor.java:87)
    at org.apache.geronimo.connector.outbound.AbstractSinglePoolCon nectionInterceptor.getConnection(AbstractSinglePoolConnectio nInterceptor.java:80)
    at org.apache.geronimo.connector.outbound.MultiPoolConnectionIn terceptor.getConnection(MultiPoolConnectionInterceptor.java: 81)
    at org.apache.geronimo.connector.outbound.ThreadLocalCachingCon nectionInterceptor.getConnection(ThreadLocalCachingConnectio nInterceptor.java:70)
    at org.apache.geronimo.connector.outbound.TransactionEnlistingI nterceptor.getConnection(TransactionEnlistingInterceptor.jav a:46)
    at org.apache.geronimo.connector.outbound.TransactionCachingInt erceptor.getConnection(TransactionCachingInterceptor.java:95 )
    at org.apache.geronimo.connector.outbound.SubjectInterceptor.ge tConnection(SubjectInterceptor.java:58)
    at org.apache.geronimo.connector.outbound.ConnectionHandleInter ceptor.getConnection(ConnectionHandleInterceptor.java:43)
    at org.apache.geronimo.connector.outbound.TCCLInterceptor.getCo nnection(TCCLInterceptor.java:39)
    at org.apache.geronimo.connector.outbound.ConnectionTrackingInt erceptor.getConnection(ConnectionTrackingInterceptor.java:66 )
    at org.apache.geronimo.connector.outbound.AbstractConnectionMan ager.allocateConnection(AbstractConnectionManager.java:87)
    at org.nuxeo.runtime.jtajca.NuxeoContainer$ConnectionManagerWra pper.allocateConnection(NuxeoContainer.java:447)
    at org.nuxeo.ecm.core.storage.sql.ra.ConnectionFactoryImpl.getC onnection(ConnectionFactoryImpl.java:161)
    at org.nuxeo.ecm.core.storage.sql.ra.ConnectionFactoryImpl.getS ession(ConnectionFactoryImpl.java:236)
    at org.nuxeo.ecm.core.api.local.LocalSession.createSession(Loca lSession.java:104)
    at org.nuxeo.ecm.core.api.local.LocalSession.getSession(LocalSe ssion.java:171)
    at org.nuxeo.ecm.core.api.AbstractSession.connect(AbstractSessi on.java:218)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.nuxeo.ecm.core.api.TransactionalCoreSessionWrapper.invok e(TransactionalCoreSessionWrapper.java:129)
    at $Proxy28.connect(Unknown Source)
    at org.nuxeo.ecm.core.api.repository.Repository.open(Repository .java:155)
    at org.nuxeo.ecm.core.api.repository.Repository.open(Repository .java:113)
    at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestri cted(UnrestrictedSessionRunner.java:140)
    at org.nuxeo.ecm.platform.publisher.impl.service.DomainsFinder. getDomains(DomainsFinder.java:61)
    at org.nuxeo.ecm.platform.publisher.impl.service.PublisherServi ceImpl.registerPendingDescriptors(PublisherServiceImpl.java: 678)
    at org.nuxeo.ecm.platform.publisher.impl.service.PublisherServi ceImpl.doApplicationStarted(PublisherServiceImpl.java:110)
    at org.nuxeo.ecm.platform.publisher.impl.service.PublisherServi ceImpl.applicationStarted(PublisherServiceImpl.java:93)
    at org.nuxeo.runtime.model.impl.RegistrationInfoImpl.notifyAppl icationStarted(RegistrationInfoImpl.java:309)
    at org.nuxeo.runtime.osgi.OSGiRuntimeService.notifyComponentsOn Started(OSGiRuntimeService.java:467)
    at org.nuxeo.runtime.osgi.OSGiRuntimeService.fireApplicationSta rted(OSGiRuntimeService.java:492)
    at org.nuxeo.runtime.osgi.OSGiRuntimeService.frameworkEvent(OSG iRuntimeService.java:502)
    at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.ja va:231)
    at org.nuxeo.osgi.application.loader.FrameworkLoader.doStart(Fr ameworkLoader.java:195)
    at org.nuxeo.osgi.application.loader.FrameworkLoader.start(Fram eworkLoader.java:123)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.nuxeo.osgi.application.FrameworkBootstrap.start(Framewor kBootstrap.java:135)
    at org.nuxeo.runtime.tomcat.NuxeoLauncher.handleEvent(NuxeoLaun cher.java:117)
    at org.nuxeo.runtime.tomcat.NuxeoLauncher.lifecycleEvent(NuxeoL auncher.java:88)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent (LifecycleSupport.java:119)
    at org.apache.catalina.core.StandardContext.start(StandardConte xt.java:4424)
    at org.apache.catalina.core.ContainerBase.addChildInternal(Cont ainerBase.java:791)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBas e.java:771)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost. java:526)
    at org.apache.catalina.startup.HostConfig.deployDescriptor(Host Config.java:630)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(Hos tConfig.java:556)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig .java:491)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java :1206)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostCo nfig.java:314)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent (LifecycleSupport.java:119)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.j ava:1053)
    at org.apache.catalina.core.StandardHost.start(StandardHost.jav a:722)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.j ava:1045)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine .java:443)
    at org.apache.catalina.core.StandardService.start(StandardServi ce.java:516)
    at org.apache.catalina.core.StandardServer.start(StandardServer .java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:583 )
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:2 88)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:41 3)
    Caused by: java.sql.SQLException: Network error IOException: Connection refused: connect
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:395)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
    at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(Jtds DataSource.java:188)
    at net.sourceforge.jtds.jdbcx.JtdsDataSource.getXAConnection(Jt dsDataSource.java:116)
    at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCBackend.initializeMo delSetup(JDBCBackend.java:116)
    ... 74 more
    Caused by: java.net.ConnectException: Connection refused: connect
    at java.net.TwoStacksPlainSocketImpl.socketConnect(Native Method)
    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSock etImpl.java:337)
    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPl ainSocketImpl.java:198)
    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocket Impl.java:180)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
    at java.net.Socket.connect(Socket.java:579)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3( SharedSocket.java:305)
    at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:323)
    ... 79 more
2012-02-17 15:15:17,311 ERROR [org.nuxeo.ecm.platform.publisher.impl.service.PublisherServ iceImpl] Unable to register pending descriptors
    org.nuxeo.ecm.core.api.ClientException: Failed to load repository default
    at org.nuxeo.ecm.core.api.local.LocalSession.createSession(Loca lSession.java:106)
    at org.nuxeo.ecm.core.api.local.LocalSession.getSession(LocalSe ssion.java:171)
    at org.nuxeo.ecm.core.api.AbstractSession.connect(AbstractSessi on.java:218)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.nuxeo.ecm.core.api.TransactionalCoreSessionWrapper.invok e(TransactionalCoreSessionWrapper.java:129)
    at $Proxy28.connect(Unknown Source)
    at org.nuxeo.ecm.core.api.repository.Repository.open(Repository .java:155)
    at org.nuxeo.ecm.core.api.repository.Repository.open(Repository .java:113)
    at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestri cted(UnrestrictedSessionRunner.java:140)
    at org.nuxeo.ecm.platform.publisher.impl.service.DomainsFinder. getDomains(DomainsFinder.java:61)
    at org.nuxeo.ecm.platform.publisher.impl.service.PublisherServi ceImpl.registerPendingDescriptors(PublisherServiceImpl.java: 678)
    at org.nuxeo.ecm.platform.publisher.impl.service.PublisherServi ceImpl.doApplicationStarted(PublisherServiceImpl.java:110)
    at org.nuxeo.ecm.platform.publisher.impl.service.PublisherServi ceImpl.applicationStarted(PublisherServiceImpl.java:93)
    at org.nuxeo.runtime.model.impl.RegistrationInfoImpl.notifyAppl icationStarted(RegistrationInfoImpl.java:309)
    at org.nuxeo.runtime.osgi.OSGiRuntimeService.notifyComponentsOn Started(OSGiRuntimeService.java:467)
    at org.nuxeo.runtime.osgi.OSGiRuntimeService.fireApplicationSta rted(OSGiRuntimeService.java:492)
    at org.nuxeo.runtime.osgi.OSGiRuntimeService.frameworkEvent(OSG iRuntimeService.java:502)
    at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.ja va:231)
    at org.nuxeo.osgi.application.loader.FrameworkLoader.doStart(Fr ameworkLoader.java:195)
    at org.nuxeo.osgi.application.loader.FrameworkLoader.start(Fram eworkLoader.java:123)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.nuxeo.osgi.application.FrameworkBootstrap.start(Framewor kBootstrap.java:135)
    at org.nuxeo.runtime.tomcat.NuxeoLauncher.handleEvent(NuxeoLaun cher.java:117)
    at org.nuxeo.runtime.tomcat.NuxeoLauncher.lifecycleEvent(NuxeoL auncher.java:88)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent (LifecycleSupport.java:119)
    at org.apache.catalina.core.StandardContext.start(StandardConte xt.java:4424)
    at org.apache.catalina.core.ContainerBase.addChildInternal(Cont ainerBase.java:791)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBas e.java:771)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost. java:526)
    at org.apache.catalina.startup.HostConfig.deployDescriptor(Host Config.java:630)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(Hos tConfig.java:556)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig .java:491)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java :1206)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostCo nfig.java:314)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent (LifecycleSupport.java:119)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.j ava:1053)
    at org.apache.catalina.core.StandardHost.start(StandardHost.jav a:722)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.j ava:1045)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine .java:443)
    at org.apache.catalina.core.StandardService.start(StandardServi ce.java:516)
    at org.apache.catalina.core.StandardServer.start(StandardServer .java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:583 )
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:2 88)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:41 3)
    Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.api.DocumentException. message: org.nuxeo.ecm.core.storage.StorageException: java.sql.SQLException: Network error IOException: Connection refused: connect
    at org.nuxeo.ecm.core.storage.sql.ra.ConnectionFactoryImpl.getS ession(ConnectionFactoryImpl.java:238)
    at org.nuxeo.ecm.core.api.local.LocalSession.createSession(Loca lSession.java:104)
    ... 53 more
    Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.storage.StorageException. message: java.sql.SQLException: Network error IOException: Connection refused: connect
    at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCBackend.initializeMo delSetup(JDBCBackend.java:130)
    at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.getConnection( RepositoryImpl.java:342)
    at org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionFactoryIm pl.getConnection(ManagedConnectionFactoryImpl.java:313)
    at org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionImpl.<init >(ManagedConnectionImpl.java:104)
    at org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionFactoryIm pl.createManagedConnection(ManagedConnectionFactoryImpl.java :191)
    at org.apache.geronimo.connector.outbound.MCFConnectionIntercep tor.getConnection(MCFConnectionInterceptor.java:49)
    at org.apache.geronimo.connector.outbound.XAResourceInsertionIn terceptor.getConnection(XAResourceInsertionInterceptor.java: 41)
    at org.apache.geronimo.connector.outbound.SinglePoolMatchAllCon nectionInterceptor.internalGetConnection(SinglePoolMatchAllC onnectionInterceptor.java:87)
    at org.apache.geronimo.connector.outbound.AbstractSinglePoolCon nectionInterceptor.getConnection(AbstractSinglePoolConnectio nInterceptor.java:80)
    at org.apache.geronimo.connector.outbound.MultiPoolConnectionIn terceptor.getConnection(MultiPoolConnectionInterceptor.java: 81)
    at org.apache.geronimo.connector.outbound.ThreadLocalCachingCon nectionInterceptor.getConnection(ThreadLocalCachingConnectio nInterceptor.java:70)
    at org.apache.geronimo.connector.outbound.TransactionEnlistingI nterceptor.getConnection(TransactionEnlistingInterceptor.jav a:46)
    at org.apache.geronimo.connector.outbound.TransactionCachingInt erceptor.getConnection(TransactionCachingInterceptor.java:95 )
    at org.apache.geronimo.connector.outbound.SubjectInterceptor.ge tConnection(SubjectInterceptor.java:58)
    at org.apache.geronimo.connector.outbound.ConnectionHandleInter ceptor.getConnection(ConnectionHandleInterceptor.java:43)
    at org.apache.geronimo.connector.outbound.TCCLInterceptor.getCo nnection(TCCLInterceptor.java:39)
    at org.apache.geronimo.connector.outbound.ConnectionTrackingInt erceptor.getConnection(ConnectionTrackingInterceptor.java:66 )
    at org.apache.geronimo.connector.outbound.AbstractConnectionMan ager.allocateConnection(AbstractConnectionManager.java:87)
    at org.nuxeo.runtime.jtajca.NuxeoContainer$ConnectionManagerWra pper.allocateConnection(NuxeoContainer.java:447)
    at org.nuxeo.ecm.core.storage.sql.ra.ConnectionFactoryImpl.getC onnection(ConnectionFactoryImpl.java:161)
    at org.nuxeo.ecm.core.storage.sql.ra.ConnectionFactoryImpl.getS ession(ConnectionFactoryImpl.java:236)
    ... 54 more
    Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: java.sql.SQLException. message: Network error IOException: Connection refused: connect
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:395)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
    at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(Jtds DataSource.java:188)
    at net.sourceforge.jtds.jdbcx.JtdsDataSource.getXAConnection(Jt dsDataSource.java:116)
    at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCBackend.initializeMo delSetup(JDBCBackend.java:116)
    ... 74 more
    Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: java.net.ConnectException. message: Connection refused: connect
    at java.net.TwoStacksPlainSocketImpl.socketConnect(Native Method)
    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSock etImpl.java:337)
    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPl ainSocketImpl.java:198)
    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocket Impl.java:180)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
    at java.net.Socket.connect(Socket.java:579)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3( SharedSocket.java:305)
    at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:323)
    ... 79 more
2012-02-17 15:15:17,467 INFO [org.nuxeo.runtime.osgi.OSGiRuntimeService] Nuxeo EP Started

============================================================ ==========
= Nuxeo EP Started*
1 ACCEPTED ANSWER

WesLowe_
Champ on-the-rise
Champ on-the-rise

Scrapped MS Sql and installed postgres and it's working now.

Thanks for all of the help!!!!!!!!!!

View answer in original post

7 REPLIES 7

bruce_Grant
Elite Collaborator
Elite Collaborator

Did you follow all the MSSQL config steps?

Florent_Guillau
World-Class Innovator
World-Class Innovator

Look at the log you just pasted, it says:

java.net.ConnectException: Connection refused: connect

So your database connection parameters are incorrect.

This can't be the case as it creates the database and populates all the tables?

Just to confirm, when I first tried to connect to the SQL database when I tried to login it didn't create the data in the database and just returned the invalid login error. Since I amended the connection information it now populates the nuxeo database with a number of tables and goes in to some kind of infinite loop.

Still no closer to getting this sorted.

WesLowe_
Champ on-the-rise
Champ on-the-rise

Yes I've made all the changes it says to make in the documentation.

WesLowe_
Champ on-the-rise
Champ on-the-rise

Scrapped MS Sql and installed postgres and it's working now.

Thanks for all of the help!!!!!!!!!!

Getting started

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.