Chris Cameron writes:
> Hi,
>
> Seems I've never had any luck with MySQL and OpenBSD, and I'm hoping I can
> finally get some help now that I've finally got around to recompiling it
> again.
>
> I'm running OpenBSD 2.7 and am compiling MySQL 3.23.38. I'm using the
> configure options;
> "CXXFLAGS="-O6 -march=i586" CFLAGS="-O6 -march=i586" ./configure
> --with-unix-socket-path=/var/mysq/mysql.sock --with-mysqld-user=mysql
> --without-debug --low-memory --without-docs --without-bench
> --without-readline "
> When it stops on sql_yacc.cc, I just compile that seperately and
> everything finishes nicely.
>
> Now, when I do a 'make test', I get exactly this (I appologize for the
> wrapping):
>
> lt-mysqltest: At line 1576: query 'select
> companynr,count(price),sum(price),min(price),max(price),avg(price) from t3
> group by companynr ' failed: 2013: Lost connection to MySQL server during
> query real 148.53 user 0.28 sys 0.44
> Aborting. To continue, re-run with '--force'.
>
> Ending Tests
> Shutting-down MySQL daemon
>
> lt-mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/usr/src/mysql-3.23.38/mysql-test/var/tmp/mysql-master.sock' (61)'
> Check that mysqld is running and that the socket:
> '/usr/src/mysql-3.23.38/mysql-test/var/tmp/mysql-master.sock' exists!
> master not cooperating with mysqladmin, will try manual kill
> ./mysql-test-run[781]: kill: 15515: No such process
> master refused to die. Sending SIGKILL
> ./mysql-test-run[781]: kill: 15515: No such process
> Master shutdown finished
> Slave shutdown finished
> *** Error code 1
>
> Stop in /usr/src/mysql-3.23.38 (line 499 of Makefile).
>
> Almost every version of MySQL I've ever run on this machine has given me
> the error "Lost connection to MySQL server". The last version I was
> running worked fine for about 50 days straight until that's all it'd print
> out without a refresh every half day (MySQL 3.23.35).
>
> -Any- help on this would be appreciated as all my other calls for help
> have gone unanswered.
>
> Thanks,
> Chris
>
>
Hi!
You should follow other instructions for OpenBSD found in our manual,
includein "-felide-constructors -fno-rtti -fno-exceptions".
Also use gcc 2.95.2 compiler.
Before running make test, run make install as a root.
Last but not least, read a chapter on how to setup socket file
location.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php