Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

mysql-4.1.6-gamma source install on fedora2 - errors

 
   Database Forums (Home) -> mySQL RSS
Next:  Linked Cube Error: more than one distinct count m..  
Author Message
Maxim. V.

External


Since: Oct 21, 2004
Posts: 2



(Msg. 1) Posted: Thu Oct 21, 2004 4:44 pm
Post subject: mysql-4.1.6-gamma source install on fedora2 - errors
Archived from groups: mailing>database>mysql (more info?)

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) <a rel="nofollow" style='text-decoration: none;' href="http://hulan.info/blog/index.php?itemid=576" target="_blank">http://hulan.info/blog/index.php?itemid=576</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.

 >> Stay informed about: mysql-4.1.6-gamma source install on fedora2 - errors 
Back to top
Login to vote
Maxim. V.

External


Since: Oct 21, 2004
Posts: 2



(Msg. 2) Posted: Sat Oct 23, 2004 6:51 am
Post subject: Re: mysql-4.1.6-gamma source install on fedora2 - errors [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

(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 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Mysql data source name setup - Hello to all, I have a problem during connection to mysql through oledb provider. I use Microsoft Visual C++ with MFC on Windows and I try to connect to mysql with the following call: hResult = CDataSource::OpenFromInitializationString..

Export MYSQL database to install on ISP ASP.Net - Hi Guys, does anyone know how to export mysql so that i can set it up on my ISP windows server ??. i s there some sort of export command to do this ?? if there is a step by step guide on how to do this could someone please point me towards it. Thanks...

Errors and logs - In the my.cnf file, under [mysqld] I have log-error=/path/to/error log file directive. The last entries in this file are over an year ago. In case of MYSQL errors, such as improper roll backs or improper commits, shouldn't the errors be logged here. And....

Changing innodb log file size - errors? - Hi, I am using MySQL version 5.0 on Linux Fedora Core 4. I recently got this error message: 060609 11:06:29 InnoDB: ERROR: the age of the last checkpoint is 9433557, InnoDB: which exceeds the log group capacity 9433498. InnoDB: If you are using big..

ODBC install problem -
   Database Forums (Home) -> mySQL All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]