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
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
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/