I have installed OpenFire 3.7.1 on my machine and configured it to use a custom database connection to use the users I have in an existing database. I did this on a Windows 7 x64 box and after a bit of manipulation was able to successfully connect and authenticate a Spark client with a username in my existing database.
I am now trying to do the same thing on the Windows Server 2008 box that our development team uses. It too is running SQL Server 2008 R2.
Following is the jdbcProvider.connectionString I am using (this same string works on my personal machine with the only difference being I used
localhost instead of the server name. I initially tried to connect a Spark client from my machine to the development server. After many tries and this not working I install Spark on the server and attempted to connect locally just as I did on my machine.
I’ve tried using the server IP address (as above), the servername (testserver), the database server (testdbserver). I’ve gotten a variety of errors depending on what config string, user I used. With the above string I get “Can’t connect to server: invalid name or server not reachable” with nothing in the \logs\error file with a valid user name/password and server = testdbserver. When I use the actual server name (testserver) I get the following error: “invalid username or password” . This attempt writes the following to the error logs:
org.jivesoftware.openfire.auth.JDBCAuthProvider - Exception in JDBCAuthProvider
java.sql.SQLException: Login failed for user ‘suser’.
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source) etc…
I hope this isn’t confusing but basically wonder why the exact same configuring (except for names) works on my Windows 7 machine but does not work on my Server 2008 box. All the values in the dbo.ofProperty tables are the same on both machines (except for the server names - DB names are exactly the same).
Thanks for any help or insight anyone can provide.