Explaination of ERROR 1126 (HY000): Can't open shared library

[John Dunne]

Hi,

I'm trying to understand why I'm getting the following error from mysql

ERROR 1126 (HY000): Can't open shared library 'distance.so' (errno: 22 /usr/lib/mysql/plugin/distance.so: failed to map segment from shared object: Permission denied)

when i try to add a UDF usign the following command

CREATE FUNCTION distance RETURNS INTEGER soname "distance.so";

Can anyone offer advise as to what may be causing this error? The file ownership and permissions aren't the cause, file is owned by mysql and full executable/write/read have been tried.

Thanks in advance for any help!