>Description:
Configuring MySQL 4.0.0 with --with-ssl causes the server to
act as though interactive_timeout and/or wait_timeout were
set to approximately 6 seconds, although the variables seem
to have normal values.
>How-To-Repeat:
Configure, build and install the server, including --with-ssl.
(See below for the configuration but without --with-ssl included.)
Start "mysqld_safe --user=mysql -l"
There are no my.cnf or .my.cnf files anywhere on this system.
There's nothing in the databases except the default grant tables.
Start the mysql client.
Type "show databases;".
Wait 7 seconds.
Type "show databases;" again. Client will complain about
the connection being lost and reconnect. Server is *NOT*
dumping core and restarting, as connection number keeps
going up and there are no kernel logs of core dumps.
Same problem with a select on one of the grant tables.
"show variables" indicates that wait_timeout and interactive_timeout
are set to the normal defaults, 28800 (?seconds?).
Deinstall and repeat above leaving out --with-ssl.
No disconnects this time.
Note: I haven't got nearly far enough to actually try to use SSL.
FreeBSD 4.3, Openssl 0.9.6, gcc 2.95.3
>Fix:
Don't use --with-ssl.
>Submitter-Id: <submitter ID>
>Originator: Gordon Burditt
>Organization:
Internet America
>MySQL support: none [none | licence | email support | extended email support ]
>Synopsis: Configuring SSL into mysqld shortens timeout horribly
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.0-alpha (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.22 Distrib 4.0.0-alpha, for -freebsd4.3 on
>i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.0-alpha-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 7 min 22 sec
Threads: 1 Questions: 4 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
Queries per second avg: 0.009
>Environment:
System: FreeBSD rat.hammy.lonestar.org 4.3-RELEASE FreeBSD 4.3-RELEASE #3: Tue Jun 26
19:32:45 CDT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/RAT i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 [FreeBSD] 20010315 (release)
Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='c++' CXXFLAGS='-O -pipe
-felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1174570 Jun 23 17:34 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Jun 5 00:42 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 561580 Jun 23 17:34 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=/var/db/mysql --without-perl
--without-debug --without-readline --without-bench --with-mit-threads=no
--with-libwrap --with-vio --without-isam --with-low-memory --enable-assembler
--prefix=/usr/local i386--freebsd4.3
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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
