Can our DBA access the DB on the logger? - Micro Focus Community

james.skala · ‎2012-07-03

Our DBA is wondering if he is able to access the loggers db from a remote connection?

or@we-can.co.il1 · ‎2012-07-04

Hello,

You could do that but it is not simple.

One way is to use the Logger API to run searches and reports as described here:

Another way, might be difficult and complex, is to connect directly do the MySQL service on the Logger:

The last message in the post by Kevin describes what you need to do to allow access to the MySQL interface.

Someone from my team also did the same thing and it works.

Please feel free to contact me at any time.

+972-052-3279374

james.skala · ‎2012-07-05

Thanks for the info on the mysql remote.

As far as using the web service api, we cant get it working while using it within microsoft powershell. Any suggestion / guidence?

or@we-can.co.il1 · ‎2012-07-05

Hi,

We used C# or Java and it worked, so you should try that.

Please feel free to contact me at any time.

+972-052-3279374

A-Aron · ‎2012-07-09

Or you could try with PERL on windows as well. There are PERL samples on Protect724 of how to search and run reports on Logger.