Changes between Version 20 and Version 21 of InstallationGuidelines/Chat

Timestamp:

06/25/14 10:42:02 (11 years ago)

Author:

knowing42

Comment:

--

InstallationGuidelines/Chat

@@ -81 +81 @@
 
 == Custom Db Integration(MYSQl/Postgre SQL) ==
+
+For MYSQL
+
+1) Clean the databases(when in base eden folder) using
+{{{
+rm -rf databases/* errors/* uploads/* sessions/*
+}}}
+
+2) In models/000_config.py choose database connection settings (use mysql).
+
+3) 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).
+
+4) Install openfire. During installation use mysql and choose the openfire database name.
+
+5) After Installation and following steps from above. Go to server properties and set the following properties.
+* jdbcProvider.driver : com.mysql.jdbc.Driver
+* jdbcProvider.connectionString  : jdbc:mysql://localhost/<sahana database name>?user=<sql_username>&password=<sql_password>
+* change provider.auth.className to org.jivesoftware.openfire.auth.JDBCAuthProvider
+* jdbcAuthProvider.passwordSQL : select password from auth_user where username=?
+* jdbcAuthProvider.passwordType : plain
+* change provider.user.className to org.jivesoftware.openfire.user.JDBCUserProvider
+* 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>
+
+6) Restart the server