problems getting it setup

[traef06]

Debian 2.6.16.14, MySQL version: 5.0.32

I downloaded the tarball, untarred it, ./configure, make, make
install.

All went well, however, I cannot get mysql to recognize that it's got
this plugin.

When I added plugin_dir to my.cnf it errored and wouldn't start.

If I take that out, it won't recognize the query:

SELECT xql_element('recipient', recvr) from mail;

I get: ERROR 1305 (42000) FUNCTION blocked.xql_element does not exist.

What did I miss in the setup?

[Roland Bouman]

Hi!

> I downloaded the tarball, untarred it, ./configure, make, make
> install.

sounds right

> All went well, however, I cannot get mysql to recognize that it's got
> this plugin.

Do

SELECT *
FROM mysql.func

to find out

>
> When I added plugin_dir to my.cnf it errored and wouldn't start.

??? UDFs (or true plugins) and my.cnf have no bearing upon each other.
Nothing to do with my.cnf

> If I take that out, it won't recognize the query:
>
> SELECT xql_element('recipient', recvr) from mail;
>
> I get: ERROR 1305 (42000) FUNCTION blocked.xql_element does not exist.
>
> What did I miss in the setup?

This I don't know. I would expect you to have seen some errors
occurring in the ./configure make make install sequence.

Please try again and look for error messages.

kind regards,

Roland