mysql-3.23.43 builds

[Gerrit P. Haase]

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@familiehaase.de
-- 
=^..^=
mysql.patch
log.test
--
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/

-------------- next part --------------
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
011029  3:03:35  Warning: Got signal 14 from thread 1
011029  3:03:35  ../sql/mysqld: Shutdown Complete

Installing Slave Databases
011029  3:03:37  Warning: Got signal 14 from thread 1
011029  3:03:37  ../sql/mysqld: Shutdown Complete

Starting MySQL daemon
Loading Standard Test Databases
Starting Tests

 TEST                         USER   SYSTEM  ELAPSED        RESULT
------------------------------------------------------------------------
alias                         ....     ....     ....       [ fail ]

/stuff/database/mysql-3.23.43/client/mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through socket '/stuff/database/mysql-3.23.43/mysql-test/var/tmp/mysql-master.so' (111) Command exited with non-zero status 1 real 12.85 user 0.03 sys 0.05 
Aborting. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

/stuff/database/mysql-3.23.43/client/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/stuff/database/mysql-3.23.43/mysql-test/var/tmp/mysql-master.so' (111)'
Check that mysqld is running and that the socket: '/stuff/database/mysql-3.23.43/mysql-test/var/tmp/mysql-master.sock' exists!
Master shutdown finished
Warning;  Aborted waiting on pid file: '/stuff/database/mysql-3.23.43/mysql-test/var/run/mysqld-slave.pid' after 10 seconds
Slave shutdown finished
make: *** [test] Error 1
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mysql.patch
Type: text/x-diff
Size: 438 bytes
Desc: not available
URL: <http://cygwin.com/pipermail/cygwin/attachments/20011028/f9880037/attachment.bin>