From owner-freebsd-database@FreeBSD.ORG  Sat Jul  1 03:52:13 2006
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
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 3909016A506
	for <freebsd-database@freebsd.org>;
	Sat,  1 Jul 2006 03:52:13 +0000 (UTC)
	(envelope-from johnckoller@yahoo.com)
Received: from smtp108.sbc.mail.mud.yahoo.com (smtp108.sbc.mail.mud.yahoo.com
	[68.142.198.207])
	by mx1.FreeBSD.org (Postfix) with SMTP id A40E243D48
	for <freebsd-database@freebsd.org>;
	Sat,  1 Jul 2006 03:52:12 +0000 (GMT)
	(envelope-from johnckoller@yahoo.com)
Received: (qmail 10749 invoked from network); 1 Jul 2006 03:52:12 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Received:Received:From:To:Subject:Date:User-Agent:References:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Content-Disposition:Message-Id;
	b=LfRQgvTDEdvmbeNPGZif+E8n2EqBx4hE6y+Lhb5PzdyQ5Sox5IltrSNfOfEW2r1IHZuUEVnGa3Fr8aQnqEbroX7vcxud+ZHA2eap9dTAPYrlDi32EoaDoLp0vOv3pPudDquQbUSgEV6RQqo6BAfeU7urdoMi5ek6wpJDm0YxJZI=
	; 
Received: from unknown (HELO sword.localdomain) (johnckoller@70.246.58.16 with
	login)
	by smtp108.sbc.mail.mud.yahoo.com with SMTP; 1 Jul 2006 03:52:12 -0000
Received: by sword.localdomain (Postfix, from userid 1000)
	id 5E35918FA6; Fri, 30 Jun 2006 22:52:08 -0500 (CDT)
From: John Koller <johnckoller@yahoo.com>
To: freebsd-database@freebsd.org
Date: Fri, 30 Jun 2006 22:52:07 -0500
User-Agent: KMail/1.9.1
References: <94678bd60606300549m25b560e9t48d9775a21135647@mail.gmail.com>
In-Reply-To: <94678bd60606300549m25b560e9t48d9775a21135647@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200606302252.08021.johnckoller@yahoo.com>
Subject: Re: FreeBSD 6.1 & Firebird
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 01 Jul 2006 03:52:13 -0000

On Friday 30 June 2006 07:49, Aleks wrote:
> Hello!
>
> Yesterday I tried several times to setup a Firebird Server on a
> freshly installed FreeBSD 6.1 and connect to the example fdb via
> network, but with no success.
[snip]
> # isql
> Use CONNECT or CREATE DATABASE to specify database
> SQL> connect '/usr/local/share/examples/firebird/employee.fdb' user
[snip]
> SQL> connect 'localhost:/usr/local/share/examples/firebird/employee.fdb'
> user 'SYSDBA' password 'masterkey';
> Statement failed, SQLCODE =-902
>
> I/O error for file "/usr/local/share/examples/employee.fdb"
> -Error while trying to open file
> -No such file or directory
> SQL> quit;

Is the error message from the example listed or from different attempts that 
you pasted together? 

What are the permissions for /usr/local/share/examples/firebird/employee.fdb?

Can you create a database with
create database 'localhost:/var/db/firebird/test.fdb';
?

-- 
John Koller