Changes between Version 24 and Version 25 of InstallationGuidelines/Chat

Timestamp:

07/02/14 15:52:12 (11 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/Chat

@@ -80 +80 @@
 
 
-== Custom Db Integration(MYSQl/Postgre SQL) ==
+== Custom DB Integration ==
 
-For MYSQL
+=== MySQL ===
 
-1) Clean the databases(when in base eden folder) using
+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).
 {{{
-rm -rf databases/* errors/* uploads/* sessions/*
+w2p
+db.auth_user.insert(email="chat_admin@example.com", username="chat_admin_example.com", password="changeme", first_name="Chat")
+db.commit()
 }}}
 
-2) In models/000_config.py choose database connection settings (use mysql).
+2. Open Openfire console http://servname:7070. Go to System Properties and set the following properties.
 
-3) In the sql table of auth_user add a user with email "chat_admin [at] example.com" , username "chat_admin_example.com" and password of your choice(having alphanumeric characters).
+Change:
+* provider.auth.className to org.jivesoftware.openfire.auth.JDBCAuthProvider
+* provider.user.className to org.jivesoftware.openfire.user.JDBCUserProvider
 
-4) Install openfire. During installation use mysql and choose the openfire database name.
-
-5) After Installation and following steps from above. Go to system properties and set the following properties.If some property names are already present modify them to the given values.
+Add (if some property names are already present modify them to the given values):
 * 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.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
+3. Restart the Openfire server.
+{{{
+sudo /opt/openfire/bin/openfire restart
+}}}
+
+=== PostgreSQL ===
+
+tbc