Subject Re: [firebird-support] Synchronize security2.fdb
Author Radu Sky
Alan McDonald wrote:
>> We have one central db in our headquarter and several dbs on the laptops
>> of our sales representatives. To synchronize the databases we use
>> IBReplicator. Now I have a new request to synchronize the security
>> databases as well. No problem I thought, just add the security databases
>> to IBReplicator. We use FB 1.5 at the moment. Then I have read the
>> release notes of FB 2.0 and realized, that this won't work with FB 2.0,
>> because no remote database connection are allowed to security2.fdb.
>> Exist some solutions for synchronizing the security2.fdb between
>> different computers?
>> Regards
>> Guido
> I've been working on a tool for this. But I'm afraid that it's not real
> replication. You administer multiple security databases at the same time.
> You can synchronise also but passwords are not included in this process
> (only user names and details and it uses thte MIDDLENAME field as EMAIL
> instead - for alerts). You will never be able to replicate existing
> passwords. AFAIK
> Alan

One idea I had a while ago to bypass the service manager.
Create an extra table to temporary store the user/password until
replication, of course decent encrypted. After table replication, the
password is changed by decrypting the field (via post event or kinda)
and the data is cleaned on both servers.