firebird2.5 SuperClassic has permissions problems
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
firebird2.5 (Ubuntu) |
Fix Released
|
Undecided
|
Popa Adrian Marius |
Bug Description
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/
/var/
sudo gunzip /var/lib/
Now if I try the tried and true example:
roland@
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect "/var/lib/
Statement failed, SQLSTATE = HY000
Can't access lock files' directory /tmp/firebird
SQL> exit
CON> ;
but, if I use sudo
roland@
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect "/var/lib/
Database: "/var/lib/
SQL> show tables
CON> ;
COUNTRY CUSTOMER
DEPARTMENT EMPLOYEE
PROJECT PROJ_DEPT_BUDGET
SQL> exit
CON> exit
CON> ;
roland@
Description: Ubuntu 10.10
Release: 10.10
roland@
Exact same problem when trying to create a database
roland@
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database '/home/
Statement failed, SQLSTATE = HY000
Can't access lock files' directory /tmp/firebird
SQL> exit
CON> ;
roland@
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database '/home/
SQL> exit;
roland@
package was installed via synaptic.
Is there a work around?
ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: firebird2.
ProcVersionSign
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
This needs to be added in the Getting started guide on Linux , i will /help.ubuntu. com/community/ Firebird2. 5
add to the ubuntu guide too (in the docbook)
I have added to the wiki https:/
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 /var/lib/ firebird/ 2.5/data/ employee. fdb " user
Then connect to the db in superclassic or classic
$ isql-fb
SQL> connect "localhost:
'SYSDBA' password 'SYSDBApassword';
to explain this minor issue we had this "bug" reported in flamerobin mapopa. blogspot. com/2008/ 10/testing- firebird- 2.html
(second half of the article)
http://