Board index » delphi » Re: EUA restrictions with admin.ib

Re: EUA restrictions with admin.ib


2006-07-21 11:51:55 PM
delphi172
Craig Stuntz [TeamB] writes:
Quote
Adalberto Baldini writes:


>>IIRC, you need an EUA account to backup and a server account to
>>restore. Which makes sense when you think about it.
>>
>
>Wrong. you need the same EUA=server account to restore, and even in
>this case you can get problems. Please see my posts in b.p.i.g
>newsgroup "unavailabe DB after restoring"


We're talking about different things. I was contesting the idea that
you need a server account to backup. I don't believe that is true.

Well Craig, I checked this in IBConsole, where I connect local server as
SYSDBA, after that :
I connected DB as owner , OK
I checked server users and that owner is not registered
I backup and LOgin Prompt appear, I fill with Owner information and I
get error :
"Error logging into the requested server,
Your username and password are not defined ...."
I retried and logged with SYSDBA. Database backup window appears and I
filled all information. Pressed OK button.
I get Error :
" Error 335544472
Your username and password are not defined ...."
How have I to consider this ?
Adalberto
 
 

Re: EUA restrictions with admin.ib

Adalberto Baldini writes:
Quote
How have I to consider this ?
Try with gbak. Some versions of IBConsole have issues with EUA.
--
Craig Stuntz [TeamB] ?Vertex Systems Corp. ?Columbus, OH
Delphi/InterBase Weblog : blogs.teamb.com/craigstuntz
All the great TeamB service you've come to expect plus (New!)
Irish Tin Whistle tips: learningtowhistle.blogspot.com
 

Re: EUA restrictions with admin.ib

Craig Stuntz [TeamB] writes:
Quote
Adalberto Baldini writes:


>How have I to consider this ?


Try with gbak. Some versions of IBConsole have issues with EUA.

I dropped user account into the server and I gbak. I got error message :
Your username and password are not defined. Ask your database
administrator to set up an Interbase login.
 

Re: EUA restrictions with admin.ib

Adalberto Baldini writes:
Quote
Craig Stuntz [TeamB] writes:

>Adalberto Baldini writes:
>
>
>>How have I to consider this ?
>
>
>
>Try with gbak. Some versions of IBConsole have issues with EUA.

I dropped user account into the server and I gbak. I got error message :
Your username and password are not defined. Ask your database
administrator to set up an Interbase login.
PS. supplying user and password gbak works.
gbak -b -v -user xxx -password yyyy db target
in following form it doesn't work
gbak -b -v db target
Adalberto
 

Re: EUA restrictions with admin.ib

Adalberto Baldini writes:
Quote
in following form it doesn't work
gbak -b -v db target
Are you sure that you have the isc_user and isc_password environment
variables set to the correct value?
--
Bill Todd (TeamB)
 

Re: EUA restrictions with admin.ib

Bill Todd writes:
Quote
Adalberto Baldini writes:


>in following form it doesn't work
>gbak -b -v db target


Are you sure that you have the isc_user and isc_password environment
variables set to the correct value?

Never set these variables. They don't exists in my system variables.
Probably I misunderstood OpGuide gbak description.
Resuming all these posts about EUA :
I need an EUA account to backup
I need a server account to create and restore.
Thanks.
Adalberto
 

Re: EUA restrictions with admin.ib

adalberto baldini writes:
Quote
>>in following form it doesn't work
>>gbak -b -v db target
If you do not have the environment variables set and you do not supply
the username and password as part of the command then it should not
work.
--
Bill Todd (TeamB)
 

Re: EUA restrictions with admin.ib

adalberto baldini writes:
Quote
Resuming all these posts about EUA :

I need an EUA account to backup
I need a server account to create and restore.
Yes, this sounds right to me. You can also backup with a server SYSDBA
account *unless* there is also an EUA SYSDBA account with a different
password.
--
Craig Stuntz [TeamB] ?Vertex Systems Corp. ?Columbus, OH
Delphi/InterBase Weblog : blogs.teamb.com/craigstuntz
Everything You Need to Know About InterBase Character Sets:
blogs.teamb.com/craigstuntz/articles/403.aspx
 

Re: EUA restrictions with admin.ib

adalberto baldini writes:
Quote
Create a Database with EUA requires that User and Password must be
defined in standard Interbase management (admin.ib). As EUA goal is
to embedd security into DB, I think that this restriction is
conflicting with the scope.

Regards
Adalberto Baldini
Interesting discussion.
Although it is in the wrong NG I want to let you all know what I think
about it.
If someone use IBConsole to backup he always need a server account to
connect to the server. This is because the API requires a logon to the
server before you can use the API-services. Still you can only do the
actual backup with an EUA-account. The suggestion of Craig Stunt that
you can use SYSDBA if there is not an EUA-account with that name is not
correct AFAIK.
There is not an official release of IBConsole that supports Backup and
Restore an EUA enabled database. Only my beta release 7.5.1.15
(available from www.gvsnet.nl/ibconsole) handle this correct.
When you use gbak you need to set the INTERBASE variable ONLY when you
have more then one instance of IB running on the machine. To backup or
restore the EUA enabled database you need to specify the EUA
credentials.
Cheers,
Gelein van de Voorde.
--
 

Re: EUA restrictions with admin.ib

Gelein van de Voorde writes:
Quote
If someone use IBConsole to backup he always need a server account to
connect to the server. This is because the API requires a logon to the
server before you can use the API-services. Still you can only do the
actual backup with an EUA-account. The suggestion of Craig Stunt that
you can use SYSDBA if there is not an EUA-account with that name is
not correct AFAIK.
My comments were about IB's requirements (i.e., through gbak), not
IBConsole's requirements.
--
Craig Stuntz [TeamB] ?Vertex Systems Corp. ?Columbus, OH
Delphi/InterBase Weblog : blogs.teamb.com/craigstuntz
Everything You Need to Know About InterBase Character Sets:
blogs.teamb.com/craigstuntz/articles/403.aspx