[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Configuring MySQL 4.0.0 with SSL shortens idle timeout horribly
From:       gordonb () airmail ! net
Date:       2001-10-31 19:53:49
[Download RAW message or body]

> 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     gordon@rat.hammy.lonestar.org:/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 <mysql-thread89653@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


[prev in list] [next in list] [prev in thread] [next in thread]