We are trying to authenticate users from an external SQL2008 database. We have openfire & spark working successfully with SQL2008 and the users within.
We would appreciate any references or help so we can authenticate users from an external existing SQL2008 client database.
// -->
<?xml version="1.0" encoding="UTF-8" ?>- <!--
This file stores bootstrap properties needed by Openfire. Property names must be in the format: "prop.name.is.blah=value" That will be stored as: <prop> <name> <is> <blah>value</blah> </is> </name> </prop> Most properties are stored in the Openfire database. A property viewer and editor is included in the admin console.
–>
- <!--
root element, all properties must be under this element
–>
- <!--
Disable either port by setting the value to -1
–>
9090
9091
aaaaaa
en
- <!--
Network settings. By default, Openfire will bind to all network interfaces. Alternatively, you can specify a specific network interfaces that the server will listen on. For example, 127.0.0.1. This setting is generally only useful on multi-homed servers.
–>
- <!--
<network> <interface></interface> </network>
–>
org.jivesoftware.database.DefaultConnectionProvider
net.sourceforge.jtds.jdbc.Driver
jdbc:jtds:sqlserver://simposrv/openfire;appName=jive
sa
simple*826
select 1
true
true
5
25
1.0
true
net.sourceforge.jtds.jdbc.Driver
jdbc:jtds:sqlserver://SIMPOSRV/SimpleCMS?user=simple&password=simple
org.jivesoftware.openfire.auth.JDBCAuthProvider
org.jivesoftware.openfire.user.JDBCUserProvider
SELECT password FROM [User] WHERE username=?
plain
SELECT firstname,email FROM [User] WHERE username=?
SELECT COUNT(*) FROM [User]
SELECT username FROM [User]
SELECT username FROM [User] WHERE
username
firstname
</jive
openfire.xml (2955 Bytes)