MySQL 4.0.15a on HPUX 11i is not running!

[Rgomes]

Hi,

I installed followings:


#swlist
# Initializing...
# Contacting target "rootdns"...
#
# Target: rootdns:/
.
.
gcc 3.3.2 gcc
guile 1.6.0 guile
mysql 4.0.15a mysql
ncurses 5.3 ncurses
#

But whenever I run,
# /usr/local/mysql/bin/mysql_install_db
I got the following message:
/usr/lib/dld.sl: Can't open shared library: /usr/local/lib/libz.sl
/usr/lib/dld.sl: No such file or directory
/usr/local/mysql/bin/mysql_install_db[73]: 4232 Abort(coredump)
/usr/local/mysql/bin/mysql_install_db[116]: 4234 Abort(coredump)
/usr/local/mysql/bin/mysql_install_db[119]: 4235 Abort(coredump)
WARNING: The host 'rootdns' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL deamon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
/usr/lib/dld.sl: Can't open shared library: /usr/local/lib/libz.sl
/usr/lib/dld.sl: No such file or directory
/usr/local/mysql/bin/mysql_install_db[309]: 4236 Abort(coredump)
Installation of grant tables failed!

Examine the logs in /usr/local/mysql/var for more information.
You can also try to start the mysqld daemon with:
/usr/local/mysql/libexec/mysqld --skip-grant &
You can use the command line tool
/usr/local/mysql/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/local/mysql/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /usr/local/mysql/var that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script!
#


Any help?
TIA

Richard

[T G Manikandan]

First search the path of libz.sl and add it to the SHLIB_PATH

Also,

check your name resolution.

The hostname -ip resolution is not happening.
check that out!!

[Rgomes]

Hi TG,

Thanks for your reply.

Let me check, I'll give feedback tomorrow. Already out-off office :(

with best regards,
Richard

[Rgomes]

Hi TG,

I could not find libz.sl.

# find / -name dld.sl
/usr/lib/dld.sl
/usr/lib/pa20_64/dld.sl
/usr/lib/aCC/dld.sl
# find / -name libz.sl
#

And my SHLIB_PATH has these entries:
# more SHLIB_PATH
/usr/lib:/etc/opt/resmon/lib
#

What to do next??

TIA,
Richard

[Rgomes]

Hi TG,

There is a good link which I found,

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=205299

As per Harry, I installed zlib,
# ls -l /usr/local/lib/libz*
-rw-r--r-- 1 root sys 79724 May 20 2003 /usr/local/lib/libz.a
-rwxr-xr-x 1 root sys 65536 May 20 2003 /usr/local/lib/libz.sl

but now I need libcrypto.sl, because whenever I run

$ /usr/local/mysql/bin/mysql_install_db
.
.
.
/usr/lib/dld.sl: Can't open shared library: /usr/local/lib/libcrypto.sl
......

I am looking for it.

regards,
Richard

[Rgomes]

Hi,

I also installed openssl after that libcrypto is fixed. But still facing some memory+buffer related issues. You can see it in the attachment.

TIA,
Richard

[Sridhar Bhaskarla]

Hi,

This is what I understood from your attachment. Error 11 may be a clue or it may be completely misguiding error from that software.

Error 11 is EAGAIN - no more processes.It means you will need to increase maxuprc kernel parameter - Maximum number of processes that a user can run.

Look at your "kmtune -l -q maxuprc" and do

a 'ps -ef|grep your_user|wc -l' and see if they are close. If so, you will need to increase this kernel parameter.

On 11i, this is a dynamic parameter. You can change it on the fly.

kmtune -s maxuprc=1024
kmtune -u

If maxuprc is not the culprit, then check the system wide process table - nproc. You can verify it by running sar -v 2 20 and look at proc-sz.

If both are not the case, then as you said it may be a problem with the package itself. libcrypto and libz are SSL/zlib libraries and are not available by default with HP-UX. They might have provided compatible versions along with this software.

-Sri

[Rgomes]

Hi Sri,

Thanks! You can see the attachemnt.

best regards,
Richard

[Sridhar Bhaskarla]

Hi Richard,

EAGAIN is not necessarily an indication of 'number of processes' as I mentioned before.

Moreover, you would need to find the processes run as that user just about when it is giving out the error.

If the above is not the case, then it's most likely a compatibility problem between zlib/ssl and your mysql.

See if you get ssl and zlib along with MYSQL.

-Sri

[Rgomes]

Thanks Sri, I'll do that.

regards,
Richard