Don Read wrote:
> On 26-Jul-2001 sachin shetty wrote:
> > Hi
> > Is it possible to authenticate a logged on user by comparing the unix
> > passwd file entry with the mysql user table entry(after copying passwords
> > from the password file to the table).
>
> The password_crypt routine used in MySQL is incompatible with the DES/MD5 crypt
> used for Unix passwords.
> Besides, MySQL user-names have nothing to do with Unix login-names.
>
Isnt' the idea of DES crypt to be a standard method of encryption? Why would
mysql's DES crypt be different then Unix? It would seem weird that Perl crypt, PHP
crypt and Unix crypt are all the same, but mysql crypt is different, what's the
point of having it at all then? And mysql user names do have nothing to do with
the names in /etc/password, but administrators *could* make then the same if they
choose.
>
> > If there is a module that handles
> > this during connection of the mysql client to the server,
>
> Maybe once PAM & Kerberos become common-place, the user community could
> submit some patches ?
>
> > then it saves
> > the risk of sending password across network
> >
>
> What makes you think the password goes over the network ?
>
> Regards,
> --
> Don Read [EMAIL PROTECTED]
> -- It's always darkest before the dawn. So if you are going to
> steal the neighbor's newspaper, that's the time to do it.
> (53kr33t w0rdz: sql table query)
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
