Database setup and configure error

Hello:

We are using windows 2003 sql server for our Openfire. Recently we moved our sql server to another machine, and I got the following error message. The sever’s configuration looks ok because our other application can access to it. Can someone helps me out?

Thanks.

2008.03.04 11:56:21 [org.jivesoftware.util.log.util.CommonsLogFactory$1.error(CommonsLogFactory.jav a:91)

] Prototype

java.sql.SQLException: Unable to get information from SQL Server: sqlserver_name.

at net.sourceforge.jtds.jdbc.MSSqlServerInfo.<init>(MSSqlServerInfo.java:91)

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

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.Prototyper.sweep(Prototyper.java:102)

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

2008.03.04 11:56:21 [org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConne ctionProvider.java:74)

] DbConnectionProvider: Error while getting connection:

java.sql.SQLException: Unable to get information from SQL Server: sqlserver_name.

at net.sourceforge.jtds.jdbc.MSSqlServerInfo.<init>(MSSqlServerInfo.java:91)

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

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

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

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

at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:330)

at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:72)

at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProp erties.java:39)

at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:51)

at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:524)

at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:327)

at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:434)

at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:155)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance0(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)

at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:50)

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 com.exe4j.runtime.LauncherEngine.launch(Unknown Source)

at com.exe4j.runtime.WinLauncher.main(Unknown Source)

2008.03.04 11:56:21 [org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnecti onManager.java:470)

]

java.lang.NullPointerException

at org.jivesoftware.database.DbConnectionManager.setMetaData(DbConnectionManager.j ava:649)

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

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

at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:330)

at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:72)

at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProp erties.java:39)

at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:51)

at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:524)

at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:327)

at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:434)

at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:155)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance0(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)

at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:50)

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 com.exe4j.runtime.LauncherEngine.launch(Unknown Source)

at com.exe4j.runtime.WinLauncher.main(Unknown Source)

2008.03.04 11:56:27 [org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConne ctionProvider.java:74)

] DbConnectionProvider: Error while getting connection:

java.sql.SQLException: Unable to get information from SQL Server: sqlserver_name.

at net.sourceforge.jtds.jdbc.MSSqlServerInfo.<init>(MSSqlServerInfo.java:91)

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

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

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

at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:330)

at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:72)

at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProp erties.java:39)

at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:51)

at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:524)

at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:327)

at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:434)

at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:155)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance0(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)

at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:50)

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 com.exe4j.runtime.LauncherEngine.launch(Unknown Source)

at com.exe4j.runtime.WinLauncher.main(Unknown Source)

Did you change the name of the server, if so you need to make that adjustment in the openfire.xml as well. How about the user account that has access to the openfire db on the new server.

Well, we use the old server name for the new server and give the old server a new name, thus we don’t need to change a lot in the configuration files.

Now I guess maybe it’s because the new server haven’t set up java environment yet. Is that case? Besides JRE, do I need to install other Java programs and is the JRE version an issue too?

Thanks.

You should not need JRE on the SQL server. Did you move the openfire install as well?

No, we didn’t move openfire server.

So all aspects of the database server are the same: FQDN of the server, username, password, catalog (actual DB)? If all is yes you could try rerunning the setup config. This is done by changing the setup attribute in the openfire.xml to match this: <setup>false</setup>

Ok, thanks! We will try it.

Hi,

We tried and it doesn’t work. We tried it to switch back our old database server, it works fine. So is there a security issue, or we missed installing some programs for Openfire on sql server if not JRE?