Highlighted
Senior Member.
254 views

NA 10.10 embedded DB Access

Hi All,

I need to access my na 10.10 embedded database, how please help. 

Thanks,

 

Venkata Krishna

0 Likes
1 Reply
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: NA 10.10 embedded DB Access

Hi @venkata krishna1,

if NA 9.x and 10.11

go to /opt/mysql/bin and use mysql

like this example you define the password and DB name, in mine is NADB:

mysql -u root -p NADB -ptruecontrol -e "select * from RN_DIAGNOSTIC_DATA;" > /tmp/file.txt

 

or like this for normal access:

mysql -u root -p NADB -ptruecontrol

it has to be sticked to the -p option to work in one line.

and on NA 10.2 and up use

/opt/postgres/bin

./psql -U admin -d postgres

and your defined password.

also these are NNMi forums NA is here:

https://community.softwaregrp.com/t5/Network-Automation-User/bd-p/sws-NA_SUP

Pedro A. Batista
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the THUMB at the bottom left of the post and show your appreciation.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.