From owner-freebsd-database@FreeBSD.ORG Mon Jan 16 21:39:22 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A225916A41F for ; Mon, 16 Jan 2006 21:39:22 +0000 (GMT) (envelope-from knezour@weboutsourcing.cz) Received: from out.smtp.cz (ender.smtp.cz [81.95.97.119]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3033943D46 for ; Mon, 16 Jan 2006 21:39:20 +0000 (GMT) (envelope-from knezour@weboutsourcing.cz) Received: from vbmailshield.smtp.cz (jane.smtp.cz [81.95.97.121]) by out.smtp.cz (Postfix) with SMTP id ED8634CDA9 for ; Mon, 16 Jan 2006 22:39:18 +0100 (CET) Received: from [192.168.35.8] (gw.weboutsourcing.cz [82.208.3.19]) by out.smtp.cz (Postfix) with ESMTP id 5FE814CDA9 for ; Mon, 16 Jan 2006 22:39:18 +0100 (CET) Message-ID: <43CC120C.2090506@weboutsourcing.cz> Date: Mon, 16 Jan 2006 22:37:16 +0100 From: Ondra Knezour User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-database@freebsd.org Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit Subject: Debugging Firebird DB X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 16 Jan 2006 21:39:22 -0000 Dear all, I'm trying to use some comercial application (Linux binary, no sources available) on FreeBSD. This program runs as daemon, receive requests from win based clients, process them, connect to Firebird and send response back to client. However, there are some troubles with daemon <-> database communication, probably with processing daemons requests in database. I tried to watch communication with tcpdump and look on running db server with truss, but didn't get any usefull info. So my question is - can anybody direct me to some method how to watch actions taken in Firebird DB upon db client request? Some sql debugger/profiler? Or some reading about this? I have no success with searching. And second question - there are some UDFs (user defined functions libraries) for Firebird, Linux only again, compiled from Delphi, no sources available. Has anybody experince with using such .so files with Firebird? Using linuxpluginwrapper, decompilation and compilation on FreeBSD, any other way? Thanks for your time. -- Best Regards Ondra Knezour