Date: Sat, 1 Jul 2006 14:59:09 +0300 From: Aleks <i.am.aleks@gmail.com> To: freebsd-database@freebsd.org Subject: Re: FreeBSD 6.1 & Firebird Message-ID: <94678bd60607010459s2c1b448co463ff5251bb4e1b8@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?94678bd60607010459s2c1b448co463ff5251bb4e1b8>