UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21. Read more.
UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21.Read more.
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class
350 views

Hi all, I am very new to ESM. Can anybody help me, How can i access my esm server local database

Hi all,  I am very new to ESM. Can anybody help me, How can i access my esm server local database?

Labels (1)
0 Likes
6 Replies
Vice Admiral
Vice Admiral

Hello

What version of ArcSight ESM do you use? If your version is 5.x you may use standard Oracle SQL Developer. But it is very dangerous to explore DB, you can crash it without understanding it work!!!

Regards,

Alexander

0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Hi Alexander,


Arcsight Version 6.8c

arcsight version.png

0 Likes
Vice Admiral
Vice Admiral

6.x uses CORRE Database so I don't know developer tools for it. I use 5.x version.

Why do you want get local access to DB? Maybe standard scripts from ArcSight home path can help you. 

0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

6.8 use MySql

You need to modify the config of MySql to allow remote connection then use a software to explore MySql. I use DBForge Studio.  Like Alexander said, it is very dangerous to play with the DB if you dont know what you are doing.

------------------------------------
Please use the Like button below, if you find this post useful or mark it as an accepted solution if it resolves your issue.
0 Likes
Fleet Admiral Fleet Admiral
Fleet Admiral

as the arcsight user:

cd /opt/arcsight/logger/current/arcsight/bin

./mysql -uroot -p arcsight

0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

I got a document.

Thank you all for your reply.

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.