Wildfire not connecting to SQL Express Server 2005

Openfire Openfire Support
1

Hi,

I went through the postings but I couldn’'t find the one which solved my problem so here it is. I have Wildfire Server setup on one machine and the SQL Express Server is on my localmachine. I am trying to connect using the following setting:

JDBC driver: class net.sourceforge.jtds.jdbc.Driver

Database URL: jdbc:jtds:sqlserver://hostname:1433/messenger

My thinking is that I need a different JDBC driver and thats the reason the connection is not being made. If so, where can I get the latest JDBC Driver and also is the Database URL syntax correct?

Thanks for all your help,

Veena

Message was edited by: veens

2

Hi Veena,

did you read SQL Server[/url]? I think you must also add “;appName=jive”

LG

3

Hi LG,

I did try the steps and also I have downloaded the new JDBC driver into the “lib” folder…IS there something wrong with the JDBC driver…I am able to connect to MySQL database so I guess it is the JDBC driver associated with SQL server Express…Do you think the driver JAR file needs to be saved in some other folder?

Thanks,

Veena

4

Hey Veena,

Could you post the errors that you see in your logs/error.log file? That will help us evaluate better the reason of this problem.

Regards,

– Gato

5

Hi Gato,

Here is the last error logged.

2006.04.11 14:30:05 [org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConne ctionProvider.java:68)

] Warning: DbConnectionDefaultPool.getConnection() was called before the internal pool has been initialized.

2006.04.11 14:30:05 [org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManage r.java:116)

] WARNING: ConnectionManager.getConnection() failed to obtain a connection.

2006.04.11 15:13:10 [org.jivesoftware.wildfire.net.SocketReader.negotiateTLS(SocketReader.java:682)

] Error while negotiating TLS

javax.net.ssl.SSLException: Unrecognized SSL message, plaintext connection?

at com.sun.net.ssl.internal.ssl.EngineInputRecord.bytesInCompletePacket(Unknown Source)

at com.sun.net.ssl.internal.ssl.SSLEngineImpl.readNetRecord(Unknown Source)

at com.sun.net.ssl.internal.ssl.SSLEngineImpl.unwrap(Unknown Source)

at javax.net.ssl.SSLEngine.unwrap(Unknown Source)

at org.jivesoftware.wildfire.net.TLSStreamHandler.doHandshake(TLSStreamHandler.jav a:268)

at org.jivesoftware.wildfire.net.TLSStreamHandler.(TLSStreamHandler.java:206)

at org.jivesoftware.wildfire.net.SocketConnection.startTLS(SocketConnection.java:1 52)

at org.jivesoftware.wildfire.net.SocketReader.negotiateTLS(SocketReader.java:679)

at org.jivesoftware.wildfire.net.SocketReader.readStream(SocketReader.java:268)

at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:119)

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

2006.04.11 15:13:10 [org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:161)

] Connection closed before session established

Socket[addr=/10.1.7.74,port=2113,localport=5222]

Any help will be appreciated …

I have downloaded the JDBC driver from microsoft website and using that.

Thanks,

Veena

I am still getting the same error…I have tried everything…Is there something I am missing out?

Thanks for all your help,

Veena

Message was edited by: veens

6

Hey Veena,

Can you post the first errors? The last one is not really of much help.

Regards,

– Gato

7

Hi Gato,

Here’'s the error log from previous connection try

2006.04.06 09:59:58 [org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConne ctionProvider.java:68)

] Warning: DbConnectionDefaultPool.getConnection() was called before the internal pool has been initialized.

2006.04.06 09:59:58 [org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManage r.java:116)

] WARNING: ConnectionManager.getConnection() failed to obtain a connection.

2006.04.06 10:30:28 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:120)

at org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProv ider.java:83)

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

at org.jivesoftware.wildfire.admin.setup.setup_002ddatasource_002dstandard_jsp._js pService(setup_002ddatasource_002dstandard_jsp.java:194)

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

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

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

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:822)

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.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

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

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

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

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

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

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:494)

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

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)

at org.mortbay.http.HttpServer.service(HttpServer.java:896)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

Thanks for helping out.

-Veena

8

Hey Veena,

Thanks for the information. The key exception here is: “java.sql.SQLException: Network error IOException: Connection refused: connect”. Possible reasons for this error are:

  1. The server name is misspelled or the port number is incorrect.

  2. SQL Server is not configured to use TCP/IP. Either enable TCP/IP from SQL Server’'s Network Utility app or have jTDS connect via named pipes (see the URL format for information on how to do this).

  3. There is a firewall blocking port 1433 on the server.

Try doing a telnet 1433 and see if that works.

Regards,

  • Gato
9

Hi Gato,

Thanks for the prompt reply…I think I have a TCP connection issue with the SQL Express server…I will try to resolve that and see if I can connect to the SQL EXPRESS server…If not I will try to use the MySQL server since that is connecting fine.

Thanks again,

Veena

Hi Gato,

Just to keep you guys updated…The error was on my SQL Express not listening to port 1433. I have resolved that and SQL Express works perfectly fine with Wildfire Server.

Thanks for all your help,

Veena

Message was edited by: veens

10

Hey Veena,

Nice to hear that things are working fine.

Regards,

– Gato