Changes between Version 24 and Version 25 of InstallationGuidelines/Chat


Ignore:
Timestamp:
07/02/14 15:52:12 (7 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/Chat

    v24 v25  
    8080
    8181
    82 == Custom Db Integration(MYSQl/Postgre SQL) ==
     82== Custom DB Integration ==
    8383
    84 For MYSQL
     84=== MySQL ===
    8585
    86 1) Clean the databases(when in base eden folder) using
     861. 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).
    8787{{{
    88 rm -rf databases/* errors/* uploads/* sessions/*
     88w2p
     89db.auth_user.insert(email="chat_admin@example.com", username="chat_admin_example.com", password="changeme", first_name="Chat")
     90db.commit()
    8991}}}
    9092
    91 2) In models/000_config.py choose database connection settings (use mysql).
     932. Open Openfire console http://servname:7070. Go to System Properties and set the following properties.
    9294
    93 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).
     95Change:
     96* provider.auth.className to org.jivesoftware.openfire.auth.JDBCAuthProvider
     97* provider.user.className to org.jivesoftware.openfire.user.JDBCUserProvider
    9498
    95 4) Install openfire. During installation use mysql and choose the openfire database name.
    96 
    97 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.
     99Add (if some property names are already present modify them to the given values):
    98100* jdbcProvider.driver : com.mysql.jdbc.Driver
    99101* 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
    101102* jdbcAuthProvider.passwordSQL : select password from auth_user where username=?
    102103* jdbcAuthProvider.passwordType : plain
    103 * change provider.user.className to org.jivesoftware.openfire.user.JDBCUserProvider
    104104* jdbcUserProvider.loadUserSQL : select first_name,email from auth_user where username=?
    105105* jdbcUserProvider.userCountSQL : select count(*) from auth_user
    106106* jdbcUserProvider.allUsersSQL : select username from auth_user
    107107* jdbcUserProvider.searchSQL : select username from auth_user where
    108 * jdbcUserProvider.usernameField : username 
     108* jdbcUserProvider.usernameField : username
    109109* jdbcUserProvider.emailField : email
    110110* jdbcUserProvider.nameField : first_name
    111111* admin.authorizedJIDs: choose a username from the user database and put it here e.g. chat_admin_example.com@<servername>
    112112
    113 6) Restart the server
     1133. Restart the Openfire server.
     114{{{
     115sudo /opt/openfire/bin/openfire restart
     116}}}
     117
     118=== PostgreSQL ===
     119
     120tbc