List Info

Thread: change password plugin for squirrelmail




change password plugin for squirrelmail
user name
2005-12-28 16:27:23
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, dbmailmerkx.demon.nl">dbmailmerkx.demon.nl < dbmailmerkx.demon.nl"> dbmailmerkx.demon.nl> 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.


>
&gt; Thanks. I have tried that too but I got "couldnot connect to database
> error";
> message. can u share your dsn?
>
> On 12/28/05, dbmailmerkx.demon.nl">dbmailmerkx.demon.nl < dbmailmerkx.demon.nl">dbmailmerkx.demon.nl > wrote:
>;>
>&gt;
>>; Hi,
>&gt;
>> There is also a plugin "change_mysqlpass".
&gt;>
>> I've been using this with dbmail for quite some time now, you need to
>&gt; modify a few lines in config.php:
>>
>>&nbsp; &nbsp; &nbsp;   ; // The names of the user ID and password columns
&gt;> ; &nbsp; &nbsp; &nbsp;  $mysql_userid_field = 'userid';
>>&nbsp; &nbsp; &nbsp;   ; $mysql_password_field ='passwd';
>>
>> And of course a few lines below that to match the encryption type you
>&gt; use
>&gt; in your database (which should be MD5):
>>
>&gt; &nbsp; &nbsp; &nbsp;   //---------------------------------------------------------
>> &nbsp;   ; &nbsp;  // Password encryption (or lack thereof)
&gt;>&nbsp; &nbsp; &nbsp; &nbsp;  //---------------------------------------------------------
>&gt;
>>; &nbsp; &nbsp; &nbsp; &nbsp; // Set only one of the options below to 1.
>>;
>>  ; &nbsp; &nbsp; &nbsp; // Set to 1 if the password column is encrypted
>>&nbsp; &nbsp; &nbsp;   ; // using the MySQL password() function.
>>&nbsp; &nbsp; &nbsp;   ; $mysql_saslcrypt = 0;
>>;
>>&nbsp;   ; &nbsp; &nbsp; // Set to 1 if the password column is encrypted
>>&nbsp; &nbsp;   ; &nbsp; // using the UNIX crypt() function.
>>&nbsp; &nbsp; &nbsp;   ; $mysql_unixcrypt = 0;
>>;
>>&nbsp;   ; &nbsp; &nbsp; // Set to 1 if the password column is to use MD5 encryption
>>&nbsp; &nbsp;   ; &nbsp; $mysql_MD5crypt = 1;
>&gt;
>>  ; &nbsp; &nbsp; &nbsp; // Set both to 0 if the password is stored in the
>&gt; &nbsp; &nbsp; &nbsp;   // column in plaintext.
>>
&gt;> Should do the trick.
>;>
>&gt; Stanley.
&gt;>
>;>
>>
>&gt; > ------=_Part_7402_30647837.1135696405212
&gt;> > Content-Type: text/plain; charset=ISO-8859-1
&gt;> > Content-Transfer-Encoding: quoted-printable
>> > Content-Disposition: inline
&gt;> >
>&gt; > Hi all,
>&gt; >
>&gt; > Hi all,
>&gt; >
>&gt; >   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
>&gt; SM
>>; >  plugin page.
>> >
>&gt; >
>&gt; http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
>&gt; >
>&gt; > Furthermore, it is for postgreSQL only. How about MySQL?
>;> >
>&gt; > ------=_Part_7402_30647837.1135696405212
&gt;> > Content-Type: text/html; charset=ISO-8859-1
&gt;> > Content-Transfer-Encoding: quoted-printable
>> > Content-Disposition: inline
>;> >
>&gt; > Hi all,<br><br&gt;<pre&gt;<font color=&quot;#ff7733&quot;>Hi all,</font><br><br><font
>>; > color=&quot;#ff7733&quot;>&nbsp; Is there any (official) plugin to change password
&gt;> for
>&gt; > dbmail ? I found</font><;br><font color=&quot;#ff7733&quot;> one written by
>&gt; Matthew
&gt;> > O'Connor but apparently it was not listed on SM
>>; > </font&gt;<br&gt;<font color=&quot;#ff7733&quot;> plugin page.</font><;br><br><font
>&gt; > color=&quot;#ff7733&quot;> <a
>> > href=";
>> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
>&gt; "
>;> > target=&quot;_blank&quot;>
&gt;> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
>&gt; > </a></font&gt;<br>;<br>Furthermore, it is for postgreSQL only. How about
>> > MySQL? <br><br>&lt;br>&lt;/pre>&lt;br>
&gt;> >
>&gt; > ------=_Part_7402_30647837.1135696405212--
>> >
>&gt; >
>&gt;
>>;
>> _______________________________________________
>&gt; Dbmail mailing list
>&gt; Dbmaildbmail.org">Dbmaildbmail.org
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>;>
>
> ------=_Part_14747_19566404.1135766140689
&gt; Content-Type: text/html; charset=ISO-8859-1
&gt; Content-Transfer-Encoding: quoted-printable
> Content-Disposition: inline
>;
> Thanks. I have tried that too but I got &quot;couldnot connect to database
&gt; error&quot; message. can u share your dsn?<br><br&gt;<div&gt;<span
> class=&quot;gmail_quote">;On 12/28/05, <b class=&quot;gmail_sendername&quot;><a
> href=";mailto: dbmailmerkx.demon.nl">dbmailmerkx.demon.nl">
> dbmailmerkx.demon.nl"> dbmailmerkx.demon.nl</a></b&gt; &lt;&lt;a
> href=";mailto: dbmailmerkx.demon.nl">dbmailmerkx.demon.nl"> dbmailmerkx.demon.nl">dbmailmerkx.demon.nl </a>&gt;
> wrote:</span>&lt;blockquote class=&quot;gmail_quote" style=&quot;border-left: 1px solid
> rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
> <br>Hi,<br&gt;<br>;There is also a plugin
&gt; &quot;change_mysqlpass&quot;.<br><br&gt;I've been using this with dbmail for
> quite some time now, you need to<br&gt;modify a few lines in
> config.php:<br><br>&amp;nbsp;&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// The
> names of the user ID and password columns
&gt; <br>&nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;&nbsp;$mysql_userid_field =
> 'userid';&lt;br>&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$mysql_password_field
> ='passwd';<br>&lt;br>And of course a few lines below that to match the
> encryption type you use<br&gt;in your database (which should be
> MD5):<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;//---------------------------------------------------------
> <br>&nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;&nbsp;// Password encryption
> (or lack
> thereof)&lt;br>&amp;nbsp;&;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//---------------------------------------------------------<br&gt;<br&gt;&nbsp;&nbsp;&nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;//
&gt; Set only one of the options below to
> 1.<br&gt;<br>;&nbsp;&nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;// Set to 1 if
> the password column is encrypted
> <br>&nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;&nbsp;// using the MySQL
>; password()
> function.&lt;br>&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$mysql_saslcrypt
> = 0;<br&gt;<br>;&nbsp;&nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;// Set to 1 if
> the password column is
> encrypted&lt;br>&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// using the
> UNIX crypt()
&gt; function.&lt;br>&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$mysql_unixcrypt
>; = 0;
> <br><br>&amp;nbsp;&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Set to 1 if the
> password column is to use MD5
> encryption<br>&amp;nbsp;&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$mysql_MD5crypt
>; = 1;<br&gt;<br>;&nbsp;&nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&;nbsp;&nbsp;&nbsp;// Set both to
> 0 if the password is stored in
> the<br&gt;&nbsp;&nbsp;&nbsp;&nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&;nbsp;// column in
> plaintext.<br>&lt;br>Should do the trick.
>; <br><br>Stanley.<br><br><br><br&gt;&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;&lt;br>&amp;gt; Hi all,<br>&gt;<br>&gt; Hi all,<br>&gt;<br>&gt;&amp;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;&gt;&amp;nbsp;&amp;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" &gt;http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
> </a><br>&amp;gt;<br>&gt; Furthermore, it is for postgreSQL only. How about
> MySQL?<br>&gt;<br&gt;&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;&gt; Hi
> all,&lt;br&gt;&lt;br&gt;&amp;lt;pre&amp;gt;&lt;font
>; color=&;quot;#ff7733&quot;&gt;Hi
> all,&lt;/font&;gt;&lt;br&gt;&lt;br&amp;gt;&;lt;font<;br>&;gt;
> color=&;quot;#ff7733&quot;&gt;&amp;nbsp;&amp;nbsp;Is there any (official) plugin to
> change password for
> <br>&gt; dbmail ? I found&lt;/font&amp;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;&gt; &lt;/font&gt;&lt;br&amp;gt;&;lt;font
&gt; color=&;quot;#ff7733&quot;&gt; plugin
>; page.&lt;/font&amp;gt;&lt;br&gt;&lt;br&gt;&amp;lt;font
> <br>&gt; color=&;quot;#ff7733&quot;&gt; &lt;a&lt;br>&amp;gt; href=&quot;<a
> href="; http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin"&gt; http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
> </a>&quot;&lt;br>&amp;gt; target=&amp;quot;_blank&quot;&gt;&lt;a
> href="; http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin"&gt; http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin
> </a><br>&amp;gt; &lt;/a&gt;&amp;lt;/font&amp;gt;&;lt;br&gt;&lt;br&gt;Furthermore, it is
> for postgreSQL only. How about<br>&gt; MySQL?
>; &lt;br&gt;&amp;lt;br&;gt;&lt;br&gt;&lt;/pre&gt;&amp;lt;br&amp;gt;<br>&gt;<br>&gt;
&gt; ------=_Part_7402_30647837.1135696405212--
> <br>&gt;<;br>&;gt;<br&gt;<br&gt;<br>;_______________________________________________<br&gt;Dbmail
&gt; mailing list<br><a
&gt; href=";mailto: Dbmaildbmail.org"> Dbmaildbmail.org"> Dbmaildbmail.org">Dbmaildbmail.org</a><br>&lt;a
> href=";https://mailman.fastxs.nl/mailman/listinfo/dbmail &quot;>
>; https://mailman.fastxs.nl/mailman/listinfo/dbmail</a><br></blockquote&gt;</div&gt;<br&gt;
>
>; ------=_Part_14747_19566404.1135766140689--
>
>


_______________________________________________
Dbmail mailing list
Dbmaildbmail.org">Dbmaildbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )