Mailing-List: contact cygwin-help AT sourceware DOT cygnus DOT com; run by ezmlm
Sender: cygwin-owner AT sources DOT redhat DOT com
Date: Mon, 29 Oct 2001 02:31:40 +0100
From: "Gerrit P. Haase" <gp AT familiehaase DOT de>
Reply-To: "Gerrit P. Haase" <gp AT familiehaase DOT de>
Organization: Esse keine toten Tiere
Message-ID: <131739715474.20011029023140@familiehaase.de>
To: cygwin AT cygwin DOT com
Subject: mysql-3.23.43 builds
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="----------95247433CE7FDE"

------------95247433CE7FDE
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hallo Cygwinners,

Create a group cyg_mysql and a user mysql with NT's user-management.
Add them in the right files (/etc/group & /etc/passwd), rename user
cyg_mysql to mysql, then build from the sources (patch is attached).

Put the attached patch and the source package (http://www.mysql.com)
in your build tree (e.g. /src/database):

$ tar zxvf mysql-3.23.43.tar.gz

$ cd mysql-3.23.43

$ patch -p0 < ../mysql.patch
patching file `extra/resolveip.c'

NOTE: you may change '--prefix=/usr' to another location
      and add '-mpentiumpro' before '-felide-constructors'
      to CXXFLAGS.

$ CFLAGS="-O3" \
> CXX=gcc \
> CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \
> ./configure \
> --prefix=/usr \
> --enable-assembler \
> --with-mysqld-ldflags=-all-static \
> --with-mysqld-user=mysql \
> --with-berkeley-db \
> --with-innodb \
> 2>&1 | tee log.configure

$ make 2>&1 | tee log.make

$ make test 2>&1 | tee log.test
       NOTE:
       there is a problem with communication through
       sockets here, see attached test.log for infos.
       This test fails!!!
       any socket specialists out there to give a
       hint? I have no idea.

$ make install 2>&1 | tee log.make

$ make init-db 2>&1 | tee log.init

$ cd /usr ; /usr/bin/safe_mysqld &

$ cd sql-bench
$ ./run-all-tests
Benchmark DBD suite: 2.14
Date of test:        2001-10-29  2:08:35
Running tests on:    CYGWIN_NT-4.0 1.3.3(0.46/3/2) i686
Arguments:
Comments:
Limits from:
Server version:      MySQL 3.23.43

alter-table:

(It is still running...)

NOTE:
These sql-bench-tests requires the Perl modules DBI & DBD::mysql
to be installed:

$ perl -MCPAN -eshell
cpan> install DBI
cpan> install DBD::mysql
cpan> quit


Ciao,

Gerrit P. Haase                          mailto:gp AT familiehaase DOT de
-- 
=^..^=
------------95247433CE7FDE
Content-Type: application/octet-stream; name="mysql.patch"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="mysql.patch"

LS0tIGV4dHJhL3Jlc29sdmVpcC5jLm9yaWcJU3VuIE9jdCAyOCAyMTo0MzowMyAyMDAxCisrKyBl
eHRyYS9yZXNvbHZlaXAuYwlTdW4gT2N0IDI4IDIxOjQyOjQxIDIwMDEKQEAgLTMxLDcgKzMxLDcg
QEAKICNpbmNsdWRlIDxteV9zeXMuaD4KICNpbmNsdWRlIDxnZXRvcHQuaD4KIAotI2lmICFkZWZp
bmVkKF9BSVgpICYmICFkZWZpbmVkKEhBVkVfVU5JWFdBUkU3X1RIUkVBRFMpICYmICFkZWZpbmVk
KEhBVkVfVU5JWFdBUkU3X1BPU0lYKSAmJiAhZGVmaW5lZChoX2Vycm5vKQorI2lmICFkZWZpbmVk
KF9BSVgpICYmICFkZWZpbmVkKEhBVkVfVU5JWFdBUkU3X1RIUkVBRFMpICYmICFkZWZpbmVkKEhB
VkVfVU5JWFdBUkU3X1BPU0lYKSAmJiAhZGVmaW5lZChoX2Vycm5vKSAmJiAhZGVmaW5lZChfX0NZ
R1dJTl9fKQogZXh0ZXJuIGludCBoX2Vycm5vOwogI2VuZGlmCiAK

------------95247433CE7FDE
Content-Type: application/octet-stream; name="log.test"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="log.test"

Y2QgbXlzcWwtdGVzdCA7IC4vbXlzcWwtdGVzdC1ydW4KSW5zdGFsbGluZyBUZXN0IERhdGFiYXNl
cwpSZW1vdmluZyBTdGFsZSBGaWxlcwpJbnN0YWxsaW5nIE1hc3RlciBEYXRhYmFzZXMKMDExMDI5
ICAzOjAzOjM1ICBXYXJuaW5nOiBHb3Qgc2lnbmFsIDE0IGZyb20gdGhyZWFkIDEKMDExMDI5ICAz
OjAzOjM1ICAuLi9zcWwvbXlzcWxkOiBTaHV0ZG93biBDb21wbGV0ZQoKSW5zdGFsbGluZyBTbGF2
ZSBEYXRhYmFzZXMKMDExMDI5ICAzOjAzOjM3ICBXYXJuaW5nOiBHb3Qgc2lnbmFsIDE0IGZyb20g
dGhyZWFkIDEKMDExMDI5ICAzOjAzOjM3ICAuLi9zcWwvbXlzcWxkOiBTaHV0ZG93biBDb21wbGV0
ZQoKU3RhcnRpbmcgTXlTUUwgZGFlbW9uCkxvYWRpbmcgU3RhbmRhcmQgVGVzdCBEYXRhYmFzZXMK
U3RhcnRpbmcgVGVzdHMKCiBURVNUICAgICAgICAgICAgICAgICAgICAgICAgIFVTRVIgICBTWVNU
RU0gIEVMQVBTRUQgICAgICAgIFJFU1VMVAotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KYWxpYXMgICAgICAgICAg
ICAgICAgICAgICAgICAgLi4uLiAgICAgLi4uLiAgICAgLi4uLiAgICAgICBbIGZhaWwgXQoKL3N0
dWZmL2RhdGFiYXNlL215c3FsLTMuMjMuNDMvY2xpZW50L215c3FsdGVzdDogRmFpbGVkIGluIG15
c3FsX3JlYWxfY29ubmVjdCgpOiBDYW4ndCBjb25uZWN0IHRvIGxvY2FsIE15U1FMIHNlcnZlciB0
aHJvdWdoIHNvY2tldCAnL3N0dWZmL2RhdGFiYXNlL215c3FsLTMuMjMuNDMvbXlzcWwtdGVzdC92
YXIvdG1wL215c3FsLW1hc3Rlci5zbycgKDExMSkgQ29tbWFuZCBleGl0ZWQgd2l0aCBub24temVy
byBzdGF0dXMgMSByZWFsIDEyLjg1IHVzZXIgMC4wMyBzeXMgMC4wNSAKQWJvcnRpbmcuIFRvIGNv
bnRpbnVlLCByZS1ydW4gd2l0aCAnLS1mb3JjZScuCgpFbmRpbmcgVGVzdHMKU2h1dHRpbmctZG93
biBNeVNRTCBkYWVtb24KCgcvc3R1ZmYvZGF0YWJhc2UvbXlzcWwtMy4yMy40My9jbGllbnQvbXlz
cWxhZG1pbjogY29ubmVjdCB0byBzZXJ2ZXIgYXQgJ2xvY2FsaG9zdCcgZmFpbGVkCmVycm9yOiAn
Q2FuJ3QgY29ubmVjdCB0byBsb2NhbCBNeVNRTCBzZXJ2ZXIgdGhyb3VnaCBzb2NrZXQgJy9zdHVm
Zi9kYXRhYmFzZS9teXNxbC0zLjIzLjQzL215c3FsLXRlc3QvdmFyL3RtcC9teXNxbC1tYXN0ZXIu
c28nICgxMTEpJwpDaGVjayB0aGF0IG15c3FsZCBpcyBydW5uaW5nIGFuZCB0aGF0IHRoZSBzb2Nr
ZXQ6ICcvc3R1ZmYvZGF0YWJhc2UvbXlzcWwtMy4yMy40My9teXNxbC10ZXN0L3Zhci90bXAvbXlz
cWwtbWFzdGVyLnNvY2snIGV4aXN0cyEKTWFzdGVyIHNodXRkb3duIGZpbmlzaGVkCldhcm5pbmc7
ICBBYm9ydGVkIHdhaXRpbmcgb24gcGlkIGZpbGU6ICcvc3R1ZmYvZGF0YWJhc2UvbXlzcWwtMy4y
My40My9teXNxbC10ZXN0L3Zhci9ydW4vbXlzcWxkLXNsYXZlLnBpZCcgYWZ0ZXIgMTAgc2Vjb25k
cwpTbGF2ZSBzaHV0ZG93biBmaW5pc2hlZAptYWtlOiAqKiogW3Rlc3RdIEVycm9yIDEK


------------95247433CE7FDE
Content-Type: text/plain; charset=us-ascii

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/
------------95247433CE7FDE--