| Subject | RE: [ib-support] Re: version 1.0.2 destroys isc4.gdb |
|---|---|
| Author | Bert Hughes |
| Post date | 2002-12-27T15:58:46Z |
Aage-
Something like that almost worked. I was able to restore to a new file,
like you said, as long as the working directory was not interbase (fb) home.
The users are there - but nothing can change - both IBConsole and Interbase
Workbench are unable to read the file. I've run through backup and restore
a few times now. Basically, whether you should use the -user -password
params appears to be random. Sometimes that works, sometimes you have to
leave it off. No doubt this is completely unreplicatable - before I even
began working on the production machine, I had tried the upgrade on a
simulation machine. Similar problems getting isc4.gdb back, but after
trying about eight or nine different things, including monkeying with
password in /etc/init.d/firebird, it came back, and no problems reading &
setting users with IBConsole & Workbench.
This is very, very bad. I would strongly recommend that no one upgrade
until this problem is fixed.
-----Original Message-----
From: Aage Johansen [mailto:aagjohan@...]
Sent: Thursday, December 26, 2002 5:49 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: version 1.0.2 destroys isc4.gdb
Bert Hughes wrote:
your _backup_ of isc4.gdb to e.g. isc4-X.gdb
2. Rename the newly installed isc4.gdb to isc4-Y.gdb.
3. Rename the newly restored isc4-X.gdb to isc4.gdb.
If necessary, move it to the correct directory.
You should now be able to use all the old usernames/passwords.
--
Aage J.
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Something like that almost worked. I was able to restore to a new file,
like you said, as long as the working directory was not interbase (fb) home.
The users are there - but nothing can change - both IBConsole and Interbase
Workbench are unable to read the file. I've run through backup and restore
a few times now. Basically, whether you should use the -user -password
params appears to be random. Sometimes that works, sometimes you have to
leave it off. No doubt this is completely unreplicatable - before I even
began working on the production machine, I had tried the upgrade on a
simulation machine. Similar problems getting isc4.gdb back, but after
trying about eight or nine different things, including monkeying with
password in /etc/init.d/firebird, it came back, and no problems reading &
setting users with IBConsole & Workbench.
This is very, very bad. I would strongly recommend that no one upgrade
until this problem is fixed.
-----Original Message-----
From: Aage Johansen [mailto:aagjohan@...]
Sent: Thursday, December 26, 2002 5:49 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: version 1.0.2 destroys isc4.gdb
Bert Hughes wrote:
> I haven't been able to recover the user database (isc4.gdb) sinceupgrading
> to fb 1.0.2. The copy the rpm saves in /tmp is useless. I thought I wasrestore
> being clever by gbak-ing isc4.gdb before upgrading, but it doesn't
> because you can't connect to the password database! Is the intent of1.0.2
> to allow only SYSDBA/masterkey, always and forever? I can't do it thehard
> way by recreating users through IBWorkbench or IBConsole either.1. Try to use gbak with SYSDBA/masterkey to restore
> (Unrecognized parameter block; unable to retreive user list).
your _backup_ of isc4.gdb to e.g. isc4-X.gdb
2. Rename the newly installed isc4.gdb to isc4-Y.gdb.
3. Rename the newly restored isc4-X.gdb to isc4.gdb.
If necessary, move it to the correct directory.
You should now be able to use all the old usernames/passwords.
--
Aage J.
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/