===========================================================================
$NetBSD: MESSAGE,v 1.5 2015/06/24 19:56:28 ryoon Exp $
To use aipo, you will need to perform the following steps.
1. Install postgresql server, for example postgresql93-server,
and enable it.
# cd databases/postgresql93-server
# make install
and follow MESSAGE in databases/postgresql93-server directory.
2. Install apache tomcat server, for example apache-tomcat7
# cd www/apache-tomcat7
# make install
3. Start postgresql server, for example
# ${RCD_SCRIPTS_DIR}/pgsql start
4. Add postgresql user, aipo_pgsql
$ sudo -u pgsql createuser aipo_pgsql
Shall the new role be a superuser? (y/n) y
5. Set password to aipo_pgsql user
$ sudo -u pgsql psql template1
psql (9.3.9)
Type "help" for help.
template1=# alter user aipo_pgsql with password 'aipo_db_password';
ALTER ROLE
template1=# \q
6. Create database fot Aipo
$ sudo -u pgsql createdb org001 -O aipo_pgsql
7. Check created database
$ sudo -u pgsql psql -l
List of databases
Name | Owner | Encoding | Collation | Ctype | Access privileges
-----------+------------+-----------+-----------+-------+-------------------
org001 | aipo_pgsql | SQL_ASCII | C | C |
(snip)
8. Initialize Aipo database and inser sample data.
$ sudo -u pgsql psql -U aipo_pgsql -d org001 -p 5432 -f \
${PREFIX}/share/aipo/sql/org001.sql
9. Unlimit database
$ sudo -u pgsql psql -U aipo_pgsql -d org001 -p 5432 \
-c "UPDATE AIPO_LICENSE SET LIMIT_USERS=0"
10. Set Aipo location to apache tomcat
$ sudo vi ${PREFIX}/share/tomcat/conf/server.xml
Add
in tag
11. Regenerate securityTokenKey.txt files.
$ sudo cat /dev/urandom | tr -dc "a-zA-Z0-9" | fold -w 64 | head -n 1 \
> ${PREFIX}/share/aipo/ROOT/WEB-INF/conf/securityTokenKey.txt
12. Start apache tomcat and access http://localhost:8080/aipo/
Default username/password are admin/admin.
===========================================================================