Custom DB integration

Openfire Openfire Support
1

My config file:

<?xml version=“1.0” encoding=“UTF-8”?> <!–
This file stores bootstrap properties needed by Wildfire.
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 Wildfire database. A
property viewer and editor is included in the admin console.
–>
<!-- root element, all properties must be under this element -->
<jive> <adminConsole> <!-- Disable either port by setting the value to -1 --> <port>9090</port> <securePort>9091</securePort> </adminConsole> <admin> <!-- Use this section to define users that will have admin privileges. Below,
you will find two ways to specify which users are admins. Admins will
have access to the admin console (only local users) and may have also access
to other functionalities like ad-hoc commands. --> <!-- By default, only the user with the username “admin” can login
to the admin console. Alternatively, you can specify a comma-delimitted
list usernames that should be authorized to login to the admin console
by setting the <authorizedUsernames> field below. --> <!-- <authorizedUsernames></authorizedUsernames> --> <!-- Comma-delimitted list of bare JIDs. The JIDs may belong to local
or remote users. --> <!-- <authorizedJIDs></authorizedJIDs> --> </admin> <locale>en</locale> <!-- Network settings. By default, Wildfire 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>
–> <!-- Example LDAP settings --> <!-- Note, for Active Directory, try usernameField=sAMAccountName, nameField=displayName,
emailField=mail --> <!–
<ldap>
<host></host>
<port>389</port>
<usernameField>uid</usernameField>
<nameField>cn</nameField>
<emailField>mail</emailField>
<baseDN></baseDN>
<adminDN></adminDN>
<adminPassword></adminPassword>
</ldap>
<provider>
<user>
<className>org.jivesoftware.wildfire.ldap.LdapUserProvider</className& gt;
</user>
<auth>
<className>org.jivesoftware.wildfire.ldap.LdapAuthProvider</className& gt;
</auth>
</provider>
–> <!-- End example LDAP settings --> <connectionProvider> <className>org.jivesoftware.database.DefaultConnectionProvider</classN ame> <auth>
<className>org.jivesoftware.wildfire.auth.JDBCAuthProvider</className& gt;
</auth>
</connectionProvider> <database> <defaultProvider> <driver>net.sourceforge.jtds.jdbc.Driver</driver> <serverURL>jdbc:jtds:sqlserver://localhost/jabber;appName=jive</server URL> <username>username</username> <password>secret</password> <minConnections>5</minConnections> <maxConnections>15</maxConnections> <connectionTimeout>1.0</connectionTimeout> </defaultProvider> </database> <provider>
<auth>
<className>org.jivesoftware.wildfire.auth.JDBCAuthProvider</className& gt;
</auth>
</provider>

<jdbcProvider>
<driver>net.sourceforge.jtds.jdbc.Driver</driver>
<connectionString>jdbc:jtds:sqlserver://localhost/jabber;appName=jive;&lt ;/connectionString>
</jdbcProvider>

<jdbcAuthProvider>
<passwordSQL>SELECT password FROM test WHERE username=?</passwordSQL>
<passwordType>plain</passwordType>
</jdbcAuthProvider>

<setup>true</setup> </jive>

I get the error mesages (error.log), user authentication doesnt work:

2006.10.10 13:13:15 [
|org.jivesoftware.wildfire.auth.JDBCAuthProvider.getPasswordValue(JDBCAuthProvi der.java:208)] Exception in JDBCAuthProvider
java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:611)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:331 )
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.jivesoftware.wildfire.auth.JDBCAuthProvider.getPasswordValue(JDBCAuthProvid er.java:194)
at org.jivesoftware.wildfire.auth.JDBCAuthProvider.authenticate(JDBCAuthProvider.j ava:138)
at org.jivesoftware.wildfire.auth.AuthFactory.authenticate(AuthFactory.java:147)
at org.jivesoftware.wildfire.handler.IQAuthHandler.login(IQAuthHandler.java:219)
at org.jivesoftware.wildfire.handler.IQAuthHandler.handleIQ(IQAuthHandler.java:140 )
at org.jivesoftware.wildfire.handler.IQHandler.process(IQHandler.java:48)
at org.jivesoftware.wildfire.IQRouter.handle(IQRouter.java:268)
at org.jivesoftware.wildfire.IQRouter.route(IQRouter.java:96)
at org.jivesoftware.wildfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:67)
at org.jivesoftware.wildfire.net.SocketReader.processIQ(SocketReader.java:250)
at org.jivesoftware.wildfire.net.ClientSocketReader.processIQ(ClientSocketReader.j ava:51)
at org.jivesoftware.wildfire.net.SocketReader.process(SocketReader.java:216)
at org.jivesoftware.wildfire.net.BlockingReadingMode.readStream(BlockingReadingMod e.java:156)
at org.jivesoftware.wildfire.net.BlockingReadingMode.run(BlockingReadingMode.java: 62)
at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:123)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.IOException: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.sendMSLoginPkt(TdsCore.java:1894)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:584)
… 21 more
2006.10.10 13:13:20 [
|org.jivesoftware.wildfire.auth.JDBCAuthProvider.getPasswordValue(JDBCAuthProvi der.java:208)] Exception in JDBCAuthProvider
java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:611)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:331 )
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.jivesoftware.wildfire.auth.JDBCAuthProvider.getPasswordValue(JDBCAuthProvid er.java:194)
at org.jivesoftware.wildfire.auth.JDBCAuthProvider.authenticate(JDBCAuthProvider.j ava:138)
at org.jivesoftware.wildfire.auth.AuthFactory.authenticate(AuthFactory.java:147)
at org.jivesoftware.wildfire.handler.IQAuthHandler.login(IQAuthHandler.java:219)
at org.jivesoftware.wildfire.handler.IQAuthHandler.handleIQ(IQAuthHandler.java:140 )
at org.jivesoftware.wildfire.handler.IQHandler.process(IQHandler.java:48)
at org.jivesoftware.wildfire.IQRouter.handle(IQRouter.java:268)
at org.jivesoftware.wildfire.IQRouter.route(IQRouter.java:96)
at org.jivesoftware.wildfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:67)
at org.jivesoftware.wildfire.net.SocketReader.processIQ(SocketReader.java:250)
at org.jivesoftware.wildfire.net.ClientSocketReader.processIQ(ClientSocketReader.j ava:51)
at org.jivesoftware.wildfire.net.SocketReader.process(SocketReader.java:216)
at org.jivesoftware.wildfire.net.BlockingReadingMode.readStream(BlockingReadingMod e.java:156)
at org.jivesoftware.wildfire.net.BlockingReadingMode.run(BlockingReadingMode.java: 62)
at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:123)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.IOException: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.sendMSLoginPkt(TdsCore.java:1894)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:584)
… 21 more

2

Hi,

I wondered if you ever resolved this? I am having the same issue, I will be happy to work with you to try and figure it out?

Paul