Haha, no problem, glad I could help :)
I have noticed a couple of gotchas to watch out for with this feature though…
You can have different groups/users mapped to different roles, but if a user
matches multiple mappings the connection will fail:
PS C:\Users\PGMRSD1> c:\apps\firebird\isql.exe
Hi – I have another question re user mapping…
If I create a new database with a user->role mapping, I can back up and restore
it and the mapping is still present.
But if I back up the new copy and restore that, the mapping is gone… is there
an issue with the procedure I'm using or is this a
Aha, you've got a typo!
In your create mapping statement (and verified by the output of show mapping),
you have "WINSSPI" instead of "WIN_SSPI".
I encountered the same issue when I accidentally typed "WIN_SPPI".
It seems that the plugin name is not validated against those currently
available
Hi Mathias
I did not have to recreate my database with FB 3.0.5. The before/after example
was around upgrading the server only, with no database changes.
(my database was created in FB 3.0.4 / ODS 12 with schema/data migrated across
from an ancient InterBase 7.5.1 db, and is still on sql
Hi again Mathias – just confirming that upgrading from 3.0.4 to 3.0..5 resolved
this issue for me.
Before (Firebird 3.0.4):
PS C:\Users\PGMRSD1> c:\apps\firebird\isql.exe localhost/3051:foo
Database: localhost/3051:foo, User: FOODSTUFF\PGMRSD1
SQL> select current_user, current_role from
Hi Mathias – I've found a relevant issue… it contains all the keywords you'd
think to search for but eventually I found it in the changelog by searching the
source for "mapping":
http://tracker.firebirdsql.org/browse/CORE-5639
It is marked as resolved in 3.0.5, I'm hoping to test this out today
Hi – I've got the same question as Mathias.
I'm also using Firebird 3 (3.0.4), with a new test database containing its own
security database.
The setup is similar:
create global mapping trusted_auth using plugin win_sspi from any user to user;
create role foo;
Mapping a single user to the role
Hi Kevin – I’ve had good results using fbclone to migrate from InterBase 7.5.1
to Firebird 3 using this method. Migrating from 1.5 might not be too
dissimilar.
https://github.com/zedalaye/fbclone
I made a couple of changes to support dialect 1 (we’re going to switch to
dialect 3 and remove
Hi - I noticed behaviour that I found a little curious while playing around
with named pipe connections using Firebird 3.0.3.
If you set RemoteServicePort to a non-default value, eg 3051, then the default
service name is still used for named pipe connections, eg localhost@gds_db.
You can also
-12-2017 03:06, FSPAPA INCA Team i...@foodstuffs-si.co.nz
> [firebird-support] wrote:
>> I reckon this change to src/remote/server/server.cpp in commit
>> 2fdb281759299f24d47349246f3c800ec78971cc introduced an unintended effect:
>
> I think you're right. I'll create a ticket in the
7.5.1 clients
On 19-12-2017 21:06, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 19.12.2017 4:32, FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support]
> wrote:
>> Wireshark traces show that the server is sending all the data from the
>> query, but
December 2017 10:40 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird 3.0.3 no longer compatible with
InterBase 7.5.1 clients
On 19-12-2017 21:06, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 19.12.2017 4:32, FSPAPA INCA Team i...@foodstu
@yahoogroups.com
[mailto:firebird-supp...@yahoogroups..com]
Sent: Wednesday, 20 December 2017 9:07 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird 3.0.3 no longer compatible with
InterBase 7.5.1 clients
19.12.2017 4:32, FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird
Hi,
I've been testing a set of apps that use the InterBase 7.5.1 client library
against Firebird 3.0.2 and have found them to be sufficiently compatible (with
minimal changes). However after updating a server to Firebird 3.0.3, InterBase
7.5.1 clients (including isql) hang when executing a
14 matches
Mail list logo
