0 Replies Latest reply on Dec 29, 2016 9:09 AM by Robert Wenberg

    MS SQL Server Connection

    Robert Wenberg

      I am having problems with my SQL Server connection in the Admin console setup.  I believe the issue is with the connection string and would like some to confirm what exactly it should look like.  Here is my setup to alleviate any questions.

      I am running SQL Express 2016

      Mixed Mode Authentication

      I am setup for remote connections.

      I enabled all protocols for the instance in SQL Sever Configuration Manager

      I am running on default port 1433

      SQL instance is  main\jitsi

      The database is called openfire

       

      The guide shows this as setup

      • driver -- net.sourceforge.jtds.jdbc.Driver
      • server -- jdbc:jtds:sqlserver://[host-name]:[port-number]/[database-name];appName=jive

       

      I have tried this:  jdbc:jtds:sqlserver://main\jitsi:1433/openfire;appName=jive

                                 jdbc:jtds:sqlserver://[main\jitsi]:1433/openfire;appName=jive  

       

      Same variation of error both lines:

       

      2016.12.29 09:03:26 org.jivesoftware.openfire.container.AdminConsolePlugin - An exception occurred while trying to make available the admin console via HTTPS.

      java.lang.NullPointerException

        at org.jivesoftware.openfire.container.AdminConsolePlugin.startup(AdminConsolePlug in.java:144)

        at org.jivesoftware.openfire.container.AdminConsolePlugin.initializePlugin(AdminCo nsolePlugin.java:244)

        at org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java :447)

        at org.jivesoftware.openfire.container.PluginManager.access$300(PluginManager.java :68)

        at org.jivesoftware.openfire.container.PluginManager$PluginMonitor.run(PluginManag er.java:1037)

        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

        at java.util.concurrent.FutureTask.runAndReset(Unknown Source)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301 (Unknown Source)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknow n Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

        at java.lang.Thread.run(Unknown Source)

      2016.12.29 09:07:48 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

      java.sql.SQLException: Unknown server host name 'main\jitsi'.

        at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:427)

        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)

        at java.sql.DriverManager.getConnection(Unknown Source)

        at java.sql.DriverManager.getConnection(Unknown Source)

        at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

        at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

        at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

        at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

      Caused by: java.net.UnknownHostException: main\jitsi

        at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

        at java.net.PlainSocketImpl.connect(Unknown Source)

        at java.net.SocksSocketImpl.connect(Unknown Source)

        at java.net.Socket.connect(Unknown Source)

        at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:2 88)

        at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)

        at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)

        ... 7 more

      2016.12.29 09:07:48 org.jivesoftware.database.DbConnectionManager - Unknown server host name 'main\jitsi'.

      java.sql.SQLException: Unknown server host name 'main\jitsi'.

        at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:427)

        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)

        at java.sql.DriverManager.getConnection(Unknown Source)

        at java.sql.DriverManager.getConnection(Unknown Source)

        at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

        at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

        at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211 )

        at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)

        at java.sql.DriverManager.getConnection(Unknown Source)

        at java.sql.DriverManager.getConnection(Unknown Source)

        at org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnec tionProvider.java:88)

        at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:602)

        at org.jivesoftware.openfire.admin.setup.setup_002ddatasource_002dstandard_jsp._js pService(setup_002ddatasource_002dstandard_jsp.java:220)

        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)

        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1669)

        at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8)

        at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)

        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1652)

        at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:76)

        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1652)

        at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:53)

        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1652)

        at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:80)

        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1652)

        at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:162)

        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1652)

        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)

        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)

        at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)

        at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:22 3)

        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:11 27)

        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)

        at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185 )

        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:106 1)

        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)

        at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandler Collection.java:215)

        at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.jav a:110)

        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)

        at org.eclipse.jetty.server.Server.handle(Server.java:499)

        at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)

        at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)

        at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)

        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635 )

        at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)

        at java.lang.Thread.run(Unknown Source)

      Caused by: java.net.UnknownHostException: main\jitsi

        at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

        at java.net.PlainSocketImpl.connect(Unknown Source)

        at java.net.SocksSocketImpl.connect(Unknown Source)

        at java.net.Socket.connect(Unknown Source)

        at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:2 88)

        at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)

        at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)

        ... 46 more