From mboxrd@z Thu Jan  1 00:00:00 1970
From: =?ISO-8859-1?Q?M=E1rio_Gamito?= <gamito@gmail.com>
Subject: MySQL obnoxious question
Date: Wed, 20 Feb 2008 00:35:26 +0000
Message-ID: <47BB75CE.7070701@gmail.com>
Mime-Version: 1.0
Content-Transfer-Encoding: QUOTED-PRINTABLE
Return-path: <linux-admin-owner@vger.kernel.org>
Sender: linux-admin-owner@vger.kernel.org
List-ID: <linux-admin.vger.kernel.org>
Content-Type: text/plain; charset="iso-8859-1"; format="flowed"
To: linux-admin@vger.kernel.org

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.

=46or obnoxious reasons, I'm running a web site in Windows/ASP.NET/C# t=
hat=20
once a user registers, it inserts in the MySQL qmail server the=20
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.
=46or 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=E1rio Gamito

--=20

<?php

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

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

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

$clearpass =3D 'yeshua';
$crypted =3D '';

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@vger.kernel.org
More majordomo info at  http://vger.kernel.org/majordomo-info.html