Requirements:
Apache 1.3.23+
PHP 4.2.+
MySQL 3.23.xx or PostgreSQL 7.3

UMA Installation and Configuration 

PostgreSQL
1. Create database: createdb DATABASE_NAME
2. Create user to connect to the database: createuser -A -D -P DATABASE_USER
3. Enter password and confirm password when asked.
4. Load the PostgreSQL schema located in the sql installation directory: 
   psql DATABASE_NAME < sql/uma.pgsql
5. Connect to the new database: psql DATABASE_NAME
6. Execute this SQL statement: 
GRANT ALL PRIVILEGES ON 
uma_challenge, uma_challenge_id_seq, uma_client, uma_client_id_seq, 
uma_client_service, uma_client_service_id_seq, uma_client_service_permission, 
uma_client_service_permission_id_seq, uma_service_entity, 
uma_service_entity_id_seq to DATABASE_USER; 

Create Admin User by issuing the following SQL statements.
INSERT INTO uma_client (username, password) values('USERNAME', 'PASSWORD');
INSERT INTO uma_client_service_permission (service, username, permission) 
VALUES ('Uma', 'USERNAME', '99');
7. Edit conf/config-pgsql.php and enter the correct database name, username,
and password.
8. Login to administrative tool: http://localhost/uma/pgsql/


MySQL
1. Create database: mysqladmin create DATABASE_NAME
2. Connect to mysql database: mysql mysql 
3. Create user with permissions to : 
GRANT ALL PRIVILEGES ON DATABASE_NAME.* 
TO DATABASE_USER@localhost IDENTIFIED BY 'DATABASE_USER_PASSWORD';

Create Admin User
INSERT INTO uma_client (username, password) values('USERNAME', 'PASSWORD');
INSERT INTO uma_client_service_permission (service_id, user_id, permission) 
VALUES (1, 2, 99);
4. Edit conf/config-mysql.php
5. Login to administrative tool: http://localhost/uma/mysql/


Have a good day,
Halo
Lead Developer / Project Maintainer
halo@halosrealm.com
http://uma.halosrealm.com
http://halosrealm.com
