HI, can anyone offer me any help with this problem. I am evaluating openfire, I had the server up and running fine with the distributed/built in database. I needed to use SQLServever, so I uninstalled onenfire and then reinstalled it and configured it to use the SQLserver database having installed the schema on the Target SQLServer instance.
In the openfire admin screen if I browse to the database config page I have the following:
Database and Version:
Microsoft SQL Server 08.00.2039
JDBC Driver:
jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
JDBC Driver Version:
1.2.2
DB Connection URL:
jdbc:jtds:sqlserver://10.2.1.134;appName=openfire
DB User:
sa
Transaction Support:
Yes
Transaction Isolation Level:
TRANSACTION_READ_COMMITTED
Supports multiple connections
open at once:
Yes
In read-only mode:
No
The problem is that the data is not being added to the sql server database, I am presuming it is still being added to the distributed database.
If I stop the SQLServer instance then the openfire admin falls over so it looks like I am missing something.
Can anyone offer me any help with this?
Thanks in advance
Chris