Re: [cobalt-users] RAQ2 MySQL 3.23 /PHP4.05 installation

["Ricky Boone" <ricky@xxxxxxx>]

> I want to do a MySQL 3.23 /PHP4.05 installation on a RAQ2,
> on looking through the archive I can find references to installing
> older versions of both of these, and the need to update glibc and
compilers.
>
> Are there any alternetives to compiling mySQL 3.23 on the RAQ2?
>
> Has anybody attempted this installation recently and can offer advice on
> the best way to go about the process. Thanks.

I have successfully compiled mySQL 3.23.37 following instructions posted to
this list (was a text file on a server, but is not accessable at the
moment).  Here ya go, straight from the text file...  (just replace 3.22.27
to 3.23.37, or whatever the latest ver is)


Part 1: Install MySQL

This is the longest part. In particular, compiling MySQL takes forever.

[1] Download MySQL:
    http://www.mysql.com/
    http://www.mysql.com/Downloads/MySQL-3.22/mysql-3.22.27.tar.gz

    A mirror list is at:
    http://www.mysql.com/mirrors.html

[2] Uncompress MySQL and delete the tarball:
    tar xzf mysql-3.22.27.tar.gz
    rm mysql-3.22.27.tar.gz

[3] Edit the configure file: (erased, since is unnecessary)


[4] Get the new glibc:
    ftp://ftp.cobaltnet.com/pub/experimental/

        glibc-profile-2.0.7-29C2.mips.rpm
        glibc-debug-2.0.7-29C2.mips.rpm
        glibc-devel-2.0.7-29C2.mips.rpm
        glibc-2.0.7-29C2.mips.rpm

[5] Install the new glibc:
    cd
    rpm -Uvh --force --nodeps glibc-*-29C2.mips.rpm

[6] Run ldconfig:
    /sbin/ldconfig

[6] Get egcs and libstdc++:
    (Alternately you could downnload and compile get gcc 2.95.1 and
libstdc++.)

    ftp://ftp.linux.sgi.com/pub/linux/mips/mipsel-linux/RPMS/mipsel/

        egcs-1.0.2-9.mipsel.rpm
        egcs-c++-1.0.2-9.mipsel.rpm
        egcs-g77-1.0.2-9.mipsel.rpm
        egcs-objc-1.0.2-9.mipsel.rpm
        libstdc++-2.8.0-9.mipsel.rpm
        libstdc++-devel-2.8.0-9.mipsel.rpm

[7] Install egcs & libstdc++
    rpm -e gcc-objc
    rpm -e gcc-c++
    rpm -e gcc
    rpm -Uvh egcs*-1.0.2-9.mipsel.rpm

    rpm -e libg++-devel-2.7.2.8
    rpm -i libstdc++*-2.8.0-9.mipsel.rpm


[8] Install mysql:
    cd mysql-3.22.27/
    ./configure --with-low-memory --disable-assembler --disable-shared \
    --with-mysqld-ldflags="-all-static" --with-client-ldflags="-all-static"
\
    mipsel-unknown-linux-gnu

(note: the \'s are mean the next line is part of the previous line, making
all 3 lines one command line)

    make
    make install

[9] Run the MySQL install script
    ./scripts/mysql_install_db

[10] Copy the MySQL start script:
     cp ./support-files/mysql.server /etc/rc.d/init.d/mysql
     chmod a+x /etc/rc.d/init.d/mysql

[11] Modify rc.local to start the MySQL server automatically:
     vi /etc/rc.d/rc.local

     put "/etc/rc.d/init.d/mysql start" at the very end.

[12] Start MySQL:
     /etc/rc.d/init.d/mysql start

[13] Give the root account a password:
     /usr/local/bin/mysqladmin -u root password 'new-password-goes-here'

--
Ricky Boone
ricky@xxxxxxx