>Description:
<I installed MySQL-3.23.54a from source on AIX 5.1. It works fine
when I connect the server through unix socket as localhost. But whenever I tried to
connect the server though TCP/IP port, the server shutdown. >
>How-To-Repeat:
<I tried :
./bin/mysql -u root -p
it will work.
./bin/myql -u root -h myhost -p
it crashed and restarted.. (safe_mysqld)
System gives error: safe_mysqld[242]: 40666 Segmentation
fault(coredump)
Even when I tried to telnet: telnet myhost 3306 it gives the same error and
the server shutdown and restarted.
I checked the myhost.err file, there is no specific error message except, mysqls
restarted.
I also tried to install the binary version of MySQL3.23.54a, it has the same problem.
I haven't been able to compile MySQL 4.0.9gamma, it configured with no complain but
give erros like function confilcts when I tried to make.
>
>Fix:
>Submitter-Id: <submitter ID>
>Originator: DBA User
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.54 (Source distribution)
>Server: ../client/mysqladmin Ver 8.23 Distrib 3.23.54, for ibm-aix5.1.0.0 on powerpc
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.54-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 20 min 37 sec
Threads: 1 Questions: 3 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
Queries per second avg: 0.002
>Environment:
System: AIX boveri 1 5 000B078F4C00
Some paths: /usr/bin/perl /usr/linux/bin//make /usr/opt/freeware/bin/gmake
/usr/bin/gcc
GCC: Reading specs from
/usr/bin/../lib/gcc-lib/powerpc-ibm-aix5.1.0.0/2.9-aix51-020209/specs
gcc version 2.9-aix51-020209
Compilation info: CC='/usr/local/bin/gcc -pipe -Wa,-many' CFLAGS=''
CXX='/usr/local/bin/g++ -pipe -Wa,-many' CXXFLAGS='-felide-constructors
-fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 bin bin 19 Jan 6 15:04 /lib/libc.a ->
/usr/ccs/lib/libc.a
lrwxrwxrwx 1 bin bin 19 Jan 6 15:04 /usr/lib/libc.a ->
/usr/ccs/lib/libc.a
Configure command: ./configure '--enable-static' '--disable-shared'
'--prefix=/usr/local/mysql' '--localstatedir=/shark1/mysql/data'
'--sbindir=/usr/local/sbin' '--libexecdir=/usr/local/sbin'
'--enable-thread-safe-client' '--enable-large-files' '--with-mysqld-user=dba'
'--with-innodb' 'CC=/usr/local/bin/gcc -pipe -Wa,-many' 'CXXFLAGS=-felide-constructors
-fno-exceptions -fno-rtti' 'CXX=/usr/local/bin/g++ -pipe -Wa,-many'
---------------------------------------------------------------------
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
