List Info

Thread: change password plugin for squirrelmail




change password plugin for squirrelmail
user name
2005-12-28 17:05:57

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, 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.
>>
>>
>> >
>> > 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> 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://mailm
an.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://mailm
an.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f
/change_dbmail_pass-0001.bin
>> >> "
>> >> > target="_blank">
>> >>
>> http://mailm
an.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
>> >> Dbmaildbmail.org
>> >> htt
ps://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:dbmailmerkx.demon.nl">
>> > dbmailmerkx.demon.nl</a></b>
&lt;<a
>> > href="mailto:dbmailmerkx.demon.nl">dbmailmerkx.demon.nl</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'v
e 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;&
amp;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;&a
mp;nbsp;&nbsp;&nbsp;&nbsp;//--------------------
-------------------------------------<br><br>&am
p;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am
p;nbsp;&nbsp;//
>> > Set only one of the options below to
>> >
1.<br><br>&nbsp;&nbsp;&nbsp;&nbs
p;&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;&
amp;nbsp;&nbsp;&nbsp;&nbsp;$mysql_saslcrypt
>> > =
0;<br><br>&nbsp;&nbsp;&nbsp;&nbs
p;&nbsp;&nbsp;&nbsp;&nbsp;// Set to
>> 1
>> if
>> > the password column is
>> >
encrypted<br>&nbsp;&nbsp;&nbsp;&nbsp;&
amp;nbsp;&nbsp;&nbsp;&nbsp;// using
>> the
>> > UNIX crypt()
>> >
>>
function.<br>&nbsp;&nbsp;&nbsp;&nbsp;&
amp;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;&nbs
p;&nbsp;&nbsp;&nbsp;&nbsp;// Set
>> both
>> to
>> > 0 if the password is stored in
>> >
the<br>&nbsp;&nbsp;&nbsp;&nbsp;&nb
sp;&nbsp;&nbsp;&nbsp;// column in
>> > plaintext.<br><br>Should do the
trick.
>> >
<br><br>Stanley.<br><br><br>&l
t;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/03
d47c5f/change_dbmail_pass-0001.bin"
>> >
>> http://mailm
an.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;&
amp;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&g
t;&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/03
d47c5f/change_dbmail_pass-0001.bin"
>> >
>> http://mailm
an.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/03
d47c5f/change_dbmail_pass-0001.bin"
>> >
>> http://mailm
an.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f
/change_dbmail_pass-0001.bin
>> > </a><br>&gt;
&lt;/a&gt;&lt;/font&gt;&lt;br&gt;&am
p;lt;br&gt;Furthermore,
>> it
>> is
>> > for postgreSQL only. How
about<br>&gt; MySQL?
>> >
&lt;br&gt;&lt;br&gt;&lt;br&gt;&l
t;/pre&gt;&lt;br&gt;<br>&gt;<br>
&gt;
>> > ------=_Part_7402_30647837.1135696405212--
>> >
>>
<br>&gt;<br>&gt;<br><br><
br>_______________________________________________<br&
gt;Dbmail
>> > mailing list<br><a
>> > href="mailtobmaildbmail.org">Dbmaildbmail.org</a><br><a
>> > href="https://mailman.fastxs.nl/mailman/listinfo/dbmail&quo
t;>
>> > htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
</a><br></blockquote></div><br>
;
>> >
>> > ------=_Part_14747_19566404.1135766140689--
>> >
>> >
>>
>>
>> _______________________________________________
>> Dbmail mailing list
>> Dbmaildbmail.org
>> htt
ps://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:dbmailmerkx.demon.nl">dbmailmerkx.demon.nl</a></b> &lt;<a
> href="mailto:dbmailmerkx.demon.nl">
> dbmailmerkx.demon.nl</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:dbmailmerkx.demon.nl">dbmailmerkx.demon.nl</a>
&lt;<a
> href="mailto:dbmailmerkx.demon.nl">dbmailmerkx.demon.nl</a>
> &gt;
wrote:<br>&gt;&gt;<br>&gt;&gt;&l
t;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;&nb
sp;&nbsp;&nbsp;
> // The names of the user ID and password
>
columns<br>&gt;&gt;&nbsp;&nbsp;&nb
sp;&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;&am
p;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am
p;nbsp;&nbsp;
>
//---------------------------------------------------------
>
<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&
;nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Password
> encryption (or lack
>
thereof)<br>&gt;&gt;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>
//---------------------------------------------------------&
lt;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;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&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;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&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;&nbs
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
p;&nbsp;
> // Set both to 0 if the password is stored in
>
the<br>&gt;&gt;&nbsp;&nbsp;&nbsp;&
amp;nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // column
> in
plaintext.<br>&gt;&gt;<br>&gt;&g
t; 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;&a
mp;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_db
mail_pass-0001.bin">http://mailman.fastxs.net/piperm
ail/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;&a
mp;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;&
amp;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&g
t;&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_db
mail_pass-0001.bin">http://mailman.fastxs.net/piperm
ail/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;&
amp;gt; <a
> href="http://mailman.fastxs.
net/pipermail/dbmail/attachments/20040810/03d47c5f/change_db
mail_pass-0001.bin">http://mailman.fastxs.net/piperm
ail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-
0001.bin
> </a><br>&gt;&gt; &gt;
>
&lt;/a&gt;&lt;/font&gt;&lt;br&gt;&am
p;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;&l
t;/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>&am
p;gt;&gt; Dbmail mailing
> list<br>&gt;&gt; <a
> href="mailtobmaildbmail.org">Dbmaildbmail.org</a><br>
> &gt;&gt; <a
> href="https://mailman.fastxs.nl/mailman/listinfo/dbmail&qu
ot;>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;&
amp;lt;span
> <br>&gt;
class=&quot;gmail_quote&quot;&gt;On 12/28/05,
&lt;b
>
class=&quot;gmail_sendername&quot;&gt;&lt;a&
lt;br>&gt; href=&quot;mailto:<a
> href="mailto:dbmailmerkx.demon.nl">dbmailmerkx.demon.nl</a>&quot;&gt;<br>&
amp;gt;
> <a href="mailto:dbmailmerkx.demon.nl">
> dbmailmerkx.demon.nl</a>&lt;/a&gt;&lt;/b&
amp;gt; &amp;lt;&lt;a<br>&gt;
> href=&quot;mailto:<a
> href="mailto:dbmailmerkx.demon.nl">dbmailmerkx.demon.nl</a>&quot;&gt;<a
> href="mailto:dbmailmerkx.demon.nl">dbmailmerkx.demon.nl</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;The
re 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;&am
p;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;&a
mp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;n
bsp;&amp;nbsp;//----------------------------------------
-----------------&lt;br&gt;&lt;br&gt;&am
p;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nb
sp;&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;nbs
p;&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;nbs
p;&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;n
bsp;&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;nbs
p;&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;nb
sp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&
amp;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&g
t;&lt;br&gt;&lt;br&gt;&lt;br&gt;&
;amp;gt;<br>&gt;
>
------=_Part_7402_30647837.1135696405212&lt;br&gt;&a
mp;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;nb
sp;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="ht
tp://mailman.fastxs.net/pipermail/dbmail/attachments/2004081
0/03d47c5f/change_dbmail_pass-0001.bin&quot;">ht
tp://mailman.fastxs.net/pipermail/dbmail/attachments/2004081
0/03d47c5f/change_dbmail_pass-0001.bin&quot;
> </a>&gt;<a
> href="http://mailm
an.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f
/change_dbmail_pass-0001.bin">http://mailman.fastxs.
net/pipermail/dbmail/attachments/20040810/03d47c5f/change_db
mail_pass-0001.bin</a>
> <br>&gt;
&lt;/a&gt;&lt;br&gt;&amp;gt;&lt;br&a
mp;gt;&amp;gt; Furthermore, it is
> for postgreSQL only. How about<br>&gt;
>
MySQL?&lt;br&gt;&amp;gt;&lt;br&gt;&a
mp;gt;
>
------=_Part_7402_30647837.1135696405212&lt;br&gt;&a
mp;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;&a
mp;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<b
r>&gt;
>
all,&amp;lt;/font&amp;gt;&amp;lt;br&amp;gt;&
amp;amp;lt;br&amp;gt;&amp;lt;font&lt;br&gt;&
amp;amp;gt;<br>&gt;
>
color=&amp;quot;#ff7733&amp;quot;&amp;gt;&am
p;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/attachmen
ts/20040810/03d47c5f/change_dbmail_pass-0001.bin&quot;&q
uot;>
> http://mailman.fastxs.net/pipermail/dbm
ail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bi
n&quot;</a>&gt;<a
> href="ht
tp://mailman.fastxs.net/pipermail/dbmail/attachments/2004081
0/03d47c5f/change_dbmail_pass-0001.bin">
> http://mailman.fastxs.net/pipermail/dbmail/a
ttachments/20040810/03d47c5f/change_dbmail_pass-0001.bin<
/a><br>&gt;
>
&lt;/a&gt;&amp;quot;&lt;br&gt;&amp;g
t;
>
target=&amp;quot;_blank&amp;quot;&amp;gt;&lt
;a<br>&gt; href=&quot;<a
> href="http://mailman.fastxs.net/pipermail/dbmail/attachmen
ts/20040810/03d47c5f/change_dbmail_pass-0001.bin&quot;&q
uot;>
> http://mailman.fastxs.net/pipermail/dbm
ail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bi
n&quot;</a>&gt;<a
> href="ht
tp://mailman.fastxs.net/pipermail/dbmail/attachments/2004081
0/03d47c5f/change_dbmail_pass-0001.bin">
> http://mailman.fastxs.net/pipermail/dbmail/a
ttachments/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;D
bmail<br>&gt;
> mailing
list&lt;br&gt;&lt;a<br>&gt;
href=&quot;mailto:<a
> href="mailtobmaildbmail.org">
> Dbmaildbmail.org</a>&quot;&gt;<a
> href="mailtobmaildbmail.org">Dbmaildbmail.org</a>&lt;/a&gt;&lt;br&
gt;&lt;a<br>&gt;
> href=&quot;<a
> href="http
s://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/lis
tinfo/dbmail">https://mailman.fastxs.nl/mailman/list
info/dbmail</a>&lt;/a&gt;&lt;br&gt;&am
p;lt;/blockquote&gt;&lt;/div&gt;&lt;br&g
t;<br>&gt;<br>&gt;
> ------=_Part_14747_19566404.1135766140689--
>
<br>&gt;<br>&gt;<br><br><
br>_______________________________________________<br&
gt;Dbmail
> mailing list<br><a
> href="mailtobmaildbmail.org">Dbmaildbmail.org</a><br><a
> href="https://mailman.fastxs.nl/mailman/listinfo/dbmail&quo
t;>
> ht
tps://mailman.fastxs.nl/mailman/listinfo/dbmail</a><
;br></blockquote></div><br>
>
> ------=_Part_16959_26226770.1135787243926--
>
>


_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
[1]

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