Hi, I tried to install mysql on PowerPC-LynxOS machine, and got into the following issues. If some body can help me resolve this, it would be of great help.
First I like to list the changes I did to compile mysql for PowerPC-LynxOS using cross compilers in sparc-sunos. Configure script changes ------------------------- 1) Changed ps options in lines which find out whether a particular process is running or not. In LynxOS it is ps -ax. In LynxOS scripts are shown as bash process, hence ps -ax | grep process_name will not fetch one for configure since it's process name is marked as bash. 2) In LynxOS for obtaining thread related functions you have to use -mthreads options, there is no thread library. Hence added check for -mthreads in configure script when checking for thread related features. 3) I was using cross compiler environment, configure script was trying to execute some binary produced for the host platform which failed, so I started with config outputs generated for a similar environment(LynxOS/x86) and tweaked it for the host. Makefile/Code changes --------------------- 1) I was using cross compiler environment, hence gen_lex_hash and conf_to_src compiled for the host platform didn't ran on the build environment, so I have generate these binary for build environment and modify Makefile to use them. Also removed -O3 flag in sql/Makefile since it was reporting undefined symbols with that option, In the following link, http://gcc.gnu.org/ml/gcc-prs/2002-11/msg01111.html they have adviced to remove that option for compiling it 2) vi_mode.c - Added the following # include <my_global.h> 3) my_pthread.h - LynxOS was offering a nonposix version of sigwait, so I had to modify the my_sigwait macro def in my_pthread.h to the below .... #ifndef HAVE_NONPOSIX_SIGWAIT #define my_sigwait(A,B) *B = sigwait((A),NULL) #else .... 4)system include file : sem.h Commented out mutex_exit macro in sem.h since it collides with mutex_exit function of innobase Some info about compilation : Release: mysql-4.0.15a (Source distribution) C compiler: 2.95.3 C++ compiler: 2.95.3 Environment: <machine, os, target, libraries (multiple lines)> System: LynxOS Decimus 0.7.0.0 PowerPC GCC: Using builtin specs. gcc version 2.9-gnupro-98r2 Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: Configure command: ./configure '--prefix=/users/spraja/usr/local/mysql' '--host=powerpc-unknown-lynxos' Then things went fine, and I got the mysql bins. When I run it on powerpc-lynxos, faced the following issues/problems. This is where I require help =============================================================== Decimus:/users/spraja/usr/local/mysql# bin/mysqladmin version bin/mysqladmin: connect to server at 'localhost' failed error: 'Lost connection to MySQL server during query' ============================================================== So I tried telnet connection to 3306 port ============================================================== Decimus:/users/spraja/usr/local/mysql# telnet Decimus 3306 Trying 172.16.254.93 ... Connected to Decimus. Escape character is '^]'. ( 4.0.15a\KBH$xQn <-- I pressed enter key <-- I pressed enter key pressed Bad handshakeConnection closed by foreign host. ============================================================== Log files content at time where ============================================================== Log files (hostname.err) 031015 06:28:27 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 031015 6:28:28 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 031015 6:28:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 031015 6:28:30 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 031015 6:28:33 InnoDB: Started /users/spraja/usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.0.15a' socket: '/tmp/mysql.sock' port: 3306 031015 6:29:16 Error on new connection socket: Socket operation on non-socket 031015 6:29:26 Error on new connection socket: Socket operation on non-socket 031015 6:31:39 Error on new connection socket: Socket operation on non-socket 031015 6:32:08 Error on new connection socket: Socket operation on non-socket mysqld got signal 6; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16384 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 19215 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. free: pid[91] : Double free of 0x215b8e68 allocated at 0x10374c44:0x10374a90:0x10378d98 ============================================================== I tried stopping the server, but in vain ============================================================== Decimus:/users/spraja/usr/local/mysql# ./share/mysql/mysql.server stop Killing mysqld with pid 108 Wait for mysqld to exit\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c gave up waiting! ============================================================== Thanks in advance, Regards, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]