MySQL obnoxious question

[Mário Gamito <gamito@xxxxxxxxx>]

Hi,

Sorry for the little off-topic, but the vpoopmail list is kind of dead.

I'm running a qmail server with vpopmail with MySQL authentication.

For obnoxious reasons, I'm running a web site in Windows/ASP.NET/C# that 
once a user registers, it inserts in the MySQL qmail server the 
username, password, etc.

It's in the password that the problem lies.
I need to hash it just before or after the MySQL INSERT statement.
For that, I have to run a PHP shell script that follows my signature.

Problem is MySQL doesn't run external commands.

Any ideas ?

Any help would be appreciated.

Warm Regards,
Mário Gamito

--

<?php

function randltr() {
 $retval = 'a';
 $rand = rand() % 64;
 if ($rand < 26) $retval = $rand + 'a';
 if ($rand > 25) $retval = $rand - 26 + 'A';
 if ($rand > 51) $retval = $rand - 52 + '0';
 if ($rand == 62) $retval = ';';
 if ($rand == 63) $retval = '.';
 return($retval);
}

function mkpasswd3(&$clearpass, &$crypted) {
 srand ((double)microtime()*1000000);

 $salt = '$1$';
 for ($i = 0; $i < 5; $i++) $salt .= randltr();
 $salt .= '0';
 $crypted = crypt($clearpass, $salt);
 if (strlen($crypted) > 0) return(true);
 return(false);
}

$clearpass = 'yeshua';
$crypted = '';

if (mkpasswd3($clearpass, $crypted))
 printf("%s -> %s\n", $clearpass, $crypted);
else
echo("Ohoh");
-
To unsubscribe from this list: send the line "unsubscribe linux-admin" in
the body of a message to majordomo@xxxxxxxxxxxxxxx
More majordomo info at  http://vger.kernel.org/majordomo-info.html