This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 176504 - Can't unsubscribe from mailing list
Summary: Can't unsubscribe from mailing list
Status: VERIFIED FIXED
Alias: None
Product: www
Classification: Unclassified
Component: Admin (show other bugs)
Version: 6.x
Hardware: PC Linux
: P1 normal (vote)
Assignee: Admins
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-11-11 04:05 UTC by Petr Blaha
Modified: 2009-11-12 01:39 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Petr Blaha 2009-11-11 04:05:49 UTC
I can't un subscribe from mailing list, see:

1) check my subscription in sympadb:
mysql> select robot_subscriber,list_subscriber, user_subscriber from subscriber_table where robot_subscriber = 'db.netbeans.org' and list_subscriber = 'issues' and user_subscriber = 'petr.blaha@sun.com';
+------------------+-----------------+--------------------+
| robot_subscriber | list_subscriber | user_subscriber    |
+------------------+-----------------+--------------------+
| db.netbeans.org  | issues          | petr.blaha@sun.com |
+------------------+-----------------+--------------------+
1 row in set (0.00 sec)

2) send unsubscribe message:
Message-ID: <4AF972BF.1030603@sun.com>
Date: Tue, 10 Nov 2009 15:03:43 +0100
From: Petr Blaha <petr.blaha@sun.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: sympa@db.netbeans.org
Subject: unsubscribe issues
References: <4AF938DA.5050800@sun.com>
In-Reply-To: <4AF938DA.5050800@sun.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

3) get reponse and reply:
Return-path: <issues-owner@db.netbeans.org>
......
Received: from mail02.netbeans.org ([127.0.0.1])
 by localhost (nbxmlm01z1    network.org [127.0.0.1]) (amavisd-new, port 10025)
 with ESMTP    id UBb1S7Sel-Xv for <petr.blaha@sun.com>; Tue,
 10 Nov 2009 14:04:14 +0000 (GMT)
Received: by mail02.netbeans.org (Postfix, from userid 60005)
    id C7EE6110836; Tue, 10 Nov 2009 14:04:14 +0000 (GMT)
Date: Tue, 10 Nov 2009 14:04:14 +0000 (GMT)
From: SYMPA <sympa@db.netbeans.org>
Subject: auth 30aefd99 signoff issues petr.blaha@sun.com
Sender: issues-owner@db.netbeans.org
To: Petr.Blaha@Sun.COM
Message-id: <20091110140414.C7EE6110836@mail02.netbeans.org>
MIME-version: 1.0
X-Mailer: Sympa 5.3.3
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
X-PMX-Version: 5.4.1.325704
X-Brightmail-Tracker: AAAAAA==
X-Virus-Scanned: amavisd-new at network.org
X-Antispam: No, score=0.0/5.0, scanned in 0.547sec at (localhost [127.0.0.1])
    by smf-spamd v1.3.1 - http://smfs.sf.net/

  You asked for your e-mail address to be removed from list 'issues'.
If you want this action to be taken, please

- reply to this mail
OR
- send a message to sympa@db.netbeans.org with subject
 auth 30aefd99 signoff issues petr.blaha@sun.com
OR
- hit the following mailto mailto:sympa@db.netbeans.org?subject=auth%2030aefd99%20signoff%20issues%20petr.blaha%40sun.com

If you do not want this action to be taken, you can safely ignore this message.

4) get error message:
From: SYMPA <sympa@db.netbeans.org>
Subject: Results of your commands
Sender: sympa-request@db.netbeans.org
To: Petr.Blaha@Sun.COM
Message-id: <20091110140549.03E97110D35@mail02.netbeans.org>
MIME-version: 1.0
X-Mailer: Sympa 5.3.3
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
X-Loop: sympa@db.netbeans.org
X-PMX-Version: 5.4.1.325704
X-Brightmail-Tracker: AAAAAA==
X-Virus-Scanned: amavisd-new at network.org


Command has failed :

> signoff issues petr.blaha@sun.com
  Your e-mail address petr.blaha@sun.com has not been found in the list issues. Maybe
you subscribed from a different e-mail address ?

5) check database:
mysql> select robot_subscriber,list_subscriber, user_subscriber from subscriber_table where robot_subscriber = 'db.netbeans.org' and list_subscriber = 'issues' and user_subscriber = 'Petr.Blaha@Sun.COM';
+------------------+-----------------+--------------------+
| robot_subscriber | list_subscriber | user_subscriber    |
+------------------+-----------------+--------------------+
| db.netbeans.org  | issues          | petr.blaha@sun.com |
+------------------+-----------------+--------------------+
1 row in set (0.00 sec)

It seems that Petr.Blaha@Sun.COM address is used instead of petr.blaha@sun.com that is stored in database or address in first e-mail.
Comment 1 Petr Blaha 2009-11-11 12:12:28 UTC
Bug reported in KENAI http://kenai.com/jira/browse/KENAI-1597
Comment 2 Marco Walther 2009-11-11 21:10:52 UTC
It looks like there was a problem with the migration of the subscriber data:-(
The subscribed_subscriber flag in the was left at NULL. So sympa got somewhat confused about the unsubscribe request.

That should be fixed now.
Comment 3 Petr Blaha 2009-11-12 01:39:27 UTC
Verified with issues@xml mailing list.