This is the mail archive of the
cygwin@cygwin.com
mailing list for the Cygwin project.
RE: php-mysql-cygwin how to - have_crypt = YES ? have_openssl? mysqld under cygwin?
- From: "Ralf Hauser" <ralfhauser at gmx dot ch>
- To: <cygwin at cygwin dot com>,"andrew brian clegg" <a dot clegg at mail dot cryst dot bbk dot ac dot uk>
- Cc: <elfyn at emcb dot co dot uk>
- Date: Tue, 8 Jul 2003 14:15:34 +0200
- Subject: RE: php-mysql-cygwin how to - have_crypt = YES ? have_openssl? mysqld under cygwin?
- Reply-to: <hauser at acm dot org>
> -----Original Message-----
> From: Elfyn McBratney [mailto:elfyn@emcb.co.uk]
> 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/