starting up mysql 5.1.3 on HP-UX 11.31

[Dee Jacobs]

mysql was installed by HP from HAOE distribution. I am trying to start it up and some things are unclear. I used mysql.server script to start it up and it appeared to run OK. Then I put mysql.server in the sg/service in a package for mysql on serviceguard. The log says it started up and immediately shutdown. The package start failed. Then I find mysqld and mysqld_safe. Those don't start it up. Log file says: /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
100726 10:57:16 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
I tried the mysql_upgrade and it says it can't find mysql.sock.
What is the proper procedure to start it up in a package as a service?

[Emil Velez]

There is a toolkit for mysql in the ECMT for legacy and modular packages. That should provide a well tested and supported script for mysql for SG. You should check the documentation and make sure that mysql is completely installed and setup before putting it in a SG package.

[Viktor Balogh]

Here is the doc about the MySQL Toolkit for ServiceGuard.

http://docs.hp.com/en/5991-7432/ar01s06.html

[Dee Jacobs]

Viktor, thanks for the doc. I'll get it read this morning.

Emil.
I am using mysql in stand-alone mode. I fire it up with mysqld_safe and it starts to set up, but stops -- can't find mysql.host. I have attached the log. Please take a look at it. Here's /etc/my.cnf --

[mysqld]
datadir=/data2a/mysql/data
basedir=/usr/local/mysql
port=3306
user=root

[Viktor Balogh]

Hi,

It seems to me a mysql bug similar to this:

http://bugs.mysql.com/bug.php?id=24270

[Dee Jacobs]

Given all that, what can you tell me about mysql.host which is the FATAL error that kills the startup?
The other one evidently can be worked around if the server starts, but the mysql.host stops it, so that must be mastered first. I know nothing about this file and I don't find anything like it anywhere on the system.

[Steven E. Protter]

Shalom,

You may need to update mysql from the http://software.hp.com site.

You will have to probably write a package script to start mysql up in ServiceGuard. The generic documentation will help.

A package script usually does the following:

1) Activates the volume group.
2) Starts the service
3) monitors the service.

SEP

[Dee Jacobs]

Thanks, Steven,
I have built my own package and it is running successfully through everything I can throw at it. My package does not have a service. It is an in-cluster logger.
I picked up on mysql next because it has a server. This is where I have had trouble.
Originally, on mysql, I set it up with mysql.server as standalone and it appeared to work, but it would not go right in the package (sg/service). It would start and immediately stop. Next to the documentation. There seem to be three paths to setting it up: mysql.server, mysqld_safe and two approaches as a package (legacy and modular). the README didn't help at all as I can't separate the two methods from the doc. I tried now mysqld_safe and after some more discovery, got the my.cnf set up. Now I am here. Tanks in advance for any advice. I will check out the software update you recommend tomorrow.

[Steven E. Protter]

Shalom,

If you have a bug, you may have no choice but to update the software or recompile.

The SG scripts you were recommended were written for the HP release of mysql

SEP

[Dee Jacobs]

HP software support says that mysql as delivered is not supported. It is just a decoration placed there to impress.
As a follow up- I downloaded the latest Community release from mysql.com and the same thing occurs. If it doesn't start it's just a dead weight.