Changes between Version 32 and Version 33 of InstallationGuidelines/Chat

Timestamp:

08/18/14 11:34:11 (11 years ago)

Author:

knowing42

Comment:

--

InstallationGuidelines/Chat

@@ -140 +140 @@
 
 === PostgreSQL ===
+=== MySQL ===
+
+1. In the sql table of auth_user add a user with email "chat_admin@example.com" , username "chat_admin_example.com" and password of your choice(having alphanumeric characters).
+{{{
+w2p
+db.auth_user.insert(email="chat_admin@example.com", username="chat_admin_example.com", password="changeme", first_name="Chat")
+db.commit()
+}}}
+
+2. Open Openfire console http://servname:7070. Go to System Properties and set the following properties.
+
+Change:
+* provider.auth.className to org.jivesoftware.openfire.auth.JDBCAuthProvider
+* provider.user.className to org.jivesoftware.openfire.user.JDBCUserProvider
+
+Add (if some property names are already present modify them to the given values):
+* jdbcProvider.driver : org.postgresql.Driver
+* jdbcProvider.connectionString  : jdbc:postgresql://localhost:5432/<sahana database name>?user=<sql_username>&password=<sql_password>
+* jdbcAuthProvider.passwordSQL : select password from auth_user where username=?
+* jdbcAuthProvider.passwordType : plain
+* jdbcUserProvider.loadUserSQL : select first_name,email from auth_user where username=?
+* jdbcUserProvider.userCountSQL : select count(*) from auth_user
+* jdbcUserProvider.allUsersSQL : select username from auth_user
+* jdbcUserProvider.searchSQL : select username from auth_user where
+* jdbcUserProvider.usernameField : username
+* jdbcUserProvider.emailField : email
+* jdbcUserProvider.nameField : first_name
+* admin.authorizedJIDs: choose a username from the user database and put it here e.g. chat_admin_example.com@<servername>
+
+3. Restart the Openfire server.
+{{{
+sudo /opt/openfire/bin/openfire restart
+}}}
 
 tbc