Ive just upgraded my PC to AMD64 and FC3 (for AMD64). I use MySQL and have lots of User defined functions, on my old machine (Pent 3 Mandrake 9.1) these were easy to install, a simple comple and put the .so file in the /usr/lib dir and everything was fine.

Under FC3 a completely different story!!! Having suspected that MySQL was not compiled correctly i.e didnt have the --with-mysqld-ldflags=-rdynamic set I installed the source RPMS (3.23.58-14) and rebuilt the packages with this option set.

I then proceeded to reinstall the RPMS and build my .so file, no problems to this point everything seems to be going smoothly. I put the .so file in /usr/lib (ive also tried /usr/lib/mysql and /usr/lib64/mysql since too).

Now when I try to execute this command:
CREATE FUNCTION udf_group_price RETURNS REAL SONAME 'race_functions.so'
I always receive this error:
ERROR 1126 at line 1: Can't open shared library 'race_functions.so' (errno: 22 race_functions.so: cannot open shared object file: No such file )

Its as though it cant open the .so file or doesnt understand the format. This is the result of doing a file on it:
[root@localhost src]# file /usr/lib/race_functions.so
/usr/lib/race_functions.so: ELF 64-bit LSB shared object, AMD x86-64, version 1 (SYSV), not stripped

So im stumped, any ideas? is this an AMD64 related issue?

Thanks

Jason McCaul

All sorted now.

I basically uninstalled all versions of MySQL, if you install using up2date or yum or choose to install as part of the initial installationt then both the x86_64 and i386 rpms get installed which may have something to do with the probs.

I then downloaded the source and recompiled ensuring dynamic option was configured, installed these X86_64 rpms only then built my .so file, placed the so file in /usr/lib64/mysql (unstripped!!), added this dir to /etc/ld.so.conf and then edited the safe_mysqld script to export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib64/mysql

doing that seemed to solve the probs thankfully.