UDFs must be copied to the UDFs directory not in the Directory where the
Database resides.
On unix it is: /opt/firebird/UDF/ and the firebird process (user) must have
the rights to execute the UDF!

Michael

_____

Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Im Auftrag von testfirst235
Gesendet: Montag, 28. April 2008 14:39
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] UDF library causes broken pipe on Linux, but
works with FB on Windows



Hello

I need to create UUIDs with Firebird Superserver on Linux (Version
2.03 from Ubuntu). I have installed the uuidlibv12.zip (by Ian Newby)
into the example Employee database. Flamerobin shows his four
functions installed as UDFs. Firebird is running OK, because "select
123 from RDB$DATABASE" works fine.
However, when I run the query

"select UUID_CREATE() from RDB$DATABASE"

I get an error dialog, with a serious system error and a broken pipe.
I have reinstalled Ubuntu 8.04 in case there was a problem with the
recent beta, but no change. These UDFs work fine on a Windows
installation. No useful information found when searching for the error
code. Only solution is to disconnect and reconnect the database. Any
ideas what I am doing wrong?

Thanks, Rob

Statistics log shown below:

====================================
select 123 from RDB$DATABASE
====================================
Starting transaction...
Preparing query: select 123 from RDB$DATABASE
Prepare time: 00:00:00.
Field #01: . Alias: Type:INTEGER
PLAN (RDB$DATABASE NATURAL)

Executing...
Done.
5 fetches, 0 marks, 0 reads, 0 writes.
0 inserts, 0 updates, 0 deletes, 0 index, 1 seq.
Delta memory: 2172 bytes.
Execute time: 00:00:00.
Preparing query: select UUID_CREATE() from RDB$DATABASE
Prepare time: 00:00:00.
Field #01: .UUID_CREATE Alias:UUID_CREATE Type:STRING(22)
PLAN (RDB$DATABASE NATURAL)

Executing...
Done.

====================================
select UUID_CREATE() from RDB$DATABASE
====================================
*** IBPP::SQLException ***
Context: Database::Statistics
Message: isc_database_info failed

SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements

Engine Code : 335544721
Engine Message :
Unable to complete network request to host "localhost".
Error writing data to the connection.
Broken pipe

Execute time: 00:00:02.

====================================
(Now trying to do same query as before)

select 123 from RDB$DATABASE
====================================
*** IBPP::SQLException ***
Context: Database::Statistics
Message: isc_database_info failed

SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements

Engine Code : 335544721
Engine Message :
Unable to complete network request to host "localhost".
Error writing data to the connection.
Broken pipe

Execute time: 00:00:00.






[Non-text portions of this message have been removed]