Welcome to Komo

Database Connection Setup

The first step in using Komo is to connect it to the PostgreSQL server, which may be on the same computer as Komo or on a remote computer connected via a network. You will need to enter a few items of information for Komo to set up the connection, and you will only need to do this once.

To enter the connection information, select DB Tools>Connection Settings from the menu. Enter the following information. Note that these entries are case-sensitive.

JDBC File

JDBC is the interface that allows Java programs such as Komo to connect to database programs such as PostgreSQL, and to make a connection Komo needs to know where this file is located. Each database program has its own JDBC file, and for PostgreSQL this file will probably look something like postgresql-8.1-404.jdbc3,jar (the Level 3 driver for PostgreSQL 8.1.2). If PostgreSQL is installed on the same computer as Komo, the file is probably in a /JDBC subdirectory of the PostgreSQL installation directory. If PostgreSQL is installed on a remote computer, a copy of the JDBC file will need to be placed in a convenient location on the Komo computer.

The JDBC Path may be entered by hand or, more simply, by clicking the Browse button and navigating to it.

Server Port

The default port is 5432. If PostgreSQL has been configured to use another port, the number can be entered here.

Server Address

The URL address to connect to PostgreSQL is entered here. If PostgreSQL is on the same computer as Komo, "localhost" is the default value. If PostgreSQL is installed on a remote computer, the network address of the remote computer is used (e.g., an address like 127.100.0.1).

Database Name

This is the actual name of the database being accessed. If a database other than the default one is being accessed, the name is changed here.

SSL Connection

If PostgreSQL has been compiled and configured for Secure Socket Layer, and if a Level 3 JDBC driver is used, connection to PostgreSQL can be made with the added security of SSL technology. This is only important in the case of a network installation.

User Name

Enter your user name. This is most included in the documentation that came with the program or, in the case of a network installation, may be obtained from the network administrator.

User Password

Enter your user password. As with the User Name, this may be in the program documentation or obtained from the network administrator.

Store Password locally

Check this box if you want the convenience of having your password stored on this computer. The benefits of doing this are that you won't have to enter the password each session and database connections will be made automatically. The potential harm is that this password could be accessed by someone else, presenting a security risk. Weigh these issues in deciding whether to store the password.