Subject Re: GSEC fails
Author johnnorthrup34
--- In firebird-support@yahoogroups.com, Aage Johansen <aagjohan@o...>
wrote:
> johnnorthrup34 wrote:
> >
> > --- In firebird-support@yahoogroups.com, Aage Johansen
<aagjohan@o...>
> >
> >>johnnorthrup34 wrote:
> >> >
> >> > I just upgraded a server from an early version of Firebird to
v1.5.1
> >> > for Windows. When I run GSEC to modify passwords it fails with a
> >> > message, your user name and password are not defined ... unable to
> >> > open database. The user name and password are defined. What
could
> >> > the problem be?
> >>
> >>Are you mixing new and old programs? Or, mixing old (isc4.gdb)
and new
> >>(security.fdb) databases?
> >>Did you convert the 'security' database? (Backup isc4.gdb,
restore as
> >>security.fdb). If SYSDBA/masterkey works it indicates that you
haven't
> >>converted.
> >
> >
> > Doesn't the Windows install do the conversion for me?
>
>
> Haven't checked. I did it "by hand".
> If it complains about username/password, try with SYSDBA/masterkey
(see above).
>
>
> --
> Aage J.

The login works fine, it's only when I run modify and this fails even
when it's with SYSDBA /masterkey. How do you upgrade the database "by
hand"?