BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Recover lost database credentials
1 members found this topic helpful
Goto page 1, 2  Next
 
Search this topic... | Search BOB's Downloads... | Search Box
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Author Message
RHuntley
Forum Member
Forum Member



Joined: 12 Aug 2011

Posts: 4



PostPosted: Thu Nov 17, 2011 8:54 am 
Post subject: Recover lost database credentials

Method of extracting lost / forgotton credentials from Designer.

Code:
ExtractConnections.xls (c) J.Huntley 2011

Version History
---------------
V1.0  November 2011

Description
-----------
In an large Business Objects installation, connection credentials can often get lost or forgotton.
Usually, the only way to resolve this is to reset the database password. Unfortunately, this may cause
additional problems, particularly if the account is shared by another application or other BO connections.

As a result, there may be a legitimate need to recover lost credentials.
The encryption scheme used by Business Objects XI appears to be secure. Universe Designer, however, as part of the
process of displaying the connections dialog box queries the CMS for connection objects and creates a class instance
internally to hold all the details should the user wish to view or change them.

It appears from examining the heap of the designer process directly after the connections window is displayed that
each connection instance holds an XML fragment containing all the connection properties including the cleartext password.
I summise that this XML is probably what is used to exchange connection data with the CMS and that instance
variables may be used to interact with the GUI.

As Designer has helpfully filled its heap with easily identifiable cleartext credentials, it is relatively easy to
to extract these details and populate a spreadsheet with the connection properties.

Limitation: Connection name is not available. If you need this, InfoObjects is probably the best source.


Tested on XI3.1 SP3, may well work on other versions.



ExtractConnections.xls
 Description:

Download
 Filename:  ExtractConnections.xls
 Filesize:  97 KB
 Downloaded:  2321 Time(s)

Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19353
Location: Bratislava


flag
PostPosted: Thu Nov 17, 2011 10:42 am 
Post subject: Re: Recover lost database credentials

[Moderator Note: Moved from Semantic Layer / Universe Designer to BOB's Uploads]
Back to top
ajunell
Principal Member
Principal Member



Joined: 03 May 2004

Posts: 230
Location: Amarillo, TX


flag
PostPosted: Fri Dec 30, 2011 10:28 am 
Post subject: Re: Recover lost database credentials

Can I vote for this to be approved and moved to the downloads section? Although it's a little scary that you can get the password like this, I find myself in this exact situation...taking over support of a universe that noone knows the connection password, and resetting the password is not an option for a variety of reasons.
_________________
Alan Junell BOCP-BOE
Back to top
RHuntley
Forum Member
Forum Member



Joined: 12 Aug 2011

Posts: 4



PostPosted: Fri Dec 30, 2011 10:50 am 
Post subject: Re: Recover lost database credentials

If you would be happy to test this for me, feel free to drop me an email (should be visible in my profile).
It works on XIR3 SP3 but I haven't had time to test on other platforms.

Regards,
Jason
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19353
Location: Bratislava


flag
PostPosted: Wed Jan 18, 2012 1:35 pm 
Post subject: Re: Recover lost database credentials

Moderator note:
Approved, and moved to BOB's Downloads.
Back to top
Atul Chowdhury
Forum Associate
Forum Associate



Joined: 07 Jul 2003

Posts: 828
Location: New Jersey



PostPosted: Wed Jan 18, 2012 3:59 pm 
Post subject: Re: Recover lost database credentials

Fascinating!!

Well done ...and thanks for sharing of course.

_________________
Atul Chowdhury @ Infolytik
http://www.infolytik.com
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19353
Location: Bratislava


flag
PostPosted: Wed Jan 18, 2012 4:10 pm 
Post subject: Re: Recover lost database credentials

Maybe just one note:
C:\temp folder must exist before running the utility. The utility will not create it. If you still run it and C:\temp does not exist, you will get an error message.
Back to top
Atul Chowdhury
Forum Associate
Forum Associate



Joined: 07 Jul 2003

Posts: 828
Location: New Jersey



PostPosted: Wed Jan 18, 2012 4:21 pm 
Post subject: Re: Recover lost database credentials

Hmm - I get a "Could not debug process" message.

Instructions were following as described in the worksheet.

It seems that this macro uses the windows debugger "ntds" that I don't think ships with Windows 7.

When I get to modUtils and it creates "szCommandLine" defined as ...

Code:
"ntsd -p 4776 -c ".dump -f c:\temp\designer.dmp ; q ""


...it stops.

Version: BOEXI3.1 SP3 FP3.2
Excel 2007, Macros Enabled
Windows 7 Professional 64 bit

I'll give it a go on an XP machine when I get a moment. ..

_________________
Atul Chowdhury @ Infolytik
http://www.infolytik.com
Back to top
RHuntley
Forum Member
Forum Member



Joined: 12 Aug 2011

Posts: 4



PostPosted: Thu Jan 19, 2012 3:22 pm 
Post subject: Re: Recover lost database credentials

Ah yes, it doesn't work with Windows 7 I'm afraid due to the lack of ntsd as you've noted.

If you want to get it running, you can always use Task Manager or Process Explorer to dump designer's memory and then load it that way.

You will have to alter my code to read the dump file instead of trying to create it. It's a bit rough and ready so please feed back any improvements.
Back to top
Sree Konduri
Principal Member
Principal Member



Joined: 14 Jul 2005

Posts: 266



PostPosted: Thu Apr 10, 2014 2:49 pm 
Post subject: Re: Recover lost database credentials

Thanks RHuntley for this nice tool.

on Windows 7 machine, I've created dump file manually and modified the code to read this file instead of creating the dump in the utility using VBA. It worked very well.

If anyone is interested in knowing how to run it on Windows 7 machine, below are the steps


    Launch Designer and Log into Designer using Administrator account
    Launch Task Manager and select Designer in Process tab and right click and select Create dump file.
    Open this Excel utility, and open the code under Sheet2 (instructions)
    comment the following code

    'If Not DumpMem(sFile, lProc) Then
    ' MsgBox "Could not debug process", vbExclamation, "Error"
    ' Exit Sub
    'End If


    add following line of code
    sFile = "<location of dump file>"

    Run the utility.
Back to top
mafta
Forum Member
Forum Member



Joined: 18 May 2011

Posts: 4



PostPosted: Wed Apr 30, 2014 5:04 am 
Post subject: Re: Recover lost database credentials

Hi,

Its fetching only 33 connections for me. Is there any limitation set in the code?

Regards
Masood
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6701
Location: Connecticut, USA


flag
PostPosted: Tue Aug 05, 2014 11:06 am 
Post subject: Re: Recover lost database credentials

As scary as it is that this is even possible, I have to say that it's saved my butt numerous times.
Back to top
sat.dpi
Principal Member
Principal Member



Joined: 12 Feb 2009

Posts: 129
Location: chennai


flag
PostPosted: Thu Mar 05, 2015 6:21 am 
Post subject: Re: Recover lost database credentials

Hi,

Do you have this utility for BI4.1?.

Thanks.
Back to top
mafta
Forum Member
Forum Member



Joined: 18 May 2011

Posts: 4



PostPosted: Tue Jun 09, 2015 10:42 am 
Post subject: Re: Recover lost database credentials

Can we use the same utility for BO4.0?
Do we need to add any library in the macro tpo get it work for BO 4.0?
Please suggest

Regards
Masood
Back to top
RensH
Principal Member
Principal Member



Joined: 18 Jun 2007
ASUG Icon
Posts: 147


flag
PostPosted: Wed Apr 06, 2016 7:27 am 
Post subject: Re: Recover lost database credentials

sat.dpi wrote:
Hi,

Do you have this utility for BI4.1?.

Thanks.


It does work for BI 4.1 (SP5), but as I am on Win7, look into the thread: it needs a bit of modification in the script .

Yes, it is kind of scary that it works, but :
- The danger is limited :
the thief of passwords needs :
access to your universes (1)
AND
Designer ( UDT ) on hir machine (2)
AND
cannot be trusted with the password(s) (3)
AND
find this tool (4)

OK, that last one is the easier part : start digging BOB DLD ...
But as (1)+(2) almost imply NOT (3) ... yes, you sometimes need to trust people too,
or they will quit and you have to train new universe designers.

_________________
Transitioning to : XI 4.2 (SP3)
(Mostly WebI docs using universes, no voyager etc -yet- but (very few) dashboards )
LDAP eDirectory , repository on oracle.


Phasing out : BI 4.1 SP5 . Mostly Webi.
Phased out : BO-XI 3.1 SP6 . Mostly Webi.
Phased out : BO651, full clients. No Webi.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT - 5 Hours
Goto page 1, 2  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.1023 seconds using 20 queries. (SQL 0.0073 Parse 0.0668 Other 0.0282)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo