Hi!
Sorry about the size of my previous log.
I am at home now and trying the same exercise but with a local sql
server connection.
Everything is the same, but instead of the ip address i am putting
localhost.
The nuxeo window opens and in this occasion i try to login with:
Administrator / Administrator
And i get an incorrect user o password error message.
This is part of the log....with the parts stated that could help you
help me.
Thanks in advance
Ramon De Abreu
org.jboss.resource.JBossResourceException: Could not create
connection; - nested throwable: (java.sql.SQLException: Network error
IOException: Connection refused: connect)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:619)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:264)
at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
at
org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)
at
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:713)
at
org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127)
at
org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:246)
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:585)
at
org.jboss.ejb3.ServiceDelegateWrapper.startService(ServiceDelegateWrapper.java:103)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:417)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy224.start(Unknown Source)
at
org.jboss.ejb3.JmxKernelAbstraction.install(JmxKernelAbstraction.java:120)
at
org.jboss.ejb3.Ejb3Deployment.startPersistenceUnits(Ejb3Deployment.java:627)
at org.jboss.ejb3.Ejb3Deployment.start(Ejb3Deployment.java:351)
at org.jboss.ejb3.Ejb3Module.startService(Ejb3Module.java:91)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:417)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy34.start(Unknown Source)
at org.jboss.ejb3.EJB3Deployer.start(EJB3Deployer.java:512)
at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at
org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy35.start(Unknown Source)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy25.deploy(Unknown Source)
at
org.nuxeo.runtime.jboss.deployment.NuxeoDeployer.start(NuxeoDeployer.java:264)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy9.deploy(Unknown Source)
at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:417)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
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:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:508)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Network error IOException:
Connection refused: connect
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:172)
... 168 more
and......
2009-06-10 15:39:45,203 INFO
[org.jboss.web.tomcat.service.TomcatDeployer] deploy,
ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
2009-06-10 15:39:45,468 INFO
[org.nuxeo.runtime.jboss.deployment.NuxeoDeployer] Nuxeo's Seam
HotReload Preprocessus is not enabled
2009-06-10 15:39:45,703 INFO
[org.nuxeo.runtime.jboss.deployment.preprocessor.DeploymentPreprocessor]
Running custom installation for container: nuxeo.ear
2009-06-10 15:40:01,515 INFO
[org.nuxeo.runtime.jboss.deployment.preprocessor.DeploymentPreprocessor]
Scanning directory: system
2009-06-10 15:40:08,468 INFO
[org.nuxeo.runtime.jboss.deployment.preprocessor.DeploymentPreprocessor]
Scanning directory: .
2009-06-10 15:40:08,656 INFO
[org.nuxeo.runtime.jboss.deployment.preprocessor.DeploymentPreprocessor]
Scanning directory: plugins
2009-06-10 15:40:08,703 INFO
[org.nuxeo.runtime.jboss.deployment.preprocessor.DeploymentPreprocessor]
Running custom installation for fragment: org.nuxeo.ecm.platform.lang
2009-06-10 15:40:09,234 INFO
[org.nuxeo.runtime.jboss.deployment.preprocessor.DeploymentPreprocessor]
Running custom installation for fragment: org.nuxeo.ecm.webapp.ui
2009-06-10 15:40:10,062 INFO
[org.nuxeo.runtime.jboss.deployment.preprocessor.DeploymentPreprocessor]
Running custom installation for fragment: org.nuxeo.theme.html
2009-06-10 15:40:10,765 INFO
[org.nuxeo.runtime.jboss.deployment.preprocessor.DeploymentPreprocessor]
Running custom installation for fragment: org.nuxeo.ecm.platform.jbpm.web
2009-06-10 15:40:10,843 INFO
[org.nuxeo.runtime.jboss.deployment.preprocessor.DeploymentPreprocessor]
Running custom installation for fragment:
org.nuxeo.ecm.annotations.repository
2009-06-10 15:40:13,765 INFO
[org.nuxeo.runtime.jboss.deployment.preprocessor.DeploymentPreprocessor]
Running custom installation for fragment: org.nuxeo.ecm.annotations.http
20
and....
2009-06-10 15:42:39,781 INFO
[org.apache.coyote.http11.Http11Protocol] Starting Coyote HTTP/1.1 on
http-127.0.0.1-8080
2009-06-10 15:42:39,796 INFO [org.apache.coyote.ajp.AjpProtocol]
Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
2009-06-10 15:42:39,812 INFO
[org.nuxeo.runtime.osgi.OSGiRuntimeService] Nuxeo EP Started
======================================================================
= Nuxeo EP Started
======================================================================
= Component Loading Status: Pending: 0 / Unstarted: 0 / Total: 314
======================================================================
2009-06-10 15:42:39,812 INFO
[org.nuxeo.ecm.platform.relations.services.RelationService] Relation
Service initialization
2009-06-10 15:42:39,812 INFO
[org.nuxeo.ecm.platform.relations.services.RelationService] create RDF
Graph versionned-annotation
2009-06-10 15:42:40,781 WARN
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create
connection; - nested throwable: (java.sql.SQLException: Network error
IOException: Connection refused: connect)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:619)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:264)
at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java:209)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java:180)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:821)
at
org.nuxeo.ecm.platform.relations.services.RelationService.frameworkEvent(RelationService.java:473)
at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:200)
at
org.nuxeo.osgi.jboss.JBossOSGiAdapter.handleNotification2(JBossOSGiAdapter.java:219)
at
org.jboss.system.ListenerServiceMBeanSupport.handleNotification(ListenerServiceMBeanSupport.java:403)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.notification.NotificationListenerProxy.invoke(NotificationListenerProxy.java:153)
at $Proxy64.handleNotification(Unknown Source)
at
org.jboss.mx.util.JBossNotificationBroadcasterSupport.handleNotification(JBossNotificationBroadcasterSupport.java:127)
at
org.jboss.mx.util.JBossNotificationBroadcasterSupport.sendNotification(JBossNotificationBroadcasterSupport.java:110)
at
org.jboss.system.server.ServerImpl.sendNotification(ServerImpl.java:916)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:497)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:508)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Network error IOException:
Connection refused: connect
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:172)
... 28 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
On Wed, Jun 10, 2009 at 3:01 PM, Julien CARSIQUE <[email protected]
<mailto:[email protected]>> wrote:
Please keep the mailing list in copy.
Use (for example) http://pastebin.com/ to give us the main parts
of the log file without having to send the content by mail.
Important parts are:
- the first lines starting with ERROR and the stacktrace just
following each of those errors.
- the lines following "INFO
[org.nuxeo.runtime.jboss.deployment.NuxeoDeployer] Sub Deployment
order is:"
- the startup summary following "INFO
[org.nuxeo.runtime.osgi.OSGiRuntimeService] Nuxeo EP Started"
Warnings with a stacktrace may be useful.
Also, if you have a file
C:\opt\jboss\server\default\log\nuxeo-error.log it may be more
compact and summarizing errors.
Ramon De Abreu a écrit :
Hi!
I have sent a post earlier this morning but the log is over
3mb and the ecm moderator is "studying what to do with it"
being to big.
I have copied the opensource driver in the jboss directory
(*jtds-1.2.2.jar* in $JBOSS_HOME\server\default\lib).
To make sure i deleted the microsoft driver from the same
directory.
I can log in with http://localhost:8080/nuxeo
As soon as i put Administrator / Administrator i get the
following page:
JBoss Seam Debug page
a few lines down i can read:
Application Context
Exception
Exception during request processing:
Caused by javax.el.ELException with message:
"org.nuxeo.ecm.core.api.ClientException: Error opening session
for repository default"
There is a quite a large log afterwards but i am not sure if
i should send it after the previous message that i sent being
too big.
Thanks in advance
Ramon De Abreu
On Wed, Jun 10, 2009 at 11:53 AM, Julien CARSIQUE
<[email protected] <mailto:[email protected]>
<mailto:[email protected] <mailto:[email protected]>>> wrote:
Hello,
Your configuration seems to be correct. Take care to only
keep one
driver into JBoss directory (the opensource one).
Then, did you try to connect to http://localhost:8080/nuxeo/ ?
Do you have errors into
C:\opt\jboss\server\default\log\server.log ?
Regards,
Julien
Ramon De Abreu a écrit :
Hi!
In my work environment i am supposed to set up Nuxeo DM 5.2
with Microsoft SQL Server.
I have been able to successfully change the default Derby
database to MySQL and also to Postgres but i am having
problems with MS SQL Server.
I supposed that the PostGres setup is basically similar
to the
MS SQL server setup so i proceeded to do the same:
Current setup:
Platform: Windows XP
Nuxeo 5.2
MS SQL Server 2005
Jboss 4.2.3.GA <http://4.2.3.GA> <http://4.2.3.GA>
<http://4.2.3.GA>
JDK 5.0
I have followed the following FAQ used to setup
Postgres and
applied it to MS SQL Server:
*http://doc.nuxeo.org/xwiki/bin/view/FAQ/Nuxeo52VcsPostgreSQL*
Also, i have used the nuxeo-book-administration.pdf
I have tried installing MS SQL Server 2005 on the current
machine that i have Nuxeo and also on an another pc in the
network.
I will comment first my experience with the other pc in the
network.
I have downloaded the Microsoft SQL Server JDBC drivers
(sqljdbc_1.0.809.102_enu) and put it in the following
directory:
$JBOSS_HOME\server\default\lib
I created a new database called *nuxeo* on the network pc.
I proceeded to use the Visible Content Store
Configuration (i
have not tried the jackrabbit option).
I have modified the following files with what i think
is the
correct configuration for MS SQL Server.
1) El contenido de *default-repository-config.xml*:
$JBOSS_HOME\server\default\deploy\nuxeo.ear\config
<?xml version="1.0"?>
<component name="org.nuxeo.ecm.core.storage.sql.config">
<extension
target="org.nuxeo.ecm.core.repository.RepositoryService"
point="repository">
<repository name="default"
factory="org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepositoryFactory">
<repository name="default">
<indexing>
<!-- configuration MS SQL SERVERS -->
<fulltext catalog="nuxeo" analyzer="english"/>
</indexing>
</repository>
</repository>
</extension>
</component>
2) El contenido del *default-repository-ds.xml*
C:\opt\jboss\server\default\deploy\nuxeo.ear\datasources
<?xml version="1.0"?>
<!-- MICROSOFT SQL SERVER -->
<connection-factories>
<tx-connection-factory>
<jndi-name>NXRepository/default</jndi-name>
<xa-transaction/>
<track-connection-by-tx/>
<adapter-display-name>Nuxeo SQL Repository
DataSource</adapter-display-name>
<rar-name>nuxeo.ear#nuxeo-core-storage-sql-ra-1.5.1-SNAPSHOT.rar</rar-name>
<connection-definition>org.nuxeo.ecm.core.storage.sql.Repository</connection-definition>
<config-property name="name">default</config-property>
<!-- <config-property name="xaDataSource"
type="java.lang.String">com.microsoft.sqlserver.jdbc.SQLServerXADataSource</config-property>
-->
<config-property name="xaDataSource"
type="java.lang.String">net.sourceforge.jtds.jdbcx.JtdsDataSource</config-property>
<config-property name="property"
type="java.lang.String">ServerName=192.168.0.2</config-property>
<config-property name="property"
type="java.lang.String">PortNumber=1433</config-property>
<config-property name="property"
type="java.lang.String">DatabaseName=nuxeo</config-property>
<config-property name="property"
type="java.lang.String">User=ramon</config-property>
<config-property name="property"
type="java.lang.String">Password=admin</config-property>
<max-pool-size>20</max-pool-size>
</tx-connection-factory>
</connection-factories>
I have read somewhere in earlier posts that there has been
problems with the Microsoft JDBC drivers and that one
should
download the ones from sourceforge (downloaded and
installed
.jar in same directory
as the microsoft JDBC one).
You can see that in the above file i have commented the
version that uses the Microsoft drivers in favour of the
source forge.
And the same goes for the following files.
Of course, i have tried both cases and none of them work.
3) El contenido del fichero: *unified-nuxeo-ds.xml*
$JBOSS_HOME\server\default\deploy\nuxeo.ear\datasources
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<!-- DEFAULT UNIFIED DATASOURCE CONFIGURATION -->
<!--
This is the default unified datasource
configuration. All
datasources from nuxeo
points to this datasource so it will use only 1
database.
To use another database than Derby, comment out the
following section and uncomment
your database configuration or add it if not present.
If you wish to use a different database for a service,
comment out the link in the relevant
xxx-ds.xml file and add a datasource configuration.
-->
<!-- Configuration for MS SQL SERVER -->
<local-tx-datasource>
<jndi-name>NuxeoDS</jndi-name>
<connection-url>jdbc:jtds:sqlserver://192.168.0.2:1433/nuxeo;user=ramon;password=admin
<http://192.168.0.2:1433/nuxeo;user=ramon;password=admin>
<http://192.168.0.2:1433/nuxeo;user=ramon;password=admin>
<http://192.168.0.2:1433/nuxeo;user=ramon;password=admin>;</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<!--
<connection-url>jdbc:microsoft:sqlserver://192.168.0.2:1433;databaseName=nuxeo</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
-->
<user-name>ramon</user-name>
<password>admin</password>
<check-valid-connection-sql>;</check-valid-connection-sql>
</local-tx-datasource>
</datasources>
4)El fichero: *sql.properties*
$JBOSS_HOME\server\default\deploy\nuxeo.ear\config
# Jena database type and transaction mode
org.nuxeo.ecm.sql.jena.databaseType=MsSQL
org.nuxeo.ecm.sql.jena.databaseTransactionEnabled=false
Finally, i execute the run.bat from my JBOSS_HOME\bin
And open firefox:
192.168.0.2:8080/nuxeo <http://192.168.0.2:8080/nuxeo>
<http://192.168.0.2:8080/nuxeo>
<http://192.168.0.2:8080/nuxeo>
And no connection occurs.
Thanks in advance
Ramon De Abreu
------------------------------------------------------------------------
_______________________________________________
ECM mailing list
[email protected] <mailto:[email protected]>
<mailto:[email protected] <mailto:[email protected]>>
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to
http://lists.nuxeo.com/mailman/options/ecm
-- Julien Carsique, Nuxeo (Paris, France)
www.nuxeo.com <http://www.nuxeo.com> <http://www.nuxeo.com>
- The Open Source ECM
Platform - www.nuxeo.org <http://www.nuxeo.org>
<http://www.nuxeo.org>
Nuxeo ECM Stack - The Java EE, scalable, standard-based ECM
Platform
[email protected] <mailto:[email protected]>
<mailto:[email protected] <mailto:[email protected]>> |
Tel: +33 1 40
33 79 87
--
Julien Carsique, Nuxeo (Paris, France)
www.nuxeo.com <http://www.nuxeo.com> - The Open Source ECM
Platform - www.nuxeo.org <http://www.nuxeo.org>
Nuxeo ECM Stack - The Java EE, scalable, standard-based ECM Platform
[email protected] <mailto:[email protected]> | Tel: +33 1 40
33 79 87
