...sorry...i didn't read the previus e-mail to the finish i saw only :
>ERROR 1126: Can't open shared library 'udf.so' (errno: 22 udf.so: cannot
----- Original Message -----
From: Elteto Zoltan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002 2:16 PM
Subject: Re: AW: User Define Function
No I have not :(((
And believe me I have tried several posibilities...
I have on one mysql server such a setup and
this works good.
So I have made a hardcopy on that server
and I have changed the startup paramaters.
The only different thing is the database.
after that comes
CREATE FUNCTION lookup RETURNS STRING SONAME "udf_example.so";
CREATE FUNCTION reverse_lookup RETURNS STRING SONAME "udf_example.so";
which said that everything is OK!!!
restart mysql
WITHOUT
--skip-grant-tables
so that the UDF initialisation to be OK ,too.
when
I try
select reverse_lookup('64.228.188.164');
I get
Stack trace seems successful - bottom reached
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x8236d38 =elect reverse_lookup('64.228.188.164')
thd->thread_id=
the error message is bigger but this is the important stuff!!
The server restarts :((
I mean the server crashes and not always restarts. :(
And I still don't know what is the problemm :(((
zoli
-------Original Message-------
From: Christian Rabe
Date: Thursday, April 18, 2002 14:07:56
To: Elteto Zoltan; [EMAIL PROTECTED]
Subject: AW: User Define Function
I'm having the same problem (Invalid Argument) at the moment.
Did you find any solution ?
Thanx
-----Ursprüngliche Nachricht-----
Von: Elteto Zoltan [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 16. April 2002 11:32
An: [EMAIL PROTECTED]
Betreff: User Define Function
Hi all,
I need to create 2 user defined functions.
lookup end reverse_lookup
These functiouns are included in the udf_example2.cc source file.
I have gcc version 2.96 20000731 (Red Hat Linux 7.0)
and
mysql-3.23.49-pc-linux-gnu-i686 (Binary distribution)
1)step: Compiling the udf_example2.cc file
gcc -shared -I /var/local/mysql/include -o udf.so udf_example2.cc
where
/var/local/mysql/include
is the folder where some mysql header files are included
This works fine.(I did not get any errors on that!!)
2) I have copied udf.so in the /usr/lib, where mysql searches for
so files ( this is the default folder for it, as I understand)
3) restart mysql
4) use mysql db
5) CREATE FUNCTION lookup RETURNS STRING SONAME "udf.so";
6) ERROR and this is bad for me:(
ERROR 1126: Can't open shared library 'udf.so' (errno: 22 udf.so: cannot
open shared object file: Invalid argument)
------------
What am I doing wrong?
Any help is appretiated!!
th
zoli
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
