[firebird-support] Synchronisation between two processes

Hi, I have two client processes (on uptodate linux host) accessing a firebird database using the direct-file-access method (libfbembed.so). Most of the time, when a write transaction is committed in one process the data is visible in the second process more-or-less immediately. Sometimes

Re: [firebird-support] Synchronisation between two processes

I'm not Sure what isolation level I'm using. Whatever is default I expect. I'm using an ORM and python interface. I will need to dig into this a little deeper. However, my transaction do not overlap, so I don't expect the isolation level to matter. Regarding using the embedded interface from

[firebird-support] Determine total pre-allocated space

Hi, I need to be able to detect when the total available space for a firebird database is running low. When this happens I need to warn users to purge old data. However, deleting data does not free up disk space. This in itself is fine, but how can I measure the resulting free space in the

[firebird-support] How to estimate free space inside database file

Hi, I am trying to figure out the amount of free space within my database, so that I can detect when I'm nearing exhausting the disk space. I'm using firebird-v2.5.2. I know that (total_pages * page_size) = size on disk. This doesn't tell me how many of those allocated pages are free. If I

RE: [firebird-support] How to estimate free space inside database file

to estimate free space inside database file 25.10.2016 19:03, Bryan Cole bryan.c...@teraview.com [firebird-support] wrote: > > I am trying to figure out the amount of free space within my database, so > that I can > detect when I'm nearing exhausting the disk space. I'm using firebird-v2.5

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Tue, 2018-12-18 at 12:52 +0100, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 2018-12-18 12:12, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 18.12.2018 12:04, 'Bryan Cole' bryan.c...@teraview.com > [firebird-support] wrote: >> [mypc]$ isq

[firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

We've just updated our application to use FB3 (version 3.0.3, on Fedora27). We create a new admin user (not SYSDBA) but no matter what I try, this admin user cannot add/remove other users. I'm creating the admin user as follows: [mypc]$ isql-fb -u SYSDBA -p mydbapassword localhost:mydatabase

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Tue, 2018-12-18 at 12:12 +0100, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 18.12.2018 12:04, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: [mypc]$ isql-fb -u test -p test -r rdb$admin localhost:mydatabase Database:

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Tue, 2018-12-18 at 14:28 +0100, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 18.12.2018 14:25, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: Database: localhost:employee, User: TEST Do you see "Role: RDB$ADMIN" here?

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Tue, 2018-12-18 at 14:56 +0100, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 18.12.2018 14:44, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: I understand I'm doing it wrong. I don't understand what I need to do

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

I'm using the default which I believe is SRP. I tried switching to the legacy one earlier today (using FB v3.0.3) but it did not make any difference. Thanks, Bryan On Tue, 2018-12-18 at 16:36 +0100, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Which plugin do you use,

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Tue, 2018-12-18 at 17:08 +0100, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 18.12.2018 16:55, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: I'm using the default which I believe is SRP. Make sure by select from

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Tue, 2018-12-18 at 17:20 +0100, liviuslivius liviusliv...@poczta.onet.pl [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:

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS) [SOLVED]

On Tue, 2018-12-18 at 20:04 +0100, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 18.12.2018 19:17, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: [root@bryan bin]# ./isql -user test -pass test -role

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Wed, 2018-12-19 at 13:46 +1300, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: Bryan, Maybe something in here will provide that ah-haa moment. ;-) In Fb 3 and Fb 4-alpha, you must have *both* and perform your login with the role. In Fb 4 beta 1, a user with the GRANT ADMIN