On 19-06-2021 20:16, Unlucky 83 wrote:
> Hi
> Thanks for the help so far...sorry for not replying before I've been
> unexpectedly busy with my work, just about to start to look at this again.
> I did use the first link -and reinstalled firebird (again) but from
> every attempt/way of installing firebird 3.0 I've tried so far I don't
> get the database -but I don't get the same folders installed either -so
> I guess it is Linux Mint thing...
> 'However, you can use any database (in fact, you can even connect -
> locally - to the security database itself).'
> Can you tell me how I would do that?
In isql (note: some distributions rename it to fb-isql), use
CONNECT 'security.db' USER sysdba;
This assumes security.db is defined in databases.conf, it should, but
you never know with modified distributions. Alternatively, use:
CONNECT 'security3.fdb' USER sysdba;
Replace security3.fdb with the actual path of the security database.
Or, just create a database and use that:
CREATE DATABASE '/path/to/some/database.fdb' USER sysdba;
For both options, you do need to be a member of the firebird group,
otherwise the embedded engine can't modify the security database.
Mark
--
Mark Rotteveel