sharing userbase with WordPress
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Is there a way to share the userbase of Mailman with WordPress?
What I need is that the "master" database is Mailman and I would like to replicate (also via script) the accounts and passwords to WordPress.
Is it possible?
Thank you.
Ciao, luigi
/ +--[Luigi Rosa]-- \
SysAdmins follow a different PATH.
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAk30Q9wACgkQ3kWu7Tfl6ZTj7wCeNglfV9rjHNRuOAKmgNo5uGCf rzkAn0nD7Ma9+Ba9uIjQ4Dlki8fJlG5l =dUpY -----END PGP SIGNATURE-----
On Sun, Jun 12, 2011 at 06:43:12AM +0200, Luigi Rosa wrote:
Is there a way to share the userbase of Mailman with WordPress?
In-part, I'd suggest...
What I need is that the "master" database is Mailman and I would like to replicate (also via script) the accounts and passwords to WordPress.
WordPress (WP) users have email addresses. It's relatively trivial to extract those addresses, and, say, feed them through to sync_members(8)...
Pulling in the name (if that's your fancy) could also be done quite easily.
As for passwords, I'd not do this, at all; particularly if you've not zapped the password-reminders crontab.
You'd also, presumably need to unsalt the password-hash stored in WP.
I'd just generate a random password for Mailman. It's trivial (although, quite how so many failo…) to receive a password reminder, after all.
(Maybe add in a 'Mailman password' field into the WP users' table, and in the user's settings pages, and feed that to Mailman?)
Is it possible?
I'd say: email addresses: yes names: yes passwords: no, and you shouldn't.
How's that?
-- "The reasonable man adapts himself to the world: the unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man." -- George Bernard Shaw
On 6/12/2011 6:59 AM, Adam McGreggor wrote:
I think the OP wants to go the other way.
I'm not sure what's available on the WordPress side, but a Mailman withlist script (see bin/withlist --help) along the lines of
def get_addr_pw(mlist): for member in mlist.getMembers(): em = mlist.getMemberCPAddresses(member) pw = mlist.getMemberPassword(member) rn = mlist.getMemberName(member) print '"%s" <%s>; %s' % (rn, em, pw)
will print name, address and password in the form
"Joe Cool" <jcool@example.com>; jcpasswd
for each member. If you have (or install) the MySQL-python package, you could probably update the WordPress user database directly in the same script.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Mark Sapiro said the following on 12/06/11 18:47:
Thank you all for the suggestions!
Ciao, luigi
/ +--[Luigi Rosa]-- \
Can anything be sadder than work left unfinished? Yes, work never begun. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAk31Ex4ACgkQ3kWu7Tfl6ZRbUACfbhf3UYVb+BRa0DzDFTRl+aE9 U+MAn2BXObk4XEqsCCgcqVSeVJ5ZEUTK =hu9H -----END PGP SIGNATURE-----
On Sun, Jun 12, 2011 at 06:43:12AM +0200, Luigi Rosa wrote:
Is there a way to share the userbase of Mailman with WordPress?
In-part, I'd suggest...
What I need is that the "master" database is Mailman and I would like to replicate (also via script) the accounts and passwords to WordPress.
WordPress (WP) users have email addresses. It's relatively trivial to extract those addresses, and, say, feed them through to sync_members(8)...
Pulling in the name (if that's your fancy) could also be done quite easily.
As for passwords, I'd not do this, at all; particularly if you've not zapped the password-reminders crontab.
You'd also, presumably need to unsalt the password-hash stored in WP.
I'd just generate a random password for Mailman. It's trivial (although, quite how so many failo…) to receive a password reminder, after all.
(Maybe add in a 'Mailman password' field into the WP users' table, and in the user's settings pages, and feed that to Mailman?)
Is it possible?
I'd say: email addresses: yes names: yes passwords: no, and you shouldn't.
How's that?
-- "The reasonable man adapts himself to the world: the unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man." -- George Bernard Shaw
On 6/12/2011 6:59 AM, Adam McGreggor wrote:
I think the OP wants to go the other way.
I'm not sure what's available on the WordPress side, but a Mailman withlist script (see bin/withlist --help) along the lines of
def get_addr_pw(mlist): for member in mlist.getMembers(): em = mlist.getMemberCPAddresses(member) pw = mlist.getMemberPassword(member) rn = mlist.getMemberName(member) print '"%s" <%s>; %s' % (rn, em, pw)
will print name, address and password in the form
"Joe Cool" <jcool@example.com>; jcpasswd
for each member. If you have (or install) the MySQL-python package, you could probably update the WordPress user database directly in the same script.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Mark Sapiro said the following on 12/06/11 18:47:
Thank you all for the suggestions!
Ciao, luigi
/ +--[Luigi Rosa]-- \
Can anything be sadder than work left unfinished? Yes, work never begun. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAk31Ex4ACgkQ3kWu7Tfl6ZRbUACfbhf3UYVb+BRa0DzDFTRl+aE9 U+MAn2BXObk4XEqsCCgcqVSeVJ5ZEUTK =hu9H -----END PGP SIGNATURE-----
participants (3)
-
Adam McGreggor -
Luigi Rosa -
Mark Sapiro