| @@ -1,77 +1,77 @@ | | | @@ -1,77 +1,77 @@ |
1 | =========================================================================== | | 1 | =========================================================================== |
2 | $NetBSD: MESSAGE,v 1.2 2011/11/29 14:51:37 ryoon Exp $ | | 2 | $NetBSD: MESSAGE,v 1.3 2011/12/06 12:41:02 ryoon Exp $ |
3 | | | 3 | |
4 | To use aipo, you will need to perform the following steps. | | 4 | To use aipo, you will need to perform the following steps. |
5 | | | 5 | |
6 | 1. Install postgresq server, for example postgresql84-server, | | 6 | 1. Install postgresql server, for example postgresql84-server, |
7 | and enable it. | | 7 | and enable it. |
8 | | | 8 | |
9 | # cd databases/postgresql84-server | | 9 | # cd databases/postgresql84-server |
10 | # make install | | 10 | # make install |
11 | and follow MESSAGE in databases/postgresql84-server directory. | | 11 | and follow MESSAGE in databases/postgresql84-server directory. |
12 | | | 12 | |
13 | 2. Install apache tomcat server, for example apache-tomcat7 | | 13 | 2. Install apache tomcat server, for example apache-tomcat7 |
14 | | | 14 | |
15 | # cd www/apache-tomcat7 | | 15 | # cd www/apache-tomcat7 |
16 | # make install | | 16 | # make install |
17 | | | 17 | |
18 | 3. Start postgresql server, for example | | 18 | 3. Start postgresql server, for example |
19 | | | 19 | |
20 | # ${RCD_SCRIPTS_DIR}/pgsql start | | 20 | # ${RCD_SCRIPTS_DIR}/pgsql start |
21 | | | 21 | |
22 | 4. Add postgresql user, aipo_pgsql | | 22 | 4. Add postgresql user, aipo_pgsql |
23 | | | 23 | |
24 | $ sudo -u pgsql createuser aipo_pgsql | | 24 | $ sudo -u pgsql createuser aipo_pgsql |
25 | Shall the new role be a superuser? (y/n) y | | 25 | Shall the new role be a superuser? (y/n) y |
26 | | | 26 | |
27 | 5. Set password to aipo_pgsql user | | 27 | 5. Set password to aipo_pgsql user |
28 | | | 28 | |
29 | $ sudo -u pgsql psql template1 | | 29 | $ sudo -u pgsql psql template1 |
30 | psql (8.4.9) | | 30 | psql (8.4.9) |
31 | Type "help" for help. | | 31 | Type "help" for help. |
32 | | | 32 | |
33 | template1=# alter user aipo_pgsql with password 'aipo_db_password'; | | 33 | template1=# alter user aipo_pgsql with password 'aipo_db_password'; |
34 | ALTER ROLE | | 34 | ALTER ROLE |
35 | template1=# \q | | 35 | template1=# \q |
36 | | | 36 | |
37 | 6. Create database fot Aipo | | 37 | 6. Create database fot Aipo |
38 | | | 38 | |
39 | $ sudo -u pgsql createdb org001 -O aipo_pgsql -U aipo_pgsql | | 39 | $ sudo -u pgsql createdb org001 -O aipo_pgsql -U aipo_pgsql |
40 | | | 40 | |
41 | 7. Check created database | | 41 | 7. Check created database |
42 | | | 42 | |
43 | $ sudo -u pgsql psql -l | | 43 | $ sudo -u pgsql psql -l |
44 | List of databases | | 44 | List of databases |
45 | Name | Owner | Encoding | Collation | Ctype | Access privileges | | 45 | Name | Owner | Encoding | Collation | Ctype | Access privileges |
46 | -----------+------------+-----------+-----------+-------+------------------- | | 46 | -----------+------------+-----------+-----------+-------+------------------- |
47 | org001 | aipo_pgsql | SQL_ASCII | C | C | | | 47 | org001 | aipo_pgsql | SQL_ASCII | C | C | |
48 | (snip) | | 48 | (snip) |
49 | | | 49 | |
50 | 8. Initialize Aipo database and inser sample data. | | 50 | 8. Initialize Aipo database and inser sample data. |
51 | | | 51 | |
52 | $ sudo -u pgsql psql -U aipo_pgsql -d org001 -p 5432 -f \ | | 52 | $ sudo -u pgsql psql -U aipo_pgsql -d org001 -p 5432 -f \ |
53 | ${PREFIX}/share/aipo/webapps/aipo/WEB-INF/sql/org001.sql | | 53 | ${PREFIX}/share/aipo/webapps/aipo/WEB-INF/sql/org001.sql |
54 | $ sudo -u pgsql psql -U aipo_pgsql -d org001 -p 5432 -f \ | | 54 | $ sudo -u pgsql psql -U aipo_pgsql -d org001 -p 5432 -f \ |
55 | ${PREFIX}/share/aipo/webapps/aipo/WEB-INF/sql/sample.sql | | 55 | ${PREFIX}/share/aipo/webapps/aipo/WEB-INF/sql/sample.sql |
56 | | | 56 | |
57 | 9. Unlimit database | | 57 | 9. Unlimit database |
58 | | | 58 | |
59 | $ sudo -u pgsql psql -U aipo_pgsql -d org001 -p 5432 \ | | 59 | $ sudo -u pgsql psql -U aipo_pgsql -d org001 -p 5432 \ |
60 | -c "UPDATE AIPO_LICENSE SET LIMIT_USERS=0" | | 60 | -c "UPDATE AIPO_LICENSE SET LIMIT_USERS=0" |
61 | | | 61 | |
62 | 10. Set Aipo location to apache tomcat | | 62 | 10. Set Aipo location to apache tomcat |
63 | $ sudo vi ${PREFIX}/share/tomcat/conf/server.xml | | 63 | $ sudo vi ${PREFIX}/share/tomcat/conf/server.xml |
64 | Add | | 64 | Add |
65 | <Context path="/aipo" docBase="${PREFIX}/share/aipo/webapps/aipo" debug="0" reloadable="true"> | | 65 | <Context path="/aipo" docBase="${PREFIX}/share/aipo/webapps/aipo" debug="0" reloadable="true"> |
66 | </Context> | | 66 | </Context> |
67 | in <Host> tag | | 67 | in <Host> tag |
68 | | | 68 | |
69 | 11. Regenerate securityTokenKey.txt files. | | 69 | 11. Regenerate securityTokenKey.txt files. |
70 | | | 70 | |
71 | $ sudo cat /dev/urandom | tr -dc "a-zA-Z0-9" | fold -w 64 | head -n 1 \ | | 71 | $ sudo cat /dev/urandom | tr -dc "a-zA-Z0-9" | fold -w 64 | head -n 1 \ |
72 | > ${PREFIX}/share/aipo/webapps/aipo/WEB-INF/conf/securityTokenKey.txt | | 72 | > ${PREFIX}/share/aipo/webapps/aipo/WEB-INF/conf/securityTokenKey.txt |
73 | $ sudo cp ${PREFIX}/share/aipo/webapps/aipo/WEB-INF/conf/securityTokenKey.txt \ | | 73 | $ sudo cp ${PREFIX}/share/aipo/webapps/aipo/WEB-INF/conf/securityTokenKey.txt \ |
74 | ${PREFIX}/share/aipo/webapps/ROOT/WEB-INF/classes/aipo/securityTokenKey.txt | | 74 | ${PREFIX}/share/aipo/webapps/ROOT/WEB-INF/classes/aipo/securityTokenKey.txt |
75 | | | 75 | |
76 | 12. Start apache tomcat and access http://localhost:8080/aipo/portal | | 76 | 12. Start apache tomcat and access http://localhost:8080/aipo/portal |
77 | =========================================================================== | | 77 | =========================================================================== |