| View previous topic :: View next topic |
| Author |
Message |
Starfox
Tux's lil' helper
Joined: 04 Sep 2002
Posts: 93
|
 Posted: Sat Oct 05, 2002 10:39 pm Post subject: Installation of MySQL fails - mysql_install_db does not work |
 |
|
HI folks,
when emerging MySQL on gentoo-1.4-rc1 i discovered an error while the needed installation script mysql_install_db is running. While searching forum and internet, i discovered no one had these problems before!???
Anyone here, who is able to imagine whats going wrong???
When runnning mysql_install_db following happens (even after many rebuilds with other USE and CFLAGS!):
| Code: |
root@btr0n32:~ $ mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
021006 0:32:54 /usr/libexec/mysqld: Shutdown Complete
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/etc/init.d/mysql start (you have to start the server first!)
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h btr0n32 password 'new-password'
See the manual for more instructions.
|
So far i see, a set of files namend
| Code: |
root@btr0n32:~ $ l /var/lib/mysql/mysql/
total 16
-rw-rw---- 1 mysql mysql 0 Oct 3 01:02 func.MYD
-rw-rw---- 1 mysql mysql 1024 Oct 3 01:02 func.MYI
-rw-rw---- 1 mysql mysql 8641 Oct 3 01:02 func.frm
|
are created, but when i try to start mysqld, i am told the following by /var/log/mysql/mysql.err
| Code: |
021006 00:36:05 mysqld started
021006 0:36:05 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
021006 00:36:05 mysqld ended
|
Anyone here discoverd (and solved) similar problems????
Thanks for help!
Starfox |
|
| Back to top |
|
 |
rac
Bodhisattva
Joined: 30 May 2002
Posts: 6553
Location: Japanifornia
|
| Posted: Sat Oct 05, 2002 11:41 pm Post subject: |
|
|
Is your hostname set up correctly? What does the hostname command (or uname -a) report? What sort of filesystem is /var/lib/mysql on?
_________________
For every higher wall, there is a taller ladder |
|
| Back to top |
|
|
fmalabre
Guru
Joined: 19 Jun 2002
Posts: 376
Location: Chicago
|
| Posted: Sun Oct 06, 2002 1:54 pm Post subject: Re: Installation of MySQL fails - mysql_install_db does not |
|
|
| Starfox wrote: | | When runnning mysql_install_db following happens (even after many rebuilds with other USE and CFLAGS!): |
I don't have all those errors...
I run Gentoo 1.4 RC1, on an old mmx 166 (it took a while to compile!). |
|
| Back to top |
|
|
Starfox
Tux's lil' helper
Joined: 04 Sep 2002
Posts: 93
|
| Posted: Sun Oct 06, 2002 2:06 pm Post subject: |
|
|
| rac wrote: | | Is your hostname set up correctly? What does the hostname command (or uname -a) report? What sort of filesystem is /var/lib/mysql on? |
Hi,
normaly the hostname settings should be okay, as i am running exactly the settings on my LFS, and there it works!
| Code: |
pts/0: : 4 file(s) : 76Kb
root@btr0n32:~ $ hostname
btr0n32
pts/0: : 4 file(s) : 76Kb
root@btr0n32:~ $ hostname -s
btr0n32
pts/0: : 4 file(s) : 76Kb
root@btr0n32:~ $ hostname -f
btr0n32.rz.uni-bayreuth.de
root@btr0n32:~ $ uname -a
Linux btr0n32 2.4.19 #3 Thu Sep 26 11:46:12 CEST 2002 i586 AuthenticAMD
|
And /var/lib/mysql is on a reiserfs, just like on my working LFS!
I tried the mysql-3.23.52.ebuild and the mysql-3.23.52-r1.ebuild!
None of them fixed the problem.
While hacking in the mysql_install_db file i realized that the commands are right (hostname, etc.) but it sems like mysql can read the table format!!! How could this happen????
Thanks for help!
Starfox |
|
| Back to top |
|
|
rac
Bodhisattva
Joined: 30 May 2002
Posts: 6553
Location: Japanifornia
|
| Posted: Sun Oct 06, 2002 5:59 pm Post subject: |
|
|
Weird. I'm running a MySQL 4.0 prerelease here, so I can't duplicate your problem either. You could try filing a bug report on https://bugs.gentoo.org.
EDIT: Moving from Installing Gentoo, which covers initial installation of the system, to Networking and Security, as MySQL generally is used as a networking daemon.
_________________
For every higher wall, there is a taller ladder
Last edited by rac on Mon Oct 07, 2002 7:53 am; edited 1 time in total |
|
| Back to top |
|
|
Starfox
Tux's lil' helper
Joined: 04 Sep 2002
Posts: 93
|
| Posted: Sun Oct 06, 2002 6:23 pm Post subject: |
|
|
hmm, maybe i should try the 4.0 version, too. Il report if that will solve my problem!
thx fox |
|
| Back to top |
|
|
RebelYell
n00b
Joined: 28 Jun 2002
Posts: 41
|
| Posted: Mon Oct 07, 2002 10:27 am Post subject: |
|
|
| I have the same problem, too... |
|
| Back to top |
|
|
Starfox
Tux's lil' helper
Joined: 04 Sep 2002
Posts: 93
|
| Posted: Mon Oct 07, 2002 10:43 am Post subject: |
|
|
@Rebel:
What architectur do you have? I Have an AMD K6-300 MHz, and my USE is USE="... -berkdb innodb mysql..." CFLAGS="-O3 -march=k6 -fomit-frame-pointer" (but other flags did no difference!)
Fox |
|
| Back to top |
|
|
Starfox
Tux's lil' helper
Joined: 04 Sep 2002
Posts: 93
|
| Posted: Mon Oct 07, 2002 8:18 pm Post subject: |
|
|
Hmm, so i finaly found the bug (MAYBE, have to do some testing to proof that!).
When changing the CFLAGS to | Code: | | CFLAGS="-O3 -march=i586 -pipe -fomit-frame-pointer" |
( _changed from -march=k6 to -march=i586 !!!!), I got a working MySQL!
Seems like the gcc-3.2 produces bulls**t code while compiling mysql with -march=k6 !!!
Maybe anyone can proof my thesis, so we can fill a bug report, and fix the ebuild!
Fox |
|
| Back to top |
|
|
RebelYell
n00b
Joined: 28 Jun 2002
Posts: 41
|
| Posted: Tue Oct 08, 2002 7:41 am Post subject: |
|
|
| Starfox wrote: | @Rebel:
What architectur do you have? I Have an AMD K6-300 MHz, and my USE is USE="... -berkdb innodb mysql..." CFLAGS="-O3 -march=k6 -fomit-frame-pointer" (but other flags did no difference!)
Fox |
CPU: K6-2
CFLAGS: -03 -march=k6-2 -pipe -fomit-frame-pointer
Gentoo 1.4 UT2k3 |
|
| Back to top |
|
|
RebelYell
n00b
Joined: 28 Jun 2002
Posts: 41
|
| Posted: Tue Oct 08, 2002 7:44 am Post subject: |
|
|
| Starfox wrote: | Hmm, so i finaly found the bug (MAYBE, have to do some testing to proof that!).
When changing the CFLAGS to | Code: | | CFLAGS="-O3 -march=i586 -pipe -fomit-frame-pointer" |
( _changed from -march=k6 to -march=i586 !!!!), I got a working MySQL!
Seems like the gcc-3.2 produces bulls**t code while compiling mysql with -march=k6 !!!
Maybe anyone can proof my thesis, so we can fill a bug report, and fix the ebuild!
Fox |
Hmm... i guess you're right. I just tried the mysql ebuild on AthlonXP with -march=athlon-xp and guess what? Success! 
I'll try later with that K6-2 using the i586 cflag and report the result.
Thanks for figuring out this one! |
|
| Back to top |
|
|
rac
Bodhisattva
Joined: 30 May 2002
Posts: 6553
Location: Japanifornia
|
| Posted: Wed Oct 09, 2002 5:56 am Post subject: |
|
|
Sorry it took me so long to get back on this, but I tried emerge mysql on my K6 (first generation), with GCC 3.2 and "-march=k6 -O2", and had no problems with mysql_install_db. So maybe it's not only architecture-specific, but optimization flag specific also.
_________________
For every higher wall, there is a taller ladder |
|
| Back to top |
|
|
Starfox
Tux's lil' helper
Joined: 04 Sep 2002
Posts: 93
|
| Posted: Wed Oct 09, 2002 1:38 pm Post subject: |
|
|
Okay, i'll try out that one and report the results. Have you tried the -O3 and -march=k6 flag, too. What happend on your system then???
fox |
|
| Back to top |
|
|
RebelYell
n00b
Joined: 28 Jun 2002
Posts: 41
|
| Posted: Sun Oct 13, 2002 10:24 am Post subject: |
|
|
| Starfox wrote: | Okay, i'll try out that one and report the results. Have you tried the -O3 and -march=k6 flag, too. What happend on your system then???
fox |
I got a working mysql on k6-2 too 
Changing the k6-2 with i586 seems to be the trick... |
|
| Back to top |
|
|
Starfox
Tux's lil' helper
Joined: 04 Sep 2002
Posts: 93
|
| Posted: Mon Oct 14, 2002 9:49 am Post subject: |
|
|
Fine, I will add a bug report to the "gentoozilla".
Thanks for help!
PS: Have you tried to install MySQL++1.7.9 ?? |
|
| Back to top |
|
|
Starfox
Tux's lil' helper
Joined: 04 Sep 2002
Posts: 93
|
| Posted: Tue Dec 10, 2002 8:39 am Post subject: |
|
|
SOLUTION for this problem:
This problem occures while using gcc-3.2, mysql*, and CFLAGS='-march=k6{-2}{-3} ...'.
Changing
| Code: | | CFLAGS='-march=k6{-2}{-3} ...' |
into
| Code: | | CFLAGS='-march=i586 ...' |
does the trick, and solves the problem. |
|
| Back to top |
|
|
|
Networking & Security
