Changes between Version 20 and Version 21 of InstallationGuidelines/Chat


Ignore:
Timestamp:
06/25/14 10:42:02 (7 years ago)
Author:
knowing42
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/Chat

    v20 v21  
    8181
    8282== Custom Db Integration(MYSQl/Postgre SQL) ==
     83
     84For MYSQL
     85
     861) Clean the databases(when in base eden folder) using
     87{{{
     88rm -rf databases/* errors/* uploads/* sessions/*
     89}}}
     90
     912) In models/000_config.py choose database connection settings (use mysql).
     92
     933) 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).
     94
     954) Install openfire. During installation use mysql and choose the openfire database name.
     96
     975) After Installation and following steps from above. Go to server properties and set the following properties.
     98* jdbcProvider.driver : com.mysql.jdbc.Driver
     99* jdbcProvider.connectionString  : jdbc:mysql://localhost/<sahana database name>?user=<sql_username>&password=<sql_password>
     100* change provider.auth.className to org.jivesoftware.openfire.auth.JDBCAuthProvider
     101* jdbcAuthProvider.passwordSQL : select password from auth_user where username=?
     102* jdbcAuthProvider.passwordType : plain
     103* change provider.user.className to org.jivesoftware.openfire.user.JDBCUserProvider
     104* jdbcUserProvider.loadUserSQL : select first_name,email from auth_user where username=?
     105* jdbcUserProvider.userCountSQL : select count(*) from auth_user
     106* jdbcUserProvider.allUsersSQL : select username from auth_user
     107* jdbcUserProvider.searchSQL : select username from auth_user where
     108* jdbcUserProvider.usernameField : username
     109* jdbcUserProvider.emailField : email
     110* jdbcUserProvider.nameField : first_name
     111* admin.authorizedJIDs: choose a username from the user database and put it here e.g. chat_admin_example.com@<servername>
     112
     1136) Restart the server