Re: IB2007 gbak bugs?

[SimonW]

Michael Danninger wrote:
> 1) Using IB2007 developer edition (Servicepack2) on Windows 2003 Server.
>
> When i try to recover a database using the following command:
> gbak -archive_recover c:\...archived.database
> c:\....recovered_database.ib -user sysdba password -MyPassword
> i get an error "Your user name and password are not defined..."
>
> When i execute exactly the same command without the username and
> password parameters, but having set user and password with variables
> like this:
>
> isc_user=sysdba
> isc_password=MyPassword
> gbak -archive_recover c:\...archived.database c:\....recovered_database.ib
>
> everything works fine. Do i have to use parameters in another order, or
> is it a bug in gbak?
>

I assume that the following bit in your OP was a typo:-

password -MyPassword

as it should be:-

-password MyPassword.

Also, to get this to run I had to enclose the paths to the archived and
recovered databases within double quotes.

[Michael Danninger]

1) Using IB2007 developer edition (Servicepack2) on Windows 2003 Server.

When i try to recover a database using the following command:
gbak -archive_recover c:\...archived.database
c:\....recovered_database.ib -user sysdba password -MyPassword
i get an error "Your user name and password are not defined..."

When i execute exactly the same command without the username and password
parameters, but having set user and password with variables like this:

isc_user=sysdba
isc_password=MyPassword
gbak -archive_recover c:\...archived.database c:\....recovered_database.ib

everything works fine. Do i have to use parameters in another order, or is
it a bug in gbak?

2) Using:
server1 with Vista Business Edition and IB2007 developer edition
(Servicepack2) / server2 with Windows 2003 Server, IB2007 developer edition
and IB2007 developer edition (Servicepack2), and a network share named
archive with read / write rights for everyone.

After changing the user account the ibserver - service uses from local
system to a domain-user, i am able to archive a database running on server1
(and its journals) with no problems to the networkshare \\server2\archive.
When i try to recover the archive from the share to server1 i get "gbak:
ERROR: Unable to complete network request to host "server1". Failed to
establish a connection. unknown Win32 error 2". When i recover from the same
archive to server2 (using IB running on server2) everything works fine. I am
wondering, why IB is able to archive to the share, but not able to recover
from it?

I know i posted point 2 before, but i hope i could make things a little
clearer now,
regards in advance,
Michael

[SimonW]

Michael Danninger wrote:
> 1) Using IB2007 developer edition (Servicepack2) on Windows 2003 Server.
>
> When i try to recover a database using the following command:
> gbak -archive_recover c:\...archived.database
> c:\....recovered_database.ib -user sysdba password -MyPassword
> i get an error "Your user name and password are not defined..."
>
> When i execute exactly the same command without the username and
> password parameters, but having set user and password with variables
> like this:
>
> isc_user=sysdba
> isc_password=MyPassword
> gbak -archive_recover c:\...archived.database c:\....recovered_database.ib
>
> everything works fine. Do i have to use parameters in another order, or
> is it a bug in gbak?
>

The following works for me:-

GBAK –archive_recover –user SYSDBA –pas masterkey
“\\sjhfs01\estates\journal archive\<Latest Database Archive File>”
“e:\estates\database\estates.gdb”

[Michael Danninger]

Thanks for your answer.

the password -MyPassword was a typo in the post, i used -password MyPassword
when i tried to recover.

> GBAK –archive_recover –user SYSDBA –pas masterkey
> “\\sjhfs01\estates\journal archive\<Latest Database Archive File>”
> “e:\estates\database\estates.gdb”

Whatever i try, double quotes, single, none, archive_recover does not work
for me. It always brings up the "Your user name and password are not
defined..." error.

When i declare the isc_user and isc_password variables everything works fine
(so i am shure i use the correct gbak syntax for recovering the database).
Gbak behaves the same way on vista and 2003 server. Are you using IB
servicepack2?

[SimonW]

Michael Danninger wrote:
>
> When i declare the isc_user and isc_password variables everything works
> fine (so i am shure i use the correct gbak syntax for recovering the
> database). Gbak behaves the same way on vista and 2003 server. Are you
> using IB servicepack2?

Version of GBAK.EXE I have is 8.1.0.257 and I am running on Win2003 (all
SPs). Sorry I can't help any more, I am sure that there are others here
who will be able to help.

