Hello all;
I hope you are able to help me. I have tried to setup my OpenFire to authenticate with my WordPress+BuddyPress user database. Every time I try to upload the script it gives me a password fail error when I try and login. Is there a fault in this code somewhere that I’m not seeing? I changed the name of my MySQL database, username, and password but other than that this is the code I am using:
Thanks in advance!
<?xml version="1.0" encoding="UTF-8"?> <jive> <adminConsole> <port>9090</port> <securePort>9091</securePort> </adminConsole> <admin>
<authorizedUsernames>skyrie</authorizedUsernames>
</admin>
<network>
<interface>xxx</interface>
</network>
<locale>en</locale> <connectionProvider> <className>org.jivesoftware.database.DefaultConnectionProvider</className> </connectionProvider> <database> <defaultProvider> <driver>com.mysql.jdbc.Driver</driver> <serverURL>jdbc:mysql://localhost:3306/xxx</serverURL> <username>xxx</username> <password>xxx</password> <testSQL>select 1</testSQL> <testBeforeUse>true</testBeforeUse> <testAfterUse>true</testAfterUse> <minConnections>5</minConnections> <maxConnections>25</maxConnections> <connectionTimeout>1.0</connectionTimeout> </defaultProvider> <jdbcProvider>
<driver>com.mysql.jdbc.Driver</driver>
<connectionString>jdbc:mysql://localhost/xxx?user=xxx&password=xxx</connectionString>
</jdbcProvider>
<provider>
<auth>
<className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className>
</auth>
<user>
<className>org.jivesoftware.openfire.user.JDBCUserProvider</className>
</user>
</provider>
<jdbcAuthProvider>
<passwordSQL>SELECT user_pass FROM wp_users WHERE user_login=?</passwordSQL>
<passwordType>md5</passwordType>
</jdbcAuthProvider>
<jdbcUserProvider>
<loadUserSQL>SELECT user_nicename,user_email FROM wp_users WHERE user_login=?</loadUserSQL>
<userCountSQL>SELECT COUNT(*) FROM wp_users</userCountSQL>
<allUsersSQL>SELECT user_login FROM wp_users</allUsersSQL>
<searchSQL>SELECT user_login FROM wp_users WHERE</searchSQL>
<usernameField>user_login</usernameField>
<nameField>user_nicename</nameField>
<emailField>user_email</emailField>
</jdbcUserProvider>
</database> <setup>true</setup>
</jive>