Hello Jason,
On Saturday, October 26, 2002 at 8:54:20 PM you wrote:
>>> It appears that passing RAND() with no arguments to the pw_passwd field
>>> breaks mysql replication.
>> 1.) Anybody who can verify this? I don't run vpopmail on MySQL for
>> myself, so I can'T tell anything about this r
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I'm pretty sure you're generating this query from some script/program.
So, why don't you generate the random number in it?? That way, you
shouldn't have any problems with replication.
Just my $0.02.
Bye!
On 26 Oct 2002 18:54:20 -, Jason Smi
Peter,
a query such as the one below:
update your_domain_com set pw_passwd = ENCRYPT("anyvaluehere",CONCAT("$1
$",SUBSTRING(MD5("anyvaluehere"),ROUND(RAND()*10),5),"0")) where
pw_name='your_name_here'
This does produce an encrypted entry that can be authenticated against, but
when replicating
Hello Jason,
On Friday, October 25, 2002 at 10:02:53 PM Jason wrote:
> On Friday, October 11, 2002 at 10:38:04 AM Peter wrote:
>> ENCRYPT("",CONCAT("$1$",SUBSTRING(MD5(""), \
>> ROUND(RAND()*10),5),"0"))
> It appears that passing RAND() with no arguments to the pw_passwd field
> breaks my
It appears that passing RAND() with no arguments to the pw_passwd field
breaks mysql replication.
> Hello Ken,
>
> On Friday, October 11, 2002 at 1:32:14 AM you wrote:
>
> > You can use the MySQL crypt command. It calls the unix crypt()
> > function, so it's compatiable with vpopmail (and /etc/s
Hello Ken,
On Friday, October 11, 2002 at 1:32:14 AM you wrote:
> You can use the MySQL crypt command. It calls the unix crypt()
> function, so it's compatiable with vpopmail (and /etc/shadow)
One addition, to make it more md5-like:
ENCRYPT("",CONCAT("$1$",SUBSTRING(MD5(""),ROUND(RAND()*10),5)
