Hi,
There is also a plugin "change_mysqlpass".
I've been using this with dbmail for quite some time now, you need to
modify a few lines in config.php:
// The names of the user ID and password columns
$mysql_userid_field = 'userid';
$mysql_password_field ='passwd';
And of course a few lines below that to match the encryption type you use
in your database (which should be MD5):
//---------------------------------------------------------
// Password encryption (or lack thereof)
//---------------------------------------------------------
// Set only one of the options below to 1.
// Set to 1 if the password column is encrypted
// using the MySQL password() function.
$mysql_saslcrypt = 0;
// Set to 1 if the password column is encrypted
// using the UNIX crypt() function.
$mysql_unixcrypt = 0;
// Set to 1 if the password column is to use MD5 encryption
$mysql_MD5crypt = 1;
// Set both to 0 if the password is stored in the
// column in plaintext.
Should do the trick.
Stanley.
> ------=_Part_7402_30647837.1135696405212
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: quoted-printable
> Content-Disposition: inline
>
> Hi all,
>
> Hi all,
>
> Is there any (official) plugin to change password for dbmail ? I found
> one written by Matthew O'Connor but apparently it was not listed on SM
> plugin page.
>
>
> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
>
> Furthermore, it is for postgreSQL only. How about MySQL?
>
> ------=_Part_7402_30647837.1135696405212
> Content-Type: text/html; charset=ISO-8859-1
> Content-Transfer-Encoding: quoted-printable
> Content-Disposition: inline
>
> Hi all,<br><br><pre><font color="#ff7733">Hi all,</font><br><br><font
> color="#ff7733"> Is there any (official) plugin to change password for
> dbmail ? I found</font><br><font color="#ff7733"> one written by Matthew
> O'Connor but apparently it was not listed on SM
> </font><br><font color="#ff7733"> plugin page.</font><br><br><font
> color="#ff7733"> <a
> href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";
> target="_blank">http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
> </a></font><br><br>Furthermore, it is for postgreSQL only. How about
> MySQL? <br><br><br></pre><br>
>
> ------=_Part_7402_30647837.1135696405212--
>
>
