MySQL 4 on HPUX 11.11 setup failures

[Victor Cintron]

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.

[Steven E. Protter]

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

[T G Manikandan]

signal 11 error,

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

Check for the ulimit variable on the users.


$ulimit

[Jim Butler]

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!

[Victor Cintron]

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]

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.