libreadline.a could not load (revisited)

[BobMCT]

Fellow AIX'ers;

This has been an outstanding issue for quite some time on our AIX boxen here. MySQL is running fine in our production but we still don't have access to the mysql command line (shell).
As a user or root when we try to execute "mysql" we receive the error:
0509-150 Dependent module /usr/lib/libreadline.a (libreadline.so) could not be loaded.
0509-153 Member libreadline.so is not found in archive.

I've searched extensives on the web and usenet and have added the LIBPATH env variable and verified that it is indeed active when executing. Also, in the directory /usr/local/lib there is the libreadline.so.4 modules with is pointed to by several variatione of libreadline including from the /usr/lib directory.

Anyone else run up against this issue? All I want to do is execute the mysql command line utility!!!!

Ideas? Suggestions???

Thanks in advance.

Bob

 

[kHz]

Have you ran a 'dump -Tv' against the executable to see which specific files it is really calling?

 

[kHz]

And 'dump -Hv'

 

[RodKnowlton]

How did you install MySQL? bff, rpm, or did you build it yourself?

Mixtures of these methods can cause some links to get out sync.



Rod Knowlton
IBM Certified Advanced Technical Expert pSeries and AIX 5L
CompTIA Linux+
CompTIA Security+

 

[BobMCT]

Yes - both.

It is asking for libreadline.a AND libreadline.so

 

[BobMCT]

Installed from bff obtained from Bull freeware. Version is:
mysqld ver 3.23.35 for ibm-aix4.3.2.0 on powerpc

Don't know if there is a new binary bff available for aix 5.1?

 

[RodKnowlton]

I haven't check for a newer version, but I'm running the 3.23.35 client on 5.1.

Did you install freeware.gnu.readline.rte?



Rod Knowlton
IBM Certified Advanced Technical Expert pSeries and AIX 5L
CompTIA Linux+
CompTIA Security+

 

[BobMCT]

Yes, that was a dependency.
freeware.gnu.readline.rte 4.1.0.1 committed F

 

[RodKnowlton]

libreadline.so.4 is neither a part of freeware.gnu.readline.rte nor the toolbox rpm readline-4.3-1.

You need to figure out how they got there, and whether you can reinstall freeware.gnu.readline.rte, which simply places the libreadline.a file (no links) in the /usr/local/lib directory, without breaking anything.



Rod Knowlton
IBM Certified Advanced Technical Expert pSeries and AIX 5L
CompTIA Linux+
CompTIA Security+

 

[BobMCT]

Rod;

Here's the latest scoop:

On the IBM AIX site I located libreadline version 5.0.x SOURCE code and downloaded. I then did the requisite ./configure, make then make install. The process creates TWO libraries in the /usr/local/lib directory. The files are libreadline.a and libreadline.so.5 and I found out that I needed to make symlinks in /usr/lib and /usr/local/lib for both and for libreadline.so pointing to *.so.5

Did that. tried running mysql and got the SAME error. Set LIBPATH to /usr/local/lib and reran mysql. Got the same error but the path name reflected the LIBPATH value.

At this point I am stumped. I will continue to search but exhausted I am!

Thanks for you input and if you think of anything else, please hollar?

Bob