Ask Question
« General Questions on Nuxeo

Trouble with Nuxeo 5.5 and MSSQL

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*
WesLowe
Member (105)   1   1   2 		02/20/2012 ( History)
0 votes
2 answers
2748 views
ANSWER
bruce Grant
Did you follow all the MSSQL config steps?

http://doc.nuxeo.com/display/ADMINDOC/Configuring+MS+SQL+Server

02/20/2012
WesLowe
Yes I've made all the changes it says to make in the documentation.
02/20/2012
ANSWERS

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

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

WesLowe
Member (105)   1   1   2 		02/21/2012 ( History)
0 votes

Look at the log you just pasted, it says:

java.net.ConnectException: Connection refused: connect

So your database connection parameters are incorrect.

Florent Guillaume
Member (36K)   6   8   8 		02/20/2012 ( History)
0 votes
WesLowe
This can't be the case as it creates the database and populates all the tables?
02/20/2012
WesLowe
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.
02/20/2012
WesLowe
Still no closer to getting this sorted.

If what you're saying is correct, would the database connection information be held anywhere other than in the nuxeo.conf file?

I can't see how it would populate the database but then get connection refused?

02/21/2012
Follow
Tags
Linked Questions
Related Questions
Error upgrading from 5.6 to 5.8 with SQL Server
Nuxeo-5.9.4 and MS SQL 2005 error
Error while Nuxeo 5.9.4 start up db schema setup
Start nuxeo fails when constrained by the pool
We are getting following error in nuxeo 5.6 after usage for approximately 2 hours?
Connection pool is fully used error
Why so often there is an error "Failed to execute the query: DB server closed the connection."
Why so often there is an error "Failed to execute query: Software caused connection abort: socket write error"
Error while updating the project from Nuxeo Studio