add debianization scripts based on work by Florent USSEIL

31 files changed, 683 insertions, 0 deletions

diff --git a/debian/README.Debian b/debian/README.Debian
new file mode 100644
index 000000000..a940ad9a8
--- /dev/null
+++ b/debian/README.Debian
@@ -0,0 +1,4 @@
+tt-rss for Debian
+-----------------
+
+ -- Florent USSEIL <[email protected]>  Mon, 31 May 2010 20:58:32 +0100
diff --git a/debian/apache.conf b/debian/apache.conf
new file mode 100644
index 000000000..840fdd999
--- /dev/null
+++ b/debian/apache.conf
@@ -0,0 +1 @@
+Alias /tt-rss /usr/share/tt-rss/www
diff --git a/debian/changelog b/debian/changelog
new file mode 100644
index 000000000..e518cb6fb
--- /dev/null
+++ b/debian/changelog
@@ -0,0 +1,127 @@
+tt-rss (1.5.6-1) unstable; urgency=low
+
+  * Reworked for 1.5.x
+  * Split into three packages: common, mysql, pgsql 
+
+ -- Andrew Dolgov <[email protected]>  Thu, 10 Nov 2011 23:47:21 +0400
+
+tt-rss (1.5.2-1) unstable; urgency=low
+
+  * New upstream
+  * Rework automatic article catchup
+  * Use tmhOAuth instead of twitteroauth for Twitter feeds
+  * Remove or add labels manually through the headline context menu
+  * Bug #300: Wrong URL for cached images
+  * Bug #308: Certain feed URL fails to download working with Tiny Tiny RSS
+  * Bug #310: sanity_config.php includes 'DB_PORT'
+  * Bug #314: https-feeds with authentification fail to download
+  * Bug #315: /mobile version missing feature
+  * Bug #323: Multiple persistent XSS in TT Rss v. 1.50
+  * Bug #325: Can not subscribe to Twitter feeds
+  * Bug #326: MagpieRSS messes up Atom feeds' titles
+  * Feature #285: Feed view layout preference
+  * Feature #304: Search bar
+  * Feature #312: Accessibility request - focus content pane after render
+
+ -- Florent USSEIL <[email protected]>  Wed, 23 Mar 2011 16:39:38 +0100
+
+tt-rss (1.5.1-1) unstable; urgency=low
+
+  * Bugfix release
+  * Bug #279: Feed list escapes special characters incorrectly
+  * Bug #281: Add better PHP sanity checks
+  * Bug #283: Icon path not valid from api
+  * Bug #287: Remove cookie for published feeds
+  * Bug #292: Keyboard shortcut missing
+  * Bug #296: The define of PHP_EXECUTABLE in Update.php is at the wrong place.
+  * Bug #298: \n instead of newline in customized stylesheet
+  * Bug #300: Wrong URL for cached images
+  * Bug #302: When adding a feed, if not logged it, it forgets the feed
+  * Bug #303: RSS URL for published feeds incorrect
+  * Feature #284: feed update timestamp in the UI
+  * Feature #295: Skip login form if ALLOW_REMOTE_USER_AUTH is true
+
+ -- Florent USSEIL <[email protected]>  Sat, 22 Jan 2011 10:14:32 +0100
+
+tt-rss (1.5.0-1) unstable; urgency=low
+
+  * New upstream
+  * Bugfixes :
+  * GeneratedFeeds improvements
+  * Added experimental digest mode (digest.php)
+  * API enhancements
+  * PHP5 with JSON support is now required
+  * Add support for forwarding articles by email
+  * Use HTML5 localStorage for client-side caching
+  * Per-user timezone support
+  * Allow filtering by article tags
+  * Automatically determine feeds from the website URL
+  * Support for feed-to-feed linking has been removed
+  * Support for Google Gears has been removed
+  * Optional full-text search using Sphinx engine
+  * User interface refactored using Dijit framework
+  * Add support for Twitter feeds using OAuth
+  * Make plaintext URLs (e.g. in Twitter feeds) clickable
+
+ -- Florent USSEIL <[email protected]>  Thu, 21 Dec 2010 19:27:32 +0100
+
+tt-rss (1.4.3-1) unstable; urgency=low
+
+  * New upstream
+  * Support import and export of tt-rss settings using OPML (when using DOMDocument import path)
+  * Replace confusing ENABLE_SIMPLEPIE option with DEFAULT_UPDATE_METHOD
+  * Properly deal with stuck child processes in forking update daemon
+  * Feed preferences: add "Subscribe in Tiny Tiny RSS" bookmarklet
+  * Bugfixes :
+  * #269: Add navigation to the mobile view
+
+ -- Florent USSEIL <[email protected]>  Sat, 11 Sep 2010 14:27:32 +0200
+
+tt-rss (1.4.2-1) unstable; urgency=low
+
+  * New upstream
+  * Allow filtering by article author
+  * Bundle new version of php-gettext which should solve translation not working on 64-bit servers
+  * Fix PHP warning in classic mobile mode
+  * Other bugfixes
+
+ -- Florent USSEIL <[email protected]>  Mon, 31 May 2010 20:58:32 +0100
+
+tt-rss (1.4.1-1) unstable; urgency=low
+
+   * New upstream bugfix release.
+   * Bugfixes
+   * Minor interface improvements
+   * Re-added updated compact three-pane theme
+   * Support dock badges in Fluid
+
+ -- Florent USSEIL <[email protected]>  Wed, 21 Apr 2010 23:35:02 +0100
+
+tt-rss (1.3.4) unstable; urgency=low
+  
+   * New upstream bugfix release.
+   * Improved support for Lolcats.
+   * Usability and performance improvements.
+   * Updated translations.
+  
+ -- Florent USSEIL <[email protected]>  Fri, 30 Oct 2009 19:53:02 +0100
+
+tt-rss (1.3.3) unstable; urgency=low
+
+  * New upstream bugfix release.
+
+ -- Florent USSEIL <[email protected]>  Thu, 26 May 2009 21:49:02 +0100
+
+tt-rss (1.3.2) unstable; urgency=low
+
+  * New upstream bugfix release.
+
+ -- Florent USSEIL <[email protected]>  Wed, 1 Apr 2009 19:50:02 +0100
+
+
+tt-rss (1.3.1-1) unstable; urgency=low
+
+  * Initial release
+  * Thanks to Marcelo Jorge Vieira for his 1.2.19 package
+
+ -- Florent USSEIL <[email protected]>  Sat, 28 Feb 2009 14:22:06 +0100
diff --git a/debian/compat b/debian/compat
new file mode 100644
index 000000000..7f8f011eb
--- /dev/null
+++ b/debian/compat
@@ -0,0 +1 @@
+7
diff --git a/debian/config.php-dist-tt-rss-mysql.diff b/debian/config.php-dist-tt-rss-mysql.diff
new file mode 100644
index 000000000..134b21efe
--- /dev/null
+++ b/debian/config.php-dist-tt-rss-mysql.diff
@@ -0,0 +1,38 @@
+--- config.php-dist	2011-11-10 21:25:19.909372305 +0400
++++ config.php-dist.mysql	2011-11-10 23:33:33.049370586 +0400
+@@ -1,10 +1,12 @@
+ <?php
+ 	// Database server configuration
+-	define('DB_TYPE', "pgsql"); // or mysql
+-	define('DB_HOST', "localhost");
+-	define('DB_USER', "fox");
+-	define('DB_NAME', "fox");
+-	define('DB_PASS', "XXXXXX");
++	// dbconfig-common
++	include_once('/etc/tt-rss-mysql/database.php');
++	define('DB_TYPE', $dbtype);
++	define('DB_HOST', $dbserver);
++	define('DB_USER', $dbuser);
++	define('DB_NAME', $dbname);
++	define('DB_PASS', $dbpass);
+ 	//define('DB_PORT', '5432'); // when neeeded, PG-only
+ 
+ 	define('SELF_URL_PATH', 'http://yourserver/tt-rss/');
+@@ -17,7 +19,7 @@
+ 	// Operate in single user mode, disables all functionality related to
+ 	// multiple users.
+ 	
+-	define('CACHE_DIR', 'cache');
++	define('CACHE_DIR', '/var/cache/tt-rss');
+ 	// Local cache directory for RSS feed content.
+ 
+ 	define('SIMPLEPIE_CACHE_IMAGES', false);
+@@ -130,7 +132,7 @@
+ 	// You want new users to be automaticaly created in tt-rss database
+ 	// on first login
+ 
+-	define('LOCK_DIRECTORY', 'lock');
++	define('LOCK_DIRECTORY', '/var/lock/tt-rss');
+ 	// Directory for lockfiles, must be writable to the user you run
+ 	// daemon process or cronjobs under.
+ 
diff --git a/debian/config.php-dist-tt-rss-pgsql.diff b/debian/config.php-dist-tt-rss-pgsql.diff
new file mode 100644
index 000000000..274e69977
--- /dev/null
+++ b/debian/config.php-dist-tt-rss-pgsql.diff
@@ -0,0 +1,38 @@
+--- config.php-dist	2011-11-10 21:25:19.909372305 +0400
++++ config.php-dist.pgsql	2011-11-10 23:34:36.221705504 +0400
+@@ -1,10 +1,12 @@
+ <?php
+ 	// Database server configuration
+-	define('DB_TYPE', "pgsql"); // or mysql
+-	define('DB_HOST', "localhost");
+-	define('DB_USER', "fox");
+-	define('DB_NAME', "fox");
+-	define('DB_PASS', "XXXXXX");
++	// dbconfig-common
++	include_once('/etc/tt-rss-pgsql/database.php');
++	define('DB_TYPE', $dbtype);
++	define('DB_HOST', $dbserver);
++	define('DB_USER', $dbuser);
++	define('DB_NAME', $dbname);
++	define('DB_PASS', $dbpass);
+ 	//define('DB_PORT', '5432'); // when neeeded, PG-only
+ 
+ 	define('SELF_URL_PATH', 'http://yourserver/tt-rss/');
+@@ -17,7 +19,7 @@
+ 	// Operate in single user mode, disables all functionality related to
+ 	// multiple users.
+ 	
+-	define('CACHE_DIR', 'cache');
++	define('CACHE_DIR', '/var/cache/tt-rss');
+ 	// Local cache directory for RSS feed content.
+ 
+ 	define('SIMPLEPIE_CACHE_IMAGES', false);
+@@ -130,7 +132,7 @@
+ 	// You want new users to be automaticaly created in tt-rss database
+ 	// on first login
+ 
+-	define('LOCK_DIRECTORY', 'lock');
++	define('LOCK_DIRECTORY', '/var/lock/tt-rss');
+ 	// Directory for lockfiles, must be writable to the user you run
+ 	// daemon process or cronjobs under.
+ 
diff --git a/debian/control b/debian/control
new file mode 100644
index 000000000..b36eb1fa1
--- /dev/null
+++ b/debian/control
@@ -0,0 +1,32 @@
+Source: tt-rss
+Section: web 
+Priority: extra
+Maintainer: Andrew Dolgov <[email protected]>
+Build-Depends: cdbs, debhelper (>= 7)
+Standards-Version: 3.7.3
+Homepage: http://tt-rss.org/
+
+Package: tt-rss-common
+Architecture: any
+Depends: php5, ${misc:Depends}
+Description: Tiny Tiny RSS is a web-based news feed (RSS/Atom)
+ aggregator, designed to allow you to read news from any location,
+ while feeling as close to a real desktop application as possible.
+
+Package: tt-rss-mysql
+Architecture: any
+Depends: tt-rss-common (= ${source:Version}), php5, php5-mysql, apache2, mysql-server, dbconfig-common, ${misc:Depends}
+Suggests: php-apc
+Conflicts: tt-rss-pgsql
+Description: Tiny Tiny RSS is a web-based news feed (RSS/Atom)
+ aggregator, designed to allow you to read news from any location,
+ while feeling as close to a real desktop application as possible.
+
+Package: tt-rss-pgsql
+Architecture: any
+Depends: tt-rss-common (= ${source:Version}), php5, php5-pgsql, apache2, postgresql, dbconfig-common, ${misc:Depends}
+Suggests: php-apc
+Conflicts: tt-rss-mysql
+Description: Tiny Tiny RSS is a web-based news feed (RSS/Atom)
+ aggregator, designed to allow you to read news from any location,
+ while feeling as close to a real desktop application as possible.
diff --git a/debian/copyright b/debian/copyright
new file mode 100644
index 000000000..16fb7b418
--- /dev/null
+++ b/debian/copyright
@@ -0,0 +1,25 @@
+This package was debianized by Florent USSEIL <[email protected]> on
+Sat, 28 Feb 2009 14:22:06 +0100.
+
+Further extended for newer versions of tt-rss by Andrew Dolgov <[email protected]>
+
+It was downloaded from http://tt-rss.org/ 
+
+Upstream Author(s):
+
+    Andrew Dolgov <[email protected]>
+
+Copyright:
+
+    (c) 2005-2009, Andrew Dolgov
+
+License:
+
+    GPLv2
+    Public License can be found in `/usr/share/common-licenses/GPL-2' 
+
+The Debian packaging is (C) 2009, Florent USSEIL <[email protected]> and
+is licensed under the GPL, see `/usr/share/common-licenses/GPL'.
+
+# Please also look if there are files or directories which have a
+# different copyright/license attached and list them here.
diff --git a/debian/docs b/debian/docs
new file mode 100644
index 000000000..e845566c0
--- /dev/null
+++ b/debian/docs
@@ -0,0 +1 @@
+README
diff --git a/debian/po/POTFILES.in b/debian/po/POTFILES.in
new file mode 100644
index 000000000..4e3028700
--- /dev/null
+++ b/debian/po/POTFILES.in
@@ -0,0 +1 @@
+[type: gettext/rfc822deb] tt-rss-mysql.templates
diff --git a/debian/po/templates.pot b/debian/po/templates.pot
new file mode 100644
index 000000000..bc4c490f3
--- /dev/null
+++ b/debian/po/templates.pot
@@ -0,0 +1,24 @@
+# SOME DESCRIPTIVE TITLE.
+# Copyright (C) YEAR THE PACKAGE'S COPYRIGHT HOLDER
+# This file is distributed under the same license as the PACKAGE package.
+# FIRST AUTHOR <EMAIL@ADDRESS>, YEAR.
+#
+#, fuzzy
+msgid ""
+msgstr ""
+"Project-Id-Version: PACKAGE VERSION\n"
+"Report-Msgid-Bugs-To: [email protected]\n"
+"POT-Creation-Date: 2007-10-03 23:33-0300\n"
+"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
+"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
+"Language-Team: LANGUAGE <[email protected]>\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=CHARSET\n"
+"Content-Transfer-Encoding: 8bit\n"
+
+#. Type: boolean
+#. Description
+#: ../tt-rss.templates:1001 ../tt-rss-mysql.templates:1001
+#: ../tt-rss-pgsql.templates:1001
+msgid "Do you want to configure apache2?"
+msgstr ""
diff --git a/debian/rules b/debian/rules
new file mode 100755
index 000000000..f1abe45c9
--- /dev/null
+++ b/debian/rules
@@ -0,0 +1,25 @@
+#!/usr/bin/make -f
+
+include /usr/share/cdbs/1/rules/debhelper.mk
+include /usr/share/cdbs/1/rules/simple-patchsys.mk
+  
+PACKAGE_MYSQL=tt-rss-mysql
+PACKAGE_PGSQL=tt-rss-pgsql
+
+define install_rule
+	cp debian/$1/usr/share/doc/$1/config.php-dist debian/$1/etc/$1/config.php
+	mkdir -p debian/$1/usr/share/tt-rss/www/
+	ln -sf /etc/$1/config.php debian/$1/usr/share/tt-rss/www/
+	patch debian/$1/etc/$1/config.php < debian/config.php-dist-$1.diff
+endef
+
+binary-install/tt-rss-mysql::
+	$(call install_rule,$(PACKAGE_MYSQL))
+	mkdir -p debian/$(PACKAGE_MYSQL)/usr/share/dbconfig-common/data/$(PACKAGE_MYSQL)/install
+	cp debian/$(PACKAGE_MYSQL)/usr/share/tt-rss/www/schema/ttrss_schema_mysql.sql debian/$(PACKAGE_MYSQL)/usr/share/dbconfig-common/data/$(PACKAGE_MYSQL)/install/mysql
+
+binary-install/tt-rss-pgsql::
+	$(call install_rule,$(PACKAGE_PGSQL))
+	mkdir -p debian/$(PACKAGE_PGSQL)/usr/share/dbconfig-common/data/$(PACKAGE_PGSQL)/install
+	cp debian/$(PACKAGE_PGSQL)/usr/share/tt-rss/www/schema/ttrss_schema_pgsql.sql debian/$(PACKAGE_PGSQL)/usr/share/dbconfig-common/data/$(PACKAGE_PGSQL)/install/pgsql
+
diff --git a/debian/source/format b/debian/source/format
new file mode 100644
index 000000000..163aaf8d8
--- /dev/null
+++ b/debian/source/format
@@ -0,0 +1 @@
+3.0 (quilt)
diff --git a/debian/tt-rss-common.install b/debian/tt-rss-common.install
new file mode 100644
index 000000000..c1ecf2ed0
--- /dev/null
+++ b/debian/tt-rss-common.install
@@ -0,0 +1,15 @@
+*.php usr/share/tt-rss/www/
+*.css usr/share/tt-rss/www/
+*.js usr/share/tt-rss/www/
+*.xsl usr/share/tt-rss/www/
+api	usr/share/tt-rss/www
+help  usr/share/tt-rss/www/
+images usr/share/tt-rss/www/
+lib usr/share/tt-rss/www/
+locale usr/share/tt-rss/www/
+mobile usr/share/tt-rss/www/
+modules usr/share/tt-rss/www/
+templates usr/share/tt-rss/www/
+themes usr/share/tt-rss/www/
+utils usr/share/tt-rss/www/
+
diff --git a/debian/tt-rss-common.postinst b/debian/tt-rss-common.postinst
new file mode 100644
index 000000000..2b455cacb
--- /dev/null
+++ b/debian/tt-rss-common.postinst
@@ -0,0 +1,48 @@
+#!/bin/sh
+set -e
+
+PACKAGE=tt-rss-mysql
+
+case "$1" in
+    configure)
+
+	 	 # source debconf stuff
+	if [ -f /usr/share/debconf/confmodule ]; then
+		. /usr/share/debconf/confmodule
+	fi
+
+
+	echo "create misc folders"
+	if [ ! -d /usr/share/tt-rss/www/icons/ ]; then
+	install -d -m775 -gwww-data /usr/share/tt-rss/www/icons
+	fi
+
+	if [ ! -d /var/lock/tt-rss ]; then
+		install -d -m775 -gwww-data /var/lock/tt-rss
+	fi
+
+	if [ ! -d /var/cache/tt-rss/htmlpurifier ]; then
+		install -d -m775 -gwww-data /var/cache/tt-rss/htmlpurifier
+	fi
+
+	if [ ! -d /var/cache/tt-rss/magpie ]; then
+		install -d -m775 -gwww-data /var/cache/tt-rss/magpie
+	fi
+
+	if [ ! -d /var/cache/tt-rss/simplepie ]; then
+		install -d -m775 -gwww-data /var/cache/tt-rss/simplepie
+	fi
+
+    ;;
+
+    abort-upgrade|abort-remove|abort-deconfigure)
+    ;;
+
+    *)
+        echo "postinst called with unknown argument \`$1'" >&2
+        exit 1
+    ;;
+esac
+
+exit 0
+#DEBHELPER#
diff --git a/debian/tt-rss-common.postrm b/debian/tt-rss-common.postrm
new file mode 100644
index 000000000..c91674def
--- /dev/null
+++ b/debian/tt-rss-common.postrm
@@ -0,0 +1,17 @@
+#!/bin/sh
+set -e
+
+# source debconf stuff
+if [ -f /usr/share/debconf/confmodule ]; then
+	. /usr/share/debconf/confmodule
+fi
+
+
+if [ "$1" = "purge" ]; then
+	rm -rf /usr/share/tt-rss/www/icons
+	rm -rf /var/lock/tt-rss
+	rm -rf /var/cache/tt-rss
+fi
+
+exit 0
+#DEBHELPER#
diff --git a/debian/tt-rss-mysql.config b/debian/tt-rss-mysql.config
new file mode 100644
index 000000000..09b3d3705
--- /dev/null
+++ b/debian/tt-rss-mysql.config
@@ -0,0 +1,18 @@
+#!/bin/sh
+set -e
+
+. /usr/share/debconf/confmodule
+
+PACKAGE=tt-rss-mysql
+
+# restart webserver
+db_input medium $PACKAGE/webserver || true
+db_go || true
+
+# dbconfig-common
+if [ -f /usr/share/dbconfig-common/dpkg/config.mysql ]; then
+	. /usr/share/dbconfig-common/dpkg/config.mysql
+	dbc_first_version="1.3.1"
+	dbc_go $PACKAGE $@
+fi
+
diff --git a/debian/tt-rss-mysql.cron.d b/debian/tt-rss-mysql.cron.d
new file mode 100644
index 000000000..672791bdc
--- /dev/null
+++ b/debian/tt-rss-mysql.cron.d
@@ -0,0 +1,4 @@
+# /etc/cron.d/tt-rss-mysql: crontab fragment for tt-rss-mysql
+#  This update feeds for tiny tiny RSS every 20min 
+
+12,42 *     * * *     www-data	 /usr/bin/wget --output-document=/dev/null --quiet http://localhost/tt-rss/backend.php?op=globalUpdateFeeds&daemon=1
diff --git a/debian/tt-rss-mysql.install b/debian/tt-rss-mysql.install
new file mode 100644
index 000000000..287e5e13e
--- /dev/null
+++ b/debian/tt-rss-mysql.install
@@ -0,0 +1,5 @@
+debian/apache.conf etc/tt-rss-mysql/
+config.php-dist usr/share/doc/tt-rss-mysql/
+schema/ttrss_schema_mysql.sql usr/share/tt-rss/www/schema/
+schema/versions/mysql usr/share/tt-rss/www/schema/versions/
+
diff --git a/debian/tt-rss-mysql.postinst b/debian/tt-rss-mysql.postinst
new file mode 100644
index 000000000..269a9c618
--- /dev/null
+++ b/debian/tt-rss-mysql.postinst
@@ -0,0 +1,56 @@
+#!/bin/sh
+set -e
+
+PACKAGE=tt-rss-mysql
+
+case "$1" in
+    configure)
+
+	# source debconf stuff
+	if [ -f /usr/share/debconf/confmodule ]; then
+		. /usr/share/debconf/confmodule
+	fi
+
+	# debconf messages      
+	db_get $PACKAGE/webserver || true
+	WEBSERVER="$RET";
+
+	# webserver configuration
+	if $WEBSERVER; then
+	        if [ ! -d /etc/apache2/conf.d/ ]; then
+	                install -d -m755 /etc/apache2/conf.d/
+	        fi
+
+	        if [ ! -e /etc/apache2/conf.d/$PACKAGE.conf ]; then
+	                ln -s /etc/$PACKAGE/apache.conf /etc/apache2/conf.d/$PACKAGE.conf
+	                #sed -e "s#tt-rss/www#$PACKAGE/www#" -i /etc/$PACKAGE/apache.conf
+	        fi
+         if apache2ctl configtest 2>/dev/null; then
+                 invoke-rc.d apache2 force-reload || true
+         else
+                 echo "apache need to be reload manualy"
+         fi
+	fi
+	
+	# dbconfig-common
+	. /usr/share/dbconfig-common/dpkg/postinst.mysql
+	dbc_first_version="1.3.1"
+	dbc_generate_include="php:/etc/$PACKAGE/database.php"
+	dbc_generate_include_owner="root:www-data"
+	dbc_generate_include_perms="0640"
+	dbc_go $PACKAGE $@
+
+	echo "Install ok on http://localhost/tt-rss/tt-rss.php"
+    ;;
+
+    abort-upgrade|abort-remove|abort-deconfigure)
+    ;;
+
+    *)
+        echo "postinst called with unknown argument \`$1'" >&2
+        exit 1
+    ;;
+esac
+
+exit 0
+#DEBHELPER#
diff --git a/debian/tt-rss-mysql.postrm b/debian/tt-rss-mysql.postrm
new file mode 100644
index 000000000..93c3a3cd3
--- /dev/null
+++ b/debian/tt-rss-mysql.postrm
@@ -0,0 +1,42 @@
+#!/bin/sh
+set -e
+
+PACKAGE=tt-rss-mysql
+
+# source debconf stuff
+if [ -f /usr/share/debconf/confmodule ]; then
+	. /usr/share/debconf/confmodule
+fi
+
+# Un-configure and restart webservers
+db_get $PACKAGE/webserver || true
+WEBSERVER="$RET";
+if $WEBSERVER; then
+        if [ -L /etc/apache2/conf.d/$PACKAGE.conf ]; then
+                rm -f /etc/apache2/conf.d/$PACKAGE.conf
+        fi
+fi
+
+if apache2ctl configtest 2>/dev/null; then
+        invoke-rc.d apache2 force-reload || true
+else
+        echo "apache need to be manually reloaded"
+fi
+
+# dbconfig-common
+if [ -f /usr/share/dbconfig-common/dpkg/postrm.mysql ]; then
+        . /usr/share/dbconfig-common/dpkg/postrm.mysql
+	dbc_go $PACKAGE $@
+fi
+
+if [ "$1" = "purge" ]; then
+       	# remove database config
+	rm -f /etc/$PACKAGE/database.php
+	if which ucf >/dev/null 2>&1; then
+		ucf --purge /etc/$PACKAGE/database.php
+	fi
+	db_purge
+fi
+
+exit 0
+#DEBHELPER#
diff --git a/debian/tt-rss-mysql.prerm b/debian/tt-rss-mysql.prerm
new file mode 100644
index 000000000..1c2790fe6
--- /dev/null
+++ b/debian/tt-rss-mysql.prerm
@@ -0,0 +1,13 @@
+#!/bin/sh
+set -e
+
+PACKAGE=tt-rss-mysql
+
+# source debconf stuff
+. /usr/share/debconf/confmodule
+
+. /usr/share/dbconfig-common/dpkg/prerm.mysql
+dbc_go $PACKAGE $@
+
+exit 0
+#DEBHELPER#
diff --git a/debian/tt-rss-mysql.templates b/debian/tt-rss-mysql.templates
new file mode 100644
index 000000000..b580704af
--- /dev/null
+++ b/debian/tt-rss-mysql.templates
@@ -0,0 +1,3 @@
+Template: tt-rss-mysql/webserver
+Type: boolean
+_Description: Do you want to configure apache2?
diff --git a/debian/tt-rss-pgsql.config b/debian/tt-rss-pgsql.config
new file mode 100644
index 000000000..66dbafeaf
--- /dev/null
+++ b/debian/tt-rss-pgsql.config
@@ -0,0 +1,18 @@
+#!/bin/sh
+set -e
+
+. /usr/share/debconf/confmodule
+
+PACKAGE=tt-rss-pgsql
+
+# restart webserver
+db_input medium $PACKAGE/webserver || true
+db_go || true
+
+# dbconfig-common
+if [ -f /usr/share/dbconfig-common/dpkg/config.pgsql ]; then
+	. /usr/share/dbconfig-common/dpkg/config.pgsql
+	dbc_first_version="1.3.1"
+	dbc_go $PACKAGE $@
+fi
+
diff --git a/debian/tt-rss-pgsql.cron.d b/debian/tt-rss-pgsql.cron.d
new file mode 100644
index 000000000..e03991482
--- /dev/null
+++ b/debian/tt-rss-pgsql.cron.d
@@ -0,0 +1,4 @@
+# /etc/cron.d/tt-rss-pgsql: crontab fragment for tt-rss-pgsql
+#  This update feeds for tiny tiny RSS every 20min 
+
+12,42 *     * * *     www-data  /usr/bin/wget --output-document=/dev/null --quiet http://localhost/tt-rss/backend.php?op=globalUpdateFeeds&daemon=1
diff --git a/debian/tt-rss-pgsql.install b/debian/tt-rss-pgsql.install
new file mode 100644
index 000000000..64304e8fe
--- /dev/null
+++ b/debian/tt-rss-pgsql.install
@@ -0,0 +1,5 @@
+debian/apache.conf etc/tt-rss-pgsql/
+config.php-dist usr/share/doc/tt-rss-pgsql/
+schema/ttrss_schema_pgsql.sql usr/share/tt-rss/www/schema/
+schema/versions/pgsql usr/share/tt-rss/www/schema/versions/
+
diff --git a/debian/tt-rss-pgsql.postinst b/debian/tt-rss-pgsql.postinst
new file mode 100644
index 000000000..7a0332779
--- /dev/null
+++ b/debian/tt-rss-pgsql.postinst
@@ -0,0 +1,57 @@
+#!/bin/sh
+set -e
+
+PACKAGE=tt-rss-pgsql
+
+case "$1" in
+    configure)
+
+	# source debconf stuff
+	if [ -f /usr/share/debconf/confmodule ]; then
+		. /usr/share/debconf/confmodule
+	fi
+
+	# debconf messages      
+	db_get $PACKAGE/webserver || true
+	WEBSERVER="$RET";
+
+	# webserver configuration
+	if $WEBSERVER; then
+	        if [ ! -d /etc/apache2/conf.d/ ]; then
+	                install -d -m755 /etc/apache2/conf.d/
+	        fi
+
+	        if [ ! -e /etc/apache2/conf.d/$PACKAGE.conf ]; then
+	                ln -s /etc/$PACKAGE/apache.conf /etc/apache2/conf.d/$PACKAGE.conf
+	                #sed -e "s#tt-rss/www#$PACKAGE/www#" -i /etc/$PACKAGE/apache.conf
+	        fi
+         if apache2ctl configtest 2>/dev/null; then
+                 invoke-rc.d apache2 force-reload || true
+         else
+                 echo "apache need to be reload manualy"
+         fi
+	fi
+	
+	# dbconfig-common
+	. /usr/share/dbconfig-common/dpkg/postinst.pgsql
+	dbc_first_version="1.3.1"
+	dbc_generate_include="php:/etc/$PACKAGE/database.php"
+	dbc_generate_include_owner="root:www-data"
+	dbc_generate_include_perms="0640"
+	dbc_go $PACKAGE $@
+
+	echo "Install ok on http://localhost/tt-rss/tt-rss.php"
+    ;;
+
+    abort-upgrade|abort-remove|abort-deconfigure)
+    ;;
+
+    *)
+        echo "postinst called with unknown argument \`$1'" >&2
+        exit 1
+    ;;
+esac
+
+exit 0
+
+#DEBHELPER#
diff --git a/debian/tt-rss-pgsql.postrm b/debian/tt-rss-pgsql.postrm
new file mode 100644
index 000000000..85e43a283
--- /dev/null
+++ b/debian/tt-rss-pgsql.postrm
@@ -0,0 +1,42 @@
+#!/bin/sh
+set -e
+
+PACKAGE=tt-rss-pgsql
+
+# source debconf stuff
+if [ -f /usr/share/debconf/confmodule ]; then
+	. /usr/share/debconf/confmodule
+fi
+
+# Un-configure and restart webservers
+db_get $PACKAGE/webserver || true
+WEBSERVER="$RET";
+if $WEBSERVER; then
+        if [ -L /etc/apache2/conf.d/$PACKAGE.conf ]; then
+                rm -f /etc/apache2/conf.d/$PACKAGE.conf
+        fi
+fi
+
+if apache2ctl configtest 2>/dev/null; then
+        invoke-rc.d apache2 force-reload || true
+else
+        echo "apache need to be manually reloaded"
+fi
+
+# dbconfig-common
+if [ -f /usr/share/dbconfig-common/dpkg/postrm.pgsql ]; then
+        . /usr/share/dbconfig-common/dpkg/postrm.pgsql
+	dbc_go $PACKAGE $@
+fi
+
+if [ "$1" = "purge" ]; then
+       	# remove database config
+	rm -f /etc/$PACKAGE/database.php
+	if which ucf >/dev/null 2>&1; then
+		ucf --purge /etc/$PACKAGE/database.php
+	fi
+	db_purge
+fi
+
+exit 0
+#DEBHELPER#
diff --git a/debian/tt-rss-pgsql.prerm b/debian/tt-rss-pgsql.prerm
new file mode 100644
index 000000000..f5c177874
--- /dev/null
+++ b/debian/tt-rss-pgsql.prerm
@@ -0,0 +1,13 @@
+#!/bin/sh
+set -e
+
+PACKAGE=tt-rss-pgsql
+
+# source debconf stuff
+. /usr/share/debconf/confmodule
+
+. /usr/share/dbconfig-common/dpkg/prerm.pgsql
+dbc_go $PACKAGE $@
+
+exit 0
+#DEBHELPER#
diff --git a/debian/tt-rss-pgsql.templates b/debian/tt-rss-pgsql.templates
new file mode 100644
index 000000000..64033be65
--- /dev/null
+++ b/debian/tt-rss-pgsql.templates
@@ -0,0 +1,3 @@
+Template: tt-rss-pgsql/webserver
+Type: boolean
+_Description: Do you want to configure apache2?
diff --git a/debian/watch b/debian/watch
new file mode 100644
index 000000000..0c87b1140
--- /dev/null
+++ b/debian/watch
@@ -0,0 +1,2 @@
+version=3
+http://tt-rss.org/download/tt-rss-(.*)\.tar.gz