Ticket #325 (closed defect: fixed)

Opened 10 years ago

Last modified 8 years ago

impossible de créer un compte pop avec le même nom qu'un ancien compte supprimé

Reported by: anarcat Owned by: anarcat
Priority: high Milestone: alternc-0.9.3
Component: Autres Version: mailman-1.5
Severity: crash Keywords:
Cc:

Description

j'ai foiré en essayant de régler un bug dans m_mail.php, et j'ai donc créé le bug suivant:

voilà le message d'erreur lors de la création du compte.

Database error: Invalid SQL: INSERT INTO mail_users (uid,alias,path,password) VALUES ('2007','joe_societecivile.cd','/var/alternc/mail/j/joe_societecivile.cd','$1$A/nuQxFm$TvwlfobxuyP.d4YFKgBu10'); MySQL Error: 1062 (Duplicate entry 'joe_societecivile.cd' for key 1) Session halted.

Je ne peux committer les modifs parce que le CVS est down, alors je documente ici.

STEPS TO REPRODUCE: 1- creer un compte pop foo@… 2- detruire le compte pop foo@… 3- re-creer le compte pop foo@…

ADDITIONAL INFORMATION: Pour régler le bug, ramener m_mail.php à la version 1.22, annulant mes 2 derniers commits, et appliquer la simple patch suivante:

--- m_mail.php.orig Thu Nov 11 13:02:30 2004 +++ m_mail.php Sun Nov 14 23:07:54 2004 @@ -537,8 +537,8 @@

} /* Effacement du domaine himself */ $db->query("DELETE FROM mail_domain WHERE mail LIKE '%@$dom';");

  • $db->query("DELETE FROM mail_users WHERE alias LIKE '%@$dom' OR alias LIKE '%_$dom';");
  • $db->query("DELETE FROM mail_alias WHERE mail LIKE '%_$dom';");

+ $db->query("DELETE FROM mail_users WHERE alias LIKE '%@$dom' OR alias LIKE '%\_$dom';"); + $db->query("DELETE FROM mail_alias WHERE mail LIKE '%\_$dom';");

$db->query("DELETE FROM mail_domain WHERE mail='$dom';"); return true;

}

Change History

comment:1 Changed 10 years ago by anarcat

  • Priority changed from normal to high
  • Severity changed from minor to crash

comment:2 Changed 10 years ago by anarcat

  • Owner changed from anonymous to anarcat
  • Status changed from new to assigned

comment:3 Changed 10 years ago by anarcat

  • Status changed from assigned to closed
  • Resolution set to fixed
  • Milestone set to 0.9.3

CVS est revenu, commit.

Note: See TracTickets for help on using tickets.