Description: When compiling mysql-3.23.36, many *.cc files caused a compilation error that said that __tz has multiple data definitions in /usr/include/sys/time.h. It first happens in the client subdirectory, but happens many times after that as well. I am using RH Linux 2.2.16-22smp gcc version 2.95.3 20010315 (release) How-To-Repeat: ./configure --prefix=/usr/local/mysql make Fix: The problem is in sys/time.h. This definition: extern int gettimeofday (struct timeval *__restrict __tv, __timezone_ptr_t __restrict __tz) __THROW; Above that in sys/time.h is this: #if defined __USE_GNU || defined __USE_BSD typedef struct timezone *__timezone_ptr_t; #else typedef void *__timezone_ptr_t; #endif The problem is that when compiling mysql, __USE_GNU is not defined, so in the declaration of gettimeofday, the wrong type is declared for __tz, which conflicts with its definition somewhere else. SO, in the mysql-3.23.36 source directory, in include/global.h, if you define __USE_GNU before the lines to include sys/time.h, #define __USE_GNU the compilation runs smoothly, with no more problems. Thank you, Greg Submitter-Id: none Originator: Gregory Berry Organization: none MySQL support: none Synopsis: __tz problem in sys/time.h Severity: critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.36 (Source distribution) Server: lt-mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i686 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 3.23.36 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 50 sec Threads: 1 Questions: 9 Slow queries: 0 Opens: 6 Flush tables: 1 Open \ tables: 0 Queries per second avg: 0.180 Environment: System: Linux localhost 2.2.16-22smp #1 SMP Tue Aug 22 16:39:21 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 14 Mar 19 16:33 /lib/libc.so.6 -> libc-2.1.92.so -rwxr-xr-x 1 root root 4776568 Aug 30 2000 /lib/libc-2.1.92.so -rw-r--r-- 1 root root 22607104 Aug 30 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Aug 30 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ --------------------------------------------------------------------- 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