By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,245 Members | 1,103 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,245 IT Pros & Developers. It's quick & easy.

mysql-4.1.6-gamma source install on fedora2 - errors

P: n/a
Hello to everone,

As mentioned in this *guide(1), i've compiled mysql on my fedora Core
2 system, with the following spec's :

*(1) http://hulan.info/blog/index.php?itemid=576

--------------- 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.
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
hq*****@gmail.com (Maxim. V.) wrote in message news:<b4*************************@posting.google.c om>...
Hello to everone,

As mentioned in this *guide(1), i've compiled mysql on my fedora Core
2 system, with the following spec's :

*(1) http://hulan.info/blog/index.php?itemid=576

--------------- 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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.