diff options
Diffstat (limited to 'zarb-ml/mageia-sysadm/2011-July/003698.html')
| -rw-r--r-- | zarb-ml/mageia-sysadm/2011-July/003698.html | 107 |
1 files changed, 107 insertions, 0 deletions
diff --git a/zarb-ml/mageia-sysadm/2011-July/003698.html b/zarb-ml/mageia-sysadm/2011-July/003698.html new file mode 100644 index 000000000..183970189 --- /dev/null +++ b/zarb-ml/mageia-sysadm/2011-July/003698.html @@ -0,0 +1,107 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> +<HTML> + <HEAD> + <TITLE> [Mageia-sysadm] Problem with sympa when changing email + </TITLE> + <LINK REL="Index" HREF="index.html" > + <LINK REL="made" HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20Problem%20with%20sympa%20when%20changing%20email&In-Reply-To=%3C1309995213.14729.110.camel%40akroma.ephaone.org%3E"> + <META NAME="robots" CONTENT="index,nofollow"> + <META http-equiv="Content-Type" content="text/html; charset=us-ascii"> + <LINK REL="Previous" HREF="003710.html"> + <LINK REL="Next" HREF="003699.html"> + </HEAD> + <BODY BGCOLOR="#ffffff"> + <H1>[Mageia-sysadm] Problem with sympa when changing email</H1> + <B>Michael Scherer</B> + <A HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20Problem%20with%20sympa%20when%20changing%20email&In-Reply-To=%3C1309995213.14729.110.camel%40akroma.ephaone.org%3E" + TITLE="[Mageia-sysadm] Problem with sympa when changing email">misc at zarb.org + </A><BR> + <I>Thu Jul 7 01:33:32 CEST 2011</I> + <P><UL> + <LI>Previous message: <A HREF="003710.html">[Mageia-sysadm] Apprentice account creation +</A></li> + <LI>Next message: <A HREF="003699.html">[Mageia-sysadm] Package removal request: lib*lcms22-2.2-1.mga2 +</A></li> + <LI> <B>Messages sorted by:</B> + <a href="date.html#3698">[ date ]</a> + <a href="thread.html#3698">[ thread ]</a> + <a href="subject.html#3698">[ subject ]</a> + <a href="author.html#3698">[ author ]</a> + </LI> + </UL> + <HR> +<!--beginarticle--> +<PRE>Hi, + +as noted some months ago, people changing email on ldap will have issues +on sympa. Since sympa use the mail as a key to identify the user instead +of the login, things go wrong when the mail is changed on ldap side. + +Damien -rediscovered the issue by changing his email in ldap to use the +@mageia.org aliases :) +( he is doing qa on the mail, finding all possible bugs, and I can only +imagine the next one ). + +To avoid this, there is several proposal : + +- let people post mail using their @mageia.org alias if they are +subscribed, using a custom scenari. That's doable, IMHO, but will only +help for some specific changes, people deciding to use their aliases +( which would be the more frequent type of change, IMHO ). In fact, that +would even help so people do not have to change it in ldap. + +This would have prevented the issue here. + +- let people use their aliases to log. Again, that's doable, and would +solve the other part of the issue. + +- push and sync from ldap, when there is a change. This would solve the +issue in all case, but this is much more complex to do. + +Anyway, shall the issue arise again, here is how I solved it : + +ssh <A HREF="https://www.mageia.org/mailman/listinfo/mageia-sysadm">root at alamut</A> +# psql -U postgres + +><i> \c sympa +</I> +><i> BEGIN ; +</I>><i> DELETE FROM user_table WHERE email_user = '<A HREF="https://www.mageia.org/mailman/listinfo/mageia-sysadm">new_email at example.org</A>' ; +</I>><i> UPDATE user_table SET email_user = '<A HREF="https://www.mageia.org/mailman/listinfo/mageia-sysadm">new_email at example.org</A>' WHERE +</I>email_user = '<A HREF="https://www.mageia.org/mailman/listinfo/mageia-sysadm">old_email at example.net</A>'; +><i> UPDATE subscriber_table SET user_subscriber = '<A HREF="https://www.mageia.org/mailman/listinfo/mageia-sysadm">new_email at example.org</A>' +</I>WHERE user_subscriber = '<A HREF="https://www.mageia.org/mailman/listinfo/mageia-sysadm">old_email at example.net</A>'; +><i> COMMIT; +</I> +As a side note, I suspect bugzilla to have the same type of issue, but +this need to be checked. + +-- +Michael Scherer + +</PRE> + + + + + +<!--endarticle--> + <HR> + <P><UL> + <!--threads--> + <LI>Previous message: <A HREF="003710.html">[Mageia-sysadm] Apprentice account creation +</A></li> + <LI>Next message: <A HREF="003699.html">[Mageia-sysadm] Package removal request: lib*lcms22-2.2-1.mga2 +</A></li> + <LI> <B>Messages sorted by:</B> + <a href="date.html#3698">[ date ]</a> + <a href="thread.html#3698">[ thread ]</a> + <a href="subject.html#3698">[ subject ]</a> + <a href="author.html#3698">[ author ]</a> + </LI> + </UL> + +<hr> +<a href="https://www.mageia.org/mailman/listinfo/mageia-sysadm">More information about the Mageia-sysadm +mailing list</a><br> +</body></html> |