Description:
Date: Tue, 18 Feb 2003 11:51:12 +0100
From: Luca Carrabba <luca.carrabba@arke-media.com>
To: bugs@lists.mysql.com
Subject: Problem installing rpm on a RH8
Hello ,
I installed mysql 4 on my linux rh8 pc (duron 950MHz, 256MB ram, Linux
danny.arke.lo 2.4.18-18.8.0 #1 Wed Nov 13 22:52:09 EST 2002 i686
athlon i386 GNU/Linux) using rpm files downloaded from your website.
Exactly:
[root@danny mysql]# rpm -qa |grep -i mys
MySQL-server-4.0.10-0
php-mysql-4.1.2-7.3.6
MySQL-client-4.0.10-0
MySQL-embedded-4.0.10-0
MySQL-shared-4.0.10-0
MySQL-devel-4.0.10-0
I've tried to start it but I had a lot of problem, whereas the previos
version I installed on a redhat 7.2:
[root@arkebest root]# rpm -qa |grep -i mys
MySQL-devel-4.0.8-0
php-mysql-4.1.2-7.3.6
MySQL-client-4.0.8-0
MySQL-4.0.8-0
MySQL-shared-4.0.8-0
MySQL-embedded-4.0.8-0
started without any problem using "service mysql start" at the first
time.
So, when I started it the first time it replied that there's no mysql
user and other errors. I add a new user, mysql in my sistem:
[root@danny mysql]# rpm -qa |grep -i mys
...
mysql:x:500:500:MySQL Server:/var/lib/mysql:/bin/bash
(I hope this is correct, I need a suggestion), then I tried to start
"manually" the server using:
[root@danny log]# su -c "/usr/sbin/mysqld start" mysql
bash: /root/.bashrc: Permission denied
030218 11:31:00 InnoDB: Started
030218 11:31:00 Fatal error: Can't open privilege tables: Can't find file:
'./mysql/host.frm' (errno: 13)
030218 11:31:00 Aborting
030218 11:31:00 InnoDB: Starting shutdown...
030218 11:31:02 InnoDB: Shutdown completed
030218 11:31:02 /usr/sbin/mysqld: Shutdown Complete
For many times. I tried to list the contents of /var/lib/mysql:
[root@danny mysql]# ll
totale 20560
-rw-rw---- 1 mysql root 3324 feb 18 11:28 danny.arke.lo.err
-rw-rw---- 1 mysql mysql 25088 feb 17 16:04 ib_arch_log_0000000000
-rw-rw---- 1 mysql mysql 10485760 feb 18 11:31 ibdata1
-rw-rw---- 1 mysql mysql 5242880 feb 18 11:31 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 feb 17 16:04 ib_logfile1
drwx------ 2 root root 4096 feb 18 11:28 mysql
drwx------ 2 root root 4096 feb 18 11:28 test
so I tried to "repair" the situation using (let me know if it's
correct):
[root@danny mysql]# chown -R mysql.mysql *
[root@danny mysql]# ll
totale 20560
-rw-rw---- 1 mysql mysql 3324 feb 18 11:28 danny.arke.lo.err
-rw-rw---- 1 mysql mysql 25088 feb 17 16:04 ib_arch_log_0000000000
-rw-rw---- 1 mysql mysql 10485760 feb 18 11:31 ibdata1
-rw-rw---- 1 mysql mysql 5242880 feb 18 11:31 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 feb 17 16:04 ib_logfile1
drwx------ 2 mysql mysql 4096 feb 18 11:28 mysql
drwx------ 2 mysql mysql 4096 feb 18 11:28 test
and then it started without any other problem.
I don't know if the previous version on the other pc can give the same
problem, I installed yor rpm files to upgrade the previos mysql
installed (using RedHat rpm, 3.23.xx).
I hope this mail can help you to develop mysql better and better...
good work!
How to repeat:
Install the RPMs on a vanilla Red Hat System (or any other Linux distribution without a
pre-existing "mysql" user account)
Suggested fix:
Fix the RPM spec file to actually include the postinstallation scripts that are supposed to
add the user account and install the privilege database.
