Up to Discussions in Openfire Support

This Question is Answered

2 "helpful" answers available (5 pts)
5 Replies Last post: Jun 12, 2008 1:48 PM by Todd Getz  
Irfan Bronze
Irfan
3 posts since
Jun 12, 2008
Currently Being Moderated

Jun 12, 2008 12:50 PM

SQL Server 2000 with default instance can't connect

 

Hi,

 

 

In my production server, i already installed sql server 2000 with default instance

 

 

Unfortunately, i can't figure what is the proper instance name for the connection string in database setup page after installing openfire...

 

 

Can anyone give me any suggestion regarding this issue?

 

 

Here is my connect string:

 

 

jdbc:jtds:sqlserver://dbserver/jabber;appName=jive;instance=mssqlserver

 

 

and, is mssqlserver default instance name if we not set  the custom instance name during the ms sql setup?

 

 

and i have these errors on error log:

 

 

2008.06.12 23:07:00 [org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConne ctionProvider.java:79)

] DbConnectionProvider: Error while getting connection:

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 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:76)

    at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:101)

    at org.jivesoftware.openfire.admin.setup.setup_002ddatasource_002dstandard_jsp.tes tConnection(setup_002ddatasource_002dstandard_jsp.java:35)

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

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

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

    at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)

    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1093)

    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.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)

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

    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)

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

    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)

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

    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)

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

    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)

    at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)

    at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)

    at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)

    at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)

    at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)

    at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollect ion.java:206)

    at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)

    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)

    at org.mortbay.jetty.Server.handle(Server.java:324)

    at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)

    at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842 )

    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)

    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)

    at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)

    at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)

    at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)

Caused by: java.net.ConnectException: Connection refused: connect

    at java.net.PlainSocketImpl.socketConnect(Native Method)

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

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

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

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

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

    at sun.reflect.GeneratedMethodAccessor3.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:3 04)

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

    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:310 )

    ... 45 more

 

 

Todd Getz KeyContributor
Todd Getz
2,163 posts since
Apr 2, 2007
Currently Being Moderated
Jun 12, 2008 1:00 PM in response to: Irfan
Re: SQL Server 2000 with default instance can't connect

Did you create a user and grant permissions in the database server?  Did you create a catalog or specific database for openfire to use within the server?

Report Abuse
Irfan Bronze
Irfan
3 posts since
Jun 12, 2008
Currently Being Moderated
Jun 12, 2008 1:12 PM in response to: Todd Getz
Re: SQL Server 2000 with default instance can't connect

 

Yes, i've created the user and grant permission, i've also tried to create new instance, and it succesfully connected

 

 

but why when i use the default instance i can't connect...?

 

 

this is so awful since my IT dept. policy dont allow me to create new instance in sql server

 

 

Anyway, what is the default instance name used on connect string ?

 

 

Report Abuse
Todd Getz KeyContributor
Todd Getz
2,163 posts since
Apr 2, 2007
Currently Being Moderated
Jun 12, 2008 1:17 PM in response to: Irfan
Re: SQL Server 2000 with default instance can't connect

Every application using SQL for storage should have it's own user and catalog for security.  By default I do not believe there is a catalog on SQL server when it is installed.  The default account is SA, but I can not tell you the password as they likely changed it as the default is blank.  Out of the box SQL server is an unsecured and unconfigured.

Report Abuse
Irfan Bronze
Irfan
3 posts since
Jun 12, 2008
Currently Being Moderated
Jun 12, 2008 1:19 PM in response to: Todd Getz
Re: SQL Server 2000 with default instance can't connect

what's the connect string when u use default instance of sql server?

Report Abuse
Todd Getz KeyContributor
Todd Getz
2,163 posts since
Apr 2, 2007
Currently Being Moderated
Jun 12, 2008 1:54 PM in response to: Irfan
Re: SQL Server 2000 with default instance can't connect 

 
 
dbc:jtds:sqlserver://[host-name]/[database-name];appName=jive
 
 
you need only change the [host-name] to the name of your MSSQL server
and [database-name] to the name of the database you created in the MSSQL server to house the Openfire tables. 

You then need to provide a username and password.

 

 

 

Like I said though that is as much as I can tell you the rest needs to come from your admins.  There is no "default" config, that I am aware of on the server side.

Report Abuse

More Like This

  • Retrieving data ...