Subject: RE: php-mysql-cygwin how to - have_crypt = YES ? have_openssl? mysqld under cygwin?
From: "Ralf Hauser" <[email-masked]>
To: <[email-masked]>, "andrew brian clegg" <[email-masked]>
Cc: <[email-masked]>
Date: Tue, 8 Jul 2003 14:15:34 +0200

> -----Original Message-----
> From: Elfyn McBratney [mailto:[email-masked]]
> Sent: Dienstag, 8. Juli 2003 12:00
> > [mysql client]
> >
> > Wanna try this myself sometime. Did you have to tweak it much or did it
> > compile out of the box?
> >
> > Andrew.
>
> From memory (haven't compiled MySQL on Cygwin for a while) it
> compiles fine, the
> only problem was, and perhaps still is, with the server.  The
> libraries work
> fine, too. I promised myself that I'd try and get it
> working...But so little
> time and so many things to do. :-)
>
> All it needs is a straight
>
>   ./configure --without-server --prefix=/usr
>   make; make install
Could you please check in this mysql client you compiled with "show
variables;" whether the "have_crypt" and the "have_openssl" are "NO" or
"YES".
If "YES", you might be able to get state-of-the art password verification
working in mysql under windows too!
see the use of the "encrypt()"  as per http://bugs.mysql.com/bug.php?id=784.

mysql> update TBL_USER set password= encrypt('holderio', '$1$saltsalt$')
where login= 'ameyer';
mysql> select encrypt( 'holderio', password) = password from TBL_USER where
login='ameyer';

P.S.: hopefully this solves it and we won't have to wait for the first
successful compilation of mysqld under cygwin.

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/