How to find SmartOffice database details?

 1 Replies
 0 Subscribed to this topic
 11 Subscribed to this forum
Sort:
Author
Messages
asdf_qwerty
New Member
Posts: 1
New Member
    Hi,

    Does anybody know how to find out the SmartOffice database details such as IP address, port, username etc?

    Thank you.
    Karin
    Veteran Member
    Posts: 57
    Veteran Member
      I don't know how to get the details but i know how to run the built in SQL console for H2.
      To be able to view the H2 console the web-xml must be manually edited. (Workspaces\GridServer\TestServer\applications\GDBC\webapps\h2console\WEB-INF)

      1. Uncomment the section that is about the console.
      2. Restart H2/GDBC. I'm not sure if you need to restart one of the apps or two
      3. Launch the Java Management pages for the grid. Select In the bottom page under the manage therer is a link to the management tool for GDBC. Select that and get to a page with two more links, the first link is for Drivers but it is the second link you want, "View Application configuration".

      Then you look for the LSO section and click the link H2 Web Console
        
      It is just a matter of finding that correct page in order to launch the link. Attached is the Managamenet page with the link to the H2 Console.

      I don't know if this is safe to do in production or not. I would check the Administration guide for the Grid extensions for more information.

      Regards
      Karin
      Regards Karin http://smartofficeblog.com