Re: IB2007 gbak bugs?

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?

-- 

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.

-- 

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 

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>” 

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