Subject | Re: [firebird-support] Backup and restore of users |
---|---|
Author | Aldo Caruso |
Post date | 2012-03-08T13:51:57Z |
Thanks all of you for your help.
Aldo Caruso
El 08/03/12 07:04, Tomasz Tyrakowski escribió:
Aldo Caruso
El 08/03/12 07:04, Tomasz Tyrakowski escribió:
>[Non-text portions of this message have been removed]
> I had run it just before posting, on one of our servers. Debian 6, FB
> 2.5.0 CS. Worked all right.
> You're right about Windows. Just checked it and got "no permission for
> direct access to security database". I haven't thought about testing it
> on Windows - sorry Aldo, my solution only half-works.
>
> regards
> Tomasz
>
> On 2012-03-08 10:54, Thomas Steinmaurer wrote:
> > Hello Tomasz,
> >
> >> gbak -B /opt/firebird/security2.fdb ./security2.fbk
> >>
> >> works as well. Restoring requires two steps: restore to an alternate
> >> location (gbak -C security2.fbk somefolder/security2.fdb), then
> stop the
> >> server (SS) or close connections (CS) and copy the restored
> >> security2.fdb to the proper location in FB directory. AFAIR, a similar
> >> procedure is required when upgrading from pre-2.x FB (it's mentioned in
> >> the section "Security in Firebird 2 (All Platforms)" in "Firebird 2
> >> Migration& Installation" here:
> >>
> http://www.firebirdsql.org/file/documentation/release_notes/html/install210.html
> >> but without details).
> >
> > Starting with Firebird 2, the security database can't be accessed by a
> > regular/direct database connection anymore. Accessing is only possible
> > via the Services Manager. Thus, you need to use the -se switch when
> > backing up the security database. At least on Windows. Can't test your
> > above gbak call under Linux right now.
> >
> >
>
> --
> __--==============================--__
> __--== Tomasz Tyrakowski ==--__
> __--== SOL-SYSTEM ==--__
> __--== http://www.sol-system.pl ==--__
> __--==============================--__
>
>