Migration of mysql 3.23.32 from Tru64 to RHEL 5.1

[Tom C Swigg]

I have been given the task of migrating some 200+ web sites fom Tru64
UNIX to Red Hat Enterprise Linux 64 bit V5.1

Many of these sites use PHP3 (3.0.18) and mysql 3.23.32 and the
developers have long gone...

The objective is to provide a 3.23.32 environment on RHEL 5.1 which
will run in parallel with the native mysql 5.0.22.

I have tried to compile mysql 3.23.32 on RHEL 5.1 and get the
following error:


g++ -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr/local/mysql-3.23.32\""
-DDATADIR="\"/usr/local/mysql-3.23.32/var\""
-DSHAREDIR="\"/usr/local/mysql-3.23.32/share/mysql\""
-DHAVE_CONFIG_H -I./../include                   -I./../regex
-I. -I../include -I.. -I.    -O3 -DDBUG_OFF -O4
-fno-implicit-templates -c sql_lex.cc
sql_map.h: In constructor 'mapped_file::mapped_file(char*, byte*,
uint)':
sql_map.h:49: error: 'map_file' was not declared in this scope
item_sum.h: At global scope:
item_sum.h:173: error: expected `)' before '*' token
item_sum.h: In member function 'virtual Item*
Item_sum_avg::result_item(Field*)':
item_sum.h:199: error: no matching function for call to
'Item_avg_field::Item_avg_field(Item_sum_avg* const)'
item_sum.h:170: note: candidates are: Item_avg_field::Item_avg_field()
item_sum.h:170: note:
Item_avg_field::Item_avg_field(const Item_avg_field&)
item_sum.h: At global scope:
item_sum.h:208: error: expected `)' before '*' token
item_sum.h: In member function 'virtual Item*
Item_sum_std::result_item(Field*)':
item_sum.h:233: error: no matching function for call to
'Item_std_field::Item_std_field(Item_sum_std* const)'
item_sum.h:205: note: candidates are: Item_std_field::Item_std_field()
item_sum.h:205: note:
Item_std_field::Item_std_field(const Item_std_field&)
make[3]: *** [sql_lex.o] Error 1
make[3]: Leaving directory `/usr/local/src/mysql/mysql-3.23.32/sql'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/usr/local/src/mysql/mysql-3.23.32/sql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/src/mysql/mysql-3.23.32'
make: *** [all-recursive-am] Error 2

______________________________________________________________________
______________________________________________________________________
____________

The configure statements are:

CC="cc -pthread "
CFLAGS="-O"
CXX="g++"
CXXFLAGS="-O -fpermissive -fabi-version=0 -pthread"
export CC CFLAGS CXXFLAGS CXX
./configure --prefix=/usr/local/mysql-3.23.32 --enable-large-files
--with-mysqld-ldflags=-all-static  --with-pthread
--with-mysqld-user=maxirat
--with-unix-socket-path=/usr/local/mysql/mysql-3.23.32.socket
--disable-shared --host=i386


G++ is version 4.1.2


Platform is VM running on ESX 3.5 on hp bl25p bladeservers (AMD)

______________________________________________________________________
______________________________________________________________________
______________


I have to do something similar for legacy php 4.2.3 again linked with
mysql 3.23.32.
We do not have the resources to migrate the code to mysql 5 and php 5
so building a mysql3/4 environment on RHEL 5.1 is essential.
Any help gratefully received.



Tom Swigg
LSBU

 
--
Email has been scanned for spam and viruses by Altman Technologies' email management
service

Copyright in this email and in any attachments belongs to London South Bank University.
This email, and its attachments if any, may be confidential or legally privileged and is
intended to be seen only by the person to whom it is addressed. If you are not the
intended recipient, please note the following: (1) You should take immediate action to
notify the sender and delete the original email and all copies from your computer
systems; (2) You should not read copy or use the contents of the email nor disclose it or
its existence to anyone else.

The views expressed herein are those of the author(s) and should not be taken as those of
London South Bank University, unless this is specifically stated.

London South Bank University is a company limited by guarantee registered in England and
Wales. The following details apply to London South Bank University: Company number -
00986761; Registered office and trading address - 103 Borough Road London SE1 0AA; VAT
number - 778 1116 17; Email address - lsbuinfo@stripped