Your message dated Mon, 22 Feb 2010 16:46:11 +0000 (WET)
with message-id <[email protected]>
and subject line Package twig has been removed from Debian
has caused the Debian Bug report #305552,
regarding twig: Uses invalid user www-data for PostgreSQL
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
305552: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=305552
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Subject: twig: Uses invalid user www-data for PostgreSQL
Package: twig
Version: 2.7.7-3
Severity: important
When trying to set up Twig to use a Postgres database, the included
scripts imply using the 'www-data' database user - which is not a valid
PostgreSQL user name. Besides, the documentation indicates the suggested
use of the 'nobody' user.
I am attaching here a partial patch, changing the DB user to 'twig'
(after all, different web-based systems running on the same server
need also to be protected from each other IMHO), which allows the
creation scripts to be successfully run. I did not change, however,
the username in the configuration (and will thus be a hurdle for any
user of this package). I would suggest you changing the user also in
the MySQL configuration.
Greetings,
-- System Information:
Debian Release: 3.1
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.10-mosca
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Versions of packages twig depends on:
ii debconf 1.4.48 Debian configuration management sy
ii php4 4:4.3.10-12 server-side, HTML-embedded scripti
ii php4-imap 4:4.3.10-12 IMAP module for php4
ii php4-mysql 4:4.3.10-12 MySQL module for php4
ii php4-pgsql 3:4.3.10-3 PostgreSQL module for php4
-- debconf information:
twig/db-update:
* twig/minimal-setup:
diff -ru twig-2.7.7/debian/README.Debian twig-2.7.7.new/debian/README.Debian
--- twig-2.7.7/debian/README.Debian 2005-04-20 13:29:23.892692848 -0500
+++ twig-2.7.7.new/debian/README.Debian 2005-04-20 13:31:03.766509720 -0500
@@ -36,7 +36,7 @@
Tell Twig that we'll use PostgreSQL. In /etc/twig/dbconfig.inc.php3,
$dbconfig["sqlserver"] = "localhost";
$dbconfig["sqlport"] = "5432";
- $dbconfig["sqlusername"] = "www-data";
+ $dbconfig["sqlusername"] = "twig";
$dbconfig["sqlpassword"] = "yourpassword";
$dbconfig["defaultdb"] = "twig";
$dbconfig["sqltype"] = "pgsql-new";
@@ -52,12 +52,12 @@
Finally, we need to setup the twig database.
~# su - postgres
- ~$ createuser www-data (the user should be able to create db's
+ ~$ createuser twig (the user should be able to create db's
but not new users)
- ~$ psql -d template1 www-data
+ ~$ psql -d template1 twig
template1=# CREATE DATABASE twig;
twig=# \q
- ~$ gunzip -c /usr/share/twig/setup/twig.table.pgsql.gz | psql twig www-data
+ ~$ gunzip -c /usr/share/twig/setup/twig.table.pgsql.gz | psql twig twig
PHP configuration:
We need to enable some PHP extensions needed by Twig. In
diff -ru twig-2.7.7/docs/Setup-pgsql.txt twig-2.7.7.new/docs/Setup-pgsql.txt
--- twig-2.7.7/docs/Setup-pgsql.txt 1999-09-05 00:29:18.000000000 -0500
+++ twig-2.7.7.new/docs/Setup-pgsql.txt 2005-04-20 13:23:15.332722480 -0500
@@ -3,7 +3,7 @@
twig.table.pgsql before doing this if your webserver runs as a
different user:
- (log in as user postgres) createuser nobody
+ (log in as user postgres) createuser twig
(give no privileges, use unix UID)
psql -d template1
create database twig;
diff -ru twig-2.7.7/setup/twig.table.pgsql twig-2.7.7.new/setup/twig.table.pgsql
--- twig-2.7.7/setup/twig.table.pgsql 2005-04-20 13:29:23.891693000 -0500
+++ twig-2.7.7.new/setup/twig.table.pgsql 2005-04-20 13:21:31.122564832
-0500
@@ -530,58 +530,58 @@
CREATE INDEX twig_todo_prefs_username_index ON twig_todo_prefs (username);
-GRANT ALL ON twig_groups TO www-data;
-GRANT ALL ON twig_members TO www-data;
-GRANT ALL ON twig_mail_prefs TO www-data;
-GRANT ALL ON twig_schedule TO www-data;
-GRANT ALL ON twig_todo TO www-data;
-GRANT ALL ON twig_bookmarks TO www-data;
-GRANT ALL ON twig_contacts TO www-data;
-GRANT ALL ON twig_folders TO www-data;
-GRANT ALL ON twig_news_prefs TO www-data;
-GRANT ALL ON twig_accounts TO www-data;
-GRANT ALL ON twig_main_prefs TO www-data;
-GRANT ALL ON twig_global_prefs TO www-data;
-GRANT ALL ON twig_contacts_prefs TO www-data;
-GRANT ALL ON twig_contacts_lists_entries TO www-data;
-GRANT ALL ON twig_bookmarks_prefs TO www-data;
-GRANT ALL ON twig_todo_prefs TO www-data;
-GRANT ALL ON twig_schedule_prefs TO www-data;
-GRANT ALL ON twig_schedule_recurring TO www-data;
-GRANT ALL ON twig_session TO www-data;
-GRANT ALL ON twig_context TO www-data;
-GRANT ALL ON twig_acls TO www-data;
-GRANT ALL ON twig_acl_groups TO www-data;
-GRANT ALL ON twig_notes TO www-data;
-GRANT ALL ON twig_notes_prefs TO www-data;
-GRANT ALL ON twig_lhsqltable TO www-data;
-GRANT ALL ON twig_meetings TO www-data;
-GRANT ALL ON twig_meetings_prefs TO www-data;
-GRANT ALL ON twig_meetings_registration TO www-data;
-GRANT ALL ON twig_sclhsqltable TO www-data;
+GRANT ALL ON twig_groups TO twig;
+GRANT ALL ON twig_members TO twig;
+GRANT ALL ON twig_mail_prefs TO twig;
+GRANT ALL ON twig_schedule TO twig;
+GRANT ALL ON twig_todo TO twig;
+GRANT ALL ON twig_bookmarks TO twig;
+GRANT ALL ON twig_contacts TO twig;
+GRANT ALL ON twig_folders TO twig;
+GRANT ALL ON twig_news_prefs TO twig;
+GRANT ALL ON twig_accounts TO twig;
+GRANT ALL ON twig_main_prefs TO twig;
+GRANT ALL ON twig_global_prefs TO twig;
+GRANT ALL ON twig_contacts_prefs TO twig;
+GRANT ALL ON twig_contacts_lists_entries TO twig;
+GRANT ALL ON twig_bookmarks_prefs TO twig;
+GRANT ALL ON twig_todo_prefs TO twig;
+GRANT ALL ON twig_schedule_prefs TO twig;
+GRANT ALL ON twig_schedule_recurring TO twig;
+GRANT ALL ON twig_session TO twig;
+GRANT ALL ON twig_context TO twig;
+GRANT ALL ON twig_acls TO twig;
+GRANT ALL ON twig_acl_groups TO twig;
+GRANT ALL ON twig_notes TO twig;
+GRANT ALL ON twig_notes_prefs TO twig;
+GRANT ALL ON twig_lhsqltable TO twig;
+GRANT ALL ON twig_meetings TO twig;
+GRANT ALL ON twig_meetings_prefs TO twig;
+GRANT ALL ON twig_meetings_registration TO twig;
+GRANT ALL ON twig_sclhsqltable TO twig;
-GRANT UPDATE ON twaccid TO www-data;
-GRANT UPDATE ON twasid TO www-data;
-GRANT UPDATE ON twanid TO www-data;
-GRANT UPDATE ON twbmid TO www-data;
-GRANT UPDATE ON twbmprf TO www-data;
-GRANT UPDATE ON twconid TO www-data;
-GRANT UPDATE ON twcprf TO www-data;
-GRANT UPDATE ON twfoldid TO www-data;
-GRANT UPDATE ON twgpid TO www-data;
-GRANT UPDATE ON groupid TO www-data;
-GRANT UPDATE ON twprefsid TO www-data;
-GRANT UPDATE ON twmpid TO www-data;
-GRANT UPDATE ON twmeetid TO www-data;
-GRANT UPDATE ON twmeetpid TO www-data;
-GRANT UPDATE ON twmeetrid TO www-data;
-GRANT UPDATE ON twmeetiid TO www-data;
-GRANT UPDATE ON memberid TO www-data;
-GRANT UPDATE ON twnpid TO www-data;
-GRANT UPDATE ON twnoteid TO www-data;
-GRANT UPDATE ON twnotepid TO www-data;
-GRANT UPDATE ON twschedid TO www-data;
-GRANT UPDATE ON twsrecid TO www-data;
-GRANT UPDATE ON twsprf TO www-data;
-GRANT UPDATE ON twtdid TO www-data;
-GRANT UPDATE ON twprf TO www-data;
+GRANT UPDATE ON twaccid TO twig;
+GRANT UPDATE ON twasid TO twig;
+GRANT UPDATE ON twanid TO twig;
+GRANT UPDATE ON twbmid TO twig;
+GRANT UPDATE ON twbmprf TO twig;
+GRANT UPDATE ON twconid TO twig;
+GRANT UPDATE ON twcprf TO twig;
+GRANT UPDATE ON twfoldid TO twig;
+GRANT UPDATE ON twgpid TO twig;
+GRANT UPDATE ON groupid TO twig;
+GRANT UPDATE ON twprefsid TO twig;
+GRANT UPDATE ON twmpid TO twig;
+GRANT UPDATE ON twmeetid TO twig;
+GRANT UPDATE ON twmeetpid TO twig;
+GRANT UPDATE ON twmeetrid TO twig;
+GRANT UPDATE ON twmeetiid TO twig;
+GRANT UPDATE ON memberid TO twig;
+GRANT UPDATE ON twnpid TO twig;
+GRANT UPDATE ON twnoteid TO twig;
+GRANT UPDATE ON twnotepid TO twig;
+GRANT UPDATE ON twschedid TO twig;
+GRANT UPDATE ON twsrecid TO twig;
+GRANT UPDATE ON twsprf TO twig;
+GRANT UPDATE ON twtdid TO twig;
+GRANT UPDATE ON twprf TO twig;
diff -ru twig-2.7.7/setup/upgrade/2.0.0/twig.table-upgrade.pgsql
twig-2.7.7.new/setup/upgrade/2.0.0/twig.table-upgrade.pgsql
--- twig-2.7.7/setup/upgrade/2.0.0/twig.table-upgrade.pgsql 2005-04-20
13:29:23.891693000 -0500
+++ twig-2.7.7.new/setup/upgrade/2.0.0/twig.table-upgrade.pgsql 2005-04-20
13:22:28.650819208 -0500
@@ -160,14 +160,14 @@
PRIMARY KEY (id)
);
-GRANT ALL ON twig_accounts TO www-data;
-GRANT ALL ON twig_acls TO www-data;
-GRANT ALL ON twig_acl_groups TO www-data;
-GRANT ALL ON twig_contacts_prefs TO www-data;
-GRANT ALL ON twig_bookmarks_prefs TO www-data;
-GRANT ALL ON twig_todo_prefs TO www-data;
-GRANT ALL ON twig_schedule_prefs TO www-data;
-GRANT ALL ON twig_session TO www-data;
-GRANT ALL ON twig_context TO www-data;
-GRANT ALL ON twig_global_prefs TO www-data;
-GRANT ALL ON twig_main_prefs TO www-data;
+GRANT ALL ON twig_accounts TO twig;
+GRANT ALL ON twig_acls TO twig;
+GRANT ALL ON twig_acl_groups TO twig;
+GRANT ALL ON twig_contacts_prefs TO twig;
+GRANT ALL ON twig_bookmarks_prefs TO twig;
+GRANT ALL ON twig_todo_prefs TO twig;
+GRANT ALL ON twig_schedule_prefs TO twig;
+GRANT ALL ON twig_session TO twig;
+GRANT ALL ON twig_context TO twig;
+GRANT ALL ON twig_global_prefs TO twig;
+GRANT ALL ON twig_main_prefs TO twig;
diff -ru twig-2.7.7/setup/upgrade/2.6.0/twig.table-upgrade.pgsql
twig-2.7.7.new/setup/upgrade/2.6.0/twig.table-upgrade.pgsql
--- twig-2.7.7/setup/upgrade/2.6.0/twig.table-upgrade.pgsql 2005-04-20
13:29:23.891693000 -0500
+++ twig-2.7.7.new/setup/upgrade/2.6.0/twig.table-upgrade.pgsql 2005-04-20
13:21:56.658682752 -0500
@@ -39,8 +39,8 @@
CREATE INDEX twig_schedule_recurring_endtype_index ON twig_schedule_recurring
(endtype);
CREATE INDEX twig_schedule_recurring_end_index ON twig_schedule_recurring
("end");
-GRANT ALL ON twig_contacts_lists_entries TO www-data;
-GRANT ALL ON twig_schedule_recurring TO www-data;
+GRANT ALL ON twig_contacts_lists_entries TO twig;
+GRANT ALL ON twig_schedule_recurring TO twig;
ALTER TABLE twig_announce RENAME date TO thedate;
diff -ru twig-2.7.7/setup/upgrade/twig.table-upgrade.pgsql
twig-2.7.7.new/setup/upgrade/twig.table-upgrade.pgsql
--- twig-2.7.7/setup/upgrade/twig.table-upgrade.pgsql 2005-04-20
13:29:23.891693000 -0500
+++ twig-2.7.7.new/setup/upgrade/twig.table-upgrade.pgsql 2005-04-20
13:22:38.613304680 -0500
@@ -22,28 +22,28 @@
UPDATE twig_groups SET type='standard' WHERE type='' OR type IS null;
-GRANT UPDATE ON twaccid TO www-data;
-GRANT UPDATE ON twasid TO www-data;
-GRANT UPDATE ON twanid TO www-data;
-GRANT UPDATE ON twbmid TO www-data;
-GRANT UPDATE ON twbmprf TO www-data;
-GRANT UPDATE ON twconid TO www-data;
-GRANT UPDATE ON twcprf TO www-data;
-GRANT UPDATE ON twfoldid TO www-data;
-GRANT UPDATE ON twgpid TO www-data;
-GRANT UPDATE ON groupid TO www-data;
-GRANT UPDATE ON twprefsid TO www-data;
-GRANT UPDATE ON twmpid TO www-data;
-GRANT UPDATE ON twmeetid TO www-data;
-GRANT UPDATE ON twmeetpid TO www-data;
-GRANT UPDATE ON twmeetrid TO www-data;
-GRANT UPDATE ON twmeetiid TO www-data;
-GRANT UPDATE ON memberid TO www-data;
-GRANT UPDATE ON twnpid TO www-data;
-GRANT UPDATE ON twnoteid TO www-data;
-GRANT UPDATE ON twnotepid TO www-data;
-GRANT UPDATE ON twschedid TO www-data;
-GRANT UPDATE ON twsrecid TO www-data;
-GRANT UPDATE ON twsprf TO www-data;
-GRANT UPDATE ON twtdid TO www-data;
-GRANT UPDATE ON twprf TO www-data;
+GRANT UPDATE ON twaccid TO twig;
+GRANT UPDATE ON twasid TO twig;
+GRANT UPDATE ON twanid TO twig;
+GRANT UPDATE ON twbmid TO twig;
+GRANT UPDATE ON twbmprf TO twig;
+GRANT UPDATE ON twconid TO twig;
+GRANT UPDATE ON twcprf TO twig;
+GRANT UPDATE ON twfoldid TO twig;
+GRANT UPDATE ON twgpid TO twig;
+GRANT UPDATE ON groupid TO twig;
+GRANT UPDATE ON twprefsid TO twig;
+GRANT UPDATE ON twmpid TO twig;
+GRANT UPDATE ON twmeetid TO twig;
+GRANT UPDATE ON twmeetpid TO twig;
+GRANT UPDATE ON twmeetrid TO twig;
+GRANT UPDATE ON twmeetiid TO twig;
+GRANT UPDATE ON memberid TO twig;
+GRANT UPDATE ON twnpid TO twig;
+GRANT UPDATE ON twnoteid TO twig;
+GRANT UPDATE ON twnotepid TO twig;
+GRANT UPDATE ON twschedid TO twig;
+GRANT UPDATE ON twsrecid TO twig;
+GRANT UPDATE ON twsprf TO twig;
+GRANT UPDATE ON twtdid TO twig;
+GRANT UPDATE ON twprf TO twig;
--- End Message ---
--- Begin Message ---
Version: 2.8.3-2.3+rm
You filed the bug http://bugs.debian.org/305552 in Debian BTS
against the package twig. I'm closing it at *unstable*, but it will
remain open for older distributions.
For more information about this package's removal, read
http://bugs.debian.org/469237. That bug might give the reasons why
this package was removed and suggestions of possible replacements.
Don't hesitate to reply to this mail if you have any question.
Thank you for your contribution to Debian.
--
Marco Rodrigues
--- End Message ---
