(Maxim. V.) wrote in message ...
> Hello to everone,
>
> As mentioned in this *guide(1), i've compiled mysql on my fedora Core
> 2 system, with the following spec's :
>
<font color=purple> > *(1) <a rel="nofollow" style='text-decoration: none;' href="http://hulan.info/blog/index.php?itemid=576</font" target="_blank">http://hulan.info/blog/index.php?itemid=576</font</a>>
>
> --------------- bash START --------------
> $ uname -a
> Linux localhost.localdomain 2.6.8-1.521 #1 Mon Aug 16 09:01:18 EDT
> 2004 i686 ath
> lon i386 GNU/Linux
>
> $ gcc -v
> Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.3.3/specs
> Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
> --infodir=/u
> sr/share/info --enable-shared --enable-threads=posix
> --disable-checking --disabl
> e-libunwind-exceptions --with-system-zlib --enable-__cxa_atexit
> --host=i386-redh
> at-linux
> Thread model: posix
> gcc version 3.3.3 20040412 (Red Hat Linux 3.3.3-7)
>
> $ ldd --version
> ldd (GNU libc) 2.3.3
>
> $ rpm -qa | grep libtermcap
> libtermcap-2.0.8-38
> libtermcap-devel-2.0.8-38
>
> $ export CFLAGS="-march=athlon-xp -mcpu=athlon-xp -mfpmath=sse -msse2
> -O2 -pipe -s -fomit-frame-pointer"
> $ export CPPFLAGS="-march=athlon-xp -mcpu=athlon-xp -mfpmath=sse
> -msse2 -O2 -pipe -s -fomit-frame-pointer"
>
> $ cd /usr/local/src/mysql-4.1.6-gamma
> $ ./configure \
> --prefix=/usr/local/mysql \
> --with-unix-sock-path=/tmp/mysql.sock \
> --with-charset=utf8
> $ make
> $ make install
> --------------- bash END --------------
>
> when i get to the stage of creating the initial database this is what
> happens :
>
> --------------- bash START --------------
> $ /usr/local/mysql/bin/mysql_install_db --user=mysql
> mkdir: cannot create directory `/usr/local/mysql/var/mysql':
> Permission denied
> chmod: cannot access `/usr/local/mysql/var/mysql': Permission denied
> mkdir: cannot create directory `/usr/local/mysql/var/test': Permission
> denied
> chmod: cannot access `/usr/local/mysql/var/test': Permission denied
> Installing all prepared tables
> bin/mysql_install_db: line 1: 3185 Illegal instruction
> /usr/local/mysql/libexec/mysqld --bootstrap --skip-grant-tables
> --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var
> --skip-innodb --skip-bdb --skip-ndbcluster --user=mysql
> --max_allowed_packet=8M
> /usr/local/mysql/bin/mysql_create_system_tables: line 664: 3186
> Broken pipe cat <<END_OF_DATA
> use mysql;
> $c_d
> $i_d
>
> $c_h
> $i_h
>
> $c_u
> $i_u
>
> $c_f
> $i_f
>
> $c_t
> $c_c
>
> $c_ht
> $c_hc
> $c_hr
> $c_hk
>
> $c_tzn
> $i_tzn
> $c_tz
> $i_tz
> $c_tzt
> $i_tzt
> $c_tztt
> $i_tztt
> $c_tzls
> $i_tzls
> END_OF_DATA
>
> Installation of system tables failed!
>
> Examine the logs in /usr/local/mysql/var for more information.
> --------------- bash END --------------
>
>
> the logs contatin nothing useful.
> here is the permissions on the folder, tough it's pretty useless as i
> run the script as root
>
>
> --------------- bash START --------------
> $ ls -la /usr/local/mysql/var/
> total 20
> drwx------ 4 mysql root 4096 Oct 21 18:10 .
> drwxr-xr-x 12 root root 4096 Oct 21 05:11 ..
> -rw-rw---- 1 mysql root 94 Oct 21 18:12 localhost.localdomain.err
> drwx------ 2 mysql root 4096 Oct 21 05:11 mysql
> drwx------ 2 mysql root 4096 Oct 21 05:11 test
> --------------- bash END --------------
>
>
> on boot i get the following message :
>
>
> --------------- bash START --------------
> localhost login: /usr/local/mysql/bin/mysqld_safe: line 1: 2480
> Illegal instruction nohup /usr/local/mysql/libexec/mysqld
> --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql
> --pid-file=/usr/local/mysql/var/localhost.localdomain.pid
> --skip-locking --port=3306 --socket=/tmp/mysql.sock
> >>/usr/local/mysql/var/localhost.localdomain.err 2>&1
> STOPPING server from pid file
> /usr/local/mysql/var/localhost.localdomain.pid
> 041021 18:12:18 mysqld ended
> --------------- bash END --------------
>
> help ? (:
>
> Thank you, Maxim Vexler.
resolved.
bad compile, could be simply checked by running this command
--------------- bash START --------------
# /usr/local/mysql/libexec/mysqld --log
Illegal instruction
--------------- bash END --------------
once mysql was recompiled with the default CFLAGS & no configue flag
asides from [--prefix=/usr/local/mysql]
all went well.
(:
for general info, the hardware is : amd athlon-xp 2500, ram 512-geil,
mb abit nf7-sl.
LANG=en_US.UTF-8
>> Stay informed about: mysql-4.1.6-gamma source install on fedora2 - errors