Problem installing rpm on a RH8

Problem installing rpm on a RH8

am 18.02.2003 11:51:12 von Luca Carrabba

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: simply install an rh8 linux (italian) and install
(using root account) all your rpm packages. I did a "light"
installation of rh8 (samba, gd library, freetype, kde, apache, php,
imagemagick) to install typo3, a cms.

--
Best regards,

Luca Carrabba mailto:luca.carrabba@arke-media.com
Linux Consultant
Arkè media srl
www.arke-media.com
info@arke-media.com
tel. +39 0883.480545


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13799@lists.mysql.com
To unsubscribe, e-mail

Re: Problem installing rpm on a RH8

am 18.02.2003 13:58:37 von Lenz Grimmer

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

thanks for your message.

On Tue, 18 Feb 2003, Luca Carrabba wrote:

> 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.

[...]

> 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:

Yes, adding a "mysql" user was the correct fix.

> [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!

Thanks for pointing this out! We've found the reason for this problem in
the meanwhile and it will be fixed for the upcoming 4.0.11 release.

When renaming "MySQL.rpm" to "MySQL-server.rpm", I forgot to to make this
name change for the postinstall scripts in the RPM spec file.

http://mysql.bkbits.net:8080/mysql-4.0/cset@1.1575?nav=index .html|ChangeSet@-2w

Sorry for the inconvenience!

Bye,
LenZ
- --
For technical support contracts, visit https://order.mysql.com/?ref=mlgr
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer
/_/ /_/\_, /___/\___\_\___/ Hamburg, Germany
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.0 (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/

iD8DBQE+Ui3+SVDhKrJykfIRAvVPAJ0SQ4bJenJ4gmGzC+RUlhJty7lQ7ACf cHJu
L6n6Dpg0FRpXaP7ssQCvQQE=
=E+p8
-----END PGP SIGNATURE-----

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13800@lists.mysql.com
To unsubscribe, e-mail