Installation instructions

[ Database ] [ Application Server ] [ Download/Install CeQ Application ] [ Launch the Community Equity application ]

Database

On your mysql database instance, create a new database and a user:

bash: mysql -u root -p
mysql> CREATE DATABASE ceq CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql> CREATE USER 'ceq'@'localhost' IDENTIFIED BY '$ceq';
mysql> GRANT ALL PRIVILEGES ON ceq.* TO 'ceq'@'localhost';
mysql> FLUSH PRIVILEGES;
mysql> exit

Application Server

1. We are using Glassfish 2.1. Download from https://glassfish.dev.java.net/downloads/v2.1-b60e.html and follow the setup instructions on that page.

Note: Please check asenv.conf if AS_JAVA="/System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Home" is set to Java 1.6.x

2. After setup is complete, install the JDBC driver for MySQL. Download the driver from http://dev.mysql.com/downloads/connector/j/5.1.html and copy it to <glassfish-root>/domains/domain1/lib/ext - assuming that you intend to use domain1 as your development domain.

3. Log in to the admin console. The console is normally running on port 4848, i.e. http://localhost:4848. The default user is admin with a password of adminadmin.

3.1 Under Resources, add a new JDBC Connection Pool for MySQL. The name of the connection pool is arbitrary, for example, you can name it ceqm for CEQ-MySQL. Chosse a resource type of javax.sql.datasource, accept the default settings and provide information on the connection URL, database name, user name and password for your MySQL database, so the updated resources are:

Url (like: jdbc:mysql://localhost:3306/ceq?useUnicode=true&characterEncoding=UTF-8)
User (like: ceq)
Password (like: $ceq)

3.2 Ping the database to test if the connection pool has been set up correctly.

3.3 Create a new JDBC Ressource named jdbc/ceq using the connection pool you have defined in the previous step.

3.4 Create JNDI CEQ Config Resource

just use the default configuration

JNDI-Name: ceqconfig
ResourceType: java.lang.String
FactoryClass: org.apache.naming.BeanFactory
Description: Configuration for CEQ

Default

JNDI Key	Default Value	Required For Authentication	Description
authentication_module	noauth		Which authentication module should be used. Currently there are "noauth","opensso","cwp".
noauth_user_key	admin	noauth	Person Key used for login when the authentication method is set to "noauth"
admins_group	admins	Both	Key of the Usergroup which all Administrators are part of
debug	false	Both	enables/disables debug outputs in the ceq-ws
user_default_usergroup_key	allusers	Both	Usergroup Key of the group all users should be part of
default_usergroup_acr	READ	Both	Default Accessrights between new persons and the default user group (can be READ, WRITE, ADMIN)
anonymous_user_allowed	true		allow web service access without authentication, do not force login
anonymous_user_key	anonymous		anonymous user is mapped to this ceq user id

External authentication

JNDI Key	Default Value	Required For Authentication	Description
auth_keys_surname	sn	Both	User Attribute to use for surname Defaults: OpenSSO=sn, CWP=SURNAME
auth_keys_givenname	givenname	Both	User Attribute to use for givenname Defaults: OpenSSO=givenname, CWP=FIRSTNAME
login_timeout	5	Both	login timeout in minutes
auth_keys_email	mail	Both	User Attribute to use for email address Defaults: OpenSSO=mail, CWP=EMAIL
opensso_url	https://ce20-webservice.sunsolutioncenter.de/opensso	OpenSSO	URL where the OpenSSO service is running
opensso_url_login	opensso_url + /UI/Login	OpenSSO	Login page for OpenSSO
opensso_url_logout	opensso_url + /UI/Logout	OpenSSO	Logout page for OpenSSO
opensso_url_service	opensso_url	OpenSSO	Service URL (Should always be base context path of the OpenSSO installation
opensso_cookiename	iPlanetDirectoryPro	OpenSSO	Name of the cookie created by OpenSSO
cwp_url	https://identity-tst.sun.com	CWP	CWP Main URL
cwp_url_login	cwp_url + /amserver/UI/Login/?org=self_registered_users	CWP	CWP Login URL (Automatically set if cwp_url is defined)
cwp_url_logout	cwp_url + /amserver/UI/Logout	CWP	CWP Logout URL (Automatically set if cwp_url is defined)
cwp_url_service	http://identity-tst.sun.com:20443/cwpidws/cwpidws	CWP	CWP Service URL
cwp_cookiename	CWP_SESSION	CWP	Name of the cookie created by CWP

Applications

Facebook.

JNDI Key	Default Value
facebook_apikey	none (blank)	API Key of a Facebook application used to access a user's [activity streams].
facebook_appid	none (blank)	Application Identifier (appid) of a Facebook application used to access a user's [activity streams].
facebook_appsecret	none (blank)	Application Secret (appsecret) of a Facebook application used to access a user's [activity streams].

Download/Install CeQ Application

Download the Community Equity ear file
unzip file

Deploy the ceq EAR project onto the configured application server.
Start the application server
Create database schema
1. Download database initialization script for MySQL 5
2. bash: mysql -u ceq -p <passwd> <../mysql_5.sql
launch the overview page http://localhost:8080/ceq-docs
Create demo data by clicking on the menu item under the Testing menu

Launch the Community Equity application

following the instruction on the overview page