DynamoBIAdminUI

About

AdminUI v1.0

The AdminUI is a graphical front-end for any web browser to LucidDB which makes database administrating simpler and does not require a great knowledge of SQL. Even SQL pros can benefit from the AdminUI and speed up a variety of tasks normally done from a command line.

For full feature details, see the DynamoBIAdminUI_Features.

Prerequisites

If you have not downloaded a copy of LucidDB, please see the instructions for that at the LucidDB Installation Page. An instance of the LucidDB Server must be running in order to connect with the AdminUI.

In order to use the AdminUI, you must have a web browser with a recent version of Flash Player installed and a recent version of the Java Runtime Environment installed on your operating system.

Downloading

Go download [our latest stable build] of Dynamo AdminUI and related services. To keep up with the latest development builds, you may instead choose to download the zip from our http://build.dynamobi.com/job/dynamo_services/ location. The link to the development builds currently is down.

Extracting and Running

Once the zip file has downloaded, extract the dynamodb-services directory to a location of your choice. If you are on Windows, you may be able to double-click the file bin\startup.bat to start the program, otherwise launch cmd.exe and navigate to the extraction directory to run the batch file. If you are running Linux or Mac, you will have to use the command window to navigate to the extraction directory, navigate to the bin directory inside, make the .sh files inside have executable privileges, and execute bin/startup.sh. For example, if you extracted to /home/me/dynamodb-services, you would run these commands:

{code:xml} $ cd /home/me/dynamodb-services $ for x in `find . -name '*.sh'`; do chmod +x $x; done $ ./start-dynamoservices.sh {code}

Control of the terminal should be returned, and the AdminUI should now be accessible from your web browser. Please allow up to a minute for the services to load. Once everything is ready, navigate to http://localhost:8077 and after a redirect you should be greeted with this page:

If you have a LucidDB server running on your localhost as well, you may now login. The default username is sa with an empty password. If you have successfully logged in, you should see the list of available schemas in the left navigation menu populate.

!adminui_loggedin.png!

You can now see what sorts of things you can do with the AdminUI at the AdminUI Features Page.

Alternate Configurations

What if LucidDB's port isn't the standard 8034?

For all of these questions, each of these options are determined by a single configuration file. The web services read a file found in dynamodb-services/webapps/adminws/WEB-INF/classes called luciddb-jdbc-default.properties. You can simply edit this file directly, though the suggested alternative is to create a file called luciddb-jdbc.properties in the same directory with the same options. The services will favor this new file.

First, to change "sa"'s default password (you can run this in SqlLine or in the AdminUI's query window):

{code:sql} create or replace user "sa" identified by 'newpassword'; {code}

Now edit the luciddb-jdbc.properties file.

{code:xml} jdbc.driver=org.luciddb.jdbc.LucidDbClientDriver (1) jdbc.url=jdbc:luciddb:http://localhost (2) jdbc.username=sa (3) jdbc.password= (4) {code}

1. Leave this alone.
2. This is where you change the location of your LucidDB server. If it's on a different port, simply append ':XXXX' to the URL string as normal.
3. Unless your root user has changed, this should remain "sa".
4. Enter your password.

What if I want a different port than 8077 for the web service?

Simply edit the configuration file dynamodb-services/conf/server.xml and search for 8077 and replace it with your new value. Restart using the shutdown.sh and startup.sh scripts in the bin directory.