Category: Technical Articles

[See remaining text…] 

Some comments:

(1)
The product name is Firebird, not FirebirdSQL. I’ve changed that
throughout (except in the package label, of course).

(2)
This:

If you get an error message like “Statement failed, SQLCODE = -551
no permission for read-write access to database /usr/share/doc/
firebird2-examples/examples/employee.fdb” then you don’t have read
or write access to the database.

is not entirely correct. Since it concerns a Superserver installation,
the message means that the Firebird server process (running as user
firebird) doesn’t have sufficient rights. The solution is not to give
everybody read-write access to the database, but to check the file
ownership, change it to user firebird if necessary, and make sure he
(she? it?) has sufficient access.

With Classic server in local mode, it’s another story. But we
shouldn’t teach our users to solve access problems by just opening
all the gates to everybody.

I haven’t changed this yet though, because you may be aware of some
peculiarities specific to the Ubuntu installation that I’m not.

Kind regards,
Paul Vinkenoog

« Hide it