Issue with loading a library in support of a user function on 64 bit systems

------_=_NextPart_001_01C7131A.6B32CEFA
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


I have built mysql using...

./configure --prefix=3D/hptc_cluster/paul/mysql-5.1.11 =
--with-plugins=3Dmax --with-mysqld-ldflags=3D-rdynamic make make install

The startup command I used was...

mysqld_safe --user=3Dmysql --server-id=3D50 --port=3D33306 =
--pid-file=3Dpid50 --skip-innodb --socket=3D$PWD/var/sock50 =
--log=3D$PWD/var/my50.log --event-scheduler=3DON =
--plugin_dir=3D$PWD/lib/mysql &

I placed my own and the example UDF .so files in the lib/mysql directory =
referred to by the plugin_dir variable.  I was unable to create the =
function, kept getting 'error 22 cannot open shared object file: No such =
file or directory'. Then I tried placing the .so files in /usr/lib and =
that worked on my development system (using 5.1.11)...

Linux pcarlton1 2.6.11-1.1369_FC4 #1 Thu Jun 2 22:55:56 EDT 2005 i686
i686 i386 GNU/Linux

However, when I repeated the process on two other 64 bit systems (both =
with 5.1.11 and 5.1.12) I got the error 22 problem, even when adding the =
.so files to /usr/lib.

Linux n5 2.6.9-22.7hp.1sp.XCsmp #1 SMP Thu Mar 23 21:35:55 EST 2006
x86_64 x86_64 x86_64 GNU/Linux

Any ideas?

I've reported this as a bug: http://bugs.mysql.com/24548


Thanks

Paul Carlton=20
Real Time Software Division=20

Mobile:    +44 (0)7768 994283=20
EMail:     [email protected]=20



------_=_NextPart_001_01C7131A.6B32CEFA--