[MySQL]ERROR 1126 (HY000) Permission Denied problem

Asked by shedh

Hi,

After looking at many different sites and forums I have not been able to find a solution for this problem, I have pasted this from a forum post I made last week.

Hi,

On the ubuntu 9.10 server edition I have been trying to add the Maatkit plugin for MySQL, prior to 9.10 I haven't had a problem as such, This is the MySQL query that I am trying to run:

CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'fnv_udf.so';

This is the error I keep getting:

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

The folders mysql & plugin, did not exist so i created them also i have changed the permission on the "mysql" & "plugin" folders and also the fnv_udf.so file to mysql:mysql

I am trying to use the udf to create the function fnv64(), i used this on a Ubuntu 8.04 LTS Server on which it worked.

Any help given to this problem I am getting will be greatly appreciated in advance

Shedh

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu mysql-dfsg-5.1 Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Chad Cramer (ccramer-tucows) said :
#1

I posted a solution to this here: http://forums.mysql.com/read.php?117,298997,298997#msg-298997

Its AppArmor. Its not configured properly for accessing the plugins directory.

Can you help with this problem?

Provide an answer of your own, or ask shedh for more information if necessary.

To post a message you must log in.