From owner-freebsd-database@FreeBSD.ORG Sat Jul 1 11:59:17 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 18D3416A415 for ; Sat, 1 Jul 2006 11:59:17 +0000 (UTC) (envelope-from i.am.aleks@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by mx1.FreeBSD.org (Postfix) with ESMTP id B41A443D70 for ; Sat, 1 Jul 2006 11:59:10 +0000 (GMT) (envelope-from i.am.aleks@gmail.com) Received: by nf-out-0910.google.com with SMTP id c29so463490nfb for ; Sat, 01 Jul 2006 04:59:09 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=eSciT5aAULyZytF6T4ZwX9hZyHHxa6QF6Ed4LuzgytAvNGdogho/LT4Mr/y1Ohpyjb2wASLZThC3f+BUnc9nlCarnxbV0bOXcuL1qUDspcGdasWtpYbe0l/APFm9tckj5lw0Wtf+7MGDHo2uGYUjvj8batmeg1lp9V1bMIqCG60= Received: by 10.49.65.8 with SMTP id s8mr954101nfk; Sat, 01 Jul 2006 04:59:09 -0700 (PDT) Received: by 10.48.223.10 with HTTP; Sat, 1 Jul 2006 04:59:09 -0700 (PDT) Message-ID: <94678bd60607010459s2c1b448co463ff5251bb4e1b8@mail.gmail.com> Date: Sat, 1 Jul 2006 14:59:09 +0300 From: Aleks To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 01 Jul 2006 11:59:17 -0000 Hi again. Last night I made some progress finding what I've missed. The usual suspect - file permissions on employee.fdb. I changed the owner to firebird:firebird (fb_inet_server runs as firebird, I think) and chmod 644. So far so good. The next thing is echo "localhost.domain.tld" >> /etc/hosts.equiv. In the docs it is simply localhost, but it appears that a fully qualified domain name is needed. From that were the nice words in firebird.log, I think. The current problem that I seem to have is that I can connect to the employee.fdb via localhost: but wihtout using username and password. # isql SQL> connect 'localhost:/usr/local/share/examples/firebird/employee.fdb' user 'SYSDBA' password 'masterkey'; Statement failed, SQLCODE = -902 cannot attach to password database SQL> connect 'localhost:/usr/local/share/examples/firebird/employee.fdb'; Database: 'localhost:/usr/local/share/examples/firebird/employee.fdb' I admit I'm not familiar with the security model of firebird, etc. etc. so I'm going to read about it and find what's the actual problem. Maybe file permissions on security.fdb? It's owned by root and the permissions are somewhat restrictive 640. I can't create 'localhost:/var/db/firebird/test.fdb'; and I think it's because of the file permissions again, right? It's the default setup and /var/db/firebird is owned by root (755). So, back to the manuals and heavy reading/trying :) Thanks! Aleks