Re: MySQL UDF Repository problems getting it setup

[Arnold Daniels]

Hi again,

If you've installed mysql using apt-get, the lib needs to be in /usr/lib.

./configure --prefix=/usr && make && make install && make installdb

You might need to restart mysql after that.

Good luck,
Arnold


Thomas Raef wrote:

Now I get:

ERROR 1126 (HY000) at line 15: Can't open shared library 'lib_mysqludf_xql.so' (errno: 22 lib_mysqludf_xql.so: cannot open shared object file: No such file or directory)
Make: *** [installdb] Error 1

What am I missing?

lib_mysql_mysqludf_xql.so exists in /usr/local/lib

Thomas J. Raef
e-Based Security, LLC
http://www.ebasedsecurity.com
tr...@ebasedsecurity.com
1-888-251-5803

  

-----Original Message-----
From: Arnold Daniels [mailto:in...@adaniels.nl]
Sent: Tuesday, July 29, 2008 4:37 PM
To: Thomas Raef
Subject: Re: MySQL UDF Repository problems getting it setup

Hi,

You need to run `make installdb` after running `make install`.
I forgot to upload the changed build description to the website. Sorry
for the confusion.

Best regards,
Arnold



traef06 wrote:
    

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?


      

No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.5.6/1579 - Release Date:
7/29/2008 6:43 AM

    

No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 270.5.6/1579 - Release Date: 7/29/2008 6:43 AM