Security

Reply
seo
Occasional Contributor II
Posts: 11
Registered: ‎01-18-2015

How do I find my appuser password to connect CPPM local SQL DB?

Hi,

 

I'm testing remote connect to CPPM, I have admin account/password on CPPM, But I don't know appuser password to connect LOCAL SQL DB. (Just I can see in GUI, ●●●●●● )

 

How do I find my password? Is it possible to view plain-text in CPPM CLI?

 

To export known MAC-ADDRESS, I need to access CPPM tipsdb from remote LINUX box.

 

Thanks.

Guru Elite
Posts: 8,786
Registered: ‎09-08-2010

Re: How do I find my appuser password to connect CPPM local SQL DB?

You cannot use the appuser account. Try using the appexternal account. You can set the password under server configuration > cluster wide settings 


Thanks, 
Tim

Tim Cappalli | Aruba Security TME
@timcappalli | timcappalli.me | ACMX #367 / ACCX #480
seo
Occasional Contributor II
Posts: 11
Registered: ‎01-18-2015

Re: How do I find my appuser password to connect CPPM local SQL DB?

[ Edited ]

Hi cappalli, Thanks very much.

 

I found password menu and success to connect my cppm from remote linux box.

 

But..appexternal have not permission to read tips_endpoints database........

 

I need to export mac_address from tips_endpoints database.

 

Is it impossible from remote?

 

Guru Elite
Posts: 8,786
Registered: ‎09-08-2010

Re: How do I find my appuser password to connect CPPM local SQL DB?

[ Edited ]

You'll want to use the Export All option under Configuration > Identity > Endpoints in the GUI. You can then use an XML to CSV utility.

 

http://xmlgrid.net/xml2text.html

 

 

The tips_endpoints table does not contain all of the endpoint data.


Tim Cappalli | Aruba Security TME
@timcappalli | timcappalli.me | ACMX #367 / ACCX #480
seo
Occasional Contributor II
Posts: 11
Registered: ‎01-18-2015

Re: How do I find my appuser password to connect CPPM local SQL DB?

Hi cappalli, Thanks very much!

 

But I need to export in automated shell in LINUX box, I need to studying GUI menu from shell with curl or wget. :)

 

And I found 'mac' field in tips_endpoint_profiles which is read from appexternal account.

 

What's this field?

I want to sync allowed MAC address across heterogeneous infra structure. If that 'mac' field is someting allowed MAC address in my main network, It's Ok to my mission.

 

Very thanks.

Guru Elite
Posts: 8,786
Registered: ‎09-08-2010

Re: How do I find my appuser password to connect CPPM local SQL DB?

Take a look at page 18 in the attached API guide.

 


Tim Cappalli | Aruba Security TME
@timcappalli | timcappalli.me | ACMX #367 / ACCX #480
seo
Occasional Contributor II
Posts: 11
Registered: ‎01-18-2015

Re: How do I find my appuser password to connect CPPM local SQL DB?

Thanks very much!

 

Success to export my HQ mac address!

Search Airheads
Showing results for 
Search instead for 
Did you mean: