I found one possible problem. I compiled the udf_exaple.cc with -shared etc. After that I did a ldconfig -l udf_example.so and got: ldconfig: ./udf_example.so is not a shared library
I havn't found a solution yet. -----Ursprüngliche Nachricht----- Von: Elteto Zoltan [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 18. April 2002 13:17 An: Christian Rabe; [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: 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 = select reverse_lookup('64.228.188.164') thd->thread_id=7 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