[Bill Todd [TeamB]]

Michael Danninger wrote:

> Whatever i try, double quotes, single, none, archive_recover does not
> work for me. It always brings up the "Your user name and password
> are not defined..." error.

It fails even when you change the order of the parameters as in Simon's
example?

--
Bill Todd (TeamB)

[Michael Danninger]

> It fails even when you change the order of the parameters as in Simon's
> example?
>
> --
> Bill Todd (TeamB)

The following is copy and paste from my commandline (password is changed to
default)
---------------------------------------------------------------------------------------------------------------
C:\Dokumente und Einstellungen\Administrator>gbak -archive_recover -user
sysdba
-pas masterkey "c:\LAB.ASS\ARCHIVE\JOURNAL.2008-03-05T10-46-34Z.1.DATABASE"
"c:\lab.ass\
db\rc.ib"
gbak: ERROR: Your user name and password are not defined. Ask your database
admi
nistrator to set up an InterBase login.
gbak: Exiting before completion due to errors

C:\Dokumente und Einstellungen\Administrator>set isc_user=sysdba

C:\Dokumente und Einstellungen\Administrator>set isc_password=masterkey

C:\Dokumente und Einstellungen\Administrator>gbak -archive_recover
"c:\LAB.ASS\A
RCHIVE\JOURNAL.2008-03-05T10-46-34Z.1.DATABASE" "c:\lab.ass\db\rc.ib"
gbak: WARNING: Recovered 0 pages of a total 197 database pages

C:\Dokumente und Einstellungen\Administrator>
----------------------------------------------------------------------------------------------------------------
First i tried to recover with the parameters in the same order as in Simon's
example. Recovering did not work. Then i set the isc variables, and it
worked.

Michael

[SimonW]

Michael Danninger wrote:
>
> C:\Dokumente und Einstellungen\Administrator>gbak -archive_recover -user
> sysdba
> -pas masterkey
> "c:\LAB.ASS\ARCHIVE\JOURNAL.2008-03-05T10-46-34Z.1.DATABASE" "c:\lab.ass\
> db\rc.ib"
> gbak: ERROR: Your user name and password are not defined. Ask your
> database admi
> nistrator to set up an InterBase login.
> gbak: Exiting before completion due to errors
>

What happens if you run the GBAK command from the directory where GBAK
resides - e.g. c:\program files\borland\interbase\bin ?

[Michael Danninger]

> What happens if you run the GBAK command from the directory where GBAK
> resides - e.g. c:\program files\borland\interbase\bin ?

I tried it:

C:\Programme\Borland\InterBase\bin>gbak -archive_recover -user
sysdba -password

masterkey "c:\LAB.ASS\ARCHIVE\JOURNAL.2008-03-05T10-46-34Z.1.DATABASE"
"c:\lab.ass\db\rc
.ib"
gbak: ERROR: Your user name and password are not defined. Ask your database
admi
nistrator to set up an InterBase login.
gbak: Exiting before completion due to errors

but it brought up the same error.

thanks, Michael

[Bill Todd [TeamB]]

A long shot but, scan your hard drive for gds32.dll. Make sure you only
have one and that the version number of gds32.dll matches the version
number of ibserver.exe exactly.

--
Bill Todd (TeamB)

[Michael Danninger]

>A long shot but, scan your hard drive for gds32.dll. Make sure you only
> have one and that the version number of gds32.dll matches the version
> number of ibserver.exe exactly.
>

I searched for iberserver.exe and gds32.dll. I found both once, and both had
the version number 8.1.0.257.

[Michael Danninger]

I tried to -archive_restore a database from an archive with one database and
two journal files archived. Using the -user and -pas parameters gbak
finished after 40 minutes with the error i described before. Gbak recovered
the whole database (~20GB) and as i could see in the interbase.log applied
one of the two journal files. It did not apply the second one, but instead
stopped with the "Your user name and password are not defined...". When i
set the isc_user and isc_password variables before -archive_restore also the
second journal file is applied. Since gbak recovered the database and
applied the first journal file using the -user and -pas parameters i am
quite sure the syntax i used is correct, and this behavior is a gbak bug.
(It seems to me gbak tries to connect a second time to the database, but
does not use the information given in the parameters. This could be the
reason why everything works fine with the isc_... parameters set).

Is there nobody else, who experienced the same behaviour?

Regards, Michael