2020年8月27日(木) 23:28 Ian Lawrence Barwick <[email protected]>:
>
> 2020年8月25日(火) 18:02 Alex Peshkoff via Firebird-devel
> <[email protected]>:
> >
> > On 2020-08-25 05:07, Ian Lawrence Barwick wrote:
> (...)
> > > ./configure --prefix=/opt/firebird4 \
> > > --with-editline \
> >
> > Almost for sure --with-system-editline will be better - builtin editline
> > is used in distributed binaries just to satisfy license.
>
> Thanks, noted.
>
> (...)
>
> > > Thanks for any pointers
> >
> > You may use no-install approach - run where it was built.
>
> Aha, that would be fine.
>
> > Just add
> > SYSDBA user to security database in build dir (gen/Release/firebird)
> >
> > # cd gen/Release/firebird/bin
> > # ./isql employee
> > SQL> create user sysdba password 'masterkey';
>
> That unfortunately doesn't work:
>
> $ ./isql employee
> Statement failed, SQLSTATE = 08006
> Unable to complete network request to host "localhost".
> -Failed to establish a connection.
> Use CONNECT or CREATE DATABASE to specify a database
> SQL>
>
> I tried this:
>
> $ FIREBIRD=/path/to/firebird/src/gen/Release/firebird/ ./bin/isql employee
> Statement failed, SQLSTATE = HY000
> operating system directive access failed
> -Not a directory
> Use CONNECT or CREATE DATABASE to specify a database
>
> (which seems necessary for the .msg file and presumably configuration files)
> and several variations, all with the same error message.
>
> I also tried hard-coding the employee and security database paths in
> the .conf files
> in the $FIREBIRD directory, no change.
>
> All files in the $FIREBIRD directory path are owned by the same (non-root)
> user.
OK, I can get it to work by using sudo; is it possible it's expecting
to run as a
different user (e.g. "firebird") rather than the user I compiled this with?
Anyway a start:
SQL> SELECT CAST(rdb$get_context('SYSTEM', 'ENGINE_VERSION') AS
VARCHAR(10)) FROM rdb$database;
CAST
==========
4.0.0
Thanks
Ian Barwick
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
