|Subject||Re: User name and password not defined|
This is very, very helpful. Thank you very much!
--- In firstname.lastname@example.org, Helen Borrie <helebor@...> wrote:
> At 06:38 a.m. 12/04/2013, you wrote:
> >99% sure, but I am going to make another copy from the server. I can see the name and password there. Thanks for the response.
> The user name and password are defined at *server* level. In a new server installation, they will be SYSDBA (user) with masterkey (password). If you are running the same Firebird version on both the old and new servers then you can copy security2.fdb from the old one; otherwise, if you know the user names and passwords and there are not many of them, the quickest thing would be to use gsec to add (or change) them in security2.fdb on the new server.
> BTW, you *can* check the on-disk structure (ODS) of the database using gstat -h. You don't need user authentication for that. If the database was created or restored under Fb 2.1, the ODS will be 11.1.
> Helen Borrie, Support Consultant, IBPhoenix (Pacific)
> Author of "The Firebird Book" and "The Firebird Book Second Edition"