Nuxeo DM with SQL Server Express 2008 - trouble setting up.
Hi, I'm trying to use sql express 2008 with Nuxeo DM. Here's a part of the config file:
# nuxeo.templates=default
nuxeo.templates=mssql
# nuxeo.db.user=nuxeo
nuxeo.db.user=nuxeo\_db\_user
# nuxeo.db.password=password
nuxeo.db.password=123
# nuxeo.db.host=localhost
nuxeo.db.host=localhost\\sqlexpress
but the database isn't created and in the server logs I have:
2011-09-22 18:05:01,265 ERROR [org.nuxeo.ecm.platform.ui.web.auth.plugins.AnonymousAuthenticator] java.lang.RuntimeException: Unkown user directory userDirectory
…which it seems that at the end of the stack trace comes from
org.nuxeo.ecm.core.api.WrappedException: Exception: java.net.UnknownHostException. message: localhost\sqlexpress
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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)
0 votes
2 answers
1963 views
Nuxeo uses jtds for the underlying connection and builds the jdbc url this way: jdbc:jtds:sqlserver://${nuxeo.db.host}:${nuxeo.db.port}/${nuxeo.db.name};useCursors=true
According to what I can see about jtds and named instances you have two options: 1) append “;instance=sqlexpress” to your nuxeo.db.name 2) use the named instance specific port instead of the generic database port
 |
Mathieu Guillaume
Member (3.4K) 1 4 3 |
09/23/2011 ( History) |
nuxeo.db.host must be a hostname or IP address, in your case it would be localhost if your MS SQL Express instance is running on the same machine as nuxeo.
|
Mathieu Guillaume
Member (3.4K) 1 4 3 |
09/23/2011 ( History) |
Yes but as you can see the server is set up as a named instance (SQLEXPRESS), so localhost isn't sufficient. Does NUXEO support connecting to named instances of SQL Server? Thank you for your time.
09/23/2011