Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sources.redhat.com/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Reply-To:	<hauser AT acm DOT org>
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>
Subject:	RE: php-mysql-cygwin how to - have_crypt = YES ? have_openssl? mysqld under cygwin?
Date:	Tue, 8 Jul 2003 14:15:34 +0200
Message-ID:	<KJEOKFJJEDMIGBEEJCHCEEJBOHAA.ralfhauser@gmx.ch>
MIME-Version:	1.0
X-Priority:	3 (Normal)
X-MSMail-Priority:	Normal
Importance:	Normal
X-MimeOLE:	Produced By Microsoft MimeOLE V6.00.2600.0000
In-Reply-To:	<Pine.CYG.4.55.0307081056450.4008@ellixia>

> -----Original Message-----
> From: Elfyn McBratney [mailto:elfyn AT emcb DOT co DOT 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/

- Raw text -