starting up mysql 5.1.3 on HP-UX 11.31 (406 Views)
Reply
Advisor
Dee Jacobs
Posts: 34
Registered: ‎06-01-2010
Message 1 of 10 (406 Views)

starting up mysql 5.1.3 on HP-UX 11.31

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?
Please use plain text.
Honored Contributor
Emil Velez
Posts: 1,450
Registered: ‎05-17-2000
Message 2 of 10 (406 Views)

Re: starting up mysql 5.1.3 on HP-UX 11.31

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.
Please use plain text.
Honored Contributor
Viktor Balogh
Posts: 1,007
Registered: ‎03-15-2009
Message 3 of 10 (406 Views)

Re: starting up mysql 5.1.3 on HP-UX 11.31

Here is the doc about the MySQL Toolkit for ServiceGuard.

http://docs.hp.com/en/5991-7432/ar01s06.html
****
Unix operates with beer.
Please use plain text.
Advisor
Dee Jacobs
Posts: 34
Registered: ‎06-01-2010
Message 4 of 10 (406 Views)

Re: starting up mysql 5.1.3 on HP-UX 11.31

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
Please use plain text.
Honored Contributor
Viktor Balogh
Posts: 1,007
Registered: ‎03-15-2009
Message 5 of 10 (406 Views)

Re: starting up mysql 5.1.3 on HP-UX 11.31

Hi,

It seems to me a mysql bug similar to this:

http://bugs.mysql.com/bug.php?id=24270
****
Unix operates with beer.
Please use plain text.
Advisor
Dee Jacobs
Posts: 34
Registered: ‎06-01-2010
Message 6 of 10 (406 Views)

Re: starting up mysql 5.1.3 on HP-UX 11.31

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.
Please use plain text.
Exalted Contributor
Steven E. Protter
Posts: 33,806
Registered: ‎08-15-2002
Message 7 of 10 (406 Views)

Re: starting up mysql 5.1.3 on HP-UX 11.31

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Please use plain text.
Advisor
Dee Jacobs
Posts: 34
Registered: ‎06-01-2010
Message 8 of 10 (406 Views)

Re: starting up mysql 5.1.3 on HP-UX 11.31

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.
Please use plain text.
Exalted Contributor
Steven E. Protter
Posts: 33,806
Registered: ‎08-15-2002
Message 9 of 10 (406 Views)

Re: starting up mysql 5.1.3 on HP-UX 11.31

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Please use plain text.
Advisor
Dee Jacobs
Posts: 34
Registered: ‎06-01-2010
Message 10 of 10 (406 Views)

Re: starting up mysql 5.1.3 on HP-UX 11.31

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.
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation