Connecting to Your Database with lmcfg.txt

The lmcfg.txt file defines the database type, name and authentication information that ListManager will use when connecting to your database. The installer will insert the values you choose as part of the installation process. To change the SQL server, database, user or password, use a plain text editor to edit the lmcfg.txt file.

Each variable is given a "$name", followed by an equals sign (=) and the value, in quotation marks. A semicolon (;) should be at the end of each line. All lines which begin with a hash (#) are commented out, and not read when connecting to the database.

$node_name

The $node_name variable specifies the machine name of this ListManager instance. If you are running ListManager in a clustered configuration, each node must have a distinct node name. This name is usually the machine's hostname.

Do not edit or change the node name! If you do so, ListManager will create a new node in the database with no configuration information. ListManager will not function properly until the node is removed. See Database Operations for more information about the renamenode function.

$sql_type

The $sql_type variable defines which database driver ListManager should use. Valid values for $sql_type are:

"MSSQL" - Native Microsoft SQL Server. Microsoft SQL Server version 7 and 2000 (8) have been tested by Lyris Technologies.

"Oracle" - Native Oracle OCI driver. Versions 8i and greater should work with ListManager.

"Postgres" - Native PosgreSQL driver. Version 7.1 has been tested with ListManager. Versions earlier than 7.1 will not function. Example:

$sql_type="MSSQL";

$sql_server

The $sql_server value is the host name of the machine running the your SQL server software. This value should be blank if the database is local for Postgres, MSDE, or Microsoft SQL Server. Example:

$sql_server="mysqlserver.example.com";

$sql_user

 The $sql_user value is the login name of the user to log in as. This user must have full permissions to create/delete/modify values in this database. May be blank if using MSSQL and integrated security. Example:

$sql_user="lyris";

$sql_password

The $sql_password value is the login password of the user to log in as. May be blank if using MSSQL and integrated security. Example:

$sql_password="lyrissqlpassword";

 $sql_database

The $sql_database value is the name of the database ListManager should use. This value is ignored by Oracle. Example:

$sql_database="listmanager";

$sql_pool

The $sql_pool value is the maximum size of the connection pool that ListManager will keep. This allows ListManager to recycle connections rather than creating a new connection for every command. Example:

$sql_pool="25";

With the exception of the MSDE server which is optimized for 8 connections, a setting of 25 will give good performance for most database connections. By default, the $sql_pool value is set to 8 for MSDE installations and 25 for all other installations. The minimum number of database connections typically in use by ListManager is 15. Even if you set a number lower than this, ListManager will set to 15 (8 for MSDE).

Specifying lmcfg.txt on Startup

You can specify a different lmcfg.txt file by adding a command-line argument. This option allows programmers to have different icons on the desktop for different lmcfg.txt files.

You can use an alternate configuration file using the cfgfile command-line option. The file to load is specified after the "cfgfile" command-line argument. For example:

lm.exe start cfgfile mycfg.txt

The cfgfile arg can appear anywhere in the command line.