On Tue, 2018-12-18 at 17:20 +0100, liviuslivius liviuslivius@... [firebird-support] wrote:

 

If you try something new better use newest snapshot. There are some fixes

OK, I've built and "make installed" the latest 3.0.5 snapshot. This is a fresh install. I'm seeing the same problem:

[root@bryan bin]# ./fbguard -daemon -forever

[root@bryan bin]# ps -A | grep fbguard

 5447 ?        00:00:00 fbguard

[root@bryan bin]# ps -A | grep firebird

 5448 ?        00:00:00 firebird

[root@bryan bin]# ./isql -user sysdba -pass mydbapassword localhost:employee

Database: localhost:employee, User: SYSDBA

SQL> create user test password 'test' grant admin role;

SQL> commit;

SQL> grant RDB$ADMIN TO USER test;

SQL> commit;

SQL> exit;

[root@bryan bin]# ./isql -user test -pass test -role RDB$ADMIN localhost:employee

Database: localhost:employee, User: TEST

SQL> create user foo password 'foo';

Statement failed, SQLSTATE = 28000

add record error

-no permission for INSERT access to TABLE PLG$SRP_VIEW

SQL> SELECT rdb$get_context('SYSTEM', 'ENGINE_VERSION')

CON> from rdb$database;

RDB$GET_CONTEXT                                                                                                                                                                                                                                                 

=============================================================================== 

3.0.5                                                                                                                                                                                                                                                           

SQL> 

I set my sysdba password during the install routine and ran the server manually from the install location /usr/local/firebird/bin

I turned off SELinux (just in case...).

Bryan

Regards,

Karol Bieniaszewski

-- 

Group Leader, Technical Development Group - Teraview Ltd.
Platinum Building, St. John's Innovation Park, Cambridge CB4 0DS, UK.
tel: +44 (0)1223 435386, fax: +44 (0)1223 435382, web: www.teraview.com Registered Number: 04126946, VAT Number: 770 8883 84

...preferred document formats: ODF (ISO/IEC 26300:2006), PDF