[Firebird-docs] Fwd: Have you tried firebird 2.5 SuperClassic from the packages?

[marius a. p. <ma...@gm...>]

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

---------- Forwarded message ----------
From: marius adrian popa <ma...@gm...>
Date: Mon, Nov 22, 2010 at 12:04 PM
Subject: Re: Have you tried firebird 2.5 SuperClassic from the packages?
To: seasoned_geek <ro...@lo...>


On Mon, Nov 22, 2010 at 9:36 AM, marius adrian popa <ma...@gm...> wrote:
> On Mon, Nov 22, 2010 at 12:33 AM, seasoned_geek
> <ro...@lo...> wrote:
>> Hello,
>>
>> I'm on KUbuntu 10.10 64-bit AMD version.  Installed SuperClassic via
>> Synaptic from whatever Ubuntu had for its packages now.
>>
>> 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?
> Aways use the localhost when connect with the classic , superclassic
> if you use the isql-fb (see why at the end)
>
> http://mapopa.blogspot.com/2008/10/testing-firebird-2.html
>
> I will add to the notes

tested on my machine and i will add the notice : always use localhost:
in front of db path when using classic or superclassic in 2.5

isql-fb
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect "localhost:/var/lib/firebird/2.5/data/employee.fdb " user
'SYSDBA' password 'mastekey';
Database:  "localhost:/var/lib/firebird/2.5/data/employee.fdb ", User: SYSDBA
SQL>

ps: i didn't added myself to firebird group maybe that could be an
option for some permissions issues