Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL 4 on HPUX 11.11 setup failures

Victor Cintron
Occasional Contributor

MySQL 4 on HPUX 11.11 setup failures

I just installed mysql-4.0.15a depot and then the problems start. I run mysql_install_db as root and as normal user to setup the tables and start ok. I get 'Preparing db table, Preparing host table etc...' ... then after 'Installing all prepared tables' I get 'mysqld got signal 11; this could be a bug' ... 'Installation of grant tables failed! ... and some more messages on how to start mysql. All parameters are defaults. The folders mysql and test are created in the var folder with database files.

Then I just try to run mysql_safe as rootand normal user and it runs just fine(mysqld and mysqld_safe show up in the process list) but any attempts to get the status or ping using mysqladmin results in 'connect to server at "localhost" failed' ... 'error: lost connection to MySQL server during query'. This is most likely due to not being able to setup the grant tables with mysql_install_db. But the server nonetheless runs. The same errors happen with the mysql command.

Running mysqld directly as a normal user also results in signal 11 error.

I believe I tried everything in the documentation to no avail. Any help or ideas will be greatly appreciated.
5 REPLIES
Steven E. Protter
Exalted Contributor

Re: MySQL 4 on HPUX 11.11 setup failures

I'm not a big mysql user but.....

Besides installation of the depot no operations should ever be done on a database as root user.

The reason is root user can get ownerhip on shared memory resources and then the database locks up.

I would start over and run mysql_install_db as the user that owns the database binaries.

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
T G Manikandan
Honored Contributor

Re: MySQL 4 on HPUX 11.11 setup failures

signal 11 error,

check for any patches.Might be a pre-requisite.

Check for the ulimit variable on the users.


$ulimit
Jim Butler
Valued Contributor

Re: MySQL 4 on HPUX 11.11 setup failures

did you set up a mysql admin user?
If not, set one up, and retry the table setups.
(that's the way we did it - but it was HP 11 and I hand built the mysql from scratch - and it was YEARS ago.... )

But I do remember having to set up a user.

Good Luck, and Happy New Year!
Man The Bilge Pumps!
Victor Cintron
Occasional Contributor

Re: MySQL 4 on HPUX 11.11 setup failures

I am going to try the patches since it looks like it needs a bunch of them. I have already setup a mysql user and will install it with that once I get the patches all done. I will reply back with the results.
Victor Cintron
Occasional Contributor

Re: MySQL 4 on HPUX 11.11 setup failures

The patches did not help. I tried to build mysql but that only showed more problems with the compiler. I also tried to reinstall the official binary with a mysql user but no luck. The system will be reinstalled since it looks like there are more problems than just installing mysql.