firebird2.5 SuperClassic has permissions problems

[Roland Hughes]

Fresh clean install of Firebird 2.5 SuperClassic.
Install the examples package.

Ran following shell to unbundle the examples.

sudo install -o firebird -g firebird -m 0660 \
    /usr/share/doc/firebird2.5-examples/examples/empbuild/employee.fdb.gz \
    /var/lib/firebird/2.5/data/
sudo gunzip /var/lib/firebird/2.5/data/employee.fdb.gz

Now if I try the tried and true example:

roland@roland-Generic-Desktop1:~$ isql-fb
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect "/var/lib/firebird/2.5/data/employee.fdb " user 'SYSDBA' password '*****';
Statement failed, SQLSTATE = HY000
Can't access lock files' directory /tmp/firebird
SQL> exit
CON> ;

but, if I use sudo

roland@roland-Generic-Desktop1:~$ sudo isql-fb
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect "/var/lib/firebird/2.5/data/employee.fdb " user 'SYSDBA' password '*****';
Database: "/var/lib/firebird/2.5/data/employee.fdb ", User: SYSDBA
SQL> show tables
CON> ;
       COUNTRY CUSTOMER
       DEPARTMENT EMPLOYEE
       EMPLOYEE_PROJECT JOB
       PROJECT PROJ_DEPT_BUDGET
       SALARY_HISTORY SALES

SQL> exit
CON> exit
CON> ;

roland@roland-Generic-Desktop1:~$ lsb_release -rd
Description: Ubuntu 10.10
Release: 10.10
roland@roland-Generic-Desktop1:~$

Exact same problem when trying to create a database

roland@roland-Generic-Desktop1:~$ isql-fb
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database '/home/roland/test.fdb' user 'SYSDBA' password '*****';
Statement failed, SQLSTATE = HY000
Can't access lock files' directory /tmp/firebird
SQL> exit
CON> ;

roland@roland-Generic-Desktop1:~$ sudo isql-fb
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database '/home/roland/test.fdb' user 'SYSDBA' password '*****';
SQL> exit;
roland@roland-Generic-Desktop1:~$

package was installed via synaptic.

Is there a work around?

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: firebird2.5-superclassic 2.5.0.25920~ReleaseCandidate2.ds2-8
ProcVersionSignature: Ubuntu 2.6.35-22.35-generic 2.6.35.4
Uname: Linux 2.6.35-22-generic x86_64
Architecture: amd64
Date: Sun Nov 21 16:06:53 2010
InstallationMedia: Kubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007)
ProcEnviron:
 LANGUAGE=
 PATH=(custom, user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: firebird2.5

[Popa Adrian Marius (mapopa)]

This needs to be added in the Getting started guide on Linux , i will
add to the ubuntu guide too (in the docbook)
I have added to the wiki https://help.ubuntu.com/community/Firebird2.5

always use localhost: in front in front of db path when using classic
or superclassic in 2.5 this way the lock files and the shared memory
segment will be owned by the 'firebird' user. Another alternative is
to add yourself to firebird group

$ sudo adduser `id -un` firebird
Then connect to the db in superclassic or classic
$ isql-fb
SQL> connect "localhost:/var/lib/firebird/2.5/data/employee.fdb " user
'SYSDBA' password 'SYSDBApassword';

to explain this minor issue we had this "bug" reported in flamerobin
(second half of the article)
http://mapopa.blogspot.com/2008/10/testing-firebird-2.html