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 replication stuff.
> 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 this table, mysql replication errors occur and replication
> dies. Simply by removing the usage of RAND(), replication is not affected.
So it seems MySQL has a problem. Would be interesting to know which
MySQL version (if they differ between the servers both of course) and
if MySQL developers already know about this problem.
MySQL shouldn't replicate the RAND() but it's result.
But as a work around for all those that would be affected one will in
fact have to use the function modified (albeit less secure!), by
exchanging 'ROUND(RAND()*10)' with any number from 1 to 28.
--
Best regards
Peter Palmreuther
