blob: 5f5b008811f208392936abaeb932f933d89b6f2d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
===========================================================================
$NetBSD: MESSAGE,v 1.4 2013/06/09 04:24:11 ryoon Exp $
To use php-tt-rss with Apache 2.4 and php 5.4, you will need to perform
the following steps.
1. Install www/apache24 and www/ap-php
2. Install PostgreSQL database server.
# cd databases/postgresql91-server
# make install
3. Start PostgreSQL server.
# ${RCD_SCRIPTS_DIR}/pgsql start
4. Add PostgreSQL user, ttrss
$ createuser -U pgsql ttrss
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n
5. Set password for ttrss user
$ psql -U pgsql template1
psql (9.1.7)
Type "help" for help.
template1=# alter user ttrss with password 'ttrss_user_password';
ALTER ROLE
template1=# \q
6. Create database for ttrss, ttrss_db
$ createdb ttrss_db -O ttrss -U ttrss
7. Check created database
$ psql -U pgsql -l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-------+-----------+---------+-------+-------------------
(snip)
ttrss_db | ttrss | SQL_ASCII | C | C |
8. Initialize database
$ psql -U ttrss -d ttrss_db -p 5432 -f \
${PREFIX}/share/tt-rss/schema/ttrss_schema_pgsql.sql
9. Be sure to have the following lines in ${PREFIX}/etc/php.ini.
extension=dom.so
extension=iconv.so
extension=json.so
extension=mbstring.so
extension=pgsql.so
8. Be sure to have the following lines in ${PREFIX}/etc/httpd/httpd.conf
DocumentRoot "${PREFIX}/share/tt-rss"
LoadModule php5_module lib/httpd/mod_php5.so
AddType application/x-httpd-php .php
<Directory "${PREFIX}/share/tt-rss">
DirectoryIndex index.php
Options All
Allow from All
AllowOverride All
Require all granted
</Directory>
9. Edit ${PREFIX}/share/tt-rss/config.php, be sure to have the following
lines.
define('DB_TYPE', "pgsql");
define('DB_HOST', "localhost");
define('DB_USER', "ttrss");
define('DB_NAME', "ttrss_db");
define('DB_PASS', "ttrss_user_password");
define('SELF_URL_PATH', 'http://localhost/');
10. Start Apache httpd 2.4
# ${RCD_SCRIPTS_DIR}/apache start
11. Access http://localhost/ , and login with
login/password = "admin"/"password".
===========================================================================
|
