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.5always 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 <
[hidden email]>
Date: Mon, Nov 22, 2010 at 12:04 PM
Subject: Re: Have you tried firebird 2.5 SuperClassic from the packages?
To: seasoned_geek <
[hidden email]>
On Mon, Nov 22, 2010 at 9:36 AM, marius adrian popa <
[hidden email]> wrote:
> On Mon, Nov 22, 2010 at 12:33 AM, seasoned_geek
> <
[hidden email]> 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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev_______________________________________________
Firebird-docs mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-docs
Locked
