You are using server-side sorting. This is currently not supported.

There is some code in place to parse the SORT command, but this barfs on
the 'ISO-8859-1' part of the command.
You can uncomment a couple of lines (grep for 'ISO-8859'), but that only
stops the imapd process from rejecting the command and is a really awful
hack.

(or as Paul J Stevens put it earlier: "Aarrgh, yuk. Serverside sorting is
broken!, But you know that..." ;-)

Probably best to stay away from server-side sorting for now.

Stanley.

>
> Why do I get this error for some users? I use SquirrelMail 1.4.4 and
> dbmail
> 2.0.7.
>
> * ERROR : Connection dropped by imap-server.*
> Query: SORT (FROM) ISO-8859-1 ALL
>
> On 12/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>>
>>
>> Hi,
>>
>> Cannot access it right now, but in the same file (config.php) there
>> should
>> be some lines defining the database server, login and password. Set
>> these
>> to the same values as you use in dbmail.conf.
>>
>> Also, if you are running the database and webserver on separate servers,
>> make sure that the database is listening on an (preferably internal)
>> IP-address that is reachable from the webserver (eg not 127.0.0.1).
>>
>> Stanley.
>>
>>
>> >
>> > Thanks. I have tried that too but I got "couldnot connect to database
>> > error"
>> > message. can u share your dsn?
>> >
>> > On 12/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>> >>
>> >>
>> >> 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--
>> >> >
>> >> >
>> >>
>> >>
>> >> _______________________________________________
>> >> Dbmail mailing list
>> >> [email protected]
>> >> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>> >>
>> >
>> > ------=_Part_14747_19566404.1135766140689
>> > Content-Type: text/html; charset=ISO-8859-1
>> > Content-Transfer-Encoding: quoted-printable
>> > Content-Disposition: inline
>> >
>> > Thanks. I have tried that too but I got &quot;couldnot connect to
>> database
>> > error&quot; message. can u share your dsn?<br><br><div><span
>> > class="gmail_quote">On 12/28/05, <b class="gmail_sendername"><a
>> > href="mailto:[EMAIL PROTECTED]">
>> > [EMAIL PROTECTED]</a></b> &lt;<a
>> > href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>&gt;
>> > wrote:</span><blockquote class="gmail_quote" style="border-left: 1px
>> solid
>> > rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
>> > <br>Hi,<br><br>There is also a plugin
>> > &quot;change_mysqlpass&quot;.<br><br>I've been using this with dbmail
>> for
>> > quite some time now, you need to<br>modify a few lines in
>> > config.php:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//
>> The
>> > names of the user ID and password columns
>> > <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$mysql_userid_field
>> > >
>> 'userid';<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$mysql_password_field
>> > ='passwd';<br><br>And of course a few lines below that to match the
>> > encryption type you use<br>in your database (which should be
>> >
>> MD5):<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//---------------------------------------------------------
>> > <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Password
>> encryption
>> > (or lack
>> >
>> thereof)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//---------------------------------------------------------<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//
>> > Set only one of the options below to
>> > 1.<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Set to 1
>> if
>> > the password column is encrypted
>> > <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// using the MySQL
>> > password()
>> >
>> function.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$mysql_saslcrypt
>> > = 0;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Set to
>> 1
>> if
>> > the password column is
>> > encrypted<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// using
>> the
>> > UNIX crypt()
>> >
>> function.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$mysql_unixcrypt
>> > = 0;
>> > <br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Set to 1 if
>> the
>> > password column is to use MD5
>> >
>> encryption<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$mysql_MD5crypt
>> > = 1;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Set
>> both
>> to
>> > 0 if the password is stored in
>> > the<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// column in
>> > plaintext.<br><br>Should do the trick.
>> > <br><br>Stanley.<br><br><br><br>&gt;
>> > ------=_Part_7402_30647837.1135696405212<br>&gt; Content-Type:
>> text/plain;
>> > charset=ISO-8859-1<br>&gt; Content-Transfer-Encoding:
>> > quoted-printable<br>&gt; Content-Disposition: inline<br>
>> > &gt;<br>&gt; Hi all,<br>&gt;<br>&gt; Hi
>> all,<br>&gt;<br>&gt;&nbsp;&nbsp;
>> > Is there any (official) plugin to change password for dbmail ? I
>> > found<br>&gt;&nbsp;&nbsp;one written by Matthew O'Connor but
>> apparently
>> it
>> > was not listed on SM<br>&gt;&nbsp;&nbsp;plugin page.
>> > <br>&gt;<br>&gt;&nbsp;&nbsp;<a
>> > href="
>> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";
>> >
>> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
>> > </a><br>&gt;<br>&gt; Furthermore, it is for postgreSQL only. How about
>> > MySQL?<br>&gt;<br>&gt;
>> ------=_Part_7402_30647837.1135696405212<br>&gt;
>> > Content-Type: text/html; charset=ISO-8859-1<br>&gt;
>> > Content-Transfer-Encoding: quoted-printable
>> > <br>&gt; Content-Disposition: inline<br>&gt;<br>&gt; Hi
>> > all,&lt;br&gt;&lt;br&gt;&lt;pre&gt;&lt;font
>> > color=&quot;#ff7733&quot;&gt;Hi
>> > all,&lt;/font&gt;&lt;br&gt;&lt;br&gt;&lt;font<br>&gt;
>> > color=&quot;#ff7733&quot;&gt;&nbsp;&nbsp;Is there any (official)
>> plugin
>> to
>> > change password for
>> > <br>&gt; dbmail ? I found&lt;/font&gt;&lt;br&gt;&lt;font
>> > color=&quot;#ff7733&quot;&gt; one written by Matthew<br>&gt; O'Connor
>> but
>> > apparently it was not listed on SM<br>&gt;
>> &lt;/font&gt;&lt;br&gt;&lt;font
>> > color=&quot;#ff7733&quot;&gt; plugin
>> > page.&lt;/font&gt;&lt;br&gt;&lt;br&gt;&lt;font
>> > <br>&gt; color=&quot;#ff7733&quot;&gt; &lt;a<br>&gt; href=&quot;<a
>> > href="
>> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";
>> >
>> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
>> > </a>&quot;<br>&gt; target=&quot;_blank&quot;&gt;<a
>> > href="
>> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";
>> >
>> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
>> > </a><br>&gt; &lt;/a&gt;&lt;/font&gt;&lt;br&gt;&lt;br&gt;Furthermore,
>> it
>> is
>> > for postgreSQL only. How about<br>&gt; MySQL?
>> > &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;/pre&gt;&lt;br&gt;<br>&gt;<br>&gt;
>> > ------=_Part_7402_30647837.1135696405212--
>> >
>> <br>&gt;<br>&gt;<br><br><br>_______________________________________________<br>Dbmail
>> > mailing list<br><a
>> > href="mailto:[email protected]";>[email protected]</a><br><a
>> > href="https://mailman.fastxs.nl/mailman/listinfo/dbmail";>
>> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
>> </a><br></blockquote></div><br>
>> >
>> > ------=_Part_14747_19566404.1135766140689--
>> >
>> >
>>
>>
>> _______________________________________________
>> Dbmail mailing list
>> [email protected]
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
>
> ------=_Part_16959_26226770.1135787243926
> Content-Type: text/html; charset=ISO-8859-1
> Content-Transfer-Encoding: quoted-printable
> Content-Disposition: inline
>
> Why do I get this error for some users? I use SquirrelMail 1.4.4 and
> dbmail 2.0.7.<br><br><b><font color="#f04040">
> ERROR : Connection dropped by imap-server.</font></b><font
> color="#f04040"><br>
> Query: SORT (FROM) ISO-8859-1 ALL</font><br><br><div><span
> class="gmail_quote">On 12/28/05, <b class="gmail_sendername"><a
> href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a></b> &lt;<a
> href="mailto:[EMAIL PROTECTED]">
> [EMAIL PROTECTED]</a>&gt; wrote:</span><blockquote class="gmail_quote"
> style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt
> 0.8ex; padding-left: 1ex;"><br>Hi,<br><br>Cannot access it right now, but
> in the same file (
> config.php) there should<br>be some lines defining the database server,
> login and password. Set these<br>to the same values as you use in
> dbmail.conf.<br><br>Also, if you are running the database and webserver on
> separate servers,
> <br>make sure that the database is listening on an (preferably
> internal)<br>IP-address that is reachable from the webserver (eg not <a
> href="http://127.0.0.1";>127.0.0.1</a>).<br><br>Stanley.<br><br><br>&gt;<br>&gt;
> Thanks. I have tried that too but I got &quot;couldnot connect to database
> <br>&gt; error&quot;<br>&gt; message. can u share your
> dsn?<br>&gt;<br>&gt; On 12/28/05, <a
> href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a> &lt;<a
> href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>
> &gt; wrote:<br>&gt;&gt;<br>&gt;&gt;<br>&gt;&gt;
> Hi,<br>&gt;&gt;<br>&gt;&gt; There is also a plugin
> &quot;change_mysqlpass&quot;.<br>&gt;&gt;<br>&gt;&gt; I've been using this
> with dbmail for quite some time now, you need to
> <br>&gt;&gt; modify a few lines in
> config.php:<br>&gt;&gt;<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> // The names of the user ID and password
> columns<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> $mysql_userid_field =
> 'userid';<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> $mysql_password_field ='passwd';
> <br>&gt;&gt;<br>&gt;&gt; And of course a few lines below that to match the
> encryption type you<br>&gt;&gt; use<br>&gt;&gt; in your database (which
> should be
> MD5):<br>&gt;&gt;<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> //---------------------------------------------------------
> <br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Password
> encryption (or lack
> thereof)<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> //---------------------------------------------------------<br>&gt;&gt;<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> // Set only one of the options below to 1.<br>&gt;&gt;
> <br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Set to 1
> if the password column is
> encrypted<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //
> using the MySQL password()
> function.<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> $mysql_saslcrypt =
> 0;<br>&gt;&gt;<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> // Set to 1 if the password column is encrypted
> <br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // using the
> UNIX crypt()
> function.<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> $mysql_unixcrypt =
> 0;<br>&gt;&gt;<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> // Set to 1 if the password column is to use MD5
> encryption<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> $mysql_MD5crypt = 1;
> <br>&gt;&gt;<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> // Set both to 0 if the password is stored in
> the<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // column
> in plaintext.<br>&gt;&gt;<br>&gt;&gt; Should do the
> trick.<br>&gt;&gt;<br>&gt;&gt; Stanley.<br>&gt;&gt;<br>&gt;&gt;
> <br>&gt;&gt;<br>&gt;&gt; &gt;
> ------=_Part_7402_30647837.1135696405212<br>&gt;&gt; &gt; Content-Type:
> text/plain; charset=ISO-8859-1<br>&gt;&gt; &gt; Content-Transfer-Encoding:
> quoted-printable<br>&gt;&gt; &gt; Content-Disposition: inline
> <br>&gt;&gt; &gt;<br>&gt;&gt; &gt; Hi all,<br>&gt;&gt; &gt;<br>&gt;&gt;
> &gt; Hi all,<br>&gt;&gt; &gt;<br>&gt;&gt; &gt;&nbsp;&nbsp; Is there any
> (official) plugin to change password for dbmail ? I<br>&gt;&gt;
> found<br>&gt;&gt; &gt;&nbsp;&nbsp;one written by Matthew O'Connor but
> apparently it was not listed on
> <br>&gt;&gt; SM<br>&gt;&gt; &gt;&nbsp;&nbsp;plugin page.<br>&gt;&gt;
> &gt;<br>&gt;&gt; &gt;<br>&gt;&gt; <a
> href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";>http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
> </a><br>&gt;&gt; &gt;<br>&gt;&gt; &gt; Furthermore, it is for postgreSQL
> only. How about MySQL?<br>&gt;&gt; &gt;<br>&gt;&gt; &gt;
> ------=_Part_7402_30647837.1135696405212<br>&gt;&gt; &gt; Content-Type:
> text/html; charset=ISO-8859-1
> <br>&gt;&gt; &gt; Content-Transfer-Encoding: quoted-printable<br>&gt;&gt;
> &gt; Content-Disposition: inline<br>&gt;&gt; &gt;<br>&gt;&gt; &gt; Hi
> all,&lt;br&gt;&lt;br&gt;&lt;pre&gt;&lt;font
> color=&quot;#ff7733&quot;&gt;Hi
> all,&lt;/font&gt;&lt;br&gt;&lt;br&gt;&lt;font
> <br>&gt;&gt; &gt; color=&quot;#ff7733&quot;&gt;&nbsp;&nbsp;Is there any
> (official) plugin to change password<br>&gt;&gt; for<br>&gt;&gt; &gt;
> dbmail ? I found&lt;/font&gt;&lt;br&gt;&lt;font
> color=&quot;#ff7733&quot;&gt; one written by
> <br>&gt;&gt; Matthew<br>&gt;&gt; &gt; O'Connor but apparently it was not
> listed on SM<br>&gt;&gt; &gt; &lt;/font&gt;&lt;br&gt;&lt;font
> color=&quot;#ff7733&quot;&gt; plugin
> page.&lt;/font&gt;&lt;br&gt;&lt;br&gt;&lt;font<br>
> &gt;&gt; &gt; color=&quot;#ff7733&quot;&gt; &lt;a<br>&gt;&gt; &gt;
> href=&quot;<br>&gt;&gt; <a
> href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";>http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
> </a><br>&gt;&gt; &quot;<br>&gt;&gt; &gt;
> target=&quot;_blank&quot;&gt;<br>&gt;&gt; <a
> href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";>http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
> </a><br>&gt;&gt; &gt;
> &lt;/a&gt;&lt;/font&gt;&lt;br&gt;&lt;br&gt;Furthermore, it is for
> postgreSQL only. How about<br>&gt;&gt; &gt; MySQL?
> &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;/pre&gt;&lt;br&gt;<br>&gt;&gt;
> &gt;<br>&gt;&gt; &gt; ------=_Part_7402_30647837.1135696405212--
> <br>&gt;&gt; &gt;<br>&gt;&gt; &gt;<br>&gt;&gt;<br>&gt;&gt;<br>&gt;&gt;
> _______________________________________________<br>&gt;&gt; Dbmail mailing
> list<br>&gt;&gt; <a
> href="mailto:[email protected]";>[email protected]</a><br>
> &gt;&gt; <a
> href="https://mailman.fastxs.nl/mailman/listinfo/dbmail";>https://mailman.fastxs.nl/mailman/listinfo/dbmail</a><br>&gt;&gt;<br>&gt;<br>&gt;
> ------=_Part_14747_19566404.1135766140689<br>&gt; Content-Type: text/html;
> charset=ISO-8859-1
> <br>&gt; Content-Transfer-Encoding: quoted-printable<br>&gt;
> Content-Disposition: inline<br>&gt;<br>&gt; Thanks. I have tried that too
> but I got &amp;quot;couldnot connect to database<br>&gt; error&amp;quot;
> message. can u share your dsn?&lt;br&gt;&lt;br&gt;&lt;div&gt;&lt;span
> <br>&gt; class=&quot;gmail_quote&quot;&gt;On 12/28/05, &lt;b
> class=&quot;gmail_sendername&quot;&gt;&lt;a<br>&gt; href=&quot;mailto:<a
> href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>&quot;&gt;<br>&gt;
> <a href="mailto:[EMAIL PROTECTED]">
> [EMAIL PROTECTED]</a>&lt;/a&gt;&lt;/b&gt; &amp;lt;&lt;a<br>&gt;
> href=&quot;mailto:<a
> href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>&quot;&gt;<a
> href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>
> &lt;/a&gt;&amp;gt;<br>&gt; wrote:&lt;/span&gt;&lt;blockquote
> class=&quot;gmail_quote&quot; style=&quot;border-left: 1px solid<br>&gt;
> rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left:
> 1ex;&quot;&gt;<br>&gt; &lt;br&gt;Hi,&lt;br&gt;&lt;br&gt;There is also a
> plugin
> <br>&gt; &amp;quot;change_mysqlpass&amp;quot;.&lt;br&gt;&lt;br&gt;I've
> been using this with dbmail for<br>&gt; quite some time now, you need
> to&lt;br&gt;modify a few lines in<br>&gt;
> config.php:&lt;br&gt;&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//
> The
> <br>&gt; names of the user ID and password columns<br>&gt;
> &lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;$mysql_userid_field
> =<br>&gt;
> 'userid';&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;$mysql_password_field
> <br>&gt; ='passwd';&lt;br&gt;&lt;br&gt;And of course a few lines below
> that to match the<br>&gt; encryption type you use&lt;br&gt;in your
> database (which should be<br>&gt;
> MD5):&lt;br&gt;&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//---------------------------------------------------------
> <br>&gt;
> &lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//
> Password encryption<br>&gt; (or lack<br>&gt;
> thereof)&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//---------------------------------------------------------&lt;br&gt;&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//
> <br>&gt; Set only one of the options below to<br>&gt;
> 1.&lt;br&gt;&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//
> Set to 1 if<br>&gt; the password column is encrypted<br>&gt;
> &lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//
> using the MySQL
> <br>&gt; password()<br>&gt;
> function.&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;$mysql_saslcrypt<br>&gt;
> =
> 0;&lt;br&gt;&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//
> Set to 1 if
> <br>&gt; the password column is<br>&gt;
> encrypted&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//
> using the<br>&gt; UNIX crypt()<br>&gt;
> function.&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;$mysql_unixcrypt
> <br>&gt; = 0;<br>&gt;
> &lt;br&gt;&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//
> Set to 1 if the<br>&gt; password column is to use MD5<br>&gt;
> encryption&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;$mysql_MD5crypt
> <br>&gt; =
> 1;&lt;br&gt;&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//
> Set both to<br>&gt; 0 if the password is stored in<br>&gt;
> the&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//
> column in
> <br>&gt; plaintext.&lt;br&gt;&lt;br&gt;Should do the trick.<br>&gt;
> &lt;br&gt;&lt;br&gt;Stanley.&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&amp;gt;<br>&gt;
> ------=_Part_7402_30647837.1135696405212&lt;br&gt;&amp;gt; Content-Type:
> text/plain;
> <br>&gt; charset=ISO-8859-1&lt;br&gt;&amp;gt;
> Content-Transfer-Encoding:<br>&gt; quoted-printable&lt;br&gt;&amp;gt;
> Content-Disposition: inline&lt;br&gt;<br>&gt; &amp;gt;&lt;br&gt;&amp;gt;
> Hi all,&lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt; Hi
> all,&lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt;&amp;nbsp;&amp;nbsp;
> <br>&gt; Is there any (official) plugin to change password for dbmail ?
> I<br>&gt; found&lt;br&gt;&amp;gt;&amp;nbsp;&amp;nbsp;one written by
> Matthew O'Connor but apparently it<br>&gt; was not listed on
> SM&lt;br&gt;&amp;gt;&amp;nbsp;&amp;nbsp;plugin page.
> <br>&gt;
> &lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt;&amp;nbsp;&amp;nbsp;&lt;a<br>&gt;
> href=&quot;<a
> href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin&quot;";>http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin&quot;
> </a>&gt;<a
> href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";>http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin</a>
> <br>&gt; &lt;/a&gt;&lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt; Furthermore, it is
> for postgreSQL only. How about<br>&gt;
> MySQL?&lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt;
> ------=_Part_7402_30647837.1135696405212&lt;br&gt;&amp;gt;<br>&gt;
> Content-Type: text/html; charset=ISO-8859-1&lt;br&gt;&amp;gt;
> <br>&gt; Content-Transfer-Encoding: quoted-printable<br>&gt;
> &lt;br&gt;&amp;gt; Content-Disposition:
> inline&lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt; Hi<br>&gt;
> all,&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&amp;lt;pre&amp;gt;&amp;lt;font
> <br>&gt; color=&amp;quot;#ff7733&amp;quot;&amp;gt;Hi<br>&gt;
> all,&amp;lt;/font&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&amp;lt;font&lt;br&gt;&amp;gt;<br>&gt;
> color=&amp;quot;#ff7733&amp;quot;&amp;gt;&amp;nbsp;&amp;nbsp;Is there any
> (official) plugin to
> <br>&gt; change password for<br>&gt; &lt;br&gt;&amp;gt; dbmail ? I
> found&amp;lt;/font&amp;gt;&amp;lt;br&amp;gt;&amp;lt;font<br>&gt;
> color=&amp;quot;#ff7733&amp;quot;&amp;gt; one written by
> Matthew&lt;br&gt;&amp;gt; O'Connor but
> <br>&gt; apparently it was not listed on SM&lt;br&gt;&amp;gt;
> &amp;lt;/font&amp;gt;&amp;lt;br&amp;gt;&amp;lt;font<br>&gt;
> color=&amp;quot;#ff7733&amp;quot;&amp;gt; plugin<br>&gt;
> page.&amp;lt;/font&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&amp;lt;font
> <br>&gt; &lt;br&gt;&amp;gt; color=&amp;quot;#ff7733&amp;quot;&amp;gt;
> &amp;lt;a&lt;br&gt;&amp;gt; href=&amp;quot;&lt;a<br>&gt; href=&quot;<a
> href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin&quot;";>
> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin&quot;</a>&gt;<a
> href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";>
> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin</a><br>&gt;
> &lt;/a&gt;&amp;quot;&lt;br&gt;&amp;gt;
> target=&amp;quot;_blank&amp;quot;&amp;gt;&lt;a<br>&gt; href=&quot;<a
> href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin&quot;";>
> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin&quot;</a>&gt;<a
> href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";>
> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin</a><br>&gt;
> &lt;/a&gt;&lt;br&gt;&amp;gt;
> &amp;lt;/a&amp;gt;&amp;lt;/font&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;Furthermore,
> it is
> <br>&gt; for postgreSQL only. How about&lt;br&gt;&amp;gt; MySQL?<br>&gt;
> &amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&amp;lt;/pre&amp;gt;&amp;lt;br&amp;gt;&lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt;<br>&gt;
> ------=_Part_7402_30647837.1135696405212--
> <br>&gt;
> &lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;_______________________________________________&lt;br&gt;Dbmail<br>&gt;
> mailing list&lt;br&gt;&lt;a<br>&gt; href=&quot;mailto:<a
> href="mailto:[email protected]";>
> [email protected]</a>&quot;&gt;<a
> href="mailto:[email protected]";>[email protected]</a>&lt;/a&gt;&lt;br&gt;&lt;a<br>&gt;
> href=&quot;<a
> href="https://mailman.fastxs.nl/mailman/listinfo/dbmail";>https://mailman.fastxs.nl/mailman/listinfo/dbmail
> </a>&quot;&gt;<br>&gt; <a
> href="https://mailman.fastxs.nl/mailman/listinfo/dbmail";>https://mailman.fastxs.nl/mailman/listinfo/dbmail</a>&lt;/a&gt;&lt;br&gt;&lt;/blockquote&gt;&lt;/div&gt;&lt;br&gt;<br>&gt;<br>&gt;
> ------=_Part_14747_19566404.1135766140689--
> <br>&gt;<br>&gt;<br><br><br>_______________________________________________<br>Dbmail
> mailing list<br><a
> href="mailto:[email protected]";>[email protected]</a><br><a
> href="https://mailman.fastxs.nl/mailman/listinfo/dbmail";>
> https://mailman.fastxs.nl/mailman/listinfo/dbmail</a><br></blockquote></div><br>
>
> ------=_Part_16959_26226770.1135787243926--
>
>


Reply via email to