=========================================================================== $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 DirectoryIndex index.php Options All Allow from All AllowOverride All Require all granted 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". ===========================================================================