Upfront Backup and Recovery without entering username and password 1

[md21]

Hi,

Currently, I am in a process of creating a BRP box for Cognos Series 7 version 2. Does any body know how to run this backup and recovery script without entering username and password? Hear I am trying to avoid hardcoding password.

Thanks

 

[GJParker]

If you are using the upfpack.exe then username and password are required



Gary Parker
MIS Data Analyst
Manchester, England

 

[md21]

Gary,

Is there any other way to get around this issue? Like using something else for backup and recovery?

Thanks

 

[GJParker]

Not as far as I know.

Gary Parker
MIS Data Analyst
Manchester, England

 

[christenhusz]

to execute this command succesfully you need root userclass permissions. The password is to prevent unauthorized users to backup the upfront datastore

christenhusz

 

[md21]

I was wondering if somehow I can use os singon so that I do not have to hardcode password.

Thanks

 

[christenhusz]

os signon is a cgi variable (web) and use together with a webserver ie. IIS or apache. upfpack is a DOS command and does not do anything with the webserver.

you can create a macro which execute this command (with the required username and password and compile this file to MCX. MCX is binary and therefore you cannot read the username/password. or store the script on a disk location where only administrators have access to.

christenhusz

 

[drlex]

you can create a macro which execute this command (with the required username and password and compile this file to MCX

Can you give an example of this? I am currently running a nightly upfpack command in a 4 line batch file run in Windows Scheduled tasks.
The only way I have been running similar DOS commands from a CognosScript macro (MAC/MCX) is by using the SHELL command to a batch file


soi la, soi carré

 

[christenhusz]

i also use shell command in my macro's.

Shell(strUpfpack & " -i " & strAdminUserID & " -j " & strAdminUserPWD )

this should work.
in batch files i normally use this:

rem ++++++ Upfront DB Amin: for Series 7 Only +++++
net stop "Cognos Upfront Dispatcher (cer3)"
"%cogCerBin%\upfdbadm" -b "%cogNightlyBak%\%cogServerName%_Upfront.bak"
net start "Cognos Upfront Dispatcher (cer3)"


christenhusz

 

[drlex]

Ah, just to complete your example, can you give the format of the contents of the variable strUpfpack?
Is something like "C:\Progra~1\Cognos\cer4\Upfpack.exe "?
thanks,
lex

soi la, soi carré

 

[christenhusz]

correct,

set strUpfpack as String

Upfpack = "C:\Progra~1\Cognos\cer4\Upfpack.exe "

christenhusz

 

[drlex]

vele dank, christenhusz; heb een ster.

soi la, soi carré

 

[griffindm]

MCX is binary and therefore you cannot read the username/password. or store the script on a disk location where only administrators have access to.

Have you ever looked at a MCX file using a text editor? The majority of it is quite legible in plain text.

I suggested a simple alogorithm to encrypt/decrypt the password, or failing that, put it in a restricted directory as you suggest.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
Magic with Data
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com